public async Task <ActionResult> AddorEdit([Bind("Name, CountryCode, District, Population")] City city)
{
var context = new worldContext();
var currentCity = context.City.Where(c => c.Name.Equals(city.Name)).FirstOrDefault();
if (ModelState.IsValid)
{
if (currentCity == null)
{
context.Add(city);
}
else
{
currentCity.Name = city.Name;
currentCity.CountryCode = city.CountryCode;
currentCity.District = city.District;
currentCity.Population = city.Population;
context.Update(currentCity);
}
await context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(city));
}
public async Task <IEnumerable <City> > GetCitiesAsync()
{
using (var context = new worldContext())
{
return(await context.City.Include(x => x.CountryCodeNavigation).ToListAsync());
}
}
public async Task <IEnumerable <Country> > GetCountriesAsync()
{
using (var context = new worldContext())
{
return(await context.Country.ToListAsync());
}
}
public async Task CreateCityAsync(City city)
{
using (var context = new worldContext())
{
await context.City.AddAsync(city);
context.SaveChanges();
}
}
public async Task <City> GetCityDetailsAsync(int cityId)
{
using (var context = new worldContext())
{
var countryQuery = context.City.Include(db => db.CountryCodeNavigation);
var details = await countryQuery.SingleOrDefaultAsync(x => x.Id == cityId);
return(details);
}
}
public async Task <Country> GetCountryDetailsAsync(string countryCode)
{
using (var context = new worldContext())
{
var countryQuery = context.Country.Include(db => db.City);
var details = await countryQuery.SingleOrDefaultAsync(x => x.Code == countryCode);
return(details);
}
}
public async Task UpdateCityAsync(City city)
{
await Task.Run(() =>
{
using (var context = new worldContext())
{
context.City.Update(city);
context.SaveChanges();
}
});
}
public async Task UpdateCountryAsync(Country country)
{
await Task.Run(() =>
{
using (var context = new worldContext())
{
context.Country.Update(country);
context.SaveChanges();
}
});
}
static void Main(string[] args)
{
worldContext context = new worldContext();
ICity cityService = new CityService(context);
// this is example of various testing scenarios
// cityService.AddCity(new City(5000, "markov grad", "markovija", 2, "PSE"));
// cityService.UpdateCity(5001, "markov promijenjeni grad", "markovija", 5, "PSE");
// cityService.DeleteCity(5001);
// List<City> cities = cityService.FindCities("", "", 12000, "");
}
// GET: CountryController
public ActionResult Index()
{
var context = new worldContext();
var list = context.Country.ToList();
var list2 = new List <Country>();
foreach (Country country in list)
{
country.NationalFlag = convertPath(country);
list2.Add(country);
}
return(View(list2));
}
public ActionResult AddorEdit(string id)
{
var context = new worldContext();
if (id == null || id.Length == 0)
{
return(View(new Country()));
}
else
{
return(View(context.Country.Find(id)));
}
}
// GET: CountryController/Delete/5
public ActionResult Delete(string id)
{
var context = new worldContext();
if (id == null)
{
return(NotFound());
}
var country = context.Country.FirstOrDefault(c => c.Code.Equals(id));
context.Country.Remove(country);
context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
public ActionResult AddorEdit(int id)
{
var context = new worldContext();
if (id == 0)
{
ViewBag.ListCountry = context.Country.ToList();
return(View(new City()));
}
else
{
ViewBag.ListCountry = context.Country.ToList();
return(View(context.City.Find(id)));
}
}
public async Task RemoveCityByIdAsync(int id)
{
await Task.Run(() =>
{
using (var context = new worldContext())
{
var cityToDelete = new City {
Id = id
};
context.City.Attach(cityToDelete);
context.City.Remove(cityToDelete);
context.SaveChanges();
}
});
}
public async Task RemoveCountryByCodeAsync(string code)
{
await Task.Run(() =>
{
using (var context = new worldContext())
{
var countryToDelete = new Country {
Code = code
};
context.Country.Attach(countryToDelete);
context.Country.Remove(countryToDelete);
context.SaveChanges();
}
});
}
// GET: CityController/Delete/5
public ActionResult Delete(int id)
{
var context = new worldContext();
if (id == 0)
{
return(NotFound());
}
var city = context.City.FirstOrDefault(c => c.Id.Equals(id));
if (city == null)
{
return(NotFound());
}
return(View(city));
}
// GET: CountryController/Details/5
public ActionResult Detail(string id)
{
var context = new worldContext();
if (id == null)
{
return(NotFound());
}
var country = context.Country.FirstOrDefault(c => c.Code.Equals(id));
country.NationalFlag = convertPath(country);
if (country == null)
{
return(NotFound());
}
return(View(country));
}
public ActionResult Delete(int?id)
{
try
{
var context = new worldContext();
if (id == 0)
{
return(NotFound());
}
var city = context.City.FirstOrDefault(c => c.Id == id);
context.City.Remove(city);
context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public async Task <ActionResult> AddorEdit([Bind("Code, Name, Region, NationalFlag")] Country country)
{
var context = new worldContext();
var currentCountry = context.Country.Find(country.Code);
if (ModelState.IsValid)
{
if (currentCountry == null)
{
context.Add(country);
}
else
{
currentCountry.Name = country.Name;
currentCountry.Region = country.Region;
currentCountry.NationalFlag = country.NationalFlag;
context.Update(currentCountry);
}
await context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(country));
}
public CountryService(worldContext ctx)
{
context = ctx;
}
public CityController()
{
_contextCity = new worldContext();
}
public CityController(worldContext context)
{
_context = context;
}
public CityController(worldContext context)
{
_context = context;
_cityService = new CityService(context);
}
public CityService(worldContext ctx)
{
context = ctx;
}
public CountryController()
{
_context = new worldContext();
}
// GET: CityController
public ActionResult Index()
{
var context = new worldContext();
return(View(context.City.ToList()));
}
public CityRepository(worldContext context)
{
_context = context;
}
public CountrylanguageService(worldContext ctx)
{
context = ctx;
}
public CountryController(worldContext context)
{
_context = context;
}
public CountryController(worldContext db)
{
_db = db;
}