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 = "";
}
}
