public void AddManualUserPick(UserPick pick) { PowerballPicks manualPick = new PowerballPicks() { ball1 = pick.ball1, ball2 = pick.ball2, ball3 = pick.ball3, ball4 = pick.ball4, ball5 = pick.ball5, powerball = pick.lottoball, pick_date = DateTime.Now, powerplay = "0X", isPicked = true }; var existingPick = this._ctx.PowerPicks.FirstOrDefault( x => x.ball1 == manualPick.ball1 && x.ball2 == manualPick.ball2 && x.ball3 == manualPick.ball3 && x.ball4 == manualPick.ball4 && x.ball5 == manualPick.ball5 && x.powerball == manualPick.powerball); if (existingPick == null) { this._ctx.PowerPicks.Add(manualPick); if (_ctx.SaveChanges() >= 0) { pick.pick_id = manualPick.id; pick.saved_date = DateTime.Now; this._ctx.UserPicks.Add(pick); } } }
public IEnumerable <PowerPicksViewModel> GetPowerballPicks() { try { using (IDbConnection dbConnection = sqlConnection) { dbConnection.Open(); var picks = dbConnection.QueryMultiple("dbo.GetPowerballPicks", commandType: CommandType.StoredProcedure); var results = picks.Read <PowerPicksViewModel>().ToList(); foreach (var pick in results) { PowerballPicks newPick = new PowerballPicks() { ball1 = pick.ball1, ball2 = pick.ball2, ball3 = pick.ball3, ball4 = pick.ball4, ball5 = pick.ball5, powerball = pick.powerball, powerplay = pick.powerplay, pick_date = DateTime.Now }; var existingPick = this._ctx.PowerPicks.FirstOrDefault( x => x.ball1 == newPick.ball1 && x.ball2 == newPick.ball2 && x.ball3 == newPick.ball3 && x.ball4 == newPick.ball4 && x.ball5 == newPick.ball5 && x.powerball == newPick.powerball); if (existingPick == null) { _ctx.PowerPicks.Add(newPick); } } //var predictedPick = PredictPowerball(); //var extraPick = new PowerballPicks //{ // ball1 = predictedPick.Ball1.ToString().PadLeft(2, '0'), // ball2 = predictedPick.Ball2.ToString().PadLeft(2, '0'), // ball3 = predictedPick.Ball3.ToString().PadLeft(2, '0'), // ball4 = predictedPick.Ball4.ToString().PadLeft(2, '0'), // ball5 = predictedPick.Ball5.ToString().PadLeft(2, '0'), // powerball = predictedPick.PowerBall.ToString().PadLeft(2, '0'), // powerplay = "0X", // pick_date = DateTime.Now //}; //var resultView = new PowerPicksViewModel //{ // ball1 = extraPick.ball1, // ball2 = extraPick.ball2, // ball3 = extraPick.ball3, // ball4 = extraPick.ball4, // ball5 = extraPick.ball5, // powerball = extraPick.powerball, // powerplay = extraPick.powerplay //}; //_ctx.PowerPicks.Add(extraPick); //results.Add(resultView); this.CleanUpPowerPicks(); SaveAll(); return(results); } } catch (Exception e) { _logger.LogError($"Failed to get Powerball Picks: {e}"); return(null); } }