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