public CountriesController(
CountriesDbContext context,
ICountriesService countriesService)
{
this.context = context;
this.countriesService = countriesService;
}
public async Task <IEnumerable <CountrySubdivisionDto> > GetMatchingCountrySubdivisions(CountrySubdivisionDto countrySubdivision)
{
using (var context = new CountriesDbContext())
{
return(await context.CountrySubdivisions.Where(countrySubdivisionDto => countrySubdivisionDto.Id != countrySubdivision.Id && countrySubdivisionDto.CountryId == countrySubdivision.CountryId && countrySubdivisionDto.Name == countrySubdivision.Name).ToArrayAsync());
}
}
public IQueryable <Continent> ListBoxContinents_GetData()
{
CountriesDbContext data = new CountriesDbContext();
var continents = data.Continents;
return(continents.OrderBy(x => x.Id));
}
public async Task <IEnumerable <CountryDto> > GetMatchingCountries(CountryDto country)
{
using (var context = new CountriesDbContext())
{
return(await context.Countries.Where(countryDto => countryDto.FullName == country.FullName && countryDto.Alpha2Code == country.Alpha2Code && countryDto.Id != country.Id).ToArrayAsync());
}
}
public IQueryable <Country> GridViewCountries_GetData()
{
var selectedId = ListBoxContinents.SelectedValue;
int id = 0;
if (selectedId != "")
{
id = int.Parse(selectedId);
}
CountriesDbContext data = new CountriesDbContext();
//return data.Countries.OrderBy(x => x.Id);
return(data.Countries.Where(x => x.ContinentId == id).OrderBy(x => x.Id));
}
public IQueryable <Town> ListViewTowns_GetData()
{
object countryId = null;
if (this.GridViewCountries.SelectedDataKey != null)
{
countryId = this.GridViewCountries.SelectedDataKey.Value;
}
int id = 0;
if (countryId != null)
{
id = (int)countryId;
}
CountriesDbContext data = new CountriesDbContext();
//return data.Countries.OrderBy(x => x.Id);
return(data.Towns.Where(x => x.CountryId == id).OrderBy(x => x.Id));
}
public static void Initialize()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <CountriesDbContext, Configuration>());
CountriesDbContext.Create().Database.Initialize(true);
}
public CountriesService(CountriesDbContext context, IMapper mapper)
{
this.context = context;
this.mapper = mapper;
}
public CountriesController(CountriesDbContext countries)
{
_countries = countries;
}
public CityRepository(CountriesDbContext context)
{
_context = context;
}
public HomeController(ILogger <HomeController> logger, CountriesDbContext context)
{
_logger = logger;
Context = context;
}
public RegionRepository(CountriesDbContext context)
{
_context = context;
}
public GenericRepository(CountriesDbContext ctx)
{
_ctx = ctx;
}
