cheking dropdownlist first value is blank then it will pass 0 value othervise dropdwnlist id

int grant_internal_status_id = GrantRequest.GetGrant_Internal_Status(grantId, userRole);
             
 ddlInternalStatus.SelectedValue = grant_internal_status_id == 0 ? "" : Convert.ToString(grant_internal_status_id.ToString());
             
 bool bRent = GrantRequest.UpdateGrant_Internal_Status(userId, grantId, userRole, ddlInternalStatus.SelectedItem.Value == "" ? 0 : Convert.ToInt32(ddlInternalStatus.SelectedItem.Value));

How to configure encryption decryption into database using assembly file

CREATE ASSEMBLY [SqlServerProject_Encryption]
AUTHORIZATION [dbo]
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300A8894A490000000000000000E0000E210B010800002000000020000000000000AE3500000020000000400000000040000020000000100000040000000000000004000000000000000080000000100000000000000300400500001000001000000000100000100000000000001000000000000000000000005C3500004F00000000400000C803000000000000000000000000000000000000006000000C00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E74657874000000B4150000002000000020000000100000000000000000000000000000200000602E72737263000000C8030000004000000010000000300000000000000000000000000000400000402E72656C6F6300000C000000006000000010000000400000000000000000000000000000400000420000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009035000000000000480000000200050090250000CC0F000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E02280D00000A2A133001003400000001000011020A06450400000002000000080000000E000000140000002B18730E00000A2A730F00000A2A731000000A2A731100000A2A142A133001003E00000002000011020A06450500000002000000080000000E000000140000001A0000002B1E731200000A2A731300000A2A731400000A2A731500000A2A731600000A2A142A00001B300400BF000000030000110228020000060B0328030000060C076F1700000A1E5B0D05097201000070281800000A6F1900000A1003281A00000A056F1B00000A1304281A00000A72050000706F1B00000A1305281A00000A046F1B00000A13060811066F1C00000A13071106280C00000613081107280C0000061309281A00000A110872270000701109281D00000A6F1B00000A130A07110411056F1E00000A130B110B110A16110A8E696F1F00000A130C110C280C0000060ADE0C26722B000070732000000A7A062A000110000000000E00A3B1000C010000011B3004000E010000040000110228020000060B0328030000060C076F1700000A1E5B13040511047201000070281800000A6F1900000A1003281A00000A056F1B00000A1305281A00000A72050000706F1B00000A1306041203280F000006130707110511066F2100000A1308110811071611078E696F1F00000A1309281A00000A11096F2200000A178D20000001130E110E167227000070281800000A9D110E6F2300000A130A110A8E69182E06732400000A7A110A169A1203280F000006130B110A179A1203280F000006130C08110B6F1C00000A130D281A00000A110C6F2200000A281A00000A110D6F2200000A282500000A2C06732400000A7A281A00000A110B6F2200000A0ADE0C26727D000070732000000A7A062A00000110000000000E00F200010C010000013E181602032804000006282700000A2A1B30040043000000050000110272AF000070282800000A2C0902282700000A0ADE2B022D0902282700000A0ADE1F181602032805000006282700000A0ADE0E2672AF000070282700000A0ADE00062A0001100000000000003333000E1F0000011E02280D00000A2A133002001500000006000011732900000A0A06026F2200000A0B07282700000A2A1E02280D00000A2A1E02280D00000A2A000000133003002E0000000700001172AF0000700A160B2B1C0602078F2300000172B1000070282A00000A282B00000A0A0717580B07028E6932DE062A0000133003003A000000080000111F41282C00000A0A1F30282C00000A0B02282D00000A100002282C00000A0C0806320808061C582F02172A0807320908071F0A582F02172A162AA6026F2E00000A183009026F2E00000A16300B72B7000070732F00000A7A022003020000283000000A2A13300500C60000000900001103165472AF0000700A160B2B2902076F3200000A0C08280D0000062C0F06088C20000001283300000A0A2B0603254A1758540717580B07026F2E00000A32CE066F2E00000A185D2C1603254A1758540616066F2E00000A17596F3400000A0A066F2E00000A185B0D098D2300000113041613051613062B43188D2000000113081108160611056F3200000A9D11081706110517586F3200000A9D1108733500000A1307110411061107280E0000069C110518581305110617581306110611048E6932B511042A0000133002002B0000000A000011170A020B160C2B1807086F3200000A0D09280D0000062D04160A2B0D0817580C08076F2E00000A32DF062A0013300200340000000B000011160A160B2B1802076F3200000A0C08280D0000062C040617580A0717580B07026F2E00000A32DF06185D2C040617590A06185B2A42534A4201000100000000000C00000076322E302E35303732370000000005006C0000007C050000237E0000E8050000BC06000023537472696E677300000000A40C00000801000023555300AC0D0000100000002347554944000000BC0D00001002000023426C6F620000000000000002000001571D02000902000000FA0133001600000100000026000000070000000C0000001100000016000000350000000A0000000D0000000B00000001000000020000000200000000000A000100000000000600A900A2000600B000A2000600DB00BE0006000801BE000A00A4018F0106002402120206005C023D020600700212020600890212020600A40212020600BF0212020600D80212020600F102120206001003120206002D0312020600640344030600840344030600C503BE000600DE03BE000600F703BE0006000704BE0006002F04BE0006004804BE0006006204BE0006007004BE0006007E04BE000600B604A2000600C504A2000600E104D50406001005BE0006004505A20006007905A2000A00AD05920506000A06D50406002406A20006005A06A200060081066C0606009B063D020000000001000000000001000100010010002A003B000500010001000201000059000000090002000600020100006A0000000900070006000100100075003B0005000D000600010010007500000005000D000900000010008A003B0005000D000B005180B5000A00060642014A0056804A014D0056804E014D00568052014D0056805B014D00060642014A0056806501650056806901650056806E01650056807501650056807C0165005020000000008618B8002E0001005820000000009100EE00320001009820000000009100160139000200E4200000000096002A0140000300C021000000009600360140000700EC22000000009600AE016E000B00FC22000000009600B2016E000D005C23000000008618B8002E000F006423000000009600B60175000F008523000000008618B8002E0010008D23000000008118B8002E0010009823000000009300BD017C001000D423000000009100CF01820011001A24000000009100DA01870012004424000000009300E7018C0013001825000000009100F90194001500502500000000910006029900160000000100BE03000001002604000001005900000002006A00000003008C04000004009C04000001005900000002006A00000003004F05000004009C0400000100C20500000200D00500000100EA0500000200D0050000010004060000010018060000010032060000010049060000010049060200020094060000010049060000010049063100B8009E003900B800A3004100B8009E004900B8009E005100B8009E005900B8009E006100B8009E006900B8009E007100B8009E007900B8009E008100B800A8008900B8002E000900B8002E009100B8002E009900B8002E00A100B8002E00A900B8002E00B100B8002E00B900B8002E00C100B8002E00C900B8002E00D100B8002E001900AA04B700D900BE04BB00E100CC04C000E900EA04C600E900F404CB002100FD04D100E1000905D80019002105DF00F1003105E800F900B8009E0019005F05DF00E9006F050A01E1007E051001F900B8002E00E100840517010901B8002E002900DE053B01E100F80517011101B8002E00190129064D01E10009055201D90039065D01010141066201E1004F06B7002101B8009E0019018E066D013101B8002E00E100A8067501E10009057A01E100B2068001E100B80086010E0004000D0008000C005100080010005600080014005B00080018006000080020005100080024005600080028005B0008002C0060000800300069002E003300C5012E006300EF012E001300A7012E002300A7012E002B00AD012E003B00A7012E004300A7012E004B00A7012E005300C5012E005B00E601C00033015600E00033015600200133015600AD00B200F1001D0141014601580167018C019A01A1010480000001000000CA0C6C58000000000000A20300000200000000000000000000000100990000000000020000000000000000000000010083010000000003000200040002000000003C4D6F64756C653E0053716C53657276657250726F6A6563745F456E6372797074696F6E2E646C6C00456E6372797074696F6E48656C7065720050617261676F6E2E53656375726974792E43727970746F67726170687900456E6372797074696F6E4D6574686F6400486173684D6574686F640055736572446566696E656446756E6374696F6E7300456E63727970746F725574696C73006D73636F726C69620053797374656D004F626A65637400456E756D004956002E63746F720053797374656D2E53656375726974792E43727970746F6772617068790053796D6D6574726963416C676F726974686D00456E6372797074696F6E5365727669636550726F76696465720048617368416C676F726974686D00486173685365727669636550726F766964657200456E6372797074446174610044656372797074446174610076616C75655F5F00446573005263320052696A6E6461656C00547269706C65446573004D443500534841310053484132353600534841333834005348413531320053797374656D2E446174610053797374656D2E446174612E53716C54797065730053716C537472696E6700656E630064656300746F4368617200627974654172726179546F537472696E670063686172546F426F6F6C00737472696E67546F4279746500737472696E67546F42797465417272617900737472696E67546F426F6F6C00737472696E67546F496E740053797374656D2E5265666C656374696F6E00417373656D626C7956657273696F6E4174747269627574650053797374656D2E52756E74696D652E496E7465726F70536572766963657300436F6D56697369626C6541747472696275746500417373656D626C7943756C7475726541747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C795469746C654174747269627574650053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C6974794174747269627574650053716C53657276657250726F6A6563745F456E6372797074696F6E004D6574686F640044455343727970746F5365727669636550726F76696465720052433243727970746F5365727669636550726F76696465720052696A6E6461656C4D616E6167656400547269706C6544455343727970746F5365727669636550726F766964657200486173684D6F6465004D443543727970746F5365727669636550726F7669646572005348413143727970746F5365727669636550726F7669646572005348413338344D616E61676564005348413235364D616E61676564005348413531324D616E6167656400737472696E67546F456E637279707400456E6372797074696F6E4B6579006765745F4B657953697A6500436F6E7665727400546F4368617200537472696E670050616452696768740053797374656D2E5465787400456E636F64696E67006765745F415343494900476574427974657300436F6D707574654861736800436F6E636174004943727970746F5472616E73666F726D00437265617465456E63727970746F72005472616E73666F726D46696E616C426C6F636B00457863657074696F6E00737472696E67546F4465637279707400437265617465446563727970746F7200476574537472696E6700436861720053706C6974006F705F496E657175616C697479004D6963726F736F66742E53716C5365727665722E5365727665720053716C46756E6374696F6E4174747269627574650064617461546F456E637279707400656E6372797074696F6E4B6579006F705F496D706C696369740064617461546F44656372797074006F705F457175616C6974790076616C7565004153434949456E636F64696E6700627974654172726179496E004279746500546F537472696E670063686172496E00546F496E74333200546F557070657200737472496E006765745F4C656E67746800417267756D656E74457863657074696F6E0053797374656D2E476C6F62616C697A6174696F6E004E756D6265725374796C65730050617273650072657456616C004F7574417474726962757465006765745F436861727300537562737472696E6700000330000021470065006E0065006E0074006500630068002D0049006E00690056006500630001032E00005155006E006B006E006F0077006E0020006500720072006F007200200065006E0063006F0075006E0074006500720065006400200069006E00200065006E006300720079007000740069006F006E002E000031440065006300720079007000740069006F006E00200075006E007300750063006300650073007300660075006C002E000001000558003200004F68006500780020006D007500730074002000620065002000310020006F0072002000320020006300680061007200610063007400650072007300200069006E0020006C0065006E0067007400680000002652FD38D70EBE4B9E656F0AC9CD2BE40008B77A5C561934E08902060E20470065006E0065006E0074006500630068002D0049006E00690056006500630003200001060001120D110C060001121111100900040E110C11100E0E0206080306110C040000000004010000000402000000040300000003061110040400000006000211150E0E06000111151D050500010E1D050400010203040001050E0700021D050E1008040001020E040001080E042001010E04200101020420010108040701110C040701111003200008040001030E0520020E080304000012750520011D050E0620011D051D050600030E0E0E0E08200212791D051D050820031D051D05080818070D0E120D1211081D051D051D051D050E0E1D0512791D050520010E1D050620011D0E1D03050002020E0E1D070F0E120D121108081D051D051D0512791D051D0E1D051D051D051D0305000111150E04070111150607021280890E0420010E0E0500020E0E0E0407020E0804000108030400010303050703080808070002050E11809504200103080500020E1C1C0520020E0808052001011D030D07090E0803081D0508080E1D03060704020E080305070308080305010000000017010012436F7079726967687420C2A920203230303800002001001B53716C53657276657250726F6A6563745F456E6372797074696F6E00000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F77730100008435000000000000000000009E35000000200000000000000000000000000000000000000000000090350000000000000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF2500204000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058400000700300000000000000000000700334000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001006C58CA0C000001006C58CA0C3F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B004D0020000010053007400720069006E006700460069006C00650049006E0066006F000000AC020000010030003000300030003000340062003000000060001C000100460069006C0065004400650073006300720069007000740069006F006E0000000000530071006C00530065007200760065007200500072006F006A006500630074005F0045006E006300720079007000740069006F006E00000040000F000100460069006C006500560065007200730069006F006E000000000031002E0030002E0033003200370034002E00320032003600330036000000000060002000010049006E007400650072006E0061006C004E0061006D0065000000530071006C00530065007200760065007200500072006F006A006500630074005F0045006E006300720079007000740069006F006E002E0064006C006C0000004800120001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90020002000320030003000380000006800200001004F0072006900670069006E0061006C00460069006C0065006E0061006D0065000000530071006C00530065007200760065007200500072006F006A006500630074005F0045006E006300720079007000740069006F006E002E0064006C006C00000058001C000100500072006F0064007500630074004E0061006D00650000000000530071006C00530065007200760065007200500072006F006A006500630074005F0045006E006300720079007000740069006F006E00000044000F000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0033003200370034002E00320032003600330036000000000048000F00010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0033003200370034002E0032003200360033003600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000C000000B035000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET = SAFE

