public void TestInsertUpdateAndGetWareHouse()
{
WareHouseBL wareHouseBL = new WareHouseBL(connectionString);
WareHouse wareHouse = WareHouseHelper.CreateDummyWareHouse();
wareHouse = wareHouseBL.InsertWareHouse(wareHouse);
Assert.IsTrue(wareHouse.Id > 0);
//Test get by Id
List <WareHouse> savedWareHouses = wareHouseBL.GetWareHouse(wareHouse.Id);
Assert.IsTrue(savedWareHouses.Count() == 1);
WareHouse savedWareHouse = savedWareHouses[0];
Assert.IsTrue(savedWareHouse.Id == wareHouse.Id); //Todo create custom validator to check all properties
//Test get all
savedWareHouses = wareHouseBL.GetWareHouse();
savedWareHouse = (from ticket in savedWareHouses where ticket.Id == savedWareHouse.Id select ticket).FirstOrDefault();
Assert.IsTrue(savedWareHouse != null);
//Test update
wareHouse.Name = "WareHouse Updated";
wareHouse.Address = "Address Updated"; //Todo check other properties
wareHouse = wareHouseBL.UpdateWareHouse(wareHouse);
savedWareHouses = wareHouseBL.GetWareHouse(wareHouse.Id);
Assert.IsTrue(savedWareHouses != null && savedWareHouses.Count() == 1);
savedWareHouse = savedWareHouses[0];
Assert.IsTrue(savedWareHouse.Name == "wareHouseUpdated");
Assert.IsTrue(savedWareHouse.Address == "Address Updated");
//Test delete
bool result = wareHouseBL.DeleteWareHouse(savedWareHouse.Id);
Assert.IsTrue(result);
savedWareHouses = wareHouseBL.GetWareHouse(wareHouse.Id);
Assert.IsTrue(savedWareHouses.Count() == 0);
}
public WareHouseController()
{
string connectionString = "Server=tcp:lasmargaritas.database.windows.net,1433;Initial Catalog=LasMargaritasDBDev;Persist Security Info=False;User ID=LasMargaritasDbUser;Password=LasMargaritasPassw0rd!;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
if (ConfigurationManager.ConnectionStrings["LasMargaritasDb"] != null)
{
connectionString = ConfigurationManager.ConnectionStrings["LasMargaritasDb"].ConnectionString;
}
wareHouseBL = new WareHouseBL(connectionString);
}
public void TestDeleteErrors()
{
WareHouseBL wareHouseBL = new WareHouseBL(connectionString);
try
{
wareHouseBL.DeleteWareHouse(0);
}
catch (WareHouseException exception)
{
Assert.IsTrue(exception.Error.HasFlag(WareHouseError.InvalidId));
}
}
public void TestInsertUpdateErrors()
{
WareHouseBL wareHouseBL = new WareHouseBL(connectionString);
WareHouse wareHouse = new WareHouse();
try
{
wareHouseBL.InsertWareHouse(wareHouse);
}
catch (WareHouseException exception)
{
Assert.IsTrue(exception.Error.HasFlag(WareHouseError.InvalidAddress));
Assert.IsTrue(exception.Error.HasFlag(WareHouseError.InvalidName));
}
try
{
wareHouseBL.UpdateWareHouse(wareHouse);
}
catch (WareHouseException exception)
{
Assert.IsTrue(exception.Error.HasFlag(WareHouseError.InvalidAddress));
Assert.IsTrue(exception.Error.HasFlag(WareHouseError.InvalidName));
}
}
