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);
}