GO
ALTER ASSEMBLY [SqlServerProject_Encryption]
ADD FILE FROM 0x7573696E672053797374656D3B0D0A7573696E672053797374656D2E53656375726974792E43727970746F6772617068793B0D0A7573696E672053797374656D2E494F3B0D0A7573696E672053797374656D2E546578743B0D0A0D0A6E616D6573706163652050617261676F6E2E53656375726974792E43727970746F6772617068790D0A7B0D0A202020202F2F2F203C73756D6D6172793E0D0A202020202F2F2F2053756D6D617279206465736372697074696F6E20666F7220456E6372797074696F6E48656C7065722E0D0A202020202F2F2F203C2F73756D6D6172793E0D0A202020207075626C696320636C61737320456E6372797074696F6E48656C7065720D0A202020207B0D0A20202020202020202F2F2A2A2A2031362D63686172616374657220496E697469616C697A6174696F6E20566563746F720D0A20202020202020202F2F7072697661746520636F6E737420737472696E67204956203D202231323334353637383930313233343536223B0D0A20202020202020207072697661746520636F6E737420737472696E67204956203D202247656E656E746563682D496E69566563223B0D0A0D0A20202020202020207075626C696320656E756D20456E6372797074696F6E4D6574686F64203A20696E740D0A20202020202020207B0D0A202020202020202020202020446573203D20302C0D0A202020202020202020202020526332203D20312C0D0A20202020202020202020202052696A6E6461656C203D20322C0D0A202020202020202020202020547269706C65446573203D20332C0D0A20202020202020207D0D0A0D0A20202020202020207075626C696320656E756D20486173684D6574686F64203A20696E740D0A20202020202020207B0D0A2020202020202020202020204D4435203D20302C0D0A20202020202020202020202053484131203D20312C0D0A202020202020202020202020534841323536203D20322C0D0A202020202020202020202020534841333834203D20332C0D0A202020202020202020202020534841353132203D20340D0A20202020202020207D0D0A0D0A20202020202020207075626C696320456E6372797074696F6E48656C70657228290D0A20202020202020207B0D0A2020202020202020202020202F2F0D0A2020202020202020202020202F2F20544F444F3A2041646420636F6E7374727563746F72206C6F67696320686572650D0A2020202020202020202020202F2F0D0A20202020202020207D0D0A0D0A202020202020202070726976617465207374617469632053796D6D6574726963416C676F726974686D20456E6372797074696F6E5365727669636550726F766964657228456E6372797074696F6E4D6574686F64204D6574686F64290D0A20202020202020207B0D0A20202020202020202020202073776974636820284D6574686F64290D0A2020202020202020202020207B0D0A202020202020202020202020202020206361736520456E6372797074696F6E4D6574686F642E4465733A0D0A202020202020202020202020202020202020202072657475726E206E65772044455343727970746F5365727669636550726F766964657228293B0D0A0D0A202020202020202020202020202020206361736520456E6372797074696F6E4D6574686F642E5263323A0D0A202020202020202020202020202020202020202072657475726E206E65772052433243727970746F5365727669636550726F766964657228293B0D0A0D0A202020202020202020202020202020206361736520456E6372797074696F6E4D6574686F642E52696A6E6461656C3A0D0A202020202020202020202020202020202020202072657475726E206E65772052696A6E6461656C4D616E6167656428293B0D0A0D0A202020202020202020202020202020206361736520456E6372797074696F6E4D6574686F642E547269706C654465733A0D0A202020202020202020202020202020202020202072657475726E206E657720547269706C6544455343727970746F5365727669636550726F766964657228293B0D0A0D0A2020202020202020202020202020202064656661756C743A0D0A202020202020202020202020202020202020202072657475726E206E756C6C3B0D0A2020202020202020202020207D0D0A20202020202020207D0D0A0D0A202020202020202070726976617465207374617469632048617368416C676F726974686D20486173685365727669636550726F766964657228486173684D6574686F6420486173684D6F6465290D0A20202020202020207B0D0A2020202020202020202020207377697463682028486173684D6F6465290D0A2020202020202020202020207B0D0A202020202020202020202020202020206361736520486173684D6574686F642E4D44353A0D0A202020202020202020202020202020202020202072657475726E206E6577204D443543727970746F5365727669636550726F766964657228293B0D0A0D0A202020202020202020202020202020206361736520486173684D6574686F642E534841313A0D0A202020202020202020202020202020202020202072657475726E206E6577205348413143727970746F5365727669636550726F766964657228293B0D0A0D0A202020202020202020202020202020206361736520486173684D6574686F642E5348413235363A0D0A202020202020202020202020202020202020202072657475726E206E6577205348413338344D616E6167656428293B0D0A0D0A202020202020202020202020202020206361736520486173684D6574686F642E5348413338343A0D0A202020202020202020202020202020202020202072657475726E206E6577205348413235364D616E6167656428293B0D0A0D0A202020202020202020202020202020206361736520486173684D6574686F642E5348413531323A0D0A202020202020202020202020202020202020202072657475726E206E6577205348413531324D616E6167656428293B0D0A0D0A2020202020202020202020202020202064656661756C743A0D0A202020202020202020202020202020202020202072657475726E206E756C6C3B0D0A2020202020202020202020207D0D0A20202020202020207D0D0A0D0A20202020202020207075626C69632073746174696320737472696E6720456E63727970744461746128456E6372797074696F6E4D6574686F6420456E6372797074696F6E4D6574686F642C20486173684D6574686F6420486173684D6574686F642C20737472696E6720737472696E67546F456E63727970742C20737472696E6720456E6372797074696F6E4B6579290D0A20202020202020207B0D0A202020202020202020202020737472696E672074657874333B0D0A0D0A20202020202020202020202053796D6D6574726963416C676F726974686D20616C676F726974686D31203D20456E6372797074696F6E5365727669636550726F766964657228456E6372797074696F6E4D6574686F64293B0D0A20202020202020202020202048617368416C676F726974686D20616C676F726974686D32203D20486173685365727669636550726F766964657228486173684D6574686F64293B0D0A0D0A2020202020202020202020207472790D0A2020202020202020202020207B0D0A20202020202020202020202020202020696E7420626C6F636B73697A65203D20616C676F726974686D312E4B657953697A65202F20383B0D0A0D0A20202020202020202020202020202020456E6372797074696F6E4B6579203D20456E6372797074696F6E4B65792E506164526967687428626C6F636B73697A652C20436F6E766572742E546F436861722822302229293B0D0A0D0A20202020202020202020202020202020627974655B5D206B6579203D20456E636F64696E672E41534349492E476574427974657328456E6372797074696F6E4B6579293B0D0A20202020202020202020202020202020627974655B5D20696E6974566563746F72203D20456E636F64696E672E41534349492E4765744279746573284956293B0D0A20202020202020202020202020202020627974655B5D2062756666657233203D20456E636F64696E672E41534349492E476574427974657328737472696E67546F456E6372797074293B0D0A20202020202020202020202020202020627974655B5D2062756666657234203D20616C676F726974686D322E436F6D70757465486173682862756666657233293B0D0A0D0A20202020202020202020202020202020737472696E67207465787431203D20456E63727970746F725574696C732E627974654172726179546F537472696E672862756666657233293B0D0A20202020202020202020202020202020737472696E67207465787432203D20456E63727970746F725574696C732E627974654172726179546F537472696E672862756666657234293B0D0A0D0A20202020202020202020202020202020627974655B5D2062756666657235203D20456E636F64696E672E41534349492E4765744279746573287465787431202B20222E22202B207465787432293B0D0A0D0A202020202020202020202020202020204943727970746F5472616E73666F726D207472616E73666F726D31203D20616C676F726974686D312E437265617465456E63727970746F72286B65792C20696E6974566563746F72293B0D0A0D0A20202020202020202020202020202020627974655B5D2062756666657236203D207472616E73666F726D312E5472616E73666F726D46696E616C426C6F636B28627566666572352C20302C20627566666572352E4C656E677468293B0D0A202020202020202020202020202020207465787433203D20456E63727970746F725574696C732E627974654172726179546F537472696E672862756666657236293B0D0A2020202020202020202020207D0D0A20202020202020202020202063617463680D0A2020202020202020202020207B0D0A202020202020202020202020202020207468726F77206E657720457863657074696F6E2822556E6B6E6F776E206572726F7220656E636F756E746572656420696E20656E6372797074696F6E2E22293B0D0A2020202020202020202020207D0D0A0D0A20202020202020202020202072657475726E2074657874333B0D0A20202020202020207D0D0A0D0A20202020202020207075626C69632073746174696320737472696E6720446563727970744461746128456E6372797074696F6E4D6574686F6420456E6372797074696F6E4D6574686F642C20486173684D6574686F6420486173684D6574686F642C20737472696E6720737472696E67546F446563727970742C20737472696E6720456E6372797074696F6E4B6579290D0A20202020202020207B0D0A202020202020202020202020737472696E672074657874313B0D0A20202020202020202020202053796D6D6574726963416C676F726974686D20616C676F726974686D31203D20456E6372797074696F6E5365727669636550726F766964657228456E6372797074696F6E4D6574686F64293B0D0A20202020202020202020202048617368416C676F726974686D20616C676F726974686D32203D20486173685365727669636550726F766964657228486173684D6574686F64293B0D0A0D0A2020202020202020202020207472790D0A2020202020202020202020207B0D0A20202020202020202020202020202020696E74206E756D313B0D0A20202020202020202020202020202020696E7420626C6F636B73697A65203D20616C676F726974686D312E4B657953697A65202F20383B0D0A0D0A20202020202020202020202020202020456E6372797074696F6E4B6579203D20456E6372797074696F6E4B65792E506164526967687428626C6F636B73697A652C20436F6E766572742E546F436861722822302229293B0D0A0D0A20202020202020202020202020202020627974655B5D206B6579203D20456E636F64696E672E41534349492E476574427974657328456E6372797074696F6E4B6579293B0D0A20202020202020202020202020202020627974655B5D20696E6974566563746F72203D20456E636F64696E672E41534349492E4765744279746573284956293B0D0A20202020202020202020202020202020627974655B5D2062756666657233203D20456E63727970746F725574696C732E737472696E67546F42797465417272617928737472696E67546F446563727970742C206F7574206E756D31293B0D0A0D0A202020202020202020202020202020204943727970746F5472616E73666F726D207472616E73666F726D31203D20616C676F726974686D312E437265617465446563727970746F72286B65792C20696E6974566563746F72293B0D0A20202020202020202020202020202020627974655B5D2062756666657234203D207472616E73666F726D312E5472616E73666F726D46696E616C426C6F636B28627566666572332C20302C20627566666572332E4C656E677468293B0D0A20202020202020202020202020202020737472696E675B5D2074657874417272617931203D20456E636F64696E672E41534349492E476574537472696E672862756666657234292E53706C6974286E657720636861725B5D207B20436F6E766572742E546F4368617228222E2229207D293B0D0A0D0A2020202020202020202020202020202069662028746578744172726179312E4C656E67746820213D2032290D0A202020202020202020202020202020207B0D0A20202020202020202020202020202020202020207468726F77206E657720457863657074696F6E28293B0D0A202020202020202020202020202020207D0D0A0D0A20202020202020202020202020202020627974655B5D2062756666657235203D20456E63727970746F725574696C732E737472696E67546F42797465417272617928746578744172726179315B305D2C206F7574206E756D31293B0D0A20202020202020202020202020202020627974655B5D2062756666657236203D20456E63727970746F725574696C732E737472696E67546F42797465417272617928746578744172726179315B315D2C206F7574206E756D31293B0D0A20202020202020202020202020202020627974655B5D2062756666657237203D20616C676F726974686D322E436F6D70757465486173682862756666657235293B0D0A0D0A2020202020202020202020202020202069662028456E636F64696E672E41534349492E476574537472696E6728627566666572362920213D20456E636F64696E672E41534349492E476574537472696E67286275666665723729290D0A202020202020202020202020202020207B0D0A20202020202020202020202020202020202020207468726F77206E657720457863657074696F6E28293B0D0A202020202020202020202020202020207D0D0A0D0A202020202020202020202020202020207465787431203D20456E636F64696E672E41534349492E476574537472696E672862756666657235293B0D0A2020202020202020202020207D0D0A20202020202020202020202063617463680D0A2020202020202020202020207B0D0A202020202020202020202020202020207468726F77206E657720457863657074696F6E282244656372797074696F6E20756E7375636365737366756C2E22293B0D0A2020202020202020202020207D0D0A0D0A20202020202020202020202072657475726E2074657874313B0D0A20202020202020207D0D0A202020207D0D0A7D0D0A
AS N'Classes\EncryptionHelper.cs'

