public ActionResult Search([Bind(Include = "Name,minprice,highprice,status,page")] AuctionViewModelForm auction)
{
logger.Info("GET/Auction/Search action has been called");
var auctions = from Auction in myDB.Auctions select Auction;
if (auction.Name != null && auction.Name != "")
{
auctions = auctions.Where(x => x.Name.Contains(auction.Name));
}
if (auction.minprice != null)
{
auctions = auctions.Where(x => x.currentPrice >= auction.minprice);
}
if (auction.highprice != null)
{
auctions = auctions.Where(x => x.currentPrice <= auction.highprice);
}
if (auction.status != null && auction.status != "")
{
auctions = auctions.Where(x => x.State.Equals(auction.status));
}
int pageSize = myDB.SystemParameters.First().ItemsPerPage;
int pageNumber = (auction.page ?? 1);
auction.Auctions = auctions.OrderByDescending(x => x.createdOn).ToPagedList(pageNumber, pageSize);
return(View("Index", auction));
}
public ActionResult Index([Bind(Include = "Name, LowPrice, HighPrice,List,Page")] AuctionViewModelForm auctionViewModel)
{
ViewBag.CurrentFilter = auctionViewModel;
var auctions = dbcontext.Auction.OrderByDescending(x => x.CreatedOn).ToList();
if (auctionViewModel.Name != null)
{
auctions = auctions.Where(x => x.Name.Contains(auctionViewModel.Name)).ToList();
}
if (auctionViewModel.LowPrice != null)
{
auctions = auctions.Where(s => s.CurrentPrice != null && s.StartPrice >= auctionViewModel.LowPrice).ToList();
}
if (auctionViewModel.HighPrice != null)
{
auctions = auctions.Where(s => s.CurrentPrice != null && s.StartPrice <= auctionViewModel.HighPrice).ToList();
}
if (!String.IsNullOrEmpty(auctionViewModel.List))
{
auctions = auctions.Where(s => s.Status == auctionViewModel.List).ToList();
}
int pageSize = dbcontext.SystemParameter.FirstOrDefault().DefaultNumPageAuctions;
int pageNumber = (auctionViewModel.Page ?? 1);
auctionViewModel.Auctions = auctions.ToPagedList(pageNumber, pageSize);
log.Info("Search Name : " + auctionViewModel.Name + " Status : " + auctionViewModel.List);
return(View(auctionViewModel));
}
// GET: Auction
public ActionResult Index(AuctionViewModelForm auction)
{
logger.Info("GET/Auction/Index action has been called");
var auctions = from Auction in myDB.Auctions select Auction;
int pageSize = myDB.SystemParameters.First().ItemsPerPage;
int pageNumber = (auction.page ?? 1);
ViewBag.Page = "Index";
auction.Auctions = auctions.OrderByDescending(x => x.createdOn).ToPagedList(pageNumber, pageSize);
return(View(auction));
}
