private void Add_button_Click(object sender, EventArgs e)
{
Update_button.Hide();
Delete_button.Hide();
Add_button.Hide();
Update_Form UF = Configurate.OptimalView_Form("Add", Update_DGV, RowToEdit, UpdateTable_CB.Text);
UF.ShowDialog();
Presenter.GetDGV(Update_DGV, UpdateTable_CB.Text, (int)OperationOption.UpdateRoutes);
}
private void Change_button_Click(object sender, EventArgs e)
{
for (int j = 1; j < NewData_DGV.ColumnCount; j++)
{
if (NewData_DGV.Rows[0].Cells[j].Value == null)
{
MessageBox.Show("Заполните все поля!");
return;
}
}
if (SelectedOption == "Update")
{
bool isSame = true;
for (int i = 0; i < NewData_DGV.ColumnCount; i++)
{
if (NewData_DGV.Rows[0].Cells[i].Value.ToString() != DGV_row[i])
{
isSame = false;
}
}
if (isSame)
{
MessageBox.Show("Введенное значение не изменилось");
return;
}
}
if (Configurate.GoodToUpdate(NewData_DGV, TableName, Presenter.GetCurrMaxId(TableName) + 1, SelectedOption))
{
switch (TableName)
{
case "Маршруты":
Presenter.UpdateTableRoutes(NewData_DGV, SelectedOption);
break;
case "Поезда":
Presenter.UpdateTableTrains(NewData_DGV, SelectedOption);
break;
case "Остановки":
Presenter.UpdateTableStops(NewData_DGV, SelectedOption);
break;
default:
break;
}
NewData_DGV.Hide();
MessageBox.Show("Таблица изменена");
NewData_DGV.Show();
Close();
}
}
private void SearchOption_CB_SelectedIndexChanged(object sender, EventArgs e)
{
SearchValue_CB.Hide();
DayTime_checkList.Hide();
SearchValue_CB.SelectedIndex = -1;
Presenter.GetDGV(Select_DGV, SelectTable_CB.Text);
switch (SearchOption_CB.SelectedIndex)
{
case (int)OperationOption.None:
break;
case (int)OperationOption.Trains:
Configurate.SearchOptionValues(SearchValue_CB, Select_DGV, (int)OperationOption.Trains);
SearchValue_CB.Show();
break;
case (int)OperationOption.FirstStop:
Configurate.SearchOptionValues(SearchValue_CB, Select_DGV, (int)OperationOption.FirstStop);
SearchValue_CB.Show();
break;
case (int)OperationOption.LastStop:
Configurate.SearchOptionValues(SearchValue_CB, Select_DGV, (int)OperationOption.LastStop);
SearchValue_CB.Show();
break;
case (int)OperationOption.DepartmentTime:
DayTime_checkList.Show();
break;
case (int)OperationOption.ArrivalTime:
DayTime_checkList.Show();
break;
}
}
private void SaveStops_ToolStripMenuItem_Click(object sender, EventArgs e)
{
Presenter.GetDGV(Select_DGV, "Остановки");
Configurate.SaveTableToTxt(Select_DGV, "stops.txt");
Presenter.GetDGV(Select_DGV, "Маршруты");
}
private void SaveTrains_ToolStripMenuItem_Click(object sender, EventArgs e)
{
Presenter.GetDGV(Select_DGV, "Поезда");
Configurate.SaveTableToTxt(Select_DGV, "trains.txt");
Presenter.GetDGV(Select_DGV, "Маршруты");
}
internal static void GetDGV(DataGridView dataTable, string tableName, int filterOption = (int)Form1.OperationOption.None, string filterValue = "")
{
dataTable.DataSource = null;
dataTable.Columns.Clear();
dataTable.Rows.Clear();
string query = "SELECT * FROM " + tableName;
if (tableName == "Маршруты")
{
query = "SELECT М._id, П.Название, О1.Название, О2.Название, М.\"Время отправления\", М.\"Время прибытия\" " +
"FROM Маршруты AS М " +
"INNER JOIN Поезда AS П " +
"ON М.Поезд = П._id " +
"INNER JOIN Остановки AS О1 " +
"ON М.\"Первая остановка\" = О1._id " +
"INNER JOIN Остановки AS О2 " +
"ON М.\"Конечная остановка\" = О2._id";
}
switch (filterOption)
{
case (int)Form1.OperationOption.None:
break;
case (int)Form1.OperationOption.Trains:
query += " WHERE П.Название = \"" + filterValue + "\"";
break;
case (int)Form1.OperationOption.FirstStop:
query += " WHERE О1.Название = \"" + filterValue + "\"";
break;
case (int)Form1.OperationOption.LastStop:
query += " WHERE О2.Название = \"" + filterValue + "\"";
break;
case (int)Form1.OperationOption.DepartmentTime:
filterValue = Configurate.FilterString(filterValue, " AND М.\"Время отправления\"");
query += " WHERE М.\"Время отправления\" " + filterValue;
break;
case (int)Form1.OperationOption.ArrivalTime:
filterValue = Configurate.FilterString(filterValue, " AND М.\"Время прибытия\"");
query += " WHERE М.\"Время прибытия\" " + filterValue;
break;
default:
break;
}
Tables tables = Database.Select(query, tableName);
switch (tableName)
{
case "Маршруты":
dataTable.DataSource = tables.T_Routes;
break;
case "Поезда":
dataTable.DataSource = tables.T_Trains;
break;
case "Остановки":
dataTable.DataSource = tables.T_Stops;
break;
default:
break;
}
Configurate.OptimalView_DGV(dataTable, tableName);
}
