public async Task <IEnumerable <T> > GetAll()
{
using (RatDbContext context = _contextFactory.CreateDbContext())
{
IEnumerable <T> entities = await context.Set <T>().ToListAsync();
return(entities);
}
}
public async Task <T> Get(int id)
{
using (RatDbContext context = _contextFactory.CreateDbContext())
{
T entity = await context.Set <T>().FirstOrDefaultAsync((e) => e.Id == id);
return(entity);
}
}
public async Task <T> Update(int id, T entity)
{
using (RatDbContext context = _contextFactory.CreateDbContext())
{
entity.Id = id;
context.Set <T>().Update(entity);
await context.SaveChangesAsync();
return(entity);
}
}
public async Task <T> Create(T entity)
{
using (RatDbContext context = _contextFactory.CreateDbContext())
{
var createdEntity = await context.Set <T>().AddAsync(entity);
await context.Set <T>().AddAsync(entity);
return(createdEntity.Entity);
}
}
public async Task <bool> Delete(int id)
{
using (RatDbContext context = _contextFactory.CreateDbContext())
{
T entity = await context.Set <T>().FirstOrDefaultAsync((e) => e.Id == id);
context.Set <T>().Remove(entity);
await context.SaveChangesAsync();
return(true);
}
}
private static void AddUser(RatDbContext context)
{
var user = context.Users.FirstOrDefault(x => x.UserId == TestUserProvider.UserId);
if (user == null)
{
context.Users.Add(new UserEntity {
UserId = TestUserProvider.UserId
});
context.SaveChanges();
}
}
private static void AddProjectType(RatDbContext context, string name)
{
var projectType = context.ProjectTypes.FirstOrDefault(x => x.Name == name);
if (projectType == null)
{
context.ProjectTypes.Add(new ProjectTypeEntity {
Name = name
});
}
context.SaveChanges();
}
public DeleteProjectCommand(RatDbContext context)
{
_context = context;
}
public CreateProjectCommand(RatDbContext context)
{
_context = context;
}
public GetProjectByIdQuery(RatDbContext context)
{
_context = context;
}
public PatchProjectCommand(RatDbContext context)
{
_context = context;
}
public GetProjectsForUserQuery(RatDbContext context)
{
_context = context;
}
