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(); } }