public ActionResult Auction(double?newbid, int?Id) { var price = from m in db.Item_table select m; if (newbid == null) { return(View(price.ToList())); } else { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { Item_table f = (from data in db.Item_table where data.Id == Id select data).FirstOrDefault(); f.prod_cbid = (double)newbid; db.SaveChanges(); dbContextTransaction.Commit(); var upInfo = from m in db.Item_table select m; return(View(upInfo.ToList())); } catch (Exception /*ex*/) { return(View(price.ToList())); } } } }
public ActionResult Delete(int id) { Item_table item_table = db.Item_table.Find(id); db.Item_table.Remove(item_table); db.SaveChanges(); return(RedirectToAction("Auction")); }
public ActionResult Auction(int?newId, int?Id) { var price = from m in db.Item_table select m; if (Id == null) { return(View(price.ToList())); } else { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { Item_table f = (from data in db.Item_table where data.Id == Id select data).FirstOrDefault(); f.prod_active = 0; Item_table newact = null; do { newact = (from data in db.Item_table where data.Id == newId select data).FirstOrDefault(); newId++; } while (newact == null); newact.prod_active = 1; db.SaveChanges(); dbContextTransaction.Commit(); var upInfo = from m in db.Item_table select m; return(View(upInfo.ToList())); } catch (Exception /*ex*/) { return(View(price.ToList())); } } } }
public void AddBid(Item_table newbid) { bidprice = newbid.prod_cbid; this.Clients.All.onBidRecorded(bidprice); }