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;
}
}
