public void UpdateConsignor() { // SETUP ConsignorClasses.Consignor c = new Consignor(); ConsignorClasses.ConsignorUtilities u = new ConsignorUtilities(); c.Address1City = testAddressCity; c.Address1State = testAddressState; c.Address1Street = testStreet; c.Address1Zip = testZip; c.CellPhone = testCell; c.Comments = testComments; c.ConsignorID = GetMaxConsignorID(); c.Donate = true; c.EmailAddress = testEmail; c.FirstName = testUpdatedFirstName; c.HomePhone = testHomePhone; c.LastName = testUpdatedLastName; c.WorkPhone = testWorkPhone; // TRIGGER bool updateResult = u.Consignor_Update(c); ConsignorClasses.Consignor updated = new Consignor(); updated = u.GetExistingConsignor(GetMaxConsignorID()); // VALIDATE Assert.AreEqual(true, updateResult, "expected different result"); Assert.AreEqual(c.LastName, updated.LastName, "expected same updated last name"); Assert.AreEqual(c.FirstName, updated.FirstName, "expected same updated first name"); }
/// <summary> /// Navigate to the report when list box items have been selected /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cmdGo_Click(object sender, EventArgs e) { if (listBox1.SelectedItems.Count != 0) { List<string> collection = ParseSelectedItems(listBox1.SelectedItems); string sqlParams = ConvertToSqlParam(collection); ConsignorClasses.ConsignorUtilities cu = new ConsignorClasses.ConsignorUtilities(); ConsignorClasses.Consignor c = new ConsignorClasses.Consignor(); c = cu.GetExistingConsignor(GlobalClass.ConsignerID); ConsignorID = c.ConsignorID; LoadReport(c.ConsignorID, sqlParams); } }
/// <summary> /// load the active only to start /// </summary> private void LoadActiveOnly() { string sqlParams = ConvertToSqlParam(ActiveOnlyStatus); ConsignorClasses.ConsignorUtilities cu = new ConsignorClasses.ConsignorUtilities(); ConsignorClasses.Consignor c = new ConsignorClasses.Consignor(); c = cu.GetExistingConsignor(GlobalClass.ConsignerID); ConsignorID = c.ConsignorID; LoadReport(c.ConsignorID, sqlParams); }
/// <summary> /// load up the report /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Report_ConsignorDetailReport_Load(object sender, EventArgs e) { this.soldStatus_Select1TableAdapter.Fill(this.doubletakeDataSet.SoldStatus_Select1); ConsignorClasses.ConsignorUtilities cu = new ConsignorClasses.ConsignorUtilities(); ConsignorClasses.Consignor c = new ConsignorClasses.Consignor(); c = cu.GetExistingConsignor(GlobalClass.ConsignerID); ConsignorID = c.ConsignorID; lblConsignorName.Text = string.Format("{0} {1}", c.FirstName, c.LastName); // check if this is coming from the right click on the search if (string.IsNullOrEmpty(GlobalClass.WhateverString)) { listBox1.SelectedItems.Clear(); } else { LoadReport(c.ConsignorID, GlobalClass.WhateverString); } }
private void GetConsignor(int ConsignorID) { ConsignorClasses.ConsignorUtilities u = new ConsignorClasses.ConsignorUtilities(); var returnedConsignor = new ConsignorClasses.Consignor(); returnedConsignor = u.GetExistingConsignor(ConsignorID); // check for C# exceptions if (returnedConsignor.LastName.Contains("SQL Exception")) { MessageBox.Show(returnedConsignor.Comments, "SQL Data Error", MessageBoxButtons.OK); ClearConsignor(); } else if (returnedConsignor.LastName.Contains("C# Exception")) { MessageBox.Show(returnedConsignor.Comments, "C# Error", MessageBoxButtons.OK); ClearConsignor(); } else { txtConsignorID.Text = ConsignorID.ToString(); txtLastName.Text = returnedConsignor.LastName; txtFirstName.Text = returnedConsignor.FirstName; txtAddress.Text = returnedConsignor.Address1Street; txtCity.Text = returnedConsignor.Address1City; txtState.Text = returnedConsignor.Address1State; txtZipCode.Text = returnedConsignor.Address1Zip; txtHomePhone.Text = returnedConsignor.HomePhone; txtWorkPhone.Text = returnedConsignor.WorkPhone; txtCellPhone.Text = returnedConsignor.CellPhone; txtemail.Text = returnedConsignor.EmailAddress; txtComments.Text = returnedConsignor.Comments; ckDonate.Checked = returnedConsignor.Donate; } ClearConsignor(); }