private void button_DeleteFlight_Click(object sender, EventArgs e)
{
try
{
SqlConnection sqlconn = new SqlConnection();
sqlconn.ConnectionString = connection_string;
SqlCommand sqlcommand = new SqlCommand();
sqlcommand.Connection = sqlconn;
int flight_id = ((Store_Plane)comBoxFlightDelete.SelectedItem).idF;
sqlcommand.CommandText = "SELECT COUNT(*) FROM Flight_Company WHERE Flight_Company.CompanyId = " + com_id + " AND Flight_Company.FlightId=" + flight_id;
SqlDataReader sqldr;
sqlconn.Open();
sqldr = sqlcommand.ExecuteReader();
sqldr.Read();
int idR = Convert.ToInt32(sqldr[0]);
sqldr.Close();
if (idR == 0)
{
MessageBox.Show("Такого польоту не існує!", "Помилка");
}
else
{
sqlcommand.CommandText = "DELETE FROM Flight_Company WHERE Flight_Company.CompanyId = " + com_id + "AND Flight_Company.FlightId = " + flight_id;
sqlcommand.ExecuteNonQuery();
flight_cxt.Dispose();
flight_cxt = new LibraryData.AirportEntities();
var query = (from flight in flight_cxt.Flight
join flight_company in flight_cxt.Flight_Company on flight.FlightId equals flight_company.FlightId
join company in flight_cxt.Company on flight_company.CompanyId equals company.CompanyId
where company.CompanyId == com_id
select flight);
query.Load();
this.flightBindingSource.DataSource = flight_cxt.Flight.Local.ToBindingList();
cb_FlightAdd_set();
cb_FlightDelete_set();
comBoxFlightDelete.Text = "";
}
sqlconn.Close();
}
catch (Exception ex)
{
MessageBox.Show(Convert.ToString(ex));
}
}
public formAirport()
{
InitializeComponent();
aieEF = new LibraryData.AirportEntities();
aieEF.Company.Load();
this.companyBindingSource.DataSource = aieEF.Company.Local.ToBindingList();
aieEF.Plane.Load();
this.planeBindingSource.DataSource = aieEF.Plane.Local.ToBindingList();
aieEF.Flight.Load();
this.flightBindingSource.DataSource = aieEF.Flight.Local.ToBindingList();
aieEF.Ticket.Load();
this.ticketBindingSource.DataSource = aieEF.Ticket.Local.ToBindingList();
}
public FrmFlight(int cat_id, string cat_name)
{
InitializeComponent();
Text = String.Concat(Text, " ", cat_name);
flight_cxt = new LibraryData.AirportEntities();
com_id = cat_id;
name_cat = cat_name;
//find_flight();
changed = false;
var query = (from flight in flight_cxt.Flight
join flight_company in flight_cxt.Flight_Company on flight.FlightId equals flight_company.FlightId
join company in flight_cxt.Company on flight_company.CompanyId equals company.CompanyId
where company.CompanyId == com_id
select flight);
query.Load();
this.flightBindingSource.DataSource = flight_cxt.Flight.Local.ToBindingList();
cb_FlightAdd_set();
cb_FlightDelete_set();
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
aieEF = new LibraryData.AirportEntities();
}
public FrmFlight()
{
InitializeComponent();
changed = false;
flight_cxt = new LibraryData.AirportEntities();
}
private void buttonSearch_Click(object sender, EventArgs e)
{
var NotSavingItem = flight_cxt.ChangeTracker.Entries <LibraryData.Flight>().Where(a => a.State != EntityState.Unchanged).ToList();
if (NotSavingItem.Count != 0)
{
MessageBox.Show("Must save", "Show Category");
}
else
{
flight_cxt.Dispose();
flight_cxt = new LibraryData.AirportEntities();
IQueryable <LibraryData.Flight> query;
if (!string.IsNullOrWhiteSpace(textBoxPlane.Text) && !string.IsNullOrWhiteSpace(textBoxPrice.Text))
{
int price = Convert.ToInt32(textBoxPrice.Text);
query = (from flight in flight_cxt.Flight
join flight_company in flight_cxt.Flight_Company on flight.FlightId equals flight_company.FlightId
join company in flight_cxt.Company on flight_company.CompanyId equals company.CompanyId
join flight_ticket in flight_cxt.Flight_Ticket on flight.FlightId equals flight_ticket.FlightId
join ticket in flight_cxt.Ticket on flight_ticket.TicketId equals ticket.TicketId
join flight_plane in flight_cxt.Flight_Plane on flight.FlightId equals flight_plane.FlightId
join plane in flight_cxt.Plane on flight_plane.PlaneId equals plane.PlaneId
where company.CompanyId == com_id && plane.Type == textBoxPlane.Text && ticket.Price <= price
select flight);
}
else if (!string.IsNullOrWhiteSpace(textBoxPlane.Text))
{
query = (from flight in flight_cxt.Flight
join flight_company in flight_cxt.Flight_Company on flight.FlightId equals flight_company.FlightId
join company in flight_cxt.Company on flight_company.CompanyId equals company.CompanyId
join flight_plane in flight_cxt.Flight_Plane on flight.FlightId equals flight_plane.FlightId
join plane in flight_cxt.Plane on flight_plane.PlaneId equals plane.PlaneId
where company.CompanyId == com_id && plane.Type == textBoxPlane.Text
select flight);
}
else if (!string.IsNullOrWhiteSpace(textBoxPrice.Text))
{
int price = Convert.ToInt32(textBoxPrice.Text);
query = (from flight in flight_cxt.Flight
join flight_company in flight_cxt.Flight_Company on flight.FlightId equals flight_company.FlightId
join company in flight_cxt.Company on flight_company.CompanyId equals company.CompanyId
join flight_ticket in flight_cxt.Flight_Ticket on flight.FlightId equals flight_ticket.FlightId
join ticket in flight_cxt.Ticket on flight_ticket.TicketId equals ticket.TicketId
where company.CompanyId == com_id && ticket.Price <= price
select flight);
}
else
{
query = (from flight in flight_cxt.Flight
join flight_company in flight_cxt.Flight_Company on flight.FlightId equals flight_company.FlightId
join company in flight_cxt.Company on flight_company.CompanyId equals company.CompanyId
where company.CompanyId == com_id
select flight);
}
query.Load();
this.flightBindingSource.DataSource = flight_cxt.Flight.Local.ToBindingList();
}
}
