public static void RegisterSnmpInfo(Snmp snmp)
{
string query = String.Format(@"INSERT INTO snmp (id, ip, syntax, community, type) VALUES (@id, @ip, @syntax, @community, @type) ON DUPLICATE KEY UPDATE edit_time = CURRENT_TIMESTAMP(), ip = @ip, syntax = @syntax, community = @community, type = @type");
using (MySqlConnection conn = new MySqlConnection(DatabaseManager.getInstance().ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(query, conn);
cmd.Parameters.AddWithValue("@id", snmp.Id);
cmd.Parameters.AddWithValue("@ip", snmp.IP);
cmd.Parameters.AddWithValue("@syntax", snmp.Syntax);
cmd.Parameters.AddWithValue("@community", snmp.Community);
cmd.Parameters.AddWithValue("@type", snmp.type);
cmd.Prepare();
cmd.ExecuteNonQuery();
}
}
public static Server GetServerInfo(Snmp snmp)
{
Server server = null;
string query = string.Format($"SELECT * FROM server WHERE ip = '{snmp.IP}'");
using (MySqlConnection conn = new MySqlConnection(DatabaseManager.getInstance().ConnectionString))
{
conn.Open();
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
server = new Server
{
Id = rdr["id"].ToString(),
Ip = rdr["ip"].ToString(),
UnitName = rdr["name"].ToString(),
Status = rdr["status"].ToString()
};
}
}
return(server);
}
