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();
}
