#region Copyright © 2015 CLIPSOFT Co.,Ltd. All Rights Reserved.
//
// All rights are reserved. Reproduction or transmission in whole or in part, 
// in any form or by any means, electronic, mechanical or otherwise, is 
// prohibited without the prior written consent of the copyright owner.
//
// Filename:SelectConsentSvcDac.cs
//
#endregion
using CLIP.eForm.Consent.Entity;
using CLIP.eForm.Server.Data;
using IBatisNet.DataMapper;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace CLIP.eForm.Consent.Dac {
  public class ConsentDac : DacBase {
    public IList<ConsentVO> GetConsentSetList(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForList<ConsentVO>("getUserFormSet", param);
    }

    public IList<ConsentVO> GetConsentBySearch(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForList<ConsentVO>("GET_CONSENT_BY_SEARCH_LIST", param);
    }

    public IList<ConsentVO> GetConsentList(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForList<ConsentVO>("GET_CONSENT_LIST", param);
    }

    public IList<ConsentVO> GetConsentDateList(ISqlMapper mapper, Hashtable param) {
      //consent_mst에 visit_type을 조건에 추가해야함
      String ordType      = (String) param["ordType"];
      String patientState = (String) param["patientState"];
      if (ordType == "I") {
        return mapper.QueryForList<ConsentVO>("GET_CONSENT_IN_LIST", param);
      } else if (ordType == "O") {
        return mapper.QueryForList<ConsentVO>("GET_CONSENT_OUT_LIST", param);
      } else if (ordType == "ER") {
        return mapper.QueryForList<ConsentVO>("GET_CONSENT_ER_LIST", param);
      } else if (ordType == "OP") {
        return mapper.QueryForList<ConsentVO>("GET_CONSENT_OP_LIST", param);
      } else if (ordType == "EX") {
        return mapper.QueryForList<ConsentVO>("GET_CONSENT_EX_LIST", param);
      } else if (ordType == "S") {
        if (patientState == "I") {
          return mapper.QueryForList<ConsentVO>("GET_CONSENT_IN_LIST", param);
        } else if (patientState == "O") {
          return mapper.QueryForList<ConsentVO>("GET_CONSENT_OUT_LIST", param);
        } else if (patientState == "ER") {
          return mapper.QueryForList<ConsentVO>("GET_CONSENT_ER_LIST", param);
        }
      }
      return null;
    }

    public IList<ConsentVO> GetPrescriptionConsentList(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForList<ConsentVO>("GET_PRESCRIPTION_CONSENT_LIST", param);
    }

    public object GetFormGuidByFormCd(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject("GET_FORM_GUID_BY_FORM_CD", param);
    }

    public IList<ConsentImageVO> GetConsentImage(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForList<ConsentImageVO>("GET_CONSENT_IMAGE", param);
    }

    public IList<ConsentImageVO> getConsentAudio(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForList<ConsentImageVO>("GET_CONSENT_AUDIO", param);
    }

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

    public IList<UnFinishedListVO> GetUnfinishedListPerDoctor(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForList<UnFinishedListVO>("GetUnfinishedListPerDoctor", param);
    }
    public String GetConsentStateCheck(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject<String>("GetConsentStateCheck", param);
    }
    //public IList<ConsentBySearchVO> GetConsentByCalcscorcd(ISqlMapper mapper, Hashtable param) {
    //  return mapper.QueryForList<ConsentBySearchVO>("GET_CONSENT_BY_CALCSCORCD", param);
    //}

    public IList<ConsentVO> getConsentByFormcd(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForList<ConsentVO>("GET_CONSENT_BY_FORMCD", param);
    }

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

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

    /// <summary>
    /// 원무 서식의 인증저장 사용 여부
    /// </summary>
    /// <param name="mapper">SQL mapper</param>
    /// <param name="param">The parameter.</param>
    /// <returns></returns>
    public String getCertuseYn(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject<String>("GET_CERTUSEYN", param);
    }

    /// <summary>
    /// 원무 서식의 인증저장 사용 여부
    /// 서식이 여러개 선택되었을때
    /// </summary>
    /// <param name="mapper">SQL mapper</param>
    /// <param name="param">The parameter.</param>
    /// <returns></returns>
    public String getCertUseYnData(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject<String>("GET_CERTUSEYN_MAP", param);
    }

    /// <summary>
    /// 동의서가 금일 작성되었는지 여부 확인 formCd 반환
    /// </summary>
    /// <param name="mapper">SQL mapper</param>
    /// <param name="param">The parameter.</param>
    /// <returns></returns>
    public String getDupCertConsent(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject<String>("GET_RESULT", param);
    }

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

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

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

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

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

    /// <summary>
    /// 경북대학교병원 accu 모니터 설치 사용자 여부
    /// </summary>
    /// <param name="mapper"></param>
    /// <param name="param"></param>
    /// <returns></returns>
    public String getDualViewMode(ISqlMapper mapper, Hashtable param) {
      return mapper.QueryForObject<String>("GET_DUAL_MODE", param);
    }

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

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

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

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

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

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