public void GetAllPotHolesTest()
{
PotholeDAL sql = new PotholeDAL(connectionString);
List <Pothole> potholeList = sql.GetAllPotholes();
Assert.AreEqual(potholeCount + 1, potholeList.Count);
}
public void InsertPotholeTest()
{
PotholeDAL sql = new PotholeDAL(connectionString);
Pothole pothole = new Pothole
{
Status = "Reported",
Severity = 4,
DateReported = DateTime.UtcNow.Date,
Longitude = -83.045653M,
Latitude = 39.99753999999996M,
};
Assert.AreEqual(updateId + 1, sql.InsertPothole(pothole));
}
public void UpdatePotholeTest()
{
DateTime repair = new DateTime(2018, 5, 30);
DateTime inspect = new DateTime(2018, 4, 30);
PotholeDAL sql = new PotholeDAL(connectionString);
Pothole pothole = new Pothole
{
PotholeID = updateId,
Status = "Inspected",
Severity = 5,
RepairDate = null,
InspectDate = inspect,
};
Assert.AreEqual(true, sql.UpdatePothole(pothole));
}
