Bplus/ApiWeb/ApiProcessToken/Models/bet/lotoDataAccess.cs

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 lotoDataAccess
    {
        public lotoDataAccess()
        {

        }

        public static void THAILAN_EVOUCHER_DETAIL_IN(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_evoucher_id = dataColumn[0].ToArray();
                    OracleParameter param0 = new OracleParameter("v_evoucher_id", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param0.Value = v_evoucher_id;
                    param0.Size = v_evoucher_id.Length;
                    command.Parameters.Add(param0);

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

                    var v_evoucher = dataColumn[2].ToArray();
                    OracleParameter param2 = new OracleParameter("v_evoucher", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param2.Value = v_evoucher;
                    param2.Size = v_evoucher.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_expire_date = dataColumn[4].ToArray();
                    OracleParameter param4 = new OracleParameter("v_expire_date", OracleDbType.NVarchar2, ParameterDirection.Input);
                    param4.Value = v_expire_date;
                    param4.Size = v_expire_date.Length;
                    command.Parameters.Add(param4);


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



                    command.ExecuteNonQuery();



                    transaction.Commit();

                }

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



        public static DataSet THAILAN_EVOUCHER_IN(string name, string code, string users, string totalrow,string totalmoney)
        {

            string str;
            str = "";
            str = "LOTO_PKG.THAILAN_EVOUCHER_IN";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_name", OracleDbType.NVarchar2),
                                new OracleParameter("v_code", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_total_row", OracleDbType.NVarchar2),
                                new OracleParameter("v_total_money", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = name;
            parms[1].Value = code;
            parms[2].Value = users;
            parms[3].Value = totalrow;
            parms[4].Value = totalmoney;



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

        public static DataSet THAILAN_GET_RANDOM_NOT_DRAW(string v_type)
        {

            string str;
            str = "";
            str = "LOTO_PKG.THAILAN_GET_RANDOM_NOT_DRAW";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

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


            return DataAccess.getDataFromProcedure(str, "", parms);
        }
        public static DataSet THAILAN_UP_RANDOM_NOT_DRAW(string v_random,string v_seq)
        {

            string str;
            str = "";
            str = "LOTO_PKG.THAILAN_UP_RANDOM_NOT_DRAW";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

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



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


        public static DataSet THAILAN_UP_PRIZE(string v_random, string v_seq)
        {

            string str;
            str = "";
            str = "LOTO_PKG.THAILAN_UP_PRIZE";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_random", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_random;
            parms[1].Value = v_seq;



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



        public static DataSet ThaiLan_checkTicketBuy(string tiket, string randomId)
        {

            string str;
            str = "";
            str = "LOTO_PKG.THAILAN_CHECK_TICKET_BUY";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_ticket", OracleDbType.NVarchar2),
                                new OracleParameter("v_random", OracleDbType.NVarchar2),

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



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




        public static DataSet THAILAN_CMS_TOTAL_REVENUE(string v_tungay, string v_denngay, string v_channel, string v_pack)
        {

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

                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_pack", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_tungay;
            parms[1].Value = v_denngay;
            parms[2].Value = v_channel;
            parms[3].Value = v_pack;

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

        public static DataSet THAILAN_CMS_DETAIL_PRIZE(string v_tungay, string v_denngay, string v_msisdn, string v_channel,string prize)
        {

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

                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                 new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                               new OracleParameter("v_prize", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_tungay;
            parms[1].Value = v_denngay;
            parms[2].Value = v_msisdn;
            parms[3].Value = v_channel;
            parms[4].Value = prize;


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

        public static DataSet THAILAN_CMS_TOTAL_PRIZE(string v_tungay, string v_denngay, string v_channel)
        {

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

                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                 new OracleParameter("v_channel", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_tungay;
            parms[1].Value = v_denngay;
            parms[2].Value = v_channel;


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




        public static DataSet THAILAN_CMS_DETAIL_TICKET(string v_tungay, string v_denngay, string v_msisdn, string v_channel)
        {

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

                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                 new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_tungay;
            parms[1].Value = v_denngay;
            parms[2].Value = v_msisdn;
            parms[3].Value = v_channel;


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


        public static DataSet THAILAN_CMS_DETAIL_EVOUCHER(string v_tungay, string v_denngay, string v_msisdn, string v_evoucher, string v_status)
        {

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

                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                 new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_evoucher", OracleDbType.NVarchar2),
                                new OracleParameter("v_status", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_tungay;
            parms[1].Value = v_denngay;
            parms[2].Value = v_msisdn;
            parms[3].Value = v_evoucher;
            parms[4].Value = v_status;


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



        public static DataSet THAILAN_CMS_TOTAL_EVOUCHER(string v_tungay, string v_denngay, string v_status)
        {

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

                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                               
                                new OracleParameter("v_status", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_tungay;
            parms[1].Value = v_denngay;
          
            parms[2].Value = v_status;


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






        //Kiem tra xem DB con song hay ko?
        public static DataSet checkDB(string type)
        {

            string str;
            str = "";
            str = "LOTO_PKG.DB_CHECK";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_typw", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = type;
          



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

        public static DataSet resultUpdateManual(string randomId, string result, string users)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.getRerultUpdateManual";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {
                                new OracleParameter("v_randomId", OracleDbType.NVarchar2),
                                new OracleParameter("v_result", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = randomId;
            parms[1].Value = result;
            parms[2].Value = users;
            


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

        public static DataSet reSearDeatailBet(string v_msisdn, string v_tungay, string v_denngay, string v_gameId
            , string v_lottery, string v_isevening, string v_channel, string isWin)
        {

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

                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_lottery", OracleDbType.NVarchar2),
                                new OracleParameter("v_isevening", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_isWin", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_msisdn;
            parms[1].Value = v_tungay;
            parms[2].Value = v_denngay;
            parms[3].Value = v_gameId;
            parms[4].Value = v_lottery;
            parms[5].Value = v_isevening;
            parms[6].Value = v_channel;
            parms[7].Value = isWin;

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



        public static DataSet reSearDeatailBetLkps(string v_msisdn, string v_tungay, string v_denngay, string v_channel, string isWin)
        {

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

                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_isWin", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_msisdn;
            parms[1].Value = v_tungay;
            parms[2].Value = v_denngay;
            
            parms[3].Value = v_channel;
            parms[4].Value = isWin;

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

        public static DataSet reSearDeatailBetUniqueMsisdn(string v_msisdn, string v_tungay, string v_denngay, string v_gameId
            , string v_lottery, string v_isevening, string v_channel,string isWin)
        {

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

                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_lottery", OracleDbType.NVarchar2),
                                new OracleParameter("v_isevening", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_isWin", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_msisdn;
            parms[1].Value = v_tungay;
            parms[2].Value = v_denngay;
            parms[3].Value = v_gameId;
            parms[4].Value = v_lottery;
            parms[5].Value = v_isevening;
            parms[6].Value = v_channel;
            parms[7].Value = isWin;

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



        public static DataSet reSearDeatailMt(string v_msisdn, string v_tungay, string v_denngay)
        {

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

                                new OracleParameter("v_msisdn", 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 = v_msisdn;
            parms[1].Value = v_tungay;
            parms[2].Value = v_denngay;
           
            return DataAccess.getDataFromProcedure(str, "", parms);
        }

        public static DataSet reTotalByDayPrizeBolet(string v_msisdn, string v_tungay, string v_denngay
            , string v_lottery, string v_isevening, string v_channel)
        {

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

                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                new OracleParameter("v_lottery", OracleDbType.NVarchar2),
                                new OracleParameter("v_isevening", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_msisdn;
            parms[1].Value = v_tungay;
            parms[2].Value = v_denngay;
            parms[3].Value = v_lottery;
            parms[4].Value = v_isevening;
            parms[5].Value = v_channel;

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


        public static DataSet reTotalByDay(string v_msisdn, string v_tungay, string v_denngay, string v_gameId
            , string v_lottery, string v_isevening, string v_channel)
        {

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

                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_lottery", OracleDbType.NVarchar2),
                                new OracleParameter("v_isevening", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_msisdn;
            parms[1].Value = v_tungay;
            parms[2].Value = v_denngay;
            parms[3].Value = v_gameId;
            parms[4].Value = v_lottery;
            parms[5].Value = v_isevening;
            parms[6].Value = v_channel;
            
            return DataAccess.getDataFromProcedure(str, "", parms);
        }


        public static DataSet reTotalByDayLkps(string v_msisdn, string v_tungay, string v_denngay, string v_channel)
        {

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

                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                               
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_msisdn;
            parms[1].Value = v_tungay;
            parms[2].Value = v_denngay;
            
            parms[3].Value = v_channel;

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


        public static DataSet reTotalByDayConvertMoney( string v_tungay, string v_denngay, string v_channel)
        {

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

                                
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
          
            parms[0].Value = v_tungay;
            parms[1].Value = v_denngay;
            parms[2].Value = v_channel;
            

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


        public static DataSet paramGetList(string v_id, string v_users)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.PAM_GET";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

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

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

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


        public static DataSet paramInsert(string V_CODE, string V_SVALUES, string V_NOTE,
            string V_STATUS, string V_CODE_GROUP, string V_DISPLAY0, string V_DISPLAY1, string V_DISPLAY2, string V_DISPLAY3,
            string V_DISPLAY4, string V_DISPLAY5, string V_GAME_ID, string V_CHANNEL, string V_USERS)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.PAM_INSERT";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("V_CODE", OracleDbType.NVarchar2),
                                new OracleParameter("V_SVALUES", OracleDbType.NVarchar2),
                                new OracleParameter("V_NOTE", OracleDbType.NVarchar2),

                                new OracleParameter("V_STATUS", OracleDbType.NVarchar2),
                                new OracleParameter("V_CODE_GROUP", OracleDbType.NVarchar2),

                                new OracleParameter("V_DISPLAY0", OracleDbType.NVarchar2),
                                new OracleParameter("V_DISPLAY1", OracleDbType.NVarchar2),
                                new OracleParameter("V_DISPLAY2", OracleDbType.NVarchar2),
                                new OracleParameter("V_DISPLAY3", OracleDbType.NVarchar2),
                                new OracleParameter("V_DISPLAY4", OracleDbType.NVarchar2),
                                new OracleParameter("V_DISPLAY5", OracleDbType.NVarchar2),
                                new OracleParameter("V_GAME_ID", OracleDbType.NVarchar2),
                                new OracleParameter("V_CHANNEL", OracleDbType.NVarchar2),
                                new OracleParameter("V_USERS", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = V_CODE;
            parms[1].Value = V_SVALUES;
            parms[2].Value = V_NOTE;
            parms[3].Value = V_STATUS;
            parms[4].Value = V_CODE_GROUP;

            parms[5].Value = V_DISPLAY0;
            parms[6].Value = V_DISPLAY1;
            parms[7].Value = V_DISPLAY2;
            parms[8].Value = V_DISPLAY3;
            parms[9].Value = V_DISPLAY4;
            parms[10].Value = V_DISPLAY5;

            parms[11].Value = V_GAME_ID;
            parms[12].Value = V_CHANNEL;
            parms[13].Value = V_USERS;

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



        public static DataSet paramUpdate(string V_ID, string V_CODE, string V_SVALUES, string V_NOTE,
            string V_STATUS, string V_CODE_GROUP, string V_DISPLAY0, string V_DISPLAY1, string V_DISPLAY2, string V_DISPLAY3,
            string V_DISPLAY4, string V_DISPLAY5, string V_GAME_ID, string V_CHANNEL, string V_USERS, string V_TYPE)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.PAM_UPDATE";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {
                                new OracleParameter("V_ID", OracleDbType.NVarchar2),
                                new OracleParameter("V_CODE", OracleDbType.NVarchar2),
                                new OracleParameter("V_SVALUES", OracleDbType.NVarchar2),
                                new OracleParameter("V_NOTE", OracleDbType.NVarchar2),
                                new OracleParameter("V_STATUS", OracleDbType.NVarchar2),
                                new OracleParameter("V_CODE_GROUP", OracleDbType.NVarchar2),

                                new OracleParameter("V_DISPLAY0", OracleDbType.NVarchar2),
                                new OracleParameter("V_DISPLAY1", OracleDbType.NVarchar2),
                                new OracleParameter("V_DISPLAY2", OracleDbType.NVarchar2),
                                new OracleParameter("V_DISPLAY3", OracleDbType.NVarchar2),
                                new OracleParameter("V_DISPLAY4", OracleDbType.NVarchar2),
                                new OracleParameter("V_DISPLAY5", OracleDbType.NVarchar2),

                                new OracleParameter("V_GAME_ID", OracleDbType.NVarchar2),
                                new OracleParameter("V_CHANNEL", OracleDbType.NVarchar2),
                                new OracleParameter("V_USERS", OracleDbType.NVarchar2),
                                new OracleParameter("V_TYPE", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = V_ID;
            parms[1].Value = V_CODE;
            parms[2].Value = V_SVALUES;
            parms[3].Value = V_NOTE;
            parms[4].Value = V_STATUS;
            parms[5].Value = V_CODE_GROUP;

            parms[6].Value = V_DISPLAY0;
            parms[7].Value = V_DISPLAY1;
            parms[8].Value = V_DISPLAY2;
            parms[9].Value = V_DISPLAY3;
            parms[10].Value = V_DISPLAY4;
            parms[11].Value = V_DISPLAY5;

            parms[12].Value = V_GAME_ID;
            parms[13].Value = V_CHANNEL;
            parms[14].Value = V_USERS;
            parms[15].Value = V_TYPE;



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


        public static DataSet getListConvertByUser(string v_serviceId, string v_users, string v_type, string v_order
            , string v_rowsOnPage, string v_seqPage, string v_id,string v_language, string v_fromdate, string v_todate,string channel_payment)
        {

            string str;
            str = "";
            str = "CONVERT_COINS_MONEY_PKG.getConvertMoneyList";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("v_order", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromdate", OracleDbType.NVarchar2),
                                new OracleParameter("v_todate", OracleDbType.NVarchar2),
                                new OracleParameter("v_transferType", OracleDbType.NVarchar2),


                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_serviceId;
            parms[1].Value = v_users;
            parms[2].Value = v_type;
            parms[3].Value = v_order;
            parms[4].Value = v_rowsOnPage;
            parms[5].Value = v_seqPage;
            parms[6].Value = v_id;
            parms[7].Value = v_language;
            parms[8].Value = v_fromdate;
            parms[9].Value = v_todate;
            parms[10].Value = channel_payment;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }



        public static DataSet convertMoney(string user,string msisdn_topup, string channel, string channelPayment, string money, string language,string serviceId)
        {

            string str;
            str = "";
            str = "CONVERT_COINS_MONEY_PKG.requestChange";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_user", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn_topup", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_channelPayment", OracleDbType.NVarchar2),
                                new OracleParameter("v_money", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = user;
            parms[1].Value = msisdn_topup;
            parms[2].Value = channel;
            parms[3].Value = channelPayment;
            parms[4].Value = money;
            parms[5].Value = language;
            parms[6].Value = serviceId;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }



        public static DataSet otpConfirm(string msisdn, string serviceId, string channel,string otp, string language)
        {

            string str;
            str = "";
            str = "LOTO_PKG.OTP_CONFIRM";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_user", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_otp", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = msisdn;
            parms[1].Value = serviceId;
            parms[2].Value = channel;
            parms[3].Value = otp;
            parms[4].Value = language;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }



        public static DataSet otpSend(string msisdn, string serviceId,string channel,string language)
        {

            string str;
            str = "";
            str = "LOTO_PKG.OTP_SEND";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_user", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = msisdn;
            parms[1].Value = serviceId;
            parms[2].Value = channel;
            parms[3].Value = language;



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




        public static DataSet lotoInsertBet(string v_user, string v_serviceId,string v_ticket,string v_money,string v_requestBuyTicket
            , string v_responseBuyTicket, string v_requestConfirm, string v_responseConfirm,string paymentCode,string paymentMesage,
            string v_startTimeSend,string v_endTimeSend,string v_duration,string v_gameId,string v_channel,string v_language)
        {

            string str;
            str = "";
            str = "LOTO_PKG.INSERT_BET";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_user", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_ticket", OracleDbType.NVarchar2),
                                new OracleParameter("v_money", OracleDbType.NVarchar2),
                                new OracleParameter("v_requestIdUi", OracleDbType.NVarchar2),
                                new OracleParameter("v_requestIdApi", OracleDbType.NVarchar2),
                                new OracleParameter("v_requestIdPayment", OracleDbType.NVarchar2),
                                new OracleParameter("v_tranId", OracleDbType.NVarchar2),
                                new OracleParameter("v_paymentCode", OracleDbType.NVarchar2),
                                new OracleParameter("v_paymentMessage", OracleDbType.NVarchar2),
                                new OracleParameter("v_startTimeSend", OracleDbType.NVarchar2),
                                new OracleParameter("v_endTimeSend", OracleDbType.NVarchar2),
                                new OracleParameter("v_duration", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),


                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_user;
            parms[1].Value = v_serviceId;
            parms[2].Value = v_ticket;
            parms[3].Value = v_money;
            parms[4].Value = v_requestBuyTicket;
            parms[5].Value = v_responseBuyTicket;
            parms[6].Value = v_requestConfirm;
            parms[7].Value = v_responseConfirm;
            parms[8].Value = paymentCode;
            parms[9].Value = paymentMesage;
            parms[10].Value = v_startTimeSend;
            parms[11].Value = v_endTimeSend;
            parms[12].Value = v_duration;
            parms[13].Value = v_gameId;
            parms[14].Value = v_channel;
            parms[15].Value = v_language;




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


        public static DataSet getPromotionByCode(string code, string msisdn)
        {

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

                                new OracleParameter("v_code", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                               
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = code;
            parms[1].Value = msisdn;
          


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




        public static DataSet getTicketByUser(string serviceId, string gameId, string users, string type, string order, string rowsOnPage, string seqPage,string id,string language)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.getTicketByUser";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("v_order", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = serviceId;
            parms[1].Value = gameId;
            parms[2].Value = users;
            parms[3].Value = type;
            parms[4].Value = order;
            parms[5].Value = rowsOnPage;
            parms[6].Value = seqPage;
            parms[7].Value = id;
            parms[8].Value = language;


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



        public static DataSet getTicketWinByUser(string serviceId, string gameId, string users
            , string v_prize_code, string order, string rowsOnPage, string seqPage, string language
            , string v_fromdate,string v_todate)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.getTicketWinByUsers";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_prize_code", OracleDbType.NVarchar2),
                                new OracleParameter("v_order", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", 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 = serviceId;
            parms[1].Value = gameId;
            parms[2].Value = users;
            parms[3].Value = v_prize_code;
            parms[4].Value = order;
            parms[5].Value = rowsOnPage;
            parms[6].Value = seqPage;
            parms[7].Value = language;
            parms[8].Value = v_fromdate;
            parms[9].Value = v_todate;


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





        public static DataSet getRerultOfTerm(string serviceId, string gameId, string type, string order, string rowsOnPage, string seqPage, string id,string language,string fromDate,string toDate)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.getRerultOfTerm";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("v_order", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                                new OracleParameter("v_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", 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 = serviceId;
            parms[1].Value = gameId;
            parms[2].Value = type;
            parms[3].Value = order;
            parms[4].Value = rowsOnPage;
            parms[5].Value = seqPage;
            parms[6].Value = id;
            parms[7].Value = language;
            parms[8].Value = fromDate;
            parms[9].Value = toDate;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }


        public static DataSet getPrizeOfCurrentTerm( string gameId)
        {

            string str;
            str = "";
            str = "LOTO_PKG.THAILAN_GET_MONEYWIN";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

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


        public static DataSet getPrizeList(string gameId)
        {

            string str;
            str = "";
            str = "LOTO_PKG.THAILAN_GET_LIST_PRIZE";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {



                                new OracleParameter("v_type", OracleDbType.NVarchar2),

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

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


        public static DataSet getRerultTopSendSms(string serviceId, string gameId, string v_user, string v_total_row, string v_channel)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.getRerultTopSendSms";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_user", OracleDbType.NVarchar2),
                                new OracleParameter("v_total_row", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = serviceId;
            parms[1].Value = gameId;
            parms[2].Value = v_user;
            parms[3].Value = v_total_row;
            parms[4].Value = v_channel;
           
            return DataAccess.getDataFromProcedure(str, "", parms);
        }



        public static DataSet getExecuteSendSms(string serviceId, string gameId, string v_user, string v_total_row, string v_channel,string type)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.getExecuteSendSms";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_user", OracleDbType.NVarchar2),
                                new OracleParameter("v_total_row", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = serviceId;
            parms[1].Value = gameId;
            parms[2].Value = v_user;
            parms[3].Value = v_total_row;
            parms[4].Value = v_channel;
            parms[5].Value = type;

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


        public static DataSet searchBySms(string serviceId, string gameId,string users, string type, string param, string language,string channel)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.searchBySms";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("v_param", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = serviceId;
            parms[1].Value = gameId;
            parms[2].Value = users;
            parms[3].Value = type;
            parms[4].Value = param;
            parms[5].Value = language;
            parms[6].Value = channel;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }



        public static DataSet getTotalWinnerByBet(string serviceId, string gameId, string betId, string users, string ticket, string channel, string language)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.getTotalWinnerByBet";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_betId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_ticket", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = serviceId;
            parms[1].Value = gameId;
            parms[2].Value = betId;
            parms[3].Value = users;
            parms[4].Value = ticket;
            parms[5].Value = channel;
            parms[6].Value = language;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }











        public static DataSet getMoney(string serviceId, string gameId, string language)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.getMoney";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                               
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = serviceId;
            parms[1].Value = gameId;
            parms[2].Value = language;
          

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


        public static DataSet getParams(string serviceId, string gameId,string language, string groupCode,string code)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.getParams";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("v_groupCode", OracleDbType.NVarchar2),
                                new OracleParameter("v_code", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = serviceId;
            parms[1].Value = gameId;
            parms[2].Value = language;
            parms[3].Value = groupCode;
            parms[4].Value = code;

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



        public static DataSet getCurentTerm(string serviceId, string gameId, string language)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.getCurentTerm";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_gameId", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = serviceId;
            parms[1].Value = gameId;
            parms[2].Value = language;

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








        public static DataSet TKupdateCheckPin(string msisdn,string ip, string errCode,string message,string channel)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.tokenUpCheckPin";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_ip", OracleDbType.NVarchar2),
                                new OracleParameter("v_errCode", OracleDbType.NVarchar2),
                                new OracleParameter("v_message", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = msisdn;
            parms[1].Value = ip;
            parms[2].Value = errCode;
            parms[3].Value = message;
            parms[4].Value = channel;
           
            return DataAccess.getDataFromProcedure(str, "", parms);
        }


        public static DataSet TKcheckSpamCheckPin(string msisdn, string ip,string channel)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.tokenCheckSpamCheckPin";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_ip", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = msisdn;
            parms[1].Value = ip;
            parms[2].Value = channel;
          

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



        public static DataSet TKcheckToken( string ip, string channel, string token)
        {

            string str;
            str = "";
            str = "LOTO_REPORT_PKG.tokenCheck";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {

                               
                                new OracleParameter("v_ip", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_token", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            
            parms[0].Value = ip;
            parms[1].Value = channel;
            parms[2].Value = token;

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










    }
}