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); } } }