Ejemplo n.º 1
0
    public static void addItemOrder(Item item, int userNo, string suppliercode)
    {
        string itemSupplier        = item.supplier1;
        SOrder lastUnconfirmedAuto = StoreSupplierDAO.findLastUnapprovedOrder(userNo, suppliercode);

        if (lastUnconfirmedAuto.OrderItems.Where(x => x.itemcode == item.itemcode && x.purchaseordernumber == lastUnconfirmedAuto.purchaseordernumber).Count() == 0)
        {
            OrderItem oi = new OrderItem();
            oi.purchaseordernumber = lastUnconfirmedAuto.purchaseordernumber;
            oi.itemcode            = item.itemcode;
            oi.orderquantity       = item.reorderquantity;
            oi.cost = StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * item.reorderquantity;
            ds.OrderItems.Attach(oi);
            ds.OrderItems.Add(oi);
            lastUnconfirmedAuto.OrderItems.Add(oi);
            if (lastUnconfirmedAuto.totalcost == null)
            {
                lastUnconfirmedAuto.totalcost = StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * oi.orderquantity;
            }
            else
            {
                lastUnconfirmedAuto.totalcost = lastUnconfirmedAuto.totalcost + StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * item.reorderquantity;
            }
            ds.SaveChanges();
        }
        else
        {
            OrderItem oi = lastUnconfirmedAuto.OrderItems.Where(x => x.itemcode == item.itemcode && x.purchaseordernumber == lastUnconfirmedAuto.purchaseordernumber).First();
            oi.orderquantity = oi.orderquantity + item.reorderquantity;
            oi.cost          = StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * oi.orderquantity;
            if (lastUnconfirmedAuto.totalcost == null)
            {
                lastUnconfirmedAuto.totalcost = StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * oi.orderquantity;
            }
            else
            {
                lastUnconfirmedAuto.totalcost = lastUnconfirmedAuto.totalcost + StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * item.reorderquantity;
            }
            ds.SaveChanges();
        }
    }