public UserRolePermission Authorize(string UserID, string Url)
{
if (string.IsNullOrEmpty(UserID) || string.IsNullOrEmpty(Url))
{
throw new ArgumentException("User Or Url is Null or Empty!");
}
AuthorizationEntities context = AuthorizationEntities.CreateContext();
UserRolePermission result = (from rp in context.RolePermissions
join r in context.Roles on rp.RoleID equals r.RoleID
join p in context.Permissions on rp.PermissionID equals p.PermissionID
join u in context.UserRoles on r.RoleID equals u.RoleID
where u.UserID == UserID &&
p.URL == Url
select new UserRolePermission
{
UserID = u.UserID,
RoleID = r.RoleID,
RoleName = r.RoleName,
PermissionID = p.PermissionID,
PermissionName = p.PermissionName,
URL = p.URL
}).FirstOrDefault();
return(result);
}
public void AddRoles(Roles role)
{
Contract.NotNull(role, "role");
using (var context = AuthorizationEntities.CreateContext())
{
context.Roles.Add(role);
context.SaveChanges();
}
}
public void UpdateRoles(Roles role)
{
Contract.NotNull(role, "role");
using (var context = AuthorizationEntities.CreateContext())
{
context.Roles.Attach(role);
context.Entry(role).State = EntityState.Modified;
context.SaveChanges();
}
}
public List <UserRolePermission> GetRoles()
{
using (var context = AuthorizationEntities.CreateContext())
{
List <UserRolePermission> result = (from rp in context.RolePermissions
join r in context.Roles on rp.RoleID equals r.RoleID
join p in context.Permissions on rp.PermissionID equals p.PermissionID
select new UserRolePermission
{
UserID = null,
RoleID = r.RoleID,
RoleName = r.RoleName,
PermissionID = p.PermissionID,
PermissionName = p.PermissionName,
URL = p.URL
}).ToList <UserRolePermission>();
return(result);
}
}