GO
ALTER ASSEMBLY [SqlServerProject_Encryption]
ADD FILE FROM 0x7573696E672053797374656D3B0D0A7573696E672053797374656D2E476C6F62616C697A6174696F6E3B0D0A0D0A6E616D6573706163652050617261676F6E2E53656375726974792E43727970746F6772617068790D0A7B0D0A202020202F2F2F203C73756D6D6172793E0D0A202020202F2F2F2053756D6D617279206465736372697074696F6E20666F7220456E63727970746F725574696C732E0D0A202020202F2F2F203C2F73756D6D6172793E0D0A20202020696E7465726E616C20636C61737320456E63727970746F725574696C730D0A202020207B0D0A20202020202020207072697661746520456E63727970746F725574696C7328290D0A20202020202020207B0D0A20202020202020207D0D0A0D0A2020202020202020696E7465726E616C2073746174696320737472696E6720627974654172726179546F537472696E6728627974655B5D20627974654172726179496E290D0A20202020202020207B0D0A202020202020202020202020737472696E67207374724F7574203D2022223B0D0A0D0A202020202020202020202020666F722028696E742069203D20303B2069203C20627974654172726179496E2E4C656E6774683B20692B2B290D0A2020202020202020202020207B0D0A202020202020202020202020202020207374724F7574203D207374724F7574202B20627974654172726179496E5B695D2E546F537472696E672822583222293B0D0A2020202020202020202020207D0D0A0D0A20202020202020202020202072657475726E207374724F75743B0D0A20202020202020207D0D0A0D0A2020202020202020707269766174652073746174696320626F6F6C2063686172546F426F6F6C28636861722063686172496E290D0A20202020202020207B0D0A202020202020202020202020696E74206E756D32203D20436F6E766572742E546F496E74333228274127293B0D0A202020202020202020202020696E74206E756D33203D20436F6E766572742E546F496E74333228273027293B0D0A0D0A20202020202020202020202063686172496E203D20636861722E546F55707065722863686172496E293B0D0A202020202020202020202020696E74206E756D31203D20436F6E766572742E546F496E7433322863686172496E293B0D0A0D0A20202020202020202020202069662028286E756D31203E3D206E756D322920262620286E756D31203C20286E756D32202B20362929290D0A2020202020202020202020207B0D0A2020202020202020202020202020202072657475726E20747275653B0D0A2020202020202020202020207D0D0A0D0A20202020202020202020202069662028286E756D31203E3D206E756D332920262620286E756D31203C20286E756D33202B2031302929290D0A2020202020202020202020207B0D0A2020202020202020202020202020202072657475726E20747275653B0D0A2020202020202020202020207D0D0A0D0A20202020202020202020202072657475726E2066616C73653B0D0A20202020202020207D0D0A0D0A20202020202020207072697661746520737461746963206279746520737472696E67546F4279746528737472696E6720737472496E290D0A20202020202020207B0D0A2020202020202020202020206966202828737472496E2E4C656E677468203E203229207C7C2028737472496E2E4C656E677468203C3D203029290D0A2020202020202020202020207B0D0A202020202020202020202020202020207468726F77206E657720417267756D656E74457863657074696F6E2822686578206D7573742062652031206F722032206368617261637465727320696E206C656E67746822293B0D0A2020202020202020202020207D0D0A0D0A20202020202020202020202072657475726E20627974652E506172736528737472496E2C204E756D6265725374796C65732E4865784E756D626572293B0D0A20202020202020207D0D0A0D0A2020202020202020696E7465726E616C2073746174696320627974655B5D20737472696E67546F42797465417272617928737472696E6720737472496E2C206F757420696E742072657456616C290D0A20202020202020207B0D0A20202020202020202020202072657456616C203D20303B0D0A202020202020202020202020737472696E67207465787431203D2022223B0D0A0D0A202020202020202020202020666F722028696E742069203D20303B2069203C20737472496E2E4C656E6774683B20692B2B290D0A2020202020202020202020207B0D0A202020202020202020202020202020206368617220636831203D20737472496E5B695D3B0D0A0D0A202020202020202020202020202020206966202863686172546F426F6F6C2863683129290D0A20202020202020202020202020202020202020207465787431203D207465787431202B206368313B0D0A20202020202020202020202020202020656C73650D0A202020202020202020202020202020202020202072657456616C202B3D20313B0D0A2020202020202020202020207D0D0A0D0A202020202020202020202020696620282874657874312E4C656E677468202520322920213D2030290D0A2020202020202020202020207B0D0A2020202020202020202020202020202072657456616C202B3D20313B0D0A202020202020202020202020202020207465787431203D2074657874312E537562737472696E6728302C2074657874312E4C656E677468202D2031293B0D0A2020202020202020202020207D0D0A0D0A202020202020202020202020696E74206E756D32203D2074657874312E4C656E677468202F20323B0D0A202020202020202020202020627974655B5D2062756666657231203D206E657720627974655B6E756D325D3B0D0A202020202020202020202020696E74206E756D33203D20303B0D0A0D0A202020202020202020202020666F722028696E74206E756D34203D20303B206E756D34203C20627566666572312E4C656E6774683B206E756D342B2B290D0A2020202020202020202020207B0D0A20202020202020202020202020202020737472696E67207465787432203D206E657720737472696E67286E657720636861725B5D207B2074657874315B6E756D335D2C2074657874315B6E756D33202B20315D207D293B0D0A20202020202020202020202020202020627566666572315B6E756D345D203D20737472696E67546F42797465287465787432293B0D0A202020202020202020202020202020206E756D33202B3D20323B0D0A2020202020202020202020207D0D0A0D0A20202020202020202020202072657475726E20627566666572313B0D0A20202020202020207D0D0A0D0A2020202020202020707269766174652073746174696320626F6F6C20737472696E67546F426F6F6C28737472696E6720737472496E290D0A20202020202020207B0D0A202020202020202020202020626F6F6C20666C616731203D20747275653B0D0A202020202020202020202020737472696E67207465787431203D20737472496E3B0D0A0D0A202020202020202020202020666F722028696E742069203D20303B2069203C2074657874312E4C656E6774683B20692B2B290D0A2020202020202020202020207B0D0A202020202020202020202020202020206368617220636831203D2074657874315B695D3B0D0A0D0A20202020202020202020202020202020696620282163686172546F426F6F6C2863683129290D0A202020202020202020202020202020207B0D0A2020202020202020202020202020202020202020666C616731203D2066616C73653B0D0A2020202020202020202020202020202020202020627265616B3B0D0A202020202020202020202020202020207D0D0A2020202020202020202020207D0D0A0D0A20202020202020202020202072657475726E20666C6167313B0D0A20202020202020207D0D0A0D0A2020202020202020707269766174652073746174696320696E7420737472696E67546F496E7428737472696E6720737472496E290D0A20202020202020207B0D0A202020202020202020202020696E74206E756D31203D20303B0D0A0D0A202020202020202020202020666F722028696E742069203D20303B2069203C20737472496E2E4C656E6774683B20692B2B290D0A2020202020202020202020207B0D0A202020202020202020202020202020206368617220636831203D20737472496E5B695D3B0D0A0D0A202020202020202020202020202020206966202863686172546F426F6F6C2863683129290D0A202020202020202020202020202020207B0D0A20202020202020202020202020202020202020206E756D312B2B3B0D0A202020202020202020202020202020207D0D0A2020202020202020202020207D0D0A0D0A20202020202020202020202069662028286E756D31202520322920213D2030290D0A2020202020202020202020207B0D0A202020202020202020202020202020206E756D312D2D3B0D0A2020202020202020202020207D0D0A0D0A20202020202020202020202072657475726E20286E756D31202F2032293B0D0A20202020202020207D0D0A202020207D0D0A0D0A7D0D0A
AS N'Classes\EncryptorUtils.cs'

