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> 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); } } }