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