public ActionResult Cities()
{
using (ZavrsniEFentities db = new ZavrsniEFentities())
{
var allCities = (from c in db.City
orderby c.CityName
select c).Include(c => c.Country).ToList();
var availableCountries = (from c in db.Country
orderby c.CountryName
select c).ToList();
var locTypes = (from l in db.LocationType
orderby l.Name
select l).ToList();
var model = new CityCountryListModel()
{
Cities = allCities,
LocationType = new SelectList(locTypes, "ID", "Name")
};
model.Country = new SelectList(availableCountries, "ID", "CountryName");
return(View(model));
}
}
public async Task <ActionResult> Cities(CityCountryListModel model)
{
using (ZavrsniEFentities db = new ZavrsniEFentities())
{
if (model.CountryName != null && model.CityName == null && Request["CountryDropDown"] == null && Request["LocationTypeDropDown"] == null)
{
var newCountry = db.Country.Create();
newCountry.CountryName = model.CountryName;
db.Country.Add(newCountry);
db.SaveChanges();
return(RedirectToAction("Cities", "Home"));
}
if (model.CountryName == null && model.CityName != null && Request["LocationTypeDropDown"] != null && Request["CountryDropDown"] != null)
{
var newCity = db.City.Create();
newCity.CityName = model.CityName;
var countrySel = Request["CountryDropDown"];
newCity.IDcountry = Convert.ToInt32(countrySel);
db.City.Add(newCity);
db.SaveChanges();
var newLocation = db.Location.Create();
newLocation.IDcity = newCity.IDcity;
var locTypeSel = Request["LocationTypeDropDown"];
newLocation.IDlocationType = Convert.ToInt32(locTypeSel);
db.Location.Add(newLocation);
db.SaveChanges();
return(RedirectToAction("Cities", "Home"));
}
}
return(RedirectToAction("Cities", "Home"));
}
