public async Task <IList <User> > GetUsers()
{
using (AdultDbContext context = new AdultDbContext())
{
return(context.Users.ToList());
}
}
public async Task DeleteAdultAsync(int adultId)
{
using (AdultDbContext context = new AdultDbContext())
{
context.Adults.Remove(context.Adults.First(a => a.Id == adultId));
await context.SaveChangesAsync();
}
}
public async Task UpdateAdultAsync(int Id, Adult adultToUpdate)
{
using (AdultDbContext context = new AdultDbContext())
{
context.Adults.Update(adultToUpdate);
await context.SaveChangesAsync();
}
}
public async Task AddUserAsync(User user)
{
using (AdultDbContext context = new AdultDbContext())
{
await context.Users.AddAsync(user);
await context.SaveChangesAsync();
}
}
public async Task RemoveAdultAsync(int id)
{
using (AdultDbContext dbContext = new AdultDbContext())
{
Adult adultToRemove = await GetAdultByIdAsync(id);
dbContext.Adults.Remove(adultToRemove);
dbContext.SaveChanges();
}
}
public async Task AddAdultAsync(Adult adultToAdd)
{
using (AdultDbContext context = new AdultDbContext())
{
Console.WriteLine("inainte");
await context.Adults.AddAsync(adultToAdd);
Console.WriteLine("dupa");
await context.SaveChangesAsync();
}
}
private static void Seed(AdultDbContext adbc)
{
FileContext fileContext = new FileContext();
IList <Adult> adults = new List <Adult>();
adults = fileContext.Adults;
adbc.Add(adults);
adbc.SaveChanges();
}
public static void Main(string[] args)
{
CreateHostBuilder(args).Build().Run();
using (AdultDbContext adbc = new AdultDbContext())
{
if (!adbc.Adults.Any())
{
Seed(adbc);
}
}
}
public async Task <Adult> UpdateAdultAsync(Adult updatedAdult)
{
using (AdultDbContext dbContext = new AdultDbContext())
{
await RemoveAdultAsync(updatedAdult.Id);
await AddAdultAsync(updatedAdult);
dbContext.SaveChanges();
}
return(updatedAdult);
}
public async Task AddAdultAsync(Adult adult)
{
using (AdultDbContext dbContext = new AdultDbContext())
{
Job job = await dbContext.Jobs.FirstOrDefaultAsync(j => j.Id == adult.JobTitle.Id);
adult.JobTitle = job;
await dbContext.Adults.AddAsync(adult);
await dbContext.SaveChangesAsync();
}
}
public async Task <IList <Adult> > ReadAllAdultsAsync(int?id, string?firstName, string?sex)
{
using (AdultDbContext context = new AdultDbContext())
{
IList <Adult> adults = context.Adults.ToList();
if (id != null)
{
adults = adults.Where(adult => adult.Id == id).ToList();
}
if (firstName != null)
{
adults = adults.Where(adult => adult.FirstName.Equals(firstName)).ToList();
}
if (sex != null)
{
adults = adults.Where(adult => adult.Sex.Equals(sex)).ToList();
}
if (id != null && firstName != null)
{
adults = adults.Where(adult => adult.Id == id && adult.FirstName.Equals(firstName)).ToList();
}
if (sex != null && firstName != null)
{
adults = adults.Where(adult => adult.Sex.Equals(sex) && adult.FirstName.Equals(firstName)).ToList();
}
if (id != null && firstName != null && sex != null)
{
adults = adults.Where(adult => adult.Id == id && adult.FirstName.Equals(firstName) && adult.Sex.Equals(sex)).ToList();
}
return(adults);
}
}
public async Task <List <Adult> > GetAdultsAsync()
{
using AdultDbContext dbContext = new AdultDbContext();
return(dbContext.Adults.Include(a => a.JobTitle).ToList());
}
public SqliteAdultsService(AdultDbContext ctx)
{
this.ctx = ctx;
}
public Repository(AdultDbContext adultDbContext)
{
_context = adultDbContext;
}
public async Task <List <Job> > GetJobsAsync()
{
using AdultDbContext dbContext = new AdultDbContext();
return(dbContext.Jobs.ToList());
}
public async Task <Adult> GetAdultByIdAsync(int id)
{
using AdultDbContext dbContext = new AdultDbContext();
return(dbContext.Adults.Include(a => a.JobTitle).FirstOrDefault(a => a.Id == id));
}
public UserRepoImpl()
{
DbContext = new AdultDbContext();
}
public AdultRepoImpl()
{
DbContext = new AdultDbContext();
}
