public OptionalFieldItemSequencesVM(CWTPaginatedList <spDesktopDataAdmin_SelectOptionalFieldItemSequences_v1Result> servicingOptionItemSequences, OptionalFieldGroup servicingOptionGroup, int servicingOptionId, OptionalField servicingOption)
{
OptionalFieldItemSequences = servicingOptionItemSequences;
OptionalFieldGroup = servicingOptionGroup;
OptionalField = servicingOption;
OptionalFieldId = servicingOptionId;
}
//Add Data From Linked Tables for Display
public void EditGroupForDisplay(OptionalFieldGroup group)
{
HierarchyRepository hierarchyRepository = new HierarchyRepository();
List <fnDesktopDataAdmin_SelectOptionalFieldGroupHierarchy_v1Result> hierarchy = new List <fnDesktopDataAdmin_SelectOptionalFieldGroupHierarchy_v1Result>();
hierarchy = GetGroupHierarchy(group.OptionalFieldGroupId);
group.OptionalFieldGroupName = Regex.Replace(group.OptionalFieldGroupName, @"[^\w\-()*]", "-");
if (hierarchy.Count > 0)
{
if (hierarchy.Count == 1)
{
group.HierarchyCode = hierarchy[0].HierarchyCode;
group.HierarchyItem = hierarchy[0].HierarchyName.Trim();
group.HierarchyType = hierarchy[0].HierarchyType;
}
else
{
group.HierarchyCode = "Multiple"; //Placeholder
group.HierarchyItem = "Multiple"; //Placeholder
group.HierarchyType = "Multiple";
}
}
group.IsMultipleHierarchy = (hierarchy.Count > 1);
}
// GET: /UnDelete
public ActionResult UnDelete(int id)
{
//Get Item From Database
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(id);
//Check Exists
if (optionalFieldGroup == null || optionalFieldGroup.DeletedFlag == false)
{
ViewData["ActionMethod"] = "DeleteGet";
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"));
}
OptionalFieldGroupVM optionalFieldGroupVM = new OptionalFieldGroupVM();
optionalFieldGroupRepository.EditGroupForDisplay(optionalFieldGroup);
optionalFieldGroupVM.OptionalFieldGroup = optionalFieldGroup;
return(View(optionalFieldGroupVM));
}
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));
}
//Change the deleted status on an item
public void UpdateGroupDeletedStatus(OptionalFieldGroup group)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_UpdateOptionalFieldGroupDeletedStatus_v1(
group.OptionalFieldGroupId,
group.DeletedFlag,
adminUserGuid,
group.VersionNumber
);
}
public OptionalFieldItemsVM(OptionalFieldGroup optionalFieldGroup,
CWTPaginatedList <spDesktopDataAdmin_SelectOptionalFieldGroupOptionalFieldItems_v1Result> optionalFieldItems,
bool hasWriteAccess,
bool canCreate,
bool canEditOrder)
{
OptionalFieldGroup = optionalFieldGroup;
OptionalFieldItems = optionalFieldItems;
HasWriteAccess = hasWriteAccess;
CanCreate = canCreate;
CanEditOrder = canEditOrder;
}
public ActionResult UnDelete(OptionalFieldGroupVM optionalFieldGroupVM)
{
//Check Valid Item passed in Form
if (optionalFieldGroupVM.OptionalFieldGroup == null)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("RecordDoesNotExistError"));
}
//Get Item From Database
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(optionalFieldGroupVM.OptionalFieldGroup.OptionalFieldGroupId);
//Check Exists in Databsase
if (optionalFieldGroup == null || optionalFieldGroup.DeletedFlag == false)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("RecordDoesNotExistError"));
}
//Check Access
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToOptionalFieldGroup(optionalFieldGroup.OptionalFieldGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Delete Form Item
try
{
optionalFieldGroupVM.OptionalFieldGroup.DeletedFlag = false;
optionalFieldGroupRepository.UpdateGroupDeletedStatus(optionalFieldGroupVM.OptionalFieldGroup);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/OptionalFieldGroup.mvc/UnDelete/" + optionalFieldGroup.OptionalFieldGroupId;
return(View("VersionError"));
}
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("ListUnDeleted"));
}
//Add Group
public void Add(OptionalFieldGroup optionalFieldGroup)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_InsertOptionalFieldGroup_v1(
optionalFieldGroup.OptionalFieldGroupName,
optionalFieldGroup.EnabledFlag,
optionalFieldGroup.EnabledDate,
optionalFieldGroup.ExpiryDate,
optionalFieldGroup.HierarchyType,
optionalFieldGroup.HierarchyCode,
adminUserGuid
);
}
public ActionResult SelectOptionalFieldToOrder(int id)
{
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(id);
OptionalFieldItemOrderSelectionVM optionalFieldItemOrderSelectionVM = new OptionalFieldItemOrderSelectionVM();
ViewData["Products"] = new SelectList(optionalFieldItemRepository.GetOptionalFieldItemOptionalFieldTypes(id), "ProductId", "ProductName");
optionalFieldItemOrderSelectionVM.OptionalFieldGroup = optionalFieldGroup;
return(View(optionalFieldItemOrderSelectionVM));
}
//Edit Group
public void Edit(OptionalFieldGroup group)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_UpdateOptionalFieldGroup_v1(
group.OptionalFieldGroupId,
group.OptionalFieldGroupName,
group.EnabledFlag,
group.EnabledDate,
group.ExpiryDate,
group.HierarchyType,
group.HierarchyCode,
adminUserGuid,
group.VersionNumber
);
}
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));
}
// GET: /View
public ActionResult View(int id)
{
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(id);
//Check Exists
if (optionalFieldGroup == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
OptionalFieldGroupVM optionalFieldGroupVM = new OptionalFieldGroupVM();
optionalFieldGroupRepository.EditGroupForDisplay(optionalFieldGroup);
optionalFieldGroupVM.OptionalFieldGroup = optionalFieldGroup;
return(View(optionalFieldGroupVM));
}
public ActionResult SelectOptionalFieldToOrder(OptionalFieldItemOrderSelectionVM optionalFieldItemOrderSelectionVM)
{
int groupId = optionalFieldItemOrderSelectionVM.OptionalFieldGroup.OptionalFieldGroupId;
//int id = optionalFieldItemOrderSelectionVM.OptionalFieldId;
int productId = optionalFieldItemOrderSelectionVM.ProductId;
//Get Group
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(groupId);
//Check Exists
if (optionalFieldGroup == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Return
return(RedirectToAction("EditSequence", new { groupid = groupId, productId = productId }));
}
// GET: /Edit
public ActionResult Edit(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"));
}
OptionalFieldGroupVM optionalFieldGroupVM = new OptionalFieldGroupVM();
optionalFieldGroupRepository.EditGroupForDisplay(optionalFieldGroup);
optionalFieldGroupVM.OptionalFieldGroup = optionalFieldGroup;
TablesDomainHierarchyLevelRepository tablesDomainHierarchyLevelRepository = new TablesDomainHierarchyLevelRepository();
SelectList hierarchyTypesList = new SelectList(
tablesDomainHierarchyLevelRepository.GetDomainHierarchies(groupName).ToList(),
"HierarchyLevelTableName",
"HierarchyLevelTableName",
optionalFieldGroup.HierarchyType);
optionalFieldGroupVM.HierarchyTypes = hierarchyTypesList;
return(View(optionalFieldGroupVM));
}
// GET: /Create
public ActionResult Create()
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
OptionalFieldGroupVM optionalFieldGroupVM = new OptionalFieldGroupVM();
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup.EnabledFlag = true;
optionalFieldGroupVM.OptionalFieldGroup = optionalFieldGroup;
TablesDomainHierarchyLevelRepository tablesDomainHierarchyLevelRepository = new TablesDomainHierarchyLevelRepository();
SelectList hierarchyTypesList = new SelectList(tablesDomainHierarchyLevelRepository.GetDomainHierarchies(groupName).ToList(), "HierarchyLevelTableName", "HierarchyLevelTableName");
optionalFieldGroupVM.HierarchyTypes = hierarchyTypesList;
return(View(optionalFieldGroupVM));
}
// GET: /EditSequence
public ActionResult EditSequence(int groupid, int productId, int?page)
{
//Get Group
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(groupid);
//Check Exists
if (optionalFieldGroup == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToOptionalFieldGroup(groupid))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
OptionalFieldItemSequenceRepository optionalFieldItemSequenceRepository = new OptionalFieldItemSequenceRepository();
OptionalFieldRepository optionalFieldRepository = new OptionalFieldRepository();
//Only show products where more than one item is present
OptionalFieldItemSequencesVM optionalFieldItemSequencesVM = new OptionalFieldItemSequencesVM();
optionalFieldItemSequencesVM.OptionalFieldItemSequences = optionalFieldItemSequenceRepository.GetOptionalFieldItemSequences(groupid, productId, page ?? 1);
optionalFieldItemSequencesVM.OptionalFieldGroup = optionalFieldGroup;
//optionalFieldItemSequencesVM.OptionalField = optionalFieldRepository.GetItem(id);
//optionalFieldItemSequencesVM.OptionalFieldId = id;
ViewData["Page"] = page ?? 1;
return(View(optionalFieldItemSequencesVM));
}
public ActionResult Edit(OptionalFieldGroupVM optionalFieldGroupVM)
{
//Get Item
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(optionalFieldGroupVM.OptionalFieldGroup.OptionalFieldGroupId);
//Check Exists
if (optionalFieldGroup == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToOptionalFieldGroup(optionalFieldGroup.OptionalFieldGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model From Form + Validate against DB
try
{
UpdateModel <OptionalFieldGroup>(optionalFieldGroup, "OptionalFieldGroup");
}
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"));
}
//Dont check for multiple as We are not editing Hierarchy, we have alrady checked access to the item itself
if (optionalFieldGroup.HierarchyType != "Multiple")
{
string hierarchyCode = optionalFieldGroup.HierarchyCode;
//Check Access Rights to PolicyGroup
HierarchyRepository hierarchyRepository = new HierarchyRepository();
if (!hierarchyRepository.AdminHasDomainHierarchyWriteAccess(optionalFieldGroup.HierarchyType, hierarchyCode, optionalFieldGroup.SourceSystemCode, groupName))
{
ViewData["Message"] = "You cannot add to this hierarchy item";
return(View("Error"));
}
}
//Database Update
try
{
optionalFieldGroupRepository.Edit(optionalFieldGroup);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/OptionalFieldGroup.mvc/Edit/" + optionalFieldGroup.OptionalFieldGroupId;
return(View("VersionError"));
}
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("ListUnDeleted"));
}
public ActionResult Create(OptionalFieldGroupVM optionalFieldGroupVM)
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//We need to extract group from groupVM
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupVM.OptionalFieldGroup;
if (optionalFieldGroup == null)
{
ViewData["Message"] = "ValidationError : missing item";;
return(View("Error"));
}
//Check Access Rights to Domain Hierarchy
if (!hierarchyRepository.AdminHasDomainHierarchyWriteAccess(
optionalFieldGroup.HierarchyType,
optionalFieldGroup.HierarchyCode,
optionalFieldGroup.SourceSystemCode,
groupName))
{
ViewData["Message"] = "You cannot add to this hierarchy item";
return(View("Error"));
}
//Update Model From Form + Validate against DB
try
{
UpdateModel(optionalFieldGroup);
}
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
{
optionalFieldGroupRepository.Add(optionalFieldGroup);
}
catch (SqlException ex)
{
//Non-Unique Name
if (ex.Message == "NonUniqueName")
{
return(View("NonUniqueNameError"));
}
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"));
}
ViewData["NewSortOrder"] = 0;
return(RedirectToAction("ListUnDeleted"));
}
public ActionResult List(int id, string filter, int?page, string sortField, int?sortOrder)
{
//Get Item From Database
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(id);
//Check Exists
if (optionalFieldGroup == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//SortField
if (sortField != "OptionalFieldDisplayOrder" && sortField != "ProductName" && sortField != "SupplierName")
{
sortField = "OptionalFieldName";
}
ViewData["CurrentSortField"] = sortField;
//SortOrder
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
sortOrder = 0;
}
OptionalFieldItemsVM optionalFieldItemsVM = new OptionalFieldItemsVM();
optionalFieldItemsVM.OptionalFieldGroup = optionalFieldGroup;
var paginatedResult = optionalFieldItemRepository.PageOptionalFieldItems(id, page ?? 1, sortField, sortOrder ?? 0);
optionalFieldItemsVM.OptionalFieldItems = paginatedResult;
//Can only a maximum of 10 items to a group
int recordCount = paginatedResult.Count();
if (recordCount < 10)
{
optionalFieldItemsVM.CanCreate = true;
}
//Can only edit order if more than 1 item present per group
if (recordCount > 1)
{
optionalFieldItemsVM.CanEditOrder = (paginatedResult.First().CanEditOrder == true);
}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToOptionalFieldGroup(optionalFieldGroup.OptionalFieldGroupId))
{
optionalFieldItemsVM.HasWriteAccess = true;
}
return(View(optionalFieldItemsVM));
}
public OptionalFieldGroupVM(OptionalFieldGroup optionalFieldGroup, IEnumerable <SelectListItem> hierarchyTypes)
{
OptionalFieldGroup = optionalFieldGroup;
HierarchyTypes = hierarchyTypes;
}
public ActionResult EditSequence(int groupid, int page, FormCollection collection)
{
//Get Group
OptionalFieldGroup optionalFieldGroup = new OptionalFieldGroup();
optionalFieldGroup = optionalFieldGroupRepository.GetGroup(groupid);
//Check Exists
if (optionalFieldGroup == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
////Check Exists
//OptionalField optionalField = new OptionalField();
//OptionalFieldRepository optionalFieldRepository = new OptionalFieldRepository();
//optionalField = optionalFieldRepository.GetItem(id);
//if (optionalField == null)
//{
// ViewData["ActionMethod"] = "EditSequencePost";
// return View("RecordDoesNotExistError");
//}
//Check Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToOptionalFieldGroup(groupid))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
string[] sequences = collection["Sequence"].Split(new char[] { ',' });
int sequence = (page - 1 * 5) - 2;
if (sequence < 0)
{
sequence = 1;
}
XmlDocument doc = new XmlDocument();// Create the XML Declaration, and append it to XML document
XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", null, null);
doc.AppendChild(dec);
XmlElement root = doc.CreateElement("SequenceXML");
doc.AppendChild(root);
foreach (string s in sequences)
{
string[] primaryKey = s.Split(new char[] { '_' });
int servicingOptionItemId = Convert.ToInt32(primaryKey[0]);
int versionNumber = Convert.ToInt32(primaryKey[1]);
XmlElement xmlItem = doc.CreateElement("Item");
root.AppendChild(xmlItem);
XmlElement xmlSequence = doc.CreateElement("Sequence");
xmlSequence.InnerText = sequence.ToString();
xmlItem.AppendChild(xmlSequence);
XmlElement xmlServicingOptionItemId = doc.CreateElement("OptionalFieldItemId");
xmlServicingOptionItemId.InnerText = servicingOptionItemId.ToString();
xmlItem.AppendChild(xmlServicingOptionItemId);
XmlElement xmlVersionNumber = doc.CreateElement("VersionNumber");
xmlVersionNumber.InnerText = versionNumber.ToString();
xmlItem.AppendChild(xmlVersionNumber);
sequence = sequence + 1;
}
try
{
OptionalFieldItemSequenceRepository optionalFieldItemSequenceRepository = new OptionalFieldItemSequenceRepository();
optionalFieldItemSequenceRepository.UpdateOptionalFieldItemSequences(System.Xml.Linq.XElement.Parse(doc.OuterXml));
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/servicingOptionItem.mvc/EditSequence?page=" + page + "&groupid=" + groupid;
return(View("VersionError"));
}
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 = groupid }));
}
public OptionalFieldItemOrderSelectionVM(int productId, OptionalFieldGroup optionalFieldGroup)
{
OptionalFieldGroup = optionalFieldGroup;
ProductId = productId;
}
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 }));
}
