private void TallyStats() { var pList = PlayerList.GetAll(); foreach (var plyr in pList) { var player = new NFLPlayer(plyr.Id); var scorecard = new ScoreCard { Player = player }; var season = PgmDao.GetSeason( Season, player.PlayerCode); if (Week == "00") { TallyPreviousActuals( scorecard, player); } TallyPredictions( scorecard, player, season); if (Int32.Parse(Week) > 0) { TallyActuals(scorecard, player, season); } ScoreCards.Add(scorecard); } }
private string GenerateBody() { var compareByPts = new Comparison <ScoreCard>( CompareByTotalPoints); ScoreCards.Sort(compareByPts); var pList = PlayerList.GetAll(); var sb = new StringBuilder(); AppendHeader(sb); foreach (var card in ScoreCards) { var player = card.Player; var season = PgmDao.GetSeason( Season, player.PlayerCode); GeneratePredictions( sb, player, season); if (Week == "00") { OutputPriors( sb, card); } if (Int32.Parse(Week) > 0) { GenerateActuals(sb, player, season); VarianceLine(sb, player, season); } sb.AppendLine(); } OutputTotalPredictions(sb); if (Week == "00") { OutputPriors( sb, TotalScoreCard); } return(sb.ToString()); }
public IHttpActionResult IndividualAddScoreCard([FromUri] string id, ScoreCards model) { try { if (!ModelState.IsValid) { var modelErrors = new List <string>(); foreach (var modelState in ModelState.Values) { foreach (var modelError in modelState.Errors) { modelErrors.Add(modelError.ErrorMessage); } } return(Content(HttpStatusCode.BadRequest, MessageResponse.Message(HttpStatusCode.BadRequest.ToString(), modelErrors[0].ToString()), new JsonMediaTypeFormatter())); } ScoreCards addNewScoreCard = new ScoreCards(); addNewScoreCard.Date = model.Date; addNewScoreCard.Braking = model.Braking; addNewScoreCard.Accel = model.Accel; addNewScoreCard.Turning = model.Turning; addNewScoreCard.Idling = model.Idling; addNewScoreCard.TenKmPerHrOver = model.TenKmPerHrOver; addNewScoreCard.TwentyKmPerHrOver = model.TwentyKmPerHrOver; addNewScoreCard.ThirtyKmPerHrOver = model.ThirtyKmPerHrOver; addNewScoreCard.PointsDeducted = model.PointsDeducted; addNewScoreCard.Points = model.Points; addNewScoreCard.Percentage = model.Percentage; // add scoreCard code string query = @"UPDATE " + _bucket.Name + " SET scoreCards = ARRAY_APPEND(scoreCards, " + Newtonsoft.Json.JsonConvert.SerializeObject(addNewScoreCard).ToString() + ") where meta().id='" + id + "'"; var result = _bucket.Query <object>(query); return(Content(HttpStatusCode.OK, MessageResponse.Message(HttpStatusCode.OK.ToString(), "Score card has been added sucessfully"), new JsonMediaTypeFormatter())); } catch (Exception ex) { return(Content(HttpStatusCode.InternalServerError, MessageResponse.Message(HttpStatusCode.InternalServerError.ToString(), ex.StackTrace), new JsonMediaTypeFormatter())); } }