public void ProductsDbAddProductReturnsFalse() { //Assign var productsDb = new ProductsDB(); var product = new Product(); productsDb.AddProduct(product); //Act + Assert Assert.IsFalse(productsDb.AddProduct(product)); }
public void ProductsDbContainsProductReturnsTrue() { //Assign var productsDb = new ProductsDB(); var product = new Product(); productsDb.AddProduct(product); //Act + Assert Assert.IsTrue(productsDb.ContainsProduct(product.Id)); }
public void ProductsDbChangeProductInfoReturnsTrue() { //Assign var productsDb = new ProductsDB(); var product = new Product(); productsDb.AddProduct(product); //Act + Assert Assert.IsTrue(productsDb.ChangeProductInfo(product.Id, new Product(), 0)); }
public void ProductsDbGetProductReturnsProductAndInt() { //Assign var productsDb = new ProductsDB(); var product = new Product(); productsDb.AddProduct(product); //Act + Assert Assert.AreEqual(productsDb.GetProduct(product.Name).Item1, product); }
public IActionResult OnPost() { if (!ModelState.IsValid) { return(Page()); } else { ProductsDB.AddProduct(NewProduct, _configuration); return(RedirectToPage("/Index")); } }
private void btnProAdd_Click(object sender, EventArgs e) { try { if (Validator.IsPresent(txtNewProductName, "New Product Name") && Validator.IsCorrectLength(txtNewProductName, "Name", 20) && Validator.IsNameValid(txtNewProductName, "Name")) { Products newProduct = productUpdate1(txtNewProductName); newProduct.ProductId = ProductsDB.AddProduct(newProduct); MessageBox.Show("Product is updated :)"); UpdateAllInfos(); productsDataGridView.DataSource = AllProducts; } } //catch the other error and show the ex error message from db class catch (Exception ex) { MessageBox.Show(ex.Message, ex.GetType().ToString()); } }
// btn SAVE: save edit (update) or save add (create) private void threeBtnSave_Click(object sender, EventArgs e) { if (threeTab.SelectedIndex == 1) // EDIT MODE { // get current displaying product obj var currentProd = ProductsDB.GetProducts(). SingleOrDefault(p => p.ProductId == Convert.ToInt32(threeTxtEditProdId.Text)); // initiate new product obj Products newProd; // validate: product name is empty or duplicated if (Validator.TBIsEmpty(threeTxtEditProdName, "Product Name") || FindDuplicatedProductName(threeTxtEditProdName.Text)) { // empty or same, do not perform update threeTxtEditProdName.Text = currentProd.ProdName; threeTxtEditProdName.SelectAll(); return; } else { // name is valid, create new Product obj newProd = new Products { ProdName = threeTxtEditProdName.Text } }; // try to perform update try { Console.WriteLine("Old prod name is: " + currentProd.ProdName); var rowsAffected = ProductsDB.UpdateProduct(currentProd, newProd); MessageBox.Show($"{rowsAffected} record was updated.", "Congratulations"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } else if (threeTab.SelectedIndex == 2) // ADD MODE { // validate input, check if empty or have duplicated name if (!Validator.TBIsEmpty(threeTxtAddProdName, "Product Name") && !FindDuplicatedProductName(threeTxtAddProdName.Text)) { // validation passed, create new product using user input var newProd = new Products { ProdName = threeTxtAddProdName.Text }; // try to insert into DB try { var id = ProductsDB.AddProduct(newProd); MessageBox.Show($"New product {newProd.ProdName} is added, product id is: {id}.", "Congratulations"); threeTxtAddProdName.Clear(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }