private void btnDeleteShipper_Click(object sender, EventArgs e)
{
try
{
int temp;
if (int.TryParse(tboShipperID.Text, out temp))
{
var data = new Shipper()
{
ShipperID = temp
};
var mgr = new NorthwindManager();
mgr.DeleteShipper(data);
//feedback to user
PopulateShippersComboBox();
//clear the form textboxes
tboShipperID.Text = "";
tboCompanyName.Text = "";
tboPhone.Text = "";
}
else
{
MessageBox.Show("Please lookup a shipper before trying to delete.");
}
}
catch (Exception ex)
{
//TODO: Log the exception
Program.LogMessage(ex.Message);
MessageBox.Show(ex.Message);
}
}
private void DeleteShipper_Click(object sender, EventArgs e)
{
try
{
int tempShipper;
if (int.TryParse(ShipperId.Text, out tempShipper))
{
// do the update...this is an initializer list, constructor runs, properties of the Shipper Object get values
var info = new Shipper()
{
ShipperID = tempShipper,
CompanyName = CompanyName.Text,
Phone = Phone.Text
};
var mgr = new NorthwindManager();
mgr.DeleteShipper(info);
PopulateShippersComboBox();
cboShippers.SelectedValue = info.ShipperID;
}
else
{
MessageBox.Show("Please look up a shipper before trying to delete.");
}
}
catch (Exception ex)
{
// TODO: Update logging
MessageBox.Show(ex.Message);
}
}
private void btnDeleteShipper_Click(object sender, EventArgs e)
{
try
{
int temp;
if (int.TryParse(lblShipperID.Text, out temp))
{
var info = new Shipper()
{
ShipperID = temp
};
var mgr = new NorthwindManager();
mgr.DeleteShipper(info);
// Feedback to user
PopulateShippersComboBox();
// clear the form textboxes
Clear();
}
else
{
MessageBox.Show("Please lookup a shipper before trying to delete.");
}
}
catch (Exception ex)
{
// TODO: log exception
MessageBox.Show(ex.Message);
}
}
private void btnDeleteShipper_Click(object sender, EventArgs e)
{
try
{
int temp;
if (int.TryParse(ShipperID.Text, out temp))
{
var elem = new Shipper()
{
ShipperID = temp
};
var mgr = new NorthwindManager();
mgr.DeleteShipper(elem);
PopulateShippersComboBox();
ShipperID.Text = "";
txtCompanyName.Text = "";
txtPhone.Text = "";
}
else
{
MessageBox.Show("Please look up a shipper before trying delete.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
}
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);
}
}
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);
}
[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 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);
}
private void DeleteShippers_Click(object sender, EventArgs e)
{
int temp;
if (int.TryParse(ShipperID.Text, out temp))
{
var data = new Shipper()
{
ShipperID = temp
};
var mgr = new NorthwindManager();
mgr.DeleteShipper(data);
//PopulateShippersComboBox();
ShipperID.Text = " ";
CompanyName.Text = "";
Phone.Text = "";
}
else
{
MessageBox.Show("Please lookup a shipper before trying to delete.");
}
}
