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); }