private void buttonAdd_Click(object sender, EventArgs e)
{
lbl_info.Text = "";
if (this.tb_destination.Text == "" || this.tb_startPoint.Text == "" || this.dt_pickerDeparture.Value.ToString() == "" || this.dtpicker_Landing.Value.ToString() == "" || this.cb_airline.Text == "")
{
this.lbl_info.Text = "Missing information.";
this.lbl_info.Show();
return;
}
if (this.id == 0)
{
Airplane.AirplaneDao airplaneDao = new Airplane.AirplaneDaoImplements();
Airplane.Airplane airplane = airplaneDao.getAirplaneName(this.cb_airline.Text);
string destination = this.tb_destination.Text;
string start_point = this.tb_startPoint.Text;
DateTime departure = this.dt_pickerDeparture.Value;
DateTime landing = this.dtpicker_Landing.Value;
Fly.Fly newFlight = new Fly.Fly(destination, start_point, departure, landing, airplane.Id);
FlyDaoImplements fdi = new FlyDaoImplements();
fdi.addFlight(newFlight);
}
else if (this.id != 0)
{
Airplane.AirplaneDao airplaneDao = new Airplane.AirplaneDaoImplements();
Airplane.Airplane airplane = airplaneDao.getAirplaneName(this.cb_airline.Text);
string destination = this.tb_destination.Text;
string start_point = this.tb_startPoint.Text;
DateTime departure = this.dt_pickerDeparture.Value;
DateTime landing = this.dtpicker_Landing.Value;
Fly.Fly newFlight = new Fly.Fly(this.id, destination, start_point, departure, landing, airplane.Id);
FlyDaoImplements fdi = new FlyDaoImplements();
fdi.editFlight(newFlight);
}
this.Close();
}
public AddFlightForm(int id)
{
InitializeComponent();
this.dt_pickerDeparture.Format = DateTimePickerFormat.Custom;
this.dt_pickerDeparture.CustomFormat = "Da't'e: dd. MM. yyyy. Ti'm'e: HH:mm:ss";
this.dtpicker_Landing.Format = DateTimePickerFormat.Custom;
this.dtpicker_Landing.CustomFormat = "Da't'e: dd. MM. yyyy. Ti'm'e: HH:mm:ss";
if (id != 0)
{
this.id = id;
FlyDao flyDao = new FlyDaoImplements();
Fly.Fly flight = flyDao.getFlight(id);
this.lb_title.Text = "Modify flight";
this.tb_destination.Text = flight.Destination;
this.tb_startPoint.Text = flight.Start_point;
this.dt_pickerDeparture.Value = flight.Departure_time;
this.dtpicker_Landing.Value = flight.Landing_time;
}
}
private void ReloadListView()
{
if (this.selectedNode == "")
{
return;
}
this.btn_add.Enabled = false;
this.btn_remove.Enabled = false;
this.btn_modify.Enabled = false;
List <Fly.Fly> listOfFlights = new List <Fly.Fly>();
ListViewItem lvi = new ListViewItem();
AirplaneDao airplaneDao = new AirplaneDaoImplements();
switch (this.selectedNode)
{
case "Flights":
FlyDao flightsDao = new FlyDaoImplements();
List <Fly.Fly> list = flightsDao.getAllFlights();
this.btn_add.Enabled = true;
this.category = "flights";
lv_Main.Columns.Clear();
lv_Main.Items.Clear();
lv_Main.Columns.Add("id", 0);
lv_Main.Columns.Add("Destination", 100);
lv_Main.Columns.Add("Start point", 100);
lv_Main.Columns.Add("Departure time", 90);
lv_Main.Columns.Add("Landing time", 90);
lv_Main.Columns.Add("Airplane", 90);
foreach (Fly.Fly item in list)
{
Airplane.Airplane airplane = airplaneDao.getAirplane(item.Airplane_id);
lvi = new ListViewItem(new[] { item.Id.ToString(), item.Destination, item.Start_point, Convert.ToString(item.Departure_time), Convert.ToString(item.Landing_time), airplane.Name });
lv_Main.Items.Add(lvi);
}
break;
case "Airlines":
this.btn_add.Enabled = true;
this.category = "airlines";
Airline_companyDao airlinesDao = new Airline_companyDaoImplements();
List <Airline_company.Airline_company> airlines = airlinesDao.getAllAirlinesData();
lv_Main.Columns.Clear();
lv_Main.Items.Clear();
lv_Main.Columns.Add("Name", 90);
lv_Main.Columns.Add("Country");
lv_Main.Columns.Add("Address");
lv_Main.Columns.Add("Telephone", 70);
lv_Main.Columns.Add("Email");
lv_Main.Columns.Add("id", 0);
foreach (Airline_company.Airline_company item in airlines)
{
lvi = new ListViewItem(new[] { item.Name, item.Country, item.Address, Convert.ToString(item.Telephone), Convert.ToString(item.Email), Convert.ToString(item.Id) });
lv_Main.Items.Add(lvi);
}
break;
case "Airplanes":
this.btn_add.Enabled = true;
this.category = "airplanes";
lv_Main.Columns.Clear();
lv_Main.Items.Clear();
lv_Main.Columns.Add("Name", 100);
lv_Main.Columns.Add("Number of seats", 100);
lv_Main.Columns.Add("Airline", 100);
lv_Main.Columns.Add("id", 0);
List <Airplane.Airplane> airplanes = airplaneDao.getAllAirplanes();
string airlineName = "";
Airline_company.Airline_companyDao airline = new Airline_company.Airline_companyDaoImplements();
foreach (Airplane.Airplane planes in airplanes)
{
airlineName = airline.getAirline(planes.Airline_company_id);
lvi = new ListViewItem(new[] { planes.Name, planes.Number_of_seats.ToString(), airlineName, planes.Id.ToString() });
lv_Main.Items.Add(lvi);
}
break;
}
}
