using Common;
using Model;
using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Text;

namespace Dao
{
  public class GwClientPayMentDao : IDisposable
  {
    public bool Update(GwClientPayMent item)
    {
      return OracleHelper.ExecuteSql("update GW_CLIENT_PAYMENT SET PAYMENT_NAME=:PAYMENT_NAME,RECEIVER_NAME=:RECEIVER_NAME,ACCOUNT=:ACCOUNT,PARTERNER_ID=:PARTERNER_ID,KEY=:KEY,IS_ENABLED=:IS_ENABLED WHERE PAYMENT_ID=:PAYMENT_ID", OracleHelper.Connection, new OracleParameter(":PAYMENT_ID", (object) item.PayMentID), new OracleParameter(":PAYMENT_NAME", (object) item.PayMentName), new OracleParameter(":RECEIVER_NAME", (object) item.ReceiverName), new OracleParameter(":ACCOUNT", (object) item.Account), new OracleParameter(":PARTERNER_ID", (object) item.PartnerID), new OracleParameter(":KEY", (object) item.Key), new OracleParameter(":IS_ENABLED", (object) item.IsEnabled)) > 0;
    }

    public bool Delete(int payMentID)
    {
      return OracleHelper.ExecuteSql("delete from GW_CLIENT_PAYMENT WHERE PAYMENT_ID=:PAYMENT_ID", OracleHelper.Connection, new OracleParameter(":PAYMENT_ID", (object) payMentID)) > 0;
    }

    public GwClientPayMent GetPayMentInfo(int payMentID)
    {
      GwClientPayMent o = new GwClientPayMent();
      using (OracleDataReader reader = OracleHelper.ExecuteReader("SELECT * FROM GW_CLIENT_PAYMENT WHERE PAYMENT_ID=:PAYMENT_ID", OracleHelper.Connection, new OracleParameter(":PAYMENT_ID", (object) payMentID)))
      {
        if (reader != null && ((DbDataReader) reader).Read())
          this.ReadInfo(reader, o);
      }
      return o;
    }

    public List<GwClientPayMent> LoadPayEnabledList()
    {
      List<GwClientPayMent> list = new List<GwClientPayMent>();
      try
      {
        StringBuilder stringBuilder = new StringBuilder();
        stringBuilder.Append("SELECT * FROM GW_CLIENT_PAYMENT WHERE IS_ENABLED=0 ");
        using (OracleDataReader reader = OracleHelper.ExecuteReader(stringBuilder.ToString(), OracleHelper.Connection))
        {
          while (((DbDataReader) reader).Read())
          {
            GwClientPayMent o = new GwClientPayMent();
            if (this.ReadInfo(reader, o))
              list.Add(o);
          }
        }
      }
      catch (Exception ex)
      {
        LogHelper.Error(ex);
        return list;
      }
      return list;
    }

    public List<GwClientPayMent> LoadPayList()
    {
      List<GwClientPayMent> list = new List<GwClientPayMent>();
      try
      {
        StringBuilder stringBuilder = new StringBuilder();
        stringBuilder.Append("SELECT * FROM GW_CLIENT_PAYMENT");
        using (OracleDataReader reader = OracleHelper.ExecuteReader(stringBuilder.ToString(), OracleHelper.Connection))
        {
          while (((DbDataReader) reader).Read())
          {
            GwClientPayMent o = new GwClientPayMent();
            if (this.ReadInfo(reader, o))
              list.Add(o);
          }
        }
      }
      catch (Exception ex)
      {
        LogHelper.Error(ex);
        return list;
      }
      return list;
    }

    public bool Add(GwClientPayMent item)
    {
      return OracleHelper.ExecuteSql("INSERT INTO GW_CLIENT_PAYMENT(PAYMENT_ID,PAYMENT_NAME,RECEIVER_NAME,ACCOUNT,PARTERNER_ID,KEY,IS_ENABLED) VALUES(GW_CLIENT_PAYMENT_SEQ.nextval,:PAYMENT_NAME,:RECEIVER_NAME,:ACCOUNT,:PARTERNER_ID,:KEY,:IS_ENABLED)", OracleHelper.Connection, new OracleParameter(":PAYMENT_NAME", (object) item.PayMentName), new OracleParameter(":RECEIVER_NAME", (object) item.ReceiverName), new OracleParameter(":ACCOUNT", (object) item.Account), new OracleParameter(":PARTERNER_ID", (object) item.PartnerID), new OracleParameter(":KEY", (object) item.Key), new OracleParameter(":IS_ENABLED", (object) item.IsEnabled)) > 0;
    }

    private bool ReadInfo(OracleDataReader reader, GwClientPayMent o)
    {
      OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader);
      o.PayMentID = oracleReaderWrapper.GetInt("PAYMENT_ID", 0);
      o.PayMentName = oracleReaderWrapper.GetString("PAYMENT_NAME", "");
      o.ReceiverName = oracleReaderWrapper.GetString("RECEIVER_NAME", "");
      o.Account = oracleReaderWrapper.GetString("ACCOUNT", "");
      o.PartnerID = oracleReaderWrapper.GetString("PARTERNER_ID", "");
      o.Key = oracleReaderWrapper.GetString("KEY", "");
      o.IsEnabled = oracleReaderWrapper.GetInt("IS_ENABLED", 0);
      return true;
    }

    public void Dispose()
    {
    }
  }
}