using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using sbcLabSystem.Data.Domain.Account;
using PalGain.Core;
using BatchService.Framework.Utility;
using System.Data;
using sbcLabSystem.Data.Domain.Backstage;

namespace sbcLabSystem.Service.Account
{
    public class AccountService
    {
        private IRespository<UserInfo> _users;
        private IRespository<RoleInfo> _roles;
        private IRespository<ResourceInfo> _resources;
        private IRespository<UserRequestInfo> _UserRequestInfo;
        private IRespository<Menus> _Menusinfo;
        private IRespository<EmileInfo> _EmileInfo;
        private IRespository<EmailSmtpInfo> _emailSmtpInfo;

        public AccountService(IRespository<UserInfo> i_users,
            IRespository<RoleInfo> i_roles,
            IRespository<ResourceInfo> i_resources,
            IRespository<UserRequestInfo> i_UserRequestInfo,
            IRespository<Menus> i_Menus,
            IRespository<EmileInfo> i_EmileInfo,
            IRespository<EmailSmtpInfo> i_emailSmtpInfo)
        {
            _emailSmtpInfo = i_emailSmtpInfo;
            _users = i_users;
            _roles = i_roles;
            _resources = i_resources;
            _UserRequestInfo = i_UserRequestInfo;
            _Menusinfo = i_Menus;
            _EmileInfo = i_EmileInfo;
        }
        public string GetCurrentMaxLabCode()
        {
            var labList = this.GetAllUserRequestInfoQueryable()
                .Where(p => string.IsNullOrEmpty(p.LabCode) == false).ToList()
                .Select(p => p.LabCode.ToLower().Replace("Lab".ToLower(), "").Replace("QC".ToLower(), "")).ToList();
            int maxValue = 0;
            labList.ForEach(x =>
            {
                int tempValue = 0;
                int.TryParse(x, out tempValue);
                if (tempValue > 0 && tempValue > maxValue)
                {
                    maxValue = tempValue;
                }
            });
            return string.Format("QC{0}", maxValue + 1);
        }
        public void ConfirmLabInfo(int oriLabId,  UserRequestInfo targetLab)
        {
            UserRequestInfo oriLabInfo = PalGainEngine.Instance.Resolve<AccountService>()
                .GetAllUserRequestInfoQueryable().FirstOrDefault(p => p.Id == oriLabId);
            UserRequestInfo targetLab2 = PalGainEngine.Instance.Resolve<AccountService>()
               .GetAllUserRequestInfoQueryable().FirstOrDefault(p => p.Id == targetLab.Id);
            UserRequestInfo targetLabInfo = targetLab;
            oriLabInfo.LabName = targetLabInfo.LabName;
            oriLabInfo.CompanyName = targetLabInfo.CompanyName;
            oriLabInfo.ManagerEmail = targetLabInfo.ManagerEmail;
            oriLabInfo.ManagerFax = targetLabInfo.ManagerFax;
            oriLabInfo.ManagerMobile = targetLabInfo.ManagerMobile;
            oriLabInfo.ManagerName = targetLabInfo.ManagerName;
            oriLabInfo.ManagerPhone = targetLabInfo.ManagerPhone;
            oriLabInfo.OperatorEmail = targetLabInfo.OperatorEmail;
            oriLabInfo.OperatorFax = targetLabInfo.OperatorFax;
            oriLabInfo.OperatorMobile = targetLabInfo.OperatorMobile;
            oriLabInfo.OperatorName = targetLabInfo.OperatorName;
            oriLabInfo.OperatorPhone = targetLabInfo.OperatorPhone;
            oriLabInfo.Address = targetLabInfo.Address;
            oriLabInfo.PostCode = targetLabInfo.PostCode;
            oriLabInfo.Province = targetLabInfo.Province;
            _UserRequestInfo.Update(oriLabInfo);
            _UserRequestInfo.Delete(targetLab2);
        }
        public void InserEmilinfo(EmileInfo info)
        {
            _EmileInfo.Insert(info);
        }
        public IQueryable<EmileInfo> GetUnSentEmails()
        {
            return _EmileInfo.Table.Where(p => p.EmileState == 0 && string.IsNullOrEmpty(p.EmileName) == false);
        }
        public void SetSentStatusToEmailSentBox(EmileInfo entity)
        {
            entity.EmileState = 1;
            entity.SendOutDatetime = DateTime.Now;
            _EmileInfo.Update(entity);
        }
        public void SetErrorMessageToEmailSentBox(EmileInfo entity)
        {
            _EmileInfo.Update(entity);
        }
        public IQueryable<UserInfo> GetUsers()
        {
            return _users.Table;
        }
        public IQueryable<EmailSmtpInfo> GetEmailSmtpInfos()
        {
            return _emailSmtpInfo.Table;
        }
        public EmailSmtpInfo GetDefaultSmtpInfo()
        {
            return _emailSmtpInfo.Table.FirstOrDefault(p => p.IsDefault == true);
        }
        public UserInfo Users(int id)
        {
            return _users.GetById(id);
        }
        public void UpdeteUser(UserInfo info)
        {
            UserInfo ent = _users.GetById(info.Id);
            if (ent != null)
            {
                ent.Password = info.Password;
                _users.Update(ent);
            }
        }
        public IQueryable<RoleInfo> GetRoleInfo()
        {
            return _roles.Table;
        }
        public IQueryable<ResourceInfo> GetResourceInfo()
        {
            return _resources.Table;
        }
        public List<UserRequestInfo> GetUserRequestInfo()
        {
            return _UserRequestInfo.Table.ToList();
        }
        public IQueryable<UserRequestInfo> GetUserRequestInfoQueryable()
        {
            return _UserRequestInfo.Table.Where(p => p.State == 1);
        }
        public IQueryable<UserRequestInfo> GetAllUserRequestInfoQueryable()
        {
            return _UserRequestInfo.Table;
        }
        public UserRequestInfo UserRequestInfo(int Id)
        {
            return _UserRequestInfo.GetById(Id);
        }
        public void UpdateUserRequestInfo(UserRequestInfo info)
        {
            UserRequestInfo ent = _UserRequestInfo.GetById(info.Id);
            if (ent != null)
            { 
                ent.Remarks = info.Remarks;
                ent.LabCode = info.LabCode;
                ent.LabLoginName = info.LabLoginName;
                ent.LabName = info.LabName;
                if (!string.IsNullOrEmpty(info.LabPassword))
                {
                    ent.LabPassword = info.LabPassword;
                }
                ent.ManagerEmail = info.ManagerEmail;
                ent.ManagerFax = info.ManagerFax;
                ent.ManagerMobile = info.ManagerMobile;
                ent.ManagerName = info.ManagerName;
                ent.ManagerPhone = info.ManagerPhone;
                ent.OperatorEmail = info.OperatorEmail;
                ent.OperatorFax = info.OperatorFax;
                ent.OperatorMobile = info.OperatorMobile;
                ent.OperatorName = info.OperatorName;
                ent.OperatorPhone = info.OperatorPhone;
                ent.PostCode = info.PostCode;
                ent.ProjectId = info.ProjectId;
                ent.Province = info.Province;
                ent.State = info.State;
                ent.UpdateTime = info.UpdateTime;
                ent.Address = info.Address;
                ent.City = info.City;
                ent.CompanyName = info.CompanyName;
                ent.District = info.District;
                ent.taxNo = info.taxNo;
                _UserRequestInfo.Update(ent);
            }
        }
        public void DeleteUserRequestInfo(int Id)
        {
            UserRequestInfo info = _UserRequestInfo.Table.FirstOrDefault(p => p.Id == Id);
            if (info != null)
            {
                _UserRequestInfo.Delete(info);
            }
        }
        public List<Menus> GetMenus()
        {
            return _Menusinfo.Table.ToList();
        }
        public Menus MenusId(int ID)
        {
            return _Menusinfo.GetById(ID);
        }
        public void InsertMenu(Menus info)
        {
            _Menusinfo.Insert(info);
        }
        public void DeleteMenu(Menus info)
        {
            _Menusinfo.Delete(info);
        }
        public void UpdateMenu(Menus info)
        {
            Menus entity = _Menusinfo.GetById(info.Id);
            entity.Name = info.Name;
            entity.ParnetId = info.ParnetId;
            entity.Url = info.Url;
            entity.Category = info.Category;
            entity.Contents = info.Contents;
            entity.Title = info.Title;
            _Menusinfo.Update(entity);
        }
        public void InsertResourceInfo(ResourceInfo info)
        {
            _resources.Insert(info);
        }
        public void InsertUserRequestInfo(UserRequestInfo info)
        {
            _UserRequestInfo.Insert(info);
        }
    }
}