public clsCompanyCollection()
{
//var for the index
var Index = 0;
//var to store the record count
var RecordCount = 0;
//object for data connection
clsDataConnection DB = new clsDataConnection();
//execute the stored procedure
DB.Execute("sproc_tblCompany_SelectAll");
//get the count of records
RecordCount = DB.Count;
//while there are records to process
while (Index < RecordCount)
{
//create a blank company
clsCompany AnCompany = new clsCompany();
//read in the fields from the current record
AnCompany.CompanyID = Convert.ToInt32(DB.DataTable.Rows[Index]["CompanyID"]);
AnCompany.CompanyName = Convert.ToString(DB.DataTable.Rows[Index]["CompanyName"]);
AnCompany.Address = Convert.ToString(DB.DataTable.Rows[Index]["Address"]);
AnCompany.PostCode = Convert.ToString(DB.DataTable.Rows[Index]["PostCode"]);
AnCompany.TeleNum = Convert.ToString(DB.DataTable.Rows[Index]["TeleNum"]);
AnCompany.Email = Convert.ToString(DB.DataTable.Rows[Index]["Email"]);
AnCompany.Description = Convert.ToString(DB.DataTable.Rows[Index]["Description"]);
//add the record to the private data member
mCompanyList.Add(AnCompany);
//point at the next record
Index++;
}
}
public void ContactNoOK()
{
clsCompany ACompany = new clsCompany();
string TestData = "0744121212";
ACompany.ContactNo = TestData;
Assert.AreEqual(ACompany.ContactNo, TestData);
}
public void CompanyNameOK()
{
clsCompany ACompany = new clsCompany();
string TestData = "DMU";
ACompany.ContactNo = TestData;
Assert.AreEqual(ACompany.ContactNo, TestData);
}
public void FindMethodOK()
{
clsCompany ACompany = new clsCompany();
Boolean Found = false;
string ContactNo = "0744121212";
Found = ACompany.Find();
Assert.IsTrue(Found);
}
public void TestAddressFound()
{
clsCompany ACompany = new clsCompany();
Boolean Found = false;
Boolean OK = true;
Found = ACompany.Find();
if (ACompany.Address == "85 Street")
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestEmailFound()
{
clsCompany ACompany = new clsCompany();
Boolean Found = false;
Boolean OK = true;
Found = ACompany.Find();
if (ACompany.Email == "*****@*****.**")
{
OK = false;
}
Assert.IsTrue(OK);
}
public void TestCompanyNameFound()
{
clsCompany ACompany = new clsCompany();
Boolean Found = false;
Boolean OK = true;
Found = ACompany.Find();
if (ACompany.ContactNo == "0744121212")
{
OK = true;
}
Assert.IsTrue(OK);
}
public void ContactNoMaxPlusOne()
{
clsCompany ACompany = new clsCompany();
Boolean OK = false;
string Address = "85 street";
string CompanyName = "DMU";
string Email = "*****@*****.**";
string ContactNo = "";
OK = ACompany.Valid(CompanyName, Address, Email, ContactNo);
Assert.IsFalse(OK);
}
public void EmailMin()
{
clsCompany ACompany = new clsCompany();
Boolean OK = false;
string Address = "85 street";
string CompanyName = "DMU";
string Email = "*****@*****.**";
string ContactNo = "0744121212";
OK = ACompany.Valid(CompanyName, Address, Email, ContactNo);
Assert.IsTrue(OK);
}
public void EmailMinLessOne()
{
clsCompany ACompany = new clsCompany();
Boolean OK = false;
string Address = "85 Street";
string CompanyName = "DMU";
string Email = "";
string ContactNo = "0744121212";
OK = ACompany.Valid(CompanyName, Address, Email, ContactNo);
Assert.IsFalse(OK);
}
public void AddressExtremeMax()
{
clsCompany ACompany = new clsCompany();
Boolean OK = false;
string Address = "";
Address = Address.PadRight(250, 'a');
string CompanyName = "DMU";
string Email = "*****@*****.**";
string ContactNo = "0744121212";
OK = ACompany.Valid(CompanyName, Address, Email, ContactNo);
Assert.IsFalse(OK);
}
public void EmailExtremeMax()
{
clsCompany ACompany = new clsCompany();
Boolean OK = false;
string Address = "85 Street";
string CompanyName = "DMU";
string Email = "";
Email = Email.PadRight(100, 'a');
string ContactNo = "33";
OK = ACompany.Valid(CompanyName, Address, Email, ContactNo);
Assert.IsFalse(OK);
}
public void ValidMethodOK()
{
clsCompany ACompany = new clsCompany();
Boolean OK = false;
Boolean Found = false;
Found = ACompany.Find();
string CompanyName = "DMU";
string Address = "85 Street";
string Email = "*****@*****.**";
string ContactNo = "0744121212";
OK = ACompany.Valid(CompanyName, Address, Email, ContactNo);
Assert.IsTrue(OK);
}
public void ContactNoExtremeMax()
{
clsCompany ACompany = new clsCompany();
Boolean OK = false;
string Address = "85 Street";
string CompanyName = "DMU";
string Email = "*****@*****.**";
string ContactNo = "33";
ContactNo = ContactNo.PadRight(30, 'a');
OK = ACompany.Valid(CompanyName, Address, Email, ContactNo);
Assert.IsFalse(OK);
}
