/// <summary>
/// To fetch details from database
/// </summary>
/// <returns></returns>
public FenceList GetFencedescription( )
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_FENCEDATA";
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);
FenceBO BOobj = null;
FenceList Listobj = new FenceList();
while (dr.Read())
{
BOobj = new FenceBO();
BOobj.Fenceid = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("FENCEID"))));
BOobj.Fencedescription = dr.GetValue(dr.GetOrdinal("FENCEDESCRIPTION")).ToString();
Listobj.Add(BOobj);
}
dr.Close();
return(Listobj);
}
/// <summary>
/// Getfencedatarow
/// </summary>
/// <param name="Pap_fenceid"></param>
/// <returns></returns>
public FenceBO Getfencedatarow(int Pap_fenceid)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_FENCE";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("F_PAP_FENCEID", Pap_fenceid);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
FenceBO FenceBOobj = null;
FenceList FenceListobj = new FenceList();
FenceBOobj = new FenceBO();
while (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("pap_fenceid")))
{
FenceBOobj.Pap_fenceid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("pap_fenceid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("fenceid")))
{
FenceBOobj.Fenceid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("fenceid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("fen_dimen_length")))
{
FenceBOobj.Fen_dimen_length = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("fen_dimen_length")));
}
if (!dr.IsDBNull(dr.GetOrdinal("fen_dimen_height")))
{
FenceBOobj.Fen_dimen_height = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("fen_dimen_height")));
}
if (!dr.IsDBNull(dr.GetOrdinal("depreciatedvalue")))
{
FenceBOobj.Depreciatedvalue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("depreciatedvalue")));
}
}
dr.Close();
return(FenceBOobj);
}
/// <summary>
/// To fetch details from database
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public FenceList GetFencedata(int householdID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_FENCE";
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);
FenceBO FenceBOobj = null;
FenceList FenceListobj = new FenceList();
while (dr.Read())
{
FenceBOobj = new FenceBO();
FenceBOobj.Pap_fenceid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAP_FENCEID")));
FenceBOobj.Fencedescription = dr.GetString(dr.GetOrdinal("FENCEDESCRIPTION"));
FenceBOobj.Fen_dimen_length = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("FEN_DIMEN_LENGTH")));
FenceBOobj.Fen_dimen_height = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("FEN_DIMEN_HEIGHT")));
FenceBOobj.Depreciatedvalue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DEPRECIATEDVALUE")));
FenceBOobj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
FenceListobj.Add(FenceBOobj);
}
dr.Close();
return(FenceListobj);
}
