public static bool UpdateRole(RoleViewModel _modifiedRole)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
ApplicationRole _role2Modify = db.Roles.Where(p => p.Id == _modifiedRole.Id).Include("PERMISSIONS").FirstOrDefault();
db.Entry(_role2Modify).Entity.Name = _modifiedRole.Name;
db.Entry(_role2Modify).Entity.RoleDescription = _modifiedRole.RoleDescription;
db.Entry(_role2Modify).Entity.IsSysAdmin = _modifiedRole.IsSysAdmin;
db.Entry(_role2Modify).Entity.LastModified = System.DateTime.Now;
db.Entry(_role2Modify).State = EntityState.Modified;
db.SaveChanges();
_retVal = true;
}
}
catch (Exception)
{
}
return(_retVal);
}
public static bool UpdateUser(UserViewModel _user)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
ApplicationUser _user2Modify = GetUser(db, _user.Id);
db.Entry(_user2Modify).Entity.UserName = _user.UserName;
db.Entry(_user2Modify).Entity.Email = _user.Email;
db.Entry(_user2Modify).Entity.Firstname = _user.Firstname;
db.Entry(_user2Modify).Entity.Lastname = _user.Lastname;
db.Entry(_user2Modify).Entity.LastModified = System.DateTime.Now;
db.Entry(_user2Modify).State = EntityState.Modified;
db.SaveChanges();
_retVal = true;
}
}
catch (Exception ex)
{
string x = ex.Message;
}
return(_retVal);
}
public static bool RemoveUser4Role(int _userId, int _roleId)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
ApplicationUser _user = GetUser(db, _userId);
if (_user.Roles.Where(p => p.RoleId == _roleId).Count() > 0)
{
_user.Roles.Remove(_user.Roles.Where(p => p.RoleId == _roleId).FirstOrDefault());
_user.LastModified = DateTime.Now;
db.Entry(_user).State = EntityState.Modified;
db.SaveChanges();
_retVal = true;
}
}
}
catch (Exception)
{
}
return(_retVal);
}
public static bool AddUser2Role(int _userId, int _roleId)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
ApplicationUser _user = GetUser(db, _userId);
if (_user.Roles.Where(p => p.RoleId == _roleId).Count() == 0)
{
//_user.UserRoles.Add(_role);
ApplicationUserRole _identityRole = new ApplicationUserRole {
UserId = _userId, RoleId = _roleId
};
if (!_user.Roles.Contains(_identityRole))
{
_user.Roles.Add(_identityRole);
}
_user.LastModified = DateTime.Now;
db.Entry(_user).State = EntityState.Modified;
db.SaveChanges();
_retVal = true;
}
}
}
catch (Exception)
{
}
return(_retVal);
}
public static bool RemovePermission4Role(int _roleId, int _permissionId)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
ApplicationRole _role2Modify = db.Roles.Where(p => p.Id == _roleId).Include("PERMISSIONS").FirstOrDefault();
PERMISSION _permission = db.PERMISSIONS.Where(p => p.PermissionId == _permissionId).Include("ROLES").FirstOrDefault();
if (_role2Modify.PERMISSIONS.Contains(_permission))
{
_role2Modify.PERMISSIONS.Remove(_permission);
_role2Modify.LastModified = DateTime.Now;
db.Entry(_role2Modify).State = EntityState.Modified;
db.SaveChanges();
_retVal = true;
}
}
}
catch (Exception)
{
throw;
}
return(_retVal);
}
public static bool AddPermission2Role(int _roleId, int _permissionId)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
ApplicationRole role = db.Roles.Where(p => p.Id == _roleId).Include("PERMISSIONS").FirstOrDefault();
if (role != null)
{
PERMISSION _permission = db.PERMISSIONS.Where(p => p.PermissionId == _permissionId).Include("ROLES").FirstOrDefault();
if (!role.PERMISSIONS.Contains(_permission))
{
role.PERMISSIONS.Add(_permission);
role.LastModified = DateTime.Now;
db.Entry(role).State = EntityState.Modified;
db.SaveChanges();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(_retVal);
}
public static bool AddAllPermissions2Role(int _roleId)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
ApplicationRole role = db.Roles.Where(p => p.Id == _roleId).Include("PERMISSIONS").FirstOrDefault();
if (role != null)
{
List <PERMISSION> _permissions = db.PERMISSIONS.Include("ROLES").ToList();
foreach (PERMISSION _permission in _permissions)
{
if (!role.PERMISSIONS.Contains(_permission))
{
role.PERMISSIONS.Add(_permission);
}
}
role.LastModified = DateTime.Now;
db.Entry(role).State = EntityState.Modified;
db.SaveChanges();
_retVal = true;
}
}
}
catch
{
}
return(_retVal);
}
public static ApplicationUser GetUser(GovHistoryDbContext db, int _userId)
{
ApplicationUser _retVal = null;
try
{
_retVal = db.Users.Where(p => p.Id == _userId).Include("Roles").Include(x => x.Roles.Select(r => r.Role.PERMISSIONS)).FirstOrDefault();
}
catch (Exception)
{
}
return(_retVal);
}
public static List <PERMISSION> GetPermissions()
{
List <PERMISSION> _retVal = null;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
_retVal = db.PERMISSIONS.OrderBy(p => p.PermissionDescription).Include("ROLES").ToList();
}
}
catch (Exception)
{
}
return(_retVal);
}
public static PERMISSION GetPermission(int _permissionid)
{
PERMISSION _retVal = null;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
_retVal = db.PERMISSIONS.Where(p => p.PermissionId == _permissionid).Include("ROLES").FirstOrDefault();
}
}
catch (Exception)
{
}
return(_retVal);
}
internal static int GetPermissionsCount()
{
int _retVal = 0;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
_retVal = db.PERMISSIONS.OrderBy(p => p.PermissionDescription).Count();
}
}
catch (Exception)
{
throw;
}
return(_retVal);
}
internal static List <PERMISSION> GetPermissions(int start, int limit)
{
List <PERMISSION> _retVal = null;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
_retVal = db.PERMISSIONS.OrderBy(p => p.PermissionDescription).Include("ROLES").OrderByDescending(c => c.PermissionId).Skip(start).Take(limit).ToList();
}
}
catch (Exception)
{
throw;
}
return(_retVal);
}
public static List <ApplicationUser> GetUsers4Surname(string _surname)
{
List <ApplicationUser> _retVal = null;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
_retVal = db.Users.Where(r => r.Inactive == false || r.Inactive == null & r.Lastname == _surname).OrderBy(r => r.Lastname).ThenBy(r => r.Firstname).ToList();
}
}
catch (Exception)
{
}
return(_retVal);
}
public static List <ApplicationRole> GetRoles4SelectList()
{
List <ApplicationRole> _retVal = null;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
_retVal = db.Roles.OrderBy(p => p.Name).ToList();
}
}
catch (Exception)
{
}
return(_retVal);
}
public static List <ApplicationUser> GetUsers4SelectList()
{
List <ApplicationUser> _retVal = null;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
_retVal = db.Users.Where(r => r.Inactive == false || r.Inactive == null).ToList();
}
}
catch (Exception)
{
}
return(_retVal);
}
public static bool UpdatePermission(PERMISSION _permission)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
db.Entry(_permission).State = EntityState.Modified;
db.SaveChanges();
_retVal = true;
}
}
catch (Exception)
{
}
return(_retVal);
}
public static List <ApplicationUser> GetUsers(int start, int limit)
{
List <ApplicationUser> _retVal = null;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
_retVal = db.Users.OrderBy(r => r.Lastname).ThenBy(r => r.Firstname).Skip(start).Take(limit).ToList();
}
}
catch (Exception)
{
throw;
}
return(_retVal);
}
public static bool DeletePermission(int _permissionId)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
PERMISSION _permission = db.PERMISSIONS.Where(p => p.PermissionId == _permissionId).Include("ROLES").FirstOrDefault();
_permission.ROLES.Clear();
db.Entry(_permission).State = EntityState.Deleted;
db.SaveChanges();
_retVal = true;
}
}
catch (Exception)
{
}
return(_retVal);
}
public static bool DeleteRole(int _roleId)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
ApplicationRole _role2Delete = db.Roles.Where(p => p.Id == _roleId).Include("PERMISSIONS").FirstOrDefault();
if (_role2Delete != null)
{
_role2Delete.PERMISSIONS.Clear();
db.Entry(_role2Delete).State = EntityState.Deleted;
db.SaveChanges();
_retVal = true;
}
}
}
catch (Exception)
{
}
return(_retVal);
}
public static bool DeleteUser(int _userId)
{
bool _retVal = false;
try
{
using (GovHistoryDbContext db = new GovHistoryDbContext())
{
//ApplicationUser _user = db.Users.Where(p => p.Id == _userId).Include("ROLES").FirstOrDefault();
ApplicationUser _user = GetUser(db, _userId);
_user.Roles.Clear();
db.Entry(_user).State = EntityState.Deleted;
db.SaveChanges();
_retVal = true;
}
}
catch (Exception)
{
}
return(_retVal);
}
public ApplicationRoleStore(GovHistoryDbContext context)
: base(context)
{
}