public bool UpdatePC(PCData data) { try { sqlConnection.Open(); using (SqlCommand sqlCommand = sqlConnection.CreateCommand()) { sqlCommand.Parameters.AddWithValue("@pcs", data.serialNumberPC); sqlCommand.Parameters.AddWithValue("@pcv", data.vendorPC); sqlCommand.Parameters.AddWithValue("@pcm", data.modelPC); sqlCommand.Parameters.AddWithValue("@pcwv", data.version); sqlCommand.Parameters.AddWithValue("@pcn", data.systemName); sqlCommand.Parameters.AddWithValue("@d", data.domain); sqlCommand.Parameters.AddWithValue("@an", data.assetName); sqlCommand.CommandText = "UPDATE PC " + " SET pcSerial=@pcs, pcVendor=@pcv, pcModel=@pcm, pcWindowsVersion=@pcwv," + " pcName=@pcn, domain=@d, assetName=@an WHERE pcSerial='" + data.serialNumberPC + "'"; sqlCommand.ExecuteNonQuery(); } } catch (SqlException e) { WriteToFile("Sql error from updateMonitor method" + e.Message); return(false); } finally { sqlConnection.Close(); } return(true); }
public void InsertPC(PCData data) { try { sqlConnection.Open(); SqlCommand sqlCommand = new SqlCommand("INSERT INTO PC(pcSerial,pcVendor,pcModel,pcWindowsVersion,pcName,domain,assetName) " + "VALUES('" + data.serialNumberPC + "','" + data.vendorPC + "','" + data.modelPC + "','" + data.version + "','" + data.systemName + "','" + data.domain + "','" + data.assetName + "')" , sqlConnection); sqlCommand.ExecuteNonQuery(); } catch (SqlException e) { WriteToFile("Sql error from insertPC method" + e.Message); } finally { sqlConnection.Close(); } }
private static string setPCData() { PCData pd = new PCData(); Database d = new Database(); try { System.Management.SelectQuery query = new System.Management.SelectQuery(@"Select * from Win32_ComputerSystem"); //initialize the searcher with the query it is supposed to execute using (System.Management.ManagementObjectSearcher searcher1 = new System.Management.ManagementObjectSearcher(query)) { //execute the query foreach (System.Management.ManagementObject process in searcher1.Get()) { //print system info process.Get(); pd.vendorPC = "" + process["Manufacturer"]; pd.modelPC = "" + process["Model"]; } } //to start searching at Windows BIOS table for the device serial number //shows the serial number of the PC ManagementObjectSearcher MOS = new ManagementObjectSearcher("Select * From Win32_BIOS"); foreach (ManagementObject getserial in MOS.Get()) { pd.serialNumberPC = getserial["SerialNumber"].ToString(); } pd.systemName = System.Environment.MachineName; pd.version = GetOSFriendlyName(); pd.domain = System.Net.NetworkInformation.IPGlobalProperties.GetIPGlobalProperties().DomainName; pd.assetName = pd.vendorPC + " " + pd.modelPC; if (!d.verifyPC(pd.serialNumberPC)) { d.InsertPC(pd); } else { d.UpdatePC(pd); } } catch (Exception t) { WriteToFile("Exception thrown in setPC " + t.Message); pd.systemName = "Generic system name"; pd.vendorPC = "this"; pd.serialNumberPC = "Check"; pd.version = "Generic PC Windows Version"; pd.domain = "Generic domain"; pd.modelPC = "PC"; pd.assetName = pd.vendorPC + pd.modelPC + " should be checked"; d.InsertPC(pd); } //pd.show(); return(pd.serialNumberPC); }