public virtual async Task <List <T> > GetAllItemsAsync()
{
using (var dbContext = new SwipeITDBContext())
{
return(await dbContext.Set <T>().ToListAsync());
}
}
public virtual async Task <T> GetItemAsync(int id)
{
using (var dbContext = new SwipeITDBContext())
{
return(await dbContext.FindAsync <T>(id));
}
}
public async Task <List <Skill> > GetAllUserCreatedSkillsAsync()
{
using (var dbContext = new SwipeITDBContext())
{
return(await dbContext.Skills.Where(x => x.IsCreatedByUser == true)
.ToListAsync());
}
}
public virtual async Task <bool> AddItemAsync(T item)
{
using (var dbContext = new SwipeITDBContext())
{
dbContext.Update(item);
await dbContext.SaveChangesAsync();
}
return(true);
}
public virtual async Task <bool> UpdateItemsAsync(IEnumerable <T> items)
{
using (var dbContext = new SwipeITDBContext())
{
dbContext.UpdateRange(items);
await dbContext.SaveChangesAsync();
}
return(true);
}
public virtual async Task <bool> DeleteItemAsync(int id)
{
using (var dbContext = new SwipeITDBContext())
{
var item = await GetItemAsync(id);
dbContext.Remove(item);
await dbContext.SaveChangesAsync();
}
return(true);
}
public override async Task <List <Developer> > GetAllItemsAsync()
{
using (var dbContext = new SwipeITDBContext())
{
return(await dbContext.Developers.Include(x => x.Skills)
.Include(x => x.AvailableLocations)
.Include(x => x.Recruiters)
.Include(x => x.DateLog)
.ToListAsync());
}
}
public override async Task <Developer> GetItemAsync(int id)
{
using (var dbContext = new SwipeITDBContext())
{
return(await dbContext.Developers.Include(x => x.Skills)
.Include(x => x.AvailableLocations)
.Include(x => x.Recruiters)
.Include(x => x.DateLog)
.FirstOrDefaultAsync(x => x.Id == id));
}
}
