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

        }


        public static DataSet subBuyCoins(string v_users, string n_serviceid, string subserviceCode)
        {

            string str;
            str = "";
            str = "MPS_PKG.COINS_BUY";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_subserviceCode", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_users;
            parms[1].Value = n_serviceid;
            parms[2].Value = subserviceCode;

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

        public static DataSet subChangeCoins(string v_users, string n_serviceid, string subserviceCode,string type)
        {

            string str;
            str = "";
            str = "MPS_PKG.COINS_CHANGE";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_subserviceCode", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_users;
            parms[1].Value = n_serviceid;
            parms[2].Value = subserviceCode;
            parms[3].Value = type;

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


        public static DataSet subUpdateCoins(string v_users, string n_serviceid, string subserviceCode,string totalCoins, string type)
        {

            string str;
            str = "";
            str = "MPS_PKG.COINS_UPDATE";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_subserviceCode", OracleDbType.NVarchar2),
                                new OracleParameter("v_totalCoin", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_users;
            parms[1].Value = n_serviceid;
            parms[2].Value = subserviceCode;
            parms[3].Value = totalCoins;
            parms[4].Value = type;

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


        public static DataSet subGetListChangeCoins(string v_users, string n_serviceid,  string type)
        {

            string str;
            str = "";
            str = "MPS_PKG.COINS_GET_LIST";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_users;
            parms[1].Value = n_serviceid;
            parms[2].Value = type;

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

        public static DataSet subGetListHisCoins(string v_users, string n_serviceid, string type,string fromDate,string toDate)
        {

            string str;
            str = "";
            str = "MPS_PKG.COINS_GET_HIS";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", 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_users;
            parms[1].Value = n_serviceid;
            parms[2].Value = type;
            parms[3].Value = fromDate;
            parms[4].Value = toDate;


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


        public static DataSet SUB_API_DK_HUY(string v_msisdn, string v_type_rg, string v_protocol, string n_packge, string n_sv_id, string v_note)
        {
            string str;
            str = "";
            str = "api_pkg.SUB_API_DK_HUY";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_type_rg", OracleDbType.NVarchar2),
                                new OracleParameter("v_protocol", OracleDbType.NVarchar2),
                                new OracleParameter("n_packge", OracleDbType.NVarchar2),
                                new OracleParameter("n_sv_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_note", OracleDbType.NVarchar2),    
                                
                     			new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_msisdn;
            parms[1].Value = v_type_rg;
            parms[2].Value = v_protocol;
            parms[3].Value = n_packge;
            parms[4].Value = n_sv_id;
            parms[5].Value = v_note;

            return DataAccess.getDataFromProcedure(str, "", parms);
        }
        public static DataSet SUB_API_CHECK_STATUS(string v_msisdn, string n_sv_id)
        {
            string str;
            str = "";
            str = "MPS_PKG.SUB_API_CHECK_STATUS";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("n_sv_id", OracleDbType.NVarchar2),
                               
                               
                                
                     			new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_msisdn;
            parms[1].Value = n_sv_id;


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



        public static DataSet SUB_API_GET_LIST(string v_msisdn, string n_sv_id)
        {
            string str;
            str = "";
            str = "MPS_PKG.SUB_API_GET_LIST";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("n_sv_id", OracleDbType.NVarchar2),



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


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



        public static DataSet SUB_API_GET_SUBSEVICECODE(string v_msisdn, string n_sv_id)
        {
            string str;
            str = "";
            str = "MPS_PKG.SUB_API_GET_SUBSERVICRCODE";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("n_sv_id", OracleDbType.NVarchar2),
                               
                               
                                
                     			new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_msisdn;
            parms[1].Value = n_sv_id;


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


        public static DataSet SUB_API_GET_SUBSEVICE(string v_type)
        {
            string str;
            str = "";
            str = "MPS_PKG.GET_SERVICE_NEW";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("ntype", OracleDbType.NVarchar2),
                              
                                
                     			new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_type;
            


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


        
        public static DataSet API_SEND_MT(string v_msisdn, string n_sv_id, string v_message)
        {
            string str;
            str = "";
            str = "api_pkg.API_SEND_MT";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("n_sv_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_message", OracleDbType.NVarchar2),
                               
                                
                     			new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_msisdn;
            parms[1].Value = n_sv_id;
            parms[2].Value = v_message;


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

        public static DataSet API_SEND_BULK_MT(string n_sv_id, string v_message, string v_type)
        {
            string str;
            str = "";
            str = "api_pkg.API_SEND_BULK_MT";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                
                                new OracleParameter("n_sv_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_message", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                               
                                
                     			new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = n_sv_id;
            parms[1].Value = v_message;
            parms[2].Value = v_type;


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




        public static DataSet API_TOPUP(string v_msisdn, string n_sv_id, string v_money, string v_message)
        {
            string str;
            str = "";
            str = "api_pkg.API_TOPUP";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("n_sv_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_money", OracleDbType.NVarchar2),
                               new OracleParameter("v_message", OracleDbType.NVarchar2),
                                
                     			new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_msisdn;
            parms[1].Value = n_sv_id;
            parms[2].Value = v_money;
            parms[3].Value = v_message;


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



        public static DataSet PLAYGAME_CHECK(string v_msisdn, string n_sv_id)
        {
            string str;
            str = "";
            str = "MINI_GAME_PKG.CHECK_PLAY_GAME";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                               
                                 new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_msisdn;
            parms[1].Value = n_sv_id;
         


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


        public static DataSet PLAYGAME_UPDATE(string playId, string score,string playKey)
        {
            string str;
            str = "";
            str = "MINI_GAME_PKG.UPDATE_PLAY_GAME";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {
                                new OracleParameter("v_play_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_score", OracleDbType.NVarchar2),
                                new OracleParameter("v_playkey", OracleDbType.NVarchar2),

                                 new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = playId;
            parms[1].Value = score;
            parms[2].Value = playKey;


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



        public static DataSet PLAYGAME_TOP(string v_fromdate, string v_todate, string v_top,string v_serviceid)
        {
            string str;
            str = "";
            str = "MINI_GAME_PKG.GET_TOP";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {
                                new OracleParameter("v_fromdate", OracleDbType.NVarchar2),
                                new OracleParameter("v_todate", OracleDbType.NVarchar2),
                                new OracleParameter("v_top", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                 new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_fromdate;
            parms[1].Value = v_todate;
            parms[2].Value = v_top;
            parms[3].Value = v_serviceid;

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


        public static DataSet PLAYGAME_WIN(string v_fromdate, string v_todate, string v_top, string v_serviceid,string v_msisdn)
        {
            string str;
            str = "";
            str = "MINI_GAME_PKG.GET_WIN";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {
                                new OracleParameter("v_fromdate", OracleDbType.NVarchar2),
                                new OracleParameter("v_todate", OracleDbType.NVarchar2),
                                new OracleParameter("v_top", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                 new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = v_fromdate;
            parms[1].Value = v_todate;
            parms[2].Value = v_top;
            parms[3].Value = v_serviceid;
            parms[4].Value = v_msisdn;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }






    }
}