public void InsertMonitor(MonitorData data) { try { sqlConnection.Open(); SqlCommand sqlCommand = new SqlCommand("INSERT INTO Monitor(monitorModel, monitorSerial, monitorVendor, attachedPC) " + "VALUES('" + data.modelM + "','" + data.serialNumberM + "','" + data.vendorM + "','" + data.attachedPC + "')" , sqlConnection); sqlCommand.ExecuteNonQuery(); } catch (SqlException e) { WriteToFile("Sql error from insertMonitor method" + e.Message); } finally { sqlConnection.Close(); } }
private static MonitorData setMonitorData(string serial) { MonitorData md = new MonitorData(); //add to database Database d = new Database(); try { //this queries the information of all available monitors ManagementObjectSearcher searcher = new ManagementObjectSearcher(@"root\WMI", "SELECT * FROM WmiMonitorID"); foreach (ManagementObject obj in searcher.Get()) { foreach (PropertyData p in obj.Properties) { if (p.Value != null) { if (p.Value.GetType().ToString().Equals("System.UInt16[]")) { switch (p.Name) { case "ManufacturerName": { md.vendorM = getString((UInt16[])p.Value); break; } case "SerialNumberID": { md.serialNumberM = getString((UInt16[])p.Value); break; } case "UserFriendlyName": { md.modelM = getString((UInt16[])p.Value); break; } } } } else if (p.Value == null) { if (!d.verifyMonitor(md.serialNumberM)) { md.attachedPC = serial; md.attachedPC = " " + serial; md.modelM = "Check"; md.serialNumberM = "The"; md.vendorM = "Monitor"; d.InsertMonitor(md); } } } /*if (md.modelM != null) * { * if (!d.verifyMonitor(md.serialNumberM)) * { * md.attachedPC = serial; * d.insertMonitor(md); * } * }*/ } } catch (Exception e) { WriteToFile("Exception thrown in setMonitor " + e.Message); d.InsertMonitor(md); } return(md); }