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 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); } }