internal static void UpdateTableStops(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++)
{
StopsToUpdate stops = new StopsToUpdate()
{
_Id = new int(),
Name = string.Empty
};
for (int j = 0; j < DGV_ToUdpate.ColumnCount; j++)
{
stops._Id = Convert.ToInt32(DGV_ToUdpate.Rows[i].Cells[j++].Value);
stops.Name = DGV_ToUdpate.Rows[i].Cells[j].Value.ToString();
}
Database.DeleteRow("Остановки", stops._Id);
Database.UpdateStops(stops);
}
}
internal static void UpdateStops(StopsToUpdate stops)
{
connection.Open();
string values = stops._Id + ", ";
values += "\"" + stops.Name + "\"";
SQLiteCommand command = new SQLiteCommand("INSERT INTO Остановки VALUES (" + values + ")", connection);
try
{
command.ExecuteNonQuery();
}
catch
{
connection.Close();
MessageBox.Show("Ошибка ввода.", "Ошибка!");
return;
}
connection.Close();
}
