using System.Collections.Generic;
using IBatisNet.DataMapper;
using SEIeSCM.Models.Dto.POPUP;
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.POPUP
{
    public class POPUPRepository : POPUPRepository_I
    {

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

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

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

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

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

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

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

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

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

        
    }
}