public void AllClaimsTest() { ClaimsSQLDAL sql = new ClaimsSQLDAL(connectionString); List <DamageClaimModel> claimList = sql.AllClaims(); Assert.AreEqual(claimsCount + 1, claimList.Count); }
public void ClaimsByPotHoleTest() { ClaimsSQLDAL sql = new ClaimsSQLDAL(connectionString); List <DamageClaimModel> claimsByPothole = sql.AllClaimsByPothole(potHoleID); Assert.AreEqual(potholeClaims, claimsByPothole.Count); }
public void NewClaimTest() { ClaimsSQLDAL sql = new ClaimsSQLDAL(connectionString); DamageClaimModel claim = new DamageClaimModel() { UserID = 2, Description = "testClaim", Estimated_cost = 200, SubmissionDate = DateTime.UtcNow.Date, Status = "Submitted", Pothole_ID = 77 }; Assert.AreEqual(claimID + 1, sql.NewClaim(claim)); }