Exemplo n.º 1
0
        private void SetProductInventory(int productInventoryID)
        {
            var db = new BusinessEntities();

            this.product_inventory_id = productInventoryID;
            this.ProductInventory     = db.Product_Inventory.Find(productInventoryID);
            this.ProductInventory.CalculatePackage();
            this.ProductInventory.SetProduct();
            db.Dispose();
        }
        public void SetProduct()
        {
            var db = new BusinessEntities();

            if (this.Product == null)
            {
                this.Product = db.Products.Find(this.product_id);
            }
            db.Dispose();
        }
        public void CalculateTotal()
        {
            // gathering lineitems info
            var     db         = new BusinessEntities();
            var     invoiceLIs = db.Invoice_Lineitem.Where(li => li.invoice_id == this.Id);
            decimal subtotal   = 0m;

            foreach (var i in invoiceLIs)
            {
                i.CalculateTotal(i.product_inventory_id);
                i.ProductInventory.SetProduct();
                subtotal += i.LineitemTotal;
            }
            this.Lineitems = invoiceLIs.ToList();

            // gathering delivery items info
            var deliveryLIs = db.Delivery_Lineitem.Where(dl => dl.Invoice_Lineitem.invoice_id == this.Id && dl.Delivery_Schedule.is_delivered == true)
                              .OrderBy(dl => dl.Delivery_Schedule.delivery_date)
                              .ToList();

            foreach (var i in deliveryLIs)
            {
                i.CalculateTotal(i.product_inventory_id);
            }
            this.DeliveryItems = deliveryLIs;

            // determine delivery status
            bool isComplete = true;

            foreach (var i in this.Lineitems)
            {
                var matchingDeliveryItems = this.DeliveryItems.Where(di => di.invoice_lineitem_id == i.Id).ToList();
                if (matchingDeliveryItems != null)
                {
                    int qty = 0;
                    foreach (var d in matchingDeliveryItems)
                    {
                        qty += d.lineitem_unit_quantity;
                    }
                    if (i.lineitem_unit_quantity != qty)
                    {
                        isComplete = false;
                    }
                }
                else
                {
                    isComplete = false;
                }
            }
            if (isComplete == false)
            {
                this.DeliveryStatus = "Pending";
            }
            else
            {
                this.DeliveryStatus = "Complete";
            }

            this.Subtotal  = subtotal;
            this.TaxAmount = subtotal * Tax;
            this.Total     = this.Subtotal + this.TaxAmount;
        }