private List <DOADM_AccessGroupMaster> GetAccessGroupSearchResult(string AccessGroupName = "", string AccessGroupDescription = "", bool IsActive = true)
{
long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
BLAccessGroup objBLAccessGroup = new BLAccessGroup();
DOADM_AccessGroupMaster objDOADM_AccessGroupMaster = new DOADM_AccessGroupMaster();
objDOADM_AccessGroupMaster.AccessGroupName = AccessGroupName;
objDOADM_AccessGroupMaster.AccessGroupDescription = AccessGroupDescription;
objDOADM_AccessGroupMaster.IsActive = IsActive;
List <DOADM_AccessGroupMaster> lstDOADM_AccessGroupMaster = new List <DOADM_AccessGroupMaster>();
try
{
ExceptionTypes result = objBLAccessGroup.GetAccessGroupBasedOnSearch(TimeZone, objDOADM_AccessGroupMaster, out lstDOADM_AccessGroupMaster);
if (result != (long)ExceptionTypes.Success)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, string.Empty, "error while retriving search results");
}
return(lstDOADM_AccessGroupMaster);
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
return(null);
}
}
public ActionResult Save(UIDOAccessGroup objUIDOAccessGroup)
{
string errorMessage = string.Empty;
string returnMessage = string.Empty;
ExceptionTypes result = new ExceptionTypes();
try
{
//check if this call is to update record or save new record
if (objUIDOAccessGroup.ADM_AccessGroupMasterId > 0)
{
//if old record is to be updated
BLCommon objCommon = new BLCommon();
//check if record is locked by current user
if (!objCommon.ValidateLockBeforeSave(currentUser.ADM_UserMasterId, (long)ScreenType.AccessGroup, objUIDOAccessGroup.ADM_AccessGroupMasterId))
{
//if record is not locked by current user dont save record and return error.
errorMessage = "Record not locked, please reload the page.";
result = ExceptionTypes.UnknownError;
return(Json(new { ID = result, Message = errorMessage }));
}
returnMessage = "Record updated successfully.";
}
else
{
//If new record to be saved
returnMessage = "Record saved successfully.";
}
objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation = new List <DOADM_AccessGroupSkillsCorrelation>();
objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation = new List <DOADM_AccessGroupReportCorrelation>();
if (Session[ConstantTexts.AccessGroupSkillSessionKey] != null)
{
objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation = Session[ConstantTexts.AccessGroupSkillSessionKey] as List <DOADM_AccessGroupSkillsCorrelation>;
}
if (Session[ConstantTexts.AccessGroupReportSessionKey] != null)
{
objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation = Session[ConstantTexts.AccessGroupReportSessionKey] as List <DOADM_AccessGroupReportCorrelation>;
}
BLAccessGroup objBLAccessGroup = new BLAccessGroup();
result = objBLAccessGroup.AddEditAccessGroup(currentUser.ADM_UserMasterId, objUIDOAccessGroup, out errorMessage);
if (result != (long)ExceptionTypes.Success)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage);
return(Json(new { ID = result, Message = "An error occured while updating DB." }));
}
Session[ConstantTexts.AccessGroupSkillSessionKey] = null;
Session[ConstantTexts.AccessGroupReportSessionKey] = null;
return(Json(new { ID = result, Message = returnMessage }));
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
return(RedirectToAction("Maintenance", "Error", new { Error = MethodBase.GetCurrentMethod().Name + " Action terminated and redirected to Maintenance. Error:" + ex.ToString() }));
}
}
private void AddAccessGroups(DOADM_UserMaster objDOADM_UserMaster)
{
long? TimeZone = (long)DefaultTimeZone.CentralStandardTime;
BLAccessGroup objBLAccessGroup = new BLAccessGroup();
//get List of Access groups to be added
List <DOADM_AccessGroupMaster> lstDOADM_AccessGroupMaster;
objBLAccessGroup.GetAccessGroupBasedOnSearch(TimeZone, new DOADM_AccessGroupMaster {
AccessGroupName = ConstantTexts.MIIMAccessGroupSearchKey, IsActive = true
}, out lstDOADM_AccessGroupMaster);
if (lstDOADM_AccessGroupMaster.Count > 0)
{
foreach (DOADM_AccessGroupMaster objDOADM_AccessGroupMaster in lstDOADM_AccessGroupMaster)
{
DOADM_AccessGroupUserCorrelation objDOADM_AccessGroupUserCorrelation = new DOADM_AccessGroupUserCorrelation();
objDOADM_AccessGroupUserCorrelation.IsActive = true;
objDOADM_AccessGroupUserCorrelation.ADM_AccessGroupMasterRef = objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId;
objDOADM_AccessGroupUserCorrelation.ADM_UserMasterRef = 0;
objDOADM_AccessGroupUserCorrelation.CreatedByRef = _currentLoginUserId;
objDOADM_AccessGroupUserCorrelation.UTCCreatedOn = DateTime.UtcNow;
objDOADM_AccessGroupUserCorrelation.LastUpdatedByRef = _currentLoginUserId;
objDOADM_AccessGroupUserCorrelation.UTCLastUpdatedOn = DateTime.UtcNow;
objDOADM_UserMaster.lstDOADM_AccessGroupUserCorrelation.Add(objDOADM_AccessGroupUserCorrelation);
}
}
}
public ActionResult Add(long ADM_AccessGroupMasterId = 0, bool isActive = true)
{
try
{
long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
Session[ConstantTexts.AccessGroupSkillSessionKey] = null;
Session[ConstantTexts.AccessGroupReportSessionKey] = null;
ViewBag.RoleList = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Role);
ViewBag.WorkBasketList = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.WorkBasket);
ViewBag.Reports = ViewBag.Reports = CacheUtility.GetAllReportsFromCache(null, "");
UIDOAccessGroup objUIDOAccessGroup = new UIDOAccessGroup();
objUIDOAccessGroup.IsActive = true;
objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation = new List <DOADM_AccessGroupSkillsCorrelation>();
objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation = new List <DOADM_AccessGroupReportCorrelation>();
if (ADM_AccessGroupMasterId != 0)
{
DOADM_AccessGroupMaster objDOADM_AccessGroupMaster = new DOADM_AccessGroupMaster();
BLAccessGroup objBLAccessGroup = new BLAccessGroup();
objDOADM_AccessGroupMaster.ADM_AccessGroupMasterId = ADM_AccessGroupMasterId;
objDOADM_AccessGroupMaster.IsActive = isActive;
ExceptionTypes result = objBLAccessGroup.GetAccessGroupForEdit(objDOADM_AccessGroupMaster, out objUIDOAccessGroup);
Session[ConstantTexts.AccessGroupSkillSessionKey] = objUIDOAccessGroup.lstDOADM_AccessGroupSkillsCorrelation;
Session[ConstantTexts.AccessGroupReportSessionKey] = objUIDOAccessGroup.lstDOADM_AccessGroupReportCorrelation;
DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster();
List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>();
BLSkills objBLSkills = new BLSkills();
objDOADM_SkillsMaster.IsActive = true;
objDOADM_SkillsMaster.WorkBasketLkup = objUIDOAccessGroup.WorkBasketLkup;
objDOADM_SkillsMaster.RoleLkup = objUIDOAccessGroup.RoleLkup;
ExceptionTypes result1 = objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out string errorMesssage);
ViewBag.Skills = lstDOADM_SkillsMaster.Where(x => x.IsActive == true).ToList();
}
return(View(objUIDOAccessGroup));
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
return(RedirectToAction("Maintenance", "Error", new { Error = MethodBase.GetCurrentMethod().Name + " Action terminated and redirected to Maintenance. Error:" + ex.ToString() }));
}
}
public ActionResult CheckExistsAccessGroup(string accessGroupsName)
{
string strErrorMessage = string.Empty;
string strMessage = string.Empty;
bool accessGroupExists = false;
try
{
long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime;
BLAccessGroup _objBLAccessGroups = new BLAccessGroup();
DOADM_AccessGroupMaster objDOADM_AccessGroupMaster = new DOADM_AccessGroupMaster();
objDOADM_AccessGroupMaster.AccessGroupName = accessGroupsName;
objDOADM_AccessGroupMaster.IsActive = true;
List <DOADM_AccessGroupMaster> lstDOADM_AccessGroupsMaster;
ExceptionTypes result = _objBLAccessGroups.GetAccessGroupBasedOnSearch(TimeZone, objDOADM_AccessGroupMaster, out lstDOADM_AccessGroupsMaster);
if (lstDOADM_AccessGroupsMaster.Count > 0)
{
accessGroupExists = true;
}
else
{
objDOADM_AccessGroupMaster.IsActive = false;//search again to check for not active records
result = _objBLAccessGroups.GetAccessGroupBasedOnSearch(TimeZone, objDOADM_AccessGroupMaster, out lstDOADM_AccessGroupsMaster);
if (lstDOADM_AccessGroupsMaster.Count > 0)
{
accessGroupExists = true;
}
else
{
accessGroupExists = false;
}
}
}
catch (Exception ex)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
return(RedirectToAction("Maintenance", "Error", new { Error = MethodBase.GetCurrentMethod().Name + " Action terminated and redirected to Maintenance. Error:" + ex.ToString() }));
}
return(Json(new { accessGroupExists = accessGroupExists, strMessage = strMessage }, JsonRequestBehavior.AllowGet));
}
