/// <summary>
/// Get de un escala especifico
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ScaleData GetScale(string id)
{
ScaleData scale = new ScaleData();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
if (!this.ExistScale(id))
{
scale = null;
return(scale);
}
var escalax = entities.Escalas.Find(id);
scale.C_Vuelo = escalax.C_Vuelo;
scale.A_Salida = escalax.A_Salida;
scale.A_Llegada = escalax.A_Llegada;
scale.F_Salida = escalax.F_Salida;
scale.F_Llegada = escalax.F_Llegada;
return(scale);
}
catch (Exception)
{
scale = null;
return(scale);
}
}
}
/// <summary>
/// Agrega un nuevo vuelo
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool AddFlight(FlightData data)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
Vuelo newFlight = new Vuelo();
//newFlight.Codigo = data.Codigo;
//newFlight.Estado = data.Estado;
//newFlight.Costo = data.Costo;
//newFlight.F_Salida = data.F_Salida;
//newFlight.F_Llegada = data.F_Llegada;
//newFlight.Millas = data.Millas;
//newFlight.ID_Aeronave = data.ID_Aeronave;
//newFlight.A_Economicos = data.A_Economicos;
//newFlight.A_Ejecutivos = data.A_Ejecutivos;
try
{
//entities.Vueloes.Add(newFlight);
//entities.SaveChanges();
int entity = entities.udsp_ins_vuelo(data.Codigo, data.C_Ejecutivo, data.C_Economico, data.F_Salida, data.F_Llegada, data.A_Salida, data.A_Llegada, data.Millas, data.ID_Aeronave);
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
/// <summary>
/// Get de un programa de un usuario especifico
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ProgramData GetProgram(string id)
{
ProgramData program = new ProgramData();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
if (!this.ExistProgram(id))
{
program = null;
return(program);
}
var programx = entities.Programas.Find(id);
program.C_Usuario = programx.C_Usuario;
program.ID_Universidad = programx.ID_Universidad;
program.Millas = programx.Millas;
return(program);
}
catch (Exception)
{
program = null;
return(program);
}
}
}
/// <summary>
/// Get de un vuelo especifico
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public TicketData GetTicket(int id)
{
TicketData ticket = new TicketData();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
if (!this.ExistTicket(id))
{
ticket = null;
return(ticket);
}
var ticketx = entities.Tiquetes.Find(id);
ticket.C_Reserva = ticketx.C_Reserva;
ticket.N_Asiento = ticketx.N_Asiento;
return(ticket);
}
catch (Exception)
{
ticket = null;
return(ticket);
}
}
}
/// <summary>
/// Agrega un nuevo escala
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool AddScale(ScaleData data)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
//Escala newScale = new Escala();
//newScale.C_Vuelo = data.C_Vuelo;
//newScale.A_Salida = data.A_Salida;
//newScale.A_Llegada = data.A_Llegada;
//newScale.F_Salida = data.F_Salida;
//newScale.F_Llegada = data.F_Llegada;
try
{
//entities.Escalas.Add(newScale);
//entities.SaveChanges();
int entity = entities.udsp_ins_escala(data.C_Vuelo, data.A_Salida, data.A_Salida, data.F_Salida, data.F_Llegada);
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
/// <summary>
/// Actualizar un vuelo
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool UpdateFlight(FlightData data)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
var flight = entities.Vueloes.Find(data.Codigo);
flight.Codigo = data.Codigo;
flight.Estado = data.Estado;
flight.C_Ejecutivo = data.C_Ejecutivo;
flight.C_Economico = data.C_Economico;
flight.F_Salida = data.F_Salida;
flight.F_Llegada = data.F_Llegada;
flight.A_Salida = data.A_Salida;
flight.A_Llegada = data.A_Llegada;
flight.Millas = data.Millas;
flight.ID_Aeronave = data.ID_Aeronave;
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
/// <summary>
/// Get de una promocion especifica
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public PromotionData GetPromotion(string id)
{
PromotionData promotion = new PromotionData();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
if (!this.ExistPromotion(id))
{
promotion = null;
return(promotion);
}
var promox = entities.Promocions.Find(id);
promotion.C_Usuario = promox.C_Usuario;
promotion.C_Vuelo = promox.C_Vuelo;
promotion.F_Inicio = promox.F_Inicio;
promotion.F_Fin = promox.F_Fin;
promotion.Porcentaje = promox.Porcentaje;
promotion.Imagen = promox.Imagen;
return(promotion);
}
catch (Exception)
{
promotion = null;
return(promotion);
}
}
}
/// <summary>
/// Agrega un nuevo usuario
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool AddUser(UserData data)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
//Usuario newUser = new Usuario();
//newUser.Nombre = data.Nombre;
//newUser.Apellido1 = data.Apellido1;
//newUser.Apellido2 = data.Apellido2;
//newUser.Telefono = data.Telefono;
//newUser.Carne = data.Carne;
//newUser.Correo = data.Correo;
//newUser.Contraseña = data.Contraseña;
try
{
//entities.Usuarios.Add(newUser);
//entities.SaveChanges();
int entity = entities.udsp_ins_usuario(data.Nombre, data.Apellido1, data.Apellido2, data.Telefono, data.Carne, data.Universidad, data.Correo, data.Contraseña);
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
/// <summary>
/// Get de un vuelo especifico
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public UniversityData GetUniversity(int id)
{
UniversityData university = new UniversityData();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
if (!this.ExistUniversity(id))
{
university = null;
return(university);
}
var universityx = entities.Universidads.Find(id);
university.Identificador = universityx.Identificador;
university.Nombre = universityx.Nombre;
return(university);
}
catch (Exception)
{
university = null;
return(university);
}
}
}
/// <summary>
/// Lista de aviones
/// </summary>
/// <returns></returns>
public List <object> GetAirports()
{
List <Object> dataList = new List <object>();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
var airshipList = entities.airports.ToList();
int n = airshipList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < airshipList.Count; ++i)
{
AirportData data = new AirportData();
data.Nombre = airshipList.ElementAt(i).Nombre;
data.Codigo = airshipList.ElementAt(i).Codigo;
data.N_Pais = airshipList.ElementAt(i).N_Pais;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
/// <summary>
/// Lista de tickets
/// </summary>
/// <returns></returns>
public List <object> GetTickets()
{
List <Object> dataList = new List <object>();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
var ticketsList = entities.Tiquetes.ToList();
int n = ticketsList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < ticketsList.Count; ++i)
{
TicketData data = new TicketData();
data.C_Reserva = ticketsList.ElementAt(i).C_Reserva;
data.N_Asiento = ticketsList.ElementAt(i).N_Asiento;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
/// <summary>
/// Get de un avion especifico
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public AirshipData GetAirship(int id)
{
AirshipData airship = new AirshipData();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
if (!this.ExistAirship(id))
{
airship = null;
return(airship);
}
var aeronavex = entities.Aeronaves.Find(id);
airship.Identificador = aeronavex.Identificador;
airship.Modelo = aeronavex.Modelo;
airship.Capacidad = aeronavex.Capacidad;
return(airship);
}
catch (Exception)
{
airship = null;
return(airship);
}
}
}
/// <summary>
/// Lista de universidades
/// </summary>
/// <returns></returns>
public List <object> GetUniversitys()
{
List <Object> dataList = new List <object>();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
var universityList = entities.Universidads.ToList();
int n = universityList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < universityList.Count; ++i)
{
UniversityData data = new UniversityData();
data.Identificador = universityList.ElementAt(i).Identificador;
data.Nombre = universityList.ElementAt(i).Nombre;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
/// <summary>
/// Lista de aviones
/// </summary>
/// <returns></returns>
public List <object> GetAirships()
{
List <Object> dataList = new List <object>();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
var airshipList = entities.Aeronaves.ToList();
int n = airshipList.Count;
if (n == 0)
{
dataList = null;
return(dataList);
}
else
{
for (int i = 0; i < airshipList.Count; ++i)
{
AirshipData data = new AirshipData();
data.Identificador = airshipList.ElementAt(i).Identificador;
data.Modelo = airshipList.ElementAt(i).Modelo;
data.Capacidad = airshipList.ElementAt(i).Capacidad;
dataList.Add(data);
}
return(dataList);
}
}
catch
{
dataList = null;
return(dataList);
}
}
}
/// <summary>
/// Get de un reservacion de un cliente especifico
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ReservationData GetReservation(int id)
{
ReservationData reservation = new ReservationData();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
if (!this.ExistReservation(id))
{
reservation = null;
return(reservation);
}
var reserx = entities.Reservas.Find(id);
reservation.Codigo = reserx.Codigo;
reservation.Chequeo = reserx.Chequeo;
reservation.Equipaje = reserx.Equipaje;
reservation.C_Vuelo = reserx.C_Vuelo;
return(reservation);
}
catch (Exception)
{
reservation = null;
return(reservation);
}
}
}
/// <summary>
/// Get de un vuelo especifico
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public FlightData GetFlight(string ASal, string ALle)
{
FlightData flight = new FlightData();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
string id = entities.Vueloes.Where(e => e.A_Salida == ASal).ToList().First().Codigo;
string id1 = entities.Vueloes.Where(e => e.A_Llegada == ALle).ToList().First().Codigo;
try
{
if (!this.ExistFlight(id) || !this.ExistFlight(id1))
{
flight = null;
return(flight);
}
var vuelox = entities.Vueloes.Find(id);
flight.Codigo = vuelox.Codigo;
flight.Estado = vuelox.Estado;
flight.C_Ejecutivo = vuelox.C_Ejecutivo;
flight.C_Economico = vuelox.C_Economico;
flight.F_Salida = vuelox.F_Salida;
flight.F_Llegada = vuelox.F_Llegada;
flight.A_Salida = vuelox.A_Salida;
flight.A_Llegada = vuelox.A_Llegada;
flight.Millas = vuelox.Millas;
flight.ID_Aeronave = vuelox.ID_Aeronave;
return(flight);
}
catch (Exception)
{
flight = null;
return(flight);
}
}
}
/// <summary>
/// Get de un usuario especifico
/// </summary>
/// <param name="correo"></param>
/// <returns></returns>
public UserData GetUser(string correo)
{
UserData user = new UserData();
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
if (!this.ExistUser(correo))
{
user = null;
return(user);
}
var userx = entities.Usuarios.Find(correo);
user.Nombre = userx.Nombre;
user.Apellido1 = userx.Apellido1;
user.Apellido2 = userx.Apellido2;
user.Telefono = userx.Telefono;
user.Carne = userx.Carne;
user.Universidad = userx.Universidad;
user.Correo = userx.Correo;
user.Contraseña = userx.Contraseña;
return(user);
}
catch (Exception)
{
user = null;
return(user);
}
}
}
/// <summary>
/// Actualizar un Reservacion
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool UpdateReservation(ReservationData data)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
var user = entities.Reservas.Find(data.Codigo);
//user.Nombre = data.Nombre;
//user.Apellido1 = data.Apellido1;
//user.Apellido2 = data.Apellido2;
user.Chequeo = data.Chequeo;
user.Equipaje = data.Equipaje;
//user.Carne = data.Carne;
//user.Correo = data.Correo;
//user.Universidad = data.Universidad;
//user.Contraseña = data.Contraseña;
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
/// <summary>
/// Actualizar un vuelo
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool OpenFlight(FlightData data)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
int entity = entities.udsp_up_abrirvuelo(data.Codigo);
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
/// <summary>
/// //Verifica si un avion existe
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool ExistAirship(int id)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
var i = entities.Aeronaves.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
/// <summary>
/// //Verifica si un reservacion existe
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool ExistReservation(int id)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
var i = entities.Reservas.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
/// <summary>
/// Actualizar un Reservacion
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool UpdateReservation(ReservationData data)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
int entity = entities.udsp_up_reserva(data.Codigo, data.Equipaje);
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
/// <summary>
/// //Verifica si un avion existe
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool ExistFlight_codigo(string id)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
var i = entities.Vueloes.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
/// <summary>
/// //Verifica si un usuario existe
/// </summary>
/// <param name="correo"></param>
/// <returns></returns>
public bool ExistProgram(string correo, string contraseña)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
var i = entities.Programas.Find(correo);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
/// <summary>
/// //Verifica si una universidad existe
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool ExistUniversity(int id)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
var i = entities.Universidads.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
/// <summary>
/// //Verifica si un usuario existe
/// </summary>
/// <param name="correo"></param>
/// <returns></returns>
public bool ExistUser(string correo)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
var i = entities.Usuarios.Find(correo);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
/// <summary>
/// //Verifica si un ticket existe
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool ExistTicket(int id)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
var i = entities.Tiquetes.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
/// <summary>
/// //Verifica si una promocion existe existe
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool ExistPromotion(string id)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
var i = entities.Promocions.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
/// <summary>
/// //Verifica si un escala existe
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool ExistScale(string id)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
var i = entities.Escalas.Find(id);
if (i == null)
{
return(false);
}
else
{
return(true);
}
}
}
/// <summary>
/// Elimina un promocion
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeletePromotion(string id)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
try
{
var ms = entities.Promocions.Find(id);
entities.Promocions.Remove(ms);
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
