public void TestCreateCarrier()
{
TruncateTable("User");
Carrier carrier = new Carrier();
carrier.Name = "WindsorCarrier1";
carrier.DepotCity = City.Windsor;
carrier.FtlAvailability = 100;
carrier.LtlAvailability = 50;
TmsDal dal = new TmsDal();
bool excepted = false;
try
{
carrier = dal.CreateCarrier(carrier);
}
catch (CouldNotInsertException)
{
excepted = true;
}
Assert.IsFalse(excepted);
Assert.IsTrue(carrier.CarrierID > 0);
}
/*================================================================================================
* Function : UpdateCarrier
* Description : This function will updates the Carrier according to the information given by admin
* Parameters : object sender:
* RoutedEventArgs e:
* Returns : Nothing as return type is void
* ` ================================================================================================*/
/// <summary>
/// This function will updates the Carrier according to the information given by admin
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void UpdateCarrier(object sender, RoutedEventArgs e)
{
if (CheckFields())
{
carrier.Name = txtCarrier_Name.Text;
TMS.Data.City city = (TMS.Data.City)Enum.Parse(typeof(TMS.Data.City), txtDepot_City.Text);
carrier.DepotCity = city;
carrier.FtlAvailability = Convert.ToInt32(txtFTL_Avail.Text);
carrier.LtlAvailability = Convert.ToInt32(txtLTL_Avail.Text);
carrier.FTLRate = Convert.ToInt32(txtFTL_Rate.Text);
carrier.LTLRate = Convert.ToInt32(txtLTL_Rate.Text);
carrier.ReeferCharge = Convert.ToInt32(txtReefer_Rate.Text);
list = tms.SearchCarriers(carrier.Name, txtDepot_City.Text);
if (list.Count != 0)
{
tms.UpdateCarrier(Convert.ToUInt32(cID), carrier);
MessageBox.Show("Carrier Updated Successfully ", "Done", MessageBoxButton.OK, MessageBoxImage.Information);
GetCarrierList();
MakeFieldEmpty();
}
else if (MessageBox.Show("Carrier does not exist !\n Do you want to add ?", "Warning", MessageBoxButton.YesNo, MessageBoxImage.Error) == MessageBoxResult.Yes)
{
tms.CreateCarrier(carrier);
MessageBox.Show("Carrier Added Successfully ", "Done", MessageBoxButton.OK, MessageBoxImage.Information);
MakeFieldEmpty();
GetCarrierList();
}
}
}
public void TestGetCarrier()
{
Carrier carrier = new Carrier();
carrier.Name = "HamiltonCarrier1";
carrier.DepotCity = City.Hamilton;
carrier.FtlAvailability = 20;
carrier.LtlAvailability = 13;
TmsDal dal = new TmsDal();
bool excepted = false;
try
{
carrier = dal.CreateCarrier(carrier);
}
catch (CouldNotInsertException)
{
excepted = true;
}
try
{
carrier = dal.GetCarrier(carrier.CarrierID);
}
catch (CarrierNotExistsException)
{
excepted = true;
}
Assert.IsFalse(excepted);
}
public void TestDeleteCarrier()
{
Carrier carrier = new Carrier();
carrier.Name = "BellevilleCarrier1";
carrier.DepotCity = City.Belleville;
carrier.FtlAvailability = 53;
carrier.LtlAvailability = 28;
TmsDal dal = new TmsDal();
bool excepted = false;
try
{
carrier = dal.CreateCarrier(carrier);
}
catch (CouldNotInsertException)
{
excepted = true;
}
try
{
dal.SetFtlRate(carrier.CarrierID, (float)1.28);
}
catch (CouldNotInsertException)
{
excepted = true;
}
try
{
dal.SetLtlRate(carrier.CarrierID, (float)5.23);
}
catch (CouldNotInsertException)
{
excepted = true;
}
try
{
dal.DeleteCarrier(carrier.CarrierID);
}
catch (CouldNotDeleteException)
{
excepted = true;
}
Assert.IsFalse(excepted);
}
public void TestGetReeferCharge()
{
TmsDal dal = new TmsDal();
Carrier carrier = new Carrier();
carrier.Name = "WindsorCarrier7";
carrier.DepotCity = City.Windsor;
carrier.FtlAvailability = 53;
carrier.LtlAvailability = 28;
carrier = dal.CreateCarrier(carrier);
dal.SetReeferCharge(carrier.CarrierID, (float)5.99);
dal.GetReeferCharge(carrier.CarrierID);
}
public void TestGetFtlRate()
{
TmsDal dal = new TmsDal();
Carrier carrier = new Carrier();
carrier.Name = "WindsorCarrier6";
carrier.DepotCity = City.Windsor;
carrier.FtlAvailability = 53;
carrier.LtlAvailability = 28;
carrier = dal.CreateCarrier(carrier);
dal.SetFtlRate(carrier.CarrierID, (float)7.283);
dal.GetFtlRate(carrier.CarrierID);
}
public void TestSetReeferCharge()
{
Carrier carrier = new Carrier();
carrier.Name = "OshawaCarrier3";
carrier.DepotCity = City.Ottawa;
carrier.LtlAvailability = 9;
carrier.FtlAvailability = 19;
TmsDal dal = new TmsDal();
bool excepted = false;
// Insert carrier
try
{
carrier = dal.CreateCarrier(carrier);
}
catch (CouldNotInsertException)
{
excepted = true;
}
// Try inserting a new ltl rate
try
{
dal.SetReeferCharge(carrier.CarrierID, (float)49.99);
}
catch (CouldNotInsertException)
{
excepted = true;
}
// Then try updating the existing rate
try
{
dal.SetReeferCharge(carrier.CarrierID, (float)44.99);
}
catch (CouldNotUpdateException)
{
excepted = true;
}
Assert.IsFalse(excepted);
}
public void TestSetFtlRate()
{
Carrier carrier = new Carrier();
carrier.Name = "OshawaCarrier1";
carrier.DepotCity = City.Oshawa;
carrier.LtlAvailability = 8;
carrier.FtlAvailability = 18;
TmsDal dal = new TmsDal();
bool excepted = false;
// Insert carrier
try
{
carrier = dal.CreateCarrier(carrier);
}
catch (CouldNotInsertException)
{
excepted = true;
}
// Try inserting a new ftl rate
try
{
dal.SetFtlRate(carrier.CarrierID, (float)250.89);
}
catch (CouldNotInsertException)
{
excepted = true;
}
// Then try updating the existing rate
try
{
dal.SetFtlRate(carrier.CarrierID, (float)180.20);
}
catch (CouldNotUpdateException)
{
excepted = true;
}
Assert.IsFalse(excepted);
}
public void TestUpdateCarrier()
{
Carrier carrier = new Carrier();
carrier.Name = "WindsorCarrier2";
carrier.DepotCity = City.Windsor;
carrier.LtlAvailability = 10;
carrier.FtlAvailability = 22;
TmsDal dal = new TmsDal();
bool excepted = false;
// Insert carrier
try
{
carrier = dal.CreateCarrier(carrier);
}
catch (CouldNotInsertException)
{
excepted = true;
}
// Update values
carrier.DepotCity = City.London;
try
{
carrier = dal.UpdateCarrier(carrier.CarrierID, carrier);
}
catch (CouldNotUpdateException)
{
excepted = true;
}
Assert.IsFalse(excepted);
}
