using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.OracleClient;

namespace CCSTrace.CCS.Object
{
    public class EventQuery
    {
        private String CCSID;
        private String Meter;
        private int CaseStatus;
        private String ChangeTime;
        private String HandlingSummary;
        private String AssumedTime;
        private String AssumedTime_Nth;
        private int DelayTimes = 0;
        private String Reason;
        private String EventLocation = "";
        //private CCS.Function.TransferDate convert = new CCS.Function.TransferDate();

        public EventQuery()
        {
        }

        public void setCCSID(String m_CCSID)
        {
            this.CCSID = m_CCSID;
        }

        public String getCCSID()
        {
            return this.CCSID;
        }

        public void setMeter(String m_Meter)
        {
            this.Meter = m_Meter;
        }

        public String getMeter()
        {
            return this.Meter;
        }

        /**
         * @return Returns the eventLocation.
         */
        public String getEventLocation()
        {
            return EventLocation;
        }

        /**
         * @param m_eventLocation The eventLocation to set.
         */
        public void setEventLocation(String m_eventLocation)
        {
            EventLocation = m_eventLocation;
        }

        public void setCaseStatus(int m_CaseStatus)
        {
            this.CaseStatus = m_CaseStatus;
        }

        public void setChangeTime(String m_ChangeTime)
        {
            this.ChangeTime = m_ChangeTime;
        }

        public String getChangeTime()
        {
            return this.ChangeTime;
        }

        public void setHandlingSummary(String m_HandlingSummary)
        {
            this.HandlingSummary = m_HandlingSummary;
        }

        public String getHandlingSummary()
        {
            return this.HandlingSummary;
        }

        public void setAssumedTime(String m_AssumedTime)
        {
            this.AssumedTime = m_AssumedTime;
        }

        public String getAssumedTime()
        {
            return this.AssumedTime;
        }

        public void setAssumedTime_Nth(String m_AssumedTime_Nth)
        {
            this.AssumedTime_Nth = m_AssumedTime_Nth;
        }

        public String getAssumedTime_Nth()
        {
            return this.AssumedTime_Nth;
        }

        public void setDelayTimes(int m_DelayTimes)
        {
            this.DelayTimes = m_DelayTimes;
        }

        public int getDelayTimes()
        {
            return this.DelayTimes;
        }

        public void setReason(String m_Reason)
        {
            this.Reason = m_Reason;
        }

        public String getReason()
        {
            return this.Reason;
        }

