using System;
using CLIP.eForm.Server.Data;
using CLIP.eForm.Server.VO;
using IBatisNet.DataMapper;
using System.Collections.Generic;
using System.Collections;
using CLIP.eForm.Consent.Entity;

namespace CLIP.eForm.Consent.Dac {
  public class SaveConsentDac : DacBase {
    public int InsertConsentMst(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject<Int32>("INSERT_CONSENT_MST", param);
    }

    public int ReWriteUpdateConsentMst(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject<Int32>("REWRITE_UPDATE_CONSENT_MST", param);
    }

    public void InsertConsentData(ISqlMapper mapper, Hashtable param) {
      mapper.QueryForObject<Int32>("INSERT_CONSENT_DATA", param);
    }

    public void InsertConsentAudio(ISqlMapper mapper, Hashtable param) {
      mapper.QueryForObject<Int32>("INSERT_CONSENT_AUDIO", param);
    }

    public void InsertConsentImage(ISqlMapper mapper, Hashtable param) {
      mapper.QueryForObject<Int32>("INSERT_CONSENT_IMAGE", param);
    }

    public void InsertConsentImageSign(ISqlMapper mapper, Hashtable param) {
      mapper.QueryForObject<Int32>("INSERT_CONSENT_IMAGE_SIGN", param);
    }

    public void UpdateConsentMst(ISqlMapper mapper, Hashtable param) {
      mapper.QueryForObject<Int32>("UPDATE_CONSENT_MST", param);
    }

    public void UpdateConsentData(ISqlMapper mapper, Hashtable param) {
      mapper.QueryForObject<Int32>("UPDATE_CONSENT_DATA", param);
    }

    public void UpdateConsentMstForReissue(ISqlMapper mapper, Hashtable param) {
      mapper.QueryForObject<Int32>("UPDATE_CONSENT_MST_FOR_REISSUE", param);
    }

    public String UpdateConsentMstForDelete(ISqlMapper mapper, Hashtable param) {
      //return mapper.Update("UPDATE_CONSENT_MST_FOR_DELETE", param);
      return (String) mapper.Insert("UPDATE_CONSENT_MST_FOR_DELETE", param);
    }

    public int UpdateMrfhocrprntStatCd(ISqlMapper mapper, Hashtable param) {
      return mapper.Update("UPDATE_MRFHOCRPRNT_STATCD", param);
    }

    public void UpdateConsentMstStatus(ISqlMapper mapper, Hashtable param) {
      mapper.QueryForObject<Int32>("UPDATE_CONSENT_MST_STATUS", param);
    }

    public void SetConsentDataChoice(ISqlMapper mapper, Hashtable param) {
      mapper.QueryForObject<Int32>("INSERT_CONSENT_DATA_CHOICE", param);
    }

    public void SetMediHistory(ISqlMapper mapper, Hashtable param) {
      mapper.QueryForObject<Int32>("SET_MEDI_HISTORY", param);
    }

    /// <summary>
    /// OCR 히스토리 테이블 저장
    /// </summary>
    /// <param name="mapper"></param>
    /// <param name="param"></param>
    public void InsertPrintData(ISqlMapper mapper, Hashtable param) {
      mapper.Insert("setOcrPrntInfo", param);
      mapper.Insert("setOcrPrntHistInfo", param);
    }

    public void InsertPrintData(ISqlMapper mapper, Hashtable param, bool isNewConsentMasterCase) {

      //string histYN = mapper.QueryForObject<String>("getOcrPrntHistYN", param);
      //histYN = histYN ?? "Y";
      mapper.Insert("setOcrPrntInfo", param);
      if (isNewConsentMasterCase == false) {
        mapper.Update("updateOcrPrntHistInfo", param);
      }
      mapper.Insert("setOcrPrntHistInfo", param);

      //if (histYN.Equals("Y")) {

      //}
    }

    public void InsertPmcmspif(ISqlMapper mapper, Hashtable param) {
      mapper.Insert("insPmcmspif", param);
    }

    public void InsertPmihagmt(ISqlMapper mapper, Hashtable param) {
      mapper.Insert("insPmihagmt", param);
    }

    public void InsertPmcminfo(ISqlMapper mapper, Hashtable param) {
      mapper.Insert("insPmcminfo", param);
    }

    public IList<string> getOcrType6Forms(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForList<string>("getOcrType6Forms", param);
      //return null;
    }

    /// <summary>
    /// 개인정보동의서 인증저장시 PAM.PMCMPICM에 넣을 SEQ 번호를 가져온다
    /// </summary>
    /// <param name="mapper"></param>
    /// <param name="param"></param>
    /// <returns></returns>
    public int getPamSeqNo(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject<int>("getPamSeqNo", param);
    }

    public int updatePreSignData(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject<int>("updatePreSignData", param);
    }

    public int insPmcmpicm(ISqlMapper mapper, Hashtable param) {
      return (Int32)mapper.QueryForObject<int>("insPmcmpicm", param);
    }

    public int SaveAutoCompleteAll(ISqlMapper mapper, Hashtable param) {
      int result = 0;

      result = mapper.Update("SAVE_AUTO_MASTER_UPDATE", param);
      if (result > 0) {
        result = mapper.Update("SAVE_AUTO_MRFMOCRPRNT", param);
      }
      
      if (result > 0) {
        result = mapper.Update("SAVE_AUTO_MRFHOCRPRNT", param);
      }
      
      return result;
    }

    public int ImrCount(ISqlMapper mapper, Hashtable param) {
      return (Int32) mapper.QueryForObject<int>("ImrCount", param);
    }

    public ImrData ImrData(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject<ImrData>("ImrData", param);
    }

    public int ImrScanFileUpdate(ISqlMapper mapper, Hashtable param) {
      return mapper.Update("ImrUpdate", param);
    }

    public int ImrScanFileDelete(ISqlMapper mapper, Hashtable param) {
      return mapper.Delete("ImrDelete", param);
    }

  }
}