internal static void UpdateTableTrains(DataGridView DGV_ToUdpate, string selectedOperation)
{
int rowCount;
if (selectedOperation == "Add")
{
rowCount = DGV_ToUdpate.RowCount - 1;
}
else
{
rowCount = DGV_ToUdpate.RowCount;
}
for (int i = 0; i < rowCount; i++)
{
TrainsToUpdate trains = new TrainsToUpdate()
{
_Id = new int(),
Name = string.Empty,
Capacity = new int()
};
for (int j = 0; j < DGV_ToUdpate.ColumnCount; j++)
{
trains._Id = Convert.ToInt32(DGV_ToUdpate.Rows[i].Cells[j++].Value);
trains.Name = DGV_ToUdpate.Rows[i].Cells[j++].Value.ToString();
trains.Capacity = Convert.ToInt32(DGV_ToUdpate.Rows[i].Cells[j].Value);
}
Database.DeleteRow("Поезда", trains._Id);
Database.UpdateTrains(trains);
}
}
internal static void UpdateTrains(TrainsToUpdate trains)
{
connection.Open();
string values = trains._Id + ", ";
values += "\"" + trains.Name + "\", ";
values += trains.Capacity;
SQLiteCommand command = new SQLiteCommand("INSERT INTO Поезда VALUES (" + values + ")", connection);
try
{
command.ExecuteNonQuery();
}
catch
{
connection.Close();
MessageBox.Show("Ошибка ввода.", "Ошибка!");
return;
}
connection.Close();
}
