public async Task <List <AppRole> > GetRolesByUserNameAsync(string userName)
{
using var context = new WorksJwtContext();
return(await context.AppUsers.Join(context.AppUserRoles, u => u.Id, ur => ur.AppUserId, (user, userRole) => new
{
user = user,
userRole = userRole
}).Join(context.AppRoles, two => two.userRole.AppRoleId, r => r.Id, (twoTable, role) => new
{
user = twoTable.user,
userRole = twoTable.userRole,
role = role
}).Where(x => x.user.UserName == userName).Select(x => new AppRole {
Id = x.role.Id,
Name = x.role.Name
}).ToListAsync());
}
public async Task <TEntity> GetByIdAsync(int id)
{
using WorksJwtContext context = new WorksJwtContext();
return(await context.Set <TEntity>().FindAsync(id));
}
public async Task <TEntity> GetByFilterAsync(Expression <Func <TEntity, bool> > filter)
{
using WorksJwtContext context = new WorksJwtContext();
return(await context.Set <TEntity>().FirstOrDefaultAsync(filter));
}
public async Task <List <TEntity> > GetAllByFilterAsync(Expression <Func <TEntity, bool> > filter)
{
using WorksJwtContext context = new WorksJwtContext();
return(await context.Set <TEntity>().Where(filter).ToListAsync());
}
public async Task <List <TEntity> > GetAllAsync()
{
using WorksJwtContext context = new WorksJwtContext();
return(await context.Set <TEntity>().ToListAsync());
}
public async Task DeleteAsync(TEntity entity)
{
using WorksJwtContext context = new WorksJwtContext();
context.Set <TEntity>().Remove(entity);
await context.SaveChangesAsync();
}
public async Task InsertAsync(TEntity entity)
{
using WorksJwtContext context = new WorksJwtContext();
context.Set <TEntity>().Add(entity);
await context.SaveChangesAsync();
}
