//get all data in mst_Concern table using USP_MST_GET_PSTATUS-SP
/// <summary>
/// To Get Pap's status
/// </summary>
/// <returns></returns>
public object GetPstatus()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SEL_PSTATUS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PstatusBO objPstatus = null;
PstatusList Pstatus = new PstatusList();
while (dr.Read())
{
objPstatus = new PstatusBO();
objPstatus.PAPDESIGNATIONID1 = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAPDESIGNATIONID")));
objPstatus.PAPDESIGNATION1 = dr.GetString(dr.GetOrdinal("PAPDESIGNATION"));
objPstatus.ISDELETED1 = dr.GetString(dr.GetOrdinal("ISDELETED"));
Pstatus.Add(objPstatus);
}
dr.Close();
return(Pstatus);
}
//get the data in mst_Concern table using USP_MST_GETSELECTCONCERN-SP signal Data based on ID
/// <summary>
/// To Get Pap's status by ID
/// </summary>
/// <param name="PAPDESIGNATIONID"></param>
/// <returns></returns>
public PstatusBO GetPstatusById(int PAPDESIGNATIONID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_PSTATUS";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("p_papdesignationid", PAPDESIGNATIONID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PstatusBO objPstatus = null;
PstatusList Users = new PstatusList();
objPstatus = new PstatusBO();
while (dr.Read())
{
if (ColumnExists(dr, "PAPDESIGNATION") && !dr.IsDBNull(dr.GetOrdinal("PAPDESIGNATION")))
{
objPstatus.PAPDESIGNATION1 = dr.GetString(dr.GetOrdinal("PAPDESIGNATION"));
}
if (ColumnExists(dr, "PAPDESIGNATIONID") && !dr.IsDBNull(dr.GetOrdinal("PAPDESIGNATIONID")))
{
objPstatus.PAPDESIGNATIONID1 = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAPDESIGNATIONID")));
}
}
dr.Close();
return(objPstatus);
}
