public ActionResult CreateMeasure(CreateMeasureModel model)
{
DatasetDataAccess dataAccess = new DatasetDataAccess();
if (ModelState.IsValid)
{
if (!dataAccess.isCreateMeasureModelValid(model))
{
ModelState.AddModelError("", "An error occured when creating the Measure. Please ensure that the Measure name is unique and that Dimensions have been specified");
model = dataAccess.populateCreateMeasureModel(model.StagingDatasetID);
List<Breadcrumb> trail = new List<Breadcrumb>();
trail.Add(new Breadcrumb() { LinkText = "Home", Action = "Index", Controller = "Home", isCurrent = false });
trail.Add(new Breadcrumb() { LinkText = "Staging Index", Action = "Index", Controller = "Staging", isCurrent = false });
trail.Add(new Breadcrumb() { LinkText = "Create Measure", Action = "", Controller = "", isCurrent = true });
model.Breadcrumbs = trail;
return View(model);
}
dataAccess.createMeasure(model);
IEnumerable<Tuple<int, int>> dimensionMappings = model.MeasureDetails.Where(x => x.DimensionValueID.HasValue).Select(x => new Tuple<int, int>(x.StagingColumnID, x.DimensionValueID.Value));
TempData["DimensionMappings"] = dimensionMappings;
return RedirectToAction("AddMeasureValues", new
{
stagingTableName = model.StagingTableName,
measureName = model.MeasureName,
measureColumnStagingID = model.MeasureColumnID,
geographyColumnID = model.GeographyColumnID,
geographyTypeID = model.GeographyTypeID
});
}
model = dataAccess.populateCreateMeasureModel(model.StagingDatasetID);
return View(model);
}
/// <summary>
/// The controller method to navigate to the page used to
/// initiate the creation of a Measure. This is the first page in a
/// two page process. Initially all that is needed is a Staging
/// Dataset ID to use to populate the model.
///
/// Accessed from /Dataset/CreateMeasure
/// </summary>
/// <param name="stagingDatasetID"></param>
/// <returns></returns>
public ActionResult CreateMeasure(int stagingDatasetID)
{
DatasetDataAccess dataAccess = new DatasetDataAccess();
CreateMeasureModel model = dataAccess.populateCreateMeasureModel(stagingDatasetID);
List<Breadcrumb> trail = new List<Breadcrumb>();
trail.Add(new Breadcrumb() { LinkText = "Home", Action = "Index", Controller = "Home", isCurrent = false });
trail.Add(new Breadcrumb() { LinkText = "Staging Index", Action = "Index", Controller = "Staging", isCurrent = false });
trail.Add(new Breadcrumb() { LinkText = "Create Measure", Action = "", Controller = "", isCurrent = true });
model.Breadcrumbs = trail;
return View(model);
}
