private void btn_add_Click(object sender, EventArgs e)
{
if (this.id == 0)
{
if (this.tb_name.Text == "" || this.tb_numberOfSeats.Text == "" || this.cb_airlines.Text == "")
{
this.lbl_info.Text = "Missing information.";
this.lbl_info.Show();
return;
}
Airline_company.Airline_companyDao airlineDao = new Airline_company.Airline_companyDaoImplements();
int airlineId = airlineDao.getAirlineId(this.cb_airlines.Text);
Airplane.Airplane plane = new Airplane.Airplane(this.tb_name.Text, this.tb_numberOfSeats.Text, airlineId);
Airplane.AirplaneDao dao = new Airplane.AirplaneDaoImplements();
dao.addAirplane(plane);
}
else if (this.id != 0)
{
if (this.tb_name.Text == "" || this.tb_numberOfSeats.Text == "" || this.cb_airlines.Text == "")
{
this.lbl_info.Text = "Missing information.";
this.lbl_info.Show();
return;
}
Airline_company.Airline_companyDao airlineDao = new Airline_company.Airline_companyDaoImplements();
int airlineId = airlineDao.getAirlineId(this.cb_airlines.Text);
Airplane.Airplane plane = new Airplane.Airplane(this.id, this.tb_name.Text, Int32.Parse(this.tb_numberOfSeats.Text), airlineId);
Airplane.AirplaneDao dao = new Airplane.AirplaneDaoImplements();
dao.editAirplane(plane);
}
this.Close();
}
private void AddModifyAirplane_Load(object sender, EventArgs e)
{
lbl_info.Text = "";
Airline_company.Airline_companyDao airlinesDao = new Airline_company.Airline_companyDaoImplements();
List <Airline_company.Airline_company> airlines = airlinesDao.getAllAirlinesData();
foreach (Airline_company.Airline_company s in airlines)
{
this.cb_airlines.Items.Add(new { Text = s.Name, Value = s.Id });
}
this.cb_airlines.DisplayMember = "Text";
this.cb_airlines.ValueMember = "Value";
if (this.id == 0)
{
lbl_title.Text = "Add airplane";
btn_add.Text = "Add";
}
else if (this.id != 0)
{
lbl_title.Text = "Modify airplane";
btn_add.Text = "Save";
AirplaneDao airplaneDao = new AirplaneDaoImplements();
Airplane.Airplane airplane = airplaneDao.getAirplane(this.id);
this.tb_name.Text = airplane.Name;
Airline_company.Airline_company ac = airlinesDao.getAirlineDataForModification(airplane.Airline_company_id);
this.tb_numberOfSeats.Text = airplane.Number_of_seats.ToString();
this.cb_airlines.SelectedItem = new { Text = ac.Name, Value = ac.Id };
}
}
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 void editAirplane(Airplane airplane)
{
DB.DBConnection db = new DB.DBConnection();
db.editAirplane(airplane);
}
public void addAirplane(Airplane airplane)
{
DB.DBConnection db = new DB.DBConnection();
db.addAirplane(airplane);
}
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;
}
}
