public override async Task <int> RemoveAsync(Expression <Func <User, bool> > expression)
{
using (AvicomContext context = new AvicomContext())
{
var users = context.Users.Where(expression);
context.Users.RemoveRange(users);
return(await context.SaveChangesAsync());
}
}
public override async Task <User> AddAsync(User user)
{
using (AvicomContext context = new AvicomContext())
{
context.Users.Add(user);
await context.SaveChangesAsync();
return(user);
}
}
public override async Task <Company> AddAsync(Company user)
{
using (AvicomContext context = new AvicomContext())
{
context.Companies.Add(user);
await context.SaveChangesAsync();
return(user);
}
}
public override User[] All(Expression <Func <User, bool> > expression = null)
{
using (AvicomContext context = new AvicomContext())
{
if (expression == null)
{
return(context.Users.AsNoTracking().ToArray());
}
else
{
return(context.Users.Where(expression).AsNoTracking().ToArray());
}
}
}
public override async Task <Company> UpdateAsync(Company entity)
{
using (AvicomContext context = new AvicomContext())
{
var editEntity = await context.Companies.SingleOrDefaultAsync(u => u.Id == entity.Id);
if (editEntity != null)
{
editEntity.Name = entity.Name;
editEntity.ContractStatus = entity.ContractStatus;
}
await context.SaveChangesAsync();
return(editEntity);
}
}
public override async Task <User> UpdateAsync(User user)
{
using (AvicomContext context = new AvicomContext())
{
var editUser = await context.Users.SingleOrDefaultAsync(u => u.Id == user.Id);
if (editUser != null)
{
editUser.Login = user.Login;
editUser.Name = user.Name;
editUser.Password = user.Password;
}
await context.SaveChangesAsync();
return(editUser);
}
}
