public int ParticipateInAuctions(int auctionId, int UserId) { int result = 0; using (TransactionScope scope = new TransactionScope()) { using (QuiBidsEntities db = new QuiBidsEntities()) { #region AddToPrice_Auction var auction = db.Auction.Where(x => x.Id == auctionId).FirstOrDefault(); auction.Current_UserId = UserId; auction.Reserve_Price++;//moshakas shavad chand vahed add shavad auction.Auction_Time = TimeSpan.FromSeconds(auction.Close_Time); db.Entry(auction).State = System.Data.Entity.EntityState.Modified; var s = db.SaveChanges(); #endregion #region LowerBidOfUser var user = db.User.Where(x => x.Id == UserId).FirstOrDefault(); if (user != null) { if (user.RealBid != 0) { user.RealBid--; } //if (user.VoucherBid != 0) // user.VoucherBid--; db.Entry(user).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } #endregion #region AddLog AuctionLogs log = new AuctionLogs { AuctionId = auctionId, DateTime = DateTime.Now, TypeBid = 1,//EditType UserId = UserId, Price = auction.Reserve_Price }; db.AuctionLogs.Add(log); db.SaveChanges(); #endregion result = auction.Reserve_Price.Value; } scope.Complete(); } return(result); }
public void Insert(AuctionLogs model) { using (QuiBidsEntities db = new QuiBidsEntities()) { AuctionLogs auction = new AuctionLogs { AuctionId = model.AuctionId, DateTime = DateTime.Now, TypeBid = model.TypeBid, UserId = model.UserId, Price = model.Price }; db.AuctionLogs.Add(auction); db.SaveChanges(); } }
public ActionResult AddToAcuctionLog(int auctionId, byte type) { if (Session["Admin"] == null) { var user = (User)Session["Admin"]; var model = new AuctionLogs { AuctionId = auctionId, //TypeBid= UserId = user.Id }; _logRepo.Insert(model); return(View()); } else { return(RedirectToAction("Login", "Home")); } }