GO
ALTER ASSEMBLY [SqlServerProject_Encryption]
ADD FILE FROM 0x7573696E672053797374656D3B0D0A7573696E672053797374656D2E446174613B0D0A7573696E672053797374656D2E446174612E53716C436C69656E743B0D0A7573696E672053797374656D2E446174612E53716C54797065733B0D0A7573696E67204D6963726F736F66742E53716C5365727665722E5365727665723B0D0A6E616D6573706163652050617261676F6E2E53656375726974792E43727970746F6772617068790D0A7B0D0A202020207075626C6963207061727469616C20636C6173732055736572446566696E656446756E6374696F6E730D0A202020207B0D0A20202020202020205B4D6963726F736F66742E53716C5365727665722E5365727665722E53716C46756E6374696F6E5D0D0A20202020202020207075626C6963207374617469632053716C537472696E672064656328737472696E672064617461546F446563727970742C20737472696E6720656E6372797074696F6E4B6579290D0A20202020202020207B0D0A2020202020202020202020207472790D0A2020202020202020202020207B0D0A202020202020202020202020202020206966202864617461546F44656372797074203D3D20222229207B2072657475726E2064617461546F446563727970743B207D0D0A202020202020202020202020202020206966202864617461546F44656372797074203D3D206E756C6C29207B2072657475726E2064617461546F446563727970743B207D0D0A0D0A2020202020202020202020202020202072657475726E20456E6372797074696F6E48656C7065722E446563727970744461746128456E6372797074696F6E48656C7065722E456E6372797074696F6E4D6574686F642E52696A6E6461656C2C20456E6372797074696F6E48656C7065722E486173684D6574686F642E4D44352C2064617461546F446563727970742C20656E6372797074696F6E4B6579293B0D0A0D0A2020202020202020202020207D0D0A202020202020202020202020636174636828457863657074696F6E2065290D0A2020202020202020202020207B0D0A2020202020202020202020202020202072657475726E2022223B0D0A202020202020202020202020202020202F2F72657475726E2064617461546F446563727970743B0D0A2020202020202020202020207D0D0A20202020202020207D0D0A202020207D0D0A7D0D0A0D0A
AS N'dec.cs'

