public ActionResult Edit(int id)
{
//Get Item From Database
OptionalFieldItem optionalFieldItem = new OptionalFieldItem();
optionalFieldItem = optionalFieldItemRepository.GetItem(id);
//Check Exists
if (optionalFieldItem == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToOptionalFieldGroup(optionalFieldItem.OptionalFieldGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
OptionalFieldItemVM optionalFieldItemVM = new OptionalFieldItemVM();
optionalFieldItemVM.OptionalFieldItem = optionalFieldItem;
//Get Optional Fields
SelectList optionalFields = new SelectList(
optionalFieldRepository.GetAllOptionalFields().ToList(),
"OptionalFieldId",
"OptionalFieldName",
optionalFieldItem.OptionalFieldId);
optionalFieldItemVM.OptionalFields = optionalFields;
//Get Supplier
if (optionalFieldItem.ProductId != null && optionalFieldItem.SupplierCode != null)
{
SupplierRepository supplierRepository = new SupplierRepository();
Supplier supplier = supplierRepository.GetSupplier(optionalFieldItem.SupplierCode, (int)optionalFieldItem.ProductId);
optionalFieldItem.SupplierName = supplier.SupplierName;
}
//Populate List of Products
ProductRepository productRepository = new ProductRepository();
SelectList products = new SelectList(productRepository.GetAllProducts().ToList(),
"ProductId",
"ProductName",
optionalFieldItem.ProductId);
ViewData["ProductList"] = products;
return(View(optionalFieldItemVM));
}
public ActionResult Delete(int id)
{
//Get Item From Database
OptionalFieldItem optionalFieldItem = new OptionalFieldItem();
optionalFieldItem = optionalFieldItemRepository.GetItem(id);
//Check Exists
if (optionalFieldItem == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToOptionalFieldGroup(optionalFieldItem.OptionalFieldGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
OptionalFieldItemVM optionalFieldItemVM = new OptionalFieldItemVM();
//Get Group
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(optionalFieldItem.OptionalFieldGroupId);
if (optionalFieldGroup != null)
{
optionalFieldItemVM.OptionalFieldGroup = optionalFieldGroup;
}
//Get Supplier
if (optionalFieldItem.ProductId != null && optionalFieldItem.SupplierCode != null)
{
SupplierRepository supplierRepository = new SupplierRepository();
Supplier supplier = supplierRepository.GetSupplier(optionalFieldItem.SupplierCode, (int)optionalFieldItem.ProductId);
optionalFieldItem.SupplierName = supplier.SupplierName;
}
//Get Product
if (optionalFieldItem.ProductId != null)
{
ProductRepository productRepository = new ProductRepository();
Product product = productRepository.GetProduct((int)optionalFieldItem.ProductId);
optionalFieldItem.ProductName = product.ProductName;
}
optionalFieldItemVM.OptionalFieldItem = optionalFieldItem;
return(View(optionalFieldItemVM));
}
public ActionResult Edit(OptionalFieldItemVM optionalFieldItemVM)
{
OptionalFieldItem optionalFieldItem = new OptionalFieldItem();
optionalFieldItem = optionalFieldItemRepository.GetItem(optionalFieldItemVM.OptionalFieldItem.OptionalFieldItemId);
//Check Exists
if (optionalFieldItem == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Update Model from Form
try
{
UpdateModel <OptionalFieldItem>(optionalFieldItem, "OptionalFieldItem");
}
catch
{
string n = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
n += error.ErrorMessage;
}
}
ViewData["Message"] = "ValidationError : " + n;
return(View("Error"));
}
//Database Update
try
{
optionalFieldItemRepository.Update(optionalFieldItem);
}
catch (SqlException ex)
{
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
ViewData["Message"] =
"There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
return(RedirectToAction("List", new { id = optionalFieldItem.OptionalFieldGroup.OptionalFieldGroupId }));
}
public ActionResult Create(int id)
{
//Get Item From Database
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(id);
//Check Exists
if (optionalFieldGroup == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToOptionalFieldGroup(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
OptionalFieldItemVM optionalFieldItemVM = new OptionalFieldItemVM();
OptionalFieldItem optionalFieldItem = new OptionalFieldItem();
optionalFieldItem.OptionalFieldGroup = optionalFieldGroup;
optionalFieldItemVM.OptionalFieldItem = optionalFieldItem;
//Get Optional Fields
SelectList optionalFields = new SelectList(optionalFieldRepository.GetAllOptionalFields().ToList(), "OptionalFieldId",
"OptionalFieldName");
optionalFieldItemVM.OptionalFields = optionalFields;
//Populate List of Products
ProductRepository productRepository = new ProductRepository();
SelectList products = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName");
ViewData["ProductList"] = products;
return(View(optionalFieldItemVM));
}
// GET: /View
public ActionResult View(int id)
{
OptionalFieldItemVM optionalFieldItemVM = new OptionalFieldItemVM();
//Check Exists
OptionalFieldItem optionalFieldItem = new OptionalFieldItem();
optionalFieldItem = optionalFieldItemRepository.GetItem(id);
if (optionalFieldItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//Get Group
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(optionalFieldItem.OptionalFieldGroupId);
if (optionalFieldGroup != null)
{
optionalFieldItemVM.OptionalFieldGroup = optionalFieldGroup;
}
//Get Supplier
if (optionalFieldItem.ProductId != null && optionalFieldItem.SupplierCode != null)
{
SupplierRepository supplierRepository = new SupplierRepository();
Supplier supplier = supplierRepository.GetSupplier(optionalFieldItem.SupplierCode, (int)optionalFieldItem.ProductId);
optionalFieldItem.SupplierName = supplier.SupplierName;
}
//Get Product
if (optionalFieldItem.ProductId != null)
{
ProductRepository productRepository = new ProductRepository();
Product product = productRepository.GetProduct((int)optionalFieldItem.ProductId);
optionalFieldItem.ProductName = product.ProductName;
}
optionalFieldItemVM.OptionalFieldItem = optionalFieldItem;
return(View(optionalFieldItemVM));
}
public ActionResult Delete(OptionalFieldItemVM optionalFieldItemVM)
{
//Get Item
OptionalFieldItem optionalFieldItem = new OptionalFieldItem();
optionalFieldItem = optionalFieldItemRepository.GetItem(optionalFieldItemVM.OptionalFieldItem.OptionalFieldItemId);
//Check Exists
if (optionalFieldItem == null)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("RecordDoesNotExistError"));
}
//Delete Item
try
{
optionalFieldItemRepository.Delete(optionalFieldItemVM.OptionalFieldItem);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/OptionalFieldItem.mvc/Delete/" + optionalFieldItem.OptionalFieldItemId.ToString();
return(View("VersionError"));
}
//Generic Error
ViewData["Message"] =
"There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
//Return
return(RedirectToAction("List", new { id = optionalFieldItem.OptionalFieldGroup.OptionalFieldGroupId }));
}
public ActionResult Create(OptionalFieldItemVM optionalFieldItemVM)
{
//Get Item From Database
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(optionalFieldItemVM.OptionalFieldItem.OptionalFieldGroupId);
//Check Exists
if (optionalFieldGroup == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToOptionalFieldGroup(optionalFieldItemVM.OptionalFieldItem.OptionalFieldGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model From Form + Validate against DB
try
{
UpdateModel <OptionalFieldItem>(optionalFieldItemVM.OptionalFieldItem, "OptionalFieldItem");
}
catch
{
string n = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
n += error.ErrorMessage;
}
}
ViewData["Message"] = "ValidationError : " + n;
return(View("Error"));
}
//Database Update
try
{
optionalFieldItemRepository.Add(optionalFieldItemVM.OptionalFieldItem);
}
catch (SqlException ex)
{
//Can only a maximum of 10 items to a group
if (ex.Message == "SQLMaximumNumberReached")
{
ViewData["Message"] = "Sorry, the maximum number of 10 items for this group has already been reached. Please delete an item before adding a new one.";
return(View("Error"));
}
//Non-Unique Name
if (ex.Message == "NonUniqueName")
{
return(View("NonUniqueNameError"));
}
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
return(View("Error"));
}
ViewData["NewSortOrder"] = 0;
return(RedirectToAction("List", new { id = optionalFieldItemVM.OptionalFieldItem.OptionalFieldGroupId }));
}
