Esempio n. 1
0
        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();
        }
Esempio n. 2
0
        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));
        }
Esempio n. 4
0
        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);
        }