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