/// <summary>
/// Get All Permission Group
/// </summary>
/// <param name="permissionGroupListViewModel"></param>
/// <returns></returns>
public PermissionGroupListViewModel GetAllPermissionGroup(PermissionGroupListViewModel permissionGroupListViewModel)
{
PermissionGroupListViewModel permissionGroupListView = new PermissionGroupListViewModel();
try
{
var permission = this.context?.PermissionGroup.Where(x => x.TenantId == permissionGroupListViewModel.TenantId && x.SchoolId == permissionGroupListViewModel.SchoolId);
permissionGroupListView.permissionGroupList = permission.ToList();
permissionGroupListView._token = permissionGroupListViewModel._token;
if (permission.Count() > 0)
{
permissionGroupListView._failure = false;
permissionGroupListView._message = "Permission Group List Fetched";
}
else
{
permissionGroupListView._failure = true;
permissionGroupListView._message = NORECORDFOUND;
}
}
catch (Exception ex)
{
permissionGroupListView._message = ex.Message;
permissionGroupListView._failure = true;
}
return(permissionGroupListView);
}
public ActionResult <PermissionGroupListViewModel> UpdateRolePermission(PermissionGroupListViewModel permissionGroupListViewModel)
{
PermissionGroupListViewModel rolePermissionUpdate = new PermissionGroupListViewModel();
try
{
rolePermissionUpdate = _roleBasedAccessService.UpdateRolePermission(permissionGroupListViewModel);
}
catch (Exception es)
{
rolePermissionUpdate._failure = true;
rolePermissionUpdate._message = es.Message;
}
return(rolePermissionUpdate);
}
public ActionResult <PermissionGroupListViewModel> GetAllPermissionGroup(PermissionGroupListViewModel permissionGroupListViewModel)
{
PermissionGroupListViewModel permissionGroupListView = new PermissionGroupListViewModel();
try
{
permissionGroupListView = _roleBasedAccessService.GetAllPermissionGroup(permissionGroupListViewModel);
}
catch (Exception es)
{
permissionGroupListView._failure = true;
permissionGroupListView._message = es.Message;
}
return(permissionGroupListView);
}
/// <summary>
/// Get All Permission Group
/// </summary>
/// <param name="permissionGroupListViewModel"></param>
/// <returns></returns>
public PermissionGroupListViewModel GetAllPermissionGroup(PermissionGroupListViewModel permissionGroupListViewModel)
{
PermissionGroupListViewModel permissionGroupListView = new PermissionGroupListViewModel();
try
{
if (TokenManager.CheckToken(permissionGroupListViewModel._tenantName + permissionGroupListViewModel._userName, permissionGroupListViewModel._token))
{
permissionGroupListView = this.roleBasedAccessRepository.GetAllPermissionGroup(permissionGroupListViewModel);
}
else
{
permissionGroupListView._failure = true;
permissionGroupListView._message = TOKENINVALID;
}
}
catch (Exception es)
{
permissionGroupListView._failure = true;
permissionGroupListView._message = es.Message;
}
return(permissionGroupListView);
}
/// <summary>
/// Update Role Permission
/// </summary>
/// <param name="permissionGroupListViewModel"></param>
/// <returns></returns>
public PermissionGroupListViewModel UpdateRolePermission(PermissionGroupListViewModel permissionGroupListViewModel)
{
PermissionGroupListViewModel rolePermissionUpdate = new PermissionGroupListViewModel();
try
{
if (TokenManager.CheckToken(permissionGroupListViewModel._tenantName + permissionGroupListViewModel._userName, permissionGroupListViewModel._token))
{
rolePermissionUpdate = this.roleBasedAccessRepository.UpdateRolePermission(permissionGroupListViewModel);
}
else
{
rolePermissionUpdate._failure = true;
rolePermissionUpdate._message = TOKENINVALID;
}
}
catch (Exception es)
{
rolePermissionUpdate._failure = true;
rolePermissionUpdate._message = es.Message;
}
return(rolePermissionUpdate);
}
/// <summary>
/// Update Role Permission
/// </summary>
/// <param name="permissionGroupListViewModel"></param>
/// <returns></returns>
public PermissionGroupListViewModel UpdateRolePermission(PermissionGroupListViewModel permissionGroupListViewModel)
{
using var transaction = context.Database.BeginTransaction(System.Data.IsolationLevel.Serializable);
PermissionGroupListViewModel PermissionGroupViewModel = new PermissionGroupListViewModel();
try
{
foreach (PermissionGroup p_group in permissionGroupListViewModel.permissionGroupList)
{
if (p_group.RolePermission.ToList().Count() > 0 && p_group.RolePermission != null)
{
var PermissionGroup = this.context?.RolePermission.FirstOrDefault(x => x.TenantId == p_group.TenantId && x.SchoolId == p_group.SchoolId && x.PermissionGroupId == p_group.PermissionGroupId && x.RolePermissionId == p_group.RolePermission.FirstOrDefault().RolePermissionId&& x.MembershipId == p_group.RolePermission.FirstOrDefault().MembershipId);
if (PermissionGroup != null)
{
PermissionGroup.CanAdd = p_group.RolePermission.FirstOrDefault().CanAdd;
PermissionGroup.CanEdit = p_group.RolePermission.FirstOrDefault().CanEdit;
PermissionGroup.CanDelete = p_group.RolePermission.FirstOrDefault().CanDelete;
PermissionGroup.CanView = p_group.RolePermission.FirstOrDefault().CanView;
this.context?.SaveChanges();
}
else
{
int?AutoId = 1;
var rolePermissionData = this.context?.RolePermission.Where(x => x.SchoolId == p_group.SchoolId && x.TenantId == p_group.TenantId).OrderByDescending(x => x.RolePermissionId).FirstOrDefault();
if (rolePermissionData != null)
{
AutoId = rolePermissionData.RolePermissionId + 1;
}
p_group.RolePermission.FirstOrDefault().RolePermissionId = (int)AutoId;
p_group.RolePermission.FirstOrDefault().PermissionSubcategoryId = null;
p_group.RolePermission.FirstOrDefault().PermissionCategoryId = null;
p_group.RolePermission.FirstOrDefault().CreatedBy = permissionGroupListViewModel.CreatedBy;
p_group.RolePermission.FirstOrDefault().CreatedOn = DateTime.UtcNow;
this.context?.RolePermission.Add(p_group.RolePermission.FirstOrDefault());
this.context?.SaveChanges();
}
if (p_group.PermissionCategory.Count() > 0 && p_group.PermissionCategory != null)
{
foreach (PermissionCategory p_cat in p_group.PermissionCategory)
{
if (p_cat.RolePermission.ToList().Count() > 0 && p_cat.RolePermission != null)
{
var PermissionCatagoary = this.context?.RolePermission.FirstOrDefault(x => x.TenantId == p_cat.TenantId && x.SchoolId == p_cat.SchoolId && x.PermissionCategoryId == p_cat.PermissionCategoryId && x.RolePermissionId == p_cat.RolePermission.FirstOrDefault().RolePermissionId&& x.MembershipId == p_cat.RolePermission.FirstOrDefault().MembershipId);
if (PermissionCatagoary != null)
{
PermissionCatagoary.CanAdd = p_cat.RolePermission.FirstOrDefault().CanAdd;
PermissionCatagoary.CanEdit = p_cat.RolePermission.FirstOrDefault().CanEdit;
PermissionCatagoary.CanDelete = p_cat.RolePermission.FirstOrDefault().CanDelete;
PermissionCatagoary.CanView = p_cat.RolePermission.FirstOrDefault().CanView;
this.context?.SaveChanges();
}
else
{
int?AutoId = 1;
var rolePermissionData = this.context?.RolePermission.Where(x => x.SchoolId == p_cat.SchoolId && x.TenantId == p_cat.TenantId).OrderByDescending(x => x.RolePermissionId).FirstOrDefault();
if (rolePermissionData != null)
{
AutoId = rolePermissionData.RolePermissionId + 1;
}
p_cat.RolePermission.FirstOrDefault().RolePermissionId = (int)AutoId;
p_cat.RolePermission.FirstOrDefault().PermissionGroupId = null;
p_cat.RolePermission.FirstOrDefault().PermissionSubcategoryId = null;
p_cat.CreatedBy = permissionGroupListViewModel.CreatedBy;
p_cat.CreatedOn = DateTime.UtcNow;
this.context?.RolePermission.Add(p_cat.RolePermission.FirstOrDefault());
this.context?.SaveChanges();
}
if (p_cat.PermissionSubcategory.Count() > 0 && p_cat.PermissionSubcategory != null)
{
foreach (PermissionSubcategory p_subcat in p_cat.PermissionSubcategory)
{
foreach (RolePermission roleper in p_subcat.RolePermission)
{
var PermissionSubCatagory = this.context?.RolePermission.FirstOrDefault(x => x.TenantId == roleper.TenantId && x.SchoolId == roleper.SchoolId && x.RolePermissionId == roleper.RolePermissionId && x.PermissionSubcategoryId == roleper.PermissionSubcategoryId && x.MembershipId == roleper.MembershipId);
if (PermissionSubCatagory != null)
{
PermissionSubCatagory.CanAdd = roleper.CanAdd;
PermissionSubCatagory.CanEdit = roleper.CanEdit;
PermissionSubCatagory.CanDelete = roleper.CanDelete;
PermissionSubCatagory.CanView = roleper.CanView;
this.context?.SaveChanges();
}
else
{
int?AutoId = 1;
var rolePermissionData = this.context?.RolePermission.Where(x => x.SchoolId == roleper.SchoolId && x.TenantId == roleper.TenantId).OrderByDescending(x => x.RolePermissionId).FirstOrDefault();
if (rolePermissionData != null)
{
AutoId = rolePermissionData.RolePermissionId + 1;
}
roleper.RolePermissionId = (int)AutoId;
roleper.PermissionGroupId = null;
roleper.PermissionCategoryId = null;
roleper.CreatedBy = permissionGroupListViewModel.CreatedBy;
roleper.CreatedOn = DateTime.UtcNow;
this.context?.RolePermission.Add(roleper);
this.context?.SaveChanges();
}
}
}
}
}
}
}
}
}
transaction.Commit();
PermissionGroupViewModel.permissionGroupList = permissionGroupListViewModel.permissionGroupList;
PermissionGroupViewModel._failure = false;
PermissionGroupViewModel._message = "UPDATE SUCCESSFUL";
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
return(PermissionGroupViewModel);
}
