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