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

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

namespace SEIeSCM.Models.Repository.Home
{
    public class HomeRepository : HomeRepository_I
    {

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

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

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

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

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


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

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

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

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

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

        
    }
}