using Oracle.ManagedDataAccess.Client; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Threading.Channels; using System.Web; namespace ResfullApi.Models.balance { public class balanceDataAccess { public balanceDataAccess() { } public static void InsertBulkBlackList(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_msisdn = dataColumn[0].ToArray(); OracleParameter param0 = new OracleParameter("v_msisdn", OracleDbType.NVarchar2, ParameterDirection.Input); param0.Value = v_msisdn; param0.Size = v_msisdn.Length; command.Parameters.Add(param0); var v_type = dataColumn[1].ToArray(); OracleParameter param1 = new OracleParameter("v_type", OracleDbType.NVarchar2, ParameterDirection.Input); param1.Value = v_type; param1.Size = v_type.Length; command.Parameters.Add(param1); var v_sv_id = dataColumn[2].ToArray(); OracleParameter param2 = new OracleParameter("v_sv_id", OracleDbType.NVarchar2, ParameterDirection.Input); param2.Value = v_sv_id; param2.Size = v_sv_id.Length; command.Parameters.Add(param2); var v_action = dataColumn[3].ToArray(); OracleParameter param3 = new OracleParameter("v_action", OracleDbType.NVarchar2, ParameterDirection.Input); param3.Value = v_action; param3.Size = v_action.Length; command.Parameters.Add(param3); var v_users = dataColumn[4].ToArray(); OracleParameter param4 = new OracleParameter("v_users", OracleDbType.NVarchar2, ParameterDirection.Input); param4.Value = v_users; param4.Size = v_users.Length; command.Parameters.Add(param4); command.ExecuteNonQuery(); transaction.Commit(); } } catch (OracleException ex) { Console.WriteLine(ex.ToString()); throw; } finally { connection.Close(); } } public static DataSet reportByCampaign(string v_users, string status,string v_fromDate, string v_toDate) { string str; str = ""; str = "BALANCE_PKG.REPORT_BY_CAMPAIGN"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_status", OracleDbType.NVarchar2), new OracleParameter("v_FROMDATE", OracleDbType.NVarchar2), new OracleParameter("v_TODATE", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_users; parms[1].Value = status; parms[2].Value = v_fromDate; parms[3].Value = v_toDate; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet reportTotalByCampaign(string v_users, string v_fromDate, string v_toDate,string status,string isDefault) { string str; str = ""; str = "BALANCE_PKG.CAM_GET_REPORT_TOTAL"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_status", OracleDbType.NVarchar2), new OracleParameter("v_isDefault", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_users; parms[1].Value = v_fromDate; parms[2].Value = v_toDate; parms[3].Value = status; parms[4].Value = isDefault; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet comGetList(string v_id,string v_users, string v_name, string v_code, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage) { string str; str = ""; str = "BALANCE_PKG.COM_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_name", OracleDbType.NVarchar2), new OracleParameter("v_code", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_name; parms[3].Value = v_code; parms[4].Value = v_fromDate; parms[5].Value = v_toDate; parms[6].Value = v_order; parms[7].Value = v_rowsOnPage; parms[8].Value = v_seqPage; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet comInsert(string V_CODE, string V_NAME,string V_PHONE,string V_EMAIL,string V_ADDRESS,string V_DESCRIPTION, string V_NOTE,string V_USERS) { string str; str = ""; str = "BALANCE_PKG.COM_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_PHONE", OracleDbType.NVarchar2), new OracleParameter("V_EMAIL", OracleDbType.NVarchar2), new OracleParameter("V_ADDRESS", OracleDbType.NVarchar2), new OracleParameter("V_DESCRIPTION", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", 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_NAME; parms[2].Value = V_PHONE; parms[3].Value = V_EMAIL; parms[4].Value = V_ADDRESS; parms[5].Value = V_DESCRIPTION; parms[6].Value = V_NOTE; parms[7].Value = V_USERS; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet comUpdate(string V_ID,string V_CODE, string V_NAME, string V_PHONE, string V_EMAIL, string V_ADDRESS, string V_DESCRIPTION, string V_NOTE, string V_USERS,string V_TYPE) { string str; str = ""; str = "BALANCE_PKG.COM_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_PHONE", OracleDbType.NVarchar2), new OracleParameter("V_EMAIL", OracleDbType.NVarchar2), new OracleParameter("V_ADDRESS", OracleDbType.NVarchar2), new OracleParameter("V_DESCRIPTION", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", 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_NAME; parms[3].Value = V_PHONE; parms[4].Value = V_EMAIL; parms[5].Value = V_ADDRESS; parms[6].Value = V_DESCRIPTION; parms[7].Value = V_NOTE; parms[8].Value = V_USERS; parms[9].Value = V_TYPE; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet listSubGetList(string v_id, string v_users,string V_sub_type, string v_name,string v_code,string v_fromDate,string v_toDate , string v_order,string v_rowsOnPage,string v_seqPage,string v_isActive) { string str; str = ""; str = "BALANCE_PKG.LIST_SUB_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("V_sub_type", OracleDbType.NVarchar2), new OracleParameter("v_name", OracleDbType.NVarchar2), new OracleParameter("v_code", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("v_isActive", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = V_sub_type; parms[3].Value = v_name; parms[4].Value = v_code; parms[5].Value = v_fromDate; parms[6].Value = v_toDate; parms[7].Value = v_order; parms[8].Value = v_rowsOnPage; parms[9].Value = v_seqPage; parms[10].Value = v_isActive; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet blistSubInsert(string V_CODE, string V_NAME, string V_NOTE, string V_USERS,string V_SUB_TYPE) { string str; str = ""; str = "BALANCE_PKG.LIST_SUB_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_SUB_TYPE", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_CODE; parms[1].Value = V_NAME; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = V_SUB_TYPE; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet blistSubUpdate(string V_ID, string V_CODE, string V_NAME,string V_SUB_TYPE, string V_NOTE, string V_USERS, string V_TYPE,string status) { string str; str = ""; str = "BALANCE_PKG.LIST_SUB_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_SUB_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_STATUS", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_ID; parms[1].Value = V_CODE; parms[2].Value = V_NAME; parms[3].Value = V_SUB_TYPE; parms[4].Value = V_NOTE; parms[5].Value = V_USERS; parms[6].Value = V_TYPE; parms[7].Value = status; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet listSubFileGetList(string v_id, string v_users, string V_list_sub_id, string v_name, string v_code, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage) { string str; str = ""; str = "BALANCE_PKG.LIST_SUB_FILE_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("V_list_sub_id", OracleDbType.NVarchar2), new OracleParameter("v_name", OracleDbType.NVarchar2), new OracleParameter("v_code", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = V_list_sub_id; parms[3].Value = v_name; parms[4].Value = v_code; parms[5].Value = v_fromDate; parms[6].Value = v_toDate; parms[7].Value = v_order; parms[8].Value = v_rowsOnPage; parms[9].Value = v_seqPage; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet blistSubFileInsert(string V_CODE, string V_NAME, string V_NOTE, string V_USERS, string V_LIST_SUB_ID, string V_FILE_ID, string V_FILE_NAME) { string str; str = ""; str = "BALANCE_PKG.LIST_SUB_FILE_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_LIST_SUB_ID", OracleDbType.NVarchar2), new OracleParameter("V_FILE_ID", OracleDbType.NVarchar2), new OracleParameter("V_FILE_NAME", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_CODE; parms[1].Value = V_NAME; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = V_LIST_SUB_ID; parms[5].Value = V_FILE_ID; parms[6].Value = V_FILE_NAME; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet blistSubFileUpdate(string V_ID, string V_CODE, string V_NAME, string V_LIST_SUB_ID, string V_NOTE, string V_USERS, string V_TYPE,string status) { string str; str = ""; str = "BALANCE_PKG.LIST_SUB_FILE_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_LIST_SUB_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_STATUS", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_ID; parms[1].Value = V_CODE; parms[2].Value = V_NAME; parms[3].Value = V_LIST_SUB_ID; parms[4].Value = V_NOTE; parms[5].Value = V_USERS; parms[6].Value = V_TYPE; parms[7].Value = status; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet sortCodeGetList( string v_type, string v_users) { string str; str = ""; str = "BALANCE_PKG.SORT_CODE_GET_LIST"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_type", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_type; parms[1].Value = v_users; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet changeStatus(string v_type,string v_id, string v_status, string v_users) { string str; str = ""; str = "BALANCE_PKG.CHANGE_STATUS"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_type", OracleDbType.NVarchar2), new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_status", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_type; parms[1].Value = v_id; parms[2].Value = v_status; parms[3].Value = v_users; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet balGetList(string v_id, string v_users,string v_name,string v_code,string v_fromDate,string v_toDate , string v_order,string v_rowsOnPage,string v_seqPage,string isActive) { string str; str = ""; str = "BALANCE_PKG.BL_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_name", OracleDbType.NVarchar2), new OracleParameter("v_code", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("v_isActive", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_name; parms[3].Value = v_code; parms[4].Value = v_fromDate; parms[5].Value = v_toDate; parms[6].Value = v_order; parms[7].Value = v_rowsOnPage; parms[8].Value = v_seqPage; parms[9].Value = isActive; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet balInsert(string V_CODE, string V_NAME, string V_MIN, string V_MAX, string V_NOTE, string V_USERS) { string str; str = ""; str = "BALANCE_PKG.BL_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_MIN", OracleDbType.NVarchar2), new OracleParameter("V_MAX", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", 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_NAME; parms[2].Value = V_MIN; parms[3].Value = V_MAX; parms[4].Value = V_NOTE; parms[5].Value = V_USERS; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet balUpdate(string V_ID,string V_CODE, string V_NAME, string V_MIN, string V_MAX, string V_NOTE, string V_USERS,string V_TYPE) { string str; str = ""; str = "BALANCE_PKG.BL_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_MIN", OracleDbType.NVarchar2), new OracleParameter("V_MAX", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", 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_NAME; parms[3].Value = V_MIN; parms[4].Value = V_MAX; parms[5].Value = V_NOTE; parms[6].Value = V_USERS; parms[7].Value = V_TYPE; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet expGetList(string v_id, string v_users, string v_name, string v_code, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage,string v_isActive) { string str; str = ""; str = "BALANCE_PKG.EP_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_name", OracleDbType.NVarchar2), new OracleParameter("v_code", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("v_isActive", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_name; parms[3].Value = v_code; parms[4].Value = v_fromDate; parms[5].Value = v_toDate; parms[6].Value = v_order; parms[7].Value = v_rowsOnPage; parms[8].Value = v_seqPage; parms[9].Value = v_isActive; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet expInsert(string V_CODE, string V_NAME, string V_TOTAL_DAY_USE, string V_NOTE, string V_USERS,string min,string max) { string str; str = ""; str = "BALANCE_PKG.EP_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_TOTAL_DAY_USE", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_MIN", OracleDbType.NVarchar2), new OracleParameter("V_MAX", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_CODE; parms[1].Value = V_NAME; parms[2].Value = V_TOTAL_DAY_USE; parms[3].Value = V_NOTE; parms[4].Value = V_USERS; parms[5].Value = min; parms[6].Value = max; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet expUpdate(string V_ID, string V_CODE, string V_NAME, string V_TOTAL_DAY_USE, string V_NOTE, string V_USERS, string V_TYPE,string min,string max) { string str; str = ""; str = "BALANCE_PKG.EP_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_TOTAL_DAY_USE", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_MIN", OracleDbType.NVarchar2), new OracleParameter("V_MAX", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_ID; parms[1].Value = V_CODE; parms[2].Value = V_NAME; parms[3].Value = V_TOTAL_DAY_USE; parms[4].Value = V_NOTE; parms[5].Value = V_USERS; parms[6].Value = V_TYPE; parms[7].Value = min; parms[8].Value = max; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet paramGetList(string v_id, string v_users) { string str; str = ""; str = "BALANCE_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 = "BALANCE_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 = "BALANCE_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 usersGetList(string v_id, string v_users) { string str; str = ""; str = "BALANCE_PKG.USERS_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 usersInsert(string V_USERNAME, string V_PASSWORD, string V_ROLE, string V_COUNTRY_CODE, string V_IS_LOCK, string V_TOTAL_FALSE, string V_TIME_LOCK, string V_NOTE, string V_USERS) { string str; str = ""; str = "BALANCE_PKG.USERS_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_USERNAME", OracleDbType.NVarchar2), new OracleParameter("V_PASSWORD", OracleDbType.NVarchar2), new OracleParameter("V_ROLE", OracleDbType.NVarchar2), new OracleParameter("V_COUNTRY_CODE", OracleDbType.NVarchar2), new OracleParameter("V_IS_LOCK", OracleDbType.NVarchar2), new OracleParameter("V_TOTAL_FALSE", OracleDbType.NVarchar2), new OracleParameter("V_TIME_LOCK", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_USERNAME; parms[1].Value = V_PASSWORD; parms[2].Value = V_ROLE; parms[3].Value = V_COUNTRY_CODE; parms[4].Value = V_IS_LOCK; parms[5].Value = V_TOTAL_FALSE; parms[6].Value = V_TIME_LOCK; parms[7].Value = V_NOTE; parms[8].Value = V_USERS; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet usersUpdate(string V_ID, string V_USERNAME, string V_PASSWORD, string V_ROLE, string V_COUNTRY_CODE, string V_IS_LOCK, string V_TOTAL_FALSE, string V_TIME_LOCK, string V_NOTE, string V_USERS, string V_TYPE) { string str; str = ""; str = "BALANCE_PKG.USERS_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_USERNAME", OracleDbType.NVarchar2), new OracleParameter("V_PASSWORD", OracleDbType.NVarchar2), new OracleParameter("V_ROLE", OracleDbType.NVarchar2), new OracleParameter("V_COUNTRY_CODE", OracleDbType.NVarchar2), new OracleParameter("V_IS_LOCK", OracleDbType.NVarchar2), new OracleParameter("V_TOTAL_FALSE", OracleDbType.NVarchar2), new OracleParameter("V_TIME_LOCK", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", 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_USERNAME; parms[2].Value = V_PASSWORD; parms[3].Value = V_ROLE; parms[4].Value = V_COUNTRY_CODE; parms[5].Value = V_IS_LOCK; parms[6].Value = V_TOTAL_FALSE; parms[7].Value = V_TIME_LOCK; parms[8].Value = V_NOTE; parms[9].Value = V_USERS; parms[10].Value = V_TYPE; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet svGetList(string v_id, string v_users, string v_name, string v_code, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage,string isActive) { string str; str = ""; str = "BALANCE_PKG.SV_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_name", OracleDbType.NVarchar2), new OracleParameter("v_code", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("v_isActive", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_name; parms[3].Value = v_code; parms[4].Value = v_fromDate; parms[5].Value = v_toDate; parms[6].Value = v_order; parms[7].Value = v_rowsOnPage; parms[8].Value = v_seqPage; parms[9].Value = isActive; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet svInsert(string V_CODE, string V_NAME, string V_DESCRIPTION, string V_SHORT_CODE, string V_COMMAND_REGISTER, string V_CONTENT_EN, string V_CONTENT_FR, string V_CONTENT_LC, string V_NOTE, string V_COMPANY_ID, string V_USERS, string msgRegisterSuccess, string msgRegisterFlase,string msgConfirm) { string str; str = ""; str = "BALANCE_PKG.SV_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_DESCRIPTION", OracleDbType.NVarchar2), new OracleParameter("V_SHORT_CODE", OracleDbType.NVarchar2), new OracleParameter("V_COMMAND_REGISTER", OracleDbType.NVarchar2), new OracleParameter("V_CONTENT_EN", OracleDbType.NVarchar2), new OracleParameter("V_CONTENT_FR", OracleDbType.NVarchar2), new OracleParameter("V_CONTENT_LC", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_COMPANY_ID", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_USSD_MSG_REGISTER_SUC", OracleDbType.NVarchar2), new OracleParameter("V_USSD_MSG_REGISTER_FAIL", OracleDbType.NVarchar2), new OracleParameter("V_USSD_CONFIRM", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_CODE; parms[1].Value = V_NAME; parms[2].Value = V_DESCRIPTION; parms[3].Value = V_SHORT_CODE; parms[4].Value = V_COMMAND_REGISTER; parms[5].Value = V_CONTENT_EN; parms[6].Value = V_CONTENT_FR; parms[7].Value = V_CONTENT_LC; parms[8].Value = V_NOTE; parms[9].Value = V_COMPANY_ID; parms[10].Value = V_USERS; parms[11].Value = msgRegisterSuccess; parms[12].Value = msgRegisterFlase; parms[13].Value = msgConfirm; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet svUpdate(string V_ID,string V_CODE, string V_NAME, string V_DESCRIPTION, string V_SHORT_CODE, string V_COMMAND_REGISTER, string V_CONTENT_EN, string V_CONTENT_FR, string V_CONTENT_LC, string V_NOTE, string V_COMPANY_ID, string V_USERS, string V_TYPE, string msgRegisterSuccess, string msgRegisterFlase,string msgConfirm) { string str; str = ""; str = "BALANCE_PKG.SV_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_DESCRIPTION", OracleDbType.NVarchar2), new OracleParameter("V_SHORT_CODE", OracleDbType.NVarchar2), new OracleParameter("V_COMMAND_REGISTER", OracleDbType.NVarchar2), new OracleParameter("V_CONTENT_EN", OracleDbType.NVarchar2), new OracleParameter("V_CONTENT_FR", OracleDbType.NVarchar2), new OracleParameter("V_CONTENT_LC", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_COMPANY_ID", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_USSD_MSG_REGISTER_SUC", OracleDbType.NVarchar2), new OracleParameter("V_USSD_MSG_REGISTER_FAIL", OracleDbType.NVarchar2), new OracleParameter("V_USSD_CONFIRM", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_ID; parms[1].Value = V_CODE; parms[2].Value = V_NAME; parms[3].Value = V_DESCRIPTION; parms[4].Value = V_SHORT_CODE; parms[5].Value = V_COMMAND_REGISTER; parms[6].Value = V_CONTENT_EN; parms[7].Value = V_CONTENT_FR; parms[8].Value = V_CONTENT_LC; parms[9].Value = V_NOTE; parms[10].Value = V_COMPANY_ID; parms[11].Value = V_USERS; parms[12].Value = V_TYPE; parms[13].Value = msgRegisterSuccess; parms[14].Value = msgRegisterFlase; parms[15].Value = msgConfirm; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet svAddGetList(string v_id, string v_users, string v_name, string v_code, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage) { string str; str = ""; str = "BALANCE_PKG.SVADD_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_name", OracleDbType.NVarchar2), new OracleParameter("v_code", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_name; parms[3].Value = v_code; parms[4].Value = v_fromDate; parms[5].Value = v_toDate; parms[6].Value = v_order; parms[7].Value = v_rowsOnPage; parms[8].Value = v_seqPage; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet svAddInsert(string V_CODE, string V_NAME, string V_ADD_TYPE, string V_NUMBER_DISPLAY, string V_PRIORITY, string V_SERVICE_ID, string V_NOTE, string V_USERS) { string str; str = ""; str = "BALANCE_PKG.SVADD_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_ADD_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_NUMBER_DISPLAY", OracleDbType.NVarchar2), new OracleParameter("V_PRIORITY", OracleDbType.NVarchar2), new OracleParameter("V_SERVICE_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", 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_NAME; parms[2].Value = V_ADD_TYPE; parms[3].Value = V_NUMBER_DISPLAY; parms[4].Value = V_PRIORITY; parms[5].Value = V_SERVICE_ID; parms[6].Value = V_NOTE; parms[7].Value = V_USERS; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet svAddUpdate(string V_ID, string V_CODE, string V_NAME, string V_ADD_TYPE, string V_NUMBER_DISPLAY, string V_PRIORITY, string V_SERVICE_ID, string V_NOTE, string V_USERS, string V_TYPE) { string str; str = ""; str = "BALANCE_PKG.SVADD_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_ADD_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_NUMBER_DISPLAY", OracleDbType.NVarchar2), new OracleParameter("V_PRIORITY", OracleDbType.NVarchar2), new OracleParameter("V_SERVICE_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", 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_NAME; parms[3].Value = V_ADD_TYPE; parms[4].Value = V_NUMBER_DISPLAY; parms[5].Value = V_PRIORITY; parms[6].Value = V_SERVICE_ID; parms[7].Value = V_NOTE; parms[8].Value = V_USERS; parms[9].Value = V_TYPE; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camGetList(string v_id, string v_users, string v_name, string v_code, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage,string v_status,string isDefault,string isMyservice) { string str; str = ""; str = "BALANCE_PKG.CAM_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_name", OracleDbType.NVarchar2), new OracleParameter("v_code", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("v_status", OracleDbType.NVarchar2), new OracleParameter("v_isDefault", OracleDbType.NVarchar2), new OracleParameter("v_isMyservice", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_name; parms[3].Value = v_code; parms[4].Value = v_fromDate; parms[5].Value = v_toDate; parms[6].Value = v_order; parms[7].Value = v_rowsOnPage; parms[8].Value = v_seqPage; parms[9].Value = v_status; parms[10].Value = isDefault; parms[11].Value = isMyservice; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camGetListCalendar( string v_users, string v_fromDate, string v_toDate,string status) { string str; str = ""; str = "BALANCE_PKG.CAM_GET_CALENDAR"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_status", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_users; parms[1].Value = v_fromDate; parms[2].Value = v_toDate; parms[3].Value = status; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camInsert(string V_CODE, string V_NAME, string V_FROM_DATE, string V_TO_DATE, string V_FROM_HOUR, string V_TO_HOUR, string V_RULE_ADD, string V_PRIORITY, string V_BALANCE_ID, string V_EXPIRE_DATE_ID, string V_STATUS, string V_NOTE, string V_USERS,string V_NUMBERDIS,string addType,string title,string isDefault,string isMyservice) { string str; str = ""; str = "BALANCE_PKG.CAM_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_FROM_DATE", OracleDbType.NVarchar2), new OracleParameter("V_TO_DATE", OracleDbType.NVarchar2), new OracleParameter("V_FROM_HOUR", OracleDbType.NVarchar2), new OracleParameter("V_TO_HOUR", OracleDbType.NVarchar2), new OracleParameter("V_RULE_ADD", OracleDbType.NVarchar2), new OracleParameter("V_PRIORITY", OracleDbType.NVarchar2), new OracleParameter("V_BALANCE_ID", OracleDbType.NVarchar2), new OracleParameter("V_EXPIRE_DATE_ID", OracleDbType.NVarchar2), new OracleParameter("V_STATUS", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_DISPLAY", OracleDbType.NVarchar2), new OracleParameter("V_ADD_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_TITLE", OracleDbType.NVarchar2), new OracleParameter("V_DEFAULT", OracleDbType.NVarchar2), new OracleParameter("V_MYSERVICE", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_CODE; parms[1].Value = V_NAME; parms[2].Value = V_FROM_DATE; parms[3].Value = V_TO_DATE; parms[4].Value = V_FROM_HOUR; parms[5].Value = V_TO_HOUR; parms[6].Value = V_RULE_ADD; parms[7].Value = V_PRIORITY; parms[8].Value = V_BALANCE_ID; parms[9].Value = V_EXPIRE_DATE_ID; parms[10].Value = V_STATUS; parms[11].Value = V_NOTE; parms[12].Value = V_USERS; parms[13].Value = V_NUMBERDIS; parms[14].Value = addType; parms[15].Value = title; parms[16].Value = isDefault; parms[17].Value = isMyservice; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camUpdate(string V_ID, string V_CODE, string V_NAME, string V_FROM_DATE, string V_TO_DATE, string V_FROM_HOUR, string V_TO_HOUR, string V_RULE_ADD, string V_PRIORITY, string V_BALANCE_ID, string V_EXPIRE_DATE_ID, string V_STATUS, string V_NOTE, string V_USERS, string V_TYPE,string DISPLAY,string addType,string title,string isDefault,string isMyService) { string str; str = ""; str = "BALANCE_PKG.CAM_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_CODE", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_FROM_DATE", OracleDbType.NVarchar2), new OracleParameter("V_TO_DATE", OracleDbType.NVarchar2), new OracleParameter("V_FROM_HOUR", OracleDbType.NVarchar2), new OracleParameter("V_TO_HOUR", OracleDbType.NVarchar2), new OracleParameter("V_RULE_ADD", OracleDbType.NVarchar2), new OracleParameter("V_PRIORITY", OracleDbType.NVarchar2), new OracleParameter("V_BALANCE_ID", OracleDbType.NVarchar2), new OracleParameter("V_EXPIRE_DATE_ID", OracleDbType.NVarchar2), new OracleParameter("V_STATUS", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_DISPLAY", OracleDbType.NVarchar2), new OracleParameter("V_ADD_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_TITLE", OracleDbType.NVarchar2), new OracleParameter("V_DEFAULT", OracleDbType.NVarchar2), new OracleParameter("V_MYSERVICE", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_ID; parms[1].Value = V_CODE; parms[2].Value = V_NAME; parms[3].Value = V_FROM_DATE; parms[4].Value = V_TO_DATE; parms[5].Value = V_FROM_HOUR; parms[6].Value = V_TO_HOUR; parms[7].Value = V_RULE_ADD; parms[8].Value = V_PRIORITY; parms[9].Value = V_BALANCE_ID; parms[10].Value = V_EXPIRE_DATE_ID; parms[11].Value = V_STATUS; parms[12].Value = V_NOTE; parms[13].Value = V_USERS; parms[14].Value = V_TYPE; parms[15].Value = DISPLAY; parms[16].Value = addType; parms[17].Value = title; parms[18].Value = isDefault; parms[19].Value = isMyService; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camCopy(string id) { string str; str = ""; str = "BALANCE_PKG.CAM_COPPY"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = id; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camBalGetList(string v_id, string v_users, string v_campaignId, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage,string channel,string language) { string str; str = ""; str = "BALANCE_PKG.CAM_BAL_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_campaignId", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("v_channel", OracleDbType.Varchar2), new OracleParameter("v_language", OracleDbType.Varchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_campaignId; parms[3].Value = v_fromDate; parms[4].Value = v_toDate; parms[5].Value = v_order; parms[6].Value = v_rowsOnPage; parms[7].Value = v_seqPage; parms[8].Value = channel; parms[9].Value = language; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camBalInsert(string V_CAMPAING_ID, string V_REF_ID, string V_NOTE, string V_USERS, string v_channel , string v_language) { string str; str = ""; str = "BALANCE_PKG.CAM_BAL_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CAMPAING_ID", OracleDbType.NVarchar2), new OracleParameter("V_REF_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", 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_CAMPAING_ID; parms[1].Value = V_REF_ID; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = v_channel; parms[5].Value = v_language; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camBalUpdate(string V_CAMPAING_ID, string V_REF_ID, string V_NOTE, string V_USERS, string v_channel , string v_language,string id,string type) { string str; str = ""; str = "BALANCE_PKG.CAM_BAL_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CAMPAING_ID", OracleDbType.NVarchar2), new OracleParameter("V_REF_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("v_channel", OracleDbType.NVarchar2), new OracleParameter("v_language", OracleDbType.NVarchar2), new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_TYPE", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_CAMPAING_ID; parms[1].Value = V_REF_ID; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = v_channel; parms[5].Value = v_language; parms[6].Value = id; parms[7].Value = type; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camSubGetList(string v_id, string v_users, string v_campaignId, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage, string channel, string language) { string str; str = ""; str = "BALANCE_PKG.CAM_SUB_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_campaignId", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("v_channel", OracleDbType.Varchar2), new OracleParameter("v_language", OracleDbType.Varchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_campaignId; parms[3].Value = v_fromDate; parms[4].Value = v_toDate; parms[5].Value = v_order; parms[6].Value = v_rowsOnPage; parms[7].Value = v_seqPage; parms[8].Value = channel; parms[9].Value = language; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camSubInsert(string V_CAMPAING_ID, string V_REF_ID, string V_NOTE, string V_USERS, string v_channel , string v_language) { string str; str = ""; str = "BALANCE_PKG.CAM_SUB_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CAMPAING_ID", OracleDbType.NVarchar2), new OracleParameter("V_REF_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", 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_CAMPAING_ID; parms[1].Value = V_REF_ID; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = v_channel; parms[5].Value = v_language; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camSubUpdate(string V_CAMPAING_ID, string V_REF_ID, string V_NOTE, string V_USERS, string v_channel , string v_language, string id, string type) { string str; str = ""; str = "BALANCE_PKG.CAM_SUB_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CAMPAING_ID", OracleDbType.NVarchar2), new OracleParameter("V_REF_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("v_channel", OracleDbType.NVarchar2), new OracleParameter("v_language", OracleDbType.NVarchar2), new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_TYPE", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_CAMPAING_ID; parms[1].Value = V_REF_ID; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = v_channel; parms[5].Value = v_language; parms[6].Value = id; parms[7].Value = type; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camExpGetList(string v_id, string v_users, string v_campaignId, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage, string channel, string language) { string str; str = ""; str = "BALANCE_PKG.CAM_EXP_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_campaignId", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("v_channel", OracleDbType.Varchar2), new OracleParameter("v_language", OracleDbType.Varchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_campaignId; parms[3].Value = v_fromDate; parms[4].Value = v_toDate; parms[5].Value = v_order; parms[6].Value = v_rowsOnPage; parms[7].Value = v_seqPage; parms[8].Value = channel; parms[9].Value = language; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camExpInsert(string V_CAMPAING_ID, string V_REF_ID, string V_NOTE, string V_USERS, string v_channel , string v_language) { string str; str = ""; str = "BALANCE_PKG.CAM_EXP_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CAMPAING_ID", OracleDbType.NVarchar2), new OracleParameter("V_REF_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", 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_CAMPAING_ID; parms[1].Value = V_REF_ID; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = v_channel; parms[5].Value = v_language; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camExpUpdate(string V_CAMPAING_ID, string V_REF_ID, string V_NOTE, string V_USERS, string v_channel , string v_language, string id, string type) { string str; str = ""; str = "BALANCE_PKG.CAM_EXP_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CAMPAING_ID", OracleDbType.NVarchar2), new OracleParameter("V_REF_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("v_channel", OracleDbType.NVarchar2), new OracleParameter("v_language", OracleDbType.NVarchar2), new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_TYPE", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_CAMPAING_ID; parms[1].Value = V_REF_ID; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = v_channel; parms[5].Value = v_language; parms[6].Value = id; parms[7].Value = type; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camScGetList(string v_id, string v_users, string v_campaignId, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage, string channel, string language) { string str; str = ""; str = "BALANCE_PKG.CAM_SC_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_campaignId", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("v_channel", OracleDbType.Varchar2), new OracleParameter("v_language", OracleDbType.Varchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_campaignId; parms[3].Value = v_fromDate; parms[4].Value = v_toDate; parms[5].Value = v_order; parms[6].Value = v_rowsOnPage; parms[7].Value = v_seqPage; parms[8].Value = channel; parms[9].Value = language; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camScInsert(string V_CAMPAING_ID, string V_REF_ID, string V_NOTE, string V_USERS, string v_channel , string v_language) { string str; str = ""; str = "BALANCE_PKG.CAM_SC_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CAMPAING_ID", OracleDbType.NVarchar2), new OracleParameter("V_REF_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", 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_CAMPAING_ID; parms[1].Value = V_REF_ID; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = v_channel; parms[5].Value = v_language; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camScUpdate(string V_CAMPAING_ID, string V_REF_ID, string V_NOTE, string V_USERS, string v_channel , string v_language, string id, string type) { string str; str = ""; str = "BALANCE_PKG.CAM_SC_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CAMPAING_ID", OracleDbType.NVarchar2), new OracleParameter("V_REF_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("v_channel", OracleDbType.NVarchar2), new OracleParameter("v_language", OracleDbType.NVarchar2), new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_TYPE", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_CAMPAING_ID; parms[1].Value = V_REF_ID; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = v_channel; parms[5].Value = v_language; parms[6].Value = id; parms[7].Value = type; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camAddGetList(string v_id, string v_users, string v_campaignId, string v_fromDate, string v_toDate , string v_order, string v_rowsOnPage, string v_seqPage) { string str; str = ""; str = "BALANCE_PKG.CAMADD_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_campaignId", OracleDbType.NVarchar2), new OracleParameter("v_fromDate", OracleDbType.NVarchar2), new OracleParameter("v_toDate", OracleDbType.NVarchar2), new OracleParameter("v_order", OracleDbType.NVarchar2), new OracleParameter("v_rowsOnPage", OracleDbType.NVarchar2), new OracleParameter("v_seqPage", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_id; parms[1].Value = v_users; parms[2].Value = v_campaignId; parms[3].Value = v_fromDate; parms[4].Value = v_toDate; parms[5].Value = v_order; parms[6].Value = v_rowsOnPage; parms[7].Value = v_seqPage; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camAddInsert(string V_CAMPAING_ID, string V_SERVICE_ADD_ID, string V_NOTE, string V_USERS, string ussdDisplay,string keyRegister) { string str; str = ""; str = "BALANCE_PKG.CAMADD_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_CAMPAING_ID", OracleDbType.NVarchar2), new OracleParameter("V_SERVICE_ADD_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_USSD_DIS", OracleDbType.NVarchar2), new OracleParameter("V_KEY_REGIS", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_CAMPAING_ID; parms[1].Value = V_SERVICE_ADD_ID; parms[2].Value = V_NOTE; parms[3].Value = V_USERS; parms[4].Value = ussdDisplay; parms[5].Value = keyRegister; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet camAddUpdate(string V_ID, string V_CAMPAING_ID, string V_SERVICE_ADD_ID, string V_NOTE, string V_USERS, string V_TYPE,string ussdDisplay,string keyRegister) { string str; str = ""; str = "BALANCE_PKG.CAMADD_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_CAMPAING_ID", OracleDbType.NVarchar2), new OracleParameter("V_SERVICE_ADD_ID", OracleDbType.NVarchar2), new OracleParameter("V_NOTE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("V_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_USSD_DIS", OracleDbType.NVarchar2), new OracleParameter("V_KEY_REGIS", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_ID; parms[1].Value = V_CAMPAING_ID; parms[2].Value = V_SERVICE_ADD_ID; parms[3].Value = V_NOTE; parms[4].Value = V_USERS; parms[5].Value = V_TYPE; parms[6].Value = ussdDisplay; parms[7].Value = keyRegister; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet ADMIN_USERS_FUNCTION(string role) { // {"msisdn":"50940227941","users":"123","pass":"123","serviceId":"23","type":"DK","channel":"WEB"} string str; str = ""; str = "BALANCE_PKG.ADMIN_GET_ROLE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_role", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = role; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet ADMIN_USERS_INFO(string v_users, string v_pass) { // {"msisdn":"50940227941","users":"123","pass":"123","serviceId":"23","type":"DK","channel":"WEB"} string str; str = ""; str = "BALANCE_PKG.ADMIN_LOGIN"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_user", OracleDbType.NVarchar2), new OracleParameter("v_pass", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_users; parms[1].Value = v_pass; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet ngamGetList(string v_id, string v_users) { string str; str = ""; str = "BALANCE_PKG.TMP_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 ngamInsert(string V_NAME, string V_SV, string V_MSG, string V_FD, string V_TD, string V_PC, string V_ADD_TYPE, string V_USERS) { string str; str = ""; str = "BALANCE_PKG.TMP_INSERT"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_SV", OracleDbType.NVarchar2), new OracleParameter("V_MSG", OracleDbType.NVarchar2), new OracleParameter("V_FD", OracleDbType.NVarchar2), new OracleParameter("V_TD", OracleDbType.NVarchar2), new OracleParameter("V_PC", OracleDbType.NVarchar2), new OracleParameter("V_ADD_TYPE", OracleDbType.NVarchar2), new OracleParameter("V_USERS", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_NAME; parms[1].Value = V_SV; parms[2].Value = V_MSG; parms[3].Value = V_FD; parms[4].Value = V_TD; parms[5].Value = V_PC; parms[6].Value = V_ADD_TYPE; parms[7].Value = V_USERS; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet ngamUpdate(string V_ID, string V_NAME, string V_SV, string V_MSG, string V_FD, string V_TD, string V_PC, string V_ADD_TYPE, string V_USERS, string V_TYPE) { string str; str = ""; str = "BALANCE_PKG.TMP_UPDATE"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("V_ID", OracleDbType.NVarchar2), new OracleParameter("V_NAME", OracleDbType.NVarchar2), new OracleParameter("V_SV", OracleDbType.NVarchar2), new OracleParameter("V_MSG", OracleDbType.NVarchar2), new OracleParameter("V_FD", OracleDbType.NVarchar2), new OracleParameter("V_TD", OracleDbType.NVarchar2), new OracleParameter("V_PC", OracleDbType.NVarchar2), new OracleParameter("V_ADD_TYPE", 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_NAME; parms[2].Value = V_SV; parms[3].Value = V_MSG; parms[4].Value = V_FD; parms[5].Value = V_TD; parms[6].Value = V_PC; parms[7].Value = V_ADD_TYPE; parms[8].Value = V_USERS; parms[9].Value = V_TYPE; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet blackGettList(string msisdn,string type,string svid, string v_users) { string str; str = ""; str = "BALANCE_PKG.BLACK_GET"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_msisdn", OracleDbType.NVarchar2), new OracleParameter("v_type", OracleDbType.NVarchar2), new OracleParameter("v_sv_id", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = msisdn; parms[1].Value = type; parms[2].Value = svid; parms[3].Value = v_users; return DataAccess.getDataFromProcedure(str, "", parms); } public static DataSet lkpw_result_update(string v_randomId, string v_users, string v_result, string v_status, string v_note) { string str; str = ""; str = "LOTO_CMS_PKG.lkpw_result_update"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_randomId", OracleDbType.NVarchar2), new OracleParameter("v_users", OracleDbType.NVarchar2), new OracleParameter("v_result", OracleDbType.NVarchar2), new OracleParameter("v_status", OracleDbType.NVarchar2), new OracleParameter("v_note", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = v_randomId; parms[1].Value = v_users; parms[2].Value = v_result; parms[3].Value = v_status; parms[4].Value = v_note; return DataAccess.getDataFromProcedure(str, "", parms); } public static void InsertBulkExport(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_export_id = dataColumn[0].ToArray(); OracleParameter param0 = new OracleParameter("v_export_id", OracleDbType.NVarchar2, ParameterDirection.Input); param0.Value = v_export_id; param0.Size = v_export_id.Length; command.Parameters.Add(param0); var v_winner_id = dataColumn[1].ToArray(); OracleParameter param1 = new OracleParameter("v_winner_id", OracleDbType.NVarchar2, ParameterDirection.Input); param1.Value = v_winner_id; param1.Size = v_winner_id.Length; command.Parameters.Add(param1); var v_msisdn = dataColumn[2].ToArray(); OracleParameter param2 = new OracleParameter("v_msisdn", OracleDbType.NVarchar2, ParameterDirection.Input); param2.Value = v_msisdn; param2.Size = v_msisdn.Length; command.Parameters.Add(param2); var v_money = dataColumn[3].ToArray(); OracleParameter param3 = new OracleParameter("v_money", OracleDbType.NVarchar2, ParameterDirection.Input); param3.Value = v_money; param3.Size = v_money.Length; command.Parameters.Add(param3); var v_random_id = dataColumn[4].ToArray(); OracleParameter param4 = new OracleParameter("v_random_id", OracleDbType.NVarchar2, ParameterDirection.Input); param4.Value = v_random_id; param4.Size = v_random_id.Length; command.Parameters.Add(param4); var v_bet_id = dataColumn[5].ToArray(); OracleParameter param5 = new OracleParameter("v_bet_id", OracleDbType.NVarchar2, ParameterDirection.Input); param5.Value = v_bet_id; param5.Size = v_bet_id.Length; command.Parameters.Add(param5); var v_winner_code = dataColumn[6].ToArray(); OracleParameter param6 = new OracleParameter("v_winner_code", OracleDbType.NVarchar2, ParameterDirection.Input); param6.Value = v_winner_code; param6.Size = v_winner_code.Length; command.Parameters.Add(param6); command.ExecuteNonQuery(); transaction.Commit(); } } catch (OracleException ex) { Console.WriteLine(ex.ToString()); throw; } finally { connection.Close(); } } public static void InsertBulkBlack(string sSQL, List> dataColumn) { OracleConnection connection = null; try { connection = DataAccess.getPoolingConnection(); connection.Open(); OracleTransaction transaction; // Start a local transaction transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted); using (var command = connection.CreateCommand()) { command.CommandText = sSQL; command.CommandType = CommandType.StoredProcedure; command.ArrayBindCount = dataColumn[0].Count; command.Transaction = transaction; var v_users = dataColumn[0].ToArray(); OracleParameter param0 = new OracleParameter("v_users", OracleDbType.NVarchar2, ParameterDirection.Input); param0.Value = v_users; param0.Size = v_users.Length; command.Parameters.Add(param0); var v_msisdn = dataColumn[1].ToArray(); OracleParameter param1 = new OracleParameter("v_msisdn", OracleDbType.NVarchar2, ParameterDirection.Input); param1.Value = v_msisdn; param1.Size = v_msisdn.Length; command.Parameters.Add(param1); var v_isLock = dataColumn[2].ToArray(); OracleParameter param2 = new OracleParameter("v_isLock", OracleDbType.NVarchar2, ParameterDirection.Input); param2.Value = v_isLock; param2.Size = v_isLock.Length; command.Parameters.Add(param2); var v_note = dataColumn[3].ToArray(); OracleParameter param3 = new OracleParameter("v_note", OracleDbType.NVarchar2, ParameterDirection.Input); param3.Value = v_note; param3.Size = v_note.Length; command.Parameters.Add(param3); command.ExecuteNonQuery(); transaction.Commit(); } } catch (OracleException ex) { Console.WriteLine(ex.ToString()); throw; } finally { connection.Close(); } } public static DataSet reload( string V_TYPE, string V_USERS) { string str; str = ""; str = "BALANCE_PKG.pro_get_update"; OracleParameter[] parms; parms = new OracleParameter[] { new OracleParameter("v_prId", OracleDbType.NVarchar2), new OracleParameter("v_user", OracleDbType.NVarchar2), new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output), }; parms[0].Value = V_TYPE; parms[1].Value = V_USERS; return DataAccess.getDataFromProcedure(str, "", parms); } } }