public ActionResult Edit(int ProductID, string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
CategoriesBusinessModelLayers categoriesLUBusinessModelLayers = new CategoriesBusinessModelLayers();
ViewBag.Categoriess = new SelectList(categoriesLUBusinessModelLayers.CategoriesSelect, "CategoryID", "CategoryName");
SuppliersBusinessModelLayers suppliersLUBusinessModelLayers = new SuppliersBusinessModelLayers();
ViewBag.Supplierss = new SelectList(suppliersLUBusinessModelLayers.SuppliersSelect, "SupplierID", "CompanyName");
ViewBag.CurrentSort = sortOrder;
ViewBag.ProductID = ProductID;
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;
//PRODUCTS TABLE MASTER
BusinessModelLayer.Products.ProductsMasterDetailModel pageModel = new BusinessModelLayer.Products.ProductsMasterDetailModel();
ProductsBusinessModelLayers productsBusinessModelLayers = new ProductsBusinessModelLayers();
Products.ProductsMasterDetailModel productsMasterDetailModel = new Products.ProductsMasterDetailModel();
pageModel.Products = productsBusinessModelLayers.GetAllProductss().FirstOrDefault(x => x.ProductID == ProductID);
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
//ORDER_DETAILS DETAIL BEGIN
ViewBag.ProductIDSortParm = String.IsNullOrEmpty(sortOrder) ? "ProductID_desc" : "";
Order_DetailsBusinessModelLayers order_detailsBusinessModelLayers = new Order_DetailsBusinessModelLayers();
List <BusinessModelLayer.Vworder_details> order_detailss = order_detailsBusinessModelLayers.GetAllVworder_detailss().FindAll(x => x.ProductID == ProductID).ToList();
if (!String.IsNullOrEmpty(searchString))
{
order_detailss = order_detailss.Where(s => s.ProductID == ProductID && s.ProductID.ToString().ToLower().Contains(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "ProductID_desc":
order_detailss = order_detailss.OrderByDescending(s => s.ProductID).ToList();
break;
default: // ProductID ascending
order_detailss = order_detailss.OrderBy(s => s.ProductID).ToList();
break;
}
pageModel.Order_DetailsVwDetl = order_detailss.ToPagedList(pageNumber, pageSize);
//ORDER_DETAILS DETAIL END
return(View(pageModel));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit_Post(ProductsSingle products, string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
ProductsBusinessModelLayers productsBusinessModelLayers = new ProductsBusinessModelLayers();
if (ModelState.IsValid)
{
//mm
productsBusinessModelLayers.UpdateProducts(products);
return(RedirectToAction("List"));
}
ViewBag.CurrentSort = sortOrder;
ViewBag.ProductID = products.ProductID;
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;
//PRODUCTS TABLE MASTER
BusinessModelLayer.Products.ProductsMasterDetailModel pageModel = new BusinessModelLayer.Products.ProductsMasterDetailModel
{
Products = productsBusinessModelLayers.GetAllProductss().Single(x => x.ProductID == products.ProductID)
};
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
//ORDER_DETAILS DETAIL BEGIN
ViewBag.OrderIDSortParm = String.IsNullOrEmpty(sortOrder) ? "OrderID_desc" : "";
Order_DetailsBusinessModelLayers order_detailsBusinessModelLayers = new Order_DetailsBusinessModelLayers();
pageModel.Order_DetailsVwDetl = order_detailsBusinessModelLayers.GetAllVworder_detailss().FindAll(x => x.ProductID == products.ProductID).ToList().ToPagedList(pageNumber, pageSize);
if (!String.IsNullOrEmpty(searchString))
{
pageModel.Order_DetailsVwDetl = pageModel.Order_DetailsVwDetl.Where(s => s.OrderID.ToString().ToLower().Contains(searchString.ToLower())).ToList().ToPagedList(pageNumber, pageSize);
}
switch (sortOrder)
{
case "OrderID_desc":
pageModel.Order_DetailsVwDetl = pageModel.Order_DetailsVwDetl.OrderByDescending(s => s.OrderID).ToList().ToPagedList(pageNumber, pageSize);
break;
default: // OrderID ascending
pageModel.Order_DetailsVwDetl = pageModel.Order_DetailsVwDetl.OrderBy(s => s.OrderID).ToList().ToPagedList(pageNumber, pageSize);
break;
}
//ORDER_DETAILS DETAIL END
return(View(pageModel));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
