using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using System.Threading.Tasks;
using VueWebCoreApi.DLL.BLL;
using VueWebCoreApi.Models;
using VueWebCoreApi.Models.SystemSetting;
using VueWebCoreApi.Tools;

namespace VueWebCoreApi.Controllers
{
    [ApiExplorerSettings(GroupName = "Excel导入")]
    [ApiController]
    [Route("api/[controller]")]
    [ChannelActionFilter]
    public class ImportExcelController : Controller
    {

        #region[Excel导入模板列表]
        /// <summary>
        /// Excel导入模板列表
        /// </summary>
        /// <returns></returns>
        [Route(template: "ExcelModelData")]
        [HttpGet]
        public JsonResult ExcelModelData()
        {
            ToMessage mes = new ToMessage();
            List<ScoreReport> list = ExcelList.ExcelData();
            mes.code = "200";
            mes.data = list;
            return Json(mes);
        }
        #endregion

        #region [Excel导入模板下载]
        /// <summary>
        /// Excel导入模板下载
        /// </summary>
        /// <param name="FileCode"></param>
        /// <returns></returns>
        [Route(template: "DownLoadExcel")]
        [HttpGet]
        public JsonResult DownLoadExcel(string FileCode = null)
        {
            ToMessage mes = new ToMessage();
            List<ScoreReport> list = ExcelList.ExcelData();
            list = list.Where(s => s.FileCode == FileCode).ToList();
            var filename = list[0].FileName + ".xls";
            string fileip = AppSetting.GetAppSetting("FileIP");
            var msg = fileip + "/Excel/" + filename;
            mes.code = "200";
            mes.data = msg;
            return Json(mes);
        }
        #endregion

        #region [Excel导入数据提交、模板验证、数据导入]
        /// <summary>
        /// Excel导入数据提交、模板验证、数据导入
        /// </summary>
        /// <param name="myModel">提交数据</param>
        /// <returns></returns>
        [Route(template: "ExcelModelCheck")]
        [HttpPost]
        public JsonResult ExcelModelCheck([FromBody] ExceImport myModel)
        {
            string FileCode = myModel.FileCode;
            List<DataTable> dataTable = myModel.TableData;

            ExcelModelCheck list = new ExcelModelCheck();
            list.json1 = ExcelCheck(dataTable, FileCode);  //模板验证
            if (list.json1.code == "301")
            {
                list.json1 = list.json1;
                return Json(list);
            }
            list.json2 = ExcelCheckData(myModel);  //数据验证
            if (list.json2.code == "301")
            {
                list.json2 = list.json2;
                return Json(list);
            }
            list.json3 = ExcelImportSubmit(dataTable, FileCode);  //数据导入
            if (list.json3.code == "300")
            {
                list.json3 = list.json3;
                return Json(list);
            }
            return Json(list);
        }
        #endregion

        #region [Excel导入模板验证]
        /// <summary>
        /// Excel导入模板验证
        /// </summary>
        /// <param name="dataTable">提交数据</param>
        /// <param name="FileCode">文件编码</param>
        /// <returns></returns>
        [Route(template: "ExcelCheckUpload")]
        [HttpGet]
        [ApiExplorerSettings(IgnoreApi = true)]
        public ToMessage ExcelCheck(List<DataTable> dataTable, string FileCode = null)
        {
            ToMessage mes = new ToMessage();
            try
            {
                mes = ExcelCheckBLL.ExcelCheck(FileCode, dataTable);
                if (mes.code == "301") //上传模板不是指定模板
                {
                    return mes;
                }
                return mes;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.Message = e.Message;
            }
            return mes;
        }
        #endregion

        #region [Excel导入数据验证]
        /// <summary>
        /// Excel导入数据验证
        /// </summary>
        /// <param name="myModel">提交数据</param>
        /// <returns></returns>
        [Route(template: "ExcelCheckData")]
        [HttpPost]
        [ApiExplorerSettings(IgnoreApi = true)]
        public ToMessage ExcelCheckData([FromBody] ExceImport myModel)
        {
            ToMessage mes = new ToMessage();
            string message = "";
            string StuCode = "";
            int count = 0;
            List<ExcelErro> list = new List<ExcelErro>();
            string FileCode = myModel.FileCode;
            List<DataTable> dataTable = myModel.TableData;
            list = ExcelCheckBLL.ExcelCheckData(FileCode, dataTable, out StuCode, out message, out count);
            mes.code = StuCode;
            mes.Message = message;
            mes.count = count;
            mes.data = list;
            return mes;
        }
        #endregion

        #region[Excel导入数据]
        /// <summary>
        /// Excel导入数据
        /// </summary>
        /// <param name="dataTable">提交数据</param>
        /// <param name="FileCode">文件编码</param>
        /// <returns></returns>
        [Route(template: "ExcelImportSubmit")]
        [HttpPost]
        [ApiExplorerSettings(IgnoreApi = true)]
        public ToMessage ExcelImportSubmit(List<DataTable> dataTable, string FileCode = null)
        {
            ToMessage mes = new ToMessage();
            try
            {
                var token = HttpContext.Request.Headers["Token"].ToString();
                User us = JwtTools.Denocode(token.ToString());
                mes = ExcelCheckBLL.ExcelImportSubmit(FileCode, dataTable, us);
                if (mes.code == "300") 
                {
                    return mes;
                }
                return mes;
            }
            catch (Exception e)
            {
                mes.code = "300";
                mes.Message = e.Message;
            }
            return mes;
        }
        #endregion
    }
}