/// <summary>
/// Update Member
/// </summary>
/// <param name="membershipAddViewModel"></param>
/// <returns></returns>
public MembershipAddViewModel UpdateMembership(MembershipAddViewModel membershipAddViewModel)
{
try
{
var memeberShipData = this.context?.Membership.FirstOrDefault(x => x.TenantId == membershipAddViewModel.membership.TenantId && x.SchoolId == membershipAddViewModel.membership.SchoolId && x.MembershipId == membershipAddViewModel.membership.MembershipId);
if (memeberShipData != null)
{
var checkProfile = this.context?.Membership.Where(x => x.SchoolId == membershipAddViewModel.membership.SchoolId && x.TenantId == membershipAddViewModel.membership.TenantId && x.MembershipId != membershipAddViewModel.membership.MembershipId && x.Profile.ToLower() == membershipAddViewModel.membership.Profile.ToLower() && x.IsActive == true).FirstOrDefault();
if (checkProfile != null)
{
membershipAddViewModel._failure = true;
membershipAddViewModel._message = "Profile Title Already Exists";
}
else
{
//if (membershipAddViewModel.membership.ProfileType.ToLower().ToString() == "Super Administrator")
//{
// membershipAddViewModel.membership.IsSuperadmin = true;
//}
//else
//{
// membershipAddViewModel.membership.IsSuperadmin = false;
//}
membershipAddViewModel.membership.ProfileType = memeberShipData.ProfileType;
membershipAddViewModel.membership.IsActive = true;
membershipAddViewModel.membership.IsSystem = false;
membershipAddViewModel.membership.CreatedBy = memeberShipData.CreatedBy;
membershipAddViewModel.membership.CreatedOn = memeberShipData.CreatedOn;
membershipAddViewModel.membership.UpdatedOn = DateTime.UtcNow;
this.context.Entry(memeberShipData).CurrentValues.SetValues(membershipAddViewModel.membership);
this.context?.SaveChanges();
membershipAddViewModel._failure = false;
membershipAddViewModel._message = "Membership Updated Successfully";
}
}
else
{
membershipAddViewModel.membership = null;
membershipAddViewModel._failure = true;
membershipAddViewModel._message = NORECORDFOUND;
}
}
catch (Exception ex)
{
membershipAddViewModel._failure = true;
membershipAddViewModel._message = ex.Message;
}
return(membershipAddViewModel);
}
public ActionResult <MembershipAddViewModel> DeleteMembership(MembershipAddViewModel membershipAddViewModel)
{
MembershipAddViewModel membershipDelete = new MembershipAddViewModel();
try
{
membershipDelete = _membershipService.DeleteMembership(membershipAddViewModel);
}
catch (Exception es)
{
membershipDelete._failure = true;
membershipDelete._message = es.Message;
}
return(membershipDelete);
}
public ActionResult <MembershipAddViewModel> AddMembership(MembershipAddViewModel membershipAddViewModel)
{
MembershipAddViewModel MembershipAdd = new MembershipAddViewModel();
try
{
MembershipAdd = _membershipService.AddMembership(membershipAddViewModel);
}
catch (Exception es)
{
MembershipAdd._failure = true;
MembershipAdd._message = es.Message;
}
return(MembershipAdd);
}
/// <summary>
/// Update Member
/// </summary>
/// <param name="membershipAddViewModel"></param>
/// <returns></returns>
public MembershipAddViewModel UpdateMembership(MembershipAddViewModel membershipAddViewModel)
{
MembershipAddViewModel MembershipUpdateModel = new MembershipAddViewModel();
try
{
if (TokenManager.CheckToken(membershipAddViewModel._tenantName + membershipAddViewModel._userName, membershipAddViewModel._token))
{
MembershipUpdateModel = this.membershipRepository.UpdateMembership(membershipAddViewModel);
}
else
{
MembershipUpdateModel._failure = true;
MembershipUpdateModel._message = TOKENINVALID;
}
}
catch (Exception es)
{
MembershipUpdateModel._failure = true;
MembershipUpdateModel._message = es.Message;
}
return(MembershipUpdateModel);
}
/// <summary>
/// Delete Membership
/// </summary>
/// <param name="membershipAddViewModel"></param>
/// <returns></returns>
public MembershipAddViewModel DeleteMembership(MembershipAddViewModel membershipAddViewModel)
{
try
{
var memeberShipData = this.context?.Membership.FirstOrDefault(x => x.TenantId == membershipAddViewModel.membership.TenantId && x.SchoolId == membershipAddViewModel.membership.SchoolId && x.MembershipId == membershipAddViewModel.membership.MembershipId);
if (memeberShipData != null)
{
var userData = this.context?.UserMaster.Where(x => x.TenantId == membershipAddViewModel.membership.TenantId && x.SchoolId == membershipAddViewModel.membership.SchoolId && x.MembershipId == membershipAddViewModel.membership.MembershipId && x.IsActive == true).ToList();
if (userData.Count > 0)
{
membershipAddViewModel._failure = true;
membershipAddViewModel._message = "Membership Cannot Be Deleted, Because It Has Association";
}
else
{
memeberShipData.IsActive = false;
this.context?.SaveChanges();
membershipAddViewModel._failure = false;
membershipAddViewModel._message = "Membership Deleted Successfully";
}
}
else
{
membershipAddViewModel._message = NORECORDFOUND;
membershipAddViewModel._failure = true;
}
}
catch (Exception es)
{
membershipAddViewModel._failure = true;
membershipAddViewModel._message = es.Message;
}
return(membershipAddViewModel);
}
/// <summary>
/// Add Member
/// </summary>
/// <param name="membershipAddViewModel"></param>
/// <returns></returns>
public MembershipAddViewModel AddMembership(MembershipAddViewModel membershipAddViewModel)
{
List <RolePermission> rolePermissionList = new List <RolePermission>();
try
{
var memberShipData = this.context?.Membership.FirstOrDefault(c => c.SchoolId == membershipAddViewModel.membership.SchoolId && c.TenantId == membershipAddViewModel.membership.TenantId && c.ProfileType.ToLower() == membershipAddViewModel.membership.ProfileType.ToLower());
if (memberShipData != null)
{
var checkProfile = this.context?.Membership.Where(x => x.SchoolId == membershipAddViewModel.membership.SchoolId && x.TenantId == membershipAddViewModel.membership.TenantId && x.Profile.ToLower() == membershipAddViewModel.membership.Profile.ToLower() && x.IsActive == true).FirstOrDefault();
if (checkProfile != null)
{
membershipAddViewModel._failure = true;
membershipAddViewModel._message = "Profile Already Exists";
}
else
{
int?MembershipId = 1;
var MembershipData = this.context?.Membership.Where(x => x.SchoolId == membershipAddViewModel.membership.SchoolId && x.TenantId == membershipAddViewModel.membership.TenantId).OrderByDescending(x => x.MembershipId).FirstOrDefault();
if (MembershipData != null)
{
MembershipId = MembershipData.MembershipId + 1;
}
if (membershipAddViewModel.membership.ProfileType.ToLower().ToString() == "Super Administrator")
{
membershipAddViewModel.membership.IsSuperadmin = true;
}
else
{
membershipAddViewModel.membership.IsSuperadmin = false;
}
var rollPermissionData = this.context.RolePermission.Where(e => e.TenantId == memberShipData.TenantId && e.SchoolId == memberShipData.SchoolId && e.MembershipId == memberShipData.MembershipId).ToList();
if (rollPermissionData != null)
{
int?rolePermissionId = 1;
var rolePermissionIdData = this.context?.RolePermission.Where(x => x.TenantId == memberShipData.TenantId && x.SchoolId == memberShipData.SchoolId).OrderByDescending(x => x.RolePermissionId).FirstOrDefault();
if (rolePermissionIdData != null)
{
rolePermissionId = rolePermissionIdData.RolePermissionId + 1;
}
foreach (var rolePermission in rollPermissionData)
{
var rolePermissions = new RolePermission
{
TenantId = rolePermission.TenantId,
SchoolId = rolePermission.SchoolId,
RolePermissionId = (int)rolePermissionId,
PermissionCategoryId = rolePermission.PermissionCategoryId,
CanView = rolePermission.CanView,
CanEdit = rolePermission.CanEdit,
CanAdd = rolePermission.CanAdd,
CanDelete = rolePermission.CanDelete,
CreatedBy = membershipAddViewModel.membership.CreatedBy,
CreatedOn = DateTime.UtcNow,
MembershipId = MembershipId,
PermissionSubcategoryId = rolePermission.PermissionSubcategoryId,
PermissionGroupId = rolePermission.PermissionGroupId,
};
this.context.RolePermission.Add(rolePermissions);
rolePermissionId++;
}
}
membershipAddViewModel.membership.IsActive = true;
membershipAddViewModel.membership.IsSystem = false;
membershipAddViewModel.membership.MembershipId = (int)MembershipId;
membershipAddViewModel.membership.CreatedOn = DateTime.UtcNow;
this.context?.Membership.Add(membershipAddViewModel.membership);
this.context?.SaveChanges();
membershipAddViewModel._failure = false;
membershipAddViewModel._message = "Membership Added Successfully";
}
}
else
{
membershipAddViewModel._failure = true;
membershipAddViewModel._message = "Membership Type Not Found";
}
}
catch (Exception es)
{
membershipAddViewModel._message = es.Message;
membershipAddViewModel._failure = true;
}
return(membershipAddViewModel);
}
