Bplus/ApiWeb/ApiProcessToken/Models/systemDataAccess.cs

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

        }

        public static DataSet SYS_GET_SERVICE_BY_ID(string v_SV_ID)
        {

            string str;
            str = "";
            str = "api_pkg.SYS_GET_SERVICE_BY_ID";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_sv_id", OracleDbType.NVarchar2),
                               
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_SV_ID;

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

        public static DataSet SYS_UPDATE_LOG_CHARGE(string msisdn, string sv_id, string money, string cmd_code, string cmd_msg, string err_code, string err_msg, string isRenew)
        {

            string str;
            str = "";
            str = "api_pkg.SYS_UPDATE_LOG_CHARGE";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_sv_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_money", OracleDbType.NVarchar2),
                                new OracleParameter("v_cmd_code", OracleDbType.NVarchar2),
                                new OracleParameter("v_cmd_msg", OracleDbType.NVarchar2),
                                new OracleParameter("v_err_code", OracleDbType.NVarchar2),
                                new OracleParameter("v_err_msg", OracleDbType.NVarchar2),
                                new OracleParameter("v_isrenew", OracleDbType.NVarchar2),

                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = msisdn;
            parms[2].Value = sv_id;
            parms[3].Value = money;
            parms[4].Value = cmd_code;
            parms[5].Value = cmd_msg;
            parms[6].Value = err_code;
            parms[7].Value = err_msg;
            parms[8].Value = isRenew;

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







    }
}