public async Task <Request> CreateRequestAsync(Request request)
{
ObjectEmpty(request);
var sqlRequest = mapper.Map <SqlRequest>(request);
dbcontext.SqlRequests.Add(sqlRequest);
await dbcontext.SaveChangesAsync();
return(mapper.Map <Request>(sqlRequest));
}
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 <bool> DeleteAssignement(SqlAccount sqlAccount, SqlUser sqlUser)
{
if (sqlAccount == null || sqlUser == null)
{
throw new NullReferenceException(Resource.ObjectEmpty);
}
SqlAssignement sqlAssignement = dbContext.SqlAssignements.Where(x => x.SqlAccount.Id == sqlAccount.Id)
.Where(x => x.SqlUser.Id == sqlUser.Id)
.Where(x => x.DeactivationDate == null)
.FirstOrDefault();
sqlAssignement.DeactivationDate = DateTime.UtcNow;
sqlAssignement.LastEdit = DateTime.UtcNow;
await dbContext.SaveChangesAsync();
return(true);
}
} // return a list of accounts
public async Task <Account> CreateAccountAsync(Account account)
{
ObjectEmpty(account);
account.CreationDate = DateTime.Now;
account.LastEdit = DateTime.Now;
SqlAccount sqlAccount = mapper.Map <SqlAccount>(account);
dbContext.SqlAccounts.Add(sqlAccount);
await dbContext.SaveChangesAsync();
return(mapper.Map <Account>(sqlAccount));
} // create a new istance of an account
