Truyenthong/SuperAdmin/SuperAdmin/Controllers/AdminController.cs

using ClosedXML.Excel;
using DocumentFormat.OpenXml.Drawing;
using DocumentFormat.OpenXml.Wordprocessing;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Server.IISIntegration;
using Microsoft.Extensions.Configuration;
using Nancy;
using OfficeOpenXml;
using SuperAdmin.Models.Http;
using SuperAdmin.Models.Object;
using SuperAdmin.Source;
using SuperCms.Extensions;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using Timor_BPSuperAdmin.Models.Http;
using static SuperAdmin.Source.CommonUtils;

namespace SuperAdmin.Controllers
{
    public class AdminController : BaseController
    {
        private static readonly log4net.ILog log = log4net.LogManager.GetLogger(typeof(Program));

        public AdminController(IConfiguration _configuration, IWebHostEnvironment hostEnvironment) : base(_configuration, hostEnvironment)
        {
        }

        public IActionResult ReportUssdDetail()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            return View();
        }

        [HttpPost]
        public IActionResult ReportUssdDetailSearch(PushUssdDetailReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            req.rowsOnPage = req.rowsOnPage ?? "100";
            req.seqPage = req.seqPage ?? "1";
            req.order = req.order ?? "desc";
            req.msisdn =  ValidateMsisdn(req.msisdn);
            String url = GetParameter(CommonUtils.WsType.PushUssdDetailGetList);
            PushUssdDetailRes res = PushUssdDetailRes.Parse(SendPost(req, url));
            var fdsds = "dsds";
            return PartialView("../Partial/_ReportUssdDetail", res.list);
        }

        [HttpPost]
        public IActionResult ReportUssdDetailExport(PushUssdDetailReq req)
        {
            if (!CheckAuthToken())
            {
                return null;
            }

            // Áp dụng cùng logic phân trang/thứ tự như ReportUssdDetailSearch để dữ liệu export khớp với search
            req.rowsOnPage = req.rowsOnPage ?? "100";
            req.seqPage = req.seqPage ?? "1";
            req.order = req.order ?? "desc";

            String url = GetParameter(CommonUtils.WsType.PushUssdDetailGetList);
            PushUssdDetailRes res = PushUssdDetailRes.Parse(SendPost(req, url));
            var list = res.list ?? new List<PushUssdDetail>();

            string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            string fileName = "campaign_detail.xlsx";
            try
            {
                using (var workbook = new XLWorkbook())
                {
                    int i = 1;
                    IXLWorksheet worksheet = workbook.Worksheets.Add("Campaign Detail");
                    worksheet.Column(i).Width = 15; worksheet.Cell(1, i++).Value = "No.";
                    worksheet.Column(i).Width = 20; worksheet.Cell(1, i++).Value = "Request ID";
                    worksheet.Column(i).Width = 30; worksheet.Cell(1, i++).Value = "Campaign";
                    worksheet.Column(i).Width = 18; worksheet.Cell(1, i++).Value = "Msisdn";
                    worksheet.Column(i).Width = 22; worksheet.Cell(1, i++).Value = "Send Time";
                    worksheet.Column(i).Width = 12; worksheet.Cell(1, i++).Value = "Send Status";
                    worksheet.Column(i).Width = 10; worksheet.Cell(1, i++).Value = "Total Step";
                    worksheet.Column(i).Width = 10; worksheet.Cell(1, i++).Value = "Is Step 1";
                    worksheet.Column(i).Width = 22; worksheet.Cell(1, i++).Value = "Step 1 Time";
                    worksheet.Column(i).Width = 10; worksheet.Cell(1, i++).Value = "Is Step 2";
                    worksheet.Column(i).Width = 22; worksheet.Cell(1, i++).Value = "Step 2 Time";
                    worksheet.Column(i).Width = 18; worksheet.Cell(1, i++).Value = "Error Code";
                    worksheet.Column(i).Width = 12; worksheet.Cell(1, i++).Value = "Is Success";
                    worksheet.Column(i).Width = 22; worksheet.Cell(1, i++).Value = "Insert Time";
                    worksheet.Column(i).Width = 22; worksheet.Cell(1, i++).Value = "Last Update";
                    worksheet.Column(i).Width = 50; worksheet.Cell(1, i++).Value = "Msg Content";
                    worksheet.Row(1).Style.Font.Bold = true;
                    worksheet.Row(1).Style.Fill.BackgroundColor = XLColor.Yellow;

                    if (list.Count > 0)
                    {
                        for (int index = 1; index <= list.Count; index++)
                        {
                            i = 1;
                            var obj = list[index - 1];
                            worksheet.Cell(index + 1, i++).Value = index;
                            worksheet.Cell(index + 1, i++).Value = obj.requestId ?? "";
                            // Campaign: ID + Name (giống view)
                            string campaignDisplay = obj.campaignId ?? "";
                            if (!string.IsNullOrEmpty(obj.campaignName))
                            {
                                campaignDisplay += " - " + obj.campaignName;
                            }
                            worksheet.Cell(index + 1, i++).Value = campaignDisplay;
                            worksheet.Cell(index + 1, i++).Value = obj.msisdn ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.sendTime ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.sendStatus ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.totalStep ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.isStep1 ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.step1Time ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.isStep2 ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.step2Time ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.errorCode ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.isSuccess ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.insertTime ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.lastUpdate ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.msgContent ?? "";
                        }
                    }
                    using (var stream = new MemoryStream())
                    {
                        workbook.SaveAs(stream);
                        var content = stream.ToArray();
                        return File(content, contentType, fileName);
                    }
                }
            }
            catch (Exception)
            {
                return null;
            }
        }
        public IActionResult Index(String fromDate, String toDate)
        {
            try
            {
                if (!CheckAuthToken())
                {
                    //return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
                    UserRoles vsa = HttpContext.Session.GetComplexData<UserRoles>("userInfo");
                    //var listMenu = new List<String>();
                    if (vsa != null && vsa.function != null)
                    {
                        var listObj = vsa.function;
                        foreach (Function obj in listObj)
                        {
                            return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + obj.link);
                        }
                    }
                    return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
                }
                fromDate = fromDate ?? DateTime.Now.ToString("dd/MM/yyyy 00:00:00");
                toDate = toDate ?? DateTime.Now.ToString("dd/MM/yyyy 23:59:59");

                //DashboardModel model = LoadDashboard(fromDate, toDate);

                // init
                try
                {
                    var listService = HttpContext.Session.GetComplexData<List<Service>>("listService");
                    if (listService == null)
                    {
                        PreLoadService();
                    }
                }
                catch (Exception ex)
                {
                    PreLoadService();
                }

                return View();
            }
            catch (Exception ex)
            {
                log.Error("Error admin index: " + ex.Message, ex);
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
        }

        public IActionResult Dashboard(String fromDate, String toDate)
        {

            DashboardModel model = LoadDashboard(fromDate, toDate);
            var listService = HttpContext.Session.GetComplexData<List<Service>>("listService");
            if (listService == null)
            {
                PreLoadService();
            }
            //
            return PartialView("../Partial/_Dashboard", model);
        }

        private DashboardModel LoadDashboard(String fromDate, String toDate)
        {
            string serviceName = GetParameter(UtilsController.Constant.SERVICE_NAME);
            string subDomain = GetParameter(UtilsController.Constant.SUB_DOMAIN);

            HttpContext.Session.SetComplexData("serviceName", serviceName);
            HttpContext.Session.SetComplexData("subDomain", subDomain);

            //String fromDate = DateTime.Now.AddDays(-30).ToString("dd/MM/yyyy");
            //String toDate = DateTime.Now.ToString("dd/MM/yyyy");
            //
            DashboardModel model = new DashboardModel();
            string url = GetParameter(CommonUtils.WsType.CamGetList);
            CampaignGetListReq req = new CampaignGetListReq();
            req.fromDate = fromDate;
            req.toDate = toDate;
            req.rowsOnPage = "1000000";
            req.seqPage = "1";
            // running
            req.status = CampaignStatus.Running;
            CampaignGetListRes running = CampaignGetListRes.Parse(SendPost(req, url));
            model.listRunning = running.list;

            // pending
            req.status = CampaignStatus.Pending + "," + CampaignStatus.Paused;
            CampaignGetListRes pending = CampaignGetListRes.Parse(SendPost(req, url));
            model.listPending = pending.list;

            return model;
        }

