public ActionResult Display(int id) { bool hasBidsFromDb; using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString)) { hasBidsFromDb = db.Query <Auction>("SELECT HasBids FROM Auctions WHERE Id ='" + id + "'").ToList().First().HasBids; } if (hasBidsFromDb == false) { var viewModel = new BidFormViewModel { Auction = _context.Auctions.Include(u => u.User).SingleOrDefault(a => a.Id == id), HighestBid = 0 }; return(View(viewModel)); } else { var viewModel = new BidFormViewModel { Auction = _context.Auctions.SingleOrDefault(a => a.Id == id), HighestBid = _context.Bids.Where(a => a.AuctionId == id).Max(a => a.Amount) }; return(View(viewModel)); } }
public ActionResult Create(BidFormViewModel viewModel) { // if (!ModelState.IsValid) // { // return RedirectToAction("Create", viewModel); // } var bid = new Bid() { UserId = User.Identity.GetUserId(), AuctionId = viewModel.Auction.Id, Amount = viewModel.Amount }; var result = _context.Auctions.SingleOrDefault(a => a.Id == viewModel.Auction.Id); if (result != null) { result.HasBids = true; } _context.Bids.Add(bid); _context.SaveChanges(); return(RedirectToAction("MyBids", "Bids")); }