private void btnAdShipper_Click(object sender, EventArgs e)
{
try
{
Shipper elem = new Shipper()
{
CompanyName = txtCompanyName.Text,
Phone = txtPhone.Text
};
var mgr = new NorthwindManager();
elem.ShipperID = mgr.AddShipper(elem);
//give feed back to user
// updater shipper combobox and select right shipper
//display id of added shipper
PopulateShippersComboBox();
cboShippers.SelectedValue = elem.ShipperID;
ShipperID.Text = elem.ShipperID.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
}
private void btnAddShipper_Click(object sender, EventArgs e)
{
try
{
Shipper item = new Shipper()
{
CompanyName = tboCompanyName.Text,
Phone = tboPhone.Text
};
var mgr = new NorthwindManager();
item.ShipperID = mgr.AddShipper(item);
//Give some feedback to the user...
// - Update my combo-box
PopulateShippersComboBox();
// - My combo-box has the right shipper selected
cboShippers.SelectedValue = item.ShipperID;
// - Display the id fo the addd shipper
tboShipperID.Text = item.ShipperID.ToString();
}
catch (Exception ex)
{
//TODO: Log the exception
MessageBox.Show(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);
}
}
public void Should_Deklete_Shipper()
{
//Arrange
var sut = new NorthwindManager();
var expected = new Shipper()
{
CompanyName = "Montgomery Scott's Transporter Service",
Phone = "780.555.1212"
};
expected.ShipperID = sut.AddShipper(expected);
//Act
sut.DeleteShipper(expected);
//Assert
var actual = sut.GetShipper(expected.ShipperID);
Assert.Null(actual);
}
private void AddShipper_Click(object sender, EventArgs e)
{
// try - catch error
Shipper item = new Shipper()
{
CompanyName = CompanyName.Text,
Phone = Phone.Text
};
var mgr = new NorthwindManager();
item.ShipperID = mgr.AddShipper(item);
// give some feedback to the user..
// update my combo box
// my combo box has the right shipper selected
cboShippers.SelectedValue = item.ShipperID;
// display the id of the added shipper
ShipperID.Text = item.ShipperID.ToString();
}
[AutoRollback] // undo db changes after tst
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 - probably a fk constraint
sut.DeleteShipper(expected);
//assert
//
Shipper actual = sut.GetShipper(expected.ShipperID);
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_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);
}
[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 Add_Click(object sender, EventArgs e)
{
try
{
Shipper item = new Shipper()
{
CompanyName = CompanyName.Text,
Phone = Phone.Text
};
var mgr = new NorthwindManager();
item.ShipperID = mgr.AddShipper(item);
// give some feedback to the user
// - update my combo box
// -my combo box has the right shipper selected
// -display the id of the added shipper
ShipperId.Text = item.ShipperID.ToString();
}
catch (Exception ex)
{
//throw;
// TODO: Add logging
MessageBox.Show(ex.Message);
}
}
