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