Bplus/ApiWeb/ApiProcessToken/Models/webserviceDataAccess.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 webserviceDataAccess
    {
        public webserviceDataAccess()
        {

        }


      




        public static DataSet ProcessSub(string username, string password, string serviceid, string msisdn,
            string chargetime, string paramss, string mode, string amount, string command, string prefix, string transaction)
        {
            string str;
            str = "";
            str = "MPS_PKG.PROCESS_SMS_SUB ";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_username", OracleDbType.NVarchar2),
                                new OracleParameter("v_password", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_chargetime", OracleDbType.NVarchar2),
                                new OracleParameter("v_paramss", OracleDbType.NVarchar2),
                                new OracleParameter("v_mode", OracleDbType.NVarchar2),
                                new OracleParameter("v_amount", OracleDbType.NVarchar2),
                                new OracleParameter("v_command", OracleDbType.NVarchar2),                       
                                new OracleParameter("v_prefix", OracleDbType.NVarchar2),
                                new OracleParameter("v_transaction", OracleDbType.NVarchar2),
                     			new OracleParameter("P_RESULT ",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = username;
            parms[1].Value = password;
            parms[2].Value = serviceid;
            parms[3].Value = msisdn;
            parms[4].Value = chargetime;
            parms[5].Value = paramss;
            parms[6].Value = mode;
            parms[7].Value = amount;
            parms[8].Value = command;
            parms[9].Value = prefix;
            parms[10].Value = transaction;


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



        public static DataSet ProcessCheckBuy1Time(string username, string password, string serviceid, string msisdn,
            string chargetime, string paramss, string mode, string amount, string command, string prefix, string transaction)
        {
            string str;
            str = "";
            str = "MPS_PKG.PROCESS_SMS_SUB_CHECK";
            OracleParameter[] parms;
            parms = new OracleParameter[]
                            {
                                new OracleParameter("v_username", OracleDbType.NVarchar2),
                                new OracleParameter("v_password", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_chargetime", OracleDbType.NVarchar2),
                                new OracleParameter("v_paramss", OracleDbType.NVarchar2),
                                new OracleParameter("v_mode", OracleDbType.NVarchar2),
                                new OracleParameter("v_amount", OracleDbType.NVarchar2),
                                new OracleParameter("v_command", OracleDbType.NVarchar2),
                                new OracleParameter("v_prefix", OracleDbType.NVarchar2),
                                new OracleParameter("v_transaction", OracleDbType.NVarchar2),
                                 new OracleParameter("P_RESULT ",OracleDbType.RefCursor,ParameterDirection.Output),
            };
            parms[0].Value = username;
            parms[1].Value = password;
            parms[2].Value = serviceid;
            parms[3].Value = msisdn;
            parms[4].Value = chargetime;
            parms[5].Value = paramss;
            parms[6].Value = mode;
            parms[7].Value = amount;
            parms[8].Value = command;
            parms[9].Value = prefix;
            parms[10].Value = transaction;


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



        //For ALL
        public static DataSet changeZodiacNew(string username, string password, string subServiceId, string msisdn,
             string paramss)
        {
            string str;
            str = "";
            str = "HORO_PKG.HORO_CHANGE_ZODIAC ";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_username", OracleDbType.NVarchar2),
                                new OracleParameter("v_password", OracleDbType.NVarchar2),
                                new OracleParameter("v_subServiceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_paramss", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT ",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = username;
            parms[1].Value = password;
            parms[2].Value = subServiceId;
            parms[3].Value = msisdn;
            parms[4].Value = paramss;



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


        //For Natcom
        public static DataSet changeZodiac(string username, string password, string subServiceId, string msisdn,
             string paramss)
        {
            string str;
            str = "";
            str = "natcom_pkg.HORO_CHANGE_ZODIAC ";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_username", OracleDbType.NVarchar2),
                                new OracleParameter("v_password", OracleDbType.NVarchar2),
                                new OracleParameter("v_subServiceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_paramss", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT ",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = username;
            parms[1].Value = password;
            parms[2].Value = subServiceId;
            parms[3].Value = msisdn;
            parms[4].Value = paramss;
           


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









        public static DataSet ProcessSubUssd(string username, string password, string serviceid, string msisdn,
            string chargetime, string paramss, string mode, string amount, string transactionId, string other_and_more,string prefix)
        {
            string str;
            str = "";
            str = "MPS_PKG.PROCESS_USSD_SUB ";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_username", OracleDbType.NVarchar2),
                                new OracleParameter("v_password", OracleDbType.NVarchar2),
                                new OracleParameter("v_servicename", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_chargetime", OracleDbType.NVarchar2),
                                new OracleParameter("v_paramss", OracleDbType.NVarchar2),
                                new OracleParameter("v_mode", OracleDbType.NVarchar2),
                                new OracleParameter("v_amount", OracleDbType.NVarchar2),
                                new OracleParameter("v_transactionId", OracleDbType.NVarchar2),
                                new OracleParameter("v_other_and_more", OracleDbType.NVarchar2),                       
                                new OracleParameter("v_prefix", OracleDbType.NVarchar2),
                     			new OracleParameter("P_RESULT ",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = username;
            parms[1].Value = password;
            parms[2].Value = serviceid;
            parms[3].Value = msisdn;
            parms[4].Value = chargetime;
            parms[5].Value = paramss;
            parms[6].Value = mode;
            parms[7].Value = amount;
            parms[8].Value = other_and_more;
            parms[9].Value = prefix;

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

        public static DataSet ProcessCharge(string username, string password, string serviceid, string msisdn,
            string chargetime, string paramss, string mode, string amount, string prefix,string cmd,string transaction)
        {
            string str;
            str = "";
            str = "MPS_PKG.PROCESS_SMS_CHARGE ";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_username", OracleDbType.NVarchar2),
                                new OracleParameter("v_password", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_chargetime", OracleDbType.NVarchar2),
                                new OracleParameter("v_paramss", OracleDbType.NVarchar2),
                                new OracleParameter("v_mode", OracleDbType.NVarchar2),
                                new OracleParameter("v_amount", OracleDbType.NVarchar2),
                                new OracleParameter("v_prefix", OracleDbType.NVarchar2),    
                                new OracleParameter("v_command", OracleDbType.NVarchar2),
                                new OracleParameter("v_transaction", OracleDbType.NVarchar2),
                     			new OracleParameter("P_RESULT ",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = username;
            parms[1].Value = password;
            parms[2].Value = serviceid;
            parms[3].Value = msisdn;
            parms[4].Value = chargetime;
            parms[5].Value = paramss;
            parms[6].Value = mode;
            parms[7].Value = amount;
            parms[8].Value = prefix;
            parms[9].Value = cmd;
            parms[10].Value = transaction;


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

        public static DataSet ProcessKeyWord(string username, string password, string serviceid, string msisdn,
            string chargetime, string paramss, string mode, string amount, string prefix, string cmd, string transaction)
        {
            string str;
            str = "";
            str = "MPS_PKG.PROCESS_SMS_KEYWORD ";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_username", OracleDbType.NVarchar2),
                                new OracleParameter("v_password", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_chargetime", OracleDbType.NVarchar2),
                                new OracleParameter("v_paramss", OracleDbType.NVarchar2),
                                new OracleParameter("v_mode", OracleDbType.NVarchar2),
                                new OracleParameter("v_amount", OracleDbType.NVarchar2),
                                new OracleParameter("v_prefix", OracleDbType.NVarchar2),    
                                new OracleParameter("v_command", OracleDbType.NVarchar2),
                                new OracleParameter("v_transaction", OracleDbType.NVarchar2),
                     			new OracleParameter("P_RESULT ",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = username;
            parms[1].Value = password;
            parms[2].Value = serviceid;
            parms[3].Value = msisdn;
            parms[4].Value = chargetime;
            parms[5].Value = paramss;
            parms[6].Value = mode;
            parms[7].Value = amount;
            parms[8].Value = prefix;
            parms[9].Value = cmd;
            parms[10].Value = transaction;


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

        public static DataSet ProcessGetContent(string username, string password, string serviceid, string msisdn,
            string trangId, string paramss, string mode, string amount, string prefix)
        {
            string str;
            str = "";
            str = "MPS_PKG.PROCESS_GET_CONTENT";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_username", OracleDbType.NVarchar2),
                                new OracleParameter("v_password", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceid", OracleDbType.NVarchar2),
                                new OracleParameter("v_msisdn", OracleDbType.NVarchar2),
                                new OracleParameter("v_trangId", OracleDbType.NVarchar2),
                                new OracleParameter("v_paramss", OracleDbType.NVarchar2),
                                new OracleParameter("v_mode", OracleDbType.NVarchar2),
                                new OracleParameter("v_amount", OracleDbType.NVarchar2),
                                new OracleParameter("v_prefix", OracleDbType.NVarchar2),    
                                
                     			new OracleParameter("P_RESULT ",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = username;
            parms[1].Value = password;
            parms[2].Value = serviceid;
            parms[3].Value = msisdn;
            parms[4].Value = trangId;
            parms[5].Value = paramss;
            parms[6].Value = mode;
            parms[7].Value = amount;
            parms[8].Value = prefix;


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




    }
}