public static void AddDataTablNullLine(ClassNullLine classTablPSBBAAK)
{
SQLiteConnection db =
new SQLiteConnection("Data Source = " + Path);
db.Open();
SQLiteCommand insertCommand = new SQLiteCommand();
insertCommand.Connection = db;
// Use parameterized query to prevent SQL injection attacks
insertCommand.CommandText = "INSERT INTO НулевыеЛинии VALUES (NULL, @ИмяПлаты, @Конал1, @Конал2, @Конал3, @Конал4, @Конал5, @Конал6, @Конал7, @Конал8, @Конал9, @Конал10, @Конал11, @Конал12);";
insertCommand.Parameters.AddWithValue("@ИмяПлаты", classTablPSBBAAK.namePSB);
insertCommand.Parameters.AddWithValue("@Конал1", classTablPSBBAAK.nullLine[0]);
insertCommand.Parameters.AddWithValue("@Конал2", classTablPSBBAAK.nullLine[1]);
insertCommand.Parameters.AddWithValue("@Конал3", classTablPSBBAAK.nullLine[2]);
insertCommand.Parameters.AddWithValue("@Конал4", classTablPSBBAAK.nullLine[3]);
insertCommand.Parameters.AddWithValue("@Конал5", classTablPSBBAAK.nullLine[4]);
insertCommand.Parameters.AddWithValue("@Конал6", classTablPSBBAAK.nullLine[5]);
insertCommand.Parameters.AddWithValue("@Конал7", classTablPSBBAAK.nullLine[6]);
insertCommand.Parameters.AddWithValue("@Конал8", classTablPSBBAAK.nullLine[7]);
insertCommand.Parameters.AddWithValue("@Конал9", classTablPSBBAAK.nullLine[8]);
insertCommand.Parameters.AddWithValue("@Конал10", classTablPSBBAAK.nullLine[9]);
insertCommand.Parameters.AddWithValue("@Конал11", classTablPSBBAAK.nullLine[10]);
insertCommand.Parameters.AddWithValue("@Конал12", classTablPSBBAAK.nullLine[11]);
insertCommand.ExecuteReader();
db.Close();
}
private void Button_Click_3(object sender, RoutedEventArgs e)
{
ClassNullLine d = (ClassNullLine)BAAKGrid1.SelectedItem;
if (d != null)
{
DataAccesBDBAAK.DeleteNullLine(d.namePSB);
}
else
{
System.Windows.MessageBox.Show("Выделенных строк для удаления нет", "Процесс удаления строки");
}
BAAKGrid1.ItemsSource = DataAccesBDBAAK.GetDataNullLine();
}
