// Token: 0x060006FE RID: 1790 RVA: 0x0002C68C File Offset: 0x0002A88C public static List <SnmpEntry> GetAllCredentials() { SqlCommand textCommand = SqlHelper.GetTextCommand("\r\n Select Distinct 1 As SnmpVersion, CommunityString, Null as SNMPUser, Null as Context, Null as AuthPassword, Null as EncryptPassword, \r\n0 as AuthLevel, Null as AuthMethod, 0 as EncryptMethod From dbo.DiscoverySNMPCredentials\r\nUnion\r\n(\r\n\tSELECT 3 As SnmpVersion, Null as CommunityString, SNMPUser, Context, AuthPassword, EncryptPassword, AuthLevel, AuthMethod, EncryptMethod \r\n\tFROM DiscoverySNMPCredentialsV3\r\n)"); List <SnmpEntry> list = new List <SnmpEntry> { new SnmpEntry { Name = "public", Version = SNMPVersion.SNMP1, Selected = true }, new SnmpEntry { Name = "private", Version = SNMPVersion.SNMP1, Selected = true } }; using (IDataReader dataReader = SqlHelper.ExecuteReader(textCommand)) { while (dataReader.Read()) { string @string = DatabaseFunctions.GetString(dataReader, "CommunityString"); int @int = DatabaseFunctions.GetInt32(dataReader, "SnmpVersion"); if ([email protected]("public", StringComparison.OrdinalIgnoreCase) && [email protected]("private", StringComparison.OrdinalIgnoreCase)) { if (@int == 3) { DiscoverySNMPCredentialsV3Entry.AuthenticationMethods int2 = DatabaseFunctions.GetInt32(dataReader, "AuthMethod"); DiscoverySNMPCredentialsV3Entry.EncryptionMethods int3 = DatabaseFunctions.GetInt32(dataReader, "EncryptMethod"); SnmpEntry snmpEntry = new SnmpEntry { UserName = DatabaseFunctions.GetString(dataReader, "SNMPUser"), Context = DatabaseFunctions.GetString(dataReader, "Context"), AuthPassword = DatabaseFunctions.GetString(dataReader, "AuthPassword"), PrivPassword = DatabaseFunctions.GetString(dataReader, "EncryptPassword"), AuthLevel = DatabaseFunctions.GetInt32(dataReader, "AuthLevel"), AuthMethod = ((int2 == 2) ? SnmpAuthMethod.SHA : SnmpAuthMethod.MD5), Version = SNMPVersion.SNMP3, Selected = true }; switch (int3) { case 2: snmpEntry.PrivMethod = SnmpPrivMethod.AES; break; case 3: snmpEntry.PrivMethod = SnmpPrivMethod.AES192; break; case 4: snmpEntry.PrivMethod = SnmpPrivMethod.AES256; break; default: snmpEntry.PrivMethod = SnmpPrivMethod.DES; break; } list.Add(snmpEntry); } else { list.Add(new SnmpEntry { Name = @string, Version = SNMPVersion.SNMP1, Selected = true }); } } } } return(list); }
public static List <SnmpEntry> GetAllCredentials() { SqlCommand textCommand = SqlHelper.GetTextCommand("\r\n Select Distinct 1 As SnmpVersion, CommunityString, Null as SNMPUser, Null as Context, Null as AuthPassword, Null as EncryptPassword, \r\n0 as AuthLevel, Null as AuthMethod, 0 as EncryptMethod From dbo.DiscoverySNMPCredentials\r\nUnion\r\n(\r\n\tSELECT 3 As SnmpVersion, Null as CommunityString, SNMPUser, Context, AuthPassword, EncryptPassword, AuthLevel, AuthMethod, EncryptMethod \r\n\tFROM DiscoverySNMPCredentialsV3\r\n)"); List <SnmpEntry> snmpEntryList1 = new List <SnmpEntry>(); SnmpEntry snmpEntry1 = new SnmpEntry(); snmpEntry1.set_Name("public"); snmpEntry1.set_Version((SNMPVersion)1); snmpEntry1.set_Selected(true); snmpEntryList1.Add(snmpEntry1); SnmpEntry snmpEntry2 = new SnmpEntry(); snmpEntry2.set_Name("private"); snmpEntry2.set_Version((SNMPVersion)1); snmpEntry2.set_Selected(true); snmpEntryList1.Add(snmpEntry2); List <SnmpEntry> snmpEntryList2 = snmpEntryList1; using (IDataReader dataReader = SqlHelper.ExecuteReader(textCommand)) { while (dataReader.Read()) { string str = DatabaseFunctions.GetString(dataReader, "CommunityString"); int int32_1 = DatabaseFunctions.GetInt32(dataReader, "SnmpVersion"); if (!str.Equals("public", StringComparison.OrdinalIgnoreCase) && !str.Equals("private", StringComparison.OrdinalIgnoreCase)) { if (int32_1 == 3) { DiscoverySNMPCredentialsV3Entry.AuthenticationMethods int32_2 = (DiscoverySNMPCredentialsV3Entry.AuthenticationMethods)DatabaseFunctions.GetInt32(dataReader, "AuthMethod"); DiscoverySNMPCredentialsV3Entry.EncryptionMethods int32_3 = (DiscoverySNMPCredentialsV3Entry.EncryptionMethods)DatabaseFunctions.GetInt32(dataReader, "EncryptMethod"); SnmpEntry snmpEntry3 = new SnmpEntry(); snmpEntry3.set_UserName(DatabaseFunctions.GetString(dataReader, "SNMPUser")); snmpEntry3.set_Context(DatabaseFunctions.GetString(dataReader, "Context")); snmpEntry3.set_AuthPassword(DatabaseFunctions.GetString(dataReader, "AuthPassword")); snmpEntry3.set_PrivPassword(DatabaseFunctions.GetString(dataReader, "EncryptPassword")); snmpEntry3.set_AuthLevel((SnmpAuthenticationLevel)DatabaseFunctions.GetInt32(dataReader, "AuthLevel")); snmpEntry3.set_AuthMethod(int32_2 == 2 ? (SnmpAuthMethod)1 : (SnmpAuthMethod)0); snmpEntry3.set_Version((SNMPVersion)3); snmpEntry3.set_Selected(true); SnmpEntry snmpEntry4 = snmpEntry3; switch (int32_3 - 2) { case 0: snmpEntry4.set_PrivMethod((SnmpPrivMethod)1); break; case 1: snmpEntry4.set_PrivMethod((SnmpPrivMethod)2); break; case 2: snmpEntry4.set_PrivMethod((SnmpPrivMethod)3); break; default: snmpEntry4.set_PrivMethod((SnmpPrivMethod)0); break; } snmpEntryList2.Add(snmpEntry4); } else { List <SnmpEntry> snmpEntryList3 = snmpEntryList2; SnmpEntry snmpEntry3 = new SnmpEntry(); snmpEntry3.set_Name(str); snmpEntry3.set_Version((SNMPVersion)1); snmpEntry3.set_Selected(true); snmpEntryList3.Add(snmpEntry3); } } } } return(snmpEntryList2); }