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 ReportByCategoryTestDataFound()
{
//create an instance of the filtered data
clsCourseCollection FilteredCourses = new clsCourseCollection();
//var to store outcome
Boolean OK = true;
//apply a category that doesnt exist
FilteredCourses.ReportByCategory("Science");
//check that the correct number of records are found
if (FilteredCourses.Count == 2)
{
//check that the first record is ID 36
if (FilteredCourses.CourseList[0].IDno != 2)
{
OK = false;
}
//check that the first record is ID 37
if (FilteredCourses.CourseList[1].IDno != 6)
{
OK = false;
}
}
else
{
OK = false;
}
//test to see that there are no records
Assert.IsTrue(OK);
}
void DisplayCourses()
{
//create and instance of the Courses
clsCourseCollection Courses = new clsCourseCollection();
//find the record to update
Courses.ThisCourse.Find(IDno);
//display the data for this record
txtIDno.Text = Courses.ThisCourse.IDno.ToString();
txtTitleCourse.Text = Courses.ThisCourse.Title;
txtCategoryCourse.Text = Courses.ThisCourse.Category;
txtTutorCourse.Text = Courses.ThisCourse.Tutor;
if (Courses.ThisCourse.LiveDate.Day < 10 & Courses.ThisCourse.LiveDate.Month < 10 & Courses.ThisCourse.LiveDate.Year < 2)
{
txtLiveDateCourse.Text = "0" + Courses.ThisCourse.LiveDate.Day + "/0" + Courses.ThisCourse.LiveDate.Month + "/000" + Courses.ThisCourse.LiveDate.Year;
}
else if (Courses.ThisCourse.LiveDate.Day < 10 & Courses.ThisCourse.LiveDate.Month < 10)
{
txtLiveDateCourse.Text = "0" + Courses.ThisCourse.LiveDate.Day + "/0" + Courses.ThisCourse.LiveDate.Month + "/" + Courses.ThisCourse.LiveDate.Year;
}
else if (Courses.ThisCourse.LiveDate.Day < 10)
{
txtLiveDateCourse.Text = "0" + Courses.ThisCourse.LiveDate.Day + "/" + Courses.ThisCourse.LiveDate.Month + "/" + Courses.ThisCourse.LiveDate.Year;
}
else if (Courses.ThisCourse.LiveDate.Month < 10)
{
txtLiveDateCourse.Text = Courses.ThisCourse.LiveDate.Day + "/0" + Courses.ThisCourse.LiveDate.Month + "/" + Courses.ThisCourse.LiveDate.Year;
}
else if (Courses.ThisCourse.LiveDate.Year < 2)
{
txtLiveDateCourse.Text = Courses.ThisCourse.LiveDate.Day + "/0" + Courses.ThisCourse.LiveDate.Month + "/000" + Courses.ThisCourse.LiveDate.Year;
}
Available.Checked = Courses.ThisCourse.Available;
txtpriceCourse.Text = Courses.ThisCourse.Price.ToString();
}
public void InstanceOK()
{
//Create an instance of the class we want to create
clsCourseCollection AllCourses = new clsCourseCollection();
//test to see that it exists
Assert.IsNotNull(AllCourses);
}
public void ReportByCategoryNoneFound()
{
//create an instance of the filtered data
clsCourseCollection FilteredCourses = new clsCourseCollection();
//apply a category that doesnt exist
FilteredCourses.ReportByCategory("xxx xxx");
//test to see that there are no records
Assert.AreEqual(0, FilteredCourses.Count);
}
public void ReportByCategoryMethodOK()
{
//create an instance of the class containing unfiltered results
clsCourseCollection AllCourses = new clsCourseCollection();
//create an instance of the filtered data
clsCourseCollection FilteredCourses = new clsCourseCollection();
//apply a blank string (should return all records);
FilteredCourses.ReportByCategory("");
//test to see that the two values are the same
Assert.AreEqual(AllCourses.Count, FilteredCourses.Count);
}
protected void btnYes_Click(object sender, EventArgs e)
{
//create a new instance of the courses
clsCourseCollection CourseBook = new clsCourseCollection();
//find the record to delete
CourseBook.ThisCourse.Find(IDno);
//delete the record
CourseBook.Delete();
//redirect back to the main page
Response.Redirect("CourseList.aspx");
}
protected void btnApply_Click(object sender, EventArgs e)
{
//create an instance of the course collection
clsCourseCollection Courses = new clsCourseCollection();
Courses.ReportByCategory(txtFilter.Text);
lstCourseList.DataSource = Courses.CourseList;
//set the name of the primary key
lstCourseList.DataValueField = "IDno";
//set the name of the field to display
lstCourseList.DataTextField = "Title";
//bind the data to the list
lstCourseList.DataBind();
}
protected void btnClear_Click(object sender, EventArgs e)
{
//create an instance of the course collection
clsCourseCollection Courses = new clsCourseCollection();
Courses.ReportByCategory("");
//clear any existing filter to tidy up the interface
txtFilter.Text = "";
lstCourseList.DataSource = Courses.CourseList;
//set the name of the primary key
lstCourseList.DataValueField = "IDno";
//set the name of the field to display
lstCourseList.DataTextField = "Title";
//bind the data to the list
lstCourseList.DataBind();
}
Int32 DisplayCourses()
{
clsCourseCollection Courses = new clsCourseCollection();
string CourseNo;
string Course;
Int32 Index = 0;
while (Index < Courses.Count)
{
CourseNo = Convert.ToString(Courses.AllCourses[Index].CourseNo);
Course = Courses.AllCourses[Index].CourseName;
ListItem NewCourse = new ListItem(Course, CourseNo);
ddlStudentCourse.Items.Add(NewCourse);
Index++;
}
return(Courses.Count);
}
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 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 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;
}
}
