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));
        }