public ActionResult Edit(string CustomerID, string sortOrder, string currentFilter, string searchString, int?page, string PgeSize) { try // handle exogenous exceptions { try // log all exceptions { ViewBag.CurrentSort = sortOrder; ViewBag.CustomerID = CustomerID; BusinessLayer.Validation pge = new BusinessLayer.Validation(); List <SelectListItem> PgeSizes = pge.PageSize(); //Assigning generic list to ViewBag ViewBag.PgeSizeList = PgeSizes; if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; //CUSTOMERS TABLE MASTER BusinessModelLayer.Customers.CustomersMasterDetailModel pageModel = new BusinessModelLayer.Customers.CustomersMasterDetailModel(); CustomersBusinessModelLayers customersBusinessModelLayers = new CustomersBusinessModelLayers(); Customers.CustomersMasterDetailModel customersMasterDetailModel = new Customers.CustomersMasterDetailModel(); pageModel.Customers = customersBusinessModelLayers.GetAllCustomerss().FirstOrDefault(x => x.CustomerID == CustomerID); int pageSize = 10; if (PgeSize != null) { Int32.TryParse(PgeSize, out pageSize); } ViewBag.PgeSize = pageSize; int pageNumber = (page ?? 1); //ORDERS DETAIL BEGIN ViewBag.CustomerIDSortParm = String.IsNullOrEmpty(sortOrder) ? "CustomerID_desc" : ""; OrdersBusinessModelLayers ordersBusinessModelLayers = new OrdersBusinessModelLayers(); List <BusinessModelLayer.Vworders> orderss = ordersBusinessModelLayers.GetAllVworderss().FindAll(x => x.CustomerID == CustomerID).ToList(); if (!String.IsNullOrEmpty(searchString)) { orderss = orderss.Where(s => s.CustomerID == CustomerID && s.CustomerID.ToString().ToLower().Contains(searchString.ToLower())).ToList(); } switch (sortOrder) { case "CustomerID_desc": orderss = orderss.OrderByDescending(s => s.CustomerID).ToList(); break; default: // CustomerID ascending orderss = orderss.OrderBy(s => s.CustomerID).ToList(); break; } pageModel.OrdersVwDetl = orderss.ToPagedList(pageNumber, pageSize); //ORDERS DETAIL END return(View(pageModel)); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ViewResult List(string sortOrder, string currentFilter, string searchString, int?page, string PgeSize) { try // handle exogenous exceptions { try // log all exceptions { ViewBag.CurrentSort = sortOrder; ViewBag.CustomerIDSortParm = String.IsNullOrEmpty(sortOrder) ? "CustomerID_desc" : ""; BusinessLayer.Validation pge = new BusinessLayer.Validation(); List <SelectListItem> PgeSizes = pge.PageSize(); //Assigning generic list to ViewBag ViewBag.PgeSizeList = PgeSizes; if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; OrdersBusinessModelLayers ordersBusinessModelLayers = new OrdersBusinessModelLayers(); List <BusinessModelLayer.Vworders> vworderss = ordersBusinessModelLayers.GetAllVworderss(); if (!String.IsNullOrEmpty(searchString)) { vworderss = vworderss.Where(s => s.CustomerID.ToString().ToLower().Contains(searchString.ToLower())).ToList(); } switch (sortOrder) { case "CustomerID_desc": vworderss = vworderss.OrderByDescending(s => s.CustomerID).ToList(); break; //case "!!!": // vworderss = vworderss.OrderBy(s => s.!!!).ToList(); // break; //case "!!!_desc": // vworderss = vworderss.OrderByDescending(s => s.!!!).ToList(); // break; default: // CustomerID ascending vworderss = vworderss.OrderBy(s => s.CustomerID).ToList(); break; } int pageSize = 10; if (PgeSize != null) { Int32.TryParse(PgeSize, out pageSize); } ViewBag.PgeSize = pageSize; int pageNumber = (page ?? 1); return(View(vworderss.ToPagedList(pageNumber, pageSize))); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Edit_Post(ShippersSingle shippers, string sortOrder, string currentFilter, string searchString, int?page, string PgeSize) { try // handle exogenous exceptions { try // log all exceptions { ShippersBusinessModelLayers shippersBusinessModelLayers = new ShippersBusinessModelLayers(); if (ModelState.IsValid) { //mm shippersBusinessModelLayers.UpdateShippers(shippers); return(RedirectToAction("List")); } ViewBag.CurrentSort = sortOrder; ViewBag.ShipperID = shippers.ShipperID; BusinessLayer.Validation pge = new BusinessLayer.Validation(); List <SelectListItem> PgeSizes = pge.PageSize(); //Assigning generic list to ViewBag ViewBag.PgeSizeList = PgeSizes; if (searchString != null) { page = 1; } else { searchString = currentFilter; } ViewBag.CurrentFilter = searchString; //SHIPPERS TABLE MASTER BusinessModelLayer.Shippers.ShippersMasterDetailModel pageModel = new BusinessModelLayer.Shippers.ShippersMasterDetailModel { Shippers = shippersBusinessModelLayers.GetAllShipperss().Single(x => x.ShipperID == shippers.ShipperID) }; int pageSize = 10; if (PgeSize != null) { Int32.TryParse(PgeSize, out pageSize); } ViewBag.PgeSize = pageSize; int pageNumber = (page ?? 1); //ORDERS DETAIL BEGIN ViewBag.CustomerIDSortParm = String.IsNullOrEmpty(sortOrder) ? "CustomerID_desc" : ""; OrdersBusinessModelLayers ordersBusinessModelLayers = new OrdersBusinessModelLayers(); pageModel.OrdersVwDetl = ordersBusinessModelLayers.GetAllVworderss().FindAll(x => x.ShipVia == shippers.ShipperID).ToList().ToPagedList(pageNumber, pageSize); if (!String.IsNullOrEmpty(searchString)) { pageModel.OrdersVwDetl = pageModel.OrdersVwDetl.Where(s => s.CustomerID.ToString().ToLower().Contains(searchString.ToLower())).ToList().ToPagedList(pageNumber, pageSize); } switch (sortOrder) { case "CustomerID_desc": pageModel.OrdersVwDetl = pageModel.OrdersVwDetl.OrderByDescending(s => s.CustomerID).ToList().ToPagedList(pageNumber, pageSize); break; default: // CustomerID ascending pageModel.OrdersVwDetl = pageModel.OrdersVwDetl.OrderBy(s => s.CustomerID).ToList().ToPagedList(pageNumber, pageSize); break; } //ORDERS DETAIL END return(View(pageModel)); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }