public IEnumerable<PS_Bins> GetAllData()
{
List<PS_Bins> lstr = new List<PS_Bins>();
using (OracleConnection con = new OracleConnection(connectionString))
{
OracleCommand cmd = new OracleCommand("GET_PS_BINS", con);
cmd.Parameters.Add("PARAM1", OracleDbType.RefCursor, ParameterDirection.Output);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
using (OracleDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
PS_Bins pS_ = new PS_Bins();
pS_.ID = Convert.ToInt32(rdr["ID"]);
pS_.Code = (rdr["CODE"]).ToString();
pS_.Name = (rdr["NAME"]).ToString();
pS_.Card_Name = (rdr["Card_Type"]).ToString();
lstr.Add(pS_);
}
}
con.Close();
}
return lstr;
}