public async Task <TResult> QueryAsync <TEntity, TResult>(Func <IQueryable <TEntity>, Task <TResult> > queryBuilder) where TEntity : EntityBase { using var appDbContext = _appDbContextFactory.Create(); var dbSet = appDbContext.Set <TEntity>().AsNoTracking(); var result = await queryBuilder(dbSet); return(result); }
public async Task <List <TaskTypeModel> > GetTaskTypes(int userId) { using (var dbContext = _dbContextFactory.Create()) { return(await dbContext.TaskTypes .Where(tt => tt.UserId == userId) .ProjectToTaskTypeModel() .OrderBy(c => c.Name) .ToListAsync()); } }
public async Task UpdateTask(TaskModel model) { using (var db = _dbContextFactory.Create()) { var dbTask = await db.LifeTasks.FindAsync(model.Id); dbTask = _lifeTaskMappingService.PopulateLifeTaskFromModel(model, dbTask); await db.SaveChangesAsync(); } }
public async Task UpdateTaskType(TaskTypeModel model) { using (var db = _dbContextFactory.Create()) { var taskType = await db.TaskTypes.FindAsync(model.Id); taskType = _lifeTaskMappingService.PopulateTaskTypeFromModel(model, taskType); await db.SaveChangesAsync(); } }
public async Task <RecurringTaskModel> GetProjectedRecurringTask(int id) { using (var db = _dbContextFactory.Create()) { var dbTask = await db.RecurringTasks .Where(lt => lt.Id == id) .ProjectToRecurringTaskModel() .FirstOrDefaultAsync(); return(dbTask); } }
public IUnitOfWork Create() { var dbContext = _dbContextFactory.Create(); var unitOfWork = _container.GetInstance <UnitOfWork>(); unitOfWork.Initialize(dbContext); return(unitOfWork); }
public async Task <LifeTask> GetTask(int id) { using (var db = _dbContextFactory.Create()) { var dbTask = await db.LifeTasks.FindAsync(id); return(dbTask); } }
public async Task AddRecurringTask(RecurringTaskModel model, int userId) { using (var db = _dbContextFactory.Create()) { var recurringTask = new RecurringTask(); recurringTask = _lifeTaskMappingService.PopulateRecurringTaskFromModel(model, recurringTask, userId); db.RecurringTasks.Add(recurringTask); await db.SaveChangesAsync(); } }
public void LatheIn() { using (AppDbContext db = factory.Create()) { //...use db } }