public List<DataLayer.Entities.User.RefreshTokens> Get()
{
using (DataLayer.EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
return authContext.RefreshTokens.ToList();
}
}
public DataLayer.Entities.User.IdentityClients GetByID(string clientId)
{
using (EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
DataLayer.Entities.User.IdentityClients client = authContext.IdentityClients.Find(clientId);
return client;
}
}
public async Task<bool> Delete(DataLayer.Entities.User.RefreshTokens refreshToken)
{
using (DataLayer.EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
authContext.RefreshTokens.Remove(refreshToken);
return await authContext.SaveChangesAsync() > 0;
}
}
public async Task<DataLayer.Entities.User.RefreshTokens> GetByID(string refreshTokenId)
{
using (DataLayer.EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
DataLayer.Entities.User.RefreshTokens refreshToken = await authContext.RefreshTokens.FindAsync(refreshTokenId);
return refreshToken;
}
}
public List<IdentityRole> Get()
{
List<IdentityRole> roles;
using (DataLayer.EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
roles = (from r in authContext.Roles select r).ToList();
}
return roles;
}
public async Task<bool> Delete(string refreshTokenId)
{
using (DataLayer.EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
var refreshToken = await authContext.RefreshTokens.FindAsync(refreshTokenId);
if (refreshToken != null)
{
authContext.RefreshTokens.Remove(refreshToken);
return await authContext.SaveChangesAsync() > 0;
}
}
return false;
}
public async Task<bool> Insert(DataLayer.Entities.User.RefreshTokens refreshToken)
{
bool returnValue;
using (DataLayer.EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
DataLayer.Entities.User.RefreshTokens existingToken = authContext.RefreshTokens.Where(rt => rt.subject == refreshToken.subject && rt.clientId == refreshToken.clientId).SingleOrDefault();
if (existingToken != null)
{
bool result = await Delete(existingToken.refreshTokenId);
}
authContext.RefreshTokens.Add(refreshToken);
returnValue = await authContext.SaveChangesAsync() > 0;
}
return returnValue;
}
public async Task<IdentityRole> Insert(string roleName)
{
IdentityRole newRole = new IdentityRole();
newRole.Name = roleName;
using (DataLayer.EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
authContext.Roles.Add(newRole);
await authContext.SaveChangesAsync();
}
if (!string.IsNullOrEmpty(newRole.Id))
{
return newRole;
}
return null;
}
public async Task<List<string>> DeleteClaimsRoles(string roleId, int claimId)
{
List<string> errors = new List<string>();
int deletedCount = 0;
try
{
using (DataLayer.EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
DataLayer.Entities.User.ClaimsRoles claimsRole = await authContext.ClaimsRoles.FirstAsync(cr => cr.claimId == claimId && cr.roleId == roleId);
if (claimsRole != null)
{
authContext.ClaimsRoles.Remove(claimsRole);
deletedCount = await authContext.SaveChangesAsync();
if (deletedCount <= 0)
{
errors.Add("Error deleting ClaimRole object, ClaimID: " + claimId.ToString() + ", RoleID: " + roleId.ToString());
}
}
}
}
catch (DbEntityValidationException ex)
{
errors.Add(ex.ToString());
}
return errors;
}
public async Task<List<DataLayer.Entities.User.ClaimsRoles>> GetClaimsRoles()
{
List<DataLayer.Entities.User.ClaimsRoles> claimsRoles;
using (DataLayer.EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
claimsRoles = await authContext.ClaimsRoles.ToListAsync();
}
return claimsRoles;
}
public async Task<List<string>> InsertClaimRoles(string roleId, int claimId)
{
var errors = new List<string>();
DataLayer.Entities.User.ClaimsRoles claimRole = new DataLayer.Entities.User.ClaimsRoles { roleId = roleId, claimId = claimId };
try
{
using (DataLayer.EFDbContext.AuthorizationContext authContext = new EFDbContext.AuthorizationContext())
{
authContext.ClaimsRoles.Add(claimRole);
await authContext.SaveChangesAsync();
}
}
catch (DbEntityValidationException ex)
{
errors.Add(ex.ToString());
}
return errors;
}
