using Oracle.DataAccess.Client;

/// <summary>
        /// Gets some t_points_alm3limitconfigs_new record dynamic for DataSet from the database according to the where and orderby conditions.
        /// </summary>
        /// <param name="whereCondition"></param>
        /// <param name="orderByCondition"></param>
        /// <returns></returns>
        public DataSet getRecordsDynamicForDS(string whereCondition, string orderByCondition)
        {
 OracleParameter[] parms = new OracleParameter[3];
            if (string.IsNullOrEmpty(whereCondition) == true)
            {
                whereCondition = string.Empty;
            }
            if (string.IsNullOrEmpty(orderByCondition) == true)
            {
                orderByCondition = string.Empty;
            }
            parms[0] = new OracleParameter("a_WhereCondition", whereCondition);
            parms[1] = new OracleParameter("a_OrderByExpression", orderByCondition);
            parms[2] = new OracleParameter("c_Result", OracleDbType.RefCursor);
            parms[2].Direction = ParameterDirection.Output;
            DataSet ds = dal.ExecuteDataSet(CommandType.StoredProcedure, "TPRI.P_PT_ALM3LIMITCONFIG_SW", parms);
            return ds;
}