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);
}
