public void UpdateTable()
{
var contest = new Contest {
ContestId = 1011, ManagerId = 4002, ContestTypeId = 1, TimePeriodId = 1, WinnerId = 2026
};
var database = new DataBaseRepo();
var result = database.Update(contest);
Assert.Equal(ExecuteCodes.SuccessToExecute, result);
}
public Contest GetWinnerOfContest(Contest contest)
{
var result = 0;
var database = new DataBaseRepo();
var players = database
.GetAll(new ContestParticipants())
.Cast <ContestParticipants>()
.Where(p => contest.ContestId == p.ContestId)
.ToList();
var series = database
.GetAll(new Serie())
.Cast <Serie>()
.Where(s => contest.ContestId == s.ContestId)
.ToList();
var scores = database.GetAll(new Score())
.Cast <Score>()
.ToList();
var higherScore = 0;
var currentScore = 0;
foreach (var serie in series)
{
var listOfSerieIdsAndPartyIds = new Dictionary <int, int>();
if (players.FirstOrDefault(p => serie.PartyId == p.CompetitorId) != null)
{
listOfSerieIdsAndPartyIds.Add(serie.PartyId, serie.SerieId);
}
if (listOfSerieIdsAndPartyIds.Count != 0)
{
foreach (var item in listOfSerieIdsAndPartyIds)
{
var quantity = (Quantity)database.GetObject(scores.First(sco => item.Value == sco.SerieId).QuantityId.ToString(), new Quantity());
higherScore = quantity.Amount;
if (higherScore > currentScore)
{
currentScore = higherScore;
result = item.Key;
}
}
}
}
contest.WinnerId = result;
database.Update(contest);
return(contest);
}
