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);
}
}
