/// <summary>
/// To fetch details from database
/// </summary>
/// <returns></returns>
public CulturePropertiesList GetCulturalPropertyType()
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_NAME_CULTURPROP";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CulturPropertiesBO BOobj = null;
CulturePropertiesList Listobj = new CulturePropertiesList();
while (dr.Read())
{
BOobj = new CulturPropertiesBO();
BOobj.CULTUREPROPTYPEID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPEID"))));
BOobj.CULTUREPROPTYP = dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPE")).ToString();
Listobj.Add(BOobj);
}
dr.Close();
return(Listobj);
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public CulturePropertiesList GetCultureProp(int householdID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_CULTURPROP";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", householdID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CulturPropertiesBO CulturPropertiesobj = null;
CulturePropertiesList Listobj = new CulturePropertiesList();
while (dr.Read())
{
CulturPropertiesobj = new CulturPropertiesBO();
CulturPropertiesobj.CULTURALPROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("culturalpropid")));
if (!dr.IsDBNull(dr.GetOrdinal("cultureproptype")))
{
CulturPropertiesobj.CULTUREPROPTYP = dr.GetString(dr.GetOrdinal("cultureproptype"));
}
if (!dr.IsDBNull(dr.GetOrdinal("culturepropdescription")))
{
CulturPropertiesobj.CULTUREPROPDESCRIPTION = dr.GetString(dr.GetOrdinal("culturepropdescription"));
}
else
{
CulturPropertiesobj.CULTUREPROPDESCRIPTION = " ";
}
CulturPropertiesobj.CULT_VALUATIONAMOUNT = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("cult_valuationamount")));
Listobj.Add(CulturPropertiesobj);
}
dr.Close();
return(Listobj);
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="culTURALPROPID"></param>
/// <returns></returns>
public CulturPropertiesBO GetData(int culTURALPROPID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_CULTURPROP";//"USP_TRN_GET_DAMAGE_CROPS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("C_CULTURALPROPID", culTURALPROPID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CulturPropertiesBO CulturPropertiesobj = null;
CulturePropertiesList Listobj = new CulturePropertiesList();
CulturPropertiesobj = new CulturPropertiesBO();
while (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("CULTURALPROPID")))
{
CulturPropertiesobj.CULTURALPROPID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTURALPROPID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CULTUREPROPTYPEID")))
{
CulturPropertiesobj.CULTUREPROPTYPEID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULTUREPROPTYPEID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CULTUREPROPDESCRIPTION")))
{
CulturPropertiesobj.CULTUREPROPDESCRIPTION = dr.GetString(dr.GetOrdinal("CULTUREPROPDESCRIPTION"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CULT_DIMEN_LENGTH")))
{
CulturPropertiesobj.CULT_DIMEN_LENGTH = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULT_DIMEN_LENGTH")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CULT_DIMEN_WIDTH")))
{
CulturPropertiesobj.CULT_DIMEN_WIDTH = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CULT_DIMEN_WIDTH")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CULT_DEPRECIATEDVALUE")))
{
CulturPropertiesobj.CULT_DEPRECIATEDVALUE = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CULT_DEPRECIATEDVALUE")));
}
if (!dr.IsDBNull(dr.GetOrdinal("CULT_VALUATIONAMOUNT")))
{
CulturPropertiesobj.CULT_VALUATIONAMOUNT = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("CULT_VALUATIONAMOUNT")));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
CulturPropertiesobj.ISDELETED = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
}
dr.Close();
return(CulturPropertiesobj);
}
