/// <summary> /// For Lookup Screen (To get Lookpu type & related lookup Master) /// </summary> /// <param name="dsResult"></param> /// <param name="objDOCMN_LookupType"></param> /// <returns></returns> private ExceptionTypes MapLookupMaster(DataSet dsResult, out DOCMN_LookupType objDOCMN_LookupType) { objDOCMN_LookupType = new DOCMN_LookupType(); try { if (dsResult != null && dsResult.Tables.Count > 0 && dsResult.Tables[0].Rows.Count > 0) { DataRow dr = dsResult.Tables[0].Rows[0]; objDOCMN_LookupType.CMN_LookupTypeId = dr["CMN_LookupTypeId"].ToInt64(); objDOCMN_LookupType.LockedByRef = (!dr["LockedByRef"].IsNull()) ? dr["LockedByRef"].ToInt64() : 0; objDOCMN_LookupType.UTCLockedOn = (!dr["UTCLockedOn"].IsNull()) ? Convert.ToDateTime(dr["UTCLockedOn"]) : (DateTime?)null; objDOCMN_LookupType.LookupTypeDescription = (!dr["LookupTypeDescription"].IsNull()) ? dr["LookupTypeDescription"].NullToString() : string.Empty; objDOCMN_LookupType.UTCCreatedOn = (!dr["UTCCreatedOn"].IsNull()) ? Convert.ToDateTime(dr["UTCCreatedOn"]) : DateTime.UtcNow; objDOCMN_LookupType.CreatedByRef = (!dr["CreatedByRef"].IsNull()) ? dr["CreatedByRef"].ToInt64() : 0; objDOCMN_LookupType.UTCLastUpdatedOn = (!dr["UTCLastUpdatedOn"].IsNull()) ? Convert.ToDateTime(dr["UTCLastUpdatedOn"]) : DateTime.UtcNow; objDOCMN_LookupType.LastUpdatedByRef = (!dr["LastUpdatedByRef"].IsNull()) ? dr["LastUpdatedByRef"].ToInt64() : 0; objDOCMN_LookupType.LockedByName = (!dr["LockedByName"].IsNull()) ? dr["LockedByName"].NullToString() : string.Empty; objDOCMN_LookupType.CreatedByName = (!dr["CreatedByName"].IsNull()) ?dr["CreatedByName"].NullToString() : string.Empty; objDOCMN_LookupType.LastUpdatedByName = (!dr["LastUpdatedByName"].IsNull()) ? dr["LastUpdatedByName"].NullToString() : string.Empty; objDOCMN_LookupType.IsActive = Convert.ToBoolean(dr["IsActive"]); } if (dsResult != null && dsResult.Tables.Count > 1 && dsResult.Tables[1].Rows.Count > 0) { objDOCMN_LookupType.lstDOCMN_LookupMaster = dsResult.Tables[1].AsEnumerable().Select(dr => new DOCMN_LookupMaster { CMN_LookupMasterId = Convert.ToInt64(dr["CMN_LookupMasterId"]), CMN_LookupTypeRef = Convert.ToInt64(dr["CMN_LookupTypeRef"]), LookupDescription = (!dr["LookupDescription"].IsNull()) ? dr["LookupDescription"].NullToString() : string.Empty, LookupValue = (!dr["LookupValue"].IsNull()) ? dr["LookupValue"].NullToString() : string.Empty, LookupValue1 = (!dr["LookupValue1"].IsNull()) ? dr["LookupValue1"].NullToString() : string.Empty, LookupValue2 = (!dr["LookupValue2"].IsNull()) ? dr["LookupValue2"].NullToString() : string.Empty, DisplayOrder = (!dr["DisplayOrder"].IsNull()) ? dr["DisplayOrder"].ToInt64() : (Int64?)null, UTCCreatedOn = (!dr["UTCCreatedOn"].IsNull()) ? Convert.ToDateTime(dr["UTCCreatedOn"]) : DateTime.UtcNow, CreatedByRef = (!dr["CreatedByRef"].IsNull()) ? dr["CreatedByRef"].ToInt64() : 0, UTCLastUpdatedOn = (!dr["UTCLastUpdatedOn"].IsNull()) ? Convert.ToDateTime(dr["UTCLastUpdatedOn"]) : DateTime.UtcNow, LastUpdatedByRef = (!dr["LastUpdatedByRef"].IsNull()) ? dr["LastUpdatedByRef"].ToInt64() : (Int64?)null, CreatedByName = (!dr["CreatedByName"].IsNull()) ? dr["CreatedByName"].NullToString() : string.Empty, LastUpdatedByName = (!dr["LastUpdatedByName"].IsNull()) ? dr["LastUpdatedByName"].NullToString() : string.Empty, IsActive = dr["IsActive"].ToBoolean() }).ToList(); } return(ExceptionTypes.Success); } catch (Exception ex) { //need log throw ex; } }
/// <summary> /// GetLookupMasterByLkupTypeID /// </summary> /// <param name="lookupTypeId"></param> /// <param name="lstDOCMN_LookupType"></param> /// <returns></returns> public ExceptionTypes GetLookupMasterByLkupTypeID(long?lookupTypeId, out DOCMN_LookupType objDOCMN_LookupType) { _dsResult = new DataSet(); _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; long lErrocode = 0; long lErrorNumber = 0; string errorMessage = string.Empty; objDOCMN_LookupType = new DOCMN_LookupType(); try { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_LookupTypeId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = lookupTypeId; _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_Lookups, _lstParameters.ToArray(), out _dsResult, out lErrocode, out lErrorNumber, out errorMessage); if (executionResult == 0) { return(MapLookupMaster(_dsResult, out objDOCMN_LookupType)); } return(ExceptionTypes.SqlException); } catch (Exception) { return(ExceptionTypes.UnknownError); } finally { _dsResult = null; _lstParameters = null; } }
/// <summary> /// Save / Modify lookup Type /// </summary> /// <param name="objDOCMN_LookupType"></param> /// <returns></returns> public ActionResult SaveLookupType(DOCMN_LookupType objDOCMN_LookupType) { errorMessage = string.Empty; ExceptionTypes result = new ExceptionTypes(); try { long loginUserId = currentUser.ADM_UserMasterId; string returnMessage = string.Empty; if (objDOCMN_LookupType.CMN_LookupTypeId > 0) //Edit Mode { BLCommon objCommon = new BLCommon(); if (!objCommon.ValidateLockBeforeSave(loginUserId, (long)ScreenType.LookupType, objDOCMN_LookupType.CMN_LookupTypeId)) { errorMessage = "Record not locked, please reload the page."; result = ExceptionTypes.UnknownError; return(Json(new { ID = result, Message = errorMessage })); } objDOCMN_LookupType.LastUpdatedByRef = loginUserId; returnMessage = "Record updated successfully."; } else { objDOCMN_LookupType.CreatedByRef = loginUserId; //Add Mode returnMessage = "Record saved successfully."; } result = _objBLLookup.SaveLookupType(objDOCMN_LookupType, out errorMessage); if (result != (long)ExceptionTypes.Success) { BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Lookups, (long)ExceptionTypes.Uncategorized, string.Empty, errorMessage); return(Json(new { ID = result, Message = "An error occured while updating DB." })); } return(Json(new { ID = result, Message = returnMessage })); } catch (Exception ex) { ViewBag.ErrorMessage = ex.ToString(); BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Lookups, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString()); return(Json(new { ID = result, Message = "An error occured while updating DB." })); } }
private DOCMN_LookupType PGetLookupMasterByLkupTypeID(long?lookupTypeId) { DOCMN_LookupType objDOCMN_LookupType = new DOCMN_LookupType(); try { ExceptionTypes result = _objBLLookup.GetLookupMasterByLkupTypeID(lookupTypeId, out objDOCMN_LookupType); if (result != (long)ExceptionTypes.Success) { //Log Error BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.Lookups, (long)ExceptionTypes.Uncategorized, string.Empty, "Something Went Wrong in PGetLookupMasterByLkupTypeID"); } return(objDOCMN_LookupType); } catch (Exception ex) { BLCommon.LogError(0, MethodBase.GetCurrentMethod().Name, (long)ErrorModuleName.LookupsCorrelation, (long)ExceptionTypes.Uncategorized, string.Empty, ex.ToString()); throw ex; } }
public ExceptionTypes SaveLookupType(DOCMN_LookupType objDOCMN_LookupType, out string errorMessage) { _retValue = new ExceptionTypes(); return(_retValue = _objDALLookup.SaveLookupType(objDOCMN_LookupType, out errorMessage)); }
public ExceptionTypes GetLookupMasterByLkupTypeID(long?lookupTypeId, out DOCMN_LookupType objDOCMN_LookupType) { _retValue = new ExceptionTypes(); return(_retValue = _objDALLookup.GetLookupMasterByLkupTypeID(lookupTypeId, out objDOCMN_LookupType)); }
/// <summary> /// Save/Update LookupType /// </summary> /// <param name="objDOCMN_LookupType"></param> /// <param name="errorMessage"></param> /// <returns></returns> public ExceptionTypes SaveLookupType(DOCMN_LookupType objDOCMN_LookupType, out string errorMessage) { _lstParameters = new List <SqlParameter>(); SqlParameter sqlParam; long lErrocode = 0; long lErrorNumber = 0; errorMessage = string.Empty; long lRowsEffected = 0; try { if (objDOCMN_LookupType.CMN_LookupTypeId > 0) { sqlParam = new SqlParameter(); sqlParam.ParameterName = "@CMN_LookupTypeId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = objDOCMN_LookupType.CMN_LookupTypeId; _lstParameters.Add(sqlParam); } sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LookupTypeDescription"; sqlParam.SqlDbType = SqlDbType.VarChar; sqlParam.Value = objDOCMN_LookupType.LookupTypeDescription; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@IsActive"; sqlParam.SqlDbType = SqlDbType.Bit; sqlParam.Value = objDOCMN_LookupType.IsActive; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@ScreenLkup"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = ScreenType.LookupType; _lstParameters.Add(sqlParam); sqlParam = new SqlParameter(); sqlParam.ParameterName = "@LoginUserId"; sqlParam.SqlDbType = SqlDbType.BigInt; sqlParam.Value = (objDOCMN_LookupType.CMN_LookupTypeId > 0) ? objDOCMN_LookupType.LastUpdatedByRef : objDOCMN_LookupType.CreatedByRef; _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_LookupType, _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; } }