// GET: ProductReference/Details/5
public ActionResult Details(int?id, int?page)
{
if (id.HasValue)
{
ProductReferences productReferences = db.ProductReferences.Find(id);
List <Products> productList = db.Products.Where(x => x.ProductSubGroups.ProductGroupID == productReferences.ProductGroupID && !db.Products.Where(y => y.ProductReferenceID != null).Any(y => y.ID == x.ID)).OrderBy(x => x.Name).ToList();
if (productReferences != null)
{
ProductReferenceViewModel productReferenceViewModel = new ProductReferenceViewModel
{
ProductReferences = productReferences,
ProductList = productList
};
ViewBag.Page = page.ToString();
return(View(productReferenceViewModel));
}
else
{
ViewBag.ErrorMessage = "Sorry we could not find the product reference";
return(View("Error"));
}
}
else
{
return(RedirectToAction("Index", "ProductReference"));
}
}
public ActionResult AddProduct(ProductReferenceViewModel productReferenceViewModel, FormCollection collection)
{
try
{
var userIdentity = User.Identity.Name;
var productReferenceID = collection.GetValues("ProductReferences.ID");
var currentPage = collection.GetValues("currentPage");
foreach (var productID in productReferenceViewModel.SelectedProducts)
{
Products currentProduct = db.Products.Find(productID);
currentProduct.ProductReferenceID = Convert.ToInt32(productReferenceID[0]);
currentProduct.LastModified = DateTime.Now;
currentProduct.LastModifiedBy = userIdentity;
db.SaveChanges();
}
return(new RedirectResult(Url.Action("Details", "ProductReference", new { id = productReferenceID[0], page = currentPage[0] })));
}
catch (Exception ex)
{
ViewBag.ErrorMessage = "An error occured, please check your data input and try again";
ViewBag.Exception = ex;
}
return(View("Error"));
}
