/// <summary> /// To GET ALL CONCERN /// </summary> /// <returns></returns> public OptionAvailableList GetAllOptionAvail() { // used in Master page OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = " USP_MST_GETALLOPTIONAVAIL"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); OptionAvailableBO objOptionAvailableBO = null; OptionAvailableList lstooptionavail = new OptionAvailableList(); while (dr.Read()) { objOptionAvailableBO = new OptionAvailableBO(); objOptionAvailableBO.ID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ID"))); objOptionAvailableBO.OptionAvailable = dr.GetString(dr.GetOrdinal("OPTIONAVAILABLE")); objOptionAvailableBO.Isdeleted = dr.GetString(dr.GetOrdinal("isdeleted")); lstooptionavail.Add(objOptionAvailableBO); } dr.Close(); return(lstooptionavail); }
/// <summary> /// get the data based on ID /// </summary> /// <param name="ConcernID"></param> /// <returns></returns> public OptionAvailableBO GetAllOptionById(int optionID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETOPTNBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("ID_", optionID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); OptionAvailableBO objoptionavail = null; OptionAvailableList Users = new OptionAvailableList(); objoptionavail = new OptionAvailableBO(); while (dr.Read()) { if (ColumnExists(dr, "OPTIONAVAILABLE") && !dr.IsDBNull(dr.GetOrdinal("OPTIONAVAILABLE"))) { objoptionavail.OptionAvailable = dr.GetString(dr.GetOrdinal("OPTIONAVAILABLE")); } if (ColumnExists(dr, "ID") && !dr.IsDBNull(dr.GetOrdinal("ID"))) { objoptionavail.ID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ID"))); } } dr.Close(); return(objoptionavail); }