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

        }

        public static DataSet sms_news_insert(string v_title, string v_serviceId, string v_content, string v_datesend)
        {
            // {"title":"xxxx","serviceId":"30","content":"cong hoa xa hoi chu nghia","dateSend":"01/12/2020 01:01:10"}
            string str;
            str = "";
            str = "news_pkg.sms_news_insert";
            OracleParameter[] parms;
            parms = new OracleParameter[] 
							{
                                new OracleParameter("v_title", OracleDbType.NVarchar2),
                                new OracleParameter("v_serviceId", OracleDbType.NVarchar2),
                                new OracleParameter("v_content", OracleDbType.NVarchar2),
                                new OracleParameter("v_datesend", 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_datesend;
           
            return DataAccess.getDataFromProcedure(str, "", parms);
        }


        public static DataSet sms_news_update(string v_id, string v_title, string v_serviceId, string v_content, string v_datesend, 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.sms_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.NVarchar2),
                                new OracleParameter("v_datesend", 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_datesend;
            parms[5].Value = v_type;
            return DataAccess.getDataFromProcedure(str, "", parms);
        }


        public static DataSet sms_news_get(string v_serviceId, string v_status, string v_date,string v_id,string top)
        {
            // {"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.sms_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("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;
           

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


    }
}