private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
ClassTablPSBBAAK d = (ClassTablPSBBAAK)BAAKGrid.SelectedItem;
if (d != null)
{
DataAccesBDBAAK.DeletePSB(d.namePSB);
}
else
{
System.Windows.MessageBox.Show("Выделенных строк для удаления нет", "Процесс удаления строки");
}
BAAKGrid.ItemsSource = DataAccesBDBAAK.GetDataBAAK();
}
public static void AddDataTablPlats(ClassTablPSBBAAK classTablPSBBAAK)
{
SQLiteConnection db =
new SQLiteConnection("Data Source = " + Path);
db.Open();
SQLiteCommand insertCommand = new SQLiteCommand();
insertCommand.Connection = db;
insertCommand.CommandText = "INSERT INTO ПлатыБААК VALUES (NULL, @ИмяПлаты, @Tip, @IPB, @KL, @Коментарий);";
insertCommand.Parameters.AddWithValue("@ИмяПлаты", classTablPSBBAAK.namePSB);
insertCommand.Parameters.AddWithValue("@Tip", classTablPSBBAAK.tipPSB);
insertCommand.Parameters.AddWithValue("@IPB", classTablPSBBAAK.IpPSB);
insertCommand.Parameters.AddWithValue("@KL", classTablPSBBAAK.nomerKlastera);
insertCommand.Parameters.AddWithValue("@Коментарий", classTablPSBBAAK.Coment);
insertCommand.ExecuteReader();
db.Close();
}
