public void InsertUserPrediction(MatchP mp, int bs1, int bs2, int bs3, int w1, int w2, int w3) { UserPrediction up = new UserPrediction(); up.MatchId = mp.MatchId; up.Username = mp.Username; up.Win = mp.Win; up.Hero1 = mp.Hero1; up.Hero2 = mp.Hero2; up.Hero3 = mp.Hero3; up.Hero4 = mp.Hero4; up.Hero5 = mp.Hero5; up.Hero6 = mp.Hero6; up.Hero7 = mp.Hero7; up.Hero8 = mp.Hero8; up.Hero9 = mp.Hero9; up.Hero10 = mp.Hero10; up.RadientScore = Convert.ToInt32(mp.RadientScore); up.DireScore = Convert.ToInt32(mp.DireScore); up.S1_Bet_Won = bs1.ToString() + "-" + w1.ToString(); up.S2_Bet_Won = bs2.ToString() + "-" + w2.ToString(); up.S3_Bet_Won = bs3.ToString() + "-" + w3.ToString(); cntx.UserPredictions.InsertOnSubmit(up); cntx.SubmitChanges(); }
public void DeleteUserPrediction(string x, int y) { var str = from a in cntx.UserPredictions where a.Username == x && a.MatchId == y select a; UserPrediction up = str.First(); cntx.UserPredictions.DeleteOnSubmit(up); cntx.SubmitChanges(); }
public async Task <IActionResult> PostUserPrediction([FromBody] UserPrediction userPrediction) { userPrediction.CreationDate = DateTime.Now; userPrediction.UserId = userId; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.UserPredictions.Add(userPrediction); await _context.SaveChangesAsync(); return(CreatedAtAction("GetUserPrediction", new { id = userPrediction.Id }, userPrediction)); }
public void Add(UserPredictionModel viewModel) { var lst = new UserPrediction { MatchID = viewModel.MatchID, Score = viewModel.Score, ScoreTitleID = viewModel.ScoreTitleID, PUserID = viewModel.UserID, Point = 0, PredictionTime = DateTime.Now, TournamentID = viewModel.TournamentID }; _userPrediction.Add(lst); }