protected void ddlItemName_SelectedIndexChanged(object sender, EventArgs e) { int count = Convert.ToInt32(Session["count"]); if (ddlItemName.SelectedIndex == 0 && count == 0) { ddlSupplier.Enabled = false; ddlSupplier.SelectedIndex = 0; tbUOM.Text = ""; tbPrice.Text = ""; tbQuantity.Text = ""; } else if (ddlItemName.SelectedIndex != 0 && count > 0) { purchaseOrderBL = new PurchaseOrderBL(); string itemName = ddlItemName.SelectedItem.Text; InventoryStockBO ins = new InventoryStockBO(); ins = purchaseOrderBL.getUOMByItem(itemName); tbUOM.Text = ins.ItemUOM.ToString(); ddlSupplier.Enabled = false; string supplier = (String)Session["ddlValue"]; ddlSupplier.SelectedItem.Text = supplier; PurchaseOrderDetailsJoinBO pod = new PurchaseOrderDetailsJoinBO(); pod = purchaseOrderBL.getPriceBySupplier(itemName, supplier); tbPrice.Text = pod.Price.ToString(); tbQuantity.Text = ""; } else { purchaseOrderBL = new PurchaseOrderBL(); string itemName = ddlItemName.SelectedItem.Text; InventoryStockBO ins = new InventoryStockBO(); ins = purchaseOrderBL.getUOMByItem(itemName); tbUOM.Text = ins.ItemUOM.ToString(); ddlSupplier.Enabled = true; List <String> supplierList = new List <string>(); InventoryStockBO bo = new InventoryStockBO(); bo = purchaseOrderBL.getSupplierByItem(itemName); supplierList.Add(bo.Supplier1); supplierList.Add(bo.Supplier2); supplierList.Add(bo.Supplier3); ddlSupplier.DataSource = supplierList; ddlSupplier.DataBind(); ListItem liSupplier = new ListItem("Select Supplier", "-1"); ddlSupplier.Items.Insert(0, liSupplier); tbPrice.Text = ""; tbQuantity.Text = ""; } }
protected void ddlSupplier_SelectedIndexChanged(object sender, EventArgs e) { int count = Convert.ToInt32(Session["count"]); purchaseOrderBL = new PurchaseOrderBL(); PurchaseOrderDetailsJoinBO ins = new PurchaseOrderDetailsJoinBO(); string itemName = ddlItemName.SelectedItem.Text; string supplier = ddlSupplier.SelectedItem.Text; ins = purchaseOrderBL.getPriceBySupplier(itemName, supplier); tbPrice.Text = ins.Price.ToString(); Session["ddlValue"] = ddlSupplier.SelectedItem.Text; }
public List <PurchaseOrderDetailsJoinBO> getPurchaseOrderDetailsById(string poId) { var query = (from po in context.PurchaseOrders join pod in context.PurchaseOrderDetails on po.POID equals pod.POID join ins in context.InventoryStocks on pod.ItemNumber equals ins.ItemNumber where po.POID == poId select new { ins.ItemNumber, ins.ItemName, pod.Quantity, pod.SupplierID, ins.Supplier1, ins.Supplier2, ins.Supplier3, ins.ItemUOM, ins.Price1, ins.Price2, ins.Price3 }); List <PurchaseOrderDetailsJoinBO> list = new List <PurchaseOrderDetailsJoinBO>(); foreach (var q in query) { PurchaseOrderDetailsJoinBO obj = new PurchaseOrderDetailsJoinBO(); obj.ItemNumber = q.ItemNumber; obj.ItemName = q.ItemName; obj.Quantity = q.Quantity; obj.ItemUOM = q.ItemUOM; if (q.SupplierID.Equals(q.Supplier1) && !(q.SupplierID.Equals(q.Supplier2)) && !(q.SupplierID.Equals(q.Supplier3))) { obj.Supplier = q.Supplier1; obj.Price = (Double)q.Price1; obj.TotalPrice = (Double)q.Quantity * obj.Price; } else if (q.SupplierID.Equals(q.Supplier2) && !(q.SupplierID.Equals(q.Supplier1)) && !(q.SupplierID.Equals(q.Supplier3))) { obj.Supplier = q.Supplier2; obj.Price = (Double)q.Price2; obj.TotalPrice = (Double)q.Quantity * obj.Price; } else { obj.Supplier = q.Supplier3; obj.Price = (Double)q.Price3; obj.TotalPrice = (Double)q.Quantity * obj.Price; } list.Add(obj); } return(list); }
public PurchaseOrderDetailsJoinBO getPriceForSupplier(string itemName, string supplier) { var query = (from invs in context.InventoryStocks where invs.ItemName == itemName select new { invs.Supplier1, invs.Supplier2, invs.Supplier3, invs.Price1, invs.Price2, invs.Price3 }); PurchaseOrderDetailsJoinBO obj = new PurchaseOrderDetailsJoinBO(); foreach (var q in query) { if (supplier == q.Supplier1) { obj.Price = (Double)q.Price1; } else if (supplier == q.Supplier2) { obj.Price = (Double)q.Price2; } else { obj.Price = (Double)q.Price3; } } return(obj); }