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); }