public ActionResult AddCountry(int id) { AddCountryVM model = new AddCountryVM { Year = id }; model.Countries = new SelectList(db.GetAllCountries(), "id", "Name"); return(View(model)); }
public ActionResult AddCountry(AddCountryVM model) { try { db.AddCountryToEvent(model); return(RedirectToAction("EventDetails", new { id = model.Year })); } catch { model.Countries = new SelectList(db.GetAllCountries(), "id", "Name"); return(View(model)); } }
void SourceRepository.AddCountryToEvent(AddCountryVM acvm) { int newSequence = 1; var exist = db.EventCountries.Where(x => x.EventID == acvm.Year); if (exist != null && exist.Count() > 0) { newSequence = exist.Max(x => x.Sequence) + 1; } EventCountry newCC = new EventCountry { CountryID = acvm.CountryID, EventID = acvm.Year, Sequence = newSequence }; db.Entry(newCC).State = EntityState.Added; db.SaveChanges(); }