        public bool Insert(RecordLog _PLog, OracleConnection _Conn, OracleTransaction _Transaction)
        {
            String SqlStmt;

            if (!Check())
            {
                return false;
            }

            if (Meter == null)
            {
                SqlStmt = "INSERT INTO CCS.EVENTQUERY (CCSID,CASESTATUS,CHANGETIME,ASSUMEDTIME,ASSUMEDTIME_NTH,DELAYTIMES,REASON,INPUTTIME) values(" + "'" + CCSID
                        + "'," + CaseStatus + ",to_date('" + ChangeTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('"
                        + AssumedTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('" + AssumedTime_Nth + "','yyyy/mm/dd hh24:mi:ss')," + DelayTimes + ",'" + Reason + "',SYSDATE)";
            }
            else
            {
                SqlStmt = "INSERT INTO CCS.EVENTQUERY (CCSID,METER,CASESTATUS,CHANGETIME,ASSUMEDTIME,ASSUMEDTIME_NTH,DELAYTIMES,REASON,INPUTTIME) values(" + "'"
                        + CCSID + "','" + Meter + "'," + CaseStatus + ",to_date('" + ChangeTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('" + AssumedTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('"
                        + AssumedTime_Nth + "','yyyy/mm/dd hh24:mi:ss')," + DelayTimes + ",'" + Reason + "',SYSDATE)";

            }

            OracleCommand Command = new OracleCommand(SqlStmt, _Conn, _Transaction);

            try
            {
                if (Command.ExecuteNonQuery() > 0)
                    return true;
                else
                    return false;
            }
            catch (Exception e)
            {
                _PLog.Error(e.Message);
                Console.WriteLine(e.StackTrace);
                return false;
            }
            finally
            {
                Command.Dispose();
            }
        }

        public bool Insert(SEventLog _PLog, OracleConnection _Conn, OracleTransaction _Transaction)
        {
            String SqlStmt;

            if (!Check())
            {
                return false;
            }

            if (Meter == null)
            {
                SqlStmt = "INSERT INTO CCS.EVENTQUERY (CCSID,CASESTATUS,CHANGETIME,ASSUMEDTIME,ASSUMEDTIME_NTH,DELAYTIMES,REASON,INPUTTIME) values(" + "'" + CCSID
                        + "'," + CaseStatus + ",to_date('" + ChangeTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('"
                        + AssumedTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('" + AssumedTime_Nth + "','yyyy/mm/dd hh24:mi:ss')," + DelayTimes + ",'" + Reason + "',SYSDATE)";
            }
            else
            {
                SqlStmt = "INSERT INTO CCS.EVENTQUERY (CCSID,METER,CASESTATUS,CHANGETIME,ASSUMEDTIME,ASSUMEDTIME_NTH,DELAYTIMES,REASON,INPUTTIME) values(" + "'"
                        + CCSID + "','" + Meter + "'," + CaseStatus + ",to_date('" + ChangeTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('" + AssumedTime + "','yyyy/mm/dd hh24:mi:ss'),to_date('"
                        + AssumedTime_Nth + "','yyyy/mm/dd hh24:mi:ss')," + DelayTimes + ",'" + Reason + "',SYSDATE)";
            }

            OracleCommand Command = new OracleCommand(SqlStmt, _Conn, _Transaction);

            try
            {
                if (Command.ExecuteNonQuery() > 0)
                    return true;
                else
                    return false;
            }
            catch (Exception e)
            {
                _PLog.Error(e.Message);
                Console.WriteLine(e.StackTrace);

                if (LocalVariable.ShowError)
                    _PLog.Error(e.StackTrace);

                throw e;
            }
            finally
            {
                Command.Dispose();
            }
        }


        public bool Update(RecordLog _PLog, OracleConnection _Conn, OracleTransaction _Transaction)
        {
            if (!Check())
            {
                return false;
            }

            String SqlStmt = "UPDATE CCS.EVENTQUERY SET CASESTATUS=" + this.CaseStatus + ",CHANGETIME=to_date('"
                    + this.ChangeTime + "','yyyy/mm/dd hh24:mi:ss'),ASSUMEDTIME=to_date('"
                    + this.AssumedTime + "','yyyy/mm/dd hh24:mi:ss'),ASSUMEDTIME_NTH=to_date('"
                    + this.AssumedTime_Nth + "','yyyy/mm/dd hh24:mi:ss'),DELAYTIMES=" + this.DelayTimes + ",REASON='"
                    + this.Reason + "',EVENTLOCATION ='" + this.EventLocation + "' WHERE CCSID='" + this.CCSID + "'";

            OracleCommand Command = new OracleCommand(SqlStmt, _Conn, _Transaction);

            try
            {
                if (Command.ExecuteNonQuery() <= 0)
                {
                    _PLog.Error("更新CCS.EVENTQUERY資料失敗.");
                    return false;
                }
            }
            catch (Exception e)
            {
                _PLog.Error(e.Message);
                Console.WriteLine(e.StackTrace);
                return false;
            }
            finally
            {
                Command.Dispose();
            }

            return true;
        }

        public bool UpdateCaseStatus(SEventLog _PLog, OracleConnection _Conn, OracleTransaction _Transaction)
        {
            String SqlStmt = "UPDATE CCS.EVENTQUERY SET CASESTATUS = " + CaseStatus + " WHERE CCSID = '" + CCSID + "'";

            OracleCommand Command = new OracleCommand(SqlStmt, _Conn, _Transaction);

            try
            {
                if (Command.ExecuteNonQuery() <= 0)
                {
                    _PLog.Error("更新CCS.EVENTQUERY的CASESTATUS失敗.");
                    return false;
                }
            }
            catch (Exception e)
            {
                _PLog.Error(e.Message);
                Console.WriteLine(e.StackTrace);

                if (LocalVariable.ShowError)
                    _PLog.Error(e.StackTrace);

                throw e;
            }
            finally
            {
                Command.Dispose();
            }

            return true;
        }

        // Not Null Check
        private bool Check()
        {
            if (CCSID == null)
            {
                return false;
            }

            if (CaseStatus == 0)
            {
                return false;
            }
            Reason = (Reason == null ? "" : Reason);
            return true;
        }


    }
}