public Reply GetUser()
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
try
{
var lst = (from d in db.Usuarios
join h in db.Roles on d.IdRoll equals h.Id
select new
{
Id = d.Id,
Nombre = d.Nombre,
Email = d.Email,
Password = d.Password,
IdRoll = d.IdRoll,
NombreRoll = h.NombreRoll
}).OrderByDescending(d => d.Id).ToList();
oReply.Success = 1;
oReply.Data = lst;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply GetPasajeros(VuelosRequest model)
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
try
{
List <Pasajero> lst = (from d in db.Pasajeros
select new Pasajero
{
Id = d.Id,
Nombres = d.Nombres,
Apellidos = d.Apellidos,
IdSexo = d.IdSexo,
IdVuelo = d.IdVuelo,
}).Where(d => d.IdVuelo == model.Id).OrderByDescending(d => d.Id).ToList();
oReply.Success = 1;
oReply.Data = lst;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply GetRol()
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
try
{
var lst = (from d in db.Roles
select new Role
{
Id = d.Id,
NombreRoll = d.NombreRoll
}).OrderByDescending(d => d.Id).ToList();
oReply.Success = 1;
oReply.Data = lst;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply EditUser(UserRequest model)
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
oReply.Success = 0;
string spassword = Encrypt.GetSHA256(model.Password);
try
{
var user = db.Usuarios.Find(model.Id);
user.Nombre = model.Nombre;
user.IdRoll = model.IdRoll;
user.Password = spassword;
user.Email = model.Email;
db.Entry(user).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
oReply.Success = 1;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply GetAeronave()
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
try
{
List <Aeronave> lst = (from d in db.Aeronaves
select new Aeronave
{
Id = d.Id,
Marca = d.Marca,
Modelo = d.Modelo,
Capacidad = d.Capacidad
}).OrderByDescending(d => d.Id).ToList();
oReply.Success = 1;
oReply.Data = lst;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply AddUser(UserRequest model)
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
oReply.Success = 0;
string spassword = Encrypt.GetSHA256(model.Password);
try
{
var user = new Usuario();
user.Nombre = model.Nombre;
user.IdRoll = model.IdRoll;
user.Password = spassword;
user.Email = model.Email;
db.Usuarios.Add(user);
db.SaveChanges();
oReply.Success = 1;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply EditVuelo(VuelosRequest model)
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
oReply.Success = 0;
try
{
Vuelo vuelo = db.Vuelos.Find(model.Id);
vuelo.Destino = model.Destino;
vuelo.FechaLlegada = model.FechaLlegada;
vuelo.FechaSalida = model.FechaSalida;
vuelo.IdAeronave = model.IdAeronave;
db.Entry(vuelo).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
oReply.Success = 1;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply AddVuelo(VuelosRequest model)
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
oReply.Success = 0;
try
{
var vuelo = new Vuelo();
vuelo.Destino = model.Destino;
vuelo.FechaLlegada = model.FechaLlegada;
vuelo.FechaSalida = model.FechaSalida;
vuelo.IdAeronave = model.IdAeronave;
vuelo.IdUsuario = 1;
vuelo.Estado = 1;
db.Vuelos.Add(vuelo);
db.SaveChanges();
oReply.Success = 1;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply GetVuelos()
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
try
{
var lst = (from d in db.Vuelos
join h in db.Aeronaves on d.IdAeronave equals h.Id
select new
{
Id = d.Id,
Destino = d.Destino,
FechaLlegada = d.FechaLlegada,
FechaSalida = d.FechaSalida,
IdAeronave = d.IdAeronave,
Estado = d.Estado,
Aeronave = h.Marca + " - " + h.Modelo
}).OrderByDescending(d => d.Id).ToList();
oReply.Success = 1;
oReply.Data = lst;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public UserResponse Auth(AuthRequest model)
{
UserResponse userresponse = new UserResponse();
using (var db = new DigitalWareContext())
{
string spassword = Encrypt.GetSHA256(model.Password);
var user = db.Usuarios.Where(d => d.Email == model.Email && d.Password == spassword).FirstOrDefault();
if (user == null)
{
return(null);
}
userresponse.Email = user.Email;
userresponse.Token = GetToken(user);
var idRoll = db.Usuarios.Where(d => d.Email == model.Email && d.Password == spassword).FirstOrDefault().IdRoll;
userresponse.IdRoll = idRoll;
userresponse.NombreRoll = db.Roles.Find(idRoll).NombreRoll;
}
return(userresponse);
}
public Reply DeleteAeronave(AeronaveRequest model)
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
oReply.Success = 0;
try
{
Aeronave aeronave = db.Aeronaves.Find(model.Id);
db.Remove(aeronave);
db.SaveChanges();
oReply.Success = 1;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply DeleteVuelo(VuelosRequest model)
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
oReply.Success = 0;
try
{
Vuelo vuelo = db.Vuelos.Find(model.Id);
db.Remove(vuelo);
db.SaveChanges();
oReply.Success = 1;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply DeleteUser(UserRequest model)
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
oReply.Success = 0;
string spassword = Encrypt.GetSHA256(model.Password);
try
{
var user = db.Usuarios.Find(model.Id);
db.Remove(user);
db.SaveChanges();
oReply.Success = 1;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply EditAeronave(AeronaveRequest model)
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
oReply.Success = 0;
try
{
Aeronave aeronave = db.Aeronaves.Find(model.Id);
aeronave.Marca = model.Marca;
aeronave.Modelo = model.Modelo;
aeronave.Capacidad = model.Capacidad;
db.Entry(aeronave).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
oReply.Success = 1;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public Reply AddAeronave(AeronaveRequest model)
{
using (DigitalWareContext db = new DigitalWareContext())
{
Reply oReply = new Reply();
oReply.Success = 0;
try
{
var aeronave = new Aeronave();
aeronave.Marca = model.Marca;
aeronave.Modelo = model.Modelo;
aeronave.Capacidad = model.Capacidad;
db.Aeronaves.Add(aeronave);
db.SaveChanges();
oReply.Success = 1;
}
catch (Exception ex)
{
oReply.Message = ex.Message;
}
return(oReply);
}
}
public ProductoRepository(DigitalWareContext context)
{
_context = context;
}
