private List <DOCMN_LookupTypeCorrelations> PGetAllLookupTypeCorrelations(string strDescription = "", int ddlLookupType = 0, bool isActive = true) { long?TimeZone = currentUser.ADM_UserPreference.TimezoneLkup != null ? currentUser.ADM_UserPreference.TimezoneLkup : (long)DefaultTimeZone.CentralStandardTime; List <DOCMN_LookupTypeCorrelations> lstDOCMN_LookupTypeCorrelations = new List <DOCMN_LookupTypeCorrelations>(); DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations = new DOCMN_LookupTypeCorrelations(); string errorMessage = string.Empty; try { objDOCMN_LookupTypeCorrelations.CorrelationDescription = strDescription; objDOCMN_LookupTypeCorrelations.CMN_LookupTypeParentRef = ddlLookupType; objDOCMN_LookupTypeCorrelations.IsActive = isActive; ExceptionTypes result = _objBLLookupCorrelations.GetAllLookupTypeCorrelations(TimeZone, objDOCMN_LookupTypeCorrelations, out lstDOCMN_LookupTypeCorrelations, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.LookupsCorrelation, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } return(lstDOCMN_LookupTypeCorrelations); } catch (Exception ex) { BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.LookupsCorrelation, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString()); throw ex; } }
private void MapLookupCorelationByID(DataSet dsResult, out DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations) { objDOCMN_LookupTypeCorrelations = new DOCMN_LookupTypeCorrelations(); objDOCMN_LookupTypeCorrelations.lstDOCMN_LookupMasterCorrelations = new List <DOCMN_LookupMasterCorrelations>(); try { if (_dsResult != null && _dsResult.Tables.Count > 0 && _dsResult.Tables[0].Rows.Count > 0) { DataRow dr = _dsResult.Tables[0].Rows[0]; objDOCMN_LookupTypeCorrelations.CMN_LookupTypeCorrelationsId = (!dr["CMN_LookupTypeCorrelationsId"].IsNull()) ? dr["CMN_LookupTypeCorrelationsId"].ToInt64() : 0; objDOCMN_LookupTypeCorrelations.CMN_LookupTypeParentRef = (!dr["CMN_LookupTypeParentRef"].IsNull()) ? dr["CMN_LookupTypeParentRef"].ToInt64() : 0; objDOCMN_LookupTypeCorrelations.CMN_LookupTypeParentValue = (!dr["CMN_LookupTypeParentValue"].IsNull()) ? dr["CMN_LookupTypeParentValue"].NullToString() : string.Empty; objDOCMN_LookupTypeCorrelations.CMN_LookupTypeChildRef = (!dr["CMN_LookupTypeChildRef"].IsNull()) ? dr["CMN_LookupTypeChildRef"].ToInt64() : 0; objDOCMN_LookupTypeCorrelations.CMN_LookupTypeChildValue = (!dr["CMN_LookupTypeChildValue"].IsNull()) ? dr["CMN_LookupTypeChildValue"].NullToString() : string.Empty; objDOCMN_LookupTypeCorrelations.GroupingLookupTypeRef = (!dr["GroupingLookupTypeRef"].IsNull()) ? dr["GroupingLookupTypeRef"].ToInt64() : 0; objDOCMN_LookupTypeCorrelations.GroupingLookupTypeValue = (!dr["GroupingLookupTypeValue"].IsNull()) ? dr["GroupingLookupTypeValue"].NullToString() : string.Empty; objDOCMN_LookupTypeCorrelations.CorrelationDescription = (!dr["CorrelationDescription"].IsNull()) ? dr["CorrelationDescription"].NullToString() : string.Empty; objDOCMN_LookupTypeCorrelations.LockedByRef = (!dr["LockedByRef"].IsNull()) ? dr["LockedByRef"].ToInt64() : 0; objDOCMN_LookupTypeCorrelations.LockedByName = (!dr["LockedByName"].IsNull()) ? dr["LockedByName"].NullToString() : string.Empty; objDOCMN_LookupTypeCorrelations.UTCLockedOn = (!dr["UTCLockedOn"].IsNull()) ? dr["UTCLockedOn"].ToDateTime() : DateTime.UtcNow; objDOCMN_LookupTypeCorrelations.IsActive = (!dr["IsActive"].IsNull()) ? dr["IsActive"].ToBoolean() : false; objDOCMN_LookupTypeCorrelations.UTCCreatedOn = (!dr["UTCCreatedOn"].IsNull()) ? dr["UTCCreatedOn"].ToDateTime() : DateTime.UtcNow; objDOCMN_LookupTypeCorrelations.CreatedByRef = (!dr["CreatedByRef"].IsNull()) ? dr["CreatedByRef"].ToInt64() : 0; objDOCMN_LookupTypeCorrelations.CreatedByName = (!dr["CreatedByName"].IsNull()) ? dr["CreatedByName"].NullToString() : string.Empty; objDOCMN_LookupTypeCorrelations.UTCLastUpdatedOn = (!dr["UTCLastUpdatedOn"].IsNull()) ? dr["UTCLastUpdatedOn"].ToDateTime() : DateTime.UtcNow; objDOCMN_LookupTypeCorrelations.LastUpdatedByRef = (!dr["LastUpdatedByRef"].IsNull()) ? dr["LastUpdatedByRef"].ToInt64() : 0; objDOCMN_LookupTypeCorrelations.LastUpdatedByName = (!dr["LastUpdatedByName"].IsNull()) ? dr["LastUpdatedByName"].NullToString() : string.Empty; } if (_dsResult != null && _dsResult.Tables.Count > 1 && _dsResult.Tables[1].Rows.Count > 0) { objDOCMN_LookupTypeCorrelations.lstDOCMN_LookupMasterCorrelations = _dsResult.Tables[1].AsEnumerable().Select(dr => new DOCMN_LookupMasterCorrelations { CMN_LookupMasterCorrelationsId = (!dr["CMN_LookupMasterCorrelationsId"].IsNull()) ? dr["CMN_LookupMasterCorrelationsId"].ToInt64() : 0, CMN_LookupTypeCorrelationsRef = (!dr["CMN_LookupTypeCorrelationsRef"].IsNull()) ? dr["CMN_LookupTypeCorrelationsRef"].ToInt64() : 0, CMN_LookupMasterParentRef = (!dr["CMN_LookupMasterParentRef"].IsNull()) ? dr["CMN_LookupMasterParentRef"].ToInt64() : 0, LookupMasterParentValue = (!dr["LookupMasterParentValue"].IsNull()) ? dr["LookupMasterParentValue"].NullToString() : string.Empty, CMN_LookupMasterChildRef = (!dr["CMN_LookupMasterChildRef"].IsNull()) ? dr["CMN_LookupMasterChildRef"].ToInt64() : 0, LookupMasterChildValue = (!dr["LookupMasterChildValue"].IsNull()) ? dr["LookupMasterChildValue"].NullToString() : string.Empty, GroupingLookupMasterRef = (!dr["GroupingLookupMasterRef"].IsNull()) ? dr["GroupingLookupMasterRef"].ToInt64() : 0, GroupingLookupMasterValue = (!dr["GroupingLookupMasterValue"].IsNull()) ? dr["GroupingLookupMasterValue"].NullToString() : string.Empty, CorrelationDescription = (!dr["CorrelationDescription"].IsNull()) ? dr["CorrelationDescription"].NullToString() : string.Empty, DisplayOrder = (!dr["DisplayOrder"].IsNull()) ? dr["DisplayOrder"].ToInt64() : 0, UTCCreatedOn = (!dr["UTCCreatedOn"].IsNull()) ? dr["UTCCreatedOn"].ToDateTime() : DateTime.UtcNow, CreatedByRef = (!dr["CreatedByRef"].IsNull()) ? dr["CreatedByRef"].ToInt64() : 0, CreatedByName = (!dr["CreatedByName"].IsNull()) ? dr["CreatedByName"].NullToString() : string.Empty, UTCLastUpdatedOn = (!dr["UTCLastUpdatedOn"].IsNull()) ? dr["UTCLastUpdatedOn"].ToDateTime() : DateTime.UtcNow, LastUpdatedByRef = (!dr["LastUpdatedByRef"].IsNull()) ? dr["LastUpdatedByRef"].ToInt64() : 0, LastUpdatedByName = (!dr["LastUpdatedByName"].IsNull()) ? dr["LastUpdatedByName"].NullToString() : string.Empty, IsActive = (!dr["IsActive"].IsNull()) ? dr["IsActive"].ToBoolean() : false }).ToList(); } } catch (Exception ex) { //need log throw ex; } }
public ExceptionTypes GetAllLookupTypeCorrelations(long?TimeZone, DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations, out List <DOCMN_LookupTypeCorrelations> lstDOCMN_LookupTypeCorrelations, out string errorMessage) { lstDOCMN_LookupTypeCorrelations = new List <DOCMN_LookupTypeCorrelations>(); List <DOCMN_LookupMasterCorrelations> lstDOCMN_LookupMasterCorrelations; ExceptionTypes returnValue = GetAllLookupTypeCorrelations(TimeZone, objDOCMN_LookupTypeCorrelations, out lstDOCMN_LookupTypeCorrelations, out lstDOCMN_LookupMasterCorrelations, out errorMessage); return(returnValue); }
/// <summary> /// Get LookuptypeCorrelation and Master as list by lookupTypeCorrelationsId /// </summary> /// <param name="lookupTypeCorrelationsId"></param> /// <param name="objDOCMN_LookupTypeCorrelations"></param> /// <returns></returns> public ExceptionTypes GetLookupCorelationByID(long lookupTypeCorrelationsId, out DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations, out string errorMessage) { _dsResult = new DataSet(); _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; long lErrocode = 0; long lErrorNumber = 0; errorMessage = string.Empty; objDOCMN_LookupTypeCorrelations = new DOCMN_LookupTypeCorrelations(); try { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_LookupTypeCorrelationsId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lookupTypeCorrelationsId; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; _lstParameters.Add(sqlParam); long executionResult = _daHelper.ExecuteSelectSP(ConstantTexts.SP_APP_SEL_LookupsCorrelation, _lstParameters.ToArray(), out _dsResult, out lErrocode, out lErrorNumber, out errorMessage); sqlParam = _lstParameters.FirstOrDefault(x => x.ParameterName == "@ErrorMessage"); if (sqlParam != null && sqlParam.Value != null) { errorMessage += sqlParam.Value.ToString(); } if (executionResult == (long)ExceptionTypes.Success && string.IsNullOrEmpty(errorMessage)) { MapLookupCorelationByID(_dsResult, out objDOCMN_LookupTypeCorrelations); return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } finally { _dsResult = null; _lstParameters = null; } }
/// <summary> /// Save / Update LookupTypeCrrelation /// </summary> /// <param name="objDOCMN_LookupTypeCorrelations"></param> /// <returns></returns> public ActionResult SaveLookupTypeCorrelation(DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations) { errorMessage = string.Empty; ExceptionTypes result = new ExceptionTypes(); long loginUserId = currentUser.ADM_UserMasterId; string returnMessage = string.Empty; BLCommon objCommon = new BLCommon(); try { if (objDOCMN_LookupTypeCorrelations.CMN_LookupTypeCorrelationsId > 0) { if (!objCommon.ValidateLockBeforeSave(loginUserId, (long)ScreenType.LookupTypeCorrelation, objDOCMN_LookupTypeCorrelations.CMN_LookupTypeCorrelationsId)) { errorMessage = "Record not locked, please reload the page."; result = ExceptionTypes.UnknownError; return(Json(new { ID = result, Message = errorMessage })); } objDOCMN_LookupTypeCorrelations.LastUpdatedByRef = loginUserId; returnMessage = "Record updated successfully."; } else { objDOCMN_LookupTypeCorrelations.CreatedByRef = loginUserId; returnMessage = "Record saved successfully."; } result = _objBLLookupCorrelations.SaveLookupTypeCorrelation(objDOCMN_LookupTypeCorrelations, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.LookupsCorrelation, (long)ExceptionTypes.Uncategorized, string.Empty, errorMessage); return(Json(new { ID = result, Message = "An error occured." })); } return(Json(new { ID = result, Message = returnMessage })); } catch (Exception ex) { BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.LookupsCorrelation, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString()); return(Json(new { ID = result, Message = "An error occured." })); } }
private static void GetAllLookupsCorrelationsIfNoCache() { long? TimeZone = (long)DefaultTimeZone.CentralStandardTime; string errorMsg = string.Empty; if (System.Web.HttpContext.Current.Cache[ConstantTexts.LookupTypeCorrelationCacheKey] == null || System.Web.HttpContext.Current.Cache[ConstantTexts.LookupMasterCorrelationCacheKey] == null) { List <DOCMN_LookupTypeCorrelations> lstDOCMN_LookupTypeCorrelations; List <DOCMN_LookupMasterCorrelations> lstDOCMN_LookupMasterCorrelations; DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations = new DOCMN_LookupTypeCorrelations(); objDOCMN_LookupTypeCorrelations.IsActive = true; BLLookupCorrelations objBLLookupCorrelation = new BLLookupCorrelations(); ExceptionTypes exResult = objBLLookupCorrelation.GetAllLookupTypeCorrelations(TimeZone, objDOCMN_LookupTypeCorrelations, out lstDOCMN_LookupTypeCorrelations, out lstDOCMN_LookupMasterCorrelations, out errorMsg); AddToCache(ConstantTexts.LookupTypeCorrelationCacheKey, lstDOCMN_LookupTypeCorrelations); AddToCache(ConstantTexts.LookupMasterCorrelationCacheKey, lstDOCMN_LookupMasterCorrelations); } }
private DOCMN_LookupTypeCorrelations PGetLookupCorelation(long lookupTypeCorrelationsId) { DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations = new DOCMN_LookupTypeCorrelations(); string errorMessage = string.Empty; try { ExceptionTypes result = _objBLLookupCorrelations.GetLookupCorelationByID(lookupTypeCorrelationsId, out objDOCMN_LookupTypeCorrelations, out errorMessage); objDOCMN_LookupTypeCorrelations.lstDOCMN_LookupType = PGetAllLookupTypeList(); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.LookupsCorrelation, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage); } return(objDOCMN_LookupTypeCorrelations); } catch (Exception ex) { BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.LookupsCorrelation, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString()); throw ex; } }
public ExceptionTypes SaveLookupTypeCorrelation(DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations, out string errorMessage) { _retValue = new ExceptionTypes(); return(_retValue = _objDALLookupCorrelations.SaveLookupTypeCorrelation(objDOCMN_LookupTypeCorrelations, out errorMessage)); }
public ExceptionTypes GetLookupCorelationByID(long lookupTypeCorrelationsId, out DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations, out string errorMessage) { _retValue = new ExceptionTypes(); return(_retValue = _objDALLookupCorrelations.GetLookupCorelationByID(lookupTypeCorrelationsId, out objDOCMN_LookupTypeCorrelations, out errorMessage)); }
public ExceptionTypes GetAllLookupTypeCorrelations(long?TimeZone, DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations, out List <DOCMN_LookupTypeCorrelations> lstDOCMN_LookupTypeCorrelations, out List <DOCMN_LookupMasterCorrelations> lstDOCMN_LookupMasterCorrelations, out string errorMessage) { _retValue = new ExceptionTypes(); return(_retValue = _objDALLookupCorrelations.GetAllLookupTypeCorrelations(TimeZone, objDOCMN_LookupTypeCorrelations, out lstDOCMN_LookupTypeCorrelations, out lstDOCMN_LookupMasterCorrelations, out errorMessage)); }
/// <summary> /// Search LookupTypeCorrelations /// </summary> /// <param name="lstDOCMN_LookupTypeCorrelations"></param> /// <returns></returns> public ExceptionTypes GetAllLookupTypeCorrelations(long?TimeZone, DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations, out List <DOCMN_LookupTypeCorrelations> lstDOCMN_LookupTypeCorrelations, out List <DOCMN_LookupMasterCorrelations> lstDOCMN_LookupMasterCorrelations, out string errorMessage) { _dsResult = new DataSet(); _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; long lErrocode = 0; long lErrorNumber = 0; errorMessage = string.Empty; lstDOCMN_LookupTypeCorrelations = new List <DOCMN_LookupTypeCorrelations>(); lstDOCMN_LookupMasterCorrelations = new List <DOCMN_LookupMasterCorrelations>(); try { if (objDOCMN_LookupTypeCorrelations.CMN_LookupTypeCorrelationsId > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_LookupTypeCorrelationsId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_LookupTypeCorrelations.CMN_LookupTypeCorrelationsId; _lstParameters.Add(sqlParam); } if (objDOCMN_LookupTypeCorrelations.CorrelationDescription != null && objDOCMN_LookupTypeCorrelations.CorrelationDescription != string.Empty) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CorrelationDescription"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOCMN_LookupTypeCorrelations.CorrelationDescription; _lstParameters.Add(sqlParam); } if (objDOCMN_LookupTypeCorrelations.CMN_LookupTypeParentRef > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_LookupTypeParentRef"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_LookupTypeCorrelations.CMN_LookupTypeParentRef; _lstParameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOCMN_LookupTypeCorrelations.IsActive; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; _lstParameters.Add(sqlParam); long executionResult = _daHelper.ExecuteSelectSP(ConstantTexts.SP_APP_SEL_LookupsCorrelation, _lstParameters.ToArray(), out _dsResult, out lErrocode, out lErrorNumber, out errorMessage); sqlParam = _lstParameters.FirstOrDefault(x => x.ParameterName == "@ErrorMessage"); if (sqlParam != null && sqlParam.Value != null) { errorMessage += sqlParam.Value.ToString(); } if (executionResult == (long)ExceptionTypes.Success && string.IsNullOrEmpty(errorMessage)) { MapAllLookupTypeCorrelations(TimeZone, _dsResult, out lstDOCMN_LookupTypeCorrelations); MapAllLookupMasterCorrelations(TimeZone, _dsResult, out lstDOCMN_LookupMasterCorrelations); return(ExceptionTypes.Success); } else { return(ExceptionTypes.UnknownError); } } catch (Exception ex) { errorMessage = ex.Message; return(ExceptionTypes.UnknownError); } finally { _dsResult = null; _lstParameters = null; } }
/// <summary> /// Save LookupType Correlation /// </summary> /// <param name="objDOCMN_LookupTypeCorrelations"></param> /// <param name="errorMessage"></param> /// <returns></returns> public ExceptionTypes SaveLookupTypeCorrelation(DOCMN_LookupTypeCorrelations objDOCMN_LookupTypeCorrelations, out string errorMessage) { _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; long lErrocode = 0; long lErrorNumber = 0; errorMessage = string.Empty; long lRowsEffected = 0; try { if (objDOCMN_LookupTypeCorrelations.CMN_LookupTypeCorrelationsId > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_LookupTypeCorrelationsId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_LookupTypeCorrelations.CMN_LookupTypeCorrelationsId; _lstParameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CorrelationDescription"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOCMN_LookupTypeCorrelations.CorrelationDescription; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_LookupTypeParentRef"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_LookupTypeCorrelations.CMN_LookupTypeParentRef; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_LookupTypeChildRef"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_LookupTypeCorrelations.CMN_LookupTypeChildRef; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = (objDOCMN_LookupTypeCorrelations.CMN_LookupTypeCorrelationsId > 0) ? objDOCMN_LookupTypeCorrelations.LastUpdatedByRef : objDOCMN_LookupTypeCorrelations.CreatedByRef; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOCMN_LookupTypeCorrelations.IsActive; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ScreenLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = ScreenType.LookupTypeCorrelation; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ErrorMessage"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = string.Empty; sqlParam.Direction = ParameterDirection.Output; sqlParam.Size = 2000; _lstParameters.Add(sqlParam); long executionResult = _daHelper.ExecuteDMLSP(ConstantTexts.SP_APP_INS_UPD_LookupTypeCorrelation, _lstParameters.ToArray(), out lErrocode, out lErrorNumber, out lRowsEffected, out errorMessage); sqlParam = _lstParameters.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); } finally { _lstParameters = null; } }