public async void DeleteFavRetailer_CanDeleteFavRetailerById() { DbContextOptions <RimrockDBContext> options = new DbContextOptionsBuilder <RimrockDBContext>().UseInMemoryDatabase("CanDeleteFavRetailerById").Options; using (RimrockDBContext context = new RimrockDBContext(options)) { // Arrange FavRetailer newFavRetailer = new FavRetailer(); newFavRetailer.Id = 1; newFavRetailer.Name = "Second Ascents"; newFavRetailer.Specialty = "Climbing"; // Act FavRetailerService favRetailerService = new FavRetailerService(context); await context.FavRetailers.AddAsync(newFavRetailer); await context.SaveChangesAsync(); // Act await favRetailerService.DeleteFavRetailer(1); List <FavRetailer> listOfRetailersInDb = await context.FavRetailers.Where(fr => fr.UserId == newFavRetailer.Id).ToListAsync(); // Assert Assert.Empty(listOfRetailersInDb); }; }
public async void DeleteFavLocation_CanDeleteFavLocationById() { DbContextOptions <RimrockDBContext> options = new DbContextOptionsBuilder <RimrockDBContext>().UseInMemoryDatabase("CanDeleteFavLocById").Options; using (RimrockDBContext context = new RimrockDBContext(options)) { // Arrange FavLocation newFavLocation = new FavLocation(); newFavLocation.Id = 1; newFavLocation.UserId = 1; newFavLocation.RegionId = 2; newFavLocation.Name = "Grand Teton"; newFavLocation.Cost = "$$"; FavLocationService favLocService = new FavLocationService(context); await context.FavLocations.AddAsync(newFavLocation); await context.SaveChangesAsync(); // Act await favLocService.DeleteFavLocation(1); List <FavLocation> listOfLocationsInDb = await context.FavLocations.Where(fl => fl.UserId == newFavLocation.Id).ToListAsync(); // Assert Assert.Empty(listOfLocationsInDb); }; }
public async void GetFavRetailer_CanGetFavRetailerById(int numForFavRetailerId, int numToTest, int numForUserId, bool expectedBool) { DbContextOptions <RimrockDBContext> options = new DbContextOptionsBuilder <RimrockDBContext>().UseInMemoryDatabase("CanGetFavRetailerById").Options; using (RimrockDBContext context = new RimrockDBContext(options)) { // Arrange FavRetailer newFavRetailer = new FavRetailer(); newFavRetailer.Id = numForFavRetailerId; newFavRetailer.UserId = numForUserId; newFavRetailer.RegionId = 2; newFavRetailer.Name = "Grand Teton"; newFavRetailer.Specialty = "Mountaineering"; FavRetailerService favRetailerService = new FavRetailerService(context); await context.FavRetailers.AddAsync(newFavRetailer); await context.SaveChangesAsync(); // Act List <FavRetailer> favRetailerListFromDb = await favRetailerService.GetFavRetailers(newFavRetailer.UserId); // Boolean test (needed for Theory-type unit test) bool actualBool = false; if (numToTest == favRetailerListFromDb[0].UserId) { actualBool = true; } // Assert Assert.Equal(actualBool, expectedBool); }; }
public async void GetFavLocation_CanGetFavLocationById ( int numForFavLocId, int numToTest, int numForUserId, bool expectedBool ) { DbContextOptions <RimrockDBContext> options = new DbContextOptionsBuilder <RimrockDBContext>().UseInMemoryDatabase("CanGetFavLocById").Options; using (RimrockDBContext context = new RimrockDBContext(options)) { // Arrange FavLocation newFavLocation = new FavLocation(); newFavLocation.Id = numForFavLocId; newFavLocation.UserId = numForUserId; newFavLocation.RegionId = 2; newFavLocation.Name = "Grand Teton"; newFavLocation.Cost = "$$"; FavLocationService favLocService = new FavLocationService(context); await context.FavLocations.AddAsync(newFavLocation); await context.SaveChangesAsync(); // Act List <FavLocation> favLocationListFromDb = await favLocService.GetFavLocations(newFavLocation.UserId); // Boolean test (needed for Theory-type unit test) bool actualBool = false; if (numToTest == favLocationListFromDb[0].UserId) { actualBool = true; } // Assert Assert.Equal(actualBool, expectedBool); }; }
public async void GetUser_CanGetSingleUser() { DbContextOptions <RimrockDBContext> options = new DbContextOptionsBuilder <RimrockDBContext>().UseInMemoryDatabase("CanGetSingleUserByName").Options; using (RimrockDBContext context = new RimrockDBContext(options)) { // Arrange User newUser = new User(); newUser.ID = 1; newUser.Name = "Jason Burns"; // Act UserService userService = new UserService(context); await context.Users.AddAsync(newUser); await context.SaveChangesAsync(); User userFromDb = await userService.GetUser(newUser.Name); // Assert Assert.Equal(userFromDb, newUser); }; }
/// <summary> /// Adds new user to DB /// </summary> /// <param name="user">User object to save to DB</param> /// <returns>Task object</returns> public async Task CreateUser(User user) { await _context.Users.AddAsync(user); await _context.SaveChangesAsync(); }
/// <summary> /// Saves new favorited retailer to DB /// </summary> /// <param name="favRetailer">object containing favorited retailer</param> /// <returns>Task</returns> public async Task CreateFavRetailer(FavRetailer favRetailer) { await _context.FavRetailers.AddAsync(favRetailer); await _context.SaveChangesAsync(); }
/// <summary> /// Saves new favorited location to DB /// </summary> /// <param name="favLocation">favorited location to save</param> /// <returns>Task</returns> public async Task CreateFavLocation(FavLocation favLocation) { await _context.FavLocations.AddAsync(favLocation); await _context.SaveChangesAsync(); }