using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;

namespace ResfullApi.Models.bet
{
    public class balanceDataAccess
    {
        public balanceDataAccess()
        {

        }


        public static DataSet getListTerm(string v_users, string v_gameId, string v_serviceId, string v_channel, string v_language
            , string v_fromDate, string v_toDate, string v_status, string v_rowsOnPage,string v_seqPage,string v_id)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.get_list_term";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_status", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                               new OracleParameter("v_id", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_users;
            parms[1].Value = v_gameId;
            parms[2].Value = v_serviceId;
            parms[3].Value = v_channel;
            parms[4].Value = v_language;
            parms[5].Value = v_fromDate;
            parms[6].Value = v_toDate;
            parms[7].Value = v_status;
            parms[8].Value = v_rowsOnPage;
            parms[9].Value = v_seqPage;
            parms[10].Value = v_id;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }


        public static DataSet lkpw_result_update(string v_randomId, string v_users, string v_result, string v_status, string v_note)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.lkpw_result_update";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_randomId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_result", OracleDbType.NVarchar2),
                                new OracleParameter("v_status", OracleDbType.NVarchar2),
                                new OracleParameter("v_note", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_randomId;
            parms[1].Value = v_users;
            parms[2].Value = v_result;
            parms[3].Value = v_status;
            parms[4].Value = v_note;
           

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



        public static DataSet lkpw_result_get_his(string v_randomId, string v_users)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.lkpw_result_get_his";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_randomId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                               

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_randomId;
            parms[1].Value = v_users;
           

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



        public static DataSet report_get_total_trafic(string v_gameId, string v_fromDate,string v_toDate,string totalRow,string seqRow)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.report_get_total_by_day";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_gameId;
            parms[1].Value = v_fromDate;
            parms[2].Value = v_toDate;
            parms[3].Value = totalRow;
            parms[4].Value = seqRow;


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



        public static DataSet cmsSearMsisdn(string v_subId, string v_msisdn)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.report_lock_stats_get";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_subId", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_subId;
            parms[1].Value = v_msisdn;
           
            return DataAccess.getDataFromProcedure(str, "", parms);
        }




        public static DataSet cmsLockByMsisdn(string v_subId, string v_msisdn,string users,string isLock,string note)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.report_lock_by_msisdn";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_subId", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_isLock", OracleDbType.NVarchar2),
                                new OracleParameter("v_note", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_subId;
            parms[1].Value = v_msisdn;
            parms[2].Value = users;
            parms[3].Value = isLock;
            parms[4].Value = note;

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



        public static DataSet cmsGetInfoTicket(string gameId, string msisdn, string tungay,string denngay,string v_rowsOnPage,string v_seqPage)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.report_ticket_get_info";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = gameId;
            parms[1].Value = msisdn;
            parms[2].Value = tungay;
            parms[3].Value = denngay;
            parms[4].Value = v_rowsOnPage;
            parms[5].Value = v_seqPage;

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



        public static DataSet cmsGetTicketWin(string gameId, string msisdn,string subId, string tungay, string denngay, string v_rowsOnPage, string v_seqPage)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.report_ticket_get_win";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_subId", OracleDbType.NVarchar2),
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = gameId;
            parms[1].Value = msisdn;
            parms[2].Value = subId;
            parms[3].Value = tungay;
            parms[4].Value = denngay;
            parms[5].Value = v_rowsOnPage;
            parms[6].Value = v_seqPage;

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



        public static DataSet cmsGetTraficTotal(string gameId,  string tungay, string denngay)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.report_get_trafic_total";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_gameId", 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 = gameId;
            parms[1].Value = tungay;
            parms[2].Value = denngay;
          

