public List <CLIENT_INFO> GetClients() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return(entities.CLIENT_INFO.ToList()); } }
public List <int?> GetFlightID() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return(entities.GET_FLIGHT_ID().ToList()); } }
public List <ALL_FLIGHT> GetFlight() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return(entities.ALL_FLIGHT.ToList()); } }
public List <GET_PROMTIONS_Result> GetFlightPromotions() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return(entities.GET_PROMTIONS().ToList()); } }
public List <SELECT_RESERVATION_Result> GetReservations() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return(entities.SELECT_RESERVATION().ToList()); } }
public List <GET_ALL_PILOT_Result> GetPilots() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return(entities.GET_ALL_PILOT().ToList()); } }
public void SetCheckIn(int id) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { entities.CHECKIN(id); } }
public List <GET_ALL_AIRPORTS_Result> GetAirports() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return(entities.GET_ALL_AIRPORTS().ToList()); } }
public void AddMiles(int id, int miles) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { entities.ADD_MILES(id, miles); } }
public List <GET_REGULAR_FLIGHTS_Result> GetRegularFlights() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return(entities.GET_REGULAR_FLIGHTS().ToList()); } }
public void SetSeats([FromBody] int id, string seats) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { entities.SET_SEATS(id, seats); } }
public List <GET_ALL_UNIVERSITY_Result> GetUniversity() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return(entities.GET_ALL_UNIVERSITY().ToList()); } }
public List <GET_NOT_STUDENT_Result> GetRegClients() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return(entities.GET_NOT_STUDENT().ToList()); } }
public List<PLANE_INFO> GetAirplanes() { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { return entities.PLANE_INFO.ToList(); } }
public HttpResponseMessage GetFlightPromotions(int id) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.CHANGE_STATUS(id); return(Request.CreateResponse(HttpStatusCode.OK)); } }
public HttpResponseMessage GetAirportByid(string id) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.GET_AIRPORT_BYID(id).ToList(); if (ent != null) { return(Request.CreateResponse(HttpStatusCode.OK, ent)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "EL aeropuerto con identificación " + id + "no existe.")); } } }
public HttpResponseMessage GetId(string id) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.GET_CLIENT_ID(id); if (ent != null) { return(Request.CreateResponse(HttpStatusCode.OK, ent)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "EL cliente con identificación " + id + "no existe.")); } } }
public HttpResponseMessage GetUniversityByid(int id) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.GET_UNIVERSITY_BYID(id).ToList(); if (ent != null) { return(Request.CreateResponse(HttpStatusCode.OK, ent)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "La universidad con identificación " + id + "no existe.")); } } }
public HttpResponseMessage GetAirplaneByid(int id) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.GET_PLANE_INFO_BYID(id).ToList(); if (ent != null) { return Request.CreateResponse(HttpStatusCode.OK, ent); } else { return Request.CreateErrorResponse(HttpStatusCode.NotFound, "EL avión con identificación " + id + "no existe."); } } }
public Boolean Check(string email, string password) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.CLIENTs.FirstOrDefault(e => e.CLIENT_EMAIL == email); var en = entities.CLIENTs.FirstOrDefault(e => e.CLIENT_PASSWRD == password); if (ent != null & en != null) { return(true); } else { return(false); } } }
public HttpResponseMessage GetClientCCByid(string id) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.CLIENTs.FirstOrDefault(e => e.CLIENT_ID == id); if (ent != null) { return(Request.CreateResponse(HttpStatusCode.OK, en.EncryptDecrypt(ent.CLIENT_CARDNO, 200))); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "EL cliente con identificación " + id + "no existe.")); } } }
public HttpResponseMessage GetReservationByClientId(string id) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.SELECT_RESERVATION_BYCID(id).ToList(); if (ent != null) { return(Request.CreateResponse(HttpStatusCode.OK, ent)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "La reservación del cliente " + id + "no existe.")); } } }
public HttpResponseMessage GetRoutesByFlightid(int id) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.FROUTEs.FirstOrDefault(e => e.FLIGHT_ID == id); if (ent != null) { return(Request.CreateResponse(HttpStatusCode.OK, ent)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Las rutas con vuelo " + id + "no existen.")); } } }
public HttpResponseMessage GetFlightByOD(string o, string d) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.GET_FLIGHT_BYOD(o, d).ToList(); if (ent != null) { return(Request.CreateResponse(HttpStatusCode.OK, ent)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "EL vuelo con origen " + o + " y destino " + d + "no existe.")); } } }
public HttpResponseMessage GetFlightByid(int id) { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { var ent = entities.SELECT_FLIGHT_ID(id).ToList(); if (ent != null) { return(Request.CreateResponse(HttpStatusCode.OK, ent)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "EL vuelo con identificación " + id + "no existe.")); } } }
public HttpResponseMessage PostAirplane([FromBody] AIRPLANE plane) { try { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { entities.INSERT_AIRPLANE(plane.AIRPLANE_ID, plane.PILOT_ID); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, plane); message.Headers.Location = new Uri(Request.RequestUri + plane.AIRPLANE_ID.ToString()); return message; } } catch (Exception ex) { return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex); } }
public HttpResponseMessage PostPilot([FromBody] PILOT pilot) { try { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { entities.INSERT_PILOT(pilot.PILOT_ID, pilot.PILOT_FNAME, pilot.PILOT_LNAME); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, pilot); message.Headers.Location = new Uri(Request.RequestUri + pilot.PILOT_ID.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage PostAirport([FromBody] AIRPORT airport) { try { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { entities.INSERT_AIRPORT(airport.AIRPORT_NAME, airport.IATA_CODE, airport.STATE_CODE, airport.COUNTRY_CODE, airport.COUNTRY_NAME); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, airport); message.Headers.Location = new Uri(Request.RequestUri + airport.IATA_CODE); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage PostRoute([FromBody] FROUTE route) { try { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { entities.INSERT_ROUTE(route.FLIGHT_ID, route.ORIGIN, route.DESTINATION, route.FLIGHT_MILES, route.CAPACITY, route.ECO_PRICE, route.EJE_PRICE, route.DATE_HOUR, route.IS_PROMOTION, route.LUGGAGE_CAPACITY); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, route); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage PostFlight([FromBody] FLIGHT flight) { try { using (TECAirlinesDBEntities entities = new TECAirlinesDBEntities()) { entities.INSERT_FLIGHT(flight.FLIGHT_ID, flight.PLANE_ID, flight.ORIGIN_AIRPORT, flight.DESTINATION_AIRPORT, flight.FSTATUS); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, flight); message.Headers.Location = new Uri(Request.RequestUri + flight.FLIGHT_ID.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }