using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using AutoMapper;
using CommonToolsCore;
using DTO;
using IServices;
using Microsoft.AspNetCore.Mvc.Rendering;
using Microsoft.EntityFrameworkCore;
using zhengcaioa.Models;

namespace Services
{
    public class ProjectService : IProjectService
    {
        private readonly zhengcaioaContext _context;
        private readonly IMapper _mapper;
        public ProjectService(zhengcaioaContext context, IMapper mapper)
        {
            _context = context;
            _mapper = mapper;
        }

        public ResultEntity saveLiaotian(ProjectDTO projectDTO)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                var project = _mapper.Map<Project>(projectDTO);
                // var ZhuanjiaList = projectDTO.ZhuanjiaList;
                //if(ZhuanjiaList!=null&& ZhuanjiaList.Length > 0)
                //{
                //    for(int i = 0;i< ZhuanjiaList.Length; i++)
                //    {
                //        project.Zhuanjia += ZhuanjiaList[i] + ",";
                //    }
                //}
               
                if (String.IsNullOrEmpty(project.Id))
                {
                    project.Id = Guid.NewGuid().ToString();
                    _context.Projects.Add(project);
                }
                else
                {
                    var updateproject = _context.Projects.Find(project.Id);
                    updateproject.StartTime = project.StartTime;
                    updateproject.Sheng = project.Sheng;
                    updateproject.City = project.City;
                    updateproject.AreaId = project.AreaId;
                    updateproject.Cgfs = project.Cgfs;
                    updateproject.Number = project.Number;
                    updateproject.Name = project.Name;
                    updateproject.Drhx = project.Drhx;
                    updateproject.DrhxPrice = project.DrhxPrice;
                    updateproject.Dshx = project.Dshx;
                    updateproject.DshxPrice = project.DshxPrice;
                    updateproject.Zhuanjia = project.Zhuanjia;
                    updateproject.Remark = project.Remark;

                    updateproject.Toubiaocishu = project.Toubiaocishu;
                    updateproject.Question = project.Question;
                    updateproject.Zhongbiaocishu = project.Zhongbiaocishu;
                    updateproject.Feibiaocishu = project.Feibiaocishu;
                    updateproject.Zhongbiaojine = project.Zhongbiaojine;

                    updateproject.RecStatus = project.RecStatus;
                    updateproject.Modifier = project.Modifier;
                    updateproject.Modifytime = project.Modifytime;


                    updateproject.Fblx = project.Fblx;
                    updateproject.Fbyy = project.Fbyy;

                    updateproject.Caigourenname = project.Caigourenname;
                    updateproject.Caigourenaddress = project.Caigourenaddress;
                    updateproject.Caigourencontact = project.Caigourencontact;
                    updateproject.Dailiname = project.Dailiname;
                    updateproject.Dailicontact = project.Dailicontact;
                    updateproject.Dailiaddress = project.Dailiaddress;
                }

                //子表
               
               var projectreasonListremove = _context.Projectreasons.Where(x => x.ProjectId == project.Id).ToList();
                if(projectreasonListremove != null && projectreasonListremove.Count > 0)
                {
                    foreach (var projectreason in projectreasonListremove)
                    {
                        _context.Projectreasons.Remove(projectreason);
                    }
                }
                var ReasonId = projectDTO.ReasonId;
                if (ReasonId != null&& ReasonId.Length>0)
                {
                    for(int i = 0;i< ReasonId.Length;i++)
                    {
                        if (!string.IsNullOrEmpty(projectDTO.Reasonname[i]))
                        {
                            Projectreason projectreason = new Projectreason();
                            if (string.IsNullOrEmpty(ReasonId[i]))
                            {
                                projectreason.ReasonId = Guid.NewGuid().ToString();

                            }
                            else
                            {
                                projectreason.ReasonId = ReasonId[i];
                            }
                            projectreason.Reasonname = projectDTO.Reasonname[i];
                            projectreason.Reasonremark = projectDTO.Reasonremark[i];
                            projectreason.ProjectId = project.Id;
                            _context.Projectreasons.Add(projectreason);
                        } 
                    }
                }


