private UIBulkUploadSearch PLoadBulkUpload() { long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; UIBulkUploadSearch objUIBulkUploadSearch = new UIBulkUploadSearch(); List <DOGEN_BulkImport> lstDOGEN_BulkImport = new List <DOGEN_BulkImport>(); errorMessage = string.Empty; try { long workBasketLkp = currentUser.WorkBasketLkup.ToInt64(); objUIBulkUploadSearch.WorkbasketLkup = workBasketLkp; objUIBulkUploadSearch.lstWorkbasket = CacheUtility.GetAllLookupsFromCache(LookupTypes.WorkBasket.ToInt64()); objUIBulkUploadSearch.lstDiscCategary = CacheUtility.GetAllLookupMasterCorrelationFromCache((long)LookupTypesCorrelation.WorkBasketVsDiscripancyCategory, workBasketLkp); objUIBulkUploadSearch.lstDOGEN_BulkImportExcelTemplateMaster = CacheUtility.GetBulkImportExcelTemplateFromCache().lstDOGEN_BulkImportExcelTemplateMaster.Where(x => x.TemplateTypeLkup == TemplateType.BulkUpload.ToInt64()).ToList(); objUIBulkUploadSearch.TemplateTypeLkup = TemplateType.BulkUpload.ToLong(); ExceptionTypes result = _objBLBulkUpload.GetBulkUploadSearchResult(TimeZone, objUIBulkUploadSearch, out lstDOGEN_BulkImport, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.BulkUpload, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } objUIBulkUploadSearch.lstDOGEN_BulkImport = lstDOGEN_BulkImport; return(objUIBulkUploadSearch); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.BulkUpload, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString()); throw ex; } }
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 GetQueues(long?lDiscrepancyCatLkup) { try { List <DOCMN_LookupMasterCorrelations> lstDOCMN_LookupMaster = CacheUtility.GetAllLookupMasterCorrelationFromCache((long)LookupTypesCorrelation.DiscripancyCategoryVQueue, lDiscrepancyCatLkup); lstDOCMN_LookupMaster = lstDOCMN_LookupMaster.Where(x => x.CMN_LookupMasterParentRef == lDiscrepancyCatLkup).ToList(); return(Json(lstDOCMN_LookupMaster)); } 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 CreateRPRCase(string memberFName = "", string memberLName = "", string memberDOB = "", string hICN = "", string mIIMReferenceId = "") { ViewBag.PageName = ConstantTexts.MiimPageName; try { string requestData = "memberFName : " + memberFName + ",memberLName : " + memberLName + ",memberDOB : " + memberDOB + ",string hICN : " + hICN + ",string mIIMReferenceId : " + mIIMReferenceId; MIIMServiceLog(MethodBase.GetCurrentMethod().Name, requestData, ConstantTexts.MIIMNew, _currentLoginUserId, TarceMethodLkup.New.ToLong(), (long)MIIMServiceMethod.CreateRPRCase); #region Create Session ExceptionTypes result = CreateSession(WorkBasket.RPR); #endregion if (result == ExceptionTypes.Success) { MIIMServiceLog(MethodBase.GetCurrentMethod().Name, requestData, ConstantTexts.MIIMUserAuthSucc, _currentLoginUserId, TarceMethodLkup.InProgress.ToLong(), (long)MIIMServiceMethod.CreateRPRCase); DOGEN_Queue objDOGEN_Queue = new DOGEN_Queue(); #region Dropdowns Binding List <DOADM_UserMaster> lstUsers; DOADM_UserMaster objDOADM_UserMaster = new DOADM_UserMaster(); objDOADM_UserMaster.IsActive = true; BLUserAdministration objBLUserAdministration = new BLUserAdministration(); long?TimeZone = (long)DefaultTimeZone.CentralStandardTime; result = objBLUserAdministration.SearchUser(TimeZone, objDOADM_UserMaster, out lstUsers, out string errorMessage); objDOGEN_Queue.ComplianceStartDate = DateTime.UtcNow; objDOGEN_Queue.DiscrepancyStartDate = objDOGEN_Queue.ComplianceStartDate.Value.AddMonths(1); objDOGEN_Queue.DiscrepancyStartDate = new DateTime(objDOGEN_Queue.DiscrepancyStartDate.Value.Year, objDOGEN_Queue.DiscrepancyStartDate.Value.Month, 1); objDOGEN_Queue.lstUsers = lstUsers.Where(x => x.ADM_UserMasterId > 1000 && x.IsManager).OrderBy(x => x.Email).ToList();//Filtered 1st three Users as Admin.sort list by email id objDOGEN_Queue.lstLob = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.LOB); objDOGEN_Queue.lstDiscCategary = CacheUtility.GetAllLookupMasterCorrelationFromCache((long)LookupTypesCorrelation.WorkBasketVsDiscripancyCategory, (long)WorkBasket.RPR); objDOGEN_Queue.lstContractid = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Contract); objDOGEN_Queue.lstPbpid = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.PBPID); objDOGEN_Queue.lstActionRequested = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.RPRActionRequested); objDOGEN_Queue.lstTaskBeingPerformed = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Taskbeingperformedwhenthisdiscrepancywasidentified); objDOGEN_Queue.lstDiscType = CacheUtility.GetAllLookupMasterCorrelationFromCache((long)LookupTypesCorrelation.DiscripancyCategoryVsDiscripancyType, (long)DiscripancyCategory.RPR); #endregion objDOGEN_Queue.MemberFirstName = memberFName; objDOGEN_Queue.MemberLastName = memberLName; objDOGEN_Queue.MIIMReferenceId = mIIMReferenceId; bool isDobCorrect = DateTime.TryParse(memberDOB, out DateTime dtMemberDob); if (isDobCorrect) { objDOGEN_Queue.MemberDOB = dtMemberDob.AddDays(1); } objDOGEN_Queue.MemberCurrentHICN = hICN; MIIMServiceLog(MethodBase.GetCurrentMethod().Name, requestData, ConstantTexts.MIIMRequestCompleted, _currentLoginUserId, TarceMethodLkup.Completed.ToLong(), (long)MIIMServiceMethod.CreateRPRCase); return(View("~/Views/RPR/Create.cshtml", objDOGEN_Queue)); } else if (result == ExceptionTypes.UnknownError) { MIIMServiceLog(MethodBase.GetCurrentMethod().Name, requestData, ConstantTexts.MIIMUserAuthFail, _currentLoginUserId, TarceMethodLkup.Completed.ToLong(), (long)MIIMServiceMethod.CreateRPRCase); ViewBag.ErrorMessage = "\nYou are not part of ERS DB.\nPlease contact administrator"; return(View("~/Views/Shared/Error.cshtml")); } else { MIIMServiceLog(MethodBase.GetCurrentMethod().Name, requestData, ConstantTexts.MIIMUserAuthFail, _currentLoginUserId, TarceMethodLkup.Completed.ToLong(), (long)MIIMServiceMethod.CreateRPRCase); ViewBag.ErrorMessage = "\nYou do not have permission to access this page.\nPlease contact administrator"; return(View("~/Views/Shared/Error.cshtml")); } } catch (Exception ex) { MIIMServiceLog(MethodBase.GetCurrentMethod().Name, "", ex.ToString(), _currentLoginUserId, TarceMethodLkup.Failed.ToLong(), (long)MIIMServiceMethod.CreateRPRCase); BLCommon.LogError(_currentLoginUserId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.MIIMConnector, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.Message); return(View("~/Views/Shared/Error.cshtml")); } }
private List <DOCMN_LookupMasterCorrelations> GetDiscrepancyCategories() { try { List <DOCMN_LookupMasterCorrelations> lstDOCMN_LookupMasterCorrelations = CacheUtility.GetAllLookupMasterCorrelationFromCache( (long)LookupTypesCorrelation.WorkBasketVsDiscripancyCategory, null); return(lstDOCMN_LookupMasterCorrelations); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.ManageSkills, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(null); } }
public ActionResult AddWorkQueuesToSession(DOADM_SkillWorkQueuesCorrelation objDOADM_SkillWorkQueuesCorrelation, long lDiscrepancyCatLkup = 0, long lPreviousWorkQueue = 0, int mode = 0) { long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; List <DOADM_SkillWorkQueuesCorrelation> lstDOADM_SkillWorkQueuesCorrelation = new List <DOADM_SkillWorkQueuesCorrelation>(); try { if (Session[ConstantTexts.SkillWorkQueueSessionKey] != null) { lstDOADM_SkillWorkQueuesCorrelation = Session[ConstantTexts.SkillWorkQueueSessionKey] as List <DOADM_SkillWorkQueuesCorrelation>; } switch (mode) { case 0: //Add new WQ to the list if (lstDOADM_SkillWorkQueuesCorrelation.Where(xx => xx.WorkQueuesLkup == objDOADM_SkillWorkQueuesCorrelation.WorkQueuesLkup).Count() == 0) { objDOADM_SkillWorkQueuesCorrelation.IsActive = true; objDOADM_SkillWorkQueuesCorrelation.CreatedByRef = currentUser.ADM_UserMasterId; objDOADM_SkillWorkQueuesCorrelation.CreatedByName = currentUser.FullName; objDOADM_SkillWorkQueuesCorrelation.UTCCreatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId; objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByName = currentUser.FullName; objDOADM_SkillWorkQueuesCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); lstDOADM_SkillWorkQueuesCorrelation.Add(objDOADM_SkillWorkQueuesCorrelation); } else { objDOADM_SkillWorkQueuesCorrelation = lstDOADM_SkillWorkQueuesCorrelation.Where(xx => xx.WorkQueuesLkup == objDOADM_SkillWorkQueuesCorrelation.WorkQueuesLkup).FirstOrDefault(); objDOADM_SkillWorkQueuesCorrelation.IsActive = true; objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId; objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByName = currentUser.FullName; objDOADM_SkillWorkQueuesCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); } break; case 1: //delete work queue from added list if (lstDOADM_SkillWorkQueuesCorrelation.Where(xx => xx.WorkQueuesLkup == objDOADM_SkillWorkQueuesCorrelation.WorkQueuesLkup).Count() > 0) { objDOADM_SkillWorkQueuesCorrelation = lstDOADM_SkillWorkQueuesCorrelation.Where(xx => xx.WorkQueuesLkup == objDOADM_SkillWorkQueuesCorrelation.WorkQueuesLkup).FirstOrDefault(); objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId; objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByName = currentUser.FullName; objDOADM_SkillWorkQueuesCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); objDOADM_SkillWorkQueuesCorrelation.IsActive = false; } break; case 2: //update existing work Queue long NewWorkQueuesLkup = objDOADM_SkillWorkQueuesCorrelation.WorkQueuesLkup; objDOADM_SkillWorkQueuesCorrelation = lstDOADM_SkillWorkQueuesCorrelation.Where(x => x.WorkQueuesLkup == lPreviousWorkQueue).FirstOrDefault(); if (objDOADM_SkillWorkQueuesCorrelation.ADM_SkillsMasterRef == 0) //updating a queue for new record { objDOADM_SkillWorkQueuesCorrelation.CreatedByName = currentUser.FullName; objDOADM_SkillWorkQueuesCorrelation.CreatedByRef = currentUser.ADM_UserMasterId; } objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByName = currentUser.FullName; objDOADM_SkillWorkQueuesCorrelation.LastUpdatedByRef = currentUser.ADM_UserMasterId; objDOADM_SkillWorkQueuesCorrelation.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); objDOADM_SkillWorkQueuesCorrelation.IsActive = true; objDOADM_SkillWorkQueuesCorrelation.WorkQueuesLkup = NewWorkQueuesLkup; break; case 3: //removing all queues from session foreach (var item in lstDOADM_SkillWorkQueuesCorrelation) { item.LastUpdatedByName = currentUser.FullName; item.LastUpdatedByRef = currentUser.ADM_UserMasterId; item.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(DateTime.UtcNow, TimeZone); item.IsActive = false; } break; } List <DOCMN_LookupMasterCorrelations> lstDOCMN_LookupMaster = CacheUtility.GetAllLookupMasterCorrelationFromCache((long)LookupTypesCorrelation.DiscripancyCategoryVQueue, lDiscrepancyCatLkup); lstDOCMN_LookupMaster = lstDOCMN_LookupMaster.Where(x => x.CMN_LookupMasterParentRef == lDiscrepancyCatLkup).ToList(); ViewBag.WorkQueues = lstDOCMN_LookupMaster; Session[ConstantTexts.SkillWorkQueueSessionKey] = lstDOADM_SkillWorkQueuesCorrelation; return(PartialView("_WorkQueue", lstDOADM_SkillWorkQueuesCorrelation.Where(xx => xx.IsActive == true).ToList())); } 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())); } }