public async Task <bool> SaveVeicleAssignement(VeicleAssignement veicleAssignement)
{
if (veicleAssignement != null)
{
if (int.TryParse(veicleAssignement.Account.Id, out int accountId) & int.TryParse(veicleAssignement.Veicle.Id, out int veicleId))
{
SqlAccount sqlAccount = await dbContext.SqlAccounts.FirstOrDefaultAsync(x => x.Id == accountId);
SqlVeicle sqlVeicle = await dbContext.SqlVeicles.FirstOrDefaultAsync(x => x.Id == veicleId);
SqlVeicleAssignement sqlVeicleAssignement = mapper.Map <SqlVeicleAssignement>(veicleAssignement);
List <SqlVeicleAssignement> validYet = dbContext.SqlVeicleAssignements.Where(x => x.SqlVeicle == sqlVeicle).ToList();
foreach (var vA in validYet)
{
if (vA.From == veicleAssignement.From)
{
return(false);
}
}
sqlVeicleAssignement.SqlAccount = sqlAccount;
sqlVeicleAssignement.SqlVeicle = sqlVeicle;
await dbContext.SqlVeicleAssignements.AddAsync(sqlVeicleAssignement);
return(await dbContext.SaveChangesAsync() > 0);
}
}
return(false);
}
public async Task <bool> SaveAsync(Veicle veicle)
{
if (veicle != null)
{
SqlVeicle sqlVeicle = mapper.Map <SqlVeicle>(veicle);
dbContext.SqlVeicles.Add(sqlVeicle);
return(await dbContext.SaveChangesAsync() > 0);
}
return(false);
}
public async Task <Veicle> GetById(string id)
{
if (int.TryParse(id, out int vId))
{
SqlVeicle sqlVeicle = await dbContext.SqlVeicles.FirstOrDefaultAsync(x => x.Id == vId);
return(mapper.Map <Veicle>(sqlVeicle));
}
return(null);
}
public async Task <bool> DeleteAsync(string id)
{
if (int.TryParse(id, out int veicleId))
{
SqlVeicle sqlVeicle = dbContext.SqlVeicles.FirstOrDefault(x => x.Id == veicleId);
if (sqlVeicle == null)
{
return(false);
}
dbContext.Remove(sqlVeicle);
return(await dbContext.SaveChangesAsync() > 0);
}
return(false);
}
public async Task <Veicle> RetriveByIdAsync(string Id)
{
await Task.Delay(0);
if (int.TryParse(Id, out int veicleId))
{
SqlVeicle sqlVeicle = dbContext.SqlVeicles.FirstOrDefault(x => x.Id == veicleId);
if (sqlVeicle == null)
{
return(null);
}
return(mapper.Map <Veicle>(sqlVeicle));
}
return(null);
}