public void AttachExistingTest()
{
string newCompany = "West Wind " + DateTime.Now;
int custId = 1;
var cust = new Customer()
{
Id = custId,
Company = newCompany,
FirstName = "Ricky",
LastName = "Strahl",
Address = "33 Kaiea Place"
};
using (var custBo = new busCustomer())
{
custBo.Attach(cust);
Assert.IsTrue(custBo.Save(), custBo.ErrorMessage);
}
// load new bus/context to force load from disk
// otherwise load loads from cached context
using (var custBus = new busCustomer())
{
Customer cust2 = custBus.Load(custId);
Assert.IsNotNull(cust2, custBus.ErrorMessage);
Assert.AreEqual(cust2.Company,newCompany);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
FrameWork.Customers cust = new FrameWork.Customers();
cust.Company = txtCompanyName.Text;
cust.Address = txtNo.Text + " " + txtStreet.Text + " " + ddlCountry.SelectedValue + " " + txtZipCode.Text;
cust.TIN = txtTIN.Text;
cust.LastName = txtLastName.Text;
cust.FirstName = txtFirstName.Text;
cust.EmailAddress = txtEmail.Text;
cust.JobTitle = ddlDesignation.Text;
cust.BusinessPhone = txtTelephone.Text;
cust.FaxNumber = txtFax.Text;
cust.ZipPostal = txtZipCode.Text;
cust.WebPage = txtWebsite.Text;
BusinessRule.busCustomer custs = new BusinessRule.busCustomer();
custs.insertCustomer(cust);
busCustomer buscust = new busCustomer();
DataTable dt = new DataTable("customer");
dt = buscust.allCustomer();
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Response.Redirect("Login.aspx");
}
if (!IsPostBack)
{
busCustomer buscust = new busCustomer();
DataTable dt = new DataTable("User");
dt = buscust.allCustomer();
ViewState["Customer"] = dt;
this.drpCustomer.Items.Clear();
this.drpCustomer.Items.Add(new ListItem("select one", "0"));
foreach (DataRow dr in dt.Rows)
{
this.drpCustomer.Items.Add(new ListItem(dr["Company"].ToString(), dr["ID"].ToString()));
}
busProducts busProd = new busProducts();
dt = new DataTable("User");
dt = busProd.allProducts();
ViewState["Products"] = dt;
this.drpProduct.Items.Clear();
this.drpProduct.Items.Add(new ListItem("select one", "0"));
foreach (DataRow dr in dt.Rows)
{
this.drpProduct.Items.Add(new ListItem(dr["ProductName"].ToString(), dr["ID"].ToString()));
}
}
}
public void LoadEntityTest()
{
using (var custBus = new busCustomer())
{
Customer cust = null;
try
{
cust = custBus.Load(1);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Assert.IsNotNull(cust,custBus.ErrorMessage);
Console.WriteLine(cust.Company);
Assert.IsTrue(cust.Company.StartsWith("West Wind"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Response.Redirect("Login.aspx");
}
if (!Page.IsPostBack)
{
BindCountry();
}
if (!IsPostBack)
{
busCustomer buscust = new busCustomer();
DataTable dt = new DataTable("User");
dt = buscust.allCustomer();
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
public void AttachExistingTest()
{
int custId = 0;
Customer cust;
DateTime time = DateTime.Now;
using (var custBo = new busCustomer())
{
// grab existing customer id we can update
custId = custBo.Context.Customers
.Where(c => c.LastName == "Strahl")
.Select( c=> c.Id)
.First();
cust = new Customer()
{
Id = custId,
FirstName = "Ricky",
LastName = "Strahl",
Company = "West Wind",
Entered = time,
Address = "31 Kaiea Place"
};
custBo.Attach(cust);
Assert.IsTrue(custBo.Save(), custBo.ErrorMessage);
}
using (var custBo2 = new busCustomer())
{
// load new bus/context to force load from disk
// otherwise load loads from cached context
Customer cust2 = custBo2.Load(custId);
Assert.IsNotNull(cust2, custBo2.ErrorMessage);
Assert.IsTrue(cust2.Entered.ToString() == cust.Entered.ToString());
}
}
public void AttachWithChildExistingTest()
{
var orderBo = new busOrder();
var custBo = new busCustomer(orderBo); // share context
// same as this to share context
//custBo.Context = orderBo.Context;
var order = orderBo.NewEntity();
order.OrderId = StringUtils.NewStringId();
// this is easiest and most efficient - if you have a PK
//order.CustomerPk = 1;
// manually load customer instance from context
var cust = custBo.Load(1);
cust.Updated = DateTime.Now; // make a change
// assign the customer
order.Customer = cust;
// add a new line item
order.LineItems.Add(new LineItem()
{
Description = "Cool new Item",
Price = 40M,
Sku = "COOLNEW",
Quantity = 1,
Total = 40m
});
Assert.IsTrue(orderBo.Save(), orderBo.ErrorMessage);
}
public void AttachNewTest()
{
var cust = new Customer()
{
Company = "East Wind Technologies",
FirstName = "Jimmy",
LastName = "Ropain",
};
using (var custBus = new busCustomer())
{
custBus.Attach(cust, true);
Assert.IsTrue(custBus.Save(), custBus.ErrorMessage);
}
int custId = cust.Id;
// load new bus/context to force load from disk
// otherwise load loads from cached context
using (var custBus = new busCustomer())
{
Customer cust2 = custBus.Load(custId);
Assert.IsNotNull(cust2, custBus.ErrorMessage);
Assert.AreEqual(cust.Company, cust2.Company);
Assert.IsTrue(custBus.Delete(custId), custBus.ErrorMessage);
}
Console.WriteLine(custId);
}
public void ExceptionHandling()
{
var customerBus = new busCustomer()
{
ThrowExceptions = true
};
try
{
// this should throw SqlException
var custList = customerBus.ExecuteList<Customer>("select * from customerss where company like '%Wind%'");
}
catch (SqlException ex)
{
Console.WriteLine("Error correctly thrown: " + customerBus.ErrorMessage);
return;
}
Assert.IsTrue(false, "Exception should have fired and code should not get here.");
}
public void UpdateEntityTest()
{
string newCompanyName = "West Wind " + DateTime.Now;
// load and update first
using (var custBus = new busCustomer())
{
var cust = custBus.Load(1);
Assert.IsNotNull(cust);
cust.Company = newCompanyName;
Assert.IsTrue(custBus.Save(), custBus.ErrorMessage);
}
// reload from disk via new context and check for validity
using (var custBus = new busCustomer())
{
// reload entity
var cust = custBus.Load(1);
Assert.IsNotNull(cust);
Assert.AreEqual(newCompanyName, cust.Company);
}
}
public void TestExecuteNonQuery()
{
var custBo = new busCustomer();
int count = custBo.ExecuteNonQuery("update customers set updated = getDate() where Id={0}", 3);
Console.WriteLine(count);
Console.WriteLine(custBo.ErrorMessage);
Assert.IsTrue(count > -1);
}
public void NewEntityAlternateTest()
{
int custId = 0;
using (var custBus = new busCustomer())
{
var cust = new Customer()
{
FirstName = "John",
LastName = "Farrow",
Company = "Faraway Travel",
LastOrder = DateTime.Now
};
// Attach cust to Context and fire
// NewEntity hooks
custBus.NewEntity(cust);
Assert.IsTrue(custBus.Save(), custBus.ErrorMessage);
// cust.Id is updated after save operation
custId = cust.Id;
// Use a new bus object/context to force
// reload from disk - existing context loads from memory
// which doesn't test properly
using (var custBus2 = new busCustomer())
{
// load and compare
var cust2 = custBus2.Load(custId);
Assert.AreEqual(cust2.Company, cust.Company);
// Remove the new record
Assert.IsTrue(custBus2.Delete(custId), custBus2.ErrorMessage);
}
}
}
public void NewEntity1Test()
{
int custId = 0;
Customer cust = null;
using (var custBus = new busCustomer())
{
cust = custBus.NewEntity();
cust.FirstName = "Oscar";
cust.LastName = "Grouch";
cust.Company = "Groucho Inc.";
cust.Entered = DateTime.Now;
Assert.IsTrue(custBus.Save(), custBus.ErrorMessage);
// cust.Id is updated after save operation
custId = cust.Id;
}
// New bus object to ensure new context is used
// and data is loaded from disk - normally not required.
using (var custBus = new busCustomer())
{
// check to ensure record was created
var cust2 = custBus.Load(custId);
Assert.AreEqual(cust2.Company, cust.Company);
// Remove the new record
Assert.IsTrue(custBus.Delete(custId), custBus.ErrorMessage);
}
}
public void LoadEntityTest()
{
using (var custBus = new busCustomer())
{
var cust = custBus.Load(1);
Assert.IsNotNull(cust,custBus.ErrorMessage);
Console.WriteLine(cust.Company);
Assert.IsTrue(cust.Company.StartsWith("West Wind"));
}
}
public void PassContextToConstructor()
{
var customerBus = new busCustomer();
customerBus.CreateContext("WebStoreContext");
var cust = customerBus.Load(1);
Assert.IsNotNull(cust, customerBus.ErrorMessage);
}
public void FailedValidationTest()
{
var customerBus = new busCustomer();
var custExisting = customerBus.Load(1);
var cust = new Customer()
{
// create dupe values which should fail validation
FirstName = custExisting.FirstName,
LastName = custExisting.LastName,
Company = custExisting.Company
};
cust = customerBus.NewEntity(cust);
Assert.IsFalse(customerBus.Validate());
Assert.IsFalse(string.IsNullOrEmpty(customerBus.ErrorMessage));
Console.WriteLine("Validation Failed (test passed): " + customerBus.ErrorMessage);
}
public void FailedValidationAutoValidateTest()
{
var customerBus = new busCustomer()
{
// Validates on Save automatically
AutoValidate = true
};
var custExisting = customerBus.Load(1);
var cust = new Customer()
{
// create dupe values which should fail validation
FirstName = custExisting.FirstName,
LastName = custExisting.LastName,
Company = custExisting.Company
};
cust = customerBus.NewEntity(cust);
Assert.IsFalse(customerBus.Save());
Assert.IsFalse(string.IsNullOrEmpty(customerBus.ErrorMessage));
Console.WriteLine("Validation Failed (test passed): " + customerBus.ErrorMessage);
Console.WriteLine("Exception: " + customerBus.ErrorException.Message + " " + customerBus.ErrorException);
}
