//public constructor for the class
public clsClientCollection()
{
//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_tblClient_SelectAll");
//get the count of records
RecordCount = DB.Count;
//while there are records to process
while (Index < RecordCount)
{
//create a blank address
clsClient AClient = new clsClient();
//read in the fields from the current record
AClient.ClientNo = Convert.ToInt32(DB.DataTable.Rows[Index]["ClientNo"]);
AClient.ClientName = Convert.ToString(DB.DataTable.Rows[Index]["ClientName"]);
AClient.ClientEmail = Convert.ToString(DB.DataTable.Rows[Index]["ClientEmail"]);
AClient.ClientPosition = Convert.ToString(DB.DataTable.Rows[Index]["ClientPosition"]);
AClient.ClientQualification = Convert.ToString(DB.DataTable.Rows[Index]["ClientQualification"]);
AClient.ClientService = Convert.ToString(DB.DataTable.Rows[Index]["ClientService"]);
AClient.ClientAddress = Convert.ToString(DB.DataTable.Rows[Index]["ClientAddress"]);
AClient.ClientTel = Convert.ToInt32(DB.DataTable.Rows[Index]["ClientTel"]);
AClient.DateAdded = Convert.ToDateTime(DB.DataTable.Rows[Index]["DateAdded"]);
AClient.Active = Convert.ToBoolean(DB.DataTable.Rows[Index]["Active"]);
//add the record to the private data member
clientList.Add(AClient);
//point at the next record
Index++;
}
}
public void ActivePropertyOK()
{
//create an instance of the class I want to create
clsClient AClient = new clsClient();
//create some test data to assign to the property
Boolean TestData = true;
//assign the data to the property
AClient.Active = TestData;
//test to see that the two values are the same
Assert.AreEqual(AClient.Active, TestData);
}
public void ClientAddressMaxLessOne()
{
//create an instance of the class we want to create
clsClient AClient = new clsClient();
//boolean variable to store the result of the validation
Boolean OK = false;
//create some test data to pass to the method
string ClientName = "freddy";
string ClientEmail = "*****@*****.**";
string ClientPosition = "CEO";
string ClientQualification = "degree";
string ClientService = "IT support for company";
string ClientAddress = "";
ClientAddress = ClientAddress.PadRight(49, '2');
string ClientTel = "783763";
string DateAdded = DateTime.Now.Date.ToString();
//invoke the method
OK = AClient.Valid(ClientName, ClientEmail, ClientPosition, ClientQualification, ClientService, ClientAddress, ClientTel, DateAdded);
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void ClientQualificationOK()
{
//create an instance of the class I want to create
clsClient AClient = new clsClient();
//create some test data to assign to the property
string TestData = "degree";
//assign the data to the property
AClient.ClientQualification = TestData;
//test to see that the two values are the same
Assert.AreEqual(AClient.ClientQualification, TestData);
}
public void ClientNoPropertyOK()
{
//create an instance of the class I want to create
clsClient AClient = new clsClient();
//create some test data to assign to the property
Int32 TestData = 21;
//assign the data to the property
AClient.ClientNo = TestData;
//test to see that the two values are the same
Assert.AreEqual(AClient.ClientNo, TestData);
}
public void ClientNamePropertyOK()
{
//create an instance of the class I want to create
clsClient AClient = new clsClient();
//create some test data to assign to the property
string TestData = "freddy";
//assign the data to the property
AClient.ClientName = TestData;
//test to see that the two values are the same
Assert.AreEqual(AClient.ClientName, TestData);
}
public void TestDateAddedFound()
{
//create an instance of the class we want to create
clsClient AClient = new clsClient();
//boolean varibale to store the result of the search
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 method
Int32 ClientNo = 21;
//invoke the method
Found = AClient.Find(ClientNo);
//check the property
if (AClient.DateAdded != Convert.ToDateTime("20/02/2016"))
{
OK = false;
}
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void TestClientTelFound()
{
//create an instance of the class we want to create
clsClient AClient = new clsClient();
//boolean varibale to store the result of the search
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 method
Int32 ClientNo = 21;
//invoke the method
Found = AClient.Find(ClientNo);
//check the ClientNo
if (AClient.ClientTel != 783763)
{
OK = false;
}
//test to see that the result is correct
Assert.IsTrue(OK);
}
public void InstanceOK()
{
//create an instance of the class I want to create
clsClient AClient = new clsClient();
//test to see if that exists
Assert.IsNotNull(AClient);
}
public void FindMethodOK()
{
//create an instance of the class we want to create
clsClient AClient = new clsClient();
//boolean varibale to store the result of the search
Boolean Found = false;
//create some test data to use with the method
Int32 ClientNo = 21;
//invoke the method
Found = AClient.Find(ClientNo);
//test to see that the result is correct
Assert.IsTrue(Found);
}
public void DateAddedPropertyOK()
{
//create an instance of the class I want to create
clsClient AClient = new clsClient();
//create some test data to assign to the property
DateTime TestData = DateTime.Now.Date;
//assign the data to the property
AClient.DateAdded = TestData;
//test to see that the two values are the same
Assert.AreEqual(AClient.DateAdded, TestData);
}
public void DateAddedMinPlusOne()
{
//create an instance of the class we want to create
clsClient AClient = new clsClient();
//boolean variable to store the result of the validation
Boolean OK = false;
//create some test data to pass to the method
string ClientName = "freddy";
string ClientEmail = "*****@*****.**";
string ClientPosition = "CEO";
string ClientQualification = "degree";
string ClientService = "IT support for company";
string ClientAddress = "21b";
string ClientTel = "783763";
DateTime TestDate;
//set the date todays date
TestDate = DateTime.Now.Date;
//change the date to whatever the date is plus 1 day
TestDate = TestDate.AddDays(1);
//convert the date variable to a string variable
string DateAdded = TestDate.ToString();
//invoke the method
OK = AClient.Valid(ClientName, ClientEmail, ClientPosition, ClientQualification, ClientService, ClientAddress, ClientTel, DateAdded);
//test to see that the result is correct
Assert.IsFalse(OK);
}
public void ClientServiceOK()
{
//create an instance of the class I want to create
clsClient AClient = new clsClient();
//create some test data to assign to the property
string TestData = "IT support for company";
//assign the data to the property
AClient.ClientService = TestData;
//test to see that the two values are the same
Assert.AreEqual(AClient.ClientService, TestData);
}