GO
ALTER ASSEMBLY [SqlServerProject_Encryption]
ADD FILE FROM 0x7573696E672053797374656D3B0D0A7573696E672053797374656D2E446174613B0D0A7573696E672053797374656D2E446174612E53716C436C69656E743B0D0A7573696E672053797374656D2E446174612E53716C54797065733B0D0A7573696E67204D6963726F736F66742E53716C5365727665722E5365727665723B0D0A6E616D6573706163652050617261676F6E2E53656375726974792E43727970746F6772617068790D0A7B0D0A202020207075626C6963207061727469616C20636C6173732055736572446566696E656446756E6374696F6E730D0A202020207B0D0A20202020202020205B4D6963726F736F66742E53716C5365727665722E5365727665722E53716C46756E6374696F6E5D0D0A20202020202020207075626C6963207374617469632053716C537472696E6720656E6328737472696E672064617461546F456E63727970742C20737472696E6720656E6372797074696F6E4B6579290D0A20202020202020207B0D0A2020202020202020202020200D0A20202020202020202020202072657475726E20456E6372797074696F6E48656C7065722E456E63727970744461746128456E6372797074696F6E48656C7065722E456E6372797074696F6E4D6574686F642E52696A6E6461656C2C20456E6372797074696F6E48656C7065722E486173684D6574686F642E4D44352C2064617461546F456E63727970742C20656E6372797074696F6E4B6579293B0D0A0D0A20202020202020207D0D0A202020207D0D0A7D3B0D0A0D0A
AS N'enc.cs'

