public void Should_Delete_Shipper()
{
// Arrange
var sut = new NorthwindManager(); // sut is short for "Situation Under Test"
var expected = new Shipper()
{
CompanyName = "Montgomery Scott's Transporter Service",
Phone = "780.555.1212"
};
expected.ShipperID = sut.AddShipper(expected);
// Act
sut.DeleteShipper(expected);
// Assert
Shipper actual = sut.GetShipper(expected.ShipperID);
Assert.Null(actual);
}
public void Should_Delete_Product()
{
//Arrange
var sut = new NorthwindManager(); //sut is short for 'Scenario Under Test'
var expected = new Product()
{
ProductName = "Double Double",
UnitsInStock = 777
};
expected.ProductID = sut.AddProduct(expected);
//Act
sut.DeleteProduct(expected);
//Assert
Shipper actual = sut.GetShipper(expected.ProductID);
Assert.Null(actual);
}
[AutoRollback] // undo db changes after tst
public void Should_Add_Shipper()
{
// Arrange
var sut = new NorthwindManager(); // sut is short for "Situation under test"
var expected = new Shipper()
{
CompanyName = "Montgomery Scott's Transporter Service",
Phone = "780.555.1212"
};
//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);
}
[AutoRollback] //Undo DB changes after test
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);
}
private void btnLookupShipper_Click(object sender, EventArgs e)
{
// try catch block
// todo: log exception
// get data from form
if (cboShippers.SelectedIndex <= 0)
{
MessageBox.Show("Please select a shipper before clicking [Lookup]");
}
else
{
int shipperId = Convert.ToInt32(cboShippers.SelectedValue);
NorthwindManager mgr = new NorthwindManager();
Shipper data = mgr.GetShipper(shipperId);
// unpack the data
ShipperID.Text = data.ShipperID.ToString();
CompanyName.Text = data.CompanyName;
Phone.Text = data.Phone;
}
}
