/// <summary> /// A helper method which returns the partial view of the recently created column data /// </summary> /// <param name="measureID">The ID of the measure to be used</param> /// <param name="measureBreakdownID">The ID of the measure Breakdown to be used</param> /// <param name="dimValueID">The ID of the Dim Combination to be used</param> /// <param name="newColumnName">The name of the new column to be added</param> /// <returns>The Partial View that can will be added to the main view</returns> public PartialViewResult AddColumnRow(int measureID, int measureBreakdownID, int dimValueID, String newColumnName) { DataViewDataAccess dataAccess = new DataViewDataAccess(); ViewColumnModel model = dataAccess.getColumnModel(measureID, measureBreakdownID, dimValueID, newColumnName); return PartialView("ViewColumnControl", model); }
public ActionResult CreateView(CreateViewModel model) { DataViewDataAccess dataAccess = new DataViewDataAccess(); if (!dataAccess.isCreateViewModelValid(model)) { ModelState.AddModelError("ViewName", "The View Name must be unique"); CreateViewModel tempModel = dataAccess.getDefaultCreateViewModel(); model.GeographyTypes = tempModel.GeographyTypes; model.NewColumnModel = dataAccess.getDefaultColumnModel(); List<Breadcrumb> trail = new List<Breadcrumb>(); trail.Add(new Breadcrumb() { LinkText = "Home", Action = "Index", Controller = "Home", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Data View Index", Action = "Index", Controller = "DataView", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Create Data View", Action = "", Controller = "", isCurrent = true }); model.Breadcrumbs = trail; return View(model); } try { dataAccess.CreateView(model); } catch (SqlException) { ModelState.AddModelError("", "An error occured when creating the Data View. Please ensure that the Data View Name is unique and that the columns are uniquely named within it."); CreateViewModel tempModel = dataAccess.getDefaultCreateViewModel(); model.GeographyTypes = tempModel.GeographyTypes; model.NewColumnModel = dataAccess.getDefaultColumnModel(); List<Breadcrumb> trail = new List<Breadcrumb>(); trail.Add(new Breadcrumb() { LinkText = "Home", Action = "Index", Controller = "Home", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Data View Index", Action = "Index", Controller = "DataView", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Create Data View", Action = "", Controller = "", isCurrent = true }); model.Breadcrumbs = trail; return View(model); } TempData["SuccessMessage"] = String.Format("The Data View - {0}, was successfully created", model.ViewName); return RedirectToAction("Index"); }
/// <summary> /// A controller method to navigate to the page where users can create /// a bespoke View. This populates the initial models for the view /// </summary> /// <returns>The View to be displayed</returns> public ActionResult CreateView() { DataViewDataAccess dataAccess = new DataViewDataAccess(); CreateViewModel model = dataAccess.getDefaultCreateViewModel(); List<ViewColumnModel> columns = new List<ViewColumnModel>(); model.Columns = columns; model.NewColumnModel = dataAccess.getDefaultColumnModel(); List<Breadcrumb> trail = new List<Breadcrumb>(); trail.Add(new Breadcrumb() { LinkText = "Home", Action = "Index", Controller = "Home", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Data View Index", Action = "Index", Controller = "DataView", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Create Data View", Action = "", Controller = "", isCurrent = true }); model.Breadcrumbs = trail; return View(model); }
/// <summary> /// A controller method to display a page which allows the user /// to view the data returned from a call to a View in the /// Database. This takes the ID of the View as a parameter. /// There is no postback from this page. /// /// Accessed via /DataView/ViewDetails /// </summary> /// <param name="viewID"></param> /// <returns></returns> public ActionResult ViewDetails(int viewID) { DataViewDataAccess dataAccess = new DataViewDataAccess(); DataViewDetailModel model = dataAccess.getViewData(viewID); List<Breadcrumb> trail = new List<Breadcrumb>(); trail.Add(new Breadcrumb() { LinkText = "Home", Action = "Index", Controller = "Home", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Data View Index", Action = "Index", Controller = "DataView", isCurrent = false }); trail.Add(new Breadcrumb() { LinkText = "Data View Details", Action = "", Controller = "", isCurrent = true }); model.Breadcrumbs = trail; return View(model); }
/// <summary> /// Helper method which is used to update the drop down /// of Measure Breakdowns based on a selected /// Measure /// </summary> /// <param name="measureID">The ID of the selected Measure</param> /// <returns>The data to populate the drop down of Measure Breakdowns as JSON</returns> public JsonResult GetMeasureBreakdownsForMeasure(int measureID) { DataViewDataAccess dataAccess = new DataViewDataAccess(); return Json(dataAccess.getMeasureBreakdownsForMeasure(measureID)); }
/// <summary> /// Helper method which is used to update the drop down /// of Dimension Set Combinations based on a selected /// Measure Breakdown /// </summary> /// <param name="measureBreakdownID">The ID of the selected Measure Breakdown</param> /// <returns>The data to populate the drop down of Dimension Set Combinations as JSON</returns> public JsonResult GetDimensionSetCombinationsForMeasureBreakdown(int measureBreakdownID) { DataViewDataAccess dataAccess = new DataViewDataAccess(); return Json(dataAccess.getDimensionSetCombinationsForMeasureBreakdowns(measureBreakdownID)); }