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