public void DeleteMethodOK() { //create an instance of the class we want to create clsProductCollection AllProducts = new clsProductCollection(); //create the item of test data clsProduct TestItem = new clsProduct(); Int32 PrimaryKey = 0; //set its properties TestItem.ProductNo = 1; TestItem.ProductName = "Samsung"; TestItem.Description = "Black"; TestItem.Price = 1299; TestItem.Active = true; //set ThisProduct to test the data AllProducts.ThisProduct = TestItem; //add the record PrimaryKey = AllProducts.Add(); TestItem.ProductNo = PrimaryKey; //find the record AllProducts.ThisProduct.Find(PrimaryKey); //delete the record AllProducts.Delete(); //now find the record Boolean Found = AllProducts.ThisProduct.Find(PrimaryKey); //test to see that the record was not found Assert.IsFalse(Found); }
public void UpdateMethodOK() { clsProductCollection Products = new clsProductCollection(); clsProduct TestProduct = new clsProduct(); Int32 PrimaryKey = 0; TestProduct.ProductName = "Metal Gear Ray Figure"; TestProduct.ProductDescription = "A die-cast figurine of Metal Gear Ray from Metal Gear Solid 2."; TestProduct.UnitPrice = 90.00; TestProduct.InStock = true; TestProduct.StockAmount = 1; TestProduct.DiscountPercentage = 0; TestProduct.DiscountActive = false; Products.ThisProduct = TestProduct; PrimaryKey = Products.Add(); TestProduct.ProductNo = PrimaryKey; TestProduct.ProductName = "Metal Gear Solid Snake Figure"; TestProduct.ProductDescription = "A die-cast figurine of Solid Snake from Metal Gear Solid."; TestProduct.UnitPrice = 60.00; TestProduct.InStock = false; TestProduct.StockAmount = 0; TestProduct.DiscountPercentage = 20; TestProduct.DiscountActive = true; Products.ThisProduct = TestProduct; Products.Update(); Products.ThisProduct.Find(PrimaryKey); Assert.AreEqual(Products.ThisProduct, TestProduct); }
public void UpdateMethodOK() { //create an instance of the class we want to create clsProductCollection AllProducts = new clsProductCollection(); //create the item of test data clsProduct TestItem = new clsProduct(); Int32 PrimaryKey = 0; //set its properties TestItem.ProductName = "Samsung S9"; TestItem.Description = "Black"; TestItem.Price = 1234; TestItem.Active = true; //set ThisProduct to test the data AllProducts.ThisProduct = TestItem; //add the record PrimaryKey = AllProducts.Add(); //set primary key of TestItem.ProductNo = PrimaryKey; //modify the test data TestItem.ProductName = "IPhone"; TestItem.Description = "Gold"; TestItem.Price = 124; TestItem.Active = false; //set the record based on the new test data AllProducts.ThisProduct = TestItem; //update the record AllProducts.Update(); //find the record AllProducts.ThisProduct.Find(PrimaryKey); //test to see ThisStaff matches the test data Assert.AreEqual(AllProducts.ThisProduct, TestItem); }
public void AddMethodOK() { //create an instance of the class we want to create clsProductCollection AllProducts = new clsProductCollection(); //creat the item of test data clsProduct TestProduct = new clsProduct(); //var to store the primary key Int32 PrimaryKey = 0; //set its properties //TestProduct.Out_Of_Stock = true; TestProduct.Product_ID = 000007; TestProduct.Title = "Test"; TestProduct.Description = "Testing"; TestProduct.Unit_Price = Convert.ToDouble("50.00"); TestProduct.Release_Date = Convert.ToDateTime("12/08/1991"); TestProduct.Genre = "Horror"; TestProduct.Platform = "Sega Megadrive"; //set thisproduct to the test data AllProducts.ThisProduct = TestProduct; //add the record PrimaryKey = AllProducts.Add(); //Set the primary key of the test data TestProduct.Product_ID = PrimaryKey; //find the record AllProducts.ThisProduct.Find(PrimaryKey); //test to see that the two values are the same Assert.AreEqual(AllProducts.ThisProduct, TestProduct); }
public void DeleteMethodOK() { clsProductCollection AllProducts = new clsProductCollection(); clsProduct TestItem = new clsProduct(); Int32 PrimaryKey = 0; TestItem.Product_ID = 1; TestItem.Name = "Dave"; TestItem.Type = "Dave"; TestItem.Colour = "Dave"; TestItem.Cost = 1; TestItem.Stock_Count = 1; TestItem.Is_Available = true; TestItem.Next_Delivery = DateTime.Now.Date; AllProducts.ThisProduct = TestItem; PrimaryKey = AllProducts.Add(); TestItem.Product_ID = PrimaryKey; AllProducts.ThisProduct.Find(PrimaryKey); AllProducts.Delete(); Boolean Found = AllProducts.ThisProduct.Find(PrimaryKey); Assert.IsFalse(Found); }
protected void OK_Click(object sender, EventArgs e) { clsProduct AProduct = new clsProduct(); String ProductName = txtProductName.Text; String ProductDescription = txtProductDescription.Text; String UnitPrice = txtUnitPrice.Text; String StockAmount = txtStockAmount.Text; String DiscountPercentage = txtDiscountPercentage.Text; String Error = ""; Error = AProduct.Valid(ProductName, ProductDescription, UnitPrice, StockAmount, DiscountPercentage); if (Error == "") { if (Convert.ToInt32(StockAmount) == 0) { AProduct.InStock = false; } else { AProduct.InStock = true; } if (Convert.ToInt32(DiscountPercentage) == 0) { AProduct.DiscountActive = false; } else { AProduct.DiscountActive = true; } AProduct.ProductNo = ProductNo; AProduct.ProductName = ProductName; AProduct.ProductDescription = ProductDescription; AProduct.UnitPrice = Convert.ToDouble(UnitPrice); AProduct.StockAmount = Convert.ToInt32(StockAmount); AProduct.DiscountPercentage = Convert.ToInt32(DiscountPercentage); AProduct.Active = Active.Checked; clsProductCollection Products = new clsProductCollection(); if (ProductNo == -1) { Products.ThisProduct = AProduct; Products.Add(); } else { Products.ThisProduct.Find(ProductNo); Products.ThisProduct = AProduct; Products.Update(); } Response.Redirect("ProductList.aspx"); } else { lblError.Text = Error; } }
protected void btnOK_Click(object sender, EventArgs e) { clsProduct AProduct = new clsProduct(); int Product_ID = Convert.ToInt32(TxtID.Text); string Name = TxtName.Text; string Type = TxtType.Text; string Colour = TxtColour.Text; int Cost = Convert.ToInt32(TxtCost.Text); int Stock_Count = Convert.ToInt32(TxtStock_Count.Text); string Next_Delivery = TxtNext_Delivery.Text; string Error = ""; Error = AProduct.Valid(Product_ID, Name, Type, Colour, Cost, Stock_Count, Next_Delivery); if (Error == "") { AProduct.Product_ID = ProductId; AProduct.Name = TxtName.Text; AProduct.Type = TxtType.Text; AProduct.Colour = TxtColour.Text; AProduct.Cost = Convert.ToInt32(TxtCost.Text); AProduct.Stock_Count = Convert.ToInt32(TxtStock_Count.Text); AProduct.Is_Available = Convert.ToBoolean(ChkAvailable.Checked); AProduct.Next_Delivery = Convert.ToDateTime(TxtNext_Delivery.Text); clsProductCollection ProductList = new clsProductCollection(); if (ProductId == -1) { ProductList.ThisProduct = AProduct; ProductList.Add(); } else { ProductList.ThisProduct.Find(ProductId); ProductList.ThisProduct = AProduct; Response.Redirect("ProductList.aspx"); } Response.Redirect("ProductViewer.aspx"); } else { LblError.Text = Error; } }
public void DeleteMethodOK() { clsProductCollection Products = new clsProductCollection(); clsProduct TestProduct = new clsProduct(); Int32 PrimaryKey = 0; TestProduct.ProductName = "Metal Gear Ray Figure"; TestProduct.ProductDescription = "A die-cast figurine of Metal Gear Ray from Metal Gear Solid 2."; TestProduct.UnitPrice = 90.00; TestProduct.InStock = true; TestProduct.StockAmount = 1; TestProduct.DiscountPercentage = 0; TestProduct.DiscountActive = false; Products.ThisProduct = TestProduct; PrimaryKey = Products.Add(); TestProduct.ProductNo = PrimaryKey; Products.ThisProduct.Find(PrimaryKey); Products.Delete(); Boolean Found = Products.ThisProduct.Find(PrimaryKey); }
//function for creating new records void Add() { clsProductCollection ProductCollect = new clsProductCollection(); String Error = ProductCollect.ThisProduct.Valid(txtProductName.Text, txtDescription.Text, txtPrice.Text); //if the data is OK then add it to the objct if (Error == "") { ProductCollect.ThisProduct.ProductName = txtProductName.Text; ProductCollect.ThisProduct.Description = txtDescription.Text; ProductCollect.ThisProduct.Price = Convert.ToDecimal(txtPrice.Text); ProductCollect.ThisProduct.Active = chkActive.Checked; //add the record ProductCollect.Add(); //all done so redirect back to the main page Response.Redirect("ProductDefault.aspx"); } else { lblError.Text = "There were problems with the data entered" + Error; } }
public void DeleteMethodOK() { clsProductCollection AllProducts = new clsProductCollection(); clsProduct TestProduct = new clsProduct(); Int32 PrimaryKey = 0; TestProduct.Product_ID = 000007; TestProduct.Title = "Test"; TestProduct.Description = "Testing"; TestProduct.Unit_Price = Convert.ToDouble("50.00"); TestProduct.Release_Date = Convert.ToDateTime("12/08/1991"); TestProduct.Genre = "Horror"; TestProduct.Platform = "Sega Megadrive"; AllProducts.ThisProduct = TestProduct; PrimaryKey = AllProducts.Add(); TestProduct.Product_ID = PrimaryKey; AllProducts.ThisProduct.Find(PrimaryKey); AllProducts.Delete(); Boolean Found = AllProducts.ThisProduct.Find(PrimaryKey); Assert.IsFalse(Found); }
public void UpdateMethodOK() { clsProductCollection AllProducts = new clsProductCollection(); clsProduct TestProduct = new clsProduct(); Int32 PrimaryKey = 0; //set its propertieis TestProduct.Product_ID = 000022; TestProduct.Title = "Test"; TestProduct.Description = "Testing"; TestProduct.Unit_Price = Convert.ToDouble("50.00"); TestProduct.Release_Date = Convert.ToDateTime("12/08/1991"); TestProduct.Out_Of_Stock = "0"; TestProduct.Genre = "Horror"; TestProduct.Platform = "Sega Megadrive"; AllProducts.ThisProduct = TestProduct; //add test data PrimaryKey = AllProducts.Add(); //set primary key of test data TestProduct.Product_ID = PrimaryKey; //modify the test data TestProduct.Product_ID = 000007; TestProduct.Title = "Test2"; TestProduct.Description = "2Testing"; TestProduct.Unit_Price = Convert.ToDouble("60.00"); TestProduct.Release_Date = Convert.ToDateTime("12/08/1998"); TestProduct.Genre = "Rythem"; TestProduct.Platform = "Sega Saturn"; AllProducts.ThisProduct = TestProduct; //set the record based on the new test data AllProducts.ThisProduct = TestProduct; //update the record AllProducts.Update(); //find the record AllProducts.ThisProduct.Find(PrimaryKey); //test to see thisproduct matches the test data Assert.AreEqual(AllProducts.ThisProduct, TestProduct); }
public void UpdateMethodOK() { clsProductCollection AllProducts = new clsProductCollection(); clsProduct TestItem = new clsProduct(); Int32 PrimaryKey = 0; TestItem.Name = "Dave"; TestItem.Type = "Dave"; TestItem.Colour = "Dave"; TestItem.Cost = 1; TestItem.Stock_Count = 1; TestItem.Is_Available = true; TestItem.Next_Delivery = DateTime.Now.Date; AllProducts.ThisProduct = TestItem; PrimaryKey = AllProducts.Add(); TestItem.Product_ID = PrimaryKey; TestItem.Name = "Joe"; TestItem.Type = "Joe"; TestItem.Colour = "Joe"; TestItem.Cost = 21; TestItem.Stock_Count = 12; TestItem.Is_Available = false; TestItem.Next_Delivery = DateTime.Now.Date; AllProducts.ThisProduct = TestItem; AllProducts.Update(); AllProducts.ThisProduct.Find(PrimaryKey); Assert.AreEqual(AllProducts.ThisProduct, TestItem); }
public void AddMethodOK() { //create an instance of the class we want to create clsProductCollection AllProducts = new clsProductCollection(); //create the item of test data clsProduct TestItem = new clsProduct(); Int32 PrimaryKey = 0; //set its properties TestItem.ProductNo = 1; TestItem.ProductName = "Samsung"; TestItem.Description = "Black"; TestItem.Price = 1299; TestItem.Active = true; //set ThisProduct to test the data AllProducts.ThisProduct = TestItem; //add the record PrimaryKey = AllProducts.Add(); TestItem.ProductNo = PrimaryKey; //find the record AllProducts.ThisProduct.Find(PrimaryKey); //test to see that the two values are the same Assert.AreEqual(AllProducts.ThisProduct, TestItem); }
//event handler for the ok button protected void btnOK_Click(object sender, EventArgs e) { //creates a new instance of clsProduct clsProduct AProduct = new clsProduct(); //capture product_id string ProductID = Convert.ToString(txtProductID); //capture title string Title = txtTitle.Text; //Capture Description string Description = txtDescription.Text; //Capture unit price string Unit_Price = txtUnitPrice.Text; //Capture Platform string Platform = txtPlatform.Text; //Capture Release_Date string Release_Date = txtReleaseDate.Text; //Capture Genre string Genre = txtGenre.Text; //Capture Out of stock string Out_Of_Stock = txtOut_Of_Stock.Text; //variable to store any error messages string Error = ""; //validate the data Error = AProduct.Valid(Title, Description, Unit_Price, Release_Date, Platform, Genre); if (Error == "") { //capture the product id AProduct.Product_ID = Product_ID; //capture the title AProduct.Title = Title; //capture the Description AProduct.Description = Description; //capture the Unit price AProduct.Unit_Price = Convert.ToDouble(Unit_Price); //capture the genre AProduct.Genre = Genre; //Capture the platform AProduct.Platform = Platform; //Capture the release date AProduct.Release_Date = Convert.ToDateTime(Release_Date); //capture the out of stock status AProduct.Out_Of_Stock = Out_Of_Stock; //Create a new instance of the address collection clsProductCollection ProductList = new clsProductCollection(); //if this is a new record then add the data if (Product_ID == -1) { //set the ThisProduct property ProductList.ThisProduct = AProduct; //Add the new record ProductList.Add(); } else//otherwise must be an update { //find the record to update ProductList.ThisProduct.Find(Product_ID); //set the thisproduct property ProductList.ThisProduct = AProduct; //update the record ProductList.Update(); } //Redirect back to the listpage Response.Redirect("ProductList.aspx"); } else { //display the error message lblError.Text = Error; } //store the product id in the session object Session["AProduct"] = AProduct; //Redirect to the viewer page Response.Redirect("ProductViewer.aspx"); }