public ExceptionTypes SearchSkills(long?TimeZone, DOADM_SkillsMaster objDOADM_SkillsDetails, out List <DOADM_SkillsMaster> lstDOADM_SkillsMaster, out string errorMessage) { retValue = new ExceptionTypes(); DALSkills objDALResources = new DALSkills(); return(retValue = objDALResources.SearchSkills(TimeZone, objDOADM_SkillsDetails, out lstDOADM_SkillsMaster, out errorMessage)); }
public ExceptionTypes SaveSkills(DOADM_SkillsMaster objDOADM_SkillsMaster, long lLoginId, out string errorMessage) { retValue = new ExceptionTypes(); DALSkills objDALSkills = new DALSkills(); return(retValue = objDALSkills.AddSkills(objDOADM_SkillsMaster, lLoginId, out errorMessage)); }
private void GetSkillForEdit(long lSkillsID, bool isActive, out DOADM_SkillsMaster objDOADM_SkillsMaster) { long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; string errorMessage = string.Empty; ExceptionTypes result; List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>(); objDOADM_SkillsMaster = new DOADM_SkillsMaster(); try { objDOADM_SkillsMaster.ADM_SkillsMasterId = lSkillsID; objDOADM_SkillsMaster.IsActive = isActive; result = _objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, "error occured while retrving skill data", "error occured while retrving skill data"); } if (lstDOADM_SkillsMaster.Count > 0) { objDOADM_SkillsMaster = lstDOADM_SkillsMaster.FirstOrDefault(); } } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); } }
public ActionResult Search() { try { string strErrorMessage = string.Empty; BLSkills _objBLSkills = new BLSkills(); DOADM_SkillMasterExtended objDOADM_SkillMasterExtended = new DOADM_SkillMasterExtended(); objDOADM_SkillMasterExtended.lstRoles = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Role); objDOADM_SkillMasterExtended.lstBusinessSegment = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.BusinessSegment); objDOADM_SkillMasterExtended.lstDepartment = GetERSDepartments(); objDOADM_SkillMasterExtended.lstWorkBasket = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.WorkBasket); List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>(); DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster(); objDOADM_SkillsMaster.IsActive = true; long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; ExceptionTypes result = _objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out strErrorMessage); objDOADM_SkillMasterExtended.lstSkillsMaster = lstDOADM_SkillsMaster; return(View(objDOADM_SkillMasterExtended)); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(RedirectToAction("Maintenance", "Error", routeValues: ex.ToString())); } }
public ActionResult Add(long lSkillsID = 0, bool isActive = true) { string errorMessage = string.Empty; try { Session[ConstantTexts.SkillWorkQueueSessionKey] = null; DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster(); objDOADM_SkillsMaster.IsActive = true; ViewBag.Roles = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Role); ViewBag.BusinessSegment = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.BusinessSegment); ViewBag.WorkBasket = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.WorkBasket); ViewBag.lstDiscrepancyCategories = GetDiscrepancyCategories(); ViewBag.lstDepartments = GetERSDepartments(); if (lSkillsID != 0) { GetSkillForEdit(lSkillsID, isActive, out objDOADM_SkillsMaster); List <DOCMN_LookupMasterCorrelations> lstDOCMN_LookupMaster = CacheUtility.GetAllLookupMasterCorrelationFromCache((long)LookupTypesCorrelation.DiscripancyCategoryVQueue, objDOADM_SkillsMaster.DiscrepancyCategoryLkup); lstDOCMN_LookupMaster = lstDOCMN_LookupMaster.Where(x => x.CMN_LookupMasterParentRef == objDOADM_SkillsMaster.DiscrepancyCategoryLkup).ToList(); ViewBag.WorkQueues = lstDOCMN_LookupMaster; Session[ConstantTexts.SkillWorkQueueSessionKey] = objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation; objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation = objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation.Where(x => x.IsActive == true).ToList(); } return(View(objDOADM_SkillsMaster)); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(RedirectToAction("Maintenance", "Error", routeValues: ex.ToString())); } }
public ActionResult Add(DOADM_SkillsMaster objDOADM_SkillsMaster) { string errorMessage = string.Empty; string returnMessage = string.Empty; ExceptionTypes result = new ExceptionTypes(); try { string sreturnMessage = string.Empty; if (objDOADM_SkillsMaster.ADM_SkillsMasterId > 0) { BLCommon objCommon = new BLCommon(); if (!objCommon.ValidateLockBeforeSave(currentUser.ADM_UserMasterId, (long)ScreenType.Skills, objDOADM_SkillsMaster.ADM_SkillsMasterId)) { errorMessage = "Record not locked, please reload the page."; result = ExceptionTypes.UnknownError; return(Json(new { ID = result, Message = errorMessage })); } objDOADM_SkillsMaster.LastUpdatedByRef = currentUser.ADM_UserMasterId; sreturnMessage = "Record updated successfully."; } else { objDOADM_SkillsMaster.CreatedByRef = currentUser.ADM_UserMasterId; sreturnMessage = "Record saved successfully."; } BLSkills _objBLSkills = new BLSkills(); if (Session[ConstantTexts.SkillWorkQueueSessionKey] != null) { objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation = Session[ConstantTexts.SkillWorkQueueSessionKey] as List <DOADM_SkillWorkQueuesCorrelation>; } result = _objBLSkills.SaveSkills(objDOADM_SkillsMaster, currentUser.ADM_UserMasterId, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); return(Json(new { ID = result, Message = "An error occured while updating DB." })); } Session[ConstantTexts.SkillWorkQueueSessionKey] = null; return(Json(new { ID = result, Message = sreturnMessage })); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(Json(new { ID = result, Message = "An error occured while updating DB." })); } }
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() })); } }
private static void GetAllSkillsIfNoCache() { long?TimeZone = (long)DefaultTimeZone.CentralStandardTime; if (System.Web.HttpContext.Current.Cache[ConstantTexts.SkillCacheKey] == null) { BLSkills objBLSkills = new BLSkills(); List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>(); DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster(); objDOADM_SkillsMaster.IsActive = true; string errorMessage; ExceptionTypes skillResult = objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out errorMessage); if (skillResult != ExceptionTypes.Success) { //Log } AddToCache(ConstantTexts.SkillCacheKey, lstDOADM_SkillsMaster); } }
public ActionResult Search(string SkillsName = "", long RoleLkup = 0, long BusinessSegmentLkup = 0, long CMN_DepartmentRef = 0, long WorkBasketLkup = 0, bool isActive = true) { try { BLSkills _objBLSkills = new BLSkills(); DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster(); List <DOADM_SkillsMaster> lstDOADM_SkillsMaster; string errorMessage = string.Empty; objDOADM_SkillsMaster.IsActive = isActive; objDOADM_SkillsMaster.SkillsName = SkillsName; objDOADM_SkillsMaster.RoleLkup = RoleLkup; objDOADM_SkillsMaster.BusinessSegmentLkup = BusinessSegmentLkup; objDOADM_SkillsMaster.CMN_DepartmentRef = CMN_DepartmentRef; objDOADM_SkillsMaster.WorkBasketLkup = WorkBasketLkup; long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; ExceptionTypes result = _objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, "error while retriving search results", "error while retriving search results"); } else if (result == ExceptionTypes.ZeroRecords) { lstDOADM_SkillsMaster.Add(objDOADM_SkillsMaster); lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>(); } DOADM_SkillMasterExtended objDOADM_SkillMasterExtended = new DOADM_SkillMasterExtended(); objDOADM_SkillMasterExtended.lstRoles = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Role); objDOADM_SkillMasterExtended.lstBusinessSegment = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.BusinessSegment); objDOADM_SkillMasterExtended.lstDepartment = GetERSDepartments(); objDOADM_SkillMasterExtended.lstWorkBasket = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.WorkBasket); objDOADM_SkillMasterExtended.lstSkillsMaster = lstDOADM_SkillsMaster; return(PartialView("_SearchResults", objDOADM_SkillMasterExtended)); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(RedirectToAction("Maintenance", "Error", routeValues: ex.ToString())); } }
public ActionResult CheckSkillExistsUsingSkillName(string skillsName) { long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; string strErrorMessage = string.Empty; string strMessage = string.Empty; bool skillExists = false; try { BLSkills _objBLSkills = new BLSkills(); DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster(); objDOADM_SkillsMaster.SkillsName = skillsName; objDOADM_SkillsMaster.IsActive = true; List <DOADM_SkillsMaster> lstDOADM_SkillsMaster; ExceptionTypes result = _objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out strErrorMessage); if (lstDOADM_SkillsMaster.Count > 0) { skillExists = true; } else { objDOADM_SkillsMaster.IsActive = false;//search again to check for not active records result = _objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out strErrorMessage); if (lstDOADM_SkillsMaster.Count > 0) { skillExists = true; } else { skillExists = false; } } } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (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 { skillExists = skillExists, strMessage = strMessage }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetSkillsBasedOnRoleAndWB(long lWorkBasketLkup, long lRoleLkup) { long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; string errorMessage = string.Empty; try { DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster(); List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>(); BLSkills objBLSkills = new BLSkills(); objDOADM_SkillsMaster.WorkBasketLkup = lWorkBasketLkup; objDOADM_SkillsMaster.RoleLkup = lRoleLkup; objDOADM_SkillsMaster.IsActive = true; objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out errorMessage); return(Json(lstDOADM_SkillsMaster)); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(RedirectToAction("Maintenance", "Error", routeValues: ex.ToString())); } }
public ActionResult AddSkillsToSession(DOADM_AccessGroupSkillsCorrelation objDOADM_AccessGroupSkillsCorrelation, long lPreviousSkill = 0, long lWorkBasketLkup = 0, long lRoleLkup = 0, int mode = 0) { long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; List <DOADM_AccessGroupSkillsCorrelation> lstDOADM_AccessGroupSkillsCorrelation = new List <DOADM_AccessGroupSkillsCorrelation>(); try { DOADM_AccessGroupSkillsCorrelation objOldDOADM_AccessGroupSkillsCorrelation = new DOADM_AccessGroupSkillsCorrelation(); if (Session[ConstantTexts.AccessGroupSkillSessionKey] != null) { lstDOADM_AccessGroupSkillsCorrelation = Session[ConstantTexts.AccessGroupSkillSessionKey] as List <DOADM_AccessGroupSkillsCorrelation>; } switch (mode) { case 0: //Add new skill to the list if (lstDOADM_AccessGroupSkillsCorrelation.Where(xx => xx.ADM_SkillsMasterRef == objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef).Count() == 0) { objDOADM_AccessGroupSkillsCorrelation.IsActive = true; objDOADM_AccessGroupSkillsCorrelation.CreatedByRef = currentUser.ADM_UserMasterId; objDOADM_AccessGroupSkillsCorrelation.CreatedByName = currentUser.FullName; objDOADM_AccessGroupSkillsCorrelation.UTCCreatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); objDOADM_AccessGroupSkillsCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId; objDOADM_AccessGroupSkillsCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); objDOADM_AccessGroupSkillsCorrelation.LastUpdatedByName = currentUser.FullName; lstDOADM_AccessGroupSkillsCorrelation.Add(objDOADM_AccessGroupSkillsCorrelation); } else { objOldDOADM_AccessGroupSkillsCorrelation = lstDOADM_AccessGroupSkillsCorrelation.Where(xx => xx.ADM_SkillsMasterRef == objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef).FirstOrDefault(); objOldDOADM_AccessGroupSkillsCorrelation.CanCreate = objDOADM_AccessGroupSkillsCorrelation.CanCreate; objOldDOADM_AccessGroupSkillsCorrelation.CanClone = objDOADM_AccessGroupSkillsCorrelation.CanClone; objOldDOADM_AccessGroupSkillsCorrelation.CanHistory = objDOADM_AccessGroupSkillsCorrelation.CanHistory; objOldDOADM_AccessGroupSkillsCorrelation.CanMassUpdate = objDOADM_AccessGroupSkillsCorrelation.CanMassUpdate; objOldDOADM_AccessGroupSkillsCorrelation.CanModify = objDOADM_AccessGroupSkillsCorrelation.CanModify; objOldDOADM_AccessGroupSkillsCorrelation.CanReassign = objDOADM_AccessGroupSkillsCorrelation.CanReassign; objOldDOADM_AccessGroupSkillsCorrelation.CanReopen = objDOADM_AccessGroupSkillsCorrelation.CanReopen; objOldDOADM_AccessGroupSkillsCorrelation.CanSearch = objDOADM_AccessGroupSkillsCorrelation.CanSearch; objOldDOADM_AccessGroupSkillsCorrelation.CanUnlock = objDOADM_AccessGroupSkillsCorrelation.CanUnlock; objOldDOADM_AccessGroupSkillsCorrelation.CanUpload = objDOADM_AccessGroupSkillsCorrelation.CanUpload; objOldDOADM_AccessGroupSkillsCorrelation.CanView = objDOADM_AccessGroupSkillsCorrelation.CanView; objOldDOADM_AccessGroupSkillsCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId; objOldDOADM_AccessGroupSkillsCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); objDOADM_AccessGroupSkillsCorrelation.LastUpdatedByName = currentUser.FullName; objOldDOADM_AccessGroupSkillsCorrelation.IsActive = true; } break; case 1: //delete skill from added list if (lstDOADM_AccessGroupSkillsCorrelation.Where(xx => xx.ADM_SkillsMasterRef == objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef).Count() > 0) { objDOADM_AccessGroupSkillsCorrelation = lstDOADM_AccessGroupSkillsCorrelation.Where(xx => xx.ADM_SkillsMasterRef == objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef).FirstOrDefault(); objDOADM_AccessGroupSkillsCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId; objDOADM_AccessGroupSkillsCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); objDOADM_AccessGroupSkillsCorrelation.IsActive = false; } break; case 2: //update existing skill objOldDOADM_AccessGroupSkillsCorrelation = lstDOADM_AccessGroupSkillsCorrelation.Where(x => x.ADM_SkillsMasterRef == lPreviousSkill).FirstOrDefault(); if (objOldDOADM_AccessGroupSkillsCorrelation.ADM_AccessGroupSkillsCorrelationId == 0) //updating a queue for new record { objOldDOADM_AccessGroupSkillsCorrelation.CreatedByRef = currentUser.ADM_UserMasterId; } objOldDOADM_AccessGroupSkillsCorrelation.CanCreate = objDOADM_AccessGroupSkillsCorrelation.CanCreate; objOldDOADM_AccessGroupSkillsCorrelation.CanClone = objDOADM_AccessGroupSkillsCorrelation.CanClone; objOldDOADM_AccessGroupSkillsCorrelation.CanHistory = objDOADM_AccessGroupSkillsCorrelation.CanHistory; objOldDOADM_AccessGroupSkillsCorrelation.CanMassUpdate = objDOADM_AccessGroupSkillsCorrelation.CanMassUpdate; objOldDOADM_AccessGroupSkillsCorrelation.CanModify = objDOADM_AccessGroupSkillsCorrelation.CanModify; objOldDOADM_AccessGroupSkillsCorrelation.CanReassign = objDOADM_AccessGroupSkillsCorrelation.CanReassign; objOldDOADM_AccessGroupSkillsCorrelation.CanReopen = objDOADM_AccessGroupSkillsCorrelation.CanReopen; objOldDOADM_AccessGroupSkillsCorrelation.CanSearch = objDOADM_AccessGroupSkillsCorrelation.CanSearch; objOldDOADM_AccessGroupSkillsCorrelation.CanUnlock = objDOADM_AccessGroupSkillsCorrelation.CanUnlock; objOldDOADM_AccessGroupSkillsCorrelation.CanUpload = objDOADM_AccessGroupSkillsCorrelation.CanUpload; objOldDOADM_AccessGroupSkillsCorrelation.CanView = objDOADM_AccessGroupSkillsCorrelation.CanView; objOldDOADM_AccessGroupSkillsCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId; objOldDOADM_AccessGroupSkillsCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); objOldDOADM_AccessGroupSkillsCorrelation.LastUpdatedByName = currentUser.FullName; objOldDOADM_AccessGroupSkillsCorrelation.IsActive = true; objOldDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef = objDOADM_AccessGroupSkillsCorrelation.ADM_SkillsMasterRef; break; case 3: //removing all the lists from Session foreach (var item in lstDOADM_AccessGroupSkillsCorrelation) { item.LastUpdatedByRef = currentUser.ADM_UserMasterId; item.UTCLastUpdatedOn = DateTime.UtcNow; item.IsActive = false; } break; } DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster(); List <DOADM_SkillsMaster> lstDOADM_SkillsMaster = new List <DOADM_SkillsMaster>(); BLSkills objBLSkills = new BLSkills(); objDOADM_SkillsMaster.WorkBasketLkup = lWorkBasketLkup; objDOADM_SkillsMaster.RoleLkup = lRoleLkup; objDOADM_SkillsMaster.IsActive = true; objBLSkills.SearchSkills(TimeZone, objDOADM_SkillsMaster, out lstDOADM_SkillsMaster, out string errorMessage); ViewBag.Skills = lstDOADM_SkillsMaster; Session[ConstantTexts.AccessGroupSkillSessionKey] = lstDOADM_AccessGroupSkillsCorrelation; return(PartialView("_Skills", lstDOADM_AccessGroupSkillsCorrelation.Where(xx => xx.IsActive == true).ToList())); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageAccessGroups, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(RedirectToAction("Maintenance", "Error", routeValues: ex.ToString())); } }
private void MapSkillsDOSkillsMaster(long?TimeZone, DataSet objDataTable, out List <DOADM_SkillsMaster> lstDOADM_SkillsDetails) { lstDOADM_SkillsDetails = new List <DOADM_SkillsMaster>(); try { foreach (DataRow dr in objDataTable.Tables[0].Rows) { DOADM_SkillsMaster objDOADM_SkillsMaster = new DOADM_SkillsMaster(); if (dr.Table.Columns.Contains("ADM_SkillsMasterId")) { if (!DBNull.Value.Equals(dr["ADM_SkillsMasterId"])) { objDOADM_SkillsMaster.ADM_SkillsMasterId = (long)dr["ADM_SkillsMasterId"]; } } if (dr.Table.Columns.Contains("SkillsName")) { if (!DBNull.Value.Equals(dr["SkillsName"])) { objDOADM_SkillsMaster.SkillsName = dr["SkillsName"].ToString(); } } if (dr.Table.Columns.Contains("RoleLkup")) { if (!DBNull.Value.Equals(dr["RoleLkup"])) { objDOADM_SkillsMaster.RoleLkup = (long)dr["RoleLkup"]; } } if (dr.Table.Columns.Contains("BusinessSegmentLkup")) { if (!DBNull.Value.Equals(dr["BusinessSegmentLkup"])) { objDOADM_SkillsMaster.BusinessSegmentLkup = (long)dr["BusinessSegmentLkup"]; } } if (dr.Table.Columns.Contains("DiscrepancyCategoryLkup")) { if (!DBNull.Value.Equals(dr["DiscrepancyCategoryLkup"])) { objDOADM_SkillsMaster.DiscrepancyCategoryLkup = (long)dr["DiscrepancyCategoryLkup"]; } } if (dr.Table.Columns.Contains("CMN_DepartmentRef")) { if (!DBNull.Value.Equals(dr["CMN_DepartmentRef"])) { objDOADM_SkillsMaster.CMN_DepartmentRef = (long)dr["CMN_DepartmentRef"]; } } if (dr.Table.Columns.Contains("WorkBasketLkup")) { if (!DBNull.Value.Equals(dr["WorkBasketLkup"])) { objDOADM_SkillsMaster.WorkBasketLkup = (long)dr["WorkBasketLkup"]; } } if (dr.Table.Columns.Contains("IsActive")) { if (!DBNull.Value.Equals(dr["IsActive"])) { objDOADM_SkillsMaster.IsActive = Convert.ToBoolean(dr["IsActive"]); } } if (dr.Table.Columns.Contains("UTCCreatedOn")) { if (!DBNull.Value.Equals(dr["UTCCreatedOn"])) { objDOADM_SkillsMaster.UTCCreatedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCCreatedOn"].ToDateTime(), TimeZone); } } if (dr.Table.Columns.Contains("CreatedByRef")) { if (!DBNull.Value.Equals(dr["CreatedByRef"])) { objDOADM_SkillsMaster.CreatedByRef = (long)dr["CreatedByRef"]; } } if (dr.Table.Columns.Contains("UTCLastUpdatedOn")) { if (!DBNull.Value.Equals(dr["UTCLastUpdatedOn"])) { objDOADM_SkillsMaster.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCLastUpdatedOn"].ToDateTime(), TimeZone); } } if (dr.Table.Columns.Contains("LastUpdatedByRef")) { if (!DBNull.Value.Equals(dr["LastUpdatedByRef"])) { objDOADM_SkillsMaster.LastUpdatedByRef = (long)dr["LastUpdatedByRef"]; } } if (dr.Table.Columns.Contains("CreatedByName")) { if (!DBNull.Value.Equals(dr["CreatedByName"])) { objDOADM_SkillsMaster.CreatedByName = dr["CreatedByName"].ToString(); } } if (dr.Table.Columns.Contains("RoleValue")) { if (!DBNull.Value.Equals(dr["RoleValue"])) { objDOADM_SkillsMaster.RoleValue = dr["RoleValue"].ToString(); } } if (dr.Table.Columns.Contains("BusinessSegmentValue")) { if (!DBNull.Value.Equals(dr["BusinessSegmentValue"])) { objDOADM_SkillsMaster.BusinessSegmentValue = dr["BusinessSegmentValue"].ToString(); } } if (dr.Table.Columns.Contains("WorkBasketValue")) { if (!DBNull.Value.Equals(dr["WorkBasketValue"])) { objDOADM_SkillsMaster.WorkBasketValue = dr["WorkBasketValue"].ToString(); } } if (dr.Table.Columns.Contains("DepartmentName")) { if (!DBNull.Value.Equals(dr["DepartmentName"])) { objDOADM_SkillsMaster.DepartmentName = dr["DepartmentName"].ToString(); } } if (dr.Table.Columns.Contains("LastUpdatedByName")) { if (!DBNull.Value.Equals(dr["LastUpdatedByName"])) { objDOADM_SkillsMaster.LastUpdatedByName = dr["LastUpdatedByName"].ToString(); } } if (dr.Table.Columns.Contains("LockedByRef")) { if (!DBNull.Value.Equals(dr["LockedByRef"])) { objDOADM_SkillsMaster.LockedByRef = Convert.ToInt64(dr["LockedByRef"].ToString()); } } if (dr.Table.Columns.Contains("LockedByName")) { if (!DBNull.Value.Equals(dr["LockedByName"])) { objDOADM_SkillsMaster.LockedByName = dr["LockedByName"].ToString(); } } if (dr.Table.Columns.Contains("UTCLockedOn")) { if (!DBNull.Value.Equals(dr["UTCLockedOn"])) { objDOADM_SkillsMaster.UTCLockedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCLockedOn"].ToDateTime(), TimeZone); } } objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation = new List <DOADM_SkillWorkQueuesCorrelation>(); if (objDataTable.Tables[1].Rows.Count > 0) { foreach (DataRow sklwrkQ in objDataTable.Tables[1].Rows) { DOADM_SkillWorkQueuesCorrelation objDOADM_SkillWorkQueuesCorrelation = new DOADM_SkillWorkQueuesCorrelation(); if (sklwrkQ.Table.Columns.Contains("ADM_SkillWorkQueuesCorrelationId")) { if (!DBNull.Value.Equals(sklwrkQ["ADM_SkillWorkQueuesCorrelationId"])) { objDOADM_SkillWorkQueuesCorrelation.ADM_SkillWorkQueuesCorrelationId = (long)sklwrkQ["ADM_SkillWorkQueuesCorrelationId"]; } } if (sklwrkQ.Table.Columns.Contains("ADM_SkillsMasterRef")) { if (!DBNull.Value.Equals(sklwrkQ["ADM_SkillsMasterRef"])) { objDOADM_SkillWorkQueuesCorrelation.ADM_SkillsMasterRef = (long)sklwrkQ["ADM_SkillsMasterRef"]; } } if (sklwrkQ.Table.Columns.Contains("WorkQueuesLkup")) { if (!DBNull.Value.Equals(sklwrkQ["WorkQueuesLkup"])) { objDOADM_SkillWorkQueuesCorrelation.WorkQueuesLkup = (long)sklwrkQ["WorkQueuesLkup"]; } } if (sklwrkQ.Table.Columns.Contains("LastUpdatedByRef")) { if (!DBNull.Value.Equals(sklwrkQ["LastUpdatedByRef"])) { objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByRef = (long)sklwrkQ["LastUpdatedByRef"]; } } if (sklwrkQ.Table.Columns.Contains("LastUpdatedByName")) { if (!DBNull.Value.Equals(sklwrkQ["LastUpdatedByName"])) { objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByName = sklwrkQ["LastUpdatedByName"].ToString(); } } if (sklwrkQ.Table.Columns.Contains("CreatedByName")) { if (!DBNull.Value.Equals(sklwrkQ["CreatedByName"])) { objDOADM_SkillWorkQueuesCorrelation.CreatedByName = sklwrkQ["CreatedByName"].ToString(); } } if (dr.Table.Columns.Contains("UTCCreatedOn")) { if (!DBNull.Value.Equals(dr["UTCCreatedOn"])) { objDOADM_SkillWorkQueuesCorrelation.UTCCreatedOn = ZoneLookupUI.ConvertToTimeZone(sklwrkQ["UTCCreatedOn"].ToDateTime(), TimeZone); } } if (dr.Table.Columns.Contains("UTCLastUpdatedOn")) { if (!DBNull.Value.Equals(dr["UTCLastUpdatedOn"])) { objDOADM_SkillWorkQueuesCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(sklwrkQ["UTCLastUpdatedOn"].ToDateTime(), TimeZone); } } //if (sklwrkQ.Table.Columns.Contains("DiscrepancyCategoryLkup")) //{ // if (!DBNull.Value.Equals(sklwrkQ["DiscrepancyCategoryLkup"])) // { // objDOADM_SkillWorkQueuesCorrelation.DiscrepancyCategoryLkup = (long)sklwrkQ["DiscrepancyCategoryLkup"]; // } //} if (sklwrkQ.Table.Columns.Contains("IsActive")) { if (!DBNull.Value.Equals(sklwrkQ["IsActive"])) { objDOADM_SkillWorkQueuesCorrelation.IsActive = (bool)sklwrkQ["IsActive"]; } } objDOADM_SkillsMaster.lstDOADM_SkillWorkQueuesCorrelation.Add(objDOADM_SkillWorkQueuesCorrelation); } } lstDOADM_SkillsDetails.Add(objDOADM_SkillsMaster); } } catch { } }
public ExceptionTypes SearchSkills(long?TimeZone, DOADM_SkillsMaster objDOADM_SkillsDetails, out List <DOADM_SkillsMaster> lstDOADM_SkillsDetails, out string errorMessage) { lstDOADM_SkillsDetails = new List <DOADM_SkillsMaster>(); objDOADM_SkillsDetails.lstDOADM_SkillWorkQueuesCorrelation = new List <DOADM_SkillWorkQueuesCorrelation>(); errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; DataSet dsResultData = new DataSet(); List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; if (objDOADM_SkillsDetails.ADM_SkillsMasterId != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ADM_SkillsMasterId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOADM_SkillsDetails.ADM_SkillsMasterId; parameters.Add(sqlParam); } if (!string.IsNullOrEmpty(objDOADM_SkillsDetails.SkillsName)) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@SkillsName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.SkillsName; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.RoleLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@RoleLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.RoleLkup; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.BusinessSegmentLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@BusinessSegmentLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.BusinessSegmentLkup; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.DiscrepancyCategoryLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DiscrepancyCategoryLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.DiscrepancyCategoryLkup; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.CMN_DepartmentRef != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_DepartmentRef"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.CMN_DepartmentRef; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.WorkBasketLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@WorkBasketLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.WorkBasketLkup; parameters.Add(sqlParam); } //Uncomment after User search SP modofication //No Null check, IsActive key boolean key by defaut will be false and cannot be null sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOADM_SkillsDetails.IsActive; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; parameters.Add(sqlParam); long executionResult = dah.ExecuteSelectSP(ConstantTexts.SP_USP_APP_SEL_Skills, parameters.ToArray(), out dsResultData, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (dsResultData.Tables.Count > 0 && dsResultData.Tables[0].Rows.Count > 0) { MapSkillsDOSkillsMaster(TimeZone, dsResultData, out lstDOADM_SkillsDetails); return(ExceptionTypes.Success); } else { return(ExceptionTypes.ZeroRecords); } } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ExceptionTypes AddSkills(DOADM_SkillsMaster objDOADM_SkillsDetails, long lLoginId, out string errorMessage) { errorMessage = string.Empty; try { DAHelper dah = new DAHelper(); List <SqlParameter> parameters = new List <SqlParameter>(); long lErrorCode = 0; long lErrorNumber = 0; DataSet dsResultData = new DataSet(); SqlParameter sqlParam; if (objDOADM_SkillsDetails.ADM_SkillsMasterId != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ADM_SkillsMasterId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOADM_SkillsDetails.ADM_SkillsMasterId; parameters.Add(sqlParam); } if (!string.IsNullOrEmpty(objDOADM_SkillsDetails.SkillsName)) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@SkillsName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.SkillsName; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.RoleLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@RoleLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.RoleLkup; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.BusinessSegmentLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@BusinessSegmentLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.BusinessSegmentLkup; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.DiscrepancyCategoryLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DiscrepancyCategoryLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.DiscrepancyCategoryLkup; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.CMN_DepartmentRef != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_DepartmentRef"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.CMN_DepartmentRef; parameters.Add(sqlParam); } if (objDOADM_SkillsDetails.WorkBasketLkup != 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@WorkBasketLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOADM_SkillsDetails.WorkBasketLkup; parameters.Add(sqlParam); } if (!string.IsNullOrEmpty(objDOADM_SkillsDetails.IsActive.ToString())) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOADM_SkillsDetails.IsActive; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lLoginId; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ScreenLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = ScreenType.Skills; parameters.Add(sqlParam); if (objDOADM_SkillsDetails.lstDOADM_SkillWorkQueuesCorrelation.Count() > 0) { DataTable skillsWorkQueue; SetSkillsWorkQueue(objDOADM_SkillsDetails.lstDOADM_SkillWorkQueuesCorrelation, out skillsWorkQueue); DataTableReader dtrSkillWorkQueues = new DataTableReader(skillsWorkQueue); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@TV_Queues"; sqlParam.SqlDbType = SqlDbType.Structured; sqlParam.Value = dtrSkillWorkQueues; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; parameters.Add(sqlParam); long executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_APP_INS_UPD_Skills, parameters.ToArray(), out lErrorCode, out lErrorCode, out lErrorNumber, out errorMessage); sqlParam = parameters.FirstOrDefault(x => x.ParameterName == "@ErrorMessage"); if (sqlParam != null && sqlParam.Value != null) { errorMessage += sqlParam.Value.ToString(); } if (executionResult == (long)ExceptionTypes.Success && string.IsNullOrEmpty(errorMessage)) { return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }