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