private void GetCurrentUserRolesPermissions()
{
using (AppraisalConnectionDataContext _apprsaisalctxt = new AppraisalConnectionDataContext()) {
List <AppraisalApproverModel> _user = (from a in _apprsaisalctxt.zib_appraisal_user_roles
join t in _apprsaisalctxt.zib_appraisal_link_role_permissions on a.roleid equals t.role_id
join x in _apprsaisalctxt.zib_appraisal_user_permissions on t.permission_id equals x.permission_id
where a.employee_number == this.employee_number
select new AppraisalApproverModel {
StaffName = a.name,
StaffNumber = a.employee_number,
RoleTitle = a.role,
RoleID = a.roleid,
Permission_ID = x.permission_id,
PermissionDescription = x.permission_description
}).ToList();
if (_user != null)
{
//this.employee_number = _user.First().StaffNumber;
foreach (AppraisalApproverModel user in _user)
{
UserRole _userRole = new UserRole {
Role_Id = user.RoleID, RoleName = user.RoleTitle
};
_userRole.Permissions.Add(new RolePermission {
Permission_Id = user.Permission_ID, PermissionDescription = user.PermissionDescription
});
this.Roles.Add(_userRole);
}
}
}
}
private void GetDatabaseUserRolesPermissions()
{
//Get user roles and permissions from database tables...
using (AppraisalConnectionDataContext _data = new AppraisalConnectionDataContext()) {
UserXXX _user = (from d in _data.zib_appraisal_user_roles
select new UserXXX {
entrykey = d.entrykey,
roleid = d.roleid.ToString(),
role = d.role,
username = d.username,
name = d.name,
status = d.status,
description = d.description,
employee_number = d.employee_number
}
).Where(u => u.username == this.Username).FirstOrDefault();
/*if (_user != null) {
* this.employee_number = _user.employee_number;
* foreach (Role _role in _user.roleid) {
* UserRole _userRole
* = new UserRole { Role_Id = _role.Id,
* RoleName = _role.RoleName
* };
* foreach (Permission _permission in _role.Permissions) {
* _userRole.Permissions.Add(new RolePermission {
* Permission_Id = _permission.Id,
* PermissionDescription = _permission.PermissionDescription });
* }
* this.Roles.Add(_userRole);
*
* if (!this.IsSystemAdmin)
* this.IsSystemAdmin = _role.IsSysAdmin;
* }
* }*/
}
}
