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