public ActionResult Create(ProductReferences productReferences)
{
ViewBag.ProductGroupID = new SelectList(db.ProductGroups, "ID", "Name");
try
{
var userIdentity = User.Identity.Name;
DateTime now = DateTime.Now;
productReferences.Created = now;
productReferences.CreatedBy = userIdentity;
productReferences.LastModified = now;
productReferences.LastModifiedBy = userIdentity;
db.ProductReferences.Add(productReferences);
db.SaveChanges();
ViewBag.Message = "success";
ViewBag.ProductReferenceID = productReferences.ID;
return(View());
}
catch (Exception ex)
{
ViewBag.Exception = ex;
ViewBag.ErrorMessage = "An error occured, please check your data input and try again";
return(View("Error"));
}
}
// 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"));
}
}
// GET: ProductReference/Delete/5
public ActionResult Delete(int id)
{
ProductReferences productReferences = db.ProductReferences.Find(id);
try
{
db.ProductReferences.Remove(productReferences);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewBag.ErrorMessage = "An error occured, please check your data input and try again";
ViewBag.Exception = ex;
}
return(View("Error"));
}
public ActionResult Edit(int id, ProductReferences productReferences, FormCollection collection)
{
var userIdentity = User.Identity.Name;
ProductReferences currentProductReference = db.ProductReferences.Find(id);
var currentPage = collection.GetValues("currentPage");
ViewBag.ProductGroupID = new SelectList(db.ProductGroups, "ID", "Name", currentProductReference.ProductGroupID);
ViewBag.ProductReferenceID = currentProductReference.ID.ToString();
ViewBag.CurrentPage = currentPage[0];
ViewBag.HaveProduct = currentProductReference.Products.Count() > 0 ? "1" : "0";
try
{
currentProductReference.Name = productReferences.Name;
currentProductReference.ProductGroupID = currentProductReference.Products.Count == 0 ? productReferences.ProductGroupID : currentProductReference.ProductGroupID;
currentProductReference.MHPBIH = productReferences.MHPBIH;
currentProductReference.MHPBOH = productReferences.MHPBOH;
currentProductReference.MHFabIH = productReferences.MHFabIH;
currentProductReference.MHFabOH = productReferences.MHFabOH;
currentProductReference.MHPaintingIH = productReferences.MHPaintingIH;
currentProductReference.MHPaintingOH = productReferences.MHPaintingOH;
currentProductReference.Factor = productReferences.Factor;
currentProductReference.IsOperatorOr = productReferences.IsOperatorOr;
currentProductReference.LastModified = DateTime.Now;
currentProductReference.LastModifiedBy = userIdentity;
db.SaveChanges();
ViewBag.Message = "Success";
return(View(currentProductReference));
}
catch (Exception ex)
{
ViewBag.ErrorMessage = "An error occured, please check your data input and try again";
ViewBag.Exception = ex;
return(View("Error"));
}
}
// GET: ProductReference/Edit/5
public ActionResult Edit(int?id, int?page)
{
if (id.HasValue)
{
ProductReferences productReferences = db.ProductReferences.Find(id);
if (productReferences != null)
{
ViewBag.ProductGroupID = new SelectList(db.ProductGroups, "ID", "Name", productReferences.ProductGroupID);
ViewBag.HaveProduct = productReferences.Products.Count() > 0 ? "1" : "0";
ViewBag.Page = page.ToString();
return(View(productReferences));
}
else
{
ViewBag.ErrorMessage = "Sorry we could not find the product reference";
return(View("Error"));
}
}
else
{
return(RedirectToAction("Index", "ProductReference"));
}
}