        // CAMPAIGN
        [HttpPost]
        public JsonResult UpdateCampaignStatus(String id, String status)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // get campaign by id
            string url = GetParameter(CommonUtils.WsType.CamGetList);
            CampaignGetListReq req = new CampaignGetListReq();
            req.id = id;
            CampaignGetListRes cpRes = CampaignGetListRes.Parse(SendPost(req, url));
            var cmp = cpRes.list[0];

            // update status
            ChangeStatusReq updateReq = new ChangeStatusReq();
            updateReq.id = id;
            updateReq.status = status;
            updateReq.users = account;
            string result = SendPost(updateReq, GetParameter(CommonUtils.WsType.changeStatus));
            CommonRes res = CommonRes.Parse(result);
            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });
        }

        public IActionResult CampaignManagement()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            CriteriaSearchReq req = new CriteriaSearchReq();
            req.rowsOnPage = "1000000";
            req.seqPage = "1";
            req.order = "asc";
            req.isActive = "1";
            // load criteria
            CriteriaGetListRes res1 = CriteriaGetListRes.Parse(SendPost(req, GetParameter(CommonUtils.WsType.balanceGetList)));
            HttpContext.Session.SetComplexData("listBalance", res1.list);
            CriteriaGetListRes res2 = CriteriaGetListRes.Parse(SendPost(req, GetParameter(CommonUtils.WsType.expGetList)));
            HttpContext.Session.SetComplexData("listExpire", res2.list);
            CriteriaGetListRes res3 = CriteriaGetListRes.Parse(SendPost(req, GetParameter(CommonUtils.WsType.shortCodeGetList)));
            HttpContext.Session.SetComplexData("listShortCode", res3.list);
            // load whitelist sub active
            GetListSubReq req2 = new GetListSubReq();
            req2.rowsOnPage = "1000000";
            req2.seqPage = "1";
            req2.order = "asc";
            req2.subType = CommonUtils.ListSubType.Whitelist;
            GetListSubRes res4 = GetListSubRes.Parse(SendPost(req, GetParameter(CommonUtils.WsType.listSubGetList)));
            HttpContext.Session.SetComplexData("listSubFile", res4.list);
            PreLoadService();
            return View();
        }

        public IActionResult CampaignSearch(CampaignGetListReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            //string account = HttpContext.Session.GetString("account");
            //req.usersName = account;
            req.rowsOnPage = "1000000";
            req.seqPage = "1";
            req.order = "desc";
            //req.type = "1"; // already result

            String url = GetParameter(CommonUtils.WsType.CamGetList);
            CampaignGetListRes res = CampaignGetListRes.Parse(SendPost(req, url));
            //HttpContext.Session.SetComplexData("ExportGetListRes", res);
            //return Json(new
            //{
            //    error = res.responseCode,
            //    content = res.responseMessage,
            //    data = res.list
            //});
            return PartialView("../Partial/_ListCampaign", res.list);
        }

        [HttpPost]
        public IActionResult CampaignExport(CampaignGetListReq req)
        {
            if (!CheckAuthToken())
            {
                return null;
            }


            String url = GetParameter(CommonUtils.WsType.CamGetList);
            CampaignGetListRes res = CampaignGetListRes.Parse(SendPost(req, url));
            var list = res.list;

            string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            string fileName = "campaigns.xlsx";
            try
            {
                using (var workbook = new XLWorkbook())
                {
                    int i = 1;
                    IXLWorksheet worksheet = workbook.Worksheets.Add("Campaigns");
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "No.";
                    worksheet.Column(i).Width = 30;
                    worksheet.Cell(1, i++).Value = "Name";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "From date";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "To Date";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Type";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Service Type";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Services in Campaign";
                    worksheet.Column(i).Width = 10;
                    worksheet.Cell(1, i++).Value = "Priority";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Modify Date";
                    worksheet.Column(i).Width = 10;
                    worksheet.Cell(1, i++).Value = "Status";
                    // make color
                    worksheet.Row(1).Style.Font.Bold = true;
                    worksheet.Row(1).Style.Fill.BackgroundColor = XLColor.Yellow;
                    //worksheet.Cell(1, i++).Value = "BetId";
                    if (list != null && list.Count > 0)
                    {
                        for (int index = 1; index <= list.Count; index++)
                        {
                            i = 1;
                            var obj = list[index - 1];
                            worksheet.Cell(index + 1, i++).Value = index;
                            worksheet.Cell(index + 1, i++).Value = obj.name;
                            worksheet.Cell(index + 1, i++).SetValue(obj.fromDate);
                            worksheet.Cell(index + 1, i++).SetValue(obj.toDate);
                            worksheet.Cell(index + 1, i++).Value = obj.isDefault == "1" ? "Default" : "Normal";
                            worksheet.Cell(index + 1, i++).Value = (int.Parse(obj.addType) - 1) + "-Verification";
                            string services = "";
                            if (obj.listServiceMapCam != null)
                            {
                                foreach (var sv in obj.listServiceMapCam)
                                {
                                    services += @sv.serviceObj.name + "; ";
                                }
                                if (services.Length > 2)
                                {
                                    services = services.Substring(0, services.Length - 2);
                                }
                            }
                            worksheet.Cell(index + 1, i++).Value = services;
                            worksheet.Cell(index + 1, i++).Value = obj.priority;
                            worksheet.Cell(index + 1, i++).SetValue(obj.dateUpdate);
                            worksheet.Cell(index + 1, i++).Value = CommonUtils.StatusToStr(obj.status);
                        }
                    }
                    using (var stream = new MemoryStream())
                    {
                        workbook.SaveAs(stream);
                        var content = stream.ToArray();
                        return File(content, contentType, fileName);
                    }
                }
            }
            catch (Exception ex)
            {
                return null;
            }
        }

        [HttpPost]
        public JsonResult CampaignClone(CampaignCopyReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");
            request.users = account;
            // send change status
            string url = GetParameter(CommonUtils.WsType.camCopy);
            var res = CommonRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });
        }

        [HttpPost]
        public IActionResult CampaignLoadInfo(CampaignGetListReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // check update or add
            string url = GetParameter(CommonUtils.WsType.CamGetList);
            var res = CampaignGetListRes.Parse(SendPost(request, url));
            if (res.responseCode == "0")
            {
                return PartialView("../Partial/_Campaign", res.list[0]);
            }
            else
            {
                return Json(new
                {
                    error = res.responseCode,
                    content = res.responseMessage
                });
            }

        }

        [HttpPost]
        public JsonResult CampaignAddUpdate(CampaignAddUpdateObj campAddUpdateObj)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");
            string errorContent = "";

            // check update or add
            string url = "";
            if (campAddUpdateObj.campReq.id == null || campAddUpdateObj.campReq.id == "")
            {
                url = GetParameter(CommonUtils.WsType.CamInsert);
            }
            else
            {
                url = GetParameter(CommonUtils.WsType.CamUpdate);
            }
            campAddUpdateObj.campReq.users = account;
            campAddUpdateObj.campReq.type = "0";
            //campAddUpdateObj.campReq.status = CampaignStatus.draft;
            var res = CampaignInsertRes.Parse(SendPost(campAddUpdateObj.campReq, url));
            if (res.responseCode == "0")
            {
                // create campaign success -> add service to campaign
                string campId = campAddUpdateObj.campReq.id;
                if (campId == null || campId == "")
                {
                    campId = res.id;
                }

                // get info to remove
                if (campAddUpdateObj.campReq.id != null && campAddUpdateObj.campReq.id != "")
                {
                    // remove service
                    url = GetParameter(CommonUtils.WsType.CamGetList);
                    CampaignGetListReq getCamReq = new CampaignGetListReq();
                    getCamReq.id = campAddUpdateObj.campReq.id;
                    var camInfo = CampaignGetListRes.Parse(SendPost(getCamReq, url)).list[0];
                    if (camInfo.listServiceMapCam != null)
                    {
                        url = GetParameter(CommonUtils.WsType.CamSvRemove);
                        CamServiceAddReq svRemoveReq = new CamServiceAddReq();
                        svRemoveReq.type = "1";
                        foreach (var oldSv in camInfo.listServiceMapCam)
                        {
                            svRemoveReq.id = oldSv.id;
                            SendPost(svRemoveReq, url);
                        }
                    }

                    // remove criteria
                    CriteriaMapCamReq criRemoveReq = new CriteriaMapCamReq();
                    criRemoveReq.type = "1";

                    url = GetParameter(CommonUtils.WsType.camBalanceUpdate);
                    foreach (var oldSv in camInfo.listBalanceMapCam)
                    {
                        criRemoveReq.id = oldSv.id;
                        SendPost(criRemoveReq, url);
                    }


                    url = GetParameter(CommonUtils.WsType.camSubUpdate);
                    foreach (var oldSv in camInfo.listSubMapCam)
                    {
                        criRemoveReq.id = oldSv.id;
                        SendPost(criRemoveReq, url);
                    }


                    url = GetParameter(CommonUtils.WsType.camExpireUpdate);
                    foreach (var oldSv in camInfo.listExpireMapCam)
                    {
                        criRemoveReq.id = oldSv.id;
                        SendPost(criRemoveReq, url);
                    }


                    url = GetParameter(CommonUtils.WsType.camShortCodeUpdate);
                    foreach (var oldSv in camInfo.listShortCodeMapCam)
                    {
                        criRemoveReq.id = oldSv.id;
                        SendPost(criRemoveReq, url);
                    }
                }
                // remove old services
                //CampaignServiceListReq listSvReq = new CampaignServiceListReq();
                //listSvReq.campaignId = campId;
                //listSvReq.rowsOnPage = "1000000";
                //listSvReq.seqPage = "1";
                //url = GetParameter(CommonUtils.WsType.CamSvGetList);
                //var listSvRes = CampaignServiceListRes.Parse(SendPost(listSvReq, url));
                //if (listSvRes.list != null)
                //{
                //    url = GetParameter(CommonUtils.WsType.CamSvRemove);
                //    CamServiceAddReq svRemoveReq = new CamServiceAddReq();
                //    svRemoveReq.type = "1";
                //    foreach (var oldSv in listSvRes.list)
                //    {
                //        svRemoveReq.id = oldSv.id;
                //        SendPost(svRemoveReq, url);
                //    }
                //}

                // add new services
                if (campAddUpdateObj.listCampSv != null)
                {
                    url = GetParameter(CommonUtils.WsType.CamAddInsert);
                    foreach (var campSv in campAddUpdateObj.listCampSv)
                    {
                        campSv.users = account;
                        campSv.campaignId = campId;
                        var resAdd = CommonRes.Parse(SendPost(campSv, url));
                        if (resAdd.responseCode != "0")
                        {
                            errorContent += "<br />" + "Error add service " + campSv.note + ": " + resAdd.responseMessage;
                        }
                    }
                }

                // add balances
                if (campAddUpdateObj.balances != null)
                {
                    url = GetParameter(CommonUtils.WsType.camBalanceInsert);
                    foreach (var campCri in campAddUpdateObj.balances)
                    {
                        campCri.users = account;
                        campCri.campaignId = campId;
                        var resAdd = CommonRes.Parse(SendPost(campCri, url));
                        if (resAdd.responseCode != "0")
                        {
                            errorContent += "<br />" + "Error add criteria " + campCri.note + ": " + resAdd.responseMessage;
                        }
                    }
                }

                // add expires
                if (campAddUpdateObj.expires != null)
                {
                    url = GetParameter(CommonUtils.WsType.camExpireInsert);
                    foreach (var campCri in campAddUpdateObj.expires)
                    {
                        campCri.users = account;
                        campCri.campaignId = campId;
                        var resAdd = CommonRes.Parse(SendPost(campCri, url));
                        if (resAdd.responseCode != "0")
                        {
                            errorContent += "<br />" + "Error add criteria " + campCri.note + ": " + resAdd.responseMessage;
                        }
                    }
                }

                // add shortcode
                url = GetParameter(CommonUtils.WsType.camShortCodeInsert);
                CriteriaMapCamReq camShortCode = new CriteriaMapCamReq();
                camShortCode.users = account;
                camShortCode.campaignId = campId;
                camShortCode.shortCodeId = campAddUpdateObj.shortCodeId;
                var resAdd2 = CommonRes.Parse(SendPost(camShortCode, url));
                if (resAdd2.responseCode != "0")
                {
                    errorContent += "<br />" + "Error add shortcode " + camShortCode.note + ": " + resAdd2.responseMessage;
                }

                // add list sub
                if (campAddUpdateObj.listSubs != null)
                {
                    url = GetParameter(CommonUtils.WsType.camSubInsert);
                    foreach (var campCri in campAddUpdateObj.listSubs)
                    {
                        campCri.users = account;
                        campCri.campaignId = campId;
                        var resAdd = CommonRes.Parse(SendPost(campCri, url));
                        if (resAdd.responseCode != "0")
                        {
                            errorContent += "<br />" + "Error add sub " + campCri.note + ": " + resAdd.responseMessage;
                        }
                    }
                }

                // check result
                if (errorContent != "")
                {
                    return Json(new
                    {
                        error = res.responseCode,
                        warning = "1",
                        campId = campId,
                        content = "Create campaign success with warning:" + errorContent
                    });

                }
                else
                {
                    return Json(new
                    {
                        error = res.responseCode,
                        content = res.responseMessage
                    });
                }
            }
            else
            {
                return Json(new
                {
                    error = res.responseCode,
                    content = res.responseMessage
                });
            }
        }

        // ApiWebserviceManagement
        public IActionResult ApiWebserviceManagement()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            return View();
        }

        [HttpPost]
        public IActionResult GetApiServices()
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            var req = new ApiServiceReq
            {
                rowsOnPage = "1000000",
                seqPage = "1",
                order = "desc"
            };

            string url = GetParameter(CommonUtils.WsType.ApiServiceLoad);
            ApiServiceRes res = ApiServiceRes.Parse(SendPost(req, url));

            if (res == null || res.list == null)
            {
                return Json(new
                {
                    error = "1",
                    content = "No data found"
                });
            }

            return Json(new
            {
                error = 0,
                data = res.list
            });
        }


        public IActionResult ApiServiceSearch(ApiServiceReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            req.rowsOnPage = "1000000";
            req.seqPage = "1";
            req.order = "desc";


            String url = GetParameter(CommonUtils.WsType.ApiServiceLoad);
            ApiServiceRes res = ApiServiceRes.Parse(SendPost(req, url));
            HttpContext.Session.SetComplexData("apiServiceData", res.list);

            return PartialView("../Partial/_ApiWebserviceManagement", res.list);
        }

        [HttpPost]
        public IActionResult ApiServiceExport(ApiServiceReq req)
        {
            if (!CheckAuthToken())
            {
                return null;
            }


            // Ensure same paging/order behavior as search
            req.rowsOnPage = "1000000";
            req.seqPage = "1";
            req.order = "desc";

            string url = GetParameter(CommonUtils.WsType.ApiServiceLoad);
            ApiServiceRes res = ApiServiceRes.Parse(SendPost(req, url));
            var list = res.list ?? new List<ApiService>();

            string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            string fileName = "api_services.xlsx";
            try
            {
                using (var workbook = new XLWorkbook())
                {
                    int i = 1;
                    IXLWorksheet worksheet = workbook.Worksheets.Add("API Services");
                    worksheet.Column(i).Width = 10; worksheet.Cell(1, i++).Value = "No.";
                    worksheet.Column(i).Width = 10; worksheet.Cell(1, i++).Value = "ID";
                    worksheet.Column(i).Width = 30; worksheet.Cell(1, i++).Value = "ws_name";
                    worksheet.Column(i).Width = 20; worksheet.Cell(1, i++).Value = "ws_code";
                    worksheet.Column(i).Width = 50; worksheet.Cell(1, i++).Value = "wsdl";
                    worksheet.Column(i).Width = 40; worksheet.Cell(1, i++).Value = "msg_template";
                    worksheet.Column(i).Width = 20; worksheet.Cell(1, i++).Value = "error_tag";
                    worksheet.Column(i).Width = 20; worksheet.Cell(1, i++).Value = "success_code";
                    worksheet.Column(i).Width = 12; worksheet.Cell(1, i++).Value = "Status";

                    worksheet.Row(1).Style.Font.Bold = true;
                    worksheet.Row(1).Style.Fill.BackgroundColor = XLColor.Yellow;

                    if (list.Count > 0)
                    {
                        for (int index = 1; index <= list.Count; index++)
                        {
                            i = 1;
                            var obj = list[index - 1];
                            worksheet.Cell(index + 1, i++).Value = index;
                            worksheet.Cell(index + 1, i++).Value = obj.ws_id;
                            worksheet.Cell(index + 1, i++).Value = obj.ws_name;
                            worksheet.Cell(index + 1, i++).Value = obj.ws_code;
                            worksheet.Cell(index + 1, i++).Value = obj.wsdl;
                            worksheet.Cell(index + 1, i++).Value = obj.msg_template;
                            worksheet.Cell(index + 1, i++).Value = obj.error_tag;
                            worksheet.Cell(index + 1, i++).Value = obj.success_code;
                            worksheet.Cell(index + 1, i++).Value = obj.isActive == "1" ? "Active" : "Inactive";
                        }
                    }

                    using (var stream = new MemoryStream())
                    {
                        workbook.SaveAs(stream);
                        var content = stream.ToArray();
                        return File(content, contentType, fileName);
                    }
                }
            }
            catch (Exception)
            {
                return null;
            }
        }


        [HttpPost]
        public JsonResult ApiServiceLoadInfo(ApiServiceReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // check update or add
            string url = GetParameter(CommonUtils.WsType.ApiServiceLoad);
            var res = ApiServiceRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage,
                data = res.list[0]
            });

        }

        [HttpPost]
        public JsonResult ApiServiceAddUpdate(ApiServiceUpdateReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // check update or add
            string url = "";
            if (request.id != null)
            {
                url = GetParameter(CommonUtils.WsType.ApiServiceUpdate);

            }
            else
            {
                // add
                url = GetParameter(CommonUtils.WsType.ApiServiceInsert);
            }
            request.users = account;
            var res = ApiServiceUpdateRes.Parse(SendPost(request, url));

            // reload
            PreLoadService();

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });

        }








        // SERVICE
        public IActionResult ServiceManagement()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            return View();
        }

        public IActionResult ServiceSearch(ServiceGetListReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            req.rowsOnPage = "1000000";
            req.seqPage = "1";
            req.order = "desc";


            String url = GetParameter(CommonUtils.WsType.SvGetList);
            ServiceGetListRes res = ServiceGetListRes.Parse(SendPost(req, url));
            HttpContext.Session.SetComplexData("listService", res.list);
            return PartialView("../Partial/_Services", res.list);
        }

        [HttpPost]
        public JsonResult ServiceLoadInfo(ServiceGetListReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // check update or add
            string url = GetParameter(CommonUtils.WsType.SvGetList);
            var res = ServiceGetListRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage,
                data = res.list[0]
            });

        }

        [HttpPost]
        public JsonResult ServiceAddUpdate(ServiceUpdateReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // check update or add
            string url = "";
            if (request.id != null)
            {
                url = GetParameter(CommonUtils.WsType.SvUpdate);

            }
            else
            {
                // add
                url = GetParameter(CommonUtils.WsType.SvInsert);
            }
            request.users = account;
            var res = ServiceUpdateRes.Parse(SendPost(request, url));

            // reload
            PreLoadService();

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });

        }


        // SERVICE
        public IActionResult CampaignScheduler()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            return View();
        }

        public IActionResult SchedulerSearch(CalendarGetListReq req, string viewType = "calendar")
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }


            String url = GetParameter(CommonUtils.WsType.CalendarGetList);
            CalendarGetListRes res = CalendarGetListRes.Parse(SendPost(req, url));

            string viewName = viewType == "table" ? "../Partial/_CampaignSchedulerTable" : "../Partial/_CampaignSchedulerCalendar";
            return PartialView(viewName, res.list);
        }

        [HttpPost]
        public IActionResult SchedulerExport(CalendarGetListReq req)
        {
            if (!CheckAuthToken())
            {
                return null;
            }

            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

            String url = GetParameter(CommonUtils.WsType.CalendarGetList);
            CalendarGetListRes res = CalendarGetListRes.Parse(SendPost(req, url));
            var list = res.list;

            string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            string fileName = "calendar.xlsx";
            try
            {
                using (var workbook = new XLWorkbook())
                {
                    int i = 1;
                    IXLWorksheet worksheet = workbook.Worksheets.Add("Scheduler");
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "No.";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Date";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "ID";
                    worksheet.Column(i).Width = 30;
                    worksheet.Cell(1, i++).Value = "Campaign Name";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Campaign Type";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Start Date";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "End Date";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Services";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Status";
                    // make color
                    worksheet.Row(1).Style.Font.Bold = true;
                    worksheet.Row(1).Style.Fill.BackgroundColor = XLColor.Yellow;
                    //worksheet.Cell(1, i++).Value = "BetId";
                    if (list != null && list.Count > 0)
                    {
                        int rownum = 1;
                        for (int index = 1; index <= list.Count; index++)
                        {
                            
                            var calendar = list[index - 1];
                            if (calendar.list == null || calendar.list.Count == 0)
                            {
                                i = 1;
                                rownum++;
                                worksheet.Cell(rownum, i++).Value = rownum-1;
                                worksheet.Cell(rownum, i++).SetValue(calendar.date);
                            }
                            else
                            {
                                for (int j = 0; j < calendar.list.Count; j++)
                                {
                                    i = 1;
                                    rownum++;
                                    var obj = calendar.list[j];
                                    worksheet.Cell(rownum, i++).Value = rownum-1;
                                    if (j == 0)
                                    {
                                        // merge cell
                                        worksheet.Range($"B{rownum}:B{rownum + calendar.list.Count - 1}").Merge();
                                        worksheet.Cell(rownum, i).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center;
                                        worksheet.Cell(rownum, i++).SetValue(calendar.date);
                                    } else
                                    {
                                        i++;
                                    }

                                    worksheet.Cell(rownum, i++).Value = obj.id;
                                    worksheet.Cell(rownum, i++).Value = obj.name;
                                    worksheet.Cell(rownum, i++).Value = obj.isDefault == "1" ? "Default" : "Normal";
                                    worksheet.Cell(rownum, i++).SetValue(obj.fromDate);
                                    worksheet.Cell(rownum, i++).SetValue(obj.toDate);
                                    string services = "";
                                    if (obj.listServiceMapCam != null)
                                    {
                                        foreach (var sv in obj.listServiceMapCam)
                                        {
                                            services += @sv.serviceObj.name + "; ";
                                        }
                                        if (services.Length > 2)
                                        {
                                            services = services.Substring(0, services.Length - 2);
                                        }
                                    }
                                    worksheet.Cell(rownum, i++).Value = services;
                                    worksheet.Cell(rownum, i++).Value = CommonUtils.StatusToStr(obj.status);
                                }
                            }
                        }
                    }
                    using (var stream = new MemoryStream())
                    {
                        workbook.SaveAs(stream);
                        var content = stream.ToArray();
                        return File(content, contentType, fileName);
                    }
                }
            }
            catch (Exception ex)
            {
                return null;
            }
        }

        // COMMON
        [HttpPost]
        public JsonResult ChangeStatus(ChangeStatusReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");
            request.users = account;
            // send change status
            string url = GetParameter(CommonUtils.WsType.changeStatus);
            var res = CommonRes.Parse(SendPost(request, url));

            // reload
            if (request.type == CommonUtils.ActionType.Service)
            {
                PreLoadService();
            }

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });
        }

        [HttpPost]
        public IActionResult ServiceExport(ServiceGetListReq req)
        {
            if (!CheckAuthToken())
            {
                return null;
            }

            try
            {
                // Initialize req if null
                if (req == null)
                {
                    req = new ServiceGetListReq();
                }

                // Set pagination to get all records, same as ServiceSearch
                req.rowsOnPage = "1000000";
                req.seqPage = "1";
                req.order = "desc";

                String url = GetParameter(CommonUtils.WsType.SvGetList);
                ServiceGetListRes res = ServiceGetListRes.Parse(SendPost(req, url));
                var list = res.list ?? new List<Service>();

                string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                string fileName = "services.xlsx";
                
                using (var workbook = new XLWorkbook())
                {
                    int i = 1;
                    IXLWorksheet worksheet = workbook.Worksheets.Add("Services");
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "No.";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Name";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Short code";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Command";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Description";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Created date";
                    worksheet.Column(i).Width = 50;
                    worksheet.Cell(1, i++).Value = "Message USSD return success";
                    worksheet.Column(i).Width = 50;
                    worksheet.Cell(1, i++).Value = "Message USSD return failed";
                    // make color
                    worksheet.Row(1).Style.Font.Bold = true;
                    worksheet.Row(1).Style.Fill.BackgroundColor = XLColor.Yellow;
                    //worksheet.Cell(1, i++).Value = "BetId";
                    if (list != null && list.Count > 0)
                    {
                        for (int index = 1; index <= list.Count; index++)
                        {
                            i = 1;
                            var obj = list[index - 1];
                            worksheet.Cell(index + 1, i++).Value = index;
                            worksheet.Cell(index + 1, i++).Value = obj.name ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.shortCode ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.command ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.description ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.dateCreated ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.msgRegisterSuccess ?? "";
                            worksheet.Cell(index + 1, i++).Value = obj.msgRegisterFlase ?? "";
                        }
                    }
                    using (var stream = new MemoryStream())
                    {
                        workbook.SaveAs(stream);
                        var content = stream.ToArray();
                        return File(content, contentType, fileName);
                    }
                }
            }
            catch (Exception ex)
            {
                log.Error("Error in ServiceExport: " + ex.Message, ex);
                return null;
            }
        }

        [HttpPost]
        public IActionResult CampaignService(CampaignServiceListReq req)
        {
            if (!CheckAuthToken())
            {
                return PartialView("../Partial/_CampaignService", null);
            }

            if (req.rowsOnPage == null)
            {
                req.rowsOnPage = "1000000";
                req.seqPage = "1";
                req.order = "asc";

                String url = GetParameter(CommonUtils.WsType.CamSvGetList);
                CampaignServiceListRes res = CampaignServiceListRes.Parse(SendPost(req, url));
                return PartialView("../Partial/_CampaignService", res.list);
            }
            else
            {
                ViewBag.nextIndex = req.rowsOnPage;
                return PartialView("../Partial/_CampaignService", null);
            }
        }
        [HttpPost]
        public IActionResult SvGroup(ServiceGroupReq req)
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }

            string url = GetParameter(CommonUtils.WsType.SvGroupGetList);
            ServiceGroupRes res = ServiceGroupRes.Parse(SendPost(req, url));
            HttpContext.Session.SetComplexData("serviceGroupData", res.list);

            return Json(new { success = true }); 
        }


        [HttpPost]
        public IActionResult SvGroupLoad(ServiceGroupReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            string url = GetParameter(CommonUtils.WsType.SvGroupGetList);
            ServiceGroupRes res = ServiceGroupRes.Parse(SendPost(req, url));

            if (res == null || res.list == null)
            {
                return Json(new
                {
                    error = "1",
                    content = "No data found"
                });
            }

            return Json(new
            {
                error = 0,
                data = res.list
            });
        }



        // ReportCampaign
        public IActionResult ReportCampaign()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            return View();
        }

        [HttpPost]
        public IActionResult ReportCampaignSearch(RpByCampaignReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }


            string url = GetParameter(CommonUtils.WsType.ReportByCampaign);
            string result = SendPost(req, url);
            RpByCampaignRes res = RpByCampaignRes.Parse(result);
            return PartialView("../Partial/_ReportCampaign", res.list);
        }

        [HttpPost]
        public IActionResult ReportCampaignExport(RpByCampaignReq req)
        {
            if (!CheckAuthToken())
            {
                return null;
            }

            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

            string url = GetParameter(CommonUtils.WsType.ReportByCampaign);
            string result = SendPost(req, url);
            RpByCampaignRes res = RpByCampaignRes.Parse(result);
            List<RpByCampaign> list = res.list;

            string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            string fileName = "report_campaign.xlsx";
            try
            {
                using (var workbook = new XLWorkbook())
                {
                    int i = 1;
                    IXLWorksheet worksheet = workbook.Worksheets.Add("Report Campaign");
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "No.";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "ID";
                    worksheet.Column(i).Width = 30;
                    worksheet.Cell(1, i++).Value = "Name";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Priority";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Campaign Type";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Service Type";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Service Name";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Total Send 1";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Total press 1 of send 1";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Total Send 2";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Total press 1 of send 2";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Total Success";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Total Failed";
                    // make color
                    worksheet.Row(1).Style.Font.Bold = true;
                    worksheet.Row(1).Style.Fill.BackgroundColor = XLColor.Yellow;
                    //worksheet.Cell(1, i++).Value = "BetId";
                    if (list != null && list.Count > 0)
                    {
                        for (int index = 1; index <= list.Count; index++)
                        {
                            i = 1;
                            var obj = list[index - 1];
                            worksheet.Cell(index + 1, i++).Value = index;
                            worksheet.Cell(index + 1, i++).Value = obj.campaignId;
                            worksheet.Cell(index + 1, i++).Value = obj.campaignName;
                            worksheet.Cell(index + 1, i++).Value = obj.priority;
                            worksheet.Cell(index + 1, i++).Value = obj.campaignType == "1" ? "Default" : "Normal";
                            worksheet.Cell(index + 1, i++).Value = (int.Parse(obj.serviceType) - 1) + "-Verification";
                            worksheet.Cell(index + 1, i++).Value = obj.serviceName;
                            worksheet.Cell(index + 1, i++).Value = obj.totalView1;
                            worksheet.Cell(index + 1, i++).Value = obj.activation1;
                            worksheet.Cell(index + 1, i++).Value = obj.totalView2;
                            worksheet.Cell(index + 1, i++).Value = obj.activation2;
                            worksheet.Cell(index + 1, i++).Value = obj.success;
                            worksheet.Cell(index + 1, i++).Value = obj.fail;
                        }
                    }
                    using (var stream = new MemoryStream())
                    {
                        workbook.SaveAs(stream);
                        var content = stream.ToArray();
                        return File(content, contentType, fileName);
                    }
                }
            }
            catch (Exception ex)
            {
                return null;
            }
        }

        private String formatStatus(String status)
        {
            if (status == "0")
            {
                return "Processing";
            }
            else if (status == "1")
            {
                return "Success";
            }
            else if (status == "2")
            {
                return "Pending";
            }
            else if (status == "3")
            {
                return "Revert";
            }
            return status;
        }

        private void PreLoadService()
        {
            try
            {
                ServiceGetListReq req = new ServiceGetListReq();
                req.isActive = "1";
                req.rowsOnPage = "20000";
                req.seqPage = "1";
                String url = GetParameter(CommonUtils.WsType.SvGetList);
                ServiceGetListRes res = ServiceGetListRes.Parse(SendPost(req, url));
                HttpContext.Session.SetComplexData("listService", res.list);
            }
            catch (Exception ex)
            {
                log.Error("Error load service: ", ex);
            }
        }


        // List import
        public IActionResult ListMsisdn()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            CampaignGetListReq req = new CampaignGetListReq();
            req.rowsOnPage = "1000000";
            req.seqPage = "1";
            req.order = "desc";

            String url = GetParameter(CommonUtils.WsType.CamGetList);
            CampaignGetListRes res = CampaignGetListRes.Parse(SendPost(req, url));
            HttpContext.Session.SetComplexData("listCampaign", res.list);

            return View();
        }

        public IActionResult ListMsisdnSearch(ListMsisdnGetReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            //string account = HttpContext.Session.GetString("account");
            //req.users = account;
            req.msisdn = BaseController.ValidateMsisdn(req.msisdn);
            string url = GetParameter(CommonUtils.WsType.MsisdnSearch);
            string result = SendPost(req, url);
            ListMsisdnGetRes res = ListMsisdnGetRes.Parse(result);
            return PartialView("../Partial/_ListMsisdn", res);
            //return Json(new
            //{
            //    error = res.responseCode,
            //    content = res.responseMessage,
            //    data = res.list
            //});
        }

        [HttpPost]
        public IActionResult ListMsisdnExport(ListMsisdnGetReq req)
        {
            if (!CheckAuthToken())
            {
                return null;
            }

            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

            string url = GetParameter(CommonUtils.WsType.MsisdnSearch);
            string result = SendPost(req, url);
            ListMsisdnGetRes res = ListMsisdnGetRes.Parse(result);
            List<MsisdnList> list = res.list;

            string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            string fileName = "player_list.xlsx";
            try
            {
                using (var workbook = new XLWorkbook())
                {
                    int i = 1;
                    IXLWorksheet worksheet = workbook.Worksheets.Add("Player List");
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "No.";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Phone number";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Type";
                    worksheet.Column(i).Width = 25;
                    worksheet.Cell(1, i++).Value = "Campaign";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Import date";
                    // make color
                    worksheet.Row(1).Style.Font.Bold = true;
                    worksheet.Row(1).Style.Fill.BackgroundColor = XLColor.Yellow;
                    //worksheet.Cell(1, i++).Value = "BetId";
                    if (list != null && list.Count > 0)
                    {
                        for (int index = 1; index <= list.Count; index++)
                        {
                            i = 1;
                            var obj = list[index - 1];
                            worksheet.Cell(index + 1, i++).Value = index;
                            worksheet.Cell(index + 1, i++).Value = obj.msisdn;
                            worksheet.Cell(index + 1, i++).Value = obj.type == "2" ? "Blacklist" : "Whitelist";
                            worksheet.Cell(index + 1, i++).Value = obj.campaignId == "-1" ? "All" : (obj.campaignId + " - " + obj.campaignName);
                            worksheet.Cell(index + 1, i++).Value = obj.sysdate;
                        }
                    }
                    using (var stream = new MemoryStream())
                    {
                        workbook.SaveAs(stream);
                        var content = stream.ToArray();
                        return File(content, contentType, fileName);
                    }
                }
            }
            catch (Exception ex)
            {
                return null;
            }
        }


        [HttpPost]
        public JsonResult ListMsisdnRemove(ImportMsisdn request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // check update or add
            string url = GetParameter(CommonUtils.WsType.MsisdnAddUpdate);
            request.users = account;
            var res = ServiceUpdateRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });

        }

        [HttpPost]
        public IActionResult ListMsisdnImport(ImportMsisdn req, IFormFile file_upload)
        {
            if (!CheckAuthToken())
            {
                return null;
            }

            //ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

            try
            {
                if (file_upload != null && (file_upload.FileName.EndsWith(".txt") || file_upload.FileName.EndsWith(".csv")))
                {
                    String fileUpload = UploadedFile(file_upload, "import_msisdn");
                    if (fileUpload != "")
                    {
                        // import data
                        return importMsisdn(req, fileUpload);
                    }
                    else
                    {
                        return Json(new
                        {
                            error_code = UtilsController.Constant.FAILURE,
                            error_content = "Invalid file",
                        });
                    }
                }
                else
                {
                    return Json(new
                    {
                        error_code = UtilsController.Constant.FAILURE,
                        error_content = "Import file invalid",
                    });
                }
            }
            catch (Exception ex)
            {
                return Json(new
                {
                    error_code = UtilsController.Constant.FAILURE,
                    error_content = "System failed!",
                });
            }
        }

        private JsonResult importMsisdn(ImportMsisdn req, String importFile)
        {
            using (StreamReader f = new StreamReader(importFile))
            {
                string account = HttpContext.Session.GetString("account");
                req.users = account;
                //
                List<Datum> listMsisdn = new List<Datum>();
                int ct = 0;
                string ln;
                while ((ln = f.ReadLine()) != null)
                {
                    ct++;
                    listMsisdn.Add(new Datum(ValidateMsisdn(ln.Trim()), "1"));
                }
                f.Close();
                req.data = listMsisdn;

                // send request
                string url = GetParameter(CommonUtils.WsType.MsisdnAddUpdate);
                string result = SendPost(req, url);
                CommonRes res = CommonRes.Parse(result);

                //
                listMsisdn.Clear();

                return Json(new
                {
                    error = res.responseCode,
                    content = res.responseMessage
                });
            }
        }

        // PARAM
        public IActionResult ParamManagement()
        {
            return View();
        }

        public IActionResult ParamSearch(ParamGetListReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            String url = GetParameter(CommonUtils.WsType.ParamGetList);
            ParamGetListRes res = ParamGetListRes.Parse(SendPost(req, url));


            return PartialView("../Partial/_Params", res.list);
        }

        [HttpPost]
        public JsonResult ParamLoadInfo(ParamGetListReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // check update or add
            string url = GetParameter(CommonUtils.WsType.ParamGetList);
            var res = ParamGetListRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage,
                data = res.list[0]
            });

        }

        [HttpPost]
        public JsonResult ParamAddUpdate(String id, String value, String note)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // get param by id
            string url = GetParameter(CommonUtils.WsType.ParamGetList);
            ParamGetListReq req = new ParamGetListReq();
            req.id = id;
            ParamGetListRes cpRes = ParamGetListRes.Parse(SendPost(req, url));
            var cmp = cpRes.list[0];

            // update status
            ParamUpdateReq updateReq = new ParamUpdateReq(cmp);
            updateReq.values = value;
            updateReq.note = note;
            updateReq.users = account;
            string result = SendPost(updateReq, GetParameter(CommonUtils.WsType.ParamUpdate));
            CommonRes res = CommonRes.Parse(result);
            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });
        }


        public IActionResult Reload()
        {
            return View();
        }

        [HttpPost]
        public JsonResult ReloadConfig(ReloadReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");
            request.users = account;

            // check update or add
            string url = GetParameter(CommonUtils.WsType.ParamReload);
            var res = ParamUpdateRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });

        }

        // SERVICE UNDER
        public IActionResult ServiceUnder()
        {
            // init
            try
            {
                var listService = HttpContext.Session.GetComplexData<List<Service>>("listService");
                if (listService == null)
                {
                    PreLoadService();
                }
            }
            catch (Exception ex)
            {
                PreLoadService();
            }
            return View();
        }

        public IActionResult ServiceUnderSearch(ServiceUnderGetListReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }


            String url = GetParameter(CommonUtils.WsType.SvGetList);
            ServiceGetListRes res = ServiceGetListRes.Parse(SendPost(req, url));


            return PartialView("../Partial/_ServicesUnder", res.list);
        }

        [HttpPost]
        public JsonResult ServiceUnderLoadInfo(ServiceUnderGetListReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // check update or add
            string url = GetParameter(CommonUtils.WsType.SvUnderGetList);
            var res = ServiceUnderGetListRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage,
                data = res.list[0]
            });

        }

        [HttpPost]
        public JsonResult ServiceUnderAddUpdate(ServiceUnderUpdateReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // check update or add
            string url = "";
            if (request.id != null)
            {
                url = GetParameter(CommonUtils.WsType.SvUnderUpdate);

            }
            else
            {
                // add
                url = GetParameter(CommonUtils.WsType.SvUnderInsert);
            }
            request.users = account;
            var res = ServiceUnderUpdateRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });

        }

        [HttpPost]
        public JsonResult ServiceUnderDelete(ServiceUnderUpdateReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            // check update or add
            string url = GetParameter(CommonUtils.WsType.SvUnderUpdate);
            request.users = account;
            request.type = "1";// delete
            var res = ServiceUnderUpdateRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });

        }


        [HttpPost]
        public IActionResult ServiceUnderExport(ServiceUnderGetListReq req)
        {
            if (!CheckAuthToken())
            {
                return null;
            }

            ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

            string url = GetParameter(CommonUtils.WsType.SvGetList);
            string result = SendPost(req, url);
            ServiceUnderGetListRes res = ServiceUnderGetListRes.Parse(result);
            var list = res.list;

            string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            string fileName = "service_ngam.xlsx";
            try
            {
                using (var workbook = new XLWorkbook())
                {
                    //<th scope="col" class="text-center" style="vertical-align:middle">ID</th>
                    //<th scope = "col" class="text-center" style="vertical-align:middle">Service Name</th>
                    //<th scope = "col" class="text-center" style="vertical-align:middle">From Date</th>
                    //<th scope = "col" class="text-center" style="vertical-align:middle">To Date</th>
                    //<th scope = "col" class="text-center" style="vertical-align:middle">Percent</th>
                    //<th scope = "col" class="text-center" style="vertical-align:middle">Message</th>
                    //<th scope = "col" class="text-center" style="vertical-align:middle">Type</th>
                    //<th scope = "col" class="text-center" style="vertical-align:middle">Action</th>
                    int i = 1;
                    IXLWorksheet worksheet = workbook.Worksheets.Add("Service Under");
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "No.";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Name";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "From Date";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "To Date";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Percent";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Content Type";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Message";
                    // make color
                    worksheet.Row(1).Style.Font.Bold = true;
                    worksheet.Row(1).Style.Fill.BackgroundColor = XLColor.Yellow;
                    //worksheet.Cell(1, i++).Value = "BetId";
                    if (list != null && list.Count > 0)
                    {
                        for (int index = 1; index <= list.Count; index++)
                        {
                            i = 1;
                            var obj = list[index - 1];
                            worksheet.Cell(index + 1, i++).Value = index;
                            worksheet.Cell(index + 1, i++).Value = obj.name;
                            worksheet.Cell(index + 1, i++).Value = obj.fromDate;
                            worksheet.Cell(index + 1, i++).Value = obj.toDate;
                            worksheet.Cell(index + 1, i++).Value = obj.percent;
                            worksheet.Cell(index + 1, i++).Value = obj.addType == "1" ? "Text" : "Register";
                            worksheet.Cell(index + 1, i++).Value = obj.message;
                        }
                    }
                    using (var stream = new MemoryStream())
                    {
                        workbook.SaveAs(stream);
                        var content = stream.ToArray();
                        return File(content, contentType, fileName);
                    }
                }
            }
            catch (Exception ex)
            {
                return null;
            }
        }

        // USER MANAGEMENT
        public IActionResult UserManagement()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            return View();
        }

        [HttpPost]
        public IActionResult UserSearch(UserWebCmsGetListReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            if (req.rowsOnPage == null)
            {
                req.rowsOnPage = "1000000";
                req.seqPage = "1";
                req.order = "desc";
            }

            String url = GetParameter(CommonUtils.WsType.UserWebCmsGetList);
            UserWebCmsGetListRes res = UserWebCmsGetListRes.Parse(SendPost(req, url));

            return PartialView("../Partial/_Users", res.list);
        }

        [HttpPost]
        public JsonResult UserLoadInfo(UserWebCmsGetListReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            String url = GetParameter(CommonUtils.WsType.UserWebCmsGetList);
            var res = UserWebCmsGetListRes.Parse(SendPost(request, url));

            if (res.list != null && res.list.Count > 0)
            {
                return Json(new
                {
                    error = res.responseCode,
                    content = res.responseMessage,
                    data = res.list[0]
                });
            }
            return Json(new
            {
                error = "-1",
                content = "Not found"
            });
        }

        [HttpPost]
        public JsonResult UserAddUpdate(UserWebCmsUpdateReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            string url = "";
            if (request.id != null && request.id != "")
            {
                url = GetParameter(CommonUtils.WsType.UserWebCmsUpdate);
            }
            else
            {
                url = GetParameter(CommonUtils.WsType.UserWebCmsInsert);
            }
            request.users = account;
            
            var res = UserWebCmsUpdateRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });
        }

        // REPORT COUNT DAILY
        public IActionResult ReportCountDaily()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            
            // Load campaign list if not in session
            try
            {
                var listCampaign = HttpContext.Session.GetComplexData<List<Campaign>>("listCampaign");
                if (listCampaign == null)
                {
                    CampaignGetListReq req = new CampaignGetListReq();
                    req.rowsOnPage = "1000000";
                    req.seqPage = "1";
                    req.order = "desc";

                    String url = GetParameter(CommonUtils.WsType.CamGetList);
                    CampaignGetListRes res = CampaignGetListRes.Parse(SendPost(req, url));
                    HttpContext.Session.SetComplexData("listCampaign", res.list);
                }
            }
            catch (Exception ex)
            {
                log.Error("Error load campaign: ", ex);
            }
            
            return View();
        }

        [HttpPost]
        public IActionResult ReportCountDailySearch(ReportCountDailyReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            req.rowsOnPage = "1000000";
            req.seqPage = "1";
            req.order = "desc";

            String url = GetParameter(CommonUtils.WsType.ReportCountDailyGetList);
            ReportCountDailyRes res = ReportCountDailyRes.Parse(SendPost(req, url));

            return PartialView("../Partial/_ReportCountDaily", res.list);
        }

        [HttpPost]
        public IActionResult ReportCountDailyExport(ReportCountDailyReq req)
        {
            if (!CheckAuthToken())
            {
                return null;
            }

            req.rowsOnPage = "1000000";
            req.seqPage = "1";
            req.order = "desc";

            String url = GetParameter(CommonUtils.WsType.ReportCountDailyGetList);
            ReportCountDailyRes res = ReportCountDailyRes.Parse(SendPost(req, url));
            var list = res.list;

            string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            string fileName = "report_count_daily.xlsx";
            try
            {
                using (var workbook = new XLWorkbook())
                {
                    int i = 1;
                    IXLWorksheet worksheet = workbook.Worksheets.Add("Report Count Daily");
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "#";
                    worksheet.Column(i).Width = 20;
                    worksheet.Cell(1, i++).Value = "Report Date";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Campaign ID";
                    worksheet.Column(i).Width = 30;
                    worksheet.Cell(1, i++).Value = "Campaign Name";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Priority";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Campaign Type";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Service Type";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "Partner";
                    worksheet.Column(i).Width = 30;
                    worksheet.Cell(1, i++).Value = "Service Name";
                    worksheet.Column(i).Width = 15;
                    worksheet.Cell(1, i++).Value = "USSD out success";
                    // make color
                    worksheet.Row(1).Style.Font.Bold = true;
                    worksheet.Row(1).Style.Fill.BackgroundColor = XLColor.Yellow;
                    if (list != null && list.Count > 0)
                    {
                        for (int index = 1; index <= list.Count; index++)
                        {
                            i = 1;
                            var obj = list[index - 1];
                            worksheet.Cell(index + 1, i++).Value = index;
                            worksheet.Cell(index + 1, i++).SetValue(obj.reportDate);
                            worksheet.Cell(index + 1, i++).Value = obj.campaignId;
                            worksheet.Cell(index + 1, i++).Value = obj.campaignName;
                            worksheet.Cell(index + 1, i++).Value = obj.priority;
                            worksheet.Cell(index + 1, i++).Value = obj.isDefault == "0" ? "Normal" : obj.isDefault == "1" ? "Default" : obj.isDefault;
                            worksheet.Cell(index + 1, i++).Value = obj.addType == "1" ? "Text" : obj.addType == "2" ? "1-Verification" : obj.addType == "3" ? "2-Verification" : obj.addType;
                            worksheet.Cell(index + 1, i++).Value = obj.isMyService == "0" ? "Metfone" : obj.isMyService == "1" ? "Khmernet" : obj.isMyService;
                            worksheet.Cell(index + 1, i++).Value = obj.serviceName;
                            worksheet.Cell(index + 1, i++).Value = obj.countSend1;
                        }
                    }
                    using (var stream = new MemoryStream())
                    {
                        workbook.SaveAs(stream);
                        var content = stream.ToArray();
                        return File(content, contentType, fileName);
                    }
                }
            }
            catch (Exception ex)
            {
                log.Error("Error exporting report count daily: ", ex);
                return StatusCode(StatusCodes.Status500InternalServerError, "Unable to export report count daily.");
            }
        }

        // FUNCTION MANAGEMENT
        public IActionResult FunctionManagement()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            return View();
        }

        [HttpPost]
        public IActionResult FunctionSearch(FunctionWebCmsGetListReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            if (req.rowsOnPage == null)
            {
                req.rowsOnPage = "1000000";
                req.seqPage = "1";
                req.order = "desc";
            }

            String url = GetParameter(CommonUtils.WsType.FunctionWebCmsGetList);
            FunctionWebCmsGetListRes res = FunctionWebCmsGetListRes.Parse(SendPost(req, url));

            return PartialView("../Partial/_Functions", res.list);
        }

        [HttpPost]
        public JsonResult FunctionLoadInfo(FunctionWebCmsGetListReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            String url = GetParameter(CommonUtils.WsType.FunctionWebCmsGetList);
            var res = FunctionWebCmsGetListRes.Parse(SendPost(request, url));

            if (res.list != null && res.list.Count > 0)
            {
                return Json(new
                {
                    error = res.responseCode,
                    content = res.responseMessage,
                    data = res.list[0]
                });
            }
            return Json(new
            {
                error = "-1",
                content = "Not found"
            });
        }

        [HttpPost]
        public JsonResult FunctionAddUpdate(FunctionWebCmsUpdateReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            string url = "";
            if (request.id != null && request.id != "")
            {
                url = GetParameter(CommonUtils.WsType.FunctionWebCmsUpdate);
            }
            else
            {
                url = GetParameter(CommonUtils.WsType.FunctionWebCmsInsert);
            }
            request.users = account;
            
            var res = FunctionWebCmsUpdateRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });
        }

        [HttpPost]
        public JsonResult FunctionDelete(FunctionWebCmsUpdateReq request)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }
            string account = HttpContext.Session.GetString("account");

            string url = GetParameter(CommonUtils.WsType.FunctionWebCmsDelete);
            request.users = account;
            
            var res = FunctionWebCmsUpdateRes.Parse(SendPost(request, url));

            return Json(new
            {
                error = res.responseCode,
                content = res.responseMessage
            });
        }

        [HttpPost]
        public IActionResult ReportErrorDailyDetail(ReportErrorDailyReq req)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            string account = HttpContext.Session.GetString("account");
            if (string.IsNullOrEmpty(account))
            {
                account = "-1";
            }
            req.users = account;

            String url = GetParameter(CommonUtils.WsType.ReportErrorDailyGetList);
            if (string.IsNullOrEmpty(url))
            {
                return Json(new
                {
                    error = "-1",
                    content = "API URL not configured"
                });
            }

            try
            {
                ReportErrorDailyRes res = ReportErrorDailyRes.Parse(SendPost(req, url));

                if (res == null || res.responseCode != "0")
                {
                    return Json(new
                    {
                        error = res?.responseCode ?? "-1",
                        content = res?.responseMessage ?? "Error occurred"
                    });
                }

                return PartialView("../Partial/_ReportErrorDaily", res.list ?? new List<ReportErrorDaily>());
            }
            catch (Exception ex)
            {
                log.Error("Error in ReportErrorDailyDetail: ", ex);
                return Json(new
                {
                    error = "-1",
                    content = "Error occurred: " + ex.Message
                });
            }
        }

        public IActionResult DashboardReport()
        {
            if (!CheckAuthToken())
            {
                return Redirect(GetParameter(UtilsController.Constant.SUB_DOMAIN) + "/Home/Login");
            }
            
            // Load campaign list if not in session
            try
            {
                var listCampaign = HttpContext.Session.GetComplexData<List<Campaign>>("listCampaign");
                if (listCampaign == null)
                {
                    CampaignGetListReq req = new CampaignGetListReq();
                    req.rowsOnPage = "1000000";
                    req.seqPage = "1";
                    req.order = "desc";

                    String url = GetParameter(CommonUtils.WsType.CamGetList);
                    CampaignGetListRes res = CampaignGetListRes.Parse(SendPost(req, url));
                    HttpContext.Session.SetComplexData("listCampaign", res.list);
                }
                
                var listService = HttpContext.Session.GetComplexData<List<Service>>("listService");
                if (listService == null)
                {
                    PreLoadService();
                }
            }
            catch (Exception ex)
            {
                log.Error("Error load campaign/service: ", ex);
            }
            
            return View();
        }

        [HttpPost]
        public JsonResult DashboardReportGetData(string campaignId, string serviceId, string hours, string quickJump)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            string account = HttpContext.Session.GetString("account");
            if (string.IsNullOrEmpty(account))
            {
                account = "-1";
            }

            try
            {
                HourlyImpressionsGetListReq req = new HourlyImpressionsGetListReq();
                req.users = account;
                req.campaignId = campaignId ?? "-1";
                req.serviceId = serviceId ?? "-1";
                req.hours = hours ?? "72h";
                req.quickJump = quickJump ?? "-1";
                req.language = "vi";

                String url = GetParameter(CommonUtils.WsType.HourlyImpressionsGetList);
                if (string.IsNullOrEmpty(url))
                {
                    return Json(new
                    {
                        error = "-1",
                        content = "API URL not configured"
                    });
                }

                HourlyImpressionsGetListRes res = HourlyImpressionsGetListRes.Parse(SendPost(req, url));
                
                if (res == null || res.responseCode != "0")
                {
                    return Json(new
                    {
                        error = res?.responseCode ?? "-1",
                        content = res?.responseMessage ?? "Error occurred"
                    });
                }

                return Json(new
                {
                    error = "0",
                    data = JsonConvert.SerializeObject(res)
                });
            }
            catch (Exception ex)
            {
                log.Error("Error in DashboardReportGetData: ", ex);
                return Json(new
                {
                    error = "-1",
                    content = "Error occurred: " + ex.Message
                });
            }
        }

        [HttpPost]
        public JsonResult DashboardReportGetDailyData(string campaignId, string fromDate, string toDate)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            string account = HttpContext.Session.GetString("account");
            if (string.IsNullOrEmpty(account))
            {
                account = "-1";
            }

            try
            {
                HourlyImpressionsGetListReq req = new HourlyImpressionsGetListReq();
                req.users = account;
                req.campaignId = campaignId ?? "-1";
                req.hours = "-1"; // Not used for daily
                req.quickJump = "-1"; // Not used for daily
                req.language = "vi";

                String url = GetParameter(CommonUtils.WsType.DailyImpressionsGetList);
                if (string.IsNullOrEmpty(url))
                {
                    return Json(new
                    {
                        error = "-1",
                        content = "API URL not configured"
                    });
                }

                // Create custom request object for daily (with fromDate and toDate)
                DailyImpressionsGetListReq dailyReq = new DailyImpressionsGetListReq();
                dailyReq.users = account;
                dailyReq.campaignId = campaignId ?? "-1";
                dailyReq.fromDate = fromDate ?? "-1";
                dailyReq.toDate = toDate ?? "-1";
                dailyReq.language = "vi";
                dailyReq.channel = "WEB";
                dailyReq.token = HttpContext.Session.GetString("token") ?? "";

                HourlyImpressionsGetListRes res = HourlyImpressionsGetListRes.Parse(SendPost(dailyReq, url));
                
                if (res == null || res.responseCode != "0")
                {
                    return Json(new
                    {
                        error = res?.responseCode ?? "-1",
                        content = res?.responseMessage ?? "Error occurred"
                    });
                }

                return Json(new
                {
                    error = "0",
                    data = JsonConvert.SerializeObject(res)
                });
            }
            catch (Exception ex)
            {
                log.Error("Error in DashboardReportGetDailyData: ", ex);
                return Json(new
                {
                    error = "-1",
                    content = "Error occurred: " + ex.Message
                });
            }
        }

        [HttpPost]
        public JsonResult DashboardReportGetDailyUniqueData(string campaignId, string serviceId, string fromDate, string toDate)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            string account = HttpContext.Session.GetString("account");
            if (string.IsNullOrEmpty(account))
            {
                account = "-1";
            }

            try
            {
                DailyImpressionsGetListReq req = new DailyImpressionsGetListReq();
                req.users = account;
                req.campaignId = campaignId ?? "-1";
                req.serviceId = serviceId ?? "-1";
                req.fromDate = fromDate ?? "-1";
                req.toDate = toDate ?? "-1";
                req.language = "vi";
                req.channel = "WEB";
                req.token = HttpContext.Session.GetString("token") ?? "";

                String url = GetParameter(CommonUtils.WsType.DailyUniqueImpressionsGetList);
                if (string.IsNullOrEmpty(url))
                {
                    return Json(new
                    {
                        error = "-1",
                        content = "API URL not configured"
                    });
                }

                HourlyImpressionsGetListRes res = HourlyImpressionsGetListRes.Parse(SendPost(req, url));

                if (res == null || res.responseCode != "0")
                {
                    return Json(new
                    {
                        error = res?.responseCode ?? "-1",
                        content = res?.responseMessage ?? "Error occurred"
                    });
                }

                return Json(new
                {
                    error = "0",
                    data = JsonConvert.SerializeObject(res)
                });
            }
            catch (Exception ex)
            {
                log.Error("Error in DashboardReportGetDailyUniqueData: ", ex);
                return Json(new
                {
                    error = "-1",
                    content = "Error occurred: " + ex.Message
                });
            }
        }

        [HttpPost]
        public JsonResult DashboardReportGetDailyEngagedData(string campaignId, string fromDate, string toDate)
        {
            if (!CheckAuthToken())
            {
                return Json(new
                {
                    error = "-1",
                    content = "Login first"
                });
            }

            string account = HttpContext.Session.GetString("account");
            if (string.IsNullOrEmpty(account))
            {
                account = "-1";
            }

            try
            {
                DailyImpressionsGetListReq req = new DailyImpressionsGetListReq();
                req.users = account;
                req.campaignId = campaignId ?? "-1";
                req.serviceId = "-1";
                req.fromDate = fromDate ?? "-1";
                req.toDate = toDate ?? "-1";
                req.language = "vi";
                req.channel = "WEB";
                req.token = HttpContext.Session.GetString("token") ?? "";

                String url = GetParameter(CommonUtils.WsType.DailyEngagedGetList);
                if (string.IsNullOrEmpty(url))
                {
                    return Json(new
                    {
                        error = "-1",
                        content = "API URL not configured"
                    });
                }

                HourlyImpressionsGetListRes res = HourlyImpressionsGetListRes.Parse(SendPost(req, url));

                if (res == null || res.responseCode != "0")
                {
                    return Json(new
                    {
                        error = res?.responseCode ?? "-1",
                        content = res?.responseMessage ?? "Error occurred"
                    });
                }

                return Json(new
                {
                    error = "0",
                    data = JsonConvert.SerializeObject(res)
                });
            }
            catch (Exception ex)
            {
                log.Error("Error in DashboardReportGetDailyEngagedData: ", ex);
                return Json(new
                {
                    error = "-1",
                    content = "Error occurred: " + ex.Message
                });
            }
        }
    }
}