public static SnmpCredentials GetCredentials(string CredentialName)
{
SnmpCredentials snmpCredentials = new SnmpCredentials();
using (SqlCommand textCommand = SqlHelper.GetTextCommand("SELECT * FROM SNMPV3Credentials WHERE CredentialName = @CredentialName"))
{
textCommand.Parameters.Add("@CredentialName", SqlDbType.NVarChar, 200).Value = (object)CredentialName;
using (IDataReader dataReader = SqlHelper.ExecuteReader(textCommand))
{
if (dataReader.Read())
{
for (int i = 0; i < dataReader.FieldCount; ++i)
{
switch (dataReader.GetName(i))
{
case nameof(CredentialName):
snmpCredentials.set_CredentialName(DatabaseFunctions.GetString(dataReader, i));
break;
case "SNMPV3AuthKey":
snmpCredentials.set_SNMPv3AuthPassword(DatabaseFunctions.GetString(dataReader, i));
break;
case "SNMPV3AuthKeyIsPwd":
snmpCredentials.set_SNMPV3AuthKeyIsPwd(DatabaseFunctions.GetBoolean(dataReader, i));
break;
case "SNMPV3AuthMethod":
snmpCredentials.set_SNMPv3AuthType((SNMPv3AuthType)Enum.Parse(typeof(SNMPv3AuthType), DatabaseFunctions.GetString(dataReader, i)));
break;
case "SNMPV3Context":
snmpCredentials.set_SnmpV3Context(DatabaseFunctions.GetString(dataReader, i));
break;
case "SNMPV3PrivKey":
snmpCredentials.set_SNMPv3PrivacyPassword(DatabaseFunctions.GetString(dataReader, i));
break;
case "SNMPV3PrivKeyIsPwd":
snmpCredentials.set_SNMPV3PrivKeyIsPwd(DatabaseFunctions.GetBoolean(dataReader, i));
break;
case "SNMPV3PrivMethod":
snmpCredentials.set_SNMPv3PrivacyType((SNMPv3PrivacyType)Enum.Parse(typeof(SNMPv3PrivacyType), DatabaseFunctions.GetString(dataReader, i)));
break;
case "SNMPV3Username":
snmpCredentials.set_SNMPv3UserName(DatabaseFunctions.GetString(dataReader, i));
break;
}
}
}
}
}
return(snmpCredentials);
}
