protected void search_click(object sender, EventArgs e) { switch(this.level.Value){ case "1": type ="deluxe"; break; case "2": type ="business"; break; case "3": type = "economy"; break; } searchF = new flight(); searchF.departure_date = Convert.ToDateTime(this.datepicker.Value); airLine = new air_line(); airLine.city_from = this.city_from.Value; airLine.city_to = this.city_to.Value; FlightService fs = new FlightService(); searchF = fs.searchFlight(searchF, type ,airLine); if (searchF == null) { ShowPopUpMsg("No flight are found!"); return; } Session["SearchFlight"] = searchF; Session["type"] = type; var response = base.Response; response.Redirect("list-flights.aspx"); }
public void deleteAirline(int airlineid) { int[] airline = new int[1]; airline[0] = airlineid; air_line air = new air_line(); air = airlineDAO.Find(airline); airlineDAO.Delete(air); }
protected void input_flight_ServerClick(object sender, EventArgs e) { FlightService fs = new FlightService(); air_line al = new air_line(); al.air_line_name = this.flight_name.Value; String[] time_leave = (this.time_depart.Value).Split(':'); String[] time_arr= this.time_arrive.Value.Split(':'); al.city_from = this.city_from.Value; al.city_to = this.city_to.Value; int t_1 = int.Parse(time_leave[0]); int t_2 = int.Parse(time_leave[1]); TimeSpan ts_l = new TimeSpan(t_1,t_2,0); t_1 = int.Parse(time_arr[0]); t_2 = int.Parse(time_arr[1]); TimeSpan ts_a = new TimeSpan(t_1,t_2,0); al.schedule_departure = ts_l; al.schedule_arrival = ts_a; al.mile = 100; al.air_line_status = "available"; fs.insertAirLine(al); }
public String updateAirline(air_line airline) { if (airlineDAO.Update(airline) != null) return "success"; else return "fail"; }
public String createAirline(air_line airLine) { if (airlineDAO.Insert(airLine) != null) return "success"; else return "fail"; }
//该接口用于符合查询航班信息 public flight searchFlight(flight f , String seat_type ,air_line air) { var select = from a in flightDAO.FindAll() select a; /* var select = from a in flightDAO.FindAll() where a.departure_date.Date.CompareTo(f.departure_date.Date) <= 0 && a.arrival_date.Date.CompareTo(f.departure_date.AddDays(1).Date) >= 0 select a; */ if (air.city_from != null) { select = select.Where(p => p.air_line.city_from == air.city_from); } if (air.city_to != null) { select = select.Where(p => p.air_line.city_to == air.city_to); } /* switch(seat_type) { case "deluxe": SqlBinary avalD = new SqlBinary(f.available_deluxe_seats); SqlBinary fullD = new SqlBinary(f.plane.plane_type.deluxe_seats); //seat is set to 1 if it is available //plane_type seat is set to 0 if(avalD.CompareTo(fullD) <= 0) select = null; break; case "business": SqlBinary avalB = new SqlBinary(f.available_business_seats); SqlBinary fullB = new SqlBinary(f.plane.plane_type.business_seats); if(avalB.CompareTo(fullB) <= 0) select = null; break; case "economy": SqlBinary avalE = new SqlBinary(f.available_economy_seats); SqlBinary fullE = new SqlBinary(f.plane.plane_type.economy_seats); if(avalE.CompareTo(fullE) <= 0) select = null; break; default: break; } */ if (select.ToList<flight>().Count == 0) return null; return select.First<flight>(); }
public air_line insertAirLine(air_line al) { return new AirLineRepository().Insert(al); }