public void DeleteMethodOK()
{
//create instance of the class we want to create
clsConsoleCollection AllConsoles = new clsConsoleCollection();
clsConsole TestItem = new clsConsole();
Int32 PrimaryKey = 0;
//sets properties
TestItem.ConsoleNo = 1;
TestItem.Name = "Xbox";
TestItem.Manufacturer = "Microsoft";
TestItem.Price = 250;
TestItem.Stock = 10000;
AllConsoles.ThisConsole = TestItem;
//add record
PrimaryKey = AllConsoles.Add();
TestItem.ConsoleNo = PrimaryKey;
AllConsoles.ThisConsole.Find(PrimaryKey);
AllConsoles.Delete();
//finds record
Boolean Found = AllConsoles.ThisConsole.Find(PrimaryKey);
//tests to see that record was not found
Assert.IsFalse(Found);
}
public void UpdateMethodOK()
{
//create instance of class we want to create
clsConsoleCollection AllConsoles = new clsConsoleCollection();
//creates item for test data
clsConsole TestItem = new clsConsole();
Int32 PrimaryKey = 0;
//set properties
TestItem.ConsoleNo = 1;
TestItem.Name = "Xbox";
TestItem.Manufacturer = "Microsoft";
TestItem.Price = 250;
TestItem.Stock = 10000;
AllConsoles.ThisConsole = TestItem;
PrimaryKey = AllConsoles.Add();
//modify test data
TestItem.ConsoleNo = 5;
TestItem.Name = "PlayStation 4 Pro";
TestItem.Manufacturer = "Sony";
TestItem.Price = 400;
TestItem.Stock = 2000;
AllConsoles.ThisConsole = TestItem;
//update record
AllConsoles.Update();
//find record
AllConsoles.ThisConsole.Find(PrimaryKey);
//test to see ThisConsole matches test data
Assert.AreEqual(AllConsoles.ThisConsole, TestItem);
}
public void AddMethodOK()
{
clsConsoleCollection AllConsoles = new clsConsoleCollection();
clsConsole TestItem = new clsConsole();
Int32 PrimaryKey = 0;
//sets properties
TestItem.ConsoleNo = 1;
TestItem.Name = "Xbox";
TestItem.Manufacturer = "Microsoft";
TestItem.Price = 250;
TestItem.Stock = 10000;
AllConsoles.ThisConsole = TestItem;
PrimaryKey = AllConsoles.Add();
TestItem.ConsoleNo = PrimaryKey;
AllConsoles.ThisConsole.Find(PrimaryKey);
Assert.AreEqual(AllConsoles.ThisConsole, TestItem);
}