GO
ALTER ASSEMBLY [SqlServerProject_Encryption]
ADD FILE FROM 0xEFBBBF7573696E672053797374656D2E5265666C656374696F6E3B0D0A7573696E672053797374656D2E52756E74696D652E436F6D70696C657253657276696365733B0D0A7573696E672053797374656D2E52756E74696D652E496E7465726F7053657276696365733B0D0A7573696E672053797374656D2E446174612E53716C3B0D0A0D0A2F2F2047656E6572616C20496E666F726D6174696F6E2061626F757420616E20617373656D626C7920697320636F6E74726F6C6C6564207468726F7567682074686520666F6C6C6F77696E670D0A2F2F20736574206F6620617474726962757465732E204368616E6765207468657365206174747269627574652076616C75657320746F206D6F646966792074686520696E666F726D6174696F6E0D0A2F2F206173736F636961746564207769746820616E20617373656D626C792E0D0A5B617373656D626C793A20417373656D626C795469746C65282253716C53657276657250726F6A6563745F456E6372797074696F6E22295D0D0A5B617373656D626C793A20417373656D626C794465736372697074696F6E282222295D0D0A5B617373656D626C793A20417373656D626C79436F6E66696775726174696F6E282222295D0D0A5B617373656D626C793A20417373656D626C79436F6D70616E79282222295D0D0A5B617373656D626C793A20417373656D626C7950726F64756374282253716C53657276657250726F6A6563745F456E6372797074696F6E22295D0D0A5B617373656D626C793A20417373656D626C79436F707972696768742822436F7079726967687420C2A920203230303822295D0D0A5B617373656D626C793A20417373656D626C7954726164656D61726B282222295D0D0A5B617373656D626C793A20417373656D626C7943756C74757265282222295D0D0A0D0A5B617373656D626C793A20436F6D56697369626C652866616C7365295D0D0A0D0A2F2F0D0A2F2F2056657273696F6E20696E666F726D6174696F6E20666F7220616E20617373656D626C7920636F6E7369737473206F662074686520666F6C6C6F77696E6720666F75722076616C7565733A0D0A2F2F0D0A2F2F2020202020204D616A6F722056657273696F6E0D0A2F2F2020202020204D696E6F722056657273696F6E0D0A2F2F2020202020204275696C64204E756D6265720D0A2F2F2020202020205265766973696F6E0D0A2F2F0D0A2F2F20596F752063616E207370656369667920616C6C207468652076616C756573206F7220796F752063616E2064656661756C7420746865205265766973696F6E20616E64204275696C64204E756D626572730D0A2F2F206279207573696E672074686520272A272061732073686F776E2062656C6F773A0D0A5B617373656D626C793A20417373656D626C7956657273696F6E2822312E302E2A22295D0D0A0D0A
AS N'Properties\AssemblyInfo.cs'

