public IHttpActionResult Putbet(int id, bet bet) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != bet.sn) { return(BadRequest()); } db.Entry(bet).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!betExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Getbet(int id) { bet bet = db.bets.Find(id); if (bet == null) { return(NotFound()); } return(Ok(bet)); }
public IHttpActionResult Deletebet(int id) { bet bet = db.bets.Find(id); if (bet == null) { return(NotFound()); } db.bets.Remove(bet); db.SaveChanges(); return(Ok(bet)); }
public IHttpActionResult NabobbetsCreate(List <betDto> betlist) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var count = 0; var eqchoice = 0; foreach (var bet in betlist) { user u = db.users.Where(p => p.userID == bet.userId && p.comSn == bet.comSn).FirstOrDefault(); game g = db.games.Where(x => x.sn == bet.gameSn).FirstOrDefault(); topic tc = db.topics.Where(x => x.gameSn == bet.gameSn).FirstOrDefault(); if (u == null) { return(BadRequest("UserID不存在")); } bet.userSn = u.sn; bet.valid = 1; Mapper.Initialize(cfg => { cfg.CreateMap <betDto, bet>(); }); bet b = Mapper.Map <bet>(bet); choice cho = db.choices.Where(p => p.sn == b.choiceSn).FirstOrDefault(); b.Odds = cho.Odds; b.topicSn = cho.topicSn; db.bets.Add(b); db.SaveChanges(); //只有新模式才會新增 if (count == 0) { eqchoice = b.sn; } b.equalchoice = eqchoice; db.Entry(b).State = EntityState.Modified; db.SaveChanges(); count++; } return(Ok(betlist)); }
public IHttpActionResult Postbet(betDto bet) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } user u = db.users.Where(p => p.userID == bet.userId && p.comSn == bet.comSn).FirstOrDefault(); game g = db.games.Where(x => x.sn == bet.gameSn).FirstOrDefault(); topic dgontc = db.topics.Where(x => x.gameSn == bet.gameSn).FirstOrDefault(); topic tc = db.topics.Where(x => x.sn == bet.topicSn).FirstOrDefault(); List <bet> bettotal = db.bets.Where(p => p.topicSn == tc.sn).ToList(); //龍的傳人才新增 if (g.betModel == 5) { prizepoolRecord ppr = new prizepoolRecord(); ppr.unitSn = 1; ppr.userSn = u.sn; ppr.gameSn = bet.gameSn; ppr.topicSn = bet.topicSn; ppr.choiceSn = bet.choiceSn; ppr.assets = (double)bet.money * (double)dgontc.outlay / 100; ppr.type = 2; ppr.inpdate = DateTime.Now; db.prizepoolRecords.Add(ppr); db.SaveChanges(); } if (u == null) { return(BadRequest("UserID不存在")); } bet.userSn = u.sn; bet.valid = 1; Mapper.Initialize(cfg => { cfg.CreateMap <betDto, bet>(); }); bet b = Mapper.Map <bet>(bet); choice cho = db.choices.Where(p => p.sn == b.choiceSn).FirstOrDefault(); b.Odds = cho.Odds; b.topicSn = cho.topicSn; if (tc.walk == 1) { b.totalmoney = bettotal.Sum(x => x.money); b.totalmoney += bet.money; } db.bets.Add(b); db.SaveChanges(); //只有新模式才會新增 if (bet.betCount != null) { foreach (betCountDto bcd in bet.betCount) { //樂透模式才會新增 betCount bc = new betCount(); //只有在可下注單位的資料要存 //if (game.betUnit.Contains(cs.unitSn.ToString())) //{ bc.betSn = b.sn; bc.choiceStr = bcd.choiceStr; bc.choiceCount = bcd.choiceCount; bc.unitSn = 1; db.betCounts.Add(bc); db.SaveChanges(); //cs = new choiceStrRepository().setData(cs); //} } } return(CreatedAtRoute("DefaultApi", new { id = bet.sn }, bet)); }