Exception SourceRepository.SetWinners(EventWinnerVM model)
{
try
{
//get the event
Event e = db.Events.Find(model.Event.Year);
//create euro winner
EventCountry EW_EC = db.EventCountries.Find(model.EventCountryEuroWinner);
e.EurovisionWinner = new EurovisionWinner {
Year = model.Event.Year, CountryID = EW_EC.CountryID, Player = EW_EC.OwningPlayer
};
//create home champ
EventCountry HC_EC = db.EventCountries.Find(model.EventCountryHomeChamp);
e.HomeChampion = new HomeChampion {
Year = model.Event.Year, CountryID = HC_EC.CountryID, Player = HC_EC.OwningPlayer
};
db.Entry(e).State = EntityState.Modified;
db.SaveChanges();
return(null);
}
catch (Exception ex)
{
return(ex);
}
}
public void AllocateCountryToPlayer(int id, Guid p)
{
EventCountry EC = db.EventCountries.Find(id);
EC.OwningPlayer = p;
db.Entry(EC).State = EntityState.Modified;
db.SaveChanges();
}
public ActionResult AssignPlayer(int id)
{
EventCountry EC = db.GetEventCountry(id);
AssignPlayerVM model = new AssignPlayerVM
{
EventCountry = EC,
Players = new SelectList(db.GetPlayersForYear(EC.Event.Year), "PlayerGuid", "Name")
};
return(View(model));
}
public ActionResult AssignPlayer(AssignPlayerVM model)
{
EventCountry EC = db.GetEventCountry(model.EventCountry.id);
try
{
db.AllocateCountryToPlayer(model.EventCountry.id, model.PlayerGuid);
return(RedirectToAction("EventDetails", new { id = EC.Event.Year }));
}
catch (Exception ex)
{
model.EventCountry = EC;
model.Players = new SelectList(db.GetPlayersForYear(model.EventCountry.Event.Year), "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();
}
