public void addUserRole(Edit userRole) { DBHelper._UserRole dbhelp_useRole = new DBHelper._UserRole(); var newUserRole = new UserRole() { Name = userRole.Name, CompanyId = userRole.CompanyId, DeletedFlag = false }; int newUserRoleId = dbhelp_useRole.Add(newUserRole); DBHelper._UserRolePermission dbhelp_useRolePermission = new DBHelper._UserRolePermission(); List <UserRolePermission> userRolePermissionList = new List <UserRolePermission>(); foreach (int permissionCatalogId in userRole.PermissionCatalogId) { var newUserRolePermission = new UserRolePermission() { UserRoleID = newUserRoleId, PermissionCatalogID = permissionCatalogId }; userRolePermissionList.Add(newUserRolePermission); } dbhelp_useRolePermission.AddManyRows(userRolePermissionList); }
public void deleteUserRolePermission(int id) { DBHelper._UserRolePermission dbhelp = new DBHelper._UserRolePermission(); UserRolePermission existingUserRolePermission = dbhelp.GetByid(id); dbhelp.Delete(existingUserRolePermission); }
public void updateUserRolePermission(int id, Edit userRolePermission) { DBHelper._UserRolePermission dbhelp = new DBHelper._UserRolePermission(); UserRolePermission existingUserRolePermission = dbhelp.GetByid(id); existingUserRolePermission.PermissionCatalogID = userRolePermission.PermissionCatalogId; existingUserRolePermission.UserRoleID = userRolePermission.UserRoleId; dbhelp.Update(existingUserRolePermission); }
public void addUserRolePermission(Edit userRolePermission) { DBHelper._UserRolePermission dbhelp = new DBHelper._UserRolePermission(); var newUserRolePermission = new UserRolePermission() { UserRoleID = userRolePermission.UserRoleId, PermissionCatalogID = userRolePermission.PermissionCatalogId }; dbhelp.Add(newUserRolePermission); }
public List <Detail> GetAllUserRolePermissionByUserRoleId(int userRoleId) { DBHelper._UserRolePermission dbhelp = new DBHelper._UserRolePermission(); return(dbhelp.GetAllByUserRoleId(userRoleId).Select(s => new Detail() { Id = s.Id, UserRoleId = s.UserRole.Id, UserRoleName = s.UserRole.Name, PermissionCatalogId = s.PermissionCatalog.Id, PermissionCatalogName = s.PermissionCatalog.Name, PermissionDescription = s.PermissionCatalog.Description }).ToList <Detail>()); }
public void updateUserRole(int id, Edit userRole) { DBHelper._UserRole dbhelp_useRole = new DBHelper._UserRole(); UserRole existingUserRole = dbhelp_useRole.GetByid(id); existingUserRole.Name = userRole.Name; existingUserRole.CompanyId = userRole.CompanyId; dbhelp_useRole.Update(existingUserRole); DBHelper._UserRolePermission dbhelp_useRolePermission = new DBHelper._UserRolePermission(); List <UserRolePermission> existingPermissionList = dbhelp_useRolePermission.GetAllByUserRoleIdIncludeDelete(id); List <UserRolePermission> insertPermissionList = new List <UserRolePermission>(); List <int> existingPermissionIdList = new List <int>(); if (existingPermissionList.Count > 0) { foreach (var eurp in existingPermissionList) { if (userRole.PermissionCatalogId == null || (!userRole.PermissionCatalogId.Contains(eurp.PermissionCatalogID) && !eurp.DeletedFlag)) { eurp.DeletedFlag = true; } else if (userRole.PermissionCatalogId.Contains(eurp.PermissionCatalogID) && eurp.DeletedFlag) { eurp.DeletedFlag = false; } existingPermissionIdList.Add(eurp.PermissionCatalogID); } dbhelp_useRolePermission.UpdateManyRows(existingPermissionList); } if (userRole.PermissionCatalogId != null) { foreach (var permissionCatalogId in userRole.PermissionCatalogId) { if (existingPermissionList.Count == 0 || (permissionCatalogId > 0 && !existingPermissionIdList.Contains(permissionCatalogId))) { var newUserRolePermissio = new UserRolePermission() { UserRoleID = id, PermissionCatalogID = permissionCatalogId }; insertPermissionList.Add(newUserRolePermissio); } } dbhelp_useRolePermission.AddManyRows(insertPermissionList); } }
public Detail getUserRolePermissionById(int id) { DBHelper._UserRolePermission dbhelp = new DBHelper._UserRolePermission(); UserRolePermission userRolePermission = dbhelp.GetByid(id); return(new Detail() { Id = userRolePermission.Id, UserRoleId = userRolePermission.UserRole.Id, UserRoleName = userRolePermission.UserRole.Name, PermissionCatalogId = userRolePermission.PermissionCatalog.Id, PermissionCatalogName = userRolePermission.PermissionCatalog.Name, PermissionDescription = userRolePermission.PermissionCatalog.Description }); }