public void ReportByProductNameNoneFound() { clsProductCollection FilteredProducts = new clsProductCollection(); FilteredProducts.ReportByProductName("abcdefg"); Assert.AreEqual(0, FilteredProducts.Count); }
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); }
//function for updating records void Update() { 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 == "") { //find the record to update ProductCollect.ThisProduct.Find(ProductNo); //get data entered by the user ProductCollect.ThisProduct.ProductName = txtProductName.Text; ProductCollect.ThisProduct.Description = txtDescription.Text; ProductCollect.ThisProduct.Price = Convert.ToDecimal(txtPrice.Text); ProductCollect.ThisProduct.Active = chkActive.Checked; //update the record ProductCollect.Update(); //all done so redirect to the main page Response.Redirect("ProductDefault.aspx"); } else { //report an error lblError.Text = "There were problems with the data entered " + Error; } }
public void ProductListOK() { //create an instance for the class we want to create clsProductCollection AllProducts = new clsProductCollection(); //create some test data to assign to the property //in this case the data needs to be a list of objects List <clsProduct> TestList = new List <clsProduct>(); //add an item to the list //create the item of the test data clsProduct TestItem = new clsProduct(); //set its properties TestItem.CategoryID = 2; TestItem.NoAvailable = 10; TestItem.ProductDetail = "used"; TestItem.ProductID = 3; TestItem.ProductName = "laptop"; TestItem.ProductPrice = 650.00m; //add the item to the test list TestList.Add(TestItem); //assign the data to the property AllProducts.ProductList = TestList; //test to see that the two values are the same Assert.AreEqual(AllProducts.ProductList, TestList); }
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 ReportByGenreTestDataFound() { clsProductCollection FilteredProducts = new clsProductCollection(); Boolean OK = true; FilteredProducts.ReportByGenre("Role-playing"); //check that the correct number of records are found if (FilteredProducts.Count == 2) { //check that the first record product_id is 000003 if (FilteredProducts.ProductList[0].Product_ID != 000003) { OK = true; } //check that the first record product_id is 000004 if (FilteredProducts.ProductList[0].Product_ID != 000004) { OK = false; } else { OK = false; } //test to see that there are no records Assert.IsTrue(OK); } }
Int32 DisplayProductName(string ProductNameFilter) { Int32 ProductNo; // var to store the primary key string ProductName; // var to store the surname //create an instance of the address collection class clsProductCollection Product = new clsProductCollection(); Product.ReportByProductName(ProductNameFilter); Int32 RecordCount; // var to store the count of records Int32 Index = 0; // var to store the index for the loop RecordCount = Product.Count; //get the count of records lstProduct.Items.Clear(); while (Index < RecordCount) // while there are records to process { ProductNo = Product.ProductList[Index].ProductNo; //get the primary key ProductName = Product.ProductList[Index].ProductName; //get the Surnanme //create a new entry for the listbox ListItem NewEntry = new ListItem(ProductName, ProductNo.ToString()); lstProduct.Items.Add(NewEntry); Index++; } return(RecordCount);//return the count of records found }
public void ReportByGenreNoneFound() { clsProductCollection FilteredProducts = new clsProductCollection(); FilteredProducts.ReportByGenre("HotDog Sales"); Assert.AreEqual(0, FilteredProducts.Count); }
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 ReportByTypeDataFound() { clsProductCollection FilteredProducts = new clsProductCollection(); Boolean OK = true; FilteredProducts.ReportByType("Cape"); if (FilteredProducts.Count == 2) { if (FilteredProducts.ProductsList[0].Product_ID != 1) { OK = false; } if (FilteredProducts.ProductsList[1].Product_ID != 9) { OK = false; } } else { OK = false; } Assert.IsTrue(OK); }
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 btnConfirm_Click(object sender, EventArgs e) { clsProductCollection ProductBook = new clsProductCollection(); ProductBook.ThisProduct.Find(ProductNo); ProductBook.Delete(); Response.Redirect("ProductList.aspx"); }
public void ReportByTypeNoneFound() { clsProductCollection FilteredProducts = new clsProductCollection(); FilteredProducts.ReportByType("Jeff"); Assert.AreEqual(0, FilteredProducts.Count); }
public void ReportByProductNameMethodOK() { clsProductCollection Products = new clsProductCollection(); clsProductCollection FilteredProducts = new clsProductCollection(); FilteredProducts.ReportByProductName(""); Assert.AreEqual(Products.Count, FilteredProducts.Count); }
protected void BtnYes_Click(object sender, EventArgs e) { clsProductCollection ProductList = new clsProductCollection(); ProductList.ThisProduct.Find(ProductId); ProductList.Delete(); Response.Redirect("ProductList"); }
public void InstanceOK() { //create an instance of the class we want to create clsProductCollection AllProducts = new clsProductCollection(); //test to see that it exists Assert.IsNotNull(AllProducts); }
void DeleteProduct() { clsProductCollection ProductCollect = new clsProductCollection(); //find the record to delete ProductCollect.ThisProduct.Find(ProductNo); //delete the record ProductCollect.Delete(); }
protected void Page_Load(object sender, EventArgs e) { ProductNo = Convert.ToInt32(Session["ProductNo"]); clsProductCollection ProductBook = new clsProductCollection(); ProductBook.ThisProduct.Find(ProductNo); lblName.Text = ProductBook.ThisProduct.ProductName; lblDesc.Text = ProductBook.ThisProduct.ProductDescription; }
protected void btnApply_Click(object sender, EventArgs e) { clsProductCollection Products = new clsProductCollection(); Products.ReportByProductName(txtNameSearch.Text); ProductListBox.DataSource = Products.ProductList; ProductListBox.DataValueField = "ProductNo"; ProductListBox.DataTextField = "ProductName"; ProductListBox.DataBind(); }
protected void BtnApply_Click(object sender, EventArgs e) { clsProductCollection Products = new clsProductCollection(); Products.ReportByType(TxtType.Text); LstProductList.DataSource = Products.ProductsList; LstProductList.DataTextField = "Type"; LstProductList.DataBind(); }
public void ReportByProductNameNoneFound() { //create an instance of the filtered data clsProductCollection FilteredProduct = new clsProductCollection(); //apply a Product name that doesn't exist FilteredProduct.ReportByProductName("qqqqq"); //test to see that there are no records Assert.AreEqual(0, FilteredProduct.Count); }
public void ReportByProductNameOK() { //create an instance of the class containing unfiltered results clsProductCollection AllProducts = new clsProductCollection(); //create an instance of the filtered data clsProductCollection FilteredProduct = new clsProductCollection(); //apply a blank string(Should return all records); FilteredProduct.ReportByProductName(""); //test to see that the two values are the same Assert.AreEqual(AllProducts.Count, FilteredProduct.Count); }
protected void btnYes_Click(object sender, EventArgs e) { //CREATE A NEW INSTANCE OF THE PRODUCT LIST clsProductCollection ProductList = new clsProductCollection(); //find the record to delete ProductList.ThisProduct.Find(Product_ID); //delete the record ProductList.Delete(); //redirect back to the main page Response.Redirect("ProductList.aspx"); }
void DisplayProduct() { clsProductCollection ProductBook = new clsProductCollection(); ProductBook.ThisProduct.Find(ProductNo); //display data from product object in the form for editing. txtProductNo.Text = ProductBook.ThisProduct.ProductNo.ToString(); txtProductName.Text = ProductBook.ThisProduct.ProductName; txtProductDescription.Text = ProductBook.ThisProduct.ProductDescription; txtUnitPrice.Text = ProductBook.ThisProduct.UnitPrice.ToString(); txtStockAmount.Text = ProductBook.ThisProduct.StockAmount.ToString(); txtDiscountPercentage.Text = ProductBook.ThisProduct.DiscountPercentage.ToString(); }
protected void btnApply_Click(object sender, EventArgs e) { clsProductCollection Products = new clsProductCollection(); //Products.ReportByGenre(txtFilter.Text); lstProductList.DataSource = Products.ProductList; //set the name of the primary field lstProductList.DataValueField = "Product_ID"; //SET THE NAME OF THE FIELD TO DISPLAY lstProductList.DataTextField = "Genre"; //bind the data to the list lstProductList.DataBind(); }
void DisplayProduct() { //create an instance of Product Collection clsProductCollection ProductCollect = new clsProductCollection(); //find the record to update ProductCollect.ThisProduct.Find(ProductNo); //display the data for this record txtProductName.Text = ProductCollect.ThisProduct.ProductName; txtDescription.Text = ProductCollect.ThisProduct.Description; txtPrice.Text = ProductCollect.ThisProduct.Price.ToString(); chkActive.Checked = ProductCollect.ThisProduct.Active; }
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; } }
void DisplayProduct() { //create an instance of the Product collection clsProductCollection Product = new clsProductCollection(); //set the source to the list of Product in the collection lstProduct.DataSource = Product.ProductList; //get the primary key lstProduct.DataValueField = "ProductNo"; //set the data field to display lstProduct.DataTextField = "ProductName"; //bind data to the list lstProduct.DataBind(); }