public void AttachItem(Motorista motorista, FleetManContext context)
{
if (!context.Motoristas.Local.Contains(motorista))
{
context.Motoristas.Attach(motorista);
}
}
public async Task <UserInfo> ValidateLogin(string email, string password)
{
try
{
FleetManHash fleetManHash = new FleetManHash();
using (FleetManContext context = new FleetManContext())
{
//Recover Salt string from Database
LoginModel loginData = await context.LoginDatas.Where(ld => ld.Email == email).FirstOrDefaultAsync();
if (loginData == null)
{
return(new UserInfo());
}
string validation_hash = fleetManHash.GetHashedPassword(password, loginData.Salt);
if (validation_hash.Equals(loginData.Password))
{
return(new UserInfo(is_valid: true, role: loginData.Role, cnpj: loginData.Login));
}
return(new UserInfo());
}
}
catch (Exception e)
{
throw e;
}
}
public void AttachItem(Veiculo veiculo, FleetManContext context)
{
if (!context.Veiculos.Local.Contains(veiculo))
{
context.Veiculos.Attach(veiculo);
}
}
public void AttachItem(Cliente cliente, FleetManContext context)
{
if (!context.Clientes.Local.Contains(cliente))
{
context.Clientes.Attach(cliente);
}
}
public async Task AddVeiculoAsync(Veiculo veiculo)
{
try
{
using FleetManContext context = new FleetManContext();
context.Veiculos.Add(veiculo);
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task AddClienteAsync(Cliente cliente)
{
try
{
using FleetManContext context = new FleetManContext();
context.Clientes.Add(cliente);
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <Cliente> GetClienteAsync(string cnpj)
{
try
{
using FleetManContext context = new FleetManContext();
return(await context.Clientes.Where(c => c.CNPJ == cnpj).FirstAsync());
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <List <Cliente> > GetAllAsync()
{
try
{
using FleetManContext context = new FleetManContext();
return(await context.Clientes.ToListAsync());
}
catch (Exception ex)
{
throw ex;
}
}
public async Task AddMotoristaAsync(Motorista motorista)
{
try
{
using FleetManContext context = new FleetManContext();
context.Motoristas.Add(motorista);
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public static bool CheckDbConnection()
{
try
{
using FleetManContext context = new FleetManContext();
return(context.Database.Exists());
}
catch (Exception)
{
return(false);
}
}
public async Task UpdateMotoristaAsync(Motorista motorista)
{
try
{
using FleetManContext context = new FleetManContext();
AttachItem(motorista, context);
context.Entry(motorista).State = EntityState.Modified;
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task UpdateClienteAsync(Cliente cliente)
{
try
{
using FleetManContext context = new FleetManContext();
AttachItem(cliente, context);
context.Entry(cliente).State = EntityState.Modified;
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task UpdateVeiculoAsync(Veiculo veiculo)
{
try
{
using FleetManContext context = new FleetManContext();
AttachItem(veiculo, context);
context.Entry(veiculo).State = EntityState.Modified;
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task RemoveMotoristaAsync(string cpf)
{
try
{
using FleetManContext context = new FleetManContext();
Motorista motorista = await GetMotoristaAsync(cpf);
if (motorista != null)
{
AttachItem(motorista, context);
context.Motoristas.Remove(motorista);
}
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task RemoveVeiculoAsync(string placa)
{
try
{
using FleetManContext context = new FleetManContext();
Veiculo veiculo = await GetVeiculoAsync(placa);
if (veiculo != null)
{
AttachItem(veiculo, context);
context.Veiculos.Remove(veiculo);
}
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task RemoveClienteAsync(string cnpj)
{
try
{
using FleetManContext context = new FleetManContext();
Cliente cliente = await GetClienteAsync(cnpj);
if (cliente != null)
{
AttachItem(cliente, context);
context.Clientes.Remove(cliente);
}
await context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <List <Motorista> > GetAllAsync(string cnpj)
{
using FleetManContext context = new FleetManContext();
return(await context.Motoristas.Where(m => m.Cliente_CNPJ == cnpj).ToListAsync());
}
public async Task <Motorista> GetMotoristaAsync(string cpf)
{
using FleetManContext context = new FleetManContext();
return(await context.Motoristas.Where(m => m.CPF == cpf).FirstOrDefaultAsync());
}
public async Task <Veiculo> GetVeiculoAsync(string placa)
{
using FleetManContext context = new FleetManContext();
return(await context.Veiculos.Where(v => v.Placa == placa).FirstOrDefaultAsync());
}
public async Task <List <Veiculo> > GetAllAsync(string cnpj)
{
using FleetManContext context = new FleetManContext();
return(await context.Veiculos.Where(v => v.Cliente_CNPJ == cnpj).ToListAsync());
}
