using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;

namespace ResfullApi.Models.edu
{
    public class lotoDataAccess
    {
        public lotoDataAccess()
        {

        }


        public static DataSet CATEGORY_GET(string v_users, string n_serviceid, string v_categoryCode)
        {
          
            string str;
            str = "";
            str = "edu_pkg.CATEGORY_GET";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_categoryCode", OracleDbType.NVarchar2),
                               
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_users;
            parms[1].Value = n_serviceid;
            parms[2].Value = v_categoryCode;
          
            return DataAccess.getDataFromProcedure(str, "", parms);
        }

        public static DataSet COURSE_GET(string v_users, string n_serviceid, string v_categoryId)
        {

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

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


        public static DataSet LESSON_GET(string v_users, string n_serviceid, string v_courseId)
        {

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

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


        public static DataSet VOCABULARY_GET(string v_users, string n_serviceid, string v_lessonId)
        {

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

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


        public static DataSet LISTEN_GET(string v_users, string n_serviceid, string v_lessonId)
        {

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

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


        public static DataSet GRAMMAR_GET(string v_users, string n_serviceid, string v_lessonId)
        {

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

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


        public static DataSet GRAMMAR_EX_GET(string v_users, string n_serviceid, string v_grammarId)
        {

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

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



        public static DataSet QUESTION_GET(string v_users, string n_serviceid, string v_lessonId)
        {

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

            return DataAccess.getDataFromProcedure(str, "", parms);
        }
        public static DataSet QUESTION_UPDATE(string v_users, string n_serviceid, string v_lessonId,string v_questionInfo)
        {

            string str;
            str = "";
            str = "edu_pkg.QUESTION_UPDATE";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_lessonId", OracleDbType.NVarchar2),
                                new OracleParameter("v_questionInfo", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_users;
            parms[1].Value = n_serviceid;
            parms[2].Value = v_lessonId;
            parms[3].Value = v_questionInfo;

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



        public static DataSet COURSE_BUY(string v_users, string n_serviceid, string n_courseid, string subserviceCode)
        {

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

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

        public static DataSet COURSE_GET_HIS(string v_users, string n_serviceid, string v_categoryCode)
        {

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

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



        public static DataSet RANKINGE_GET_LIST(string v_users, string n_serviceid)
        {

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

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


    }
}