public ActionResult Store(StockSort stockSort) { if (TempData.ContainsKey("SuccessMessage")) { ViewBag.successMessage = TempData["SuccessMessage"].ToString(); } if (TempData.ContainsKey("lessQuantityMessage")) { ViewBag.LessQuantityMessage = TempData["lessQuantityMessage"].ToString(); } string sort = sortMain; if (sort == null || sort == "") { sort = "Name Ascending"; } Stock stock = new Stock(); //stock.sortValue(sort); sortMain = ""; return(View(stock.sortValue(sort))); //var stocks = db.Stocks.Include(s => s.CropInfo).Include(y=>y.StocksImage); //return View(stocks.ToList()); //List<StockViewModel> searchStockList = new List<StockViewModel>(); //var mergedList = (from c in db.CropInfoes // join x in db.Stocks // on c.CropID equals x.CropID // join y in db.StocksImages // on x.StockID equals y.StockID // orderby c.Name ascending // select new // { // x.StockID, // c.CropID, // c.Name, // x.CurQuantity, // x.Expiery, // x.Price, // y.StockImage // }).ToList(); //if (mergedList.Count() > 0) //{ // foreach (var item in mergedList) // { // StockViewModel stk = new StockViewModel(); // stk.StockID = item.StockID; // stk.CropID = item.CropID; // stk.CropName = item.Name; // stk.CurQuantity = item.CurQuantity; // stk.Expiery = item.Expiery; // stk.StockImage = item.StockImage; // searchStockList.Add(stk); // } //} }
public ActionResult StockSort(StockSort stockSort) { if (stockSort.SortBy != null) { sortMain = stockSort.SortBy.ToString(); return(RedirectToAction("Store")); } else { return(PartialView()); } //StocksController sc = new StocksController(); //sc.Store(sort); }