using System.Collections.Generic;
using IBatisNet.DataMapper;
using SEIeSCM.Models.Dto.SysLogin;
using SEIeSCM.Models.Dto;
using System;

using System.Net;
using System.Net.Mail;
using System.Text.RegularExpressions;
using EC_Comware;

namespace SEIeSCM.Models.Repository.SysLogin
{
    public class SysLoginRepository : SysLoginRepository_I
    {

        public int SelectInt(string SqlMap, SysDto SLD)
        {
            return Mapper.Instance().QueryForObject<int>(SqlMap, SLD);
        }

        public string SelectString(string SqlMap, SysDto SLD)
        {
            return Mapper.Instance().QueryForObject<string>(SqlMap, SLD);
        }

        public SysDto Select(string SqlMap, SysDto SLD)
        {
            return Mapper.Instance().QueryForObject<SysDto>(SqlMap, SLD);
        }

        public IList<SysDto> SelectList(string SqlMap, SysDto SLD)
        {
            return Mapper.Instance().QueryForList<SysDto>(SqlMap, SLD);
        }

        // 신규저장
        public void Insert(string SqlMap, SysDto SLD)
        {
            try
            {
                Mapper.Instance().Insert(SqlMap, SLD);
            }
            catch { }
        }


        // 수정
        public void Update(string SqlMap, SysDto SLD)
        {
            Mapper.Instance().Update(SqlMap, SLD);
        }

        // 삭제
        public void Delete(string SqlMap, SysDto SLD)
        {
            Mapper.Instance().Delete(SqlMap, SLD);
        }

        public void Begin()
        {
            Mapper.Instance().BeginTransaction();
        }

        public void Commit()
        {
            Mapper.Instance().CommitTransaction();
        }

        public void RollBack()
        {
            Mapper.Instance().RollBackTransaction();
        }

        public string ValidateUser(string strCompanyCd, string strUserId, string strPwd)
        {
            //SysDto dto = (SysDto)Mapper.Instance().QueryForObject("Sys.ValidateUser", new SysDto { GV_CompanyCd = strCompanyCd, GV_UserId = strUserId, GV_Pwd = strPwd });
            SysDto dto = (SysDto)Mapper.Instance().QueryForObject("Sys.ValidateUser", new SysDto { Sy_CompanyCd = strCompanyCd, Sy_UserId = strUserId, Sy_UserPwd = strPwd });

            if (dto != null)
            {
                return dto.Sy_Valid;
            }
            else
            {
                return "Non";
            }
        }

        public void SetHisLogin(string strUserId, string strUserIp, string strUserAgent, string strUserCulture)
        {
            if (strUserIp.Length > 20)
                strUserIp = strUserIp.Substring(0, 20);

            if (strUserAgent.Length > 500)
                strUserAgent = strUserAgent.Substring(0, 500);

            if (strUserCulture.Length > 20)
                strUserCulture = strUserCulture.Substring(0, 20);

            //Mapper.Instance().Insert("Account.SetHisLogin", new SysDto
            //{
            //    UserId = strUserId,
            //    UserIp = strUserIp,
            //    UserAgent = strUserAgent,
            //    UserCulture = strUserCulture
            //});
        }


        // 패스워드저장
        public string BatchPawdChange(SysDto SLD)
        {
            string msg = "";

            try
            {
                Mapper.Instance().BeginTransaction();
                // 비용마스터 처리
                Mapper.Instance().Update("Sys.UserPwChange", SLD);
                
                msg = "Save success!!!";
                Mapper.Instance().CommitTransaction();
            }
            catch (Exception e)
            {
                msg = "Capture this screen and send to admin!!!\n" + e.ToString();

                Mapper.Instance().RollBackTransaction();
            }

            return msg;
        }

        
    }
}