private void tabControlCourses_Click(object sender, EventArgs e) { try { _trains = Trains.GetAllTrains(_sqlConnection); comboBoxTrains.Items.Clear(); for (int i = 0; i < _trains.Rows.Count; i++) { comboBoxTrains.Items.Add(_trains.Rows[i][1].ToString()); } _courses = Courses.GetAllCourses(_sqlConnection); comboBoxCourses.Items.Clear(); for (int i = 0; i < _courses.Rows.Count; i++) { comboBoxCourses.Items.Add(_courses.Rows[i][0].ToString()); } comboBoxStations.Items.Clear(); _stations = Stations.GetAllStations(_sqlConnection); for (int i = 0; i < _stations.Rows.Count; i++) { comboBoxStations.Items.Add(_stations.Rows[i][1].ToString()); } } catch (Exception err) { MessageBox.Show(err.Message); } }
private void buttonAddVisit_Click(object sender, EventArgs e) { try { var dateDays = monthCalendar1.SelectionStart; dateDays = dateDays.AddHours((int)numericUpDownHours.Value); dateDays = dateDays.AddMinutes((int)numericUpDownMinutes.Value); string date = dateDays.Year.ToString() + "-" + dateDays.Month.ToString() + "-" + dateDays.Day.ToString() + " " + dateDays.Hour.ToString() + ":" + dateDays.Minute.ToString() + ":" + dateDays.Second.ToString(); string courseIndex = _courses.Rows[comboBoxCourses.SelectedIndex][0].ToString(); string stationIndex = _stations.Rows[comboBoxStations.SelectedIndex][0].ToString(); string visitOrder = (Courses.GetNumberOfVisits(_sqlConnection, courseIndex) + 1).ToString(); string avaibleSeats = 50.ToString(); Visits.VisitData visitData = new Visits.VisitData(stationIndex, courseIndex, visitOrder, avaibleSeats, date); if (Visits.AddNewVisit(_sqlConnection, visitData)) { MessageBox.Show("Przystanek dodano pomyślnie"); } string visitIndex = Visits.GetVisitId(_sqlConnection, courseIndex, visitOrder); Seats.AddSeats(_sqlConnection, courseIndex, visitIndex, 50); dataGridViewCourses.DataSource = Courses.GetCourseVisits(_sqlConnection, courseIndex); _courses = Courses.GetAllCourses(_sqlConnection); } catch (Exception err) { MessageBox.Show(err.Message); } }
private void buttonAddCourse_Click(object sender, EventArgs e) { if (comboBoxTrains.SelectedIndex != -1) { try { int index = Int32.Parse(_trains.Rows[comboBoxTrains.SelectedIndex][0].ToString()); if (Courses.AddCourse(_sqlConnection, index)) { MessageBox.Show("Kurs został dodany pomyślnie!"); } _courses = Courses.GetAllCourses(_sqlConnection); dataGridViewCourses.DataSource = _courses; comboBoxCourses.Items.Clear(); for (int i = 0; i < _courses.Rows.Count; i++) { comboBoxCourses.Items.Add(_courses.Rows[i][0].ToString()); } } catch (Exception err) { MessageBox.Show(err.Message); } } else { MessageBox.Show("Nie wybrano pociągu!"); } }
private void buttonSelectAllCourses_Click(object sender, EventArgs e) { try { _courses = Courses.GetAllCourses(_sqlConnection); dataGridViewCourses.DataSource = _courses; } catch (Exception err) { MessageBox.Show(err.Message); } }
private void buttonDeleteCourse_Click(object sender, EventArgs e) { try { int selectedRow = dataGridViewCourses.CurrentCell.RowIndex; int courseId = Int32.Parse(_courses.Rows[selectedRow][0].ToString()); if (Courses.DeleteCourse(_sqlConnection, courseId)) { MessageBox.Show("Kurs został usunięty pomyślnie!"); } _courses = Courses.GetAllCourses(_sqlConnection); dataGridViewCourses.DataSource = _courses; } catch (Exception err) { MessageBox.Show(err.Message); } }