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