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

        }



        public static DataSet sv_news_up_read(string v_usres, string v_serviceId, string v_newsId)
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.sv_news_up_read";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_usres", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_newsId", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_usres;
            parms[1].Value = v_serviceId;
            parms[2].Value = v_newsId;
           

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


        public static DataSet sv_news_sendMT(string v_usres, string v_serviceId, string v_newsId)
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.svs_send_sms";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_newsId", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_usres;
            parms[1].Value = v_serviceId;
            parms[2].Value = v_newsId;


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


        public static DataSet sv_news_insert(string v_serviceId, string v_parentId, string v_code, string v_name_global, string v_name_local,
            string v_description_global, string v_description_local, string v_introduction_global, string v_introduction_local
            , string v_icon, string v_logo, string v_content, string v_contenType
            , string v_provinceId, string v_topicId, string v_fromDate, string v_toDate,string is_show,string type,string users,string note,
            string v_name_global1,
  string v_name_global2,
  string v_description_global1,
  string v_description_global2,
  string v_content_global,
  string v_content_global1,
  string v_content_global2,
  string v_introduction_global1,
  string v_introduction_global2
            )
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.sv_news_insert";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_parentId", OracleDbType.NVarchar2),
                                new OracleParameter("v_code", OracleDbType.NVarchar2),
                                new OracleParameter("v_name_global", OracleDbType.NVarchar2),
                                new OracleParameter("v_name_local", OracleDbType.NVarchar2),
                                new OracleParameter("v_description_global", OracleDbType.NVarchar2),
                                new OracleParameter("v_description_local", OracleDbType.NVarchar2),
                                new OracleParameter("v_introduction_global", OracleDbType.Clob),
                                new OracleParameter("v_introduction_local", OracleDbType.Clob),
                                new OracleParameter("v_icon", OracleDbType.NVarchar2),
                                new OracleParameter("v_logo", OracleDbType.NVarchar2),
                                new OracleParameter("v_content", OracleDbType.Clob),
                                new OracleParameter("v_contenType", OracleDbType.NVarchar2),

                                new OracleParameter("v_provinceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_topicId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_isShow", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_note", OracleDbType.Clob),

                                new OracleParameter("v_name_global1", OracleDbType.NVarchar2),
                                new OracleParameter("v_name_global2", OracleDbType.NVarchar2),
                                new OracleParameter("v_description_global1", OracleDbType.NVarchar2),
                                new OracleParameter("v_description_global2", OracleDbType.NVarchar2),
                                new OracleParameter("v_content_global", OracleDbType.Clob),
                                new OracleParameter("v_content_global1", OracleDbType.Clob),
                                new OracleParameter("v_content_global2", OracleDbType.Clob),
                                new OracleParameter("v_introduction_global1", OracleDbType.Clob),
                                new OracleParameter("v_introduction_global2", OracleDbType.Clob),



                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_serviceId;
            parms[1].Value = v_parentId;
            parms[2].Value = v_code;
            parms[3].Value = v_name_global;
            parms[4].Value = v_name_local;
            parms[5].Value = v_description_global;
            parms[6].Value = v_description_local;
            parms[7].Value = v_introduction_global;
            parms[8].Value = v_introduction_local;
            parms[9].Value = v_icon;
            parms[10].Value = v_logo;
            parms[11].Value = v_content;
            parms[12].Value = v_contenType;

            parms[13].Value = v_provinceId;
            parms[14].Value = v_topicId;
            parms[15].Value = v_fromDate;
            parms[16].Value = v_toDate;
            parms[17].Value = is_show;
            parms[18].Value = type;
            parms[19].Value = users;
            parms[20].Value = note;

            parms[21].Value = v_name_global1;
            parms[22].Value = v_name_global2;
            parms[23].Value = v_description_global1;
            parms[24].Value = v_description_global2;
            parms[25].Value = v_content_global;
            parms[26].Value = v_content_global1;
            parms[27].Value = v_content_global2;
            parms[28].Value = v_introduction_global1;
            parms[29].Value = v_introduction_global2;



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



        public static DataSet sv_news_update(string v_serviceId, string v_parentId, string v_code, string v_name_global, string v_name_local,
            string v_description_global, string v_description_local, string v_introduction_global, string v_introduction_local
            , string v_icon, string v_logo, string v_content, string v_contenType,string vtype,string vid
            , string v_provinceId, string v_topicId, string v_fromDate, string v_toDate,string is_show,string note,
             string v_name_global1,
  string v_name_global2,
  string v_description_global1,
  string v_description_global2,
  string v_content_global,
  string v_content_global1,
  string v_content_global2,
  string v_introduction_global1,
  string v_introduction_global2
            )
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.svs_news_update";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_parentId", OracleDbType.NVarchar2),
                                new OracleParameter("v_code", OracleDbType.NVarchar2),
                                new OracleParameter("v_name_global", OracleDbType.NVarchar2),
                                new OracleParameter("v_name_local", OracleDbType.NVarchar2),
                                new OracleParameter("v_description_global", OracleDbType.NVarchar2),
                                new OracleParameter("v_description_local", OracleDbType.NVarchar2),
                                new OracleParameter("v_introduction_global", OracleDbType.NVarchar2),
                                new OracleParameter("v_introduction_local", OracleDbType.NVarchar2),
                                new OracleParameter("v_icon", OracleDbType.NVarchar2),
                                new OracleParameter("v_logo", OracleDbType.NVarchar2),
                                new OracleParameter("v_content", OracleDbType.Clob),
                                new OracleParameter("v_contenType", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("v_Id", OracleDbType.NVarchar2),

                                new OracleParameter("v_provinceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_topicId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_isShow", OracleDbType.NVarchar2),
                                new OracleParameter("v_note", OracleDbType.Clob),

                                new OracleParameter("v_name_global1", OracleDbType.Clob),
                                new OracleParameter("v_name_global2", OracleDbType.Clob),
                                new OracleParameter("v_description_global1", OracleDbType.Clob),
                                new OracleParameter("v_description_global2", OracleDbType.Clob),
                                new OracleParameter("v_content_global", OracleDbType.Clob),
                                new OracleParameter("v_content_global1", OracleDbType.Clob),
                                new OracleParameter("v_content_global2", OracleDbType.Clob),
                                new OracleParameter("v_introduction_global1", OracleDbType.Clob),
                                new OracleParameter("v_introduction_global2", OracleDbType.Clob),


                               
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_serviceId;
            parms[1].Value = v_parentId;
            parms[2].Value = v_code;
            parms[3].Value = v_name_global;
            parms[4].Value = v_name_local;
            parms[5].Value = v_description_global;
            parms[6].Value = v_description_local;
            parms[7].Value = v_introduction_global;
            parms[8].Value = v_introduction_local;
            parms[9].Value = v_icon;
            parms[10].Value = v_logo;
            parms[11].Value = v_content;
            parms[12].Value = v_contenType;
            parms[13].Value = vtype;
            parms[14].Value = vid;

            parms[15].Value = v_provinceId;
            parms[16].Value = v_topicId;
            parms[17].Value = v_fromDate;
            parms[18].Value = v_toDate;
            parms[19].Value = is_show;
            parms[20].Value = note;

            parms[21].Value = v_name_global1;
            parms[22].Value = v_name_global2;
            parms[23].Value = v_description_global1;
            parms[24].Value = v_description_global2;
            parms[25].Value = v_content_global;
            parms[26].Value = v_content_global1;
            parms[27].Value = v_content_global2;
            parms[28].Value = v_introduction_global1;
            parms[29].Value = v_introduction_global2;

         




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

        public static DataSet sv_news_getById(string v_Id,string v_svId,string v_users,string language)
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.svs_news_getById";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_Id", OracleDbType.NVarchar2),
                                new OracleParameter("v_svId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                               new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_Id;
            parms[1].Value = v_svId;
            parms[2].Value = v_users;
            parms[3].Value = language;

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


        public static DataSet sv_news_getByParentId(string v_Id, string v_svId, string v_users, string v_rowOnePage, string v_seqPage,
            string isGetContet,string isShow,string type,string channel,string language,string code,string isGetChildById)
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.svs_news_getByParentId";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_Id", OracleDbType.NVarchar2),
                                new OracleParameter("v_svId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPay", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                              
                                new OracleParameter("v_isGetContent", OracleDbType.NVarchar2),
                                new OracleParameter("v_isShow", OracleDbType.NVarchar2),
                                new OracleParameter("v_type", OracleDbType.NVarchar2),
                                new OracleParameter("v_channel", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("v_code", OracleDbType.NVarchar2),
                                new OracleParameter("v_isGetChildById", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_Id;
            parms[1].Value = v_svId;
            parms[2].Value = v_users;
            parms[3].Value = v_rowOnePage;
            parms[4].Value = v_seqPage;
            parms[5].Value = isGetContet;
            parms[6].Value = isShow;
            parms[7].Value = type;
            parms[8].Value = channel;
            parms[9].Value = language;
            parms[10].Value = code;
            parms[11].Value = isGetChildById;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }


        public static DataSet sv_news_getByUsers(string v_svId, string v_users, string v_rowOnePage, string v_seqPage,
           string isGetContet, string isShow,string language)
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.svs_news_getByUsers";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                
                                new OracleParameter("v_svId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_rowsOnPay", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                              
                                new OracleParameter("v_isGetContent", OracleDbType.NVarchar2),
                                new OracleParameter("v_isShow", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            
            parms[0].Value = v_svId;
            parms[1].Value = v_users;
            parms[2].Value = v_rowOnePage;
            parms[3].Value = v_seqPage;
            parms[4].Value = isGetContet;
            parms[5].Value = isShow;
            parms[6].Value = language;

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





        public static DataSet newsSearchProTopDate(string v_svId, string v_users,string proviceId,string topicId,string fromdate,string todate, string v_rowOnePage, string v_seqPage, string isGetContet,string name,string language)
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.svs_news_Search";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                               
                                new OracleParameter("v_svId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),

                                new OracleParameter("v_provinId", OracleDbType.NVarchar2),
                                new OracleParameter("v_topicId", OracleDbType.NVarchar2),
                                new OracleParameter("v_fromDate", OracleDbType.NVarchar2),
                                new OracleParameter("v_toDate", OracleDbType.NVarchar2),


                                new OracleParameter("v_rowsOnPay", OracleDbType.NVarchar2),
                                new OracleParameter("v_seqPage", OracleDbType.NVarchar2),
                              
                                new OracleParameter("v_isGetContent", OracleDbType.NVarchar2),
                                new OracleParameter("v_name", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
          
            parms[0].Value = v_svId;
            parms[1].Value = v_users;
            parms[2].Value = proviceId;
            parms[3].Value = topicId;
            parms[4].Value = fromdate;
            parms[5].Value = todate;

            parms[6].Value = v_rowOnePage;
            parms[7].Value = v_seqPage;
            parms[8].Value = isGetContet;
            parms[9].Value = name;
            parms[10].Value = language;
            
            return DataAccess.getDataFromProcedure(str, "", parms);
        }




        public static DataSet newsGetTop(string v_svId, string v_users, string top, string isGetContet, string level,string language)
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.svs_news_getTop";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                               
                                new OracleParameter("v_svId", OracleDbType.NVarchar2),
                                new OracleParameter("v_users", OracleDbType.NVarchar2),

                                new OracleParameter("v_top", OracleDbType.NVarchar2),
                                
                                new OracleParameter("v_isGetContent", OracleDbType.NVarchar2),
                                new OracleParameter("v_level", OracleDbType.NVarchar2),
                                new OracleParameter("v_language", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};

            parms[0].Value = v_svId;
            parms[1].Value = v_users;
            parms[2].Value = top;
            parms[3].Value = isGetContet;
            parms[4].Value = level;
            parms[5].Value = language;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }




        public static DataSet newsBuy(string v_users, string n_serviceid, string n_news, string subserviceCode)
        {

            string str;
            str = "";
            str = "news_pkg.svs_news_buy";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_users", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_newsId", 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_news;
            parms[3].Value = subserviceCode;

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

        public static DataSet web_news_insert(string v_title, string v_serviceId, string v_content, string v_des,string v_url)
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.web_news_insert";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_title", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_content", OracleDbType.Clob),
                                new OracleParameter("v_des", OracleDbType.NVarchar2),
                                new OracleParameter("v_url", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_title;
            parms[1].Value = v_serviceId;
            parms[2].Value = v_content;
            parms[3].Value = v_des;
            parms[4].Value = v_url;
           
            return DataAccess.getDataFromProcedure(str, "", parms);
        }


        public static DataSet web_news_update(string v_id, string v_title, string v_serviceId, string v_content, string v_des, string v_url, string v_type)
        {
            // {"id":"4","title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10","type":"0",}
            string str;
            str = "";
            str = "news_pkg.web_news_update";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_id", OracleDbType.NVarchar2),     
                                new OracleParameter("v_title", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_content", OracleDbType.Clob),
                                new OracleParameter("v_des", OracleDbType.NVarchar2),
                                new OracleParameter("v_url", 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_title;
            parms[2].Value = v_serviceId;
            parms[3].Value = v_content;
            parms[4].Value = v_des;
            parms[5].Value = v_url;
            parms[6].Value = v_type;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }


        public static DataSet web_news_get(string v_serviceid, string v_status, string v_date, string v_id, string top, string v_isGetContent)
        {
            //{"id":"10","serviceId":"30","status":"-1","date":"13/02/2020" } 
            string str;
            str = "";
            str = "news_pkg.web_news_get";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),     
                                new OracleParameter("v_status", OracleDbType.NVarchar2),
                                new OracleParameter("v_date", OracleDbType.NVarchar2),
                                new OracleParameter("v_id", OracleDbType.NVarchar2),
                                new OracleParameter("v_top", OracleDbType.NVarchar2),
                                new OracleParameter("v_isGetContent", OracleDbType.NVarchar2),
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_serviceid;
            parms[1].Value = v_status;
            parms[2].Value = v_date;
            parms[3].Value = v_id;
            parms[4].Value = top;
            parms[5].Value = v_isGetContent;

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


        public static DataSet web_lettery_get(string v_tungay, string v_denngay)
        {
            // {"fromDate":"01/02/2020","toDate":"20/02/2020"}
            string str;
            str = "";
            str = "news_pkg.lottery_get";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_tungay", OracleDbType.NVarchar2),     
                                new OracleParameter("v_denngay", OracleDbType.NVarchar2),
                                
                                new OracleParameter("P_RESULT",OracleDbType.RefCursor,ParameterDirection.Output),
			};
            parms[0].Value = v_tungay;
            parms[1].Value = v_denngay;
            

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


    }
}