public ActionResult OrderHistory(int?id) { List <vProductOrder> payment = new List <vProductOrder>(); try { payment = BGBCFunctions.ProductOrders().Where(x => x.UserID == ((BGBC.Core.CustomPrincipal)(User)).UserId).OrderByDescending(o => o.TransDate).ToList(); } catch (Exception ex) { log.Error(ex.Message); } return(View(payment)); }
public ActionResult ViewOrders(int id) { return(View(BGBCFunctions.ProductOrders().Where(x => x.ProductID == id).OrderByDescending(s => s.TransDate).ToList())); }
public ActionResult AllProductsOrders(int?id, string sortOrder, string currentFilter, string searchString, int?page, string PageSize) { if (id != null) { Product product = _product.Get(id); ViewBag.Name = product.Name; } int currentPageSize = int.Parse(PageSize == null ? "10" : PageSize), pageNumber = (page ?? 1); try { var products = (id == null ? BGBCFunctions.ProductOrders() : BGBCFunctions.ProductOrders().Where(x => x.ProductID == id)); ViewBag.CurrentSort = sortOrder; ViewBag.DateSortParm = sortOrder == "Date" ? "date_desc" : "Date"; ViewBag.TransIDSortParm = sortOrder == "TransID" ? "TransID_desc" : "TransID"; ViewBag.CustomerSortParm = sortOrder == "Customer" ? "Customer_desc" : "Customer"; ViewBag.TypeSortParm = sortOrder == "Type" ? "Type_desc" : "Type"; ViewBag.PriceSortParm = sortOrder == "Price" ? "Price_desc" : "Price"; ViewBag.NameSortParm = sortOrder == "Name" ? "name_desc" : "Name"; ViewBag.CommentsSortParm = sortOrder == "Comments" ? "comments_desc" : "Comments"; if (PageSize != null) { ViewBag.currentPageSize = currentPageSize; } if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; ViewBag.page = pageNumber; if (!string.IsNullOrEmpty(searchString)) { products = products.Where(x => x.CustomerFName.Contains(searchString) || x.CustomerLName.Contains(searchString) || x.Name.Contains(searchString) || x.TransId.Contains(searchString)); } switch (sortOrder) { case "date_desc": products = products.OrderByDescending(x => x.TransDate); break; case "TransID": products = products.OrderBy(x => x.TransId); break; case "TransID_desc": products = products.OrderByDescending(x => x.TransId); break; case "Customer": products = products.OrderBy(x => x.CustomerFName); break; case "Customer_desc": products = products.OrderByDescending(x => x.CustomerFName); break; case "Type": products = products.OrderBy(x => x.UserType); break; case "Type_desc": products = products.OrderByDescending(x => x.UserType); break; case "Name": products = products.OrderBy(x => x.Name); break; case "name_desc": products = products.OrderByDescending(x => x.Name); break; case "Price": products = products.OrderBy(x => x.Price); break; case "Price_desc": products = products.OrderByDescending(x => x.Price); break; case "Comments": products = products.OrderBy(x => x.Comments); break; case "comments_desc": products = products.OrderByDescending(x => x.Comments); break; default: // Date ascending products = products.OrderBy(x => x.TransDate); break; } return(View(products.ToPagedList(pageNumber, currentPageSize))); } catch (Exception ex) { log.Error(ex.Message); } return(View()); }