using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace CAPI.Custom.Entities.publ.PurchaseOrders
{
    [Table("publ_PurchaseOrders")]
    public class PurchaseOrder
    {
        [Key]
        [Column("id")]
        public int Id { get; set; }

        [Column("purchaseOrderParentId")]
        public int? PurchaseOrderParentId { get; set; }

        public virtual PurchaseOrder PurchaseOrderParent { get; set; }

        [Column("code")]
        public string Code { get; set; }

        [Column("date")]
        public DateTime Date { get; set; }

        [Column("documentStatusId")]
        public int? DocumentStatusID { get; set; }
        
        public virtual PurchaseOrderDocumentStatus DocumentStatus { get; set; }

        [Column("documentTypeId")]
        public int DocumentTypeID { get; set; }
        public virtual PurchaseOrderDocumentType DocumentType { get; set; }

        [Column("exclAmountZAR")]
        public decimal? ExclAmountZAR { get; set; }

        [Column("forexAmount")]
        public decimal? ForexAmount { get; set; }

        [Column("currencyId")]
        public int? CurrencyId { get; set; }

        [Column("currency")]
        public string Currency { get; set; }

        [Column("inclAmountZAR")]
        public decimal? InclAmountZAR { get; set; }

        [Column("quoteId")]
        public int QuoteId { get; set; }

        [Column("quoteNumber")]
        public string QuoteNumber { get; set; }

        [Column("statusId")]
        public int StatusID { get; set; }
        
        public virtual PurchaseOrderStatus Status { get; set; }

        [Column("supplierId")]
        public int SupplierId { get; set; }

        [Column("supplierTradingName")]
        public string SupplierTradingName { get; set; }

        [Column("typeId")]
        public int? TypeID { get; set; }
        public virtual PurchaseOrderType Type { get; set; }

        [Column("deliveryDate")]
        public DateTime? DeliveryDate { get; set; }

        [Column("deliveryAttention")]
        public string DeliveryAttention { get; set; }

        [Column("deliveryTelephone")]
        public string DeliveryTelephone { get; set; }

        [Column("deliveryInstructions")]
        public string DeliveryInstructions { get; set; }

        [Column("deliveryStreet")]
        public string DeliveryStreet { get; set; }

        [Column("deliverySuburb")]
        public string DeliverySuburb { get; set; }

        [Column("deliveryCity")]
        public string DeliveryCity { get; set; }

        [Column("deliveryState")]
        public string DeliveryState { get; set; }

        [Column("deliveryPostalCode")]
        public string DeliveryPostalCode { get; set; }

        [Column("deliveryCountry")]
        public string DeliveryCountry { get; set; }

        [Column("dueDate")]
        public DateTime? DueDate { get; set; }

        [Column("exchangeRate")]
        public decimal? ExchangeRate { get; set; }

        [Column("freightCost")]
        public decimal? FreightCost { get; set; }

        [Column("dutiesCost")]
        public decimal? DutiesCost { get; set; }

        [Column("waybillNumber")]
        public string WaybillNumber { get; set; }

        [Column("invoiceTotal")]
        public decimal? InvoiceTotal { get; set; }

        [Column("rowVersion")]
        [Timestamp]
        public byte[] RowVersion { get; set; }

        [Column("dateChanged")]
        public DateTime? DateChanged { get; set; }

        [Column("notes")]
        public string Notes { get; set; }

        [Column("cancelReason")]
        public string CancelReason { get; set; }

        public virtual ICollection<PurchaseOrderQuoteItemFinal> QuoteItemsFinal { get; set; }

        public virtual ICollection<PurchaseOrderInvoiceQuoteItemFinal> InvoiceQuoteItemsFinal { get; set; }

        public virtual ICollection<PurchaseOrderPickingSlipQuoteItemFinal> PickingSlipQuoteItemFinal { get; set; }

    }
}