                var ProjectyouxiaosListremove = _context.Projectyouxiaos.Where(x => x.ProjectId == project.Id).ToList();
                if (ProjectyouxiaosListremove != null && ProjectyouxiaosListremove.Count > 0)
                {
                    foreach (var projectyouxiao in ProjectyouxiaosListremove)
                    {
                        _context.Projectyouxiaos.Remove(projectyouxiao);
                    }
                }
                var YouxiaoId = projectDTO.YouxiaoId;
                if (YouxiaoId != null && YouxiaoId.Length > 0)
                {
                    for (int i = 0; i < YouxiaoId.Length; i++)
                    {
                        if (!string.IsNullOrEmpty(projectDTO.Namesyouxiao[i]))
                        {
                            Projectyouxiao projectyouxiao = new Projectyouxiao();
                            if (string.IsNullOrEmpty(YouxiaoId[i]))
                            {
                                projectyouxiao.YouxiaoId = Guid.NewGuid().ToString();

                            }
                            else
                            {
                                projectyouxiao.YouxiaoId = YouxiaoId[i];
                            }
                            projectyouxiao.Namesyouxiao = projectDTO.Namesyouxiao[i];
                            projectyouxiao.Priceyouxiao = projectDTO.Priceyouxiao[i];
                            projectyouxiao.ProjectId = project.Id;
                            _context.Projectyouxiaos.Add(projectyouxiao);
                        }
                    }
                }


                var ProjectzhongbiaosListremove = _context.Projectzhongbiaos.Where(x => x.ProjectId == project.Id).ToList();
                if (ProjectzhongbiaosListremove != null && ProjectzhongbiaosListremove.Count > 0)
                {
                    foreach (var projectzhongbiao in ProjectzhongbiaosListremove)
                    {
                        _context.Projectzhongbiaos.Remove(projectzhongbiao);
                    }
                }
                var ZhongbiaoId = projectDTO.ZhongbiaoId;
                if (ZhongbiaoId != null && ZhongbiaoId.Length > 0)
                {
                    for (int i = 0; i < ZhongbiaoId.Length; i++)
                    {
                        if (!string.IsNullOrEmpty(projectDTO.Names[i]))
                        {
                            Projectzhongbiao projectzhongbiao = new Projectzhongbiao();
                            if (string.IsNullOrEmpty(ZhongbiaoId[i]))
                            {
                                projectzhongbiao.ZhongbiaoId = Guid.NewGuid().ToString();

                            }
                            else
                            {
                                projectzhongbiao.ZhongbiaoId = ZhongbiaoId[i];
                            }
                            projectzhongbiao.Names = projectDTO.Names[i];
                            projectzhongbiao.Price = projectDTO.Price[i];
                            projectzhongbiao.ProjectId = project.Id;
                            _context.Projectzhongbiaos.Add(projectzhongbiao);
                        }
                    }
                }
                CacheHelperNetCore.CacheNull("Projects");


