public async Task <Division> Get(int divisionId)
{
using (var context = new MVVMDemoDBEntities())
{
return(await context.Divisions.FirstOrDefaultAsync(x => x.DivisionId == divisionId));
}
}
public async Task <List <User> > GetAll(int divisionId)
{
using (var context = new MVVMDemoDBEntities())
{
return(await context.Users.Where(x => x.Division == divisionId).ToListAsync());
}
}
public async Task <List <User> > GetAll()
{
using (var context = new MVVMDemoDBEntities())
{
return(await context.Users.ToListAsync());
}
}
public async Task <User> Get(int userId)
{
using (var context = new MVVMDemoDBEntities())
{
return(await context.Users.FirstOrDefaultAsync(x => x.UserId == userId));
}
}
public async Task <List <Division> > GetAll()
{
using (var context = new MVVMDemoDBEntities())
{
//await Task.Delay(2000);
return(await context.Divisions.ToListAsync());
}
}
public async void Delete(int divisionId)
{
using (var context = new MVVMDemoDBEntities())
{
context.Divisions.Remove(await context.Divisions.FirstOrDefaultAsync(x => x.DivisionId == divisionId));
await context.SaveChangesAsync();
}
}
public async void Update(Division division)
{
using (var context = new MVVMDemoDBEntities())
{
var divisionToUpdate = await context.Divisions.FirstOrDefaultAsync(x => x.DivisionId == division.DivisionId);
divisionToUpdate.Name = division.Name;
await context.SaveChangesAsync();
}
}
public async void Add(User user)
{
using (var context = new MVVMDemoDBEntities())
{
context.Users.Add(new User {
FirstName = user.FirstName, LastName = user.LastName
});
await context.SaveChangesAsync();
}
}
public async void Update(User user)
{
using (var context = new MVVMDemoDBEntities())
{
User userToUpdate = await context.Users.FirstOrDefaultAsync(x => x.UserId == user.UserId);
userToUpdate.FirstName = user.FirstName;
userToUpdate.LastName = user.LastName;
userToUpdate.Division = user.Division;
await context.SaveChangesAsync();
}
}
public async void Add(string name)
{
using (var context = new MVVMDemoDBEntities())
{
if (!context.Divisions.Any(x => x.Name == name))
{
context.Divisions.Add(new Division {
Name = name
});
await context.SaveChangesAsync();
}
else
{
throw new Exception("En avdelning med det namnet finns redan");
}
}
}
