public ActionResult Inquiry(string sortOrder, string currentFilter, int?id, int?biddingID) { ViewBag.CurrentSort = sortOrder; //ViewBag.TypeSortParm = String.IsNullOrEmpty(sortOrder) ? "type_desc" : ""; ViewBag.ForSortParm = String.IsNullOrEmpty(sortOrder) ? "for_desc" : ""; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; ViewBag.CurrentFilter = currentFilter; var viewModel = new BiddingIndexData(); viewModel.Properties = db.Properties .Include(p => p.Address) .Include(p => p.Agent) //.OrderBy(p => p.Title) .Where(p => p.AllowBidding.ToString().Equals("Allowed") && p.Availability.ToString().Equals("Yes")); if (id != null) { ViewBag.PropertyID = id.Value; viewModel.Biddings = viewModel.Properties.Where( i => i.ID == id.Value).Single().Biddings; } if (biddingID != null) { ViewBag.BiddingID = biddingID.Value; viewModel.Bids = viewModel.Biddings.Where( x => x.ID == biddingID).Single().Bids; } switch (sortOrder) { //case "type_desc": // viewModel.Properties = viewModel.Properties.OrderByDescending(p => p.OfType); // break; case "for_desc": viewModel.Properties = viewModel.Properties.OrderByDescending(p => p.For); break; case "Date": viewModel.Properties = viewModel.Properties.OrderBy(p => p.PublishOn); break; case "date_desc": viewModel.Properties = viewModel.Properties.OrderByDescending(p => p.PublishOn); break; default: viewModel.Properties = viewModel.Properties.OrderBy(p => p.Title); break; } return(View(viewModel)); }
// GET: Biddings public async Task <ActionResult> Index(int?id) { var viewModel = new BiddingIndexData(); strCurrentUserId = User.Identity.GetUserId(); var biddings = db.Biddings.Include(b => b.Property).Where(b => b.Property.AgentID.Equals(strCurrentUserId)); viewModel.Biddings = await biddings.ToListAsync(); if (id != null) { ViewBag.BiddingID = id.Value; viewModel.Bids = viewModel.Biddings.Where( x => x.ID == id).Single().Bids; } return(View(viewModel)); }