                _context.SaveChanges();
                resultEntity.ReturnID = project.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";

            }
            return resultEntity;
        }

        public ProjectDTO GetLiaotianEntity(string id)
        {
            
            var entity = _context.Projects.Find(id);
            if (entity.RecStatus != "A")
            {
                entity = new Project();
            }
            var projectreasons = _context.Projectreasons.Where(x => x.ProjectId == entity.Id).ToList();

            var Projectyouxiaos = _context.Projectyouxiaos.Where(x => x.ProjectId == entity.Id).ToList();

            var Projectzhongbiaos = _context.Projectzhongbiaos.Where(x => x.ProjectId == entity.Id).ToList();




            var projectDTO = _mapper.Map<ProjectDTO>(entity);
            if(projectreasons!=null && projectreasons.Count>0)
            {
                projectDTO.projectreasons = projectreasons;
            }
            else
            {
                var Projectreasonlist = new List<Projectreason>();
                Projectreasonlist.Add(new Projectreason());
                projectDTO.projectreasons = Projectreasonlist;
            }

            if (Projectyouxiaos != null && Projectyouxiaos.Count > 0)
            {
                projectDTO.Projectyouxiaos = Projectyouxiaos;
            }
            else
            {
                var Projectyouxiaolist = new List<Projectyouxiao>();
                Projectyouxiaolist.Add(new Projectyouxiao());
                projectDTO.Projectyouxiaos = Projectyouxiaolist;
            }

            if (Projectzhongbiaos != null && Projectzhongbiaos.Count > 0)
            {
                projectDTO.Projectzhongbiaos = Projectzhongbiaos;
            }
            else
            {
                var Projectzhongbiaoslist = new List<Projectzhongbiao>();
                Projectzhongbiaoslist.Add(new Projectzhongbiao());
                projectDTO.Projectzhongbiaos = Projectzhongbiaoslist;
            }

            return projectDTO;
        }

        public ResultDataEntity<ProjectDTO> SearchByPaging(ProjectDTOSearch searchEntity)
        {



            ResultDataEntity<ProjectDTO> data = new ResultDataEntity<ProjectDTO>();
            List<ProjectDTO> list = new List<ProjectDTO>();
            //筛选
            StringBuilder sql = new StringBuilder();
            sql.Append("SELECT distinct a.[Id],a.[start_time] ,b.[name] +'-'+c.[name]+'-'+d.[name]  Sheng ,a.city  ,a.[area_id],a.cgfs, a.[name] ,a.[number],a.creater,a.createtime,a.modifier,a.modifytime       ,a.[drhx],a.[drhx_price],a.[dshx],a.[dshx_price],a.[remark],a.[rec_status],a.[toubiaocishu] ,a.[question] ,a.[zhongbiaocishu],a.[feibiaocishu],a.[zhongbiaojine],a.[Fblx],a.[Fbyy] , a.[zhuanjia]  , a.[caigourenname], a.[caigourenaddress], a.[caigourencontact], a.[dailiname], a.[dailiaddress], a.[dailicontact]    "); //zhuanjia = stuff((select ','+name from [Zhuanjia] f where  CHARINDEX(f.id,a.[zhuanjia]) >0 for xml path('')), 1,1, '') 
            sql.Append("FROM [Project] a ");
            sql.Append("left join  [Area] b  on a.[sheng]  = b.[codeID] ");
            sql.Append("left join  [Area] c  on a.[city]  = c.[codeID] ");
            sql.Append("left join  [Area] d  on a.[area_id]  = d.[codeID] ");
            //sql.Append("left join  [Zhuanjia] e  on CHARINDEX(e.id,a.[zhuanjia]) >0   ");
            sql.Append("  where a.rec_status='A' ");

            if (!string.IsNullOrWhiteSpace(searchEntity.Names))
            {
                sql.Append(" and  exists (select b.[ProjectId] from [Projectzhongbiao] b  where  a.[Id]=b.[ProjectId] and   b.[names] like '%"+ searchEntity.Names + "%') ");

            }

            if (!string.IsNullOrWhiteSpace(searchEntity.StartTimestar))
            {
                sql.Append(" and a.start_time >='"+ searchEntity.StartTimestar.Trim().Replace("'","''") + "'");
            
            }
            if (!string.IsNullOrWhiteSpace(searchEntity.StartTimeend))
            {
                sql.Append(" and a.start_time <='" + DateTime.Parse(searchEntity.StartTimeend.Trim().Replace("'", "''")).AddDays(1).ToString("yyyy-MM-dd") + "'"); ;

            }

            if (!string.IsNullOrWhiteSpace(searchEntity.Sheng))
            {
                sql.Append(" and a.[sheng] = '" + searchEntity.Sheng.Trim().Replace("'", "''") + "' ");

            }
            if (!string.IsNullOrWhiteSpace(searchEntity.City))
            {
                sql.Append(" and a.[city] = '" + searchEntity.City.Trim().Replace("'", "''") + "' ");

            }
            if (!string.IsNullOrWhiteSpace(searchEntity.AreaId))
            {
                sql.Append(" and a.[area_id] = '" + searchEntity.AreaId.Trim().Replace("'", "''") + "' ");

            }

            if (!string.IsNullOrWhiteSpace(searchEntity.Cgfs))
            {
                sql.Append("and a.[cgfs] ='" + searchEntity.Cgfs.Trim().Replace("'", "''") + "'");

            }

            if (!string.IsNullOrWhiteSpace(searchEntity.Zhuanjia))
            {
                sql.Append("and a.[zhuanjia] like '%" + searchEntity.Zhuanjia.Trim().Replace("'", "''") + "%'");

            }
            if (!string.IsNullOrWhiteSpace(searchEntity.Number))
            {
                sql.Append("and a.[number] like '%" + searchEntity.Number.Trim().Replace("'", "''") + "%'");

            }
            if (!string.IsNullOrWhiteSpace(searchEntity.Name))
            {
                sql.Append("and a.[name] like '%" + searchEntity.Name.Trim().Replace("'", "''") + "%'");

            }
           

            DateTime Createtimestart = DateTime.Now;
            DateTime Createtimeend = DateTime.Now;
            if (!string.IsNullOrWhiteSpace(searchEntity.Createtime))
            {
                string[] Createtimes = searchEntity.Createtime.Split("|");
                DateTime.TryParse(Createtimes[0], out Createtimestart);
                DateTime.TryParse(Createtimes[1], out Createtimeend);
                //Createtimeend = Createtimeend.AddDays(1);
            }


            if (!string.IsNullOrWhiteSpace(searchEntity.Createtime))
            {
                sql.Append(" and a.Createtime >='" + Createtimestart.ToString("yyyy-MM-dd") + "'");

            }
            if (!string.IsNullOrWhiteSpace(searchEntity.Createtime))
            {
                sql.Append(" and a.Createtime <='" + Createtimeend.AddDays(1).ToString("yyyy-MM-dd") + "'");

            }
            if (!string.IsNullOrWhiteSpace(searchEntity.Creater))
            {
                sql.Append(" and a.Creater ='" + searchEntity.Creater + "'");

            }
            //if (!string.IsNullOrEmpty(searchEntity.pingshenqingkuang) )
            //{
            //    if(searchEntity.pingshenqingkuang.Equals("中标供应商"))
            //    {
            //        sql.Append(" a.[zhongbiaocishu] !='' ");
            //    }else if (searchEntity.pingshenqingkuang.Equals("有效供应商"))
            //    {
            //        sql.Append(" a.[zhongbiaocishu] !='' ");
            //    }
            //    else if (searchEntity.pingshenqingkuang.Equals("无效供应商"))
            //    {
            //        sql.Append(" a.[zhongbiaocishu] !='' ");
            //    }


            //}






            var query = _context.Projects
           .FromSqlRaw(sql.ToString()).OrderByDescending(x=>x.StartTime)
           .ToList();

            

            
            if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            list = _mapper.Map<List<ProjectDTO>>(lianlist);
            data.LoadData(searchEntity, list);
            return data;
        }


        public List<Zhuanjium> Getzhuanjie()
        {
            var zhuanjia = _context.Zhuanjia.ToList();
            return zhuanjia;
        }

        public List<Cgf>  GetCgfs()
        {
            var Cgfs = _context.Cgfs.ToList();
            return Cgfs;
        }

        public List<Area> Getsheng()
        {
            var Areas = _context.Areas.Where(x=>x.ParentId == "0").ToList();
            return Areas;
        }

        public List<Area> Getshi(string sheng)
        {
            var Areas = _context.Areas.Where(x => x.ParentId == sheng).ToList();
            return Areas;
        }

        public List<Area> Getquxian(string shi)
        {

            var Areas = _context.Areas.Where(x => x.ParentId == shi).ToList();
            return Areas;
        }

        /// <summary>
        /// 获取项目下拉列表
        /// </summary>
        /// <returns></returns>
        public List<SelectListItem> AllcgfsDropDown()
        {
            
                var listProject = _context.Cgfs.ToList();
                var items = listProject.Select(x => new SelectListItem
                {
                    Text = $"{x.Name}",
                    Value = x.Id
                }).ToList();
                return items;
            
        }

        /// <summary>
        /// 修改主表状态
        /// </summary>
        /// <param name="id">主id</param>
        /// <param name="userid">用户</param>
        /// <returns></returns>
        public ResultEntity ModifyStatus(string id, string userid)
        {
            ResultEntity result = new ResultEntity();
            result.Result = true;

            var model = _context.Projects.Find(id);
            if (model != null)
            {
                model.RecStatus = "D";
                model.Modifier = userid;
                model.Modifytime = DateTime.Now;
                _context.SaveChanges();
            }

            return result;
        }

        /// <summary>
        /// 获取所有有效合作客户
        /// </summary>
        /// <returns></returns>
        public List<ProjectDTO> GetList()
        {
            List<ProjectDTO> projectDTOs = (List<ProjectDTO>)CacheHelperNetCore.CacheValue("Projects");
            if (projectDTOs!=null&& projectDTOs.Count > 0)
            {
                return projectDTOs;
            }

            var listPosition = _context.Projects.Where(r => r.RecStatus == "A").ToList();
           
            var list = _mapper.Map<List<ProjectDTO>>(listPosition);
            CacheHelperNetCore.CacheInsert("Projects", list);
            return list;
        }
    }
}