protected void BindGrid() { List <InventoryCatalogue> cList = InventoryLogic.GetAllCatalogue(); GridViewCatalogue.DataSource = cList; GridViewCatalogue.DataBind(); Session["CatalogueList"] = cList; }
protected void BindGrid() { InventoryLogic il = new InventoryLogic(); List <InventoryCatalogue> itemList = InventoryLogic.GetAllCatalogue().Where(x => x.Discontinued != "Y").ToList(); GridViewAddRequest.DataSource = itemList; GridViewAddRequest.DataBind(); }
protected void BtnSubmit_Click(object sender, EventArgs e) { try { string ItemID = TxtItemID.Text; string BIN = TxtBIN.Text; string Shelf = TxtShelf.Text; int Level = Convert.ToInt32(TxtLevel.Text); string CategoryID = Convert.ToString(DdlCategoryID.SelectedValue); string Description = TxtDescription.Text; int ReorderLevel = Convert.ToInt32(TxtReorderLevel.Text); int UnitsInStock = Convert.ToInt32(TxtUnitsInStock.Text); int ReorderQty = Convert.ToInt32(TxtReorderQty.Text); string UOM = TxtUOM.Text; string Discontinued = "N"; int UnitsOnOrder = Convert.ToInt32(TxtUnitsOnOrder.Text); int BufferStockLevel = 0; int BFSProportion = 10; string supplier1 = DdlSupplier1.SelectedValue; string supplier2 = DdlSupplier2.SelectedValue; string supplier3 = DdlSupplier3.SelectedValue; double price1; double price2; double price3; bool isprice1legit = false; if (Double.TryParse(TxtPriceS1.Text, out price1) && price1 > 0) { isprice1legit = true; } bool isprice2legit = false; if (Double.TryParse(TxtPriceS2.Text, out price2) && price2 > 0) { isprice2legit = true; } bool isprice3legit = false; if (Double.TryParse(TxtPriceS3.Text, out price3) && price3 > 0) { isprice3legit = true; } string input = TxtItemID.Text; //This part is written by Pradeep //Here call a list of all InventoryCatalogue, and check if the itemID exist. InventoryCatalogues.; bool Exist = InventoryLogic.GetAllCatalogue().Any(i => i.ItemID == input); if (!Exist) { if (supplier1 != string.Empty) { if (isprice1legit) { if (supplier2 != string.Empty) { if (supplier1 != supplier2) { if (isprice2legit) { if (supplier3 != string.Empty) { if (supplier1 != supplier3 && supplier2 != supplier3) { if (isprice3legit) { BusinessLogic.InventoryLogic.AddCatalogue(ItemID, BIN, Shelf, Level, CategoryID, Description, ReorderLevel, UnitsInStock, ReorderQty, UOM, Discontinued, UnitsOnOrder, BufferStockLevel, BFSProportion); InventoryLogic.AddSupplierCatalogue(supplier1, ItemID, price1, 1, UOM); InventoryLogic.AddSupplierCatalogue(supplier2, ItemID, price2, 2, UOM); InventoryLogic.AddSupplierCatalogue(supplier3, ItemID, price3, 3, UOM); Response.Redirect("ViewCatalogue.aspx"); } else { statusMessage.Text = "Please enter a valid price for 3rd Supplier"; statusMessage.Visible = true; statusMessage.ForeColor = Color.Red; } } else { statusMessage.Text = "Please choose different suppliers"; statusMessage.Visible = true; statusMessage.ForeColor = Color.Red; } } else { BusinessLogic.InventoryLogic.AddCatalogue(ItemID, BIN, Shelf, Level, CategoryID, Description, ReorderLevel, UnitsInStock, ReorderQty, UOM, Discontinued, UnitsOnOrder, BufferStockLevel, BFSProportion); InventoryLogic.AddSupplierCatalogue(supplier1, ItemID, price1, 1, UOM); InventoryLogic.AddSupplierCatalogue(supplier2, ItemID, price2, 2, UOM); Response.Redirect("ViewCatalogue.aspx"); } } else { statusMessage.Text = "Please enter a valid price for 2nd Supplier"; statusMessage.Visible = true; statusMessage.ForeColor = Color.Red; } } else { statusMessage.Text = "Please choose different suppliers"; statusMessage.Visible = true; statusMessage.ForeColor = Color.Red; } } else { BusinessLogic.InventoryLogic.AddCatalogue(ItemID, BIN, Shelf, Level, CategoryID, Description, ReorderLevel, UnitsInStock, ReorderQty, UOM, Discontinued, UnitsOnOrder, BufferStockLevel, BFSProportion); InventoryLogic.AddSupplierCatalogue(supplier1, ItemID, price1, 1, UOM); Response.Redirect("ViewCatalogue.aspx"); } } else { statusMessage.Text = "Please enter a valid price for 1st Supplier"; statusMessage.Visible = true; statusMessage.ForeColor = Color.Red; } } else { statusMessage.Text = "Please choose a supplier"; statusMessage.Visible = true; statusMessage.ForeColor = Color.Red; } } else { statusMessage.Text = "Item already exists"; statusMessage.Visible = true; statusMessage.ForeColor = Color.Red; } } catch { statusMessage.Text = "Input is required for all fields"; statusMessage.Visible = true; statusMessage.ForeColor = Color.Red; } }
//-------------------------------------Binding all the records from inventory table to datagrid view--------------------// public void GridBind() { allList = InventoryLogic.GetAllCatalogue(); Session["list"] = allList; DatagridBind(allList); }