public void DeleteMethodOK()
{
//Create an instance of the class we want to create
clsCourseCollection AllCourses = new clsCourseCollection();
//create the item of test data
clsCourses TestItem = new clsCourses();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.Available = true;
TestItem.IDno = 1;
TestItem.Title = "Web Development";
TestItem.Category = "Technology";
TestItem.Tutor = "R Sunderland";
TestItem.LiveDate = DateTime.Now.Date;
TestItem.Price = 180;
//set ThisCourse to the test data
AllCourses.ThisCourse = TestItem;
//add the record
PrimaryKey = AllCourses.Add();
//set the primary key of the test data
TestItem.IDno = PrimaryKey;
//find the record
AllCourses.ThisCourse.Find(PrimaryKey);
//delete the record
AllCourses.Delete();
//now find the record
Boolean Found = AllCourses.ThisCourse.Find(PrimaryKey);
//test to see that the record was not found
Assert.IsFalse(Found);
}
public void ListAndCountOK()
{
//Create an instance of the class we want to create
clsCourseCollection AllCourses = new clsCourseCollection();
//create some test data to assign to the property
//in this case the data needs to be a list of objects
List <clsCourses> TestList = new List <clsCourses>();
//add an item to the list
//create the item of test data
clsCourses TestItem = new clsCourses();
//set its properties
TestItem.Available = true;
TestItem.IDno = 1;
TestItem.Title = "Computing";
TestItem.Category = "Technology";
TestItem.Tutor = "D Lewis";
TestItem.LiveDate = DateTime.Now.Date;
TestItem.Price = 200;
//add the item to the test list
TestList.Add(TestItem);
//assign the data to the property
AllCourses.CourseList = TestList;
//test to see that the two values are the same
Assert.AreEqual(AllCourses.Count, TestList.Count);
}
public void InstanceOK()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//test to see that it exists
Assert.IsNotNull(aCourse);
}
public void TitleCourseOK()
{//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//create some test data to assign to the course
String TestData = "Computer Science";
//asign the data to the course
aCourse.Title = TestData;
//test to see that the two values are the same
Assert.AreEqual(aCourse.Title, TestData);
}
public void CategoryCourseOK()
{//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//create some test data to assign to the course
String TestData = "Technology";
//asign the data to the course
aCourse.Category = TestData;
//test to see that the two values are the same
Assert.AreEqual(aCourse.Category, TestData);
}
public void TutorCourseOK()
{//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//create some test data to assign to the course
String TestData = "D Armstrong";
//asign the data to the course
aCourse.Tutor = TestData;
//test to see that the two values are the same
Assert.AreEqual(aCourse.Tutor, TestData);
}
public void LiveDateCourseOK()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//create some test data to assign to the course
DateTime TestData = DateTime.Now.Date;
//assign the data to the course
aCourse.LiveDate = TestData;
//test to see that the two values are the same
Assert.AreEqual(aCourse.LiveDate, TestData);
}
public void PriceCourseok()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//create some test data to assign to the course
decimal TestData = 00.00m;
//assign the data to the course
aCourse.Price = TestData;
//test to see that the two values are the same
Assert.AreEqual(aCourse.Price, TestData);
}
public void ValidMethodOK()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//string variable to store any error message
String Error = "";
//invoke the method
Error = aCourse.Valid(Title, Category, Tutor, LiveDate, Price);
//test to see that the result is correct
Assert.AreEqual(Error, "");
}
public void IDCourseOK()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//create some test data to assign to the course
Int32 TestData = 1;
//asign the data to the course
aCourse.IDno = TestData;
//test to see that the two values are the same
Assert.AreEqual(aCourse.IDno, TestData);
}
public void AvailableCourseOK()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//create some test data to assign to the property
Boolean TestData = true;
//assign the data to the course
aCourse.Available = TestData;
//test to see that the two values are the same
Assert.AreEqual(aCourse.Available, TestData);
}
public void PriceInvalidData()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//string variable to store any error message
String Error = "";
//set the LiveDate to a non date value
string Price = "this is not a decimal!";
Error = aCourse.Valid(Title, Category, Tutor, LiveDate, Price);
//test to see that the result is correct
Assert.AreNotEqual(Error, "");
}
public void FindMethodOK()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//boolean variable to store the result of the validation
Boolean Found = false;
//Create some test data to use with the method
Int32 IDno = 1;
//invoke the method
Found = aCourse.Find(IDno);
//Test to see that the result is correct
Assert.IsTrue(Found);
}
public void TutorMaxPlusOne()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//string variable to store any error message
String Error = "";
//create some test data to pass to the method
string Tutor = "aaaaaaaaaaaaaaaaaaabbbbbbb";//this should fail
//invoke the method
Error = aCourse.Valid(Title, Category, Tutor, LiveDate, Price);
//test to see that the result is correct
Assert.AreNotEqual(Error, "");
}
public void LiveDateMin()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//string variable to store any error message
String Error = "";
//create a variable to store the test date data
DateTime TestDate;
//set the date to todays date
TestDate = DateTime.Now.Date;
//convert the date variable to a string variable
string LiveDate = TestDate.ToString();
//invoke the method
Error = aCourse.Valid(Title, Category, Tutor, LiveDate, Price);
//test to see that the result is correct
Assert.AreEqual(Error, "");
}
public void PriceMin()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//string variable to store any error message
String Error = "";
//create a variable to store the test date data
Decimal TestPrice;
//set TestPrice to a value
TestPrice = 00.00m;
//convert the decimal variable to a string variable
string Price = TestPrice.ToString();
//invoke the method
Error = aCourse.Valid(Title, Category, Tutor, LiveDate, Price);
//test to see that the result is correct
Assert.AreEqual(Error, "");
}
public void ThisCoursePropertyOK()
{
//Create an instance of the class we want to create
clsCourseCollection AllCourses = new clsCourseCollection();
//create some test data to assign to the property
clsCourses TestCourses = new clsCourses();
//set the properties of the test object
TestCourses.Available = true;
TestCourses.IDno = 1;
TestCourses.Title = "Computing";
TestCourses.Category = "Technology";
TestCourses.Tutor = "D Lewis";
TestCourses.LiveDate = DateTime.Now.Date;
TestCourses.Price = 200;
//assign the data to the property
AllCourses.ThisCourse = TestCourses;
//test to see that the two values are the same
Assert.AreEqual(AllCourses.ThisCourse, TestCourses);
}
public void TestCategoryFound()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//boolean variable to store the result of the validation
Boolean Found = false;
//boolean variable to record if data is ok (assume it is)
Boolean OK = true;
//create some test data to use with the methods
String Category = Convert.ToString("Technology");
//invoke the method
Found = aCourse.Find(1);
//check the address no
if (aCourse.Category != "Technology")
{
OK = false;
}
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void TestAvailableFound()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//boolean variable to store the result of the validation
Boolean Found = false;
//boolean variable to record if data is ok (assume it is)
Boolean OK = true;
//create some test data to use with the methods
Boolean Available = Convert.ToBoolean(true);
//invoke the method
Found = aCourse.Find(1);
//check the address no
if (aCourse.Available != true)
{
OK = false;
}
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void UpdateMethodOK()
{
//Create an instance of the class we want to create
clsCourseCollection AllCourses = new clsCourseCollection();
//create the item of test data
clsCourses TestItem = new clsCourses();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.Available = true;
TestItem.IDno = 1;
TestItem.Title = "Web Development";
TestItem.Category = "Technology";
TestItem.Tutor = "R Sunderland";
TestItem.LiveDate = DateTime.Now.Date;
TestItem.Price = 180;
//set ThisCourse to the test data
AllCourses.ThisCourse = TestItem;
//add the record
PrimaryKey = AllCourses.Add();
//set the primary key of the test data
TestItem.IDno = PrimaryKey;
//modify the test data
TestItem.Available = false;
TestItem.IDno = 11;
TestItem.Title = "Front-end Web Development";
TestItem.Category = "Technology";
TestItem.Tutor = "S Sunderland";
TestItem.LiveDate = DateTime.Now.Date;
TestItem.Price = 150;
//set the record based on the new test data
AllCourses.ThisCourse = TestItem;
//update the record
AllCourses.Update();
//find the record
AllCourses.ThisCourse.Find(PrimaryKey);
//test to see ThisCourse matches the test data
Assert.AreEqual(AllCourses.ThisCourse, TestItem);
}
protected void Page_Load(object sender, EventArgs e)
{
//create a new instance of clsCourses
clsCourses aCourse = new clsCourses();
//get the data from the session object
aCourse = (clsCourses)Session["aCourse"];
//display the ID for this entry
Response.Write(aCourse.IDno);
//display the Title for this entry
Response.Write(aCourse.Title);
//display the Category for this entry
Response.Write(aCourse.Category);
//display the Tutor for this entry
Response.Write(aCourse.Tutor);
//display the LiveDate for this entry
Response.Write(aCourse.LiveDate);
//display the Available for this entry
Response.Write(aCourse.Available);
//display the Price for this entry
Response.Write(aCourse.Price);
}
public void TestLiveDateFound()
{
//create an instance of the class we want to create
clsCourses aCourse = new clsCourses();
//boolean variable to store the result of the validation
Boolean Found = false;
//boolean variable to record if data is ok (assume it is)
Boolean OK = true;
//create some test data to use with the methods
DateTime LiveDate = Convert.ToDateTime("01/01/2020");
//DateTime LiveDate = 01/01/2020;
//invoke the method
Found = aCourse.Find(1);
//check the address no
if (aCourse.LiveDate != Convert.ToDateTime("01/01/2020"))
{
OK = false;
}
//test to see that the result is correct
Assert.IsTrue(OK);
}
protected void Find_Click(object sender, EventArgs e)
{
//create a new instance of clsCourses
clsCourses aCourse = new clsCourses();
//variable to store the primary key
Int32 IDno;
//variable to store the result of the find operation
Boolean Found = false;
//get the primary key entered by the user
IDno = Convert.ToInt32(txtIDno.Text);
//find the record
Found = aCourse.Find(IDno);
//if found
if (Found == true)
{
//display the values of the properties in the form
txtIDno.Text = aCourse.IDno.ToString();
txtTitleCourse.Text = aCourse.Title;
txtCategoryCourse.Text = aCourse.Category;
txtTutorCourse.Text = aCourse.Tutor;
if (aCourse.LiveDate.Day < 10 & aCourse.LiveDate.Month < 10)
{
txtLiveDateCourse.Text = "0" + aCourse.LiveDate.Day + "/0" + aCourse.LiveDate.Month + "/" + aCourse.LiveDate.Year;
}
else if (aCourse.LiveDate.Day < 10)
{
txtLiveDateCourse.Text = "0" + aCourse.LiveDate.Day + "/" + aCourse.LiveDate.Month + "/" + aCourse.LiveDate.Year;
}
else if (aCourse.LiveDate.Month < 10)
{
txtLiveDateCourse.Text = aCourse.LiveDate.Day + "/0" + aCourse.LiveDate.Month + "/" + aCourse.LiveDate.Year;
}
Available.Text = aCourse.Available.ToString();
txtpriceCourse.Text = aCourse.Price.ToString();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
lblError.Text = "";
//create a new instance of clsCourses
clsCourses aCourse = new clsCourses();
//capture the CourseTitle
string Title = txtTitleCourse.Text;
//capture the courseCategory
string Category = txtCategoryCourse.Text;
//capture the courseTutor
string Tutor = txtTutorCourse.Text;
//capture the courseLiveDate
string LiveDate = txtLiveDateCourse.Text;
//capture the coursePrice
string Price = txtpriceCourse.Text;
//variable to store any error messages
string Error = "";
//validate the data
Error = aCourse.Valid(Title, Category, Tutor, LiveDate, Price);
if (Error == "")
{
//capture the IDno
aCourse.IDno = IDno;
//capture the Title
aCourse.Title = Title;
//capture the Category
aCourse.Category = Category;
//capture the Tutor
aCourse.Tutor = Tutor;
//capture the LiveDate
aCourse.LiveDate = Convert.ToDateTime(LiveDate);
//capture the Price
aCourse.Price = Convert.ToDecimal(Price);
//capture Available
aCourse.Available = Available.Checked;
//create a new instance of the address collection
clsCourseCollection courseList = new clsCourseCollection();
//if this is a new record i.e IDno = -1 then add the data
if (IDno == -1)
{
//set the ThisCourse property
courseList.ThisCourse = aCourse;
//add the new record
courseList.Add();
}
//otherwise it must be an update
else
{
//find the record to update
courseList.ThisCourse.Find(IDno);
//set the ThisCourse property
courseList.ThisCourse = aCourse;
//update the record
courseList.Update();
}
//redirect back to the listpage
Response.Redirect("CourseList.aspx");
}
else
{
//display the error message
lblError.Text = Error;
}
}
