public IHttpActionResult Gettbl_FlightDetails(string id)
        {
            tbl_FlightDetails tbl_FlightDetails = db.tbl_FlightDetails.Find(id);

            if (tbl_FlightDetails == null)
            {
                return(NotFound());
            }

            return(Ok(tbl_FlightDetails));
        }
        public IHttpActionResult Deletetbl_FlightDetails(string id)
        {
            tbl_FlightDetails tbl_FlightDetails = db.tbl_FlightDetails.Find(id);

            if (tbl_FlightDetails == null)
            {
                return(NotFound());
            }

            db.tbl_FlightDetails.Remove(tbl_FlightDetails);
            db.SaveChanges();

            return(Ok(tbl_FlightDetails));
        }
        public IHttpActionResult Posttbl_FlightDetails(tbl_FlightDetails tbl_FlightDetails)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }
            db.proc_AddFlight(tbl_FlightDetails.TravelDays, tbl_FlightDetails.DeparturePoint, tbl_FlightDetails.ArrivalPoint,
                              tbl_FlightDetails.CabinType, tbl_FlightDetails.EconomyClassFair
                              , tbl_FlightDetails.BusinessClassFair, tbl_FlightDetails.FirstClassFair, tbl_FlightDetails.FlightStatus);
            //db.tbl_FlightDetails.Add(tbl_FlightDetails);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = tbl_FlightDetails.FlightId }, tbl_FlightDetails));
        }