public void t2_get_All_Ship_Redux_With_Weight_Load()
{
//Arrange
ShipQueries sut = new ShipQueries();
//Act
List <ContainerShipRedux> data = sut.GetAllShipsRedux();
//Assert
var genGroupedContainers =
from c in generator.Containers
group c by c.CurrentShip.Id into grouping
select new
{
ShipId = grouping.Key,
//ContainerCount = c.Count(),
WeightSum = grouping.Sum(s => s.Weight),
};
foreach (var item in genGroupedContainers)
{
Assert.AreEqual(
data.Where(sr => sr.Id == item.ShipId).First().TotalWeight,
item.WeightSum);
}
}
public void t1_get_All_Ship_Redux_With_correct_Container_Count()
{
//Arrange
ShipQueries sut = new ShipQueries();
//Act
List <ContainerShipRedux> data = sut.GetAllShipsRedux();
//Assert
var genGroupedContainers =
from c in generator.Containers
group c by c.CurrentShip.Id into grouping
select new
{
ShipId = grouping.Key,
ContainerCount = grouping.Count(),
};
foreach (var item in genGroupedContainers)
{
Assert.AreEqual(
data.Where(sr => sr.Id == item.ShipId).First().ContainerCount,
item.ContainerCount);
}
}
public void t4_insert_ship()
{
//Arrange
ShipQueries sut = new ShipQueries();
ContainerShip testShip = new ContainerShip()
{
Id = 61,
ATISCode = "gyugyctrcfcft456",
Name = "dsfdsfv",
Origin = new Harbor()
{
Id = 100
},
Destination = new Harbor()
{
Id = 101
},
DepartureTime = new System.DateTime(1992, 08, 12),
ArrivalTime = new System.DateTime(1992, 08, 12),
Cargo = new List <Container>(),
Crew = 6,
MaxHeight = 30,
MaxLength = 220,
MaxSpeed = 20,
MaxWeight = 33000,
MaxWidth = 20
};
//Act
sut.InsertShip(testShip);
var control = sut.GetShipById(testShip.Id);
//Assert
Assert.NotNull(control);
Assert.AreEqual(testShip.Id, control.Id);
Assert.AreEqual(testShip.ATISCode, control.ATISCode);
Assert.AreEqual(testShip.Name, control.Name);
Assert.AreEqual(testShip.DepartureTime, control.DepartureTime);
Assert.AreEqual(testShip.ArrivalTime, control.ArrivalTime);
Assert.AreEqual(testShip.Crew, control.Crew);
Assert.AreEqual(testShip.MaxHeight, control.MaxHeight);
Assert.AreEqual(testShip.MaxLength, control.MaxLength);
Assert.That(testShip.MaxSpeed, Is.EqualTo(control.MaxSpeed).Within(0.001));
Assert.AreEqual(testShip.MaxWeight, control.MaxWeight);
Assert.AreEqual(testShip.MaxWidth, control.MaxWidth);
}
public void t3_get_ship_by_crew_size_return_list_in_right_order()
{
//Arrange
ShipQueries sut = new ShipQueries();
//Act
List <ContainerShip> data = sut.GetShipsByCrew();
List <ContainerShip> sortgen = generator.ContainerShips.OrderBy(s => s.Crew).ToList();
data.OrderBy(d => d.Crew);
//Assert
for (int i = 0; i < generator.ContainerShips.Count; i++)
{
Assert.AreEqual(sortgen[i].Crew, data[i].Crew);
}
}
public void t1_get_All_Ships()
{
//Arrange
ShipQueries sut = new ShipQueries();
//Act
List <ContainerShip> data = sut.GetAllShips();
//Assert
Assert.AreEqual(generator.ContainerShips.Count, data.Count);
generator.ContainerShips.OrderBy(s => s.Id);
data.OrderBy(s => s.Id);
for (int i = 0; i < generator.ContainerShips.Count; i++)
{
Assert.AreEqual(generator.ContainerShips[i].Name, data[i].Name);
}
}
public void t5_delete_ship()
{
//Arrange
ContainerShip testShip = new ContainerShip()
{
Id = 50,
ATISCode = Guid.NewGuid().ToString(),
Name = generator.GetRandomName(),
Origin = new Harbor()
{
Id = 100
},
Destination = new Harbor()
{
Id = 101
},
DepartureTime = new System.DateTime(1992, 08, 12),
ArrivalTime = new System.DateTime(1992, 08, 12),
Cargo = new List <Container>(),
Crew = 6,
MaxHeight = 30,
MaxLength = 220,
MaxSpeed = 20,
MaxWeight = 33000,
MaxWidth = 20
};
ShipQueries sut = new ShipQueries();
//Act
sut.InsertShip(testShip);
sut.DeleteShip(testShip);
var control = sut.GetShipById(testShip.Id);
//Assert
Assert.Null(control);
}
public void t2_get_correct_ship_by_id()
{
//Arrange
ShipQueries sut = new ShipQueries();
//Act
ContainerShip genData = generator.ContainerShips.FirstOrDefault();
ContainerShip data = sut.GetShipById(genData.Id);
//Assert
Assert.AreEqual(genData.Id, data.Id);
Assert.AreEqual(genData.ATISCode, data.ATISCode);
Assert.AreEqual(genData.Name, data.Name);
Assert.AreEqual(genData.DepartureTime, data.DepartureTime);
Assert.AreEqual(genData.ArrivalTime, data.ArrivalTime);
Assert.AreEqual(genData.Crew, data.Crew);
Assert.AreEqual(genData.MaxHeight, data.MaxHeight);
Assert.AreEqual(genData.MaxLength, data.MaxLength);
Assert.That(genData.MaxSpeed, Is.EqualTo(data.MaxSpeed).Within(0.001));
Assert.AreEqual(genData.MaxWeight, data.MaxWeight);
Assert.AreEqual(genData.MaxWidth, data.MaxWidth);
}