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)); } }