using Model;
using System;
using System.Collections.Generic;
using System.Linq;

namespace BLL.SendEmail
{
    public class SendEmailTemplateService
    {

        #region 邮件模板添加
        /// <summary>
        /// 邮件模板添加
        /// </summary>
        /// <param name="eProject"></param>
        public static void AddSendEmail(Model.SendEmailTemplate sendEmailTemplate, List<Model.Email_ToPeople> peopleList)
        {
            Model.SendEmailTemplate newsendTemplate = new Model.SendEmailTemplate();
            newsendTemplate.EmailId = Guid.NewGuid().ToString();
            newsendTemplate.EmailType = sendEmailTemplate.EmailType;
            newsendTemplate.EmailName = sendEmailTemplate.EmailName;
            newsendTemplate.EmailContext = sendEmailTemplate.EmailContext;
            newsendTemplate.EailTiaoJian = sendEmailTemplate.EailTiaoJian;
            newsendTemplate.EmailNotifier = sendEmailTemplate.EmailNotifier;
            newsendTemplate.CreateName = sendEmailTemplate.CreateName;
            newsendTemplate.CreateTime = sendEmailTemplate.CreateTime;
            newsendTemplate.UpdateName = sendEmailTemplate.UpdateName;
            newsendTemplate.UpdateTime = sendEmailTemplate.UpdateTime;

            Funs.DB.SendEmailTemplate.InsertOnSubmit(newsendTemplate);

            var list = (from x in Funs.DB.Email_ToPeople where x.EmtempID == newsendTemplate.EmailId select x).ToList();
            if (list != null || list.Count > 0)
            {
                Funs.DB.Email_ToPeople.DeleteAllOnSubmit(list);
            }
            if (peopleList != null)
            {
                Funs.DB.Email_ToPeople.InsertAllOnSubmit(peopleList);
            }

            Funs.DB.SubmitChanges();
        }
        #endregion

        #region 邮件模板修改
        /// <summary>
        /// 邮件模板修改
        /// </summary>
        /// <param name="sendEmailTemplate"></param>
        public static void UpdateSendEmail(Model.SendEmailTemplate sendEmailTemplate, List<Model.Email_ToPeople> peopleList)
        {
            Model.SendEmailTemplate newsendTemplate = Funs.DB.SendEmailTemplate.FirstOrDefault(x => x.EmailId == sendEmailTemplate.EmailId);
            newsendTemplate.EmailType = sendEmailTemplate.EmailType;
            newsendTemplate.EmailName = sendEmailTemplate.EmailName;
            newsendTemplate.EmailContext = sendEmailTemplate.EmailContext;
            newsendTemplate.EmailNotifier = sendEmailTemplate.EmailNotifier;
            newsendTemplate.EailTiaoJian = sendEmailTemplate.EailTiaoJian;
            newsendTemplate.UpdateName = sendEmailTemplate.UpdateName;
            newsendTemplate.UpdateTime = sendEmailTemplate.UpdateTime;

            var list = (from x in Funs.DB.Email_ToPeople where x.EmtempID == newsendTemplate.EmailId select x).ToList();
            if (list != null || list.Count > 0)
            {
                Funs.DB.Email_ToPeople.DeleteAllOnSubmit(list);
            }
            if (peopleList != null)
            {
                Funs.DB.Email_ToPeople.InsertAllOnSubmit(peopleList);
            }

            Funs.DB.SubmitChanges();
        }
        #endregion

        #region 根据主键获取邮件设置
        /// <summary>
        /// 根据主键获取邮件设置
        /// </summary>
        /// <param name="EmailID">邮件设置Id</param>
        /// <returns></returns>
        public static Model.SendEmailTemplate GetSendEmailTemplate(string EmailID)
        {
            return Funs.DB.SendEmailTemplate.FirstOrDefault(x => x.EmailId == EmailID);
        }
        #endregion

        #region 获取邮件模板列表
        /// <summary>
        /// 获取邮件模板列表
        /// </summary>
        /// <returns></returns>
        public static List<Model.SendEmailTemplate> GetSendEmailTemplateList()
        {
            return (from x in Funs.DB.SendEmailTemplate orderby x.CreateTime descending select x).ToList();
        }
        #endregion

        #region 根据主键删除
        /// <summary>
        /// 根据主键删除
        /// </summary>
        /// <param name="EmailId"></param>
        public static void DeleteEproejctById(string EmailId)
        {
            Model.SendEmailTemplate SendEmailTemplate = Funs.DB.SendEmailTemplate.FirstOrDefault(e => e.EmailId == EmailId);
            if (SendEmailTemplate != null)
            {
                Funs.DB.SendEmailTemplate.DeleteOnSubmit(SendEmailTemplate);
                Funs.DB.SubmitChanges();
            }
        }
        #endregion

        public static List<Model.Email_ToPeople> GetSenderTopeopleList(string EmtempID,string emailType)
        {
            return (from x in Funs.DB.Email_ToPeople select x).Where(o => o.EmtempID == EmtempID && o.EMPeopleType == emailType).ToList();
        }

        //#region 根据主键删除EProject
        ///// <summary>
        ///// 根据主键删除EProject
        ///// </summary>
        ///// <param name="EmailId"></param>
        //public static List<SendEmailTemplate> GetEmailNotifierList(string EmailNotifier)
        //{
        //    return (from x in Funs.DB.SendEmailTemplate orderby x.CreateTime descending select x).Where(o => o.EmailNotifier == EmailNotifier).ToList();
        //}
        //#endregion

        //#region 根据主键删除EProject
        ///// <summary>
        ///// 根据主键删除EProject
        ///// </summary>
        ///// <param name="EmailId"></param>
        //public static SendEmailTemplate GetEmailNotifier(string EmailNotifier)
        //{
        //    return Funs.DB.SendEmailTemplate.FirstOrDefault(x => x.EmailNotifier == EmailNotifier && x.EmailType == 0);
        //}
        //#endregion
    }
}