public Task <List <Adult> > GetAdultsAsync()
{
using (AdultDBContext context = new AdultDBContext())
{
return(context.Adults.Include(a => a.JobTitle).ToListAsync());
}
}
public async Task <Adult> GetAdultAsync(int id)
{
using (AdultDBContext context = new AdultDBContext())
{
Adult adult = context.Adults.Where(a => a.Id == id).
Include(a => a.JobTitle).First();
return(adult);
}
}
public async Task <Adult> UpdateAsync(Adult adult)
{
using (AdultDBContext dbContext = new AdultDBContext())
{
dbContext.Adults.Update(adult);
await dbContext.SaveChangesAsync();
return(adult);
}
}
public async Task <Adult> AddAdultAsync(Adult adult)
{
using (AdultDBContext context = new AdultDBContext())
{
context.Adults.Add(adult);
await context.SaveChangesAsync();
return(adult);
}
}
public async Task RemoveAdultAsync(int id)
{
using (AdultDBContext context = new AdultDBContext())
{
Adult adult = context.Adults.Where(a => a.Id == id).
Include(a => a.JobTitle).First();
context.Adults.Remove(adult);
context.Jobs.Remove(adult.JobTitle);
await context.SaveChangesAsync();
}
}
public async Task <int> GetAdultAgeGroupAsync(int minimum, int maximum)
{
using (AdultDBContext context = new AdultDBContext())
{
int count = 0;
foreach (var a in context.Adults)
{
if (a.Age >= minimum && a.Age <= maximum)
{
count++;
}
}
return(count);
}
}
public async Task <double> GetEyeColorPercentageAsync(string color)
{
using (AdultDBContext Context = new AdultDBContext())
{
int count = 0;
foreach (var a in Context.Adults)
{
if (a.EyeColor.Equals(color))
{
count++;
}
}
return((double)count / Context.Adults.Count());
}
}
public async Task <Account> ValidateUserAsync(string username, string password)
{
using (AdultDBContext adultDbContext = new AdultDBContext())
{
Account first = adultDbContext.Accounts.FirstOrDefault(user => user.Username.Equals(username));
if (first == null)
{
throw new Exception("User not found");
}
if (!first.Password.Equals(password))
{
throw new Exception("Incorrect password");
}
return(first);
}
}
