public AntivirusIdsFirewall(Aif aif) { InitializeComponent(); Text = "Изменить"; objectName.Text = aif.Name; objectPrice.Text = aif.Price.ToString(); if (aif.Support.IndexOf("Win") != -1) { windowsSupport.Checked = true; } if (aif.Support.IndexOf("Unix") != -1) { unixSupport.Checked = true; } objectClass.SelectedIndex = aif.ClassId - 1; }
public void ChangeObject(Aif oldAif, Aif newAif, string table) { string updateObject = string.Format("UPDATE {0} SET Name = @name, Price = @price, Support = @support, Class_Id = @classId WHERE Id = @id", table); using (SqlCommand sqlCommand = new SqlCommand(updateObject, _sqlConnection)) { sqlCommand.Parameters.AddWithValue("@name", newAif.Name); sqlCommand.Parameters.AddWithValue("@price", newAif.Price); sqlCommand.Parameters.AddWithValue("@support", newAif.Support); sqlCommand.Parameters.AddWithValue("@classId", newAif.ClassId); sqlCommand.Parameters.AddWithValue("@id", oldAif.Id); if (sqlCommand.ExecuteNonQuery() > 0) { MessageBox.Show("Изменено"); } else { MessageBox.Show("Ошибка при изменении"); } } }
public void DeleteObject(Aif aif, string table) { string removeObject = string.Format("DELETE FROM {0} WHERE Id = @id", table); using (SqlCommand sqlCommand = new SqlCommand(removeObject, _sqlConnection)) { sqlCommand.Parameters.AddWithValue("@id", aif.Id); if (sqlCommand.ExecuteNonQuery() > 0) { MessageBox.Show("Удалено"); } else { MessageBox.Show("Ошибка при удалении"); } } }
public void AddObject(Aif aif, string table) { string insertObject = string.Format("INSERT INTO {0} (Name, Price, Support, Class_Id) VALUES (@name, @price, @support, @classId)", table); using (SqlCommand sqlCommand = new SqlCommand(insertObject, _sqlConnection)) { sqlCommand.Parameters.AddWithValue("@name", aif.Name); sqlCommand.Parameters.AddWithValue("@price", aif.Price); sqlCommand.Parameters.AddWithValue("@support", aif.Support); sqlCommand.Parameters.AddWithValue("@classId", aif.ClassId); if (sqlCommand.ExecuteNonQuery() > 0) { // MessageBox.Show("Добвленно"); } else { MessageBox.Show("Ошибка при добавлении"); } } }