public void FilterItemByDescriptionTestDataFound() { clsItemsCollection FilteredItems = new clsItemsCollection(); //var to store outcome Boolean OK = true; //apply description that does not exist FilteredItems.FilterItemByDescription("test"); //check that the correct numbers of records are found if (FilteredItems.Count == 2) { //check that the first record is ItemNo 76 if (FilteredItems.ItemsList[0].ItemNo != 76) { OK = false; } //check that the first record is ItemNo is 80 if (FilteredItems.ItemsList[1].ItemNo != 80) { OK = false; } else { OK = false; } } Assert.IsTrue(OK); }
public void UpdateMethodOK() { clsItemsCollection AllItems = new clsItemsCollection(); clsItems TestItems = new clsItems(); Int32 PrimaryKey = 0; TestItems.ItemDescription = "test"; TestItems.ItemQuantity = 1; TestItems.ItemPricePerUnit = 1; TestItems.ItemDateOfAvailability = DateTime.Now.Date; TestItems.ItemAvailability = true; AllItems.ThisItem = TestItems; PrimaryKey = AllItems.Add(); TestItems.ItemNo = PrimaryKey; //modify the test data TestItems.ItemDescription = "another item"; TestItems.ItemQuantity = 9; TestItems.ItemPricePerUnit = 5; TestItems.ItemDateOfAvailability = DateTime.Now.Date; TestItems.ItemAvailability = false; //set the record based on the new test data AllItems.ThisItem = TestItems; AllItems.Update(); AllItems.ThisItem.Find(PrimaryKey); //test to see ThisItem matches the test data Assert.AreEqual(AllItems.ThisItem, TestItems); }
public void FilterItemByDescriptionNotFound() { clsItemsCollection FilteredItems = new clsItemsCollection(); FilteredItems.FilterItemByDescription("xxxxxx"); Assert.AreEqual(0, FilteredItems.Count); }
protected void btnYes_Click(object sender, EventArgs e) { clsItemsCollection ItemBook = new clsItemsCollection(); ItemBook.ThisItem.Find(ItemNo); ItemBook.Delete(); Response.Redirect("ItemsList.aspx"); }
public void FilterItemByDescriptionOK() { clsItemsCollection AllItems = new clsItemsCollection(); //create an instance of the filtered data clsItemsCollection FilteredItems = new clsItemsCollection(); FilteredItems.FilterItemByDescription(""); Assert.AreEqual(AllItems.Count, FilteredItems.Count); }
protected void btnClear_Click(object sender, EventArgs e) { clsItemsCollection Items = new clsItemsCollection(); Items.FilterItemByDescription(""); TxtFilter.Text = ""; lstItemsList.DataSource = Items.ItemsList; lstItemsList.DataValueField = "ItemNo"; lstItemsList.DataTextField = "ItemDescription"; lstItemsList.DataBind(); }
void DisplayItems() { clsItemsCollection ItemBook = new clsItemsCollection(); ItemBook.ThisItem.Find(ItemNo); TxtItemNo.Text = ItemBook.ThisItem.ItemNo.ToString(); TxtItemDescription.Text = ItemBook.ThisItem.ItemDescription; TxtItemQuantity.Text = ItemBook.ThisItem.ItemQuantity.ToString(); TxtItemPricePerUnit.Text = ItemBook.ThisItem.ItemPricePerUnit.ToString(); TxtItemDateOfAvailability.Text = ItemBook.ThisItem.ItemDateOfAvailability.ToString(); ItemAvailability.Checked = ItemBook.ThisItem.ItemAvailability; }
protected void btnApply_Click(object sender, EventArgs e) { clsItemsCollection Items = new clsItemsCollection(); Items.FilterItemByDescription(TxtFilter.Text); lstItemsList.DataSource = Items.ItemsList; //set the name of the primary key which is the ItemNo lstItemsList.DataValueField = "ItemNo"; //set the name of the field to display lstItemsList.DataTextField = "ItemDescription"; //bind the data to the list lstItemsList.DataBind(); }
public void ThisItemOK() { clsItemsCollection AllItems = new clsItemsCollection(); clsItems TestItems = new clsItems(); TestItems.ItemNo = 11; TestItems.ItemDescription = "test"; TestItems.ItemQuantity = 1; TestItems.ItemPricePerUnit = 1; TestItems.ItemDateOfAvailability = DateTime.Now.Date; TestItems.ItemAvailability = true; AllItems.ThisItem = TestItems; Assert.AreEqual(AllItems.ThisItem, TestItems); }
public void ListAndCountOK() { clsItemsCollection AllItems = new clsItemsCollection(); List <clsItems> TestList = new List <clsItems>(); clsItems TestItemOfTestData = new clsItems(); TestItemOfTestData.ItemNo = 11; TestItemOfTestData.ItemDescription = "test"; TestItemOfTestData.ItemQuantity = 1; TestItemOfTestData.ItemPricePerUnit = 1; TestItemOfTestData.ItemDateOfAvailability = DateTime.Now.Date; TestItemOfTestData.ItemAvailability = true; TestList.Add(TestItemOfTestData); AllItems.ItemsList = TestList; Assert.AreEqual(AllItems.Count, TestList.Count); }
public void AddMethodOK() { clsItemsCollection AllItems = new clsItemsCollection(); clsItems TestItems = new clsItems(); Int32 PrimaryKey = 0; TestItems.ItemNo = 11; TestItems.ItemDescription = "test"; TestItems.ItemQuantity = 1; TestItems.ItemPricePerUnit = 1; TestItems.ItemDateOfAvailability = DateTime.Now.Date; TestItems.ItemAvailability = true; AllItems.ThisItem = TestItems; PrimaryKey = AllItems.Add(); TestItems.ItemNo = PrimaryKey; Assert.AreEqual(AllItems.ThisItem, TestItems); }
protected void btnOK_Click(object sender, EventArgs e) { clsItems AnItem = new clsItems(); string ItemDescription = TxtItemDescription.Text; string ItemQuantity = TxtItemQuantity.Text; string ItemPricePerUnit = TxtItemPricePerUnit.Text; string ItemDateOfAvailability = TxtItemDateOfAvailability.Text; string Error = ""; Error = AnItem.Valid(ItemDescription, ItemQuantity, ItemPricePerUnit, ItemDateOfAvailability); if (Error == "") { AnItem.ItemNo = ItemNo; AnItem.ItemDescription = ItemDescription; AnItem.ItemQuantity = Convert.ToInt32(ItemQuantity); AnItem.ItemPricePerUnit = Convert.ToDecimal(ItemPricePerUnit); AnItem.ItemDateOfAvailability = Convert.ToDateTime(ItemDateOfAvailability); AnItem.ItemAvailability = ItemAvailability.Checked; clsItemsCollection ItemsList = new clsItemsCollection(); if (ItemNo == -1) { ItemsList.ThisItem = AnItem; ItemsList.Add(); } else { ItemsList.ThisItem.Find(ItemNo); ItemsList.ThisItem = AnItem; ItemsList.Update(); } Response.Redirect("ItemsList.aspx"); } else { lblError.Text = Error; } }
public void ItemsListOK() //the ItemList will provide us with an indexed list of Items from the database table { clsItemsCollection AllItems = new clsItemsCollection(); List <clsItems> TestList = new List <clsItems>(); clsItems TestItemOfTestData = new clsItems(); TestItemOfTestData.ItemNo = 11; TestItemOfTestData.ItemDescription = "test"; TestItemOfTestData.ItemQuantity = 1; TestItemOfTestData.ItemPricePerUnit = 1; TestItemOfTestData.ItemDateOfAvailability = DateTime.Now.Date; TestItemOfTestData.ItemAvailability = true; //add the item to the test list TestList.Add(TestItemOfTestData); //assign data to the property AllItems.ItemsList = TestList; Assert.AreEqual(AllItems.ItemsList, TestList); }
public void DeleteMethodOK() { clsItemsCollection AllItems = new clsItemsCollection(); clsItems TestItems = new clsItems(); Int32 PrimaryKey = 0; TestItems.ItemNo = 11; TestItems.ItemDescription = "test"; TestItems.ItemQuantity = 1; TestItems.ItemPricePerUnit = 1; TestItems.ItemDateOfAvailability = DateTime.Now.Date; TestItems.ItemAvailability = true; AllItems.ThisItem = TestItems; PrimaryKey = AllItems.Add(); TestItems.ItemNo = PrimaryKey; AllItems.ThisItem.Find(PrimaryKey); AllItems.Delete(); Boolean Found = AllItems.ThisItem.Find(PrimaryKey); Assert.IsFalse(Found); }
public void InstanceOK() { clsItemsCollection AllItems = new clsItemsCollection(); Assert.IsNotNull(AllItems); }