            return DataAccess.getDataFromProcedure(str, "", parms);
        }
        public static DataSet cmsGetTop(string gameId,  string tungay, string denngay,string type, string row, string v_rowsOnPage, string v_seqPage)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.report_get_top";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("v_total_row", OracleDbType.NVarchar2),

                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = gameId;
            parms[1].Value = tungay;
            parms[2].Value = denngay;
            parms[3].Value = type;
            parms[4].Value = row;
            parms[5].Value = v_rowsOnPage;
            parms[6].Value = v_seqPage;

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



        public static DataSet export_created(string v_users, string v_gameId, string v_name, string v_fromDate, string v_toDate)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.export_created";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_name", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_users;
            parms[1].Value = v_gameId;
            parms[2].Value = v_name;
            parms[3].Value = v_fromDate;
            parms[4].Value = v_toDate;


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


        public static DataSet export_action(string v_users, string v_export_id, string v_type, string v_note)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.export_action";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_export_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("v_note", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_users;
            parms[1].Value = v_export_id;
            parms[2].Value = v_type;
            parms[3].Value = v_note;
           


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

















        public static DataSet export_winner_get_data(string v_users, string v_gameId, string v_fromDate, string v_toDate, string v_payOnline
            , string v_rowsOnPage, string v_seqPage,string isPayType)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.export_winner_get_data";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_payOnline", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_payType", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_users;
            parms[1].Value = v_gameId;
            parms[2].Value = v_fromDate;
            parms[3].Value = v_toDate;
            parms[4].Value = v_payOnline;
            parms[5].Value = v_rowsOnPage;
            parms[6].Value = v_seqPage;
            parms[7].Value = isPayType;


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








        public static DataSet export_winner_get_data_byId(string v_users, string v_export_id, string v_type
            , string v_rowsOnPage, string v_seqPage)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.export_winner_get_data_byId";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_export_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_users;
            parms[1].Value = v_export_id;
            parms[2].Value = v_type;
            parms[3].Value = v_rowsOnPage;
            parms[4].Value = v_seqPage;
           


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




        public static DataSet export_get_his(string v_export_id, string v_users)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.export_get_his";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_export_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),


                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_export_id;
            parms[1].Value = v_users;


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


        public static DataSet export_get_list( string v_users, string v_gameId,string v_fromDate,string v_toDate, string v_rowsOnPage, string v_seqPage,string v_status,string exportId)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.export_get_list";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_status", OracleDbType.NVarchar2),
                                new OracleParameter("v_exportId", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_users;
            parms[1].Value = v_gameId;
            parms[2].Value = v_fromDate;
            parms[3].Value = v_toDate;
            parms[4].Value = v_rowsOnPage;
            parms[5].Value = v_seqPage;
            parms[6].Value = v_status;
            parms[7].Value = exportId;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }




        public static DataSet blackList_get_list(string v_users,string v_msisdn, string v_fromDate,string v_toDate,string v_rowsOnPage,string v_seqPage)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.blacklist_get_data";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                
                               new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_users;
            parms[1].Value = v_msisdn;
            parms[2].Value = v_fromDate;
            parms[3].Value = v_toDate;
            parms[4].Value = v_rowsOnPage;
            parms[5].Value = v_seqPage;
            



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







        public static DataSet param_get_list(string channel, string codeGroup, string code)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.param_get_list";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_pram_group_code", OracleDbType.NVarchar2),
                                new OracleParameter("v_pram_code", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = channel;
            parms[1].Value = codeGroup;
            parms[2].Value = code;
           
            return DataAccess.getDataFromProcedure(str, "", parms);
        }

        public static DataSet param_update(string id, string values, string note,string ds0, string ds1, string ds2, string ds3, string ds4, string ds5)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.param_update";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_values", OracleDbType.NVarchar2),
                                new OracleParameter("v_note", OracleDbType.NVarchar2),
                                new OracleParameter("v_ds0", OracleDbType.NVarchar2),
                                new OracleParameter("v_ds1", OracleDbType.NVarchar2),
                                new OracleParameter("v_ds2", OracleDbType.NVarchar2),
                                new OracleParameter("v_ds3", OracleDbType.NVarchar2),
                                new OracleParameter("v_ds4", OracleDbType.NVarchar2),
                                new OracleParameter("v_ds5", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = id;
            parms[1].Value = values;
            parms[2].Value = note;
            parms[3].Value = ds0;
            parms[4].Value = ds1;
            parms[5].Value = ds2;
            parms[6].Value = ds3;
            parms[7].Value = ds4;
            parms[8].Value = ds5;


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


        public static DataSet cmsDoanhThuTongHop (string channel, string serviceId, string gameId, string gamefromDate, string toDate)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.baocao_doanhthu_tonghop";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = channel;
            parms[1].Value = serviceId;
            parms[2].Value = gameId;
            parms[3].Value = gamefromDate;
            parms[4].Value = toDate;

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


        public static DataSet cmsDoanhThuChiTiet(string channel, string serviceId, string gameId, string gamefromDate, string toDate)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.baocao_doanhthu_chitiet";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = channel;
            parms[1].Value = serviceId;
            parms[2].Value = gameId;
            parms[3].Value = gamefromDate;
            parms[4].Value = toDate;

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


        public static DataSet cmsTraThuongTongHop(string channel, string serviceId, string gameId, string gamefromDate, string toDate)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.baocao_trathuong_tonghop";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = channel;
            parms[1].Value = serviceId;
            parms[2].Value = gameId;
            parms[3].Value = gamefromDate;
            parms[4].Value = toDate;

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



        public static DataSet cmsTraThuongChiTiet(string channel, string serviceId, string gameId, string gamefromDate, string toDate)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.baocao_trathuong_chitiet";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = channel;
            parms[1].Value = serviceId;
            parms[2].Value = gameId;
            parms[3].Value = gamefromDate;
            parms[4].Value = toDate;

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


        public static DataSet cmsTongHopTheoKyQuay(string channel, string serviceId, string gameId, string gamefromDate, string toDate)
        {

            string str;
            str = "";
            str = "LOTO_CMS_PKG.baocao_tonghop_kyquay";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = channel;
            parms[1].Value = serviceId;
            parms[2].Value = gameId;
            parms[3].Value = gamefromDate;
            parms[4].Value = toDate;

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




        public static void InsertBulkExport(string sSQL, List<List<string>> dataColumn)
        {
            OracleConnection connection = null;
            try
            {
                connection =DataAccess.getPoolingConnection();
                connection.Open();
                OracleTransaction transaction;

                // Start a local transaction
                transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
                using (var command = connection.CreateCommand())
                {
                    command.CommandText = sSQL;
                    command.CommandType = CommandType.StoredProcedure;
                    command.ArrayBindCount = dataColumn[0].Count;
                    command.Transaction = transaction;




                    var v_export_id = dataColumn[0].ToArray();
                    OracleParameter param0 = new OracleParameter("v_export_id", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param0.Value = v_export_id;
                    param0.Size = v_export_id.Length;
                    command.Parameters.Add(param0);

                    var v_winner_id = dataColumn[1].ToArray();
                    OracleParameter param1 = new OracleParameter("v_winner_id", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param1.Value = v_winner_id;
                    param1.Size = v_winner_id.Length;
                    command.Parameters.Add(param1);

                    var v_msisdn = dataColumn[2].ToArray();
                    OracleParameter param2 = new OracleParameter("v_msisdn", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param2.Value = v_msisdn;
                    param2.Size = v_msisdn.Length;
                    command.Parameters.Add(param2);

                    var v_money = dataColumn[3].ToArray();
                    OracleParameter param3 = new OracleParameter("v_money", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param3.Value = v_money;
                    param3.Size = v_money.Length;
                    command.Parameters.Add(param3);


                    var v_random_id = dataColumn[4].ToArray();
                    OracleParameter param4 = new OracleParameter("v_random_id", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param4.Value = v_random_id;
                    param4.Size = v_random_id.Length;
                    command.Parameters.Add(param4);

                    var v_bet_id = dataColumn[5].ToArray();
                    OracleParameter param5 = new OracleParameter("v_bet_id", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param5.Value = v_bet_id;
                    param5.Size = v_bet_id.Length;
                    command.Parameters.Add(param5);


                    var v_winner_code = dataColumn[6].ToArray();
                    OracleParameter param6 = new OracleParameter("v_winner_code", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param6.Value = v_winner_code;
                    param6.Size = v_winner_code.Length;
                    command.Parameters.Add(param6);




                    command.ExecuteNonQuery();



                    transaction.Commit();

                }

            }
            catch (OracleException ex)
            {
                Console.WriteLine(ex.ToString());
                throw;
            }
            finally
            {
                connection.Close();
            }
        }



        public static void InsertBulkBlack(string sSQL, List<List<string>> dataColumn)
        {
            OracleConnection connection = null;
            try
            {
                connection = DataAccess.getPoolingConnection();
                connection.Open();
                OracleTransaction transaction;

                // Start a local transaction
                transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
                using (var command = connection.CreateCommand())
                {
                    command.CommandText = sSQL;
                    command.CommandType = CommandType.StoredProcedure;
                    command.ArrayBindCount = dataColumn[0].Count;
                    command.Transaction = transaction;




                    var v_users = dataColumn[0].ToArray();
                    OracleParameter param0 = new OracleParameter("v_users", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param0.Value = v_users;
                    param0.Size = v_users.Length;
                    command.Parameters.Add(param0);

                    var v_msisdn = dataColumn[1].ToArray();
                    OracleParameter param1 = new OracleParameter("v_msisdn", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param1.Value = v_msisdn;
                    param1.Size = v_msisdn.Length;
                    command.Parameters.Add(param1);

                    var v_isLock = dataColumn[2].ToArray();
                    OracleParameter param2 = new OracleParameter("v_isLock", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param2.Value = v_isLock;
                    param2.Size = v_isLock.Length;
                    command.Parameters.Add(param2);


                    var v_note = dataColumn[3].ToArray();
                    OracleParameter param3 = new OracleParameter("v_note", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param3.Value = v_note;
                    param3.Size = v_note.Length;
                    command.Parameters.Add(param3);


                    command.ExecuteNonQuery();



                    transaction.Commit();

                }

            }
            catch (OracleException ex)
            {
                Console.WriteLine(ex.ToString());
                throw;
            }
            finally
            {
                connection.Close();
            }
        }











    }
}