using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Oracle.ManagedDataAccess.Client;
using System.Data;
namespace ResfullApi.Models
{
    public class happyDataAccess
    {
        public happyDataAccess()
        {

        }


   

        public static DataSet SearchCode(string v_users, string n_serviceid,  string code,string fromDate,string toDate,string winType)
        {

            string str;
            str = "";
            str = "HAPPY_CALL_PKG.SEARCH_CODE";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_code", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_winType", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_users;
            parms[1].Value = n_serviceid;
            parms[2].Value = code;
            parms[3].Value = fromDate;
            parms[4].Value = toDate;
            parms[5].Value = winType;

            return DataAccess.getDataFromProcedure(str, "", parms);
        }

        

    }
}