using System.Data.OracleClient;

namespace CCSTrace.CCS.Object
{
    public class EventRecord
    {
        //private CCS.Function.TransferDate Convert = new CCS.Function.TransferDate();

        public EventRecord(int mCaseId, OracleConnection conn, OracleTransaction trx)
        {
            CaseId = mCaseId;
            LocateEquipment = new LocateEquipment(CaseId, false, conn, trx);
        }

        public LocateEquipment LocateEquipment { get; }

        public int CaseId { get; }

        public string Name { get; set; } = "";

        public string Meter { get; set; } = "";

        public string Tel { get; set; } = "";

        public string Addr { get; set; } = "";

        public string Brief { get; set; } = "";

        public string Log { get; set; } = "";

        public int Dept { get; set; } = 0;

        public string AcceptNum { get; set; }

        public string AcceptDate { get; set; }

        public int TraceFinish { get; set; } = 0;

        public int Fsc { get; set; } = 0;

        public int Ufid { get; set; } = 0;

        public int FdrId { get; set; } = 0;

        public int ParentId { get; set; } = 0;

        public int ImportCase { get; set; }

        public string Note { get; set; } = "";

        public int IsReCall { get; set; }

        public string ReCallTel { get; set; } = "";

        public string ReCallName { get; set; } = "";

        public int Level { get; set; } = 0;


        public int TmpCaseId { get; set; } = 0;

        public bool IsDespatched { get; set; }

        public string Tpclid { get; set; } = "";

        public void SetIsDespatched(bool mDespatched)
        {
            IsDespatched = mDespatched;
        }

        public string GetSqlStmt()
        {
            var sqlStmt = "INSERT INTO EOS.EVENTRECORD VALUES (" + CaseId + ",'" + Name + "','" + Meter + "','" + Tel +
                          "','" + Addr + "','" + Brief + "'," + Dept + ",'" + Log + "','" + AcceptNum + "',to_date('"
                          + AcceptDate + "','yyyy/mm/dd hh24:mi:ss')," + Fsc + "," + Ufid + "," + FdrId + "," +
                          TraceFinish + "," + ImportCase + ",'" + Note + "'," + IsReCall + ",'"
                          + ReCallTel + "','" + ReCallName + "'," + Level + ")";

            return sqlStmt;
        }

        //}
        //    return SqlStmt;
        //            + getReCallName() + "',CASELEVEL = " + getLevel() + ",DEPT = " + getDept() + " WHERE CASEID = " + getCaseID();
        //            + ",NOTE = '" + getNote() + "',ISRECALL = " + getisReCall() + ",RECALLTEL = '" + getReCallTel() + "',RECALLNAME = '"

        //    SqlStmt = "UPDATE EOS.EVENTRECORD SET CUSTOMERADDR = '" + getAddr() + "',EVENTBRIEF = '" + getBrief() + "',IMPORTCASE = " + getImportCase()
        //    String SqlStmt;
        //{

        //public String getUpdateSqlStmt()
    }
}