public virtual IEnumerable <TEntity> Get(Expression <Func <TEntity, bool> > filter = null)
{
IQueryable <TEntity> query = context.Set <TEntity>();
if (filter != null)
{
query = query.Where(filter);
}
return(query.ToList());
}
public async Task <bool> Delete(int id)
{
using (ToDoDbContext context = _contextFactory.CreateDbContext())
{
T entity = await context.Set <T>().FirstOrDefaultAsync((entity) => entity.Id == id);
context.Set <T>().Remove(entity);
await context.SaveChangesAsync();
return(true);
}
}
public async Task <IEnumerable <T> > GetAll()
{
using (ToDoDbContext context = _contextFactory.CreateDbContext())
{
IEnumerable <T> entities = await context.Set <T>().ToListAsync();
return(entities);
}
}
public async Task <T> Get(int id)
{
using (ToDoDbContext context = _contextFactory.CreateDbContext())
{
T entity = await context.Set <T>().FirstOrDefaultAsync((entity) => entity.Id == id);
return(entity);
}
}
public async Task <T> Create(T entity)
{
using (ToDoDbContext context = _contextFactory.CreateDbContext())
{
var result = await context.Set <T>().AddAsync(entity);
await context.SaveChangesAsync();
return(result.Entity);
}
}
public async Task <T> Update(int id, T entity)
{
using (ToDoDbContext context = _contextFactory.CreateDbContext())
{
entity.Id = id;
context.Set <T>().Update(entity);
await context.SaveChangesAsync();
return(entity);
}
}
public async Task <IEnumerable <T> > GetAllAsync()
{
return(await _context.Set <T>().ToListAsync());
}
/// <summary>
/// ctor.
/// </summary>
/// <param name="dbContext"></param>
public Repository(ToDoDbContext dbContext)
{
_dbContext = dbContext;
dbSet = _dbContext.Set <T>();
}
/// <summary>
/// Fetches All todo's from database
/// </summary>
/// <returns></returns>
public IQueryable <ToDo> GetAllToDos()
{
return(_toDoDbContext.Set <ToDo>());
}
public List <ToDoDto> GetAll() => _context.Set <ToDoEntity>().ToList().Select(item => new ToDoDto(item)).ToList();
public async Task <int> Update(T entity)
{
_dbContext.Set <T>().Attach(entity);
_dbContext.Entry(entity).State = EntityState.Modified;
return(await Save());
}
public GenericRepo(ToDoDbContext dbContext)
{
_dbContext = dbContext;
_table = _dbContext.Set <T>();
}
