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 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())); } }