public ActionResult Create(userTable u)
{
using (ac)
{
ac.userTables.Add(u);
ac.SaveChanges();
return(RedirectToAction("Login"));
}
}
public static void AddUser(User user)
{
using (AuctionEntities au = new AuctionEntities())
{
if (user.Id == 0)
{
au.Users.Add(user);
}
else
{
User dbUser = au.Users.Find(user.Id);
if (dbUser != null)
{
dbUser.IdRole = user.IdRole;
dbUser.Login = user.Login;
dbUser.Password = user.Password;
dbUser.Email = user.Email;
dbUser.Phone = user.Phone;
dbUser.Name = user.Name;
dbUser.Address = user.Address;
}
}
au.SaveChanges();
}
}
private void NotifyAuctionEnd(Guid itemId)
{
var context = new AuctionEntities();
var item = context.Items.Find(itemId);
item.IsAvailable = false;
if (item.BuyerId != null)
{
var sellerEmail = context.Accounts.Find(item.SellerId).Email;
context.Notifications.Add(new Notification
{
Id = Guid.NewGuid(),
Message = "Auction has been finished, you've purchased the product!\nPlease contact seller via email: " + sellerEmail,
ReceiverId = item.BuyerId.Value
});
}
context.Notifications.Add(new Notification
{
Id = Guid.NewGuid(),
Message = "Auction has been finished!\nPlease contact buyer via email: " + item.BuyerAccount.Email,
ReceiverId = item.SellerId
});
context.SaveChanges();
}
public ActionResult BidFromSearch(productTable upd)
{
//upd.biddedPrice = 69;
//ViewBag.shohan = new SelectList(acForBid.productTables, "productID", "basePrice");
searchProduct.Entry(upd).State = EntityState.Modified;
searchProduct.SaveChanges();
return(RedirectToAction("ShowBidListForUser", "Product"));
}
public ActionResult uploadProduct(productTable pt)
{
using (acForproduct)
{
acForproduct.productTables.Add(pt);
acForproduct.SaveChanges();
return(RedirectToAction("ShowListForUser"));
//return RedirectToAction("PORE KORBO");
}
}
public ActionResult updateBid(productTable upd)
{
//upd.biddedPrice = 69;
//ViewBag.shohan = new SelectList(acForBid.productTables, "productID", "basePrice");
acForBid.Entry(upd).State = EntityState.Modified;
acForBid.SaveChanges();
//return returnre("availableProducts");
//return RedirectToAction("~/Bid/availableProducts");
//return View("availableProducts");
return(RedirectToAction("ShowBidListForUser", "Product"));
}
public static void AddSection(Section section)
{
using (AuctionEntities au = new AuctionEntities())
{
if (section.Id == 0)
{
au.Sections.Add(section);
}
else
{
Section dbSection = au.Sections.Find(section.Id);
if (dbSection != null)
{
dbSection.NameSection = section.NameSection;
}
}
au.SaveChanges();
}
}
public static void UpdateLotsStatus()
{
using (AuctionEntities au = new AuctionEntities())
{
IEnumerable<Lot> lots = au.Lots
.Where(l => l.EndDate <= DateTime.Now && l.Status != false).ToList();
if (lots.Any())
{
foreach (Lot lot in lots)
{
lot.Status = false;
AddLot(lot, au);
}
}
IEnumerable<UserLot> userLots = au.UserLots
.Where(ul => ul.Lot.Status == false).ToList();
if (userLots.Any())
{
foreach (UserLot userLot in userLots)
{
if (userLot.idStatus == 1)
{
userLot.idStatus = 4;
AddUserLot(userLot, au);
}
if (userLot.idStatus == 2)
{
userLot.idStatus = 5;
AddUserLot(userLot, au);
}
}
}
au.SaveChanges();
}
}
public void CreateAuction(Data.Auction auction)
{
_auctionEntities.Auctions.Add(auction);
_auctionEntities.SaveChanges();
}
