private void buttonShowCourseVisits_Click_1(object sender, EventArgs e) { string id = textBoxCourseVisits.Text; if (id.All(char.IsDigit)) { try { using (DataTable dataTable = Courses.GetCourseVisits(_sqlConnection, id)) { if (dataTable != null) { dataGridViewCourses.DataSource = dataTable; } else { MessageBox.Show("Kurs o podanych danych nie istnieje!"); } textBoxCourseVisits.Text = ""; } } catch { MessageBox.Show("Błąd zapytania do BD"); } } else { MessageBox.Show("Nie podano liczby"); } }
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 buttonShowCourseVisits_Click(object sender, EventArgs e) { string id = textBoxCourseVisits.Text; if (id.All(char.IsDigit) && id != "") { using (DataTable dataTable = Courses.GetCourseVisits(_sqlConnection, id)) { if (dataTable != null) { dataGridViewCourses.DataSource = dataTable; } else { MessageBox.Show("Kurs o podanych danych nie istnieje!"); } } } else { MessageBox.Show("ID musi być liczbą!"); textBoxCourseVisits.Text = ""; } }