using System.Collections.Generic;
using IBatisNet.DataMapper;
using SEIeSCM.Models.Dto.SCMNT;
using SEIeSCM.Models.Dto;
using System;
using System.Text;
using System.Net;
using System.Net.Mail;
using System.Text.RegularExpressions;
using EC_Comware;
using SEIeSCM.Common;

namespace SEIeSCM.Models.Repository.SCMNT
{
    public class SCMNTRepository : SCMNTRepository_I
    {

        //DropDownCodeList
        public IList<CommonDto> DropDownCodeList(string SqlMap, CommonDto ComnD)
        {
            return Mapper.Instance().QueryForList<CommonDto>(SqlMap, ComnD);
        }
        
        // 조회
        public SCMNTDto Select(string SqlMap, SCMNTDto MD)
        {
            return Mapper.Instance().QueryForObject<SCMNTDto>(SqlMap, MD);
        }

        // 조회 List
        public IList<SCMNTDto> SelectList(string SqlMap, SCMNTDto MD)
        {
            return Mapper.Instance().QueryForList<SCMNTDto>(SqlMap, MD);
        }
        public IList<SCMNTDto> List(string SqlMap, SCMNTDto MD)
        {
            return Mapper.Instance().QueryForList<SCMNTDto>(SqlMap, MD);
        }

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

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

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

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

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

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

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



        //출고처리저장
        public string MI_USERINFO_WEB_I(SCMNTDto MD)
        {
            string msg = "";

            string[] splitgubun = new string[] { "@@" };
            string[] saveData = MD.TX_GRIDDATA.Substring(0, (MD.TX_GRIDDATA.Length - 1)).Split(splitgubun, StringSplitOptions.None);

            string[] tempData;

            string s_SoNo = "";
            //string s_NO_SCMDL_OR = "";
            //string s_NO_SCMDL_CUST = "";

            try
            {
                Mapper.Instance().BeginTransaction();
                
                // 그리드 세부내용 처리 
                foreach (string obj in saveData)
                {
                    tempData = null;
                    tempData = obj.Split('^');
                    
                    MD.KS_SABUN  = tempData[0].ToString();
                    MD.KS_NAME   = tempData[1].ToString();
                    MD.KS_ID     = tempData[2].ToString();
                    MD.KS_PASSWD = tempData[3].ToString();
                    MD.StoreCode = tempData[4].ToString();
                    
                    Mapper.Instance().Insert("SCMNT.SP_MI_USERIFO_WEB_I", MD);

                    tempData = null;

                }

                msg = "Y^" + s_SoNo;
                Mapper.Instance().CommitTransaction();
            }
            catch (Exception e)
            {
                msg = "Capture this screen and send to admin!!!\n" + e.ToString();
                Mapper.Instance().RollBackTransaction();
            }

            return msg;
        }
        

        public string MI_USERINFO_WEB_D_D(SCMNTDto MD)
        {
            string msg = "";

            try
            {
                Mapper.Instance().BeginTransaction();
                Mapper.Instance().Delete("SCMNT.SP_MI_USERINFO_WEB_D_D", MD);
                msg = "삭제 되었습니다.";
                Mapper.Instance().CommitTransaction();
            }
            catch (Exception e)
            {
                Mapper.Instance().RollBackTransaction();
                msg = e.ToString();
            }

            return msg;
        }

        public void SimpleSave(string SqlMap, SCMNTDto MD)
        {
            Mapper.Instance().Insert(SqlMap, MD);
        }
        
        public string SCM_NOTICE_D(SCMNTDto MD)
        {
            string msg = "";

            try
            {
                Mapper.Instance().BeginTransaction();
                Mapper.Instance().Delete("SCMNT.SP_SCM_NOTICE_D", MD);
                msg = "삭제 되었습니다.";
                Mapper.Instance().CommitTransaction();
            }
            catch (Exception e)
            {
                Mapper.Instance().RollBackTransaction();
                msg = e.ToString();
            }

            return msg;
        }
    }
}