public IHttpActionResult GetAllFlights()
{
var db = new FlightDb();
var model = db.Flight;
return(Ok(model));
}
public static List <Flight> executeLinq_forfiltering_flights(ref FlightDb dbobj, DateTime?filterdate)
{
var mylist = from a in dbobj.flights_table
where a.Departure_date == filterdate
select a;
return(mylist.ToList());
}
public List <Seats> getSeats(ref FlightDb dbobj)
{
int fligthid = (int)Session["flight"];
var somelist = (from a in dbobj.tableof_seats
where a.seatcapacity > 0 && a.whatflightId == fligthid
select a).ToList();
return(somelist);
}
public FlightRepository(FlightDb dbContext)
{
_dbContext = dbContext;
}
public IHttpActionResult GetAllFlights()
{
var db = new FlightDb();
return(Ok(db.Flights));
}
public ReservationRepository(FlightDb dbContext)
{
_dbContext = dbContext;
}
public PassengerRepository(FlightDb dbContext)
{
_dbContext = dbContext;
}