public FinalValuationList getFinalValuationById(int HHID) { proc = "USP_TRN_GET_FINALVALUATION"; cnn = new OracleConnection(con); FinalValuationBO objFinalValuation = null; FinalValuationList lstFinalValuation = new FinalValuationList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("hhid_", HHID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objFinalValuation = new FinalValuationBO(); objFinalValuation = MapData(dr); lstFinalValuation.Add(objFinalValuation); } dr.Close(); } catch (Exception ex) { throw ex; } return(null); }
/// <summary> /// To fetch details /// </summary> /// <param name="HHID"></param> /// <returns></returns> public FinalValuationBO getNegIndValuation(int HHID) { proc = "USP_TRN_GET_FINVALIND"; cnn = new OracleConnection(con); FinalValuationBO objFinalValuation = null; FinalValuationList lstFinalValuation = new FinalValuationList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("HHID_", HHID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objFinalValuation = new FinalValuationBO(); if (!dr.IsDBNull(dr.GetOrdinal("CROPVALUENEGAMT"))) { objFinalValuation.CropNegValue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CROPVALUENEGAMT"))); } if (!dr.IsDBNull(dr.GetOrdinal("LANDVALUENEGAMT"))) { objFinalValuation.LandNegValue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("LANDVALUENEGAMT"))); } if (!dr.IsDBNull(dr.GetOrdinal("FIXTUREVALUENEGAMT"))) { objFinalValuation.FixtureNegValue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("FIXTUREVALUENEGAMT"))); } if (!dr.IsDBNull(dr.GetOrdinal("REPLACEMENTVALUENEGAMT"))) { objFinalValuation.ReplacementNegValue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("REPLACEMENTVALUENEGAMT"))); } if (!dr.IsDBNull(dr.GetOrdinal("DAMAGEDCROPVALUENEGAMT"))) { objFinalValuation.DamagedcropNegValue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DAMAGEDCROPVALUENEGAMT"))); } if (!dr.IsDBNull(dr.GetOrdinal("CULTURALPROPVALUENEGAMT"))) { objFinalValuation.CulturalpropertyNegValue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CULTURALPROPVALUENEGAMT"))); } if (!dr.IsDBNull(dr.GetOrdinal("CROPVALUENEGAMTAPPRVD"))) { objFinalValuation.CropNegValueAppStatus = dr.GetString(dr.GetOrdinal("CROPVALUENEGAMTAPPRVD")); } if (!dr.IsDBNull(dr.GetOrdinal("LANDVALUENEGAMTAPPRVD"))) { objFinalValuation.LandNegValueAppStatus = dr.GetString(dr.GetOrdinal("LANDVALUENEGAMTAPPRVD")); } if (!dr.IsDBNull(dr.GetOrdinal("FIXTUREVALUENEGAMTAPPRVD"))) { objFinalValuation.FixtureNegValueAppStatus = dr.GetString(dr.GetOrdinal("FIXTUREVALUENEGAMTAPPRVD")); } if (!dr.IsDBNull(dr.GetOrdinal("REPLACEMENTVALUENEGAMTAPPRVD"))) { objFinalValuation.ReplacementNegValueAppStatus = dr.GetString(dr.GetOrdinal("REPLACEMENTVALUENEGAMTAPPRVD")); } if (!dr.IsDBNull(dr.GetOrdinal("DAMAGEDCROPVALUENEGAMTAPPRVD"))) { objFinalValuation.DamagedcropNegValueAppStatus = dr.GetString(dr.GetOrdinal("DAMAGEDCROPVALUENEGAMTAPPRVD")); } if (!dr.IsDBNull(dr.GetOrdinal("CULTURALPROPVALUENEGAMTAPPRVD"))) { objFinalValuation.CulturalpropertyNegValueAppStatus = dr.GetString(dr.GetOrdinal("CULTURALPROPVALUENEGAMTAPPRVD")); } // lstFinalValuation.Add(objFinalValuation); } dr.Close(); } catch (Exception ex) { throw ex; } return(objFinalValuation); }