public void ConsultantListOK()
{
//create an instance of the class we want to create
clsConsultantCollection AllConsultants = new clsConsultantCollection();
//create some test data to assign to the property
//in this case the data needs to be a list of objects
List<clsConsultant> TestList = new List<clsConsultant>();
//add an item to the list
//create the item of the test data
clsConsultant TestItem = new clsConsultant();
//set its properties
TestItem.Status = true;
TestItem.ConsultantNo = 1;
TestItem.FirstName = "John";
TestItem.LastName = "Wayne";
TestItem.DateOfBirth = DateTime.Now.Date;
TestItem.Address = "Flat BC, 2 Cilantro Road";
TestItem.Email = "*****@*****.**";
TestItem.TelephoneNo = "07437320192";
TestItem.EmergencyContact = "07528789924";
TestItem.EmploymentDate = DateTime.Now.Date;
TestItem.HoursOfWork = 172;
TestItem.EmploymentHistory = "None";
TestItem.DateAdded = DateTime.Now.Date;
//add the item to the test list
TestList.Add(TestItem);
//assign the data to the property
AllConsultants.ConsultantList = TestList;
//test to see that the two values are the same
Assert.AreEqual(AllConsultants.ConsultantList, TestList);
}
public void AddMethodOK()
{
//create an instance of the class we want to create
clsConsultantCollection AllConsultants = new clsConsultantCollection();
clsConsultant TestItem = new clsConsultant();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.Status = true;
TestItem.ConsultantNo = 120;
TestItem.FirstName = "James";
TestItem.LastName = "Junior";
TestItem.DateOfBirth = DateTime.Now.Date.AddYears(-17);
TestItem.Address = "Flat C, Colly road";
TestItem.Email = "*****@*****.**";
TestItem.TelephoneNo = "07437320192";
TestItem.EmergencyContact = "07528789924";
TestItem.EmploymentDate = DateTime.Now.Date;
TestItem.HoursOfWork = 129;
TestItem.EmploymentHistory = "None";
TestItem.DateAdded = DateTime.Now.Date;
//set ThisConsultant to the test data
AllConsultants.ThisConsultant = TestItem;
//add the record
PrimaryKey = AllConsultants.AddNew();
//set the primary key of the test data
TestItem.ConsultantNo = PrimaryKey;
//find the record
AllConsultants.ThisConsultant.Find(PrimaryKey);
//test to see that the two values are the same
Assert.AreEqual(AllConsultants.ThisConsultant, TestItem);
}
public void AddressMid()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//boolean variable to store the result of the validation
Boolean OK = false;
//create some test data to use with the method
string FirstName = "James";
string LastName = "mmmmmm";
string Address = "CERRFlat2CBASTREETLEICERRFlat2";
string Email = "*****@*****.**";
string DateAdded = DateTime.Now.Date.ToString();
string EmploymentHistory = "None";
//invoke the method
OK = AConsultant.Valid(FirstName, LastName, Address, Email, EmploymentHistory, DateAdded);
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void AllConsultantsOK()
{
//Create an instance of the class we want to create
clsConsultantCollection Consultants = new clsConsultantCollection();
//create some test data to assign to the property
//in this case the data needs to be a list of objects
List<clsConsultant> TestList = new List<clsConsultant>();
//add an item to the list
//create an item of test data
clsConsultant TestItem = new clsConsultant();
//set its properties
TestItem.ConsultantNo = 1;
TestItem.FirstName = "James";
//add the item to the test list
TestList.Add(TestItem);
//assign the data to the property
Consultants.AllConsultants = TestList;
//test to see that the two values are the same
Assert.AreEqual(Consultants.AllConsultants, TestList);
}
//public constructor for the class
public clsConsultantCollection()
{
//var for the index
Int32 Index = 0;
//var to store the record count
Int32 RecordCount = 0;
//object for data connection
clsDataConnection DB = new clsDataConnection();
//execute the stored procedure
DB.Execute("sproc_tblConsultant_SelectAll");
//get the count of records
RecordCount = DB.Count;
//while there are records to process
while (Index < RecordCount)
{
//create a blank Consultant
clsConsultant AConsultant = new clsConsultant();
//read in the fields from the current record
AConsultant.ConsultantNo = Convert.ToInt32(DB.DataTable.Rows[Index]["ConsultantNo"]);
AConsultant.FirstName = Convert.ToString(DB.DataTable.Rows[Index]["FirstName"]);
AConsultant.LastName = Convert.ToString(DB.DataTable.Rows[Index]["LastName"]);
AConsultant.Address = Convert.ToString(DB.DataTable.Rows[Index]["Address"]);
AConsultant.Email = Convert.ToString(DB.DataTable.Rows[Index]["Email"]);
AConsultant.TelephoneNo = Convert.ToString(DB.DataTable.Rows[Index]["TelephoneNo"]);
AConsultant.EmergencyContact = Convert.ToString(DB.DataTable.Rows[Index]["EmergencyContact"]);
AConsultant.HoursOfWork = Convert.ToInt32(DB.DataTable.Rows[Index]["HoursOfWork"]);
AConsultant.DateOfBirth = Convert.ToDateTime(DB.DataTable.Rows[Index]["DateOfBirth"]);
AConsultant.EmploymentDate = Convert.ToDateTime(DB.DataTable.Rows[Index]["EmploymentDate"]);
AConsultant.Status = Convert.ToBoolean(DB.DataTable.Rows[Index]["Status"]);
AConsultant.DateAdded = Convert.ToDateTime(DB.DataTable.Rows[Index]["DateAdded"]);
//add the record to the private data member
ConsultantList.Add(AConsultant);
//point at the next record
Index++;
}
}
public void InstanceOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//test to see if it exists
Assert.IsNotNull(AConsultant);
}
public void LastNameMid()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//boolean variable to store the result of the validation
Boolean OK = false;
//create some test data to use with the method
string FirstName = "James"; //This should pass
string LastName = "abcdmjmjmghhasmjkloithkgk";
string Address = "flat b 2, thml";
string Email = "*****@*****.**";
string DateAdded = DateTime.Now.Date.ToString();
string EmploymentHistory = "None";
//invoke the method
OK = AConsultant.Valid(FirstName, LastName, Address, Email, EmploymentHistory, DateAdded);
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void FirstNamePropertyOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//create some test data to assign to the property
string TestData = "Frank";
//assign the data to the property
AConsultant.FirstName = TestData;
//test to see that the two values are the same
Assert.AreEqual(AConsultant.FirstName, TestData);
}
public void HoursOfWorkPropertyOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//create some test data to assign to the property
Int32 TestData = 127;
//assign the data to the property
AConsultant.HoursOfWork = TestData;
//test to see that the two values are the same
Assert.AreEqual(AConsultant.HoursOfWork, TestData);
}
public void AddressPropertyOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//create some test data to assign to the property
string TestData = "21 bart road";
//assign the data to the property
AConsultant.Address = TestData;
//test to see that the two values are the same
Assert.AreEqual(AConsultant.Address, TestData);
}
public void TestHoursOfWorkFound()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//boolean variable to store the result of the search
Boolean Found = false;
//boolean variable to record ifdata is OK (assume it is)
Boolean OK = true;
//create some test data to use with the method
Int32 ConsultantNo = 2;
//invoke the method
Found = AConsultant.Find(ConsultantNo);
//check the Consultant No
if (AConsultant.HoursOfWork != 128)
{
OK = false;
}
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void TestTelNoFound()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//boolean varibale to store the result of the validation
Boolean Found = false;
//boolean variable to store the result of the search
Boolean OK = true;
//create some test data to use with the method
Int32 ConsultantNo = 1;
//invoke the method
Found = AConsultant.Find(ConsultantNo);
//check the ConsultantNo
if (AConsultant.TelephoneNo != "07548389201")
{
OK = false;
}
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void ThisConsultantPropertyOK()
{
//create an instance of the class we want to create
clsConsultantCollection AllConsultants = new clsConsultantCollection();
clsConsultant TestItem = new clsConsultant();
//set its properties
TestItem.Status = true;
TestItem.ConsultantNo = 1;
TestItem.FirstName = "John";
TestItem.LastName = "Wayne";
TestItem.DateOfBirth = DateTime.Now.Date;
TestItem.Address = "Flat BC, 2 Cilantro Road";
TestItem.Email = "*****@*****.**";
TestItem.TelephoneNo = "07437320192";
TestItem.EmergencyContact = "07528789924";
TestItem.EmploymentDate = DateTime.Now.Date;
TestItem.HoursOfWork = 172;
TestItem.EmploymentHistory = "None";
TestItem.DateAdded = DateTime.Now.Date;
//assign the data to the property
AllConsultants.ThisConsultant = TestItem;
//test to see that the two values are the same
Assert.AreEqual(AllConsultants.ThisConsultant, TestItem);
}
public void EmploymentDatePropertyOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//create some test data to assign to the property
DateTime TestData = DateTime.Now.Date;
//assign the data to the property
AConsultant.EmploymentDate = TestData;
//test to see that the two values are the same
Assert.AreEqual(AConsultant.EmploymentDate, TestData);
}
public void EmploymentHistoryPropertyOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//create some test data to assign to the property
string TestData = "Not Applicable";
//assign the data to the property
AConsultant.EmploymentHistory = TestData;
//test to see that the two values are the same
Assert.AreEqual(AConsultant.EmploymentHistory, TestData);
}
public void EmergencyContactPropertyOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//create some test data to assign to the property
string TestData = "0752879265";
//assign the data to the property
AConsultant.EmergencyContact = TestData;
//test to see that the two values are the same
Assert.AreEqual(AConsultant.EmergencyContact, TestData);
}
public void EmailPropertyOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//create some test data to assign to the property
string TestData = "*****@*****.**";
//assign the data to the property
AConsultant.Email = TestData;
//test to see that the two values are the same
Assert.AreEqual(AConsultant.Email, TestData);
}
public void DateAddedMinPlusOne()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//boolean variable to store the result of the validation
Boolean OK = false;
//create some test data to use with the method
string FirstName = "James";
string LastName = "mmmmmm";
string Address = "flat b 2, thml";
string Email = "*****@*****.**";
string EmploymentHistory = "None";
//create a variable to store the test date data
DateTime TestDate;
//set the date to todays date
TestDate = DateTime.Now.Date;
//change the date to tomorrow (+1)
TestDate = TestDate.AddDays(1);
//convert the date variable to string variable
string DateAdded = TestDate.ToString();
//invoke the method
OK = AConsultant.Valid(FirstName, LastName, Address, Email, DateAdded, EmploymentHistory);
//test to see that the result is correct
Assert.IsFalse(OK);
}
public void DeleteMethodOK()
{
//create an instance of the class we want to create
clsConsultantCollection AllConsultants = new clsConsultantCollection();
clsConsultant TestItem = new clsConsultant();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.Status = true;
TestItem.ConsultantNo = 119;
TestItem.FirstName = "James";
TestItem.LastName = "Junior";
TestItem.DateOfBirth = DateTime.Now.Date.AddYears(-17);
TestItem.Address = "Flat C, Basil road";
TestItem.Email = "*****@*****.**";
TestItem.TelephoneNo = "07528789965";
TestItem.EmergencyContact = "07528789965";
TestItem.EmploymentDate = DateTime.Now.Date;
TestItem.HoursOfWork = 129;
TestItem.EmploymentHistory = "None";
TestItem.DateAdded = DateTime.Now.Date;
//set ThisConsultant to the test data
AllConsultants.ThisConsultant = TestItem;
//add the record
PrimaryKey = AllConsultants.AddNew();
//set the primary key of the test data
TestItem.ConsultantNo = PrimaryKey;
//find the record
AllConsultants.ThisConsultant.Find(PrimaryKey);
//delete the record
AllConsultants.Delete();
//now find the record
Boolean Found = AllConsultants.ThisConsultant.Find(PrimaryKey);
//test to see that the record wasn't found
Assert.IsFalse(Found);
}
public void TelephoneNoPropertyOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//create some test data to assign to the property
string TestData = "+44752890120";
//assign the data to the property
AConsultant.TelephoneNo = TestData;
//test to see that the two values are the same
Assert.AreEqual(AConsultant.TelephoneNo, TestData);
}
public void TestEmploymentDateFound()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//boolean varibale to store the result of the validation
Boolean Found = false;
//boolean variable to store the result of the search
Boolean OK = true;
//create some test data to use with the method
Int32 ConsultantNo = 1;
//invoke the method
Found = AConsultant.Find(ConsultantNo);
//check the ConsultantNo
if (AConsultant.EmploymentDate != Convert.ToDateTime("12/12/2014"))
{
OK = false;
}
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void FirstNameMaxLessOne()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//boolean variable to store the result of the validation
Boolean OK = false;
//create some test data to use with the method
string FirstName = "Abcdhfmhklfigmahsmghcksmsdmjnbhmklowpoutfghmglava"; //This should pass
string LastName = "mmmmmm";
string Address = "flat b 2, thml";
string Email = "*****@*****.**";
string DateAdded = DateTime.Now.Date.ToString();
string EmploymentHistory = "None";
//invoke the method
OK = AConsultant.Valid(FirstName, LastName, Address, Email, EmploymentHistory, DateAdded);
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void EmploymentMinPlusOne()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//boolean variable to store the result of the validation
Boolean OK = false;
//create some test data to use with the method
string FirstName = "James";
string LastName = "mmmmmm";
string Address = "FlatB2CTHYMEROADLESS";
string Email = "mmwen@xyz";
string DateAdded = DateTime.Now.Date.ToString();
string EmploymentHistory = "Fired";
//invoke the method
OK = AConsultant.Valid(FirstName, LastName, Address, Email, EmploymentHistory, DateAdded);
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void ValidMethodOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//boolean variable to store the result of the vaidation
Boolean OK = false;
//create some test data to use with the method
string FirstName = "James";
string LastName = "James";
string Address = "Flat C, Colly road";
string Email = "*****@*****.**";
string EmploymentHistory = "Employed";
string DateAdded = DateTime.Now.Date.ToString();
//invoke the method
OK = AConsultant.Valid(FirstName, LastName, Address, Email, EmploymentHistory, DateAdded);
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void FindMethodOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//boolean variable to store the result of the vaidation
Boolean Found = false;
//create some test data to use with the method
Int32 ConsultantNo = 2;
//invoke the method
Found = AConsultant.Find(ConsultantNo);
//test to see that the result is correct
Assert.IsTrue(Found);
}
public void StatusPropertyOK()
{
//create an instance of the class we want to create
clsConsultant AConsultant = new clsConsultant();
//create some test data to assign to the property
Boolean TestData = true;
//assign the data to the property
AConsultant.Status = TestData;
//test to see that the two values are the same
Assert.AreEqual(AConsultant.Status, TestData);
}