public ActionResult Default()
{
Setup();
dbEvent currentEvent = _eventManager.GetCurrentEvent();
return(Index(currentEvent.Name, currentEvent.CurrentRound));
}
public void Update(dbEvent e)
{
var sqlUpdate = $"UPDATE Events SET Name='{e.Name}', CurrentRound={e.CurrentRound}, Rounds={e.Rounds}, RoundMatches={e.RoundMatches}, Locked={Convert.ToInt32(e.Locked)}, StartDate='{e.StartDate}', RoundEndDate='{e.RoundEndDate}' WHERE Name='{e.dbName}'";
try
{
_dataContext.ExecuteCommand(sqlUpdate);
e.dbName = e.Name;
}
catch (Exception)
{
throw;
}
}
public void Create(dbEvent e)
{
var sqlCreate = "INSERT INTO Events (Name, CurrentRound, Rounds, RoundMatches, Locked, StartDate, RoundEndDate)";
var sqlValues = $"VALUES ('{e.Name}', {e.CurrentRound}, {e.Rounds}, {e.RoundMatches}, {Convert.ToInt32(e.Locked)}, '{e.StartDate}', '{e.RoundEndDate}')";
var fullSql = sqlCreate + sqlValues;
try
{
_dataContext.ExecuteCommand(fullSql);
e.dbName = e.Name;
}
catch (Exception)
{
throw;
}
}
public Trigger After(dbEvent ev)
{
this._event = ev;
this.before = false;
return(this);
}
public Trigger Before(dbEvent ev)
{
this._event = ev;
this.before = true;
return(this);
}
public void PopulateEvent(Event pop, dbEvent loadedEvent)
{
pop.name = loadedEvent.Name;
pop.myDbEvent = loadedEvent;
pop.rounds = loadedEvent.Rounds;
pop.CurrentRound = loadedEvent.CurrentRound;
pop.RoundMatches = loadedEvent.RoundMatches;
pop.EventStartDate = loadedEvent.StartDate;
pop.RoundEndDate = loadedEvent.RoundEndDate;
var eventPlayers = _eventPlayerRepository.LoadDBEventPlayers(loadedEvent.Name);
pop.RoundPrizes = _roundPrizeRepository.LoadDBRoundPrizes(loadedEvent.Name);
//LoadPlayers
pop.Players = new List <Player>();
_playerRepository.LoadDBPlayers().Where(p => eventPlayers.Any(ep => ep.PlayerID == p.ID)).ToList().ForEach(p => pop.Players.Add(new Player(p.Name, p.Email, p.ID)));
//LoadEventPlayers
eventPlayers.Where(ep => ep.Dropped > 0).ToList().ForEach(ep =>
{
foreach (var p in pop.Players)
{
if (p.ID == ep.PlayerID)
{
p.DroppedInRound = ep.Dropped;
}
}
});
//LoadMatches
pop.Matches = new List <Match>();
_matchRepository.LoadDBMatches(pop.name).Where(m => m.Event == loadedEvent.Name).ToList().ForEach(m => pop.Matches.Add(m));
foreach (Match m in pop.Matches)
{
_matchRepository.PopulateMatch(pop.Players, m);
}
foreach (var match in pop.Matches)
{
if (String.IsNullOrEmpty((match.Player1.Name)))
{
throw new Exception();
}
if (String.IsNullOrEmpty((match.Player2.Name)))
{
throw new Exception();
}
}
foreach (var p in pop.Players)
{
foreach (var m in pop.Matches)
{
if (m.Player1ID == p.ID)
{
m.Player1 = p;
p.Matches.Add(m);
}
else if (m.Player2ID == p.ID)
{
m.Player2 = p;
p.Matches.Add(m);
}
}
}
}
