public void AddMethodOK()
{
//create an instance of the class we want to create
clsSupplierCollection AllSuppliers = new clsSupplierCollection();
//create th item of the data
clsSupplier TestItem = new clsSupplier();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.Active = true;
TestItem.Supplier_Address = "Some Supplier Address ";
TestItem.CountyNo = 1;
TestItem.Supplier_Email = "*****@*****.**";
TestItem.Supplier_Id = 001;
TestItem.Supplier_Name = "Game.net";
TestItem.Supplier_Phone_No = "07331415589";
//set ThisSupplier to the test data
AllSuppliers.ThisSupplier = TestItem;
//add record
PrimaryKey = AllSuppliers.Add();
//set the primary key of the test data
TestItem.Supplier_Id = PrimaryKey;
//find the record
AllSuppliers.ThisSupplier.Find(PrimaryKey);
//Test to see that the two values are the same
Assert.AreEqual(AllSuppliers.ThisSupplier, TestItem);
}
public void AddMethodOK()
{
clsSupplierCollection AllSuppliers = new clsSupplierCollection();
clsSupplier TestItem = new clsSupplier();
Int32 PrimaryKey = 0;
TestItem.SupplierID = 1;
TestItem.Address = "1b";
TestItem.City = "Birmingham";
TestItem.County = "eastmidlands";
TestItem.DateAdded = System.DateTime.Now.Date;
TestItem.Mobile = "078";
TestItem.Name = "Mark";
TestItem.Postcode = "CV6";
TestItem.PositionInCompany = "1bbbbbbbbbbbbbbbbbbbbbb25";
TestItem.SupplierName = "Audi";
TestItem.Title = "Mr";
TestItem.WorkExt = "312";
TestItem.WorkNumber = "12134";
TestItem.SupplierEmail = "*****@*****.**";
AllSuppliers.ThisSupplier = TestItem;
PrimaryKey = AllSuppliers.Add();
TestItem.SupplierID = PrimaryKey;
AllSuppliers.ThisSupplier.Find(PrimaryKey);
Assert.AreEqual(AllSuppliers.ThisSupplier, TestItem);
}
public void UpdateMethodOK()
{
clsSupplierCollection Suppliers = new clsSupplierCollection();
clsSuppliers Supplier1 = new clsSuppliers();
Int32 PrimaryKey = 1;
Supplier1.Active = true;
Supplier1.Address = "64 Zoo Lane";
Supplier1.Email = "*****@*****.**";
Supplier1.LastDelivery = DateTime.Now.Date;
Supplier1.Name = "WotC";
Supplier1.ID = PrimaryKey;
Suppliers.ThisSupplier = Supplier1;
PrimaryKey = Suppliers.Add();
Supplier1.ID = PrimaryKey;
Suppliers.ThisSupplier.Find(PrimaryKey);
Supplier1.ID = PrimaryKey;
Supplier1.Active = true;
Supplier1.Address = "65 Zoo Lane";
Supplier1.Email = "*****@*****.**";
Supplier1.LastDelivery = DateTime.Now.Date;
Supplier1.Name = "Konami";
Supplier1.ID = PrimaryKey;
Suppliers.ThisSupplier = Supplier1;
Suppliers.Update();
Suppliers.ThisSupplier.Find(PrimaryKey);
Assert.AreEqual(Suppliers.ThisSupplier, Supplier1);
}
public void DeleteMethodOK()
{
//create an instance of the class we want to create
clsSupplierCollection AllSuppliers = new clsSupplierCollection();
//create th item of the data
clsSupplier TestItem = new clsSupplier();
//var to store the primary key
Int32 PrimaryKey = 0;
//set its properties
TestItem.Active = true;
TestItem.Supplier_Address = "Some Supplier Address ";
TestItem.CountyNo = 1;
TestItem.Supplier_Email = "*****@*****.**";
TestItem.Supplier_Id = 001;
TestItem.Supplier_Name = "Game.net";
TestItem.Supplier_Phone_No = "07331415589";
//set ThisSupplier to the test data
AllSuppliers.ThisSupplier = TestItem;
//add record
PrimaryKey = AllSuppliers.Add();
//set the primary key of the test data
TestItem.Supplier_Id = PrimaryKey;
//find the record
AllSuppliers.ThisSupplier.Find(PrimaryKey);
//delete record
AllSuppliers.Delete();
//now find the record
Boolean Found = AllSuppliers.ThisSupplier.Find(PrimaryKey);
//test to see that the record was not found
Assert.IsFalse(Found);
}
public void DeleteMethodOK()
{
clsSupplierCollection Suppliers = new clsSupplierCollection();
clsSuppliers Supplier1 = new clsSuppliers();
Int32 PrimaryKey = 0;
Supplier1.Active = true;
Supplier1.Address = "64 Zoo Lane";
Supplier1.Email = "*****@*****.**";
Supplier1.LastDelivery = DateTime.Now.Date;
Supplier1.Name = "WotC";
Supplier1.ID = PrimaryKey;
Suppliers.ThisSupplier = Supplier1;
PrimaryKey = Suppliers.Add();
Supplier1.ID = PrimaryKey;
Suppliers.ThisSupplier.Find(PrimaryKey);
Suppliers.DeleteSupplier();
Boolean Found = Suppliers.ThisSupplier.Find(PrimaryKey);
Assert.IsFalse(Found);
}
void Add() //function for adding new records
{
//Create instance in Supplier collection class
clsSupplierCollection Suppliers = new clsSupplierCollection();
//validate the data on the web form
Boolean OK = Suppliers.ThisSupplier.Valid(txtAddress.Text, txtCity.Text, txtCounty.Text, txtDateAdded.Text, txtMobile.Text, txtName.Text, txtPostcode.Text, txtPositionInCompany.Text, txtSupplierName.Text, txtTitle.Text, txtWorkExt.Text, txtWorkNumber.Text, txtSupplierEmail.Text);
//if the data is ok then add it to the object
if (OK == true)
{
Suppliers.ThisSupplier.Address = txtAddress.Text;
Suppliers.ThisSupplier.City = txtCity.Text;
Suppliers.ThisSupplier.County = txtCounty.Text;
Suppliers.ThisSupplier.DateAdded = Convert.ToDateTime(txtDateAdded.Text);
Suppliers.ThisSupplier.Mobile = txtMobile.Text;
Suppliers.ThisSupplier.Name = txtName.Text;
Suppliers.ThisSupplier.Postcode = txtPostcode.Text;
Suppliers.ThisSupplier.PositionInCompany = txtPositionInCompany.Text;
Suppliers.ThisSupplier.SupplierName = txtSupplierName.Text;
Suppliers.ThisSupplier.Title = txtTitle.Text;
Suppliers.ThisSupplier.WorkExt = txtWorkExt.Text;
Suppliers.ThisSupplier.WorkNumber = txtWorkNumber.Text;
Suppliers.ThisSupplier.SupplierEmail = txtSupplierEmail.Text;
//add the record
Suppliers.Add();
Response.Redirect("SupplierHomepage.aspx");
}
else
{
//Report error
lblErrorMessageAdd.Text = "there were problems with the data entered";
}
}
public void AddMethodOK()
{
clsSupplierCollection AllSupplier = new clsSupplierCollection();
clsSupplier TestItem = new clsSupplier();
Int32 PrimaryKey = 0;
TestItem.SupplierID = 1;
TestItem.CompanyName = "teesLTD";
TestItem.Product = "tShirts";
TestItem.PhoneNumber = "07456332127";
TestItem.EmailAddress = "*****@*****.**";
TestItem.Address = "101 Second Avenue";
TestItem.PostCode = "LE1 1ST";
AllSupplier.ThisSupplier = TestItem;
PrimaryKey = AllSupplier.Add();
TestItem.SupplierID = PrimaryKey;
AllSupplier.ThisSupplier.Find(PrimaryKey);
Assert.AreEqual(AllSupplier.ThisSupplier, TestItem);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
clsSuppliers ASupplier = new clsSuppliers();
string Name = txtName.Text;
string Address = txtAddress.Text;
string Email = txtEmail.Text;
string LastDelivery = txtDelivery.Text;
string Error = "";
Error = ASupplier.Valid(Name, Email, Address, LastDelivery);
if (Error == "")
{
ASupplier.Name = Name;
ASupplier.Address = Address;
ASupplier.Email = Email;
ASupplier.LastDelivery = Convert.ToDateTime(LastDelivery);
ASupplier.Active = cbxActive.Checked;
clsSupplierCollection SupplierList = new clsSupplierCollection();
if (ID == -1)
{
SupplierList.ThisSupplier = ASupplier;
SupplierList.Add();
}
else
{
SupplierList.ThisSupplier.Find(ID);
SupplierList.ThisSupplier = ASupplier;
SupplierList.Update();
}
Response.Redirect("SupplierList.aspx");
}
else
{
lblResult.Text = Error;
}
}
public void DeleteMethodOK()
{
clsSupplierCollection AllSupplier = new clsSupplierCollection();
clsSupplier TestItem = new clsSupplier();
Int32 PrimaryKey = 0;
//data to delete
TestItem.CompanyName = "teesLTD";
TestItem.Product = "tShirts";
TestItem.PhoneNumber = "07456332127";
TestItem.EmailAddress = "*****@*****.**";
TestItem.Address = "101 Second Avenue";
TestItem.PostCode = "LE1 1ST";
AllSupplier.ThisSupplier = TestItem;
PrimaryKey = AllSupplier.Add();
TestItem.SupplierID = PrimaryKey;
AllSupplier.ThisSupplier.Find(PrimaryKey);
AllSupplier.Delete();
Boolean Found = AllSupplier.ThisSupplier.Find(PrimaryKey);
Assert.IsFalse(Found);
}
