public static async void Update(string pcName, string admPass, string biosPass, string model)//Update PC if it was exist { if (model == "" || model == null) { MessageBox.Show("Необходимо указать модель компьютера."); return; } SqlCommand command = new SqlCommand("UPDATE [Table] SET PcName=@PcName, Date=@Date, Responsibility=@Responsibility, AdmPass=@AdmPass, BiosPass=@BiosPass, pcModel=@Model WHERE PcName=@PcName", connection); command.Parameters.AddWithValue("PcName", pcName.ToUpper()); command.Parameters.AddWithValue("Date", DateTime.Today); command.Parameters.AddWithValue("Responsibility", Environment.UserName); command.Parameters.AddWithValue("AdmPass", Crypter.RSAEncrypt(admPass)); command.Parameters.AddWithValue("BiosPass", Crypter.RSAEncrypt(biosPass)); command.Parameters.AddWithValue("Model", model); try { await command.ExecuteNonQueryAsync(); MessageBox.Show("Запись обновлена успешно."); } catch (Exception e) { MessageBox.Show(e.ToString()); } }
public static async void ImportDB(string connect) { SqlConnection con = new SqlConnection(@" Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename =" + connect + "; Integrated Security = True"); //Connection to second DB SqlDataReader reader = null; await con.OpenAsync(); SqlCommand SelectCommand = new SqlCommand("SELECT * FROM [Table]", con); Comps.compsList.Clear(); reader = await SelectCommand.ExecuteReaderAsync(); //Reading all DB and get list while (await reader.ReadAsync()) { Comps comp = new Comps(); comp.PcName = reader[1].ToString(); comp.Responsibility = reader[3].ToString(); try { comp.AdmPass = Crypter.RSADecrypt(reader[4].ToString()); comp.BiosPass = Crypter.RSADecrypt(reader[5].ToString()); comp.Date = reader[2].ToString(); } catch { comp.AdmPass = reader[4].ToString(); comp.BiosPass = reader[5].ToString(); comp.Date = null; } Comps.compsList.Add(comp); } reader.Close(); con.Close(); SqlCommand command = new SqlCommand("INSERT INTO [Table] (PcName, Date, Responsibility, AdmPass, BiosPass)VALUES(UPPER(@PcName), @Date, @Responsible, @AdmPass, @BiosPass)", connection); foreach (Comps comp in Comps.compsList) { command.Parameters.Clear(); command.Parameters.AddWithValue("PcName", comp.PcName); if (comp.Date != null && comp.Date.Length > 1) { command.Parameters.AddWithValue("Date", DateTime.Parse(comp.Date)); } else { command.Parameters.AddWithValue("Date", DBNull.Value); } command.Parameters.AddWithValue("Responsible", comp.Responsibility); command.Parameters.AddWithValue("AdmPass", Crypter.RSAEncrypt(comp.AdmPass)); command.Parameters.AddWithValue("BiosPass", Crypter.RSAEncrypt(comp.BiosPass)); command.ExecuteNonQuery(); } }
public static async void Add(string pcName, string admPass, string biosPass, string model) //Insert new PC { SqlCommand command = new SqlCommand("INSERT INTO [Table] (PcName, Date, Responsibility, AdmPass, BiosPass, pcModel)VALUES(UPPER(@PcName), @Date, @Responsible, @AdmPass, @BiosPass, @Model)", connection); command.Parameters.AddWithValue("PcName", pcName); command.Parameters.AddWithValue("Date", DateTime.Today); command.Parameters.AddWithValue("Responsible", Environment.UserName); command.Parameters.AddWithValue("AdmPass", Crypter.RSAEncrypt(admPass)); command.Parameters.AddWithValue("BiosPass", Crypter.RSAEncrypt(biosPass)); command.Parameters.AddWithValue("Model", model); try { await command.ExecuteNonQueryAsync(); UpdateLastPC(); MessageBox.Show("Запись добавлена успешно."); } catch (Exception e) { MessageBox.Show(e.ToString()); } }