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 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 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 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 async Task <bool> EliminarProducto(int id)
{
var productoConsulta = _context.Producto.Where(x => x.Id == id).FirstOrDefault();
if (productoConsulta != null)
{
_context.Producto.Remove(productoConsulta);
_context.SaveChanges();
await _context.SaveChangesAsync();
return(true);
}
return(false);
}
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);
}
}