GO
ALTER ASSEMBLY [SqlServerProject_Encryption]
ADD FILE FROM 0x7573696E672053797374656D3B0D0A7573696E672053797374656D2E446174613B0D0A7573696E672053797374656D2E446174612E53716C436C69656E743B0D0A7573696E672053797374656D2E446174612E53716C54797065733B0D0A7573696E67204D6963726F736F66742E53716C5365727665722E5365727665723B0D0A0D0A7075626C6963207061727469616C20636C6173732055736572446566696E656446756E6374696F6E730D0A7B0D0A202020205B4D6963726F736F66742E53716C5365727665722E5365727665722E53716C46756E6374696F6E5D0D0A202020207075626C6963207374617469632053716C537472696E6720746F4368617228627974655B5D2076616C7565290D0A202020207B0D0A0D0A202020202020202053797374656D2E546578742E4153434949456E636F64696E67204153434949456E636F64696E67203D206E65772053797374656D2E546578742E4153434949456E636F64696E6728293B0D0A2020202020202020737472696E6720737472427566666572203D204153434949456E636F64696E672E476574537472696E672876616C7565293B0D0A202020202020202072657475726E207374724275666665723B0D0A0D0A202020207D0D0A7D3B0D0A0D0A
AS N'toChar.cs'

GO
EXEC sys.sp_addextendedproperty @name=N'AutoDeployed', @value=N'yes' , @level0type=N'ASSEMBLY',@level0name=N'SqlServerProject_Encryption'
GO
EXEC sys.sp_addextendedproperty @name=N'SqlAssemblyProjectRoot', @value=N'C:\Projects\SQL 2005 Projects\SqlServerProject_Encryption' , @level0type=N'ASSEMBLY',@level0name=N'SqlServerProject_Encryption'


