//Search Department by Department ID public ExceptionTypes SearchDepartmentById(long?TimeZone, DOCMN_Department department, out List <DOCMN_Department> lstDOCMN_Department, out string errorMessage) { retValue = new ExceptionTypes(); DALDepartment objDALDepartment = new DALDepartment(); return(retValue = objDALDepartment.SearchDepartmentById(TimeZone, department, out lstDOCMN_Department, out errorMessage)); }
//Search Duplicate Department public ExceptionTypes CheckDuplicateDep(long?TimeZone, DOCMN_Department objDOCMN_Department, out List <DOCMN_Department> lstDOCMN_Department, out string errorMessage) { retValue = new ExceptionTypes(); DALDepartment objDALDepartment = new DALDepartment(); return(retValue = objDALDepartment.CheckDuplicateDep(TimeZone, objDOCMN_Department, out lstDOCMN_Department, out errorMessage)); }
public JsonResult CheckDuplicateDep(long BusinessSegment, long DepName) { long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; var data = ""; BLDepartment objBLDepartment = new BLDepartment(); List <DOCMN_Department> lstDOCMN_Department; DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.BusinessSegmentLkup = BusinessSegment; objDOCMN_Department.DepartmentLkup = DepName; string errorMessage = string.Empty; ExceptionTypes result = objBLDepartment.CheckDuplicateDep(TimeZone, objDOCMN_Department, out lstDOCMN_Department, out errorMessage); if (result != (long)ExceptionTypes.Success) { //Log error BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, errorMessage.ToString(), errorMessage.ToString()); } else if (result == ExceptionTypes.ZeroRecords) { lstDOCMN_Department.Add(objDOCMN_Department); lstDOCMN_Department = new List <DOCMN_Department>(); } int i = lstDOCMN_Department.Count; if (i > 0) { data = "Department Name already exists."; } return(Json(new { Data = data }, JsonRequestBehavior.AllowGet)); }
public ExceptionTypes SaveDepartment(DOCMN_Department objDOCMN_Department, out string errorMessage) { retValue = new ExceptionTypes(); DALDepartment objDALDepartment = new DALDepartment(); return(retValue = objDALDepartment.SaveDepartment(objDOCMN_Department, out errorMessage)); }
//Search Department By Department ID public ExceptionTypes SearchDepartmentById(long?TimeZone, DOCMN_Department department, out List <DOCMN_Department> lstDOCMN_Department, out string errorMessage) { lstDOCMN_Department = new List <DOCMN_Department>(); 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; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_DepartmentId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = department.CMN_DepartmentId; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = department.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_Department, parameters.ToArray(), out dsResultData, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { if (dsResultData.Tables.Count > 0 && dsResultData.Tables[0].Rows.Count > 0) { MapDepartmentDetails(TimeZone, dsResultData.Tables[0], out lstDOCMN_Department); return(ExceptionTypes.Success); } else { return(ExceptionTypes.ZeroRecords); } } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public ActionResult Add(long ResourceId = 0, bool isActive = true) { long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; DOADM_ResourceDetails objDOADM_ResourceDetails = new DOADM_ResourceDetails(); objDOADM_ResourceDetails.IsActive = true; string errorMessage = string.Empty; try { ExceptionTypes result; //get list of Depatments for Department drop down List <DOCMN_Department> lstCMN_Department; BLDepartment objBLDepartment = new BLDepartment(); DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.IsActive = true; result = objBLDepartment.SearchDepartment(TimeZone, objDOCMN_Department, out lstCMN_Department, out errorMessage); //check result for DB action if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Resources, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } //sort list by Depatment name lstCMN_Department = lstCMN_Department.OrderBy(x => x.ERSDepartmentName).ToList(); if (ResourceId != 0) { //temporary list to hold search Resource results List <DOADM_ResourceDetails> lstDOADM_ResourceDetails = new List <DOADM_ResourceDetails>(); //temporary object for search resources function DOADM_ResourceDetails objDOADM_ResourceDetails_Find = new DOADM_ResourceDetails(); objDOADM_ResourceDetails_Find.ADM_ResourceDetailsId = ResourceId; objDOADM_ResourceDetails_Find.IsActive = isActive; result = _objBLResources.SearchResources(TimeZone, objDOADM_ResourceDetails_Find, out lstDOADM_ResourceDetails, out errorMessage); //check result for DB action if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Resources, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } if (lstDOADM_ResourceDetails.Count > 0) { objDOADM_ResourceDetails = lstDOADM_ResourceDetails.FirstOrDefault(); } } //Alert Time Zone lookup from Cache objDOADM_ResourceDetails.lstTimeZone = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Timezone); objDOADM_ResourceDetails.lstCMN_Department = lstCMN_Department; return(View(objDOADM_ResourceDetails)); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Resources, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(RedirectToAction("Maintenance", "Error", ex.ToString())); } }
public ActionResult Add(DOCMN_Department Department) { string errorMessage = string.Empty; string returnMessage = string.Empty; ExceptionTypes result = new ExceptionTypes(); try { long loginUserId = currentUser.ADM_UserMasterId; BLDepartment objBLDepartment = new BLDepartment(); DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.CMN_DepartmentId = Department.CMN_DepartmentId; if (objDOCMN_Department.CMN_DepartmentId > 0) // Edit Mode { BLCommon objCommon = new BLCommon(); if (!objCommon.ValidateLockBeforeSave(loginUserId, (long)ScreenType.Department, objDOCMN_Department.CMN_DepartmentId)) { errorMessage = "Record not locked, please reload the page."; result = ExceptionTypes.UnknownError; return(Json(new { ID = result, Message = errorMessage })); } objDOCMN_Department.CreatedByRef = loginUserId; returnMessage = "Record updated successfully."; } else { objDOCMN_Department.CreatedByRef = loginUserId; //Add Mode returnMessage = "Record saved successfully."; } objDOCMN_Department.ERSDepartmentName = Department.ERSDepartmentName; objDOCMN_Department.BusinessSegmentLkup = Department.BusinessSegmentLkup; objDOCMN_Department.DepartmentLkup = Department.DepartmentLkup; objDOCMN_Department.EffectiveDate = Department.EffectiveDate; objDOCMN_Department.InactivationDate = Department.InactivationDate; objDOCMN_Department.IsActive = Department.IsActive; objDOCMN_Department.UTCCreatedOn = Department.UTCCreatedOn; result = objBLDepartment.SaveDepartment(objDOCMN_Department, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, errorMessage.ToString(), errorMessage.ToString()); return(Json(new { ID = result, Message = "An error occured while updating DB." })); } return(Json(new { ID = result, Message = returnMessage })); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(Json(new { ID = result, Message = "An error occured while performing Save action." })); } }
public List <DOCMN_Department> GetERSDepartments() { long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; string strErrorMessage = string.Empty; List <DOCMN_Department> lstCMN_Department = new List <DOCMN_Department>(); BLDepartment objBLDepartment = new BLDepartment(); DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.IsActive = true; ExceptionTypes result = objBLDepartment.SearchDepartment(TimeZone, objDOCMN_Department, out lstCMN_Department, out strErrorMessage); return(lstCMN_Department); }
public ActionResult Add(long DepId = 0, bool isActive = true) { long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; // Bind Dropdown List for Business Segment and Department. string errorMessage = string.Empty; List <DOCMN_LookupMaster> lstBusinessSegment; List <DOCMN_LookupMaster> lstDepartment; List <DOCMN_LookupMaster> lstTimezone; BLDepartment objBLDepartment = new BLDepartment(); List <DOCMN_Department> lstDOCMN_Department = new List <DOCMN_Department>(); DOCMN_Department objDOCMN_Department = new DOCMN_Department(); lstBusinessSegment = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.BusinessSegment); lstDepartment = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Department); lstTimezone = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Timezone); objDOCMN_Department.IsActive = true; if (DepId != 0) { // Fetch Record By Department ID. objDOCMN_Department.CMN_DepartmentId = DepId; objDOCMN_Department.IsActive = isActive; ExceptionTypes result = objBLDepartment.SearchDepartmentById(TimeZone, objDOCMN_Department, out lstDOCMN_Department, out errorMessage); if (result != (long)ExceptionTypes.Success) { //Log Error BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, errorMessage.ToString(), errorMessage.ToString()); } if (lstDOCMN_Department.Count > 0) { objDOCMN_Department = lstDOCMN_Department.FirstOrDefault(); } } else { objDOCMN_Department.EffectiveDate = DateTime.UtcNow; } objDOCMN_Department.lstBusinessSegment = lstBusinessSegment; objDOCMN_Department.lstCMN_Department = lstDepartment; objDOCMN_Department.lstTimeZone = lstTimezone; return(View("Add", objDOCMN_Department)); }
// Get Department In Search Page. private List <DOCMN_Department> PGetDepartment(string strDepName = "", bool isActive = true) { long? TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; BLDepartment objBLDepartment = new BLDepartment(); List <DOCMN_Department> lstDOCMN_Department; try { DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.ERSDepartmentName = strDepName; if (isActive) { objDOCMN_Department.IsActive = Convert.ToBoolean(isActive); } else { objDOCMN_Department.IsActive = false; } string errorMessage = string.Empty; ExceptionTypes result = objBLDepartment.SearchDepartment(TimeZone, objDOCMN_Department, out lstDOCMN_Department, out errorMessage); if (result != (long)ExceptionTypes.Success) { //Log error BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, errorMessage.ToString(), errorMessage.ToString()); } else if (result == ExceptionTypes.ZeroRecords) { lstDOCMN_Department.Add(objDOCMN_Department); lstDOCMN_Department = new List <DOCMN_Department>(); } return(lstDOCMN_Department); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Department, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); throw ex; } }
//save Department Master public ExceptionTypes SaveDepartment(DOCMN_Department objDOCMN_Department, out string errorMessage) { try { DAHelper dah = new DAHelper(); long lErrocode = 0; long lErrorNumber = 0; long lRowsEffected = 0; DataSet dsTable = new DataSet(); errorMessage = string.Empty; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter sqlParam; sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_DepartmentId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_Department.CMN_DepartmentId; parameters.Add(sqlParam); if (!string.IsNullOrEmpty(objDOCMN_Department.ERSDepartmentName)) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ERSDepartmentName"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOCMN_Department.ERSDepartmentName; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@BusinessSegmentLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_Department.BusinessSegmentLkup; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@DepartmentLkup"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOCMN_Department.DepartmentLkup; parameters.Add(sqlParam); if (objDOCMN_Department.EffectiveDate != null) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@EffectiveDate"; sqlParam.SqlDbType = SqlDbType.DateTime; sqlParam.Value = objDOCMN_Department.EffectiveDate; parameters.Add(sqlParam); } if (objDOCMN_Department.InactivationDate != null) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@InactivationDate"; sqlParam.SqlDbType = SqlDbType.DateTime; sqlParam.Value = objDOCMN_Department.InactivationDate; parameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOCMN_Department.IsActive; parameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_Department.CreatedByRef; parameters.Add(sqlParam); //Extra parameter when adding or editing record for releasing lock sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ScreenLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = (long)ScreenType.Department; 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 = 0; //if (objDOADM_UserMaster.ADM_UserMasterId == 0) //{ executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_APP_INS_UPD_Department, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); //} //else //{ // executionResult = executionResult = dah.ExecuteDMLSP(ConstantTexts.SP_USP_APP_UPD_ADM_UserMaster, parameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); //} if (executionResult == 0) { return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } }
public void MapDepartmentDetails(long?TimeZone, DataTable objDataTable, out List <DOCMN_Department> lstDOCMN_Department) { lstDOCMN_Department = new List <DOCMN_Department>(); try { foreach (DataRow dr in objDataTable.Rows) { DOCMN_Department objDOCMN_Department = new DOCMN_Department(); if (dr.Table.Columns.Contains("CMN_DepartmentId")) { if (!DBNull.Value.Equals(dr["CMN_DepartmentId"])) { objDOCMN_Department.CMN_DepartmentId = Convert.ToInt32(dr["CMN_DepartmentId"]); } } if (dr.Table.Columns.Contains("ERSDepartmentName")) { if (!DBNull.Value.Equals(dr["ERSDepartmentName"])) { objDOCMN_Department.ERSDepartmentName = dr["ERSDepartmentName"].ToString(); } } if (dr.Table.Columns.Contains("EffectiveDate")) { if (!DBNull.Value.Equals(dr["EffectiveDate"])) { objDOCMN_Department.EffectiveDate = Convert.ToDateTime(dr["EffectiveDate"]); } } if (dr.Table.Columns.Contains("InactivationDate")) { if (!DBNull.Value.Equals(dr["InactivationDate"])) { objDOCMN_Department.InactivationDate = Convert.ToDateTime(dr["InactivationDate"]); } } if (dr.Table.Columns.Contains("InactivationDate")) { if (!DBNull.Value.Equals(dr["InactivationDate"])) { objDOCMN_Department.InactivationDate = Convert.ToDateTime(dr["InactivationDate"]); } } if (dr.Table.Columns.Contains("BusinessSegmentLkup")) { if (!DBNull.Value.Equals(dr["BusinessSegmentLkup"])) { objDOCMN_Department.BusinessSegmentLkup = (long)(dr["BusinessSegmentLkup"]); } } if (dr.Table.Columns.Contains("DepartmentLkup")) { if (!DBNull.Value.Equals(dr["DepartmentLkup"])) { objDOCMN_Department.DepartmentLkup = (long)(dr["DepartmentLkup"]); } } if (dr.Table.Columns.Contains("IsActive")) { if (!DBNull.Value.Equals(dr["IsActive"])) { if (dr["IsActive"].ToString() == "True") { objDOCMN_Department.IsActive = true; } if (dr["IsActive"].ToString() == "False") { objDOCMN_Department.IsActive = false; } } } if (dr.Table.Columns.Contains("LockedByRef")) { if (!DBNull.Value.Equals(dr["LockedByRef"])) { objDOCMN_Department.LockedByRef = (long)(dr["LockedByRef"]); } } if (dr.Table.Columns.Contains("UTCCreatedOn")) { if (!DBNull.Value.Equals(dr["UTCCreatedOn"])) { objDOCMN_Department.UTCCreatedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCCreatedOn"].ToDateTime(), TimeZone); } } if (dr.Table.Columns.Contains("CreatedByName")) { if (!DBNull.Value.Equals(dr["CreatedByName"])) { objDOCMN_Department.CreatedByName = Convert.ToString(dr["CreatedByName"]); } } if (dr.Table.Columns.Contains("UTCLastUpdatedOn")) { if (!DBNull.Value.Equals(dr["UTCLastUpdatedOn"])) { objDOCMN_Department.UTCLastUpdatedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCLastUpdatedOn"].ToDateTime(), TimeZone); } } if (dr.Table.Columns.Contains("LastUpdatedByName")) { if (!DBNull.Value.Equals(dr["LastUpdatedByName"])) { objDOCMN_Department.LastUpdatedByName = Convert.ToString(dr["LastUpdatedByName"]); } } if (dr.Table.Columns.Contains("LockedByName")) { if (!DBNull.Value.Equals(dr["LockedByName"])) { objDOCMN_Department.LockedByName = Convert.ToString(dr["LockedByName"]); } } if (dr.Table.Columns.Contains("UTCLockedOn")) { if (!DBNull.Value.Equals(dr["UTCLockedOn"])) { objDOCMN_Department.UTCLockedOn = ZoneLookupUI.ConvertToTimeZone(dr["UTCLockedOn"].ToDateTime(), TimeZone); } } lstDOCMN_Department.Add(objDOCMN_Department); } } catch { } }
public ActionResult Add(long AlertId = 0, bool isActive = true) { DOADM_AlertDetails objDOADM_AlertDetails = new DOADM_AlertDetails(); objDOADM_AlertDetails.IsActive = true; string errorMessage = string.Empty; try { ExceptionTypes result; //get list of users for Send ALert to Indiviual drop down List <DOADM_UserMaster> lstUsers; BLUserAdministration objBLUserAdministration = new BLUserAdministration(); DOADM_UserMaster objDOADM_UserMaster = new DOADM_UserMaster(); objDOADM_UserMaster.IsActive = true; long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; result = objBLUserAdministration.SearchUser(TimeZone, objDOADM_UserMaster, out lstUsers, out errorMessage); //check result for DB action if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Alerts, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } //Filtered 1st three Users as Admin.sort list by email id lstUsers = lstUsers.Where(x => x.ADM_UserMasterId > 1000).OrderBy(x => x.Email).ToList(); //get list of Depatments for Send ALert to Department drop down List <DOCMN_Department> lstCMN_Department; BLDepartment objBLDepartment = new BLDepartment(); DOCMN_Department objDOCMN_Department = new DOCMN_Department(); objDOCMN_Department.IsActive = true; result = objBLDepartment.SearchDepartment(TimeZone, objDOCMN_Department, out lstCMN_Department, out errorMessage); //check result for DB action if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Alerts, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } //sort list by Depatment name lstCMN_Department = lstCMN_Department.OrderBy(x => x.ERSDepartmentName).ToList(); if (AlertId != 0) { //temporary list to hold search alerts results List <DOADM_AlertDetails> lstDOADM_AlertDetails = new List <DOADM_AlertDetails>(); //temporary object for search alerts function DOADM_AlertDetails objDOADM_AlertDetails_Find = new DOADM_AlertDetails(); objDOADM_AlertDetails_Find.ADM_AlertDetailsId = AlertId; objDOADM_AlertDetails_Find.IsActive = isActive; result = _objBLAlerts.SearchAlerts(TimeZone, objDOADM_AlertDetails_Find, out lstDOADM_AlertDetails, out errorMessage); //check result for DB action if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Alerts, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } if (lstDOADM_AlertDetails.Count > 0) { objDOADM_AlertDetails = lstDOADM_AlertDetails.FirstOrDefault(); } } objDOADM_AlertDetails.lstUsers = lstUsers; objDOADM_AlertDetails.lstCMN_Department = lstCMN_Department; //Alert criticality lookup from Cache objDOADM_AlertDetails.lstAlertCriticalityLkup = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.AlertCriticality); //Send Alert To lookup from Cache objDOADM_AlertDetails.lstSendAlertToLkup = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.SendAlertTo); //Alert Time Zone lookup from Cache objDOADM_AlertDetails.lstTimeZone = CacheUtility.GetAllLookupsFromCache((long)LookupTypes.Timezone); return(View(objDOADM_AlertDetails)); } catch (Exception ex) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Alerts, (long)ExceptionTypes.Uncategorized, ex.ToString(), ex.ToString()); return(RedirectToAction("Maintenance", "Error", new { Error = ex.ToString() })); } }