private void btnDelete_Click(object sender, EventArgs e) { try { int shipperId; if (int.TryParse(lblShipperID.Text, out shipperId)) { //do the delete... var info = new Shipper() { ShipperID = shipperId }; NorthwindManager mgr = new NorthwindManager(); mgr.DeleteShipper(info); PopulateShippersComboBox(); cboShippers.SelectedItem = 0; } else { MessageBox.Show("Please select a shipper before clicking [Lookup Shipper]"); } } catch (Exception ex) { //TODO: Log the exception MessageBox.Show("Error: " + ex.Message); } }
private void btnAdd_Click(object sender, EventArgs e) { try { NorthwindManager mgr = new NorthwindManager(); int shipperId = mgr.AddShipper(new Shipper() { CompanyName=txtCompanyName.Text, Phone=txtPhone.Text }); //update the combobox PopulateShippersComboBox(); //has right shipper selected cboShippers.SelectedValue = shipperId; //display id of added shipper lblShipperID.Text = shipperId.ToString(); } catch (Exception ex) { //TODO: Log the exception MessageBox.Show("Error: " + ex.Message); } }
private void ViewRegions_Load(object sender, EventArgs e) { // Populate the ComboBox NorthwindManager manager = new NorthwindManager(); var data = manager.GetRegions(); cboRegions.DataSource = data; cboRegions.DisplayMember = "RegionDescription"; cboRegions.ValueMember = "RegionID"; }
public void Should_Delete_Products() { //Arrange var sut = new NorthwindManager(); var actual = new Product() { ProductName = "Product to delete" }; actual.ProductID = sut.AddProduct(actual); //Act sut.DeleteProduct(actual); //Assert Product p = sut.GetProduct(actual.ProductID); Assert.Null(p); }
public void Should_Add_Product() { //Arrange var sut = new NorthwindManager(); var product = new Product() { ProductName = "MSP Basic Product", Discontinued = false }; //Act var productID = sut.AddProduct(product); //Assert Assert.True(productID > 0); Product actual = sut.GetProduct(productID); Assert.Equal(productID, actual.ProductID); }
private void ProductSalesForm_Load(object sender, EventArgs e) { List<ProductSaleSummary> list = new NorthwindManager().GetProductSaleSummaries(); reportViewer1.LocalReport.DataSources.Clear(); //NOTE: reportViewer1.LocalReport.ReportEmbeddedResource = // "<application namespace>.[optional <folder>].<filename.rdlc>" reportViewer1.LocalReport.ReportEmbeddedResource = "DesktopApp.Reports.ProductSalesReport.rdlc"; Microsoft.Reporting.WinForms.ReportDataSource dataset = new Microsoft.Reporting.WinForms.ReportDataSource("ProductSalesDataSet", list); //set datasource reportViewer1.LocalReport.DataSources.Add(dataset); dataset.Value = list; reportViewer1.LocalReport.Refresh(); this.reportViewer1.RefreshReport(); }
public void Should_Add_Shipper() { //Arrange var sut = new NorthwindManager(); // sut is short for "Situation Under Test" var expected = new Shipper() { CompanyName = "Tin Hoang's Transporter Service", Phone = "780.231.3123" }; //Act var actualId = sut.AddShipper(expected); //Assert Assert.True(actualId > 0); Shipper actual = sut.GetShipper(actualId); Assert.Equal(expected.CompanyName, actual.CompanyName); Assert.Equal(expected.Phone,actual.Phone); Assert.Equal(actualId,actual.ShipperID); }
public void Should_Update_Products(Product existing) { //Arrange existing.ProductName = "TIN'S OLD PRODUCT"; var sut = new NorthwindManager(); //Act sut.UpdateProduct(existing); //Assert var actual = sut.GetProduct(existing.ProductID); Assert.NotNull(actual); Assert.Equal(existing.ProductName, actual.ProductName); }
public void Should_Delete_Shipper() { //Arrange var sut = new NorthwindManager(); // sut is short for "Situation Under Test" var expected = new Shipper() { CompanyName = "Tin Hoang's Transporter Service", Phone = "780.231.3123" }; expected.ShipperID = sut.AddShipper(expected); //Act sut.DeleteShipper(expected); //Assert Shipper actual = sut.GetShipper(expected.ShipperID); Assert.Null(actual); }
public void Should_Update_Shippers(Shipper existing) { //Arrange existing.Phone = "780.999.9998"; var sut = new NorthwindManager(); //Act sut.UpdateShipper(existing); //Assert var actual = sut.GetShipper(existing.ShipperID); Assert.NotNull(actual); Assert.Equal(existing.Phone, actual.Phone); Assert.Equal(existing.CompanyName, actual.CompanyName); }
public ShipperController() { Northwind = new NorthwindManager(); }
private void PopulateShippersComboBox() { NorthwindManager manager = new NorthwindManager(); var data = manager.ListShippers(); data.Insert(0, new Shipper() { ShipperID = -1, CompanyName = "[Select a shipper]" }); cboShippers.DataSource = data; cboShippers.DisplayMember = "CompanyName"; // CompanyName is a property of the Shipper class cboShippers.ValueMember = "ShipperID"; // ShipperID is the property that represents the Primary Key (uniquely distinguishes each shipper in the database) //cboShippers.Items.Insert(0, "[Select a shipper]"); cboShippers.SelectedIndex = 0; }
private void LookupBtn_Click(object sender, EventArgs e) { try { if (cboShippers.SelectedIndex <= 0) { MessageBox.Show("Please select a shipper before clicking [Lookup Shipper]"); } else { int shipperId = Convert.ToInt32(cboShippers.SelectedValue); NorthwindManager mgr = new NorthwindManager(); var shipper = mgr.GetShipper(shipperId); if (shipper != null) { lblShipperID.Text = shipper.ShipperID.ToString(); txtCompanyName.Text = shipper.CompanyName; txtPhone.Text = shipper.Phone; } } } catch(Exception ex) { //TODO: Log the exception MessageBox.Show("Error: " + ex.Message); } }