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

    [Table("buy_order_row")]
    public class BuyOrderRowModel
    {
        /// <summary>
        /// ID del record
        /// </summary>
        [Key]
        public int BuyOrderRowID { get; set; }

        /// <summary>
        /// ID Ordine di acquisto di riferimento
        /// </summary>
        public int BuyOrderID { get; set; }

        /// <summary>
        /// Riga Ordine (per ordinamento)
        /// </summary>
        public int RowNum { get; set; } = 0;

        /// <summary>
        /// ID dell'item richiesto (se disponibile)
        /// </summary>
        public int? ItemID { get; set; } = null;

        /// <summary>
        /// Classificazione Item
        /// </summary>
        public string ClassCode { get; set; } = "";

        /// <summary>
        /// Descrizione Item
        /// </summary>
        public string DescriptionCode { get; set; } = "";

        /// <summary>
        /// Codice Item
        /// </summary>
        public string ItemCode { get; set; } = "";

        /// <summary>
        /// Quantità articolo TOTALE
        /// </summary>
        public double TotQty
        {
            get => MatReqNav.Sum(x => x.Qty);
        }


#if false
        /// <summary>
        /// Quantità articolo TOTALE
        /// </summary>
        public double TotQty
        {
            get => DictOrderRowDetail.Sum(x => x.Value);
        }
        /// <summary>
        /// Dizionario serializzato di RigheOrdine + Qty
        /// </summary>
        public string OrderRowData { get; set; } = "";

        /// <summary>
        /// Dizionario escplicito degli OrderRow esplosi rispetto a ItemId delle BOM
        /// </summary>
        [NotMapped]
        public Dictionary<int, double> DictOrderRowDetail
        {
            get
            {
                Dictionary<int, double> answ = new();
                if (!string.IsNullOrEmpty(OrderRowData) && OrderRowData.Count() > 2)
                {
                    answ = JsonConvert.DeserializeObject<Dictionary<int, double>>(OrderRowData) ?? new();
                }
                return answ;
            }
            set
            {
                OrderRowData = JsonConvert.SerializeObject(value);
            }
        } 
#endif

        /// <summary>
        /// Navigazione Ordine Acquisto
        /// </summary>
        [ForeignKey("BuyOrderID")]
        public virtual BuyOrderModel? BuyOrderNav { get; set; } = null;

        /// <summary>
        /// Navigazione Item
        /// </summary>
        [ForeignKey("ItemID")]
        public virtual ItemModel? ItemNav { get; set; } = null;

        /// <summary>
        /// Many-to-many verso associazione con MatReq
        /// </summary>
        public virtual ICollection<BuyOrderRow2MatReqModel> MatReqNav { get; set; } = new List<BuyOrderRow2MatReqModel>();
    }
}