private void buttonAddStation_Click(object sender, EventArgs e)
{
string stationName = textBoxStationName.Text;
if (!stationName.Any(char.IsDigit) && stationName.Any(char.IsLetter) && stationName.Length < 51)
{
try
{
if (Stations.AddStation(_sqlConnection, stationName))
{
MessageBox.Show("Stacja została dodana pomyślnie!");
}
_stations = Stations.GetAllStations(_sqlConnection);
dataGridViewCourses.DataSource = _stations;
comboBoxStations.Items.Clear();
_stations = Stations.GetAllStations(_sqlConnection);
for (int i = 0; i < _stations.Rows.Count; i++)
{
comboBoxStations.Items.Add(_stations.Rows[i][1].ToString());
}
textBoxStationName.Text = "";
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
else
{
MessageBox.Show("Nazwa stacji nie powinna zawierać cyfr/ nie powinna być pusta");
}
}
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 buttonDisplayAllStations_Click(object sender, EventArgs e)
{
try
{
dataGridViewCourses.DataSource = Stations.GetAllStations(_sqlConnection);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void tabControl2_Click(object sender, EventArgs e)
{
if (tabControl1.SelectedIndex == 2)
{
try
{
comboBoxCityA.Items.Clear();
comboBoxCityB.Items.Clear();
var stations = Stations.GetAllStations(_sqlConnection);
for (int i = 0; i < stations.Rows.Count; i++)
{
comboBoxCityA.Items.Add(stations.Rows[i][1].ToString());
comboBoxCityB.Items.Add(stations.Rows[i][1].ToString());
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
}
