public void GetAllShouldWorkCorrectlyWithNoAddedCountriesUsingMoq() { var repository = new Mock <IRepository <Country> >(); var countriesList = new List <Country>(); repository.Setup(r => r.AllAsNoTracking()).Returns(countriesList.AsQueryable()); var service = new CountriesService(repository.Object); Assert.Empty(service.GetAll()); Assert.Equal(countriesList, service.GetAll()); repository.Verify(x => x.AllAsNoTracking(), Times.Exactly(2)); }
public async Task GetAllTest() { var countries = new List <Country> { new Country() { Name = "Country-1" }, new Country() { Name = "Country-2" }, }; var fakeRepositoryMock = new Mock <ICountriesRepository>(); fakeRepositoryMock.Setup(x => x.GetAll()).ReturnsAsync(countries); var countriesService = new CountriesService(fakeRepositoryMock.Object); var result = await countriesService.GetAll(); Assert.Collection(result, country => { Assert.Equal("Country-1", country.Name); }, country => { Assert.Equal("Country-2", country.Name); }); }
public async Task GetAllWorksCorrectly() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()).Options; var dbContext = new ApplicationDbContext(options); var addressesServiceMock = new Mock <IAddressesService>(); var citiesRepository = new EfDeletableEntityRepository <City>(dbContext); var repository = new EfDeletableEntityRepository <Country>(dbContext); var citiesServiceMock = new Mock <CitiesService>(citiesRepository, addressesServiceMock.Object); var service = new CountriesService(repository, citiesServiceMock.Object); var country1 = new Country() { Id = 1, }; var country2 = new Country() { Id = 2, }; var country3 = new Country() { Id = 3, }; dbContext.Add(country1); dbContext.Add(country2); dbContext.Add(country3); await dbContext.SaveChangesAsync(); var result = await service.GetAll(); Assert.Equal(3, result.Count()); }
public void GetAllShouldWorkCorrectlyUsingMoq() { var repository = new Mock <IRepository <Country> >(); var countriesList = new List <Country> { new Country { Id = 1, CreatedOn = DateTime.UtcNow, Name = "TestCountry1" }, new Country { Id = 1, CreatedOn = DateTime.UtcNow, Name = "TestCountry2" }, new Country { Id = 1, CreatedOn = DateTime.UtcNow, Name = "TestCountry3" }, }; repository.Setup(r => r.AllAsNoTracking()).Returns(countriesList.AsQueryable()); var service = new CountriesService(repository.Object); Assert.Equal(countriesList, service.GetAll()); repository.Verify(x => x.AllAsNoTracking(), Times.Once); }
public async Task GetAllShouldWorkCorrectlyUsingDbContext() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(databaseName: "GetAllShouldWorkCorrectlyUsingDbContextCountriesServiceTests").Options; using var dbContext = new ApplicationDbContext(options); await dbContext.Countries.AddAsync(new Country { Name = "TestCountry1" }); await dbContext.Countries.AddAsync(new Country { Name = "TestCountry2" }); await dbContext.Countries.AddAsync(new Country { Name = "TestCountry3" }); await dbContext.SaveChangesAsync(); using var repository = new EfRepository <Country>(dbContext); var service = new CountriesService(repository); Assert.Equal(3, service.GetAll().Count()); Assert.Equal(1, service.GetAll().FirstOrDefault().Id); Assert.Equal("TestCountry1", service.GetAll().FirstOrDefault().Name); Assert.Equal(2, service.GetAll().ElementAt(1).Id); Assert.Equal("TestCountry2", service.GetAll().ElementAt(1).Name); Assert.Equal(3, service.GetAll().ElementAt(2).Id); Assert.Equal("TestCountry3", service.GetAll().ElementAt(2).Name); }
public void GetAllShouldWorkCorrectlyWithNoAddedCategoriesUsingDbContext() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(databaseName: "GetAllShouldWorkCorrectlyWithNoAddedCategoriesUsingDbContextCountriesServiceTests").Options; using var dbContext = new ApplicationDbContext(options); using var repository = new EfRepository <Country>(dbContext); var service = new CountriesService(repository); Assert.Empty(service.GetAll()); }
internal static void Configure() { Dictionary <string, string[]> locations = new Dictionary <string, string[]>(); using (WebClient webClient = new WebClient()) { string jsonString = webClient.DownloadString("https://raw.githubusercontent.com/David-Haim/CountriesToCitiesJSON/master/countriesToCities.json"); locations = JsonConvert.DeserializeObject <Dictionary <string, string[]> >(jsonString); } CountriesService countriesService = new CountriesService(); List <Country> countries = new List <Country>(); foreach (var item in locations) { Country country = new Country(); country.Name = item.Key; countries.Add(country); } countriesService.InsertCollection(countries); List <Country> allCountries = countriesService.GetAll(); List <City> cities = new List <City>(); foreach (var item in locations) { foreach (Country c in allCountries) { if (c.Name == item.Key) { cities.AddRange(item.Value.Select(city => new City() { Name = city, CountryID = c.ID })); } } } CitiesService citieService = new CitiesService(); citieService.InsertCollection(cities); }
public async Task TestGetAllCountries() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase("Countries"); var countryRepository = new EfDeletableEntityRepository <Country>(new ApplicationDbContext(options.Options)); await countryRepository.AddAsync(new Country { Name = "Bulgaria" }); await countryRepository.AddAsync(new Country { Name = "Turkey" }); await countryRepository.AddAsync(new Country { Name = "Russia" }); await countryRepository.SaveChangesAsync(); var countryService = new CountriesService(countryRepository); AutoMapperConfig.RegisterMappings(typeof(MyTestCountry).Assembly); var countries = countryService.GetAll <MyTestCountry>(); Assert.Equal(3, countries.Count()); }
// GET: Countries public async Task <IActionResult> Index() { return(View(await _service.GetAll())); }
//public void LoadAddressControl() //{ // txtAddressId.Value = AddressId; // txtLine1.Text = Line1; // txtLine2.Text = Line2; // txtTownCity.Text = TownCity; // txtStateOrProvince.Text = StateOrProvince; // txtPostCod.Text = PostCod; // //ddlCountries.SelectedItem.Value = CountryCode; // ddlCountries.Items.FindByValue(CountryCode).Selected = true; //} private TList <Countries> LoadCountries() { CountriesService countriesService = new CountriesService(); return(countriesService.GetAll()); }
public ActionResult List() { CountriesService countriesService = new CountriesService(); CountriesListVM model = new CountriesListVM(); TryUpdateModel(model); model.Countries = countriesService.GetAll(); if (!String.IsNullOrEmpty(model.Search)) { model.Countries = model.Countries.Where(c => c.Name.ToLower().Contains(model.Search.ToLower())).ToList(); } switch (model.SortOrder) { case "population_asc": model.Countries = model.Countries.OrderBy(c => c.Population).ToList(); break; case "population_desc": model.Countries = model.Countries.OrderByDescending(c => c.Population).ToList(); break; case "date_asc": model.Countries = model.Countries.OrderBy(c => c.FoundationDate).ToList(); break; case "date_desc": model.Countries = model.Countries.OrderByDescending(c => c.FoundationDate).ToList(); break; case "name_desc": model.Countries = model.Countries.OrderByDescending(c => c.Name).ToList(); break; case "name_asc": default: model.Countries = model.Countries.OrderBy(c => c.Name).ToList(); break; } return View(model); }