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