public GraveList GetGraveFinish()
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_GRAVEDATA";
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);
GraveBO BOobj = null;
GraveList Listobj = new GraveList();
while (dr.Read())
{
BOobj = new GraveBO();
BOobj.Grv_finishid = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("GRV_FINISHID"))));
BOobj.Grv_finishtype = dr.GetValue(dr.GetOrdinal("GRV_FINISHTYPE")).ToString();
Listobj.Add(BOobj);
}
dr.Close();
return(Listobj);
}
/// <summary>
/// to fetch details
/// </summary>
/// <param name="Pap_graveid"></param>
/// <returns></returns>
public GraveBO Getdatarow(int Pap_graveid)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_GRAVE";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("G_PAP_GRAVEID", Pap_graveid);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
GraveBO GraveBOobj = null;
GraveList GraveListobj = new GraveList();
GraveBOobj = new GraveBO();
while (dr.Read())
{
if (!dr.IsDBNull(dr.GetOrdinal("pap_graveid")))
{
GraveBOobj.Pap_graveid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("pap_graveid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("grv_finishid")))
{
GraveBOobj.Grv_finishid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("grv_finishid")));
}
if (!dr.IsDBNull(dr.GetOrdinal("grv_dimen_length")))
{
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("grv_dimen_length")));
}
if (!dr.IsDBNull(dr.GetOrdinal("grv_dimen_width")))
{
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("grv_dimen_width")));
}
if (!dr.IsDBNull(dr.GetOrdinal("depreciatedvalue")))
{
GraveBOobj.Depreciatedvalue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("depreciatedvalue")));
}
if (!dr.IsDBNull(dr.GetOrdinal("othergravefinish")))
{
GraveBOobj.Othergravefinish = dr.GetString(dr.GetOrdinal("othergravefinish"));
}
}
dr.Close();
return(GraveBOobj);
}
/// <summary>
/// to fetch details
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public GraveList GetGravedata(int householdID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_GRAVE";
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);
GraveBO GraveBOobj = null;
GraveList GraveListobj = new GraveList();
while (dr.Read())
{
GraveBOobj = new GraveBO();
GraveBOobj.Pap_graveid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAP_GRAVEID")));
GraveBOobj.Grv_finishtype = dr.GetString(dr.GetOrdinal("GRV_FINISHTYPE"));
GraveBOobj.Grv_dimen_length = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("GRV_DIMEN_LENGTH")));
GraveBOobj.Grv_dimen_width = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("GRV_DIMEN_WIDTH")));
GraveBOobj.Depreciatedvalue = Convert.ToDecimal(dr.GetValue(dr.GetOrdinal("DEPRECIATEDVALUE")));
GraveBOobj.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
GraveListobj.Add(GraveBOobj);
}
dr.Close();
return(GraveListobj);
}
