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 btn_remove_Click(object sender, EventArgs e)
{
int id = 0;
ListViewItem item = new ListViewItem();
if (this.lv_Main.SelectedItems.Count > 0)
{
item = this.lv_Main.SelectedItems[0];
}
switch (this.category)
{
case "flights":
Fly.FlyDao fly = new Fly.FlyDaoImplements();
id = Convert.ToInt32(item.SubItems[0].Text);
fly.removeFlight(id);
break;
case "airlines":
Airline_company.Airline_companyDao line = new Airline_company.Airline_companyDaoImplements();
int idLine = Convert.ToInt32(item.SubItems[5].Text);
line.removeAirline(idLine);
break;
case "airplanes":
Airplane.AirplaneDao air = new Airplane.AirplaneDaoImplements();
int idPlane = Convert.ToInt32(item.SubItems[3].Text);
air.removeAirplane(idPlane);
break;
}
this.ReloadListView();
}
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;
}
}
private void btn_add_Click(object sender, EventArgs e)
{
if (this.id == 0)
{
lbl_info.Text = "";
if (this.tb_name.Text == "" || this.tb_country.Text == "" || this.tb_address.Text == "")
{
this.lbl_info.Text = "Missing information.";
this.lbl_info.Show();
return;
}
else
{
Airline_company.Airline_companyDao dao = new Airline_company.Airline_companyDaoImplements();
string name = this.tb_name.Text;
string country = this.tb_country.Text;
string address = this.tb_address.Text;
string telephone = null;
string email = null;
if (this.tb_telephone.Text != "")
{
telephone = this.tb_telephone.Text;
}
if (this.tb_email.Text != "")
{
email = this.tb_email.Text;
}
Airline_company.Airline_company airline = new Airline_company.Airline_company(name, country, address, telephone, email);
dao.addAirline(airline);
}
}
else if (this.id != 0)
{
lbl_info.Text = "";
if (this.tb_name.Text == "" || this.tb_country.Text == "" || this.tb_address.Text == "")
{
this.lbl_info.Text = "Missing information.";
this.lbl_info.Show();
return;
}
else
{
Airline_company.Airline_companyDao dao = new Airline_company.Airline_companyDaoImplements();
string name = this.tb_name.Text;
string country = this.tb_country.Text;
string address = this.tb_address.Text;
string telephone = null;
string email = null;
if (this.tb_telephone.Text != "")
{
telephone = this.tb_telephone.Text;
}
if (this.tb_email.Text != "")
{
email = this.tb_email.Text;
}
Airline_company.Airline_company airline = new Airline_company.Airline_company(name, country, address, telephone, email, this.id);
dao.editAirline(airline);
}
}
this.Close();
}