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

        }




        /*
         * 
            ********************************************    CAC HAM CUA LUCKY SIX **********************************
         * 
         */



        public static DataSet LKS_BET(string v_users, string v_serviceid, string v_listNumber, string v_money, string v_times)
        {

            string str;
            str = "";
            str = "lks_pkg.LKS_BET";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                new OracleParameter("v_listNumber", OracleDbType.NVarchar2),
                                new OracleParameter("v_money", OracleDbType.NVarchar2),
                                new OracleParameter("v_times", OracleDbType.NVarchar2),
                               
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_users;
            parms[1].Value = v_serviceid;
            parms[2].Value = v_listNumber;
            parms[3].Value = v_money;
            parms[4].Value = v_times;

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

        public static DataSet LKS_BET_GET_LIST(string v_users, string v_serviceid, string v_status,string v_date,string v_top,string v_isWin)
        {

            string str;
            str = "";
            str = "lks_pkg.LKS_BET_GET_LIST";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                new OracleParameter("v_status", OracleDbType.NVarchar2),
                                new OracleParameter("v_date", OracleDbType.NVarchar2),
                               new OracleParameter("v_top", OracleDbType.NVarchar2),
                               new OracleParameter("v_isWin", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_users;
            parms[1].Value = v_serviceid;
            parms[2].Value = v_status;
            parms[3].Value = v_date;
            parms[4].Value = v_top;
            parms[5].Value = v_isWin;


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


        public static DataSet LKS_BET_GET_TOP_USERS(string v_users, string v_serviceid, string v_date, string v_top)
        {

            string str;
            str = "";
            str = "lks_pkg.LKS_BET_GET_TOP_USERS";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                new OracleParameter("v_date", OracleDbType.NVarchar2),
                               new OracleParameter("v_top", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_users;
            parms[1].Value = v_serviceid;
            parms[2].Value = v_date;
            parms[3].Value = v_top;


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


        public static DataSet LKS_BET_GET_TOTAL(string v_users, string v_serviceid, string v_totalDay)
        {

            string str;
            str = "";
            str = "lks_pkg.LKS_BET_GET_TOTAL";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                new OracleParameter("v_totalDay", OracleDbType.NVarchar2),
                               
                               
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_users;
            parms[1].Value = v_serviceid;
            parms[2].Value = v_totalDay;
           


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

        public static DataSet LKS_RANDOM_GET(string id)
        {

            string str;
            str = "";
            str = "lks_pkg.LKS_RANDOM_GET";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_id", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = id;



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


        public static DataSet LKS_RANDOM_GET_BY_DATE(string id,string status,string date)
        {

            string str;
            str = "";
            str = "lks_pkg.LKS_RANDOM_GET_BY_DATE";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_status", OracleDbType.NVarchar2),
                                new OracleParameter("v_date", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = id;
            parms[1].Value = status;
            parms[2].Value = date;

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



        public static DataSet LKS_REPORT_TOTAL(string users, string serviceId, string fromDate,string toDate)
        {

            string str;
            str = "";
            str = "lks_pkg.LKS_REPORT_TOTAL";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = users;
            parms[1].Value = serviceId;
            parms[2].Value = fromDate;
            parms[3].Value = toDate;

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




        /*
         * 
            ********************************************   KET THUC HAM CUA LUCKY SIX **********************************
         * 
         */






    }
}