public void CanDeleteListing() { Listing listingToAdd = new Listing(); var repo = new ListingsRepositoryADO(); listingToAdd.UserId = "00000000-0000-0000-0000-000000000000"; listingToAdd.StateId = "OH"; listingToAdd.Nickname = "My Test Shack"; listingToAdd.BathroomTypeId = 1; listingToAdd.City = "Columbus"; listingToAdd.Rate = 50M; listingToAdd.SquareFootage = 100M; listingToAdd.HasElectric = true; listingToAdd.HasHeat = true; listingToAdd.ImageFileName = "placeholder.png"; listingToAdd.ListingDescription = "Description"; repo.Insert(listingToAdd); var loaded = repo.GetById(7); Assert.IsNotNull(loaded); repo.Delete(7); loaded = repo.GetById(7); Assert.IsNull(loaded); }
public void NotFoundListingReturnsNull() { var repo = new ListingsRepositoryADO(); var listing = repo.GetById(100000); Assert.IsNull(listing); }
public void CanSearchOnCity() { var repo = new ListingsRepositoryADO(); var found = repo.ListingSearch(new ListingSearchParameters { City = "Cleveland" }); Assert.AreEqual(6, found.Count()); }
public void CanSearchOnRange() { var repo = new ListingsRepositoryADO(); var found = repo.ListingSearch(new ListingSearchParameters { MaxRate = 120M, MinRate = 100M }); Assert.AreEqual(3, found.Count()); }
public void CanSearchOnMinRate() { var repo = new ListingsRepositoryADO(); var found = repo.ListingSearch(new ListingSearchParameters { MinRate = 110M }); Assert.AreEqual(5, found.Count()); }
public void CanLoadRecentListings() { var repo = new ListingsRepositoryADO(); List <ListingShortItem> listings = repo.ListingGetRecent().ToList(); Assert.AreEqual(5, listings.Count()); Assert.AreEqual(6, listings[0].ListingId); Assert.AreEqual(Guid.Empty.ToString(), listings[0].UserId); Assert.AreEqual(150M, listings[0].Rate); Assert.AreEqual("Cleveland", listings[0].City); Assert.AreEqual("OH", listings[0].StateId); Assert.AreEqual("placeholder.png", listings[0].ImageFileName); }
public void CanUpdateListing() { Listing listingToAdd = new Listing(); var repo = new ListingsRepositoryADO(); listingToAdd.UserId = "00000000-0000-0000-0000-000000000000"; listingToAdd.StateId = "OH"; listingToAdd.Nickname = "My Test Shack"; listingToAdd.BathroomTypeId = 1; listingToAdd.City = "Columbus"; listingToAdd.Rate = 50M; listingToAdd.SquareFootage = 100M; listingToAdd.HasElectric = true; listingToAdd.HasHeat = true; listingToAdd.ImageFileName = "placeholder.png"; listingToAdd.ListingDescription = "Description"; repo.Insert(listingToAdd); listingToAdd.StateId = "KY"; listingToAdd.Nickname = "My Updated Shack"; listingToAdd.BathroomTypeId = 2; listingToAdd.City = "Louisville"; listingToAdd.Rate = 25M; listingToAdd.SquareFootage = 75M; listingToAdd.HasElectric = false; listingToAdd.HasHeat = false; listingToAdd.ImageFileName = "updated.png"; listingToAdd.ListingDescription = "updated"; repo.Update(listingToAdd); var updatedListing = repo.GetById(7); Assert.AreEqual("KY", updatedListing.StateId); Assert.AreEqual("My Updated Shack", updatedListing.Nickname); Assert.AreEqual(2, updatedListing.BathroomTypeId); Assert.AreEqual("Louisville", updatedListing.City); Assert.AreEqual(25M, updatedListing.Rate); Assert.AreEqual(75M, updatedListing.SquareFootage); Assert.AreEqual(false, updatedListing.HasElectric); Assert.AreEqual(false, updatedListing.HasHeat); Assert.AreEqual("updated.png", updatedListing.ImageFileName); Assert.AreEqual("updated", updatedListing.ListingDescription); }
public void CanLoadListing() { var repo = new ListingsRepositoryADO(); var listing = repo.GetById(1); Assert.IsNotNull(listing); Assert.AreEqual(1, listing.ListingId); Assert.AreEqual("00000000-0000-0000-0000-000000000000", listing.UserId); Assert.AreEqual("OH", listing.StateId); Assert.AreEqual(3, listing.BathroomTypeId); Assert.AreEqual("Test shack 1", listing.Nickname); Assert.AreEqual("Cleveland", listing.City); Assert.AreEqual(120M, listing.Rate); Assert.AreEqual(400M, listing.SquareFootage); Assert.AreEqual(false, listing.HasElectric); Assert.AreEqual(true, listing.HasHeat); Assert.AreEqual("placeholder.png", listing.ImageFileName); }
public void CanAddListing() { var listingToAdd = new Listing(); var repo = new ListingsRepositoryADO(); listingToAdd.UserId = Guid.Empty.ToString(); listingToAdd.StateId = "OH"; listingToAdd.BathroomTypeId = 1; listingToAdd.Nickname = "Test Shack 1"; listingToAdd.City = "Columbus"; listingToAdd.Rate = 50M; listingToAdd.SquareFootage = 100M; listingToAdd.HasElectric = true; listingToAdd.HasHeat = true; listingToAdd.ListingDescription = "Test Description"; listingToAdd.ImageFileName = "placeholder.png"; repo.ListingInsert(listingToAdd); Assert.AreEqual(7, listingToAdd.ListingId); }
public void CanAddListing() { Listing listingToAdd = new Listing(); var repo = new ListingsRepositoryADO(); listingToAdd.UserId = "00000000-0000-0000-0000-000000000000"; listingToAdd.StateId = "OH"; listingToAdd.BathroomTypeId = 1; listingToAdd.Nickname = "My Test Shack"; listingToAdd.City = "Columbus"; listingToAdd.Rate = 50M; listingToAdd.SquareFootage = 100M; listingToAdd.HasElectric = true; listingToAdd.HasHeat = true; listingToAdd.ImageFileName = "placeholder.png"; repo.Insert(listingToAdd); Assert.AreEqual(2, listingToAdd.ListingId); }
public void CanLoadListing() { var repo = new ListingsRepositoryADO(); Listing listing = repo.ListingGetById(1); Assert.IsNotNull(listing); //1, '00000000-0000-0000-0000-000000000000', 'OH', 1, 'Test shack 1', 'Cleveland', 120, 400, 0, 1, 'placeholder.png' Assert.AreEqual(1, listing.ListingId); Assert.AreEqual(Guid.Empty.ToString(), listing.UserId); Assert.AreEqual("OH", listing.StateId); Assert.AreEqual(1, listing.BathroomTypeId); Assert.AreEqual("Test shack 1", listing.Nickname); Assert.AreEqual("Cleveland", listing.City); Assert.AreEqual(100M, listing.Rate); Assert.AreEqual(400M, listing.SquareFootage); Assert.AreEqual(false, listing.HasElectric); Assert.AreEqual(true, listing.HasHeat); Assert.AreEqual("Description 1", listing.ListingDescription); Assert.AreEqual("placeholder.png", listing.ImageFileName); }