protected void UpdateProduct_Click(object sender, EventArgs e) { // TODO: Do any validation int id; if (int.TryParse(ProductID.Text, out id)) // If there is a Product ID { try { // Create a Product object and fill it with the data from the form Product item = GetProductFromUser(); // Everything but the ProductId item.ProductID = id; // The id from when they did the Lookup // Send the Product object to the BLL InventoryPurchasingController controller = new InventoryPurchasingController(); controller.UpdateProduct(item); // Give the user some feedback PopulateProductsDropDown(); CurrentProducts.SelectedValue = id.ToString(); ShowMessage(item.ProductName + " was successfully updated", "success"); } catch (Exception ex) { ShowMessage("Error: " + ex.Message, "danger"); } } else { ShowMessage("Please lookup a product before clicking the Update button.", "info"); } }
protected void DeleteProduct_Click(object sender, EventArgs e) { int id; if (int.TryParse(ProductID.Text, out id)) // If there is a Product ID { try { // Send the Product object to the BLL InventoryPurchasingController controller = new InventoryPurchasingController(); controller.DeleteProduct(id); // Give the user some feedback PopulateProductsDropDown(); CurrentProducts.SelectedIndex = 0; ShowMessage("Product was successfully removed", "success"); ClearForm_Click(sender, e); // just call the ClearForm click method to clean up } catch (Exception ex) { ShowFullExceptionMessage(ex); } } else { ShowMessage("Please lookup a product before clicking the Delete button.", "info"); } }
protected void DeleteCategory_Click(object sender, EventArgs e) { int theCategoryId; if (int.TryParse(CategoryID.Text, out theCategoryId)) { try { InventoryPurchasingController controller = new InventoryPurchasingController(); controller.DeleteCategory(theCategoryId); MessageLabel.Text = "Category " + CategoryName.Text + " deleted"; PopulateCategoryDropdown(); CategoryID.Text = string.Empty; CategoryName.Text = string.Empty; Description.Text = string.Empty; Picture.ImageUrl = "~/Images/NoImage_172x120.gif"; } catch (Exception ex) { MessageLabel.Text = ex.Message; MessagePanel.CssClass = "alert alert-danger alert-dismissible"; MessagePanel.Visible = true; } } else { MessageLabel.Text = "Lookup and existing category before attempting to delete."; } }
protected void DeleteSupplier_Click(object sender, EventArgs e) { try { int supplierId; if (int.TryParse(CurrentSupplier.Text, out supplierId)) { if (IsValid) { InventoryPurchasingController Controller = new InventoryPurchasingController(); Controller.DeleteSupplier(supplierId); // 2) Update the form and give feedback to the user BindSupplierDropDown(); SupplierDropDownList.SelectedIndex = -1; MessageLabel.Text = "Supplier removed"; MessagePanel.CssClass = "alert alert-success alert-dismissible"; MessagePanel.Visible = true; } } else { MessageLabel.Text = "Please lookup a supplier before attempting to update"; MessagePanel.CssClass = "alert alert-warning alert-dismissible"; MessagePanel.Visible = true; } } catch (Exception ex) { MessageLabel.Text = ex.Message; MessagePanel.CssClass = "alert alert-danger alert-dismissible"; MessagePanel.Visible = true; } }
protected void UpdateSupplier_Click(object sender, EventArgs e) { try { int supplierId; if (int.TryParse(CurrentSupplier.Text, out supplierId)) { if (IsValid) { // 1) Add the product as a new item // Get the Country name string country = null; if (CountryDropDown.SelectedIndex > 0) { country = CountryDropDown.SelectedValue; } Supplier item = new Supplier(); item.SupplierID = supplierId; item.CompanyName = CompanyName.Text; item.ContactName = ContactName.Text; item.ContactTitle = ContactTitle.Text; item.Address = Address.Text; item.City = City.Text; item.Region = Region.Text; item.PostalCode = PostalCode.Text; item.Country = country; item.Phone = Phone.Text; item.Fax = Fax.Text; item.HomePageTitle = HomePageTitle.Text; item.HomePageUrl = WebAddress.Text; InventoryPurchasingController Controller = new InventoryPurchasingController(); Controller.UpdateSupplier(item); // 2) Update the form and give feedback to the user BindSupplierDropDown(); ClearForm_Click(sender, e); MessageLabel.Text = "Supplier updated"; MessagePanel.CssClass = "alert alert-success alert-dismissible"; MessagePanel.Visible = true; } } else { MessageLabel.Text = "Please lookup a supplier before attempting to update"; MessagePanel.CssClass = "alert alert-warning alert-dismissible"; MessagePanel.Visible = true; } } catch (Exception ex) { MessageLabel.Text = ex.Message; MessagePanel.CssClass = "alert alert-danger alert-dismissible"; MessagePanel.Visible = true; } }
protected void LookupCategory_Click(object sender, EventArgs e) { // if the user is required to make a selection or // enter a value for the look, ensure that it has // been done if (CurrentCategories.SelectedIndex != 0) { // you should properly handle errors in a friendly manner try { //connect to the BLL InventoryPurchasingController systemmgr = new InventoryPurchasingController(); //set up the data catching variable Category aCategory; //currently null // issue query request (lookup) aCategory = systemmgr.LookupCategory(int.Parse(CurrentCategories.SelectedValue)); // testing for not found if (aCategory == null) { MessageLabel.Text = "No data from for selected category"; // empty display controls CategoryID.Text = ""; CategoryName.Text = ""; Description.Text = ""; } else { // load the appropriate controls with corresponding data CategoryID.Text = aCategory.CategoryID.ToString(); CategoryName.Text = aCategory.CategoryName; Description.Text = aCategory.Description; if (aCategory.Picture != null) { string base64String = Convert.ToBase64String(aCategory.Picture); Picture.ImageUrl = string.Format("data:{0};base64,{1}", aCategory.PictureMimeType, base64String); } else { Picture.ImageUrl = "~/Images/NoImage_172x120.gif"; } } } catch (Exception ex) { MessageLabel.Text = ex.Message; MessagePanel.CssClass = "alert alert-danger alert-dismissible"; MessagePanel.Visible = true; } } else { MessageLabel.Text = "Select a category for searching."; MessagePanel.CssClass = "alert alert-info alert-dismissible"; MessagePanel.Visible = true; } }
private void PopulateGridView() { InventoryPurchasingController controller = new InventoryPurchasingController(); int searchId = int.Parse(CategoryDropDown.SelectedValue); List <Product> data = controller.GetProductsByCategory(searchId); SearchResultsGridView.DataSource = data; SearchResultsGridView.DataBind(); }
private void BindSupplierDropDown() { InventoryPurchasingController controller = new InventoryPurchasingController(); SupplierDropDownList.DataSource = controller.ListAllSuppliers(); SupplierDropDownList.DataTextField = "CompanyName"; SupplierDropDownList.DataValueField = "SupplierID"; SupplierDropDownList.DataBind(); SupplierDropDownList.Items.Insert(0, new ListItem("[Select a supplier]", "-1")); }
private void PopulateSupplierDropDown() { InventoryPurchasingController controller = new InventoryPurchasingController(); List <Supplier> data = controller.ListAllSuppliers(); SupplierDropDown.DataSource = data; SupplierDropDown.DataTextField = "CompanyName"; SupplierDropDown.DataValueField = "SupplierID"; SupplierDropDown.DataBind(); SupplierDropDown.Items.Insert(0, "[select a supplier]"); }
private void PopulateCategoryDropDown() { InventoryPurchasingController controller = new InventoryPurchasingController(); List <Category> data = controller.ListAllCategories(); CategoryDropDown.DataSource = data; CategoryDropDown.DataTextField = "CategoryName"; CategoryDropDown.DataValueField = "CategoryID"; CategoryDropDown.DataBind(); CategoryDropDown.Items.Insert(0, "[select a Category]"); }
private void BindCountryDropDown() { InventoryPurchasingController controller = new InventoryPurchasingController(); CountryDropDown.DataSource = controller.ListAllCountries(); CountryDropDown.DataTextField = "Country"; CountryDropDown.DataValueField = "Country"; CountryDropDown.DataBind(); CountryDropDown.Items.Insert(0, new ListItem("[Select a Country]", "-1")); CountryDropDown.Items.Insert(1, new ListItem("[no Country]", "")); }
private void PopulateCategoryDropdown() { // Populate Category drop-down InventoryPurchasingController controller = new InventoryPurchasingController(); List <Category> categories = controller.ListAllCategories(); CurrentCategories.DataSource = categories; CurrentCategories.DataTextField = "CategoryName"; CurrentCategories.DataValueField = "CategoryID"; CurrentCategories.DataBind(); CurrentCategories.Items.Insert(0, "[select a category]"); }
private void PopulateCategoryDropDown() { InventoryPurchasingController controller = new InventoryPurchasingController(); List <Category> categories = controller.ListAllCategories(); Category.DataSource = categories; Category.DataTextField = "CategoryName"; Category.DataValueField = "CategoryID"; Category.DataBind(); // Let's insert a couple of options at the top of the drop-down Category.Items.Insert(0, new ListItem("[select a category]")); Category.Items.Insert(1, new ListItem("[no category]", "")); // because Product.CategoryID is nullable }
private void PopulateSupplierDropDown() { InventoryPurchasingController controller = new InventoryPurchasingController(); List <Supplier> suppliers = controller.ListAllSuppliers(); Supplier.DataSource = suppliers; Supplier.DataTextField = "CompanyName"; Supplier.DataValueField = "SupplierID"; Supplier.DataBind(); // Let's insert a couple of options at the top of the drop-down Supplier.Items.Insert(0, new ListItem("[select a supplier]")); Supplier.Items.Insert(1, new ListItem("[no supplier]", "")); // because Product.SupplierID is nullable }
protected void AddSupplier_Click(object sender, System.EventArgs e) { try { if (IsValid) { // 1) Add the product as a new item // Get the Country name string country = null; if (CountryDropDown.SelectedIndex > 0) { country = CountryDropDown.SelectedValue; } Supplier item = new Supplier(); item.CompanyName = CompanyName.Text; item.ContactName = ContactName.Text; item.ContactTitle = ContactTitle.Text; item.Address = Address.Text; item.City = City.Text; item.Region = Region.Text; item.PostalCode = PostalCode.Text; item.Country = country; item.Phone = Phone.Text; item.Fax = Fax.Text; item.HomePageTitle = HomePageTitle.Text; item.HomePageUrl = WebAddress.Text; InventoryPurchasingController Controller = new InventoryPurchasingController(); int NewSupplierId = Controller.AddSupplier(item); // 2) Update the form and give feedback to the user BindSupplierDropDown(); SupplierDropDownList.SelectedValue = NewSupplierId.ToString(); CurrentSupplier.Text = NewSupplierId.ToString(); MessageLabel.Text = "Supplier added"; MessagePanel.CssClass = "alert alert-success alert-dismissible"; MessagePanel.Visible = true; } } catch (Exception ex) { MessageLabel.Text = ex.Message; MessagePanel.CssClass = "alert alert-danger alert-dismissible"; MessagePanel.Visible = true; } }
private void PopulateProductsDropDown() { // We can populate some controls such as DropDownLists with data // Populate CurrentProducts with all the products in the database InventoryPurchasingController controller = new InventoryPurchasingController(); // controller is a NorthwindController object List <Product> products = controller.ListAllProducts(); // products is a List<Product> object CurrentProducts.DataSource = products; // CurrentProducts is a DropDownList CurrentProducts.DataTextField = "ProductName"; // The property of the Product class to display CurrentProducts.DataValueField = "ProductID"; CurrentProducts.DataBind(); // Populate the DropDownList CurrentProducts.Items.Insert(0, "[select a product]"); }
protected void LookupSupplier_Click(object sender, System.EventArgs e) { try { int supplierId; if (int.TryParse(SupplierDropDownList.SelectedValue, out supplierId) && supplierId >= 0) { Supplier item; InventoryPurchasingController Controller = new InventoryPurchasingController(); item = Controller.LookupSupplier(supplierId); CurrentSupplier.Text = item.SupplierID.ToString(); CompanyName.Text = item.CompanyName; ContactName.Text = item.ContactName; ContactTitle.Text = item.ContactTitle; Address.Text = item.Address; City.Text = item.City; Region.Text = item.Region; PostalCode.Text = item.PostalCode; CountryDropDown.SelectedValue = item.Country; Phone.Text = item.Phone; Fax.Text = item.Fax; HomePageTitle.Text = item.HomePageTitle; WebAddress.Text = item.HomePageUrl; } else { MessageLabel.Text = "Please Select a supplier before clicking Lookup"; MessagePanel.CssClass = "alert alert-info alert-dismissible"; MessagePanel.Visible = true; } } catch (Exception ex) { MessageLabel.Text = ex.Message; MessagePanel.CssClass = "alert alert-danger alert-dismissible"; MessagePanel.Visible = true; } }
protected void ShowProductDetails_Click(object sender, EventArgs e) { int searchId; if (CurrentProducts.SelectedIndex == 0) { ShowMessage("Please select a product from the dropdown before clicking [Show Product Details]", "info"); } else { try { searchId = int.Parse(CurrentProducts.SelectedValue); InventoryPurchasingController controller = new InventoryPurchasingController(); Product foundProduct = controller.GetProduct(searchId); // Unpacking the found product into the form ProductID.Text = foundProduct.ProductID.ToString(); ProductName.Text = foundProduct.ProductName; // Select the supplier/category for the found product Supplier.SelectedValue = foundProduct.SupplierID.ToString(); Category.SelectedValue = foundProduct.CategoryID.ToString(); // Other values that are displayed in text boxes QtyPerUnit.Text = foundProduct.QuantityPerUnit; UnitPrice.Text = foundProduct.UnitPrice.ToString(); InStock.Text = foundProduct.UnitsInStock.ToString(); OnOrder.Text = foundProduct.UnitsOnOrder.ToString(); ReorderLevel.Text = foundProduct.ReorderLevel.ToString(); // Set the checkbox for the found product's Discontinued flag Discontinued.Checked = foundProduct.Discontinued; ShowMessage("Product details found", "success"); } catch (Exception ex) { ShowMessage(ex.Message, "danger"); } } }
protected void AddCategory_Click(object sender, EventArgs e) { try { Category item = new Category(); item.CategoryName = CategoryName.Text; if (!string.IsNullOrEmpty(Description.Text)) { item.Description = Description.Text; } item.Picture = ImageUploadHelpers.GetUploadedPicture(CategoryImageUpload); item.PictureMimeType = ImageUploadHelpers.GetMimeType(CategoryImageUpload); InventoryPurchasingController controller = new InventoryPurchasingController(); int addedCategoryID = controller.AddCategory(item); // Update the form and give feedback to the user PopulateCategoryDropdown(); CurrentCategories.SelectedValue = addedCategoryID.ToString(); CategoryID.Text = addedCategoryID.ToString(); if (item.Picture != null) { string base64String = Convert.ToBase64String(item.Picture); Picture.ImageUrl = string.Format("data:{0};base64,{1}", item.PictureMimeType, base64String); } else { Picture.ImageUrl = "~/Images/NoImage_172x120.gif"; } MessageLabel.Text = "New category added"; } catch (Exception ex) { MessageLabel.Text = ex.Message; MessagePanel.CssClass = "alert alert-danger alert-dismissible"; MessagePanel.Visible = true; } }
protected void AddProduct_Click(object sender, EventArgs e) { // TODO: Do any validation try { // Create a Product object and fill it with the data from the form Product item = GetProductFromUser(); // Send the Product object to the BLL InventoryPurchasingController controller = new InventoryPurchasingController(); int newItemId = controller.AddProduct(item); // my bad ;) // Give the user some feedback PopulateProductsDropDown(); // because we have a new product for the list CurrentProducts.SelectedValue = newItemId.ToString(); ProductID.Text = newItemId.ToString(); ShowMessage("Product added", "success"); } catch (Exception ex) { ShowMessage(ex.Message, "danger"); } }
protected void UpdateCategory_Click(object sender, EventArgs e) { int theCategoryId; if (IsValid) { if (int.TryParse(CategoryID.Text, out theCategoryId)) { try { byte[] uploadedPicture = ImageUploadHelpers.GetUploadedPicture(CategoryImageUpload); string mimeType = ImageUploadHelpers.GetMimeType(CategoryImageUpload); if (uploadedPicture != null && DeletePicture.Checked) { MessageLabel.Text = "Unclear input.<br />" + "You selected 'Check to delete picture' and uploaded an image."; } else { // 1) Get the picture to be used in the update InventoryPurchasingController controller = new InventoryPurchasingController(); if (DeletePicture.Checked) { uploadedPicture = null; mimeType = null; } else if (uploadedPicture == null) { // default to the existing picture Category existing = controller.LookupCategory(theCategoryId); uploadedPicture = existing.Picture; mimeType = existing.PictureMimeType; } // 2) Create the Category object Category item = new Category(); item.CategoryID = theCategoryId; item.CategoryName = CategoryName.Text; if (!string.IsNullOrEmpty(Description.Text)) { item.Description = Description.Text; } item.Picture = uploadedPicture; item.PictureMimeType = mimeType; // 3) Update the database controller.UpdateCategory(item); PopulateCategoryDropdown(); CurrentCategories.SelectedValue = item.CategoryID.ToString(); if (item.Picture != null) { string base64String = Convert.ToBase64String(item.Picture); Picture.ImageUrl = string.Format("data:{0};base64,{1}", item.PictureMimeType, base64String); } else { Picture.ImageUrl = "~/Images/NoImage_172x120.gif"; } MessageLabel.Text = "Category was updated."; } } catch (Exception ex) { MessageLabel.Text = ex.Message; MessagePanel.CssClass = "alert alert-danger alert-dismissible"; MessagePanel.Visible = true; } } else { MessageLabel.Text = "Lookup and existing category before attempting an update."; } } }