//Method to load a list of damage reports
private void LoadDamageReports()
{
var reports = new List <BoatDamage>();
using (var context = new BootDB())
{
//tables used: Boats - BoatsTypes - BoatDamages - Reservations- Members
//selected boat name, boat type description, damage level, damage location, reason the boat is damaged, date teh report was made, who reported the damage
var data = from m in context.Members
join bd in context.BoatDamages
on m.memberId equals bd.memberId
join b in context.Boats
on bd.boatId equals b.boatId
join bt in context.BoatTypes
on b.boatTypeId equals bt.boatTypeId
where bd.boatId == BoatId
select new
{
boatImageBlob = bd.boatImageBlob,
boatName = b.boatName,
boatDesc = bt.boatTypeDescription,
boatDamageLevel = bd.boatDamageLevel,
boatDamageLocation = bd.boatDamageLocation,
boatDamageReason = bd.boatDamageReason,
boatDamageReportDate = bd.reportDate,
boatDamageReporter = m.memberName
};
//add all reports to list
foreach (var d in data)
{
reports.Add(new BoatDamage
{
boatImageBlob = d.boatImageBlob,
boatDamageLevelText = BoatDamage.DamageLevelToString(d.boatDamageLevel),
boatDamageLocation = d.boatDamageLocation,
boatDamageReason = d.boatDamageReason,
boatDamageReportDate = d.boatDamageReportDate.ToString("dd-MM-yyyy"),
boatDamageReporter = d.boatDamageReporter
});
nameLabel.Content = d.boatName;
descriptionLabel.Content = d.boatDesc;
}
}
//add list with reports to the grid
ReportList.ItemsSource = reports;
}
public void DamageLevelToString_Input2MethodOutputIsSchade_ResultIsTrue()
{
//Arragne
var returnValue = "";
var input = 2;
var result = false;
//Act
returnValue = BoatDamage.DamageLevelToString(input);
if (returnValue == "Schade")
{
result = true;
}
//Assert
Assert.IsTrue(result);
}
