public ActionResult SaveCorrelationMaster(DOCMN_LookupMasterCorrelationsExtended objDOCMN_LookupMasterCorrelationsExtended)
{
errorMessage = string.Empty;
ExceptionTypes result = new ExceptionTypes();
long loginUserId = currentUser.ADM_UserMasterId;
string returnMessage = string.Empty;
try
{
if (objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CMN_LookupMasterCorrelationsId > 0)
{
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.LastUpdatedByRef = loginUserId;
returnMessage = "Record updated successfully.";
}
else
{
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CreatedByRef = loginUserId;
returnMessage = "Record saved successfully.";
}
result = _objBLLookupCorrelations.SaveCorrelationMaster(objDOCMN_LookupMasterCorrelationsExtended, 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 void MapLookupCorelationMasterByID(DataSet dsResult, long corTypeID, long corMasterID, out DOCMN_LookupMasterCorrelationsExtended objDOCMN_LookupMasterCorrelationsExtended)
{
objDOCMN_LookupMasterCorrelationsExtended = new DOCMN_LookupMasterCorrelationsExtended();
try
{
if (_dsResult != null && _dsResult.Tables.Count > 0 && _dsResult.Tables[0].Rows.Count > 0)
{
DataRow dr = _dsResult.Tables[0].Rows[0];
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupTypeCorrelations.CMN_LookupTypeCorrelationsId = dr["CMN_LookupTypeCorrelationsId"].ToInt64();
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupTypeCorrelations.CMN_LookupTypeParentRef = dr["CMN_LookupTypeParentRef"].ToInt64();
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupTypeCorrelations.CMN_LookupTypeChildRef = (!dr["CMN_LookupTypeChildRef"].IsNull()) ? dr["CMN_LookupTypeChildRef"].ToInt64() : 0;
}
if (_dsResult != null && _dsResult.Tables.Count > 1 && _dsResult.Tables[1].Rows.Count > 0 && corMasterID > 0)
{
DataRow dr = _dsResult.Tables[1].Rows[0];
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CMN_LookupMasterCorrelationsId = dr["CMN_LookupMasterCorrelationsId"].ToInt64();
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CMN_LookupTypeCorrelationsRef = dr["CMN_LookupTypeCorrelationsRef"].ToInt64();
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CMN_LookupMasterParentRef = (!dr["CMN_LookupMasterParentRef"].IsNull()) ? dr["CMN_LookupMasterParentRef"].ToInt64() : 0;
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CMN_LookupMasterChildRef = (!dr["CMN_LookupMasterChildRef"].IsNull()) ? dr["CMN_LookupMasterChildRef"].ToInt64() : 0;
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CorrelationDescription = (!dr["CorrelationDescription"].IsNull()) ? dr["CorrelationDescription"].NullToString() : string.Empty;
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.DisplayOrder = (!dr["DisplayOrder"].IsNull()) ? dr["DisplayOrder"].ToInt64() : 0;
objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.IsActive = dr["IsActive"].ToBoolean();
}
}
catch (Exception ex)
{
throw ex;
}
}
private DOCMN_LookupMasterCorrelationsExtended PGetCorrelationMasterByID(long lkupCorelationTypeID, long lkupCorelationMasterID)
{
DOCMN_LookupMasterCorrelationsExtended objDOCMN_LookupMasterCorrelationsExtended = new DOCMN_LookupMasterCorrelationsExtended();
string errorMessage = string.Empty;
try
{
ExceptionTypes result = _objBLLookupCorrelations.GetCorrelationMasterByID(lkupCorelationTypeID, lkupCorelationMasterID, out objDOCMN_LookupMasterCorrelationsExtended, out errorMessage);
objDOCMN_LookupMasterCorrelationsExtended.lstDOCMN_LookupMasterParent = CacheUtility.GetAllLookupsFromCache(objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupTypeCorrelations.CMN_LookupTypeParentRef);
objDOCMN_LookupMasterCorrelationsExtended.lstDOCMN_LookupMasterChild = CacheUtility.GetAllLookupsFromCache(objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupTypeCorrelations.CMN_LookupTypeChildRef);
if (result != (long)ExceptionTypes.Success)
{
BLCommon.LogError(currentUser.ADM_UserMasterId, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.LookupsCorrelation, (long)ExceptionTypes.Uncategorized, errorMessage, errorMessage);
}
return(objDOCMN_LookupMasterCorrelationsExtended);
}
catch (Exception ex)
{
BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.LookupsCorrelation, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString());
throw ex;
}
}
public ExceptionTypes SaveCorrelationMaster(DOCMN_LookupMasterCorrelationsExtended objDOCMN_LookupMasterCorrelationsExtended, out string errorMessage)
{
_retValue = new ExceptionTypes();
return(_retValue = _objDALLookupCorrelations.SaveCorrelationMaster(objDOCMN_LookupMasterCorrelationsExtended, out errorMessage));
}
public ExceptionTypes GetCorrelationMasterByID(long lkupCorelationTypeID, long lkupCorelationMasterID, out DOCMN_LookupMasterCorrelationsExtended objDOCMN_LookupMasterCorrelationsExtended, out string errorMessage)
{
_retValue = new ExceptionTypes();
return(_retValue = _objDALLookupCorrelations.GetCorrelationMasterByID(lkupCorelationTypeID, lkupCorelationMasterID, out objDOCMN_LookupMasterCorrelationsExtended, out errorMessage));
}
public ExceptionTypes SaveCorrelationMaster(DOCMN_LookupMasterCorrelationsExtended objDOCMN_LookupMasterCorrelationsExtended, out string errorMessage)
{
_lstParameters = new List <SqlParameter>();
SqlParameter sqlParam;
long lErrocode = 0;
long lErrorNumber = 0;
errorMessage = string.Empty;
long lRowsEffected = 0;
try
{
if (objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CMN_LookupMasterCorrelationsId > 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_LookupMasterCorrelationsId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CMN_LookupMasterCorrelationsId;
_lstParameters.Add(sqlParam);
}
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_LookupTypeCorrelationsRef";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupTypeCorrelations.CMN_LookupTypeCorrelationsId;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CorrelationDescription";
sqlParam.SqlDbType = SqlDbType.VarChar;
sqlParam.Value = objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CorrelationDescription;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_LookupMasterParentRef";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CMN_LookupMasterParentRef;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_LookupMasterChildRef";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CMN_LookupMasterChildRef;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@LoginUserId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = (objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CMN_LookupMasterCorrelationsId > 0) ? objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.LastUpdatedByRef : objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.CreatedByRef;
_lstParameters.Add(sqlParam);
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@IsActive";
sqlParam.SqlDbType = SqlDbType.Bit;
sqlParam.Value = objDOCMN_LookupMasterCorrelationsExtended.objDOCMN_LookupMasterCorrelations.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.ExecuteDMLSP(ConstantTexts.SP_APP_INS_UPD_LookupMasterCorrelation, _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;
}
}
/// <summary>
/// Get Correlation Master Popup Data
/// </summary>
/// <param name="lkupCorelationMasterID"></param>
/// <param name="objDOCMN_LookupMasterCorrelationsExtended"></param>
/// <returns></returns>
public ExceptionTypes GetCorrelationMasterByID(long lkupCorelationTypeID, long lkupCorelationMasterID, out DOCMN_LookupMasterCorrelationsExtended objDOCMN_LookupMasterCorrelationsExtended, out string errorMessage)
{
_dsResult = new DataSet();
_lstParameters = new List <SqlParameter>();
SqlParameter sqlParam;
long lErrocode = 0;
long lErrorNumber = 0;
errorMessage = string.Empty;
objDOCMN_LookupMasterCorrelationsExtended = new DOCMN_LookupMasterCorrelationsExtended();
try
{
if (lkupCorelationTypeID > 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_LookupTypeCorrelationsId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = lkupCorelationTypeID;
_lstParameters.Add(sqlParam);
}
if (lkupCorelationMasterID > 0)
{
sqlParam = new SqlParameter();
sqlParam.ParameterName = "@CMN_LookupMasterCorrelationsId";
sqlParam.SqlDbType = SqlDbType.BigInt;
sqlParam.Value = lkupCorelationMasterID;
_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))
{
MapLookupCorelationMasterByID(_dsResult, lkupCorelationTypeID, lkupCorelationMasterID, out objDOCMN_LookupMasterCorrelationsExtended);
return(ExceptionTypes.Success);
}
else
{
return(ExceptionTypes.UnknownError);
}
}
catch (Exception ex)
{
errorMessage = ex.Message;
return(ExceptionTypes.UnknownError);
}
finally
{
_dsResult = null;
_lstParameters = null;
}
}
