EVCB_OCPP.Common/EVCB_OCPP.Domain/Models/Database/TransactionRecord.cs

namespace EVCB_OCPP.Domain.Models.Database
{
    using Microsoft.EntityFrameworkCore;
    using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;

    /// <summary>
    /// 交易紀錄
    /// </summary>
    [Table("TransactionRecord")]
    [Index(nameof(ConnectorId), nameof(ChargeBoxId), nameof(StartTime) , IsUnique = true)]
    public partial class TransactionRecord
    {
        public TransactionRecord()
        {
            StartIdTag = string.Empty;
            StopIdTag = string.Empty;
            StartTime = new DateTime(1991, 1, 1);
            StopTime = new DateTime(1991, 1, 1);
            ReservationId = -1;
            BillingDone = false;
            CreatedOn = new DateTime(1991, 1, 1);
            UpdatedOn = new DateTime(1991, 1, 1);
            StartTransactionReportedOn = new DateTime(1991, 1, 1);
            StopTransactionReportedOn = new DateTime(1991, 1, 1);
            ErrorMsg = string.Empty;
        }

        [Key]
        public Int32 Id { get; set; }

        /// <summary>
        /// 客戶代碼
        /// </summary>
        [Required]
        public Guid CustomerId { get; set; }



        /// <summary>
        /// 槍號  1 byte string、本來是 string、改為byte
        /// </summary>
        [Required]
        //[Index("IX_1202_Issue_Report", Order = 2, IsUnique = true)]
        public byte ConnectorId { get; set; }



        /// <summary>
        /// chargePointSerialNumber
        /// </summary>
        //[Index("IX_MachineId")]
        //[Index("IX_1202_Issue_Report", Order = 1, IsUnique = true)]
        [Required]
        [StringLength(50)]
        public string ChargeBoxId { get; set; }

        /// <summary>
        /// StartIdTag
        /// </summary>
        [StringLength(20)]
        public string StartIdTag { get; set; }


        /// <summary>
        /// StopIdTag
        /// </summary>
        [StringLength(20)]
        public string StopIdTag { get; set; }

        /// <summary>
        /// 開始充電開始時間
        /// </summary>
        //[Index("IX_1202_Issue_Report", Order = 3, IsUnique = true)]
        public DateTime StartTime { get; set; }

        /// <summary>
        /// 充電結束時間
        /// </summary>
        public DateTime StopTime { get; set; }

        /// <summary>
        /// 預約Id
        /// </summary>
        public int ReservationId { set; get; }

        /// <summary>
        /// 停止原因No
        /// </summary>
        public int StopReasonId { set; get; }

        /// <summary>
        /// 停止原因
        /// </summary>
        [StringLength(60)]
        public string StopReason { set; get; }



        /// <summary>
        /// 開始meter
        /// </summary>
        [DataType("decimal(16 ,2)")]
        public decimal MeterStart { get; set; }

        /// <summary>
        /// 結束meter
        /// </summary>
        [DataType("decimal(16 ,2)")]
        public decimal MeterStop { get; set; }

        /// <summary>
        /// 產生時間
        /// </summary>
        public DateTime CreatedOn { get; set; }

        /// <summary>
        /// 更新時間
        /// </summary>
        public DateTime UpdatedOn { get; set; }


        /// <summary>
        /// 開始充電的回報時間
        /// </summary>
        public DateTime StartTransactionReportedOn { get; set; }

        /// <summary>
        /// 開始充電回報的次數
        /// </summary>
        public int RetryStartTransactionTimes { get; set; }

        /// <summary>
        /// 結束充電的回報時間
        /// </summary>
        public DateTime StopTransactionReportedOn { get; set; }

        /// <summary>
        /// 結束充電回報的次數
        /// </summary>
        public int RetryStopTransactionTimes { get; set; }

        /// <summary>
        /// 回調客戶API，問題紀錄
        /// </summary>
        public string ErrorMsg { set; get; }

        /// <summary>
        /// 計費完成與否
        /// </summary>
        public bool BillingDone { set; get; }

        /// <summary>
        /// 是否上傳到TTIA
        /// </summary>
        public bool UploadedtoTTIA { set; get; }

        [DataType("decimal(16 ,2)")]
        public decimal Cost { set; get; }

        /// <summary>
        /// 收費明細
        /// </summary>
        [StringLength(3000)]
        public string Receipt { set; get; }

        /// <summary>
        /// 收費標準
        /// </summary>
        [StringLength(1500)]
        public string Fee { set; get; }





    }
}