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()));
                    }
                }
            }
        }
示例#4
0
        public void AddBid(Item_table newbid)
        {
            bidprice = newbid.prod_cbid;

            this.Clients.All.onBidRecorded(bidprice);
        }