private void LoadDataGridViewTimetable()
{
dataGridViewTimetable.Rows.Clear();
dataGridViewTimetable.Columns.Clear();
dataGridViewTimetable.Columns.Add("FromTheCity", "Откуда");
dataGridViewTimetable.Columns.Add("InTheCity", "Куда");
dataGridViewTimetable.Columns.Add("Train", "Поезд");
dataGridViewTimetable.Columns.Add("Date", "Дата");
using (var context = new RailwayTicketContext())
{
DateTime date = Convert.ToDateTime(dateTimePicker.Text);
var timetable = context.Timetables.Where(t => t.Date == date &&
t.Route.FromCity == comboBoxFromCity.SelectedItem.ToString() &&
t.Route.InCity == comboBoxInCity.SelectedItem.ToString()).ToList();
for (int i = 0; i < timetable.Count(); i++)
{
List <string> data = new List <string>();
data.Add(timetable[i].Route.FromCity);
data.Add(timetable[i].Route.InCity);
data.Add(timetable[i].Train.Name);
data.Add(timetable[i].Date.ToLongDateString());
dataGridViewTimetable.Rows.Add(data.ToArray());
}
}
}
private void buttonOrder_Click(object sender, EventArgs e)
{
using (var context = new RailwayTicketContext())
{
var train = context.Trains.ToList().Where(t => t.Name == dataGridViewTimetable.SelectedRows[0].Cells["Train"].Value.ToString()).First();
MessageBox.Show($"Билет на поезд {train.Name} забронирован");
}
}
public StartWindow()
{
InitializeComponent();
using (var context = new RailwayTicketContext())
{
var cities = context.Routes.GroupBy(r => r.FromCity).Select(c => new { Name = c.Key });
foreach (var city in cities)
{
comboBoxFromCity.Items.Add(city.Name);
}
cities = context.Routes.GroupBy(r => r.InCity).Select(c => new { Name = c.Key });
foreach (var city in cities)
{
comboBoxInCity.Items.Add(city.Name);
}
}
}
