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); }