namespace EgwCoreLib.Lux.Data.DbModel.Supplier
{
    // <Auto-Generated>
    // This is here so CodeMaid doesn't reorganize this document
    // </Auto-Generated>

    [Table("buy_order")]
    public class BuyOrderModel
    {
        /// <summary>
        /// ID del record
        /// </summary>
        [Key]
        public int BuyOrderID { get; set; }

        /// <summary>
        /// Anno rif Ordine Fornitore
        /// </summary>
        public int RefYear { get; set; } = DateTime.Today.Year;

        /// <summary>
        /// Numero prog Ordine nell'anno (da calcolare)
        /// </summary>
        public int RefNum { get; set; } = 0;

        /// <summary>
        /// Indice revisione
        /// </summary>
        public int RefRev { get; set; } = 1;

        /// <summary>
        /// Codice calcolato Ordine ANNO.NUMERO.REV
        /// </summary>
        [NotMapped]
        public string BuyOrderCode
        {
            get => $"BO.{RefYear:00}.{RefNum:00000}.{RefRev:00}";
        }

        /// <summary>
        /// Descrizione generale
        /// </summary>
        public string Description { get; set; } = "";

        /// <summary>
        /// Fornitore (quandoa ssegnato, altrimenti è quotazione)
        /// </summary>
        public int? SupplierID { get; set; } = null;

        /// <summary>
        /// Ordine assegnato se ho un supplier definito
        /// </summary>
        [NotMapped]
        public bool Assigned => SupplierID != null;

        /// <summary>
        /// DataOra inserimento
        /// </summary>
        public DateTime Inserted { get; set; } = DateTime.Now;

        /// <summary>
        /// DataOra ultima modifica
        /// </summary>
        public DateTime Modified { get; set; } = DateTime.Now;

        /// <summary>
        /// DataOra richiesta per il completamento dell'ordine di fornitura
        /// </summary>
        public DateTime DueDateReq { get; set; } = DateTime.Today.AddDays(30);

        /// <summary>
        /// note di consegna (opzionali)
        /// </summary>
        public string ConsNote { get; set; } = "";

        /// <summary>
        /// Enum stato Ordine Acquisto
        /// </summary>
        public BuyOrderStates OrderState { get; set; } = BuyOrderStates.Created;

        /// <summary>
        /// Navigazione Supplier
        /// </summary>
        [ForeignKey("SupplierID")]
        public virtual SupplierModel? SupplierNav { get; set; } = null;

        /// <summary>
        /// Navigazione alle righe Ordine Acquisto
        /// </summary>
        public virtual ICollection<BuyOrderRowModel> BuyOrderRowNav { get; set; } = new List<BuyOrderRowModel>();
    }
}