-------------------------------------------------------------------------------------------------------

2nd run below enc and dec function


USE GHI-HIP-QA

EXEC sp_dbcmptlevel 'GHI-HIP-QA', 90 ---change database name
GO
CREATE FUNCTION [dbo].[enc](@dataToEncrypt [nvarchar](4000), @encryptionKey [nvarchar](4000))
RETURNS [nvarchar](4000) WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [SqlServerProject_Encryption].[Paragon.Security.Cryptography.UserDefinedFunctions].[enc]
GO

CREATE FUNCTION [dbo].[dec](@dataToDecrypt [nvarchar](4000), @encryptionKey [nvarchar](4000))
RETURNS [nvarchar](4000) WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [SqlServerProject_Encryption].[Paragon.Security.Cryptography.UserDefinedFunctions].[dec]
GO

-------------------------------------------------------------------------------

After that Run Decrypted and Encrypted  function


create function Decrypted(@dataToDecrypt nvarchar(4000))
RETURNS [nvarchar](4000)
As
Begin
Declare @DecryptData nvarchar(4000)

Select @DecryptData=dbo.dec(@dataToDecrypt,'RbuejjCadghUPcAChdxTAMBhuGumCpDL')
RETURN @DecryptData
End
GO

create function Encrypted(@dataToDecrypt nvarchar(4000))
RETURNS [nvarchar](4000)
As
Begin
Declare @DecryptData nvarchar(4000)

Select @DecryptData=dbo.enc(@dataToDecrypt,'RbuejjCadghUPcAChdxTAMBhuGumCpDL')
RETURN @DecryptData
End
Go