private ActionResult RefreshPivotDataWith(Action <AvrPivotGridModel> action) { AvrPivotGridModel model = GetModelFromSession(); if (model == null) { return(View("AvrServiceError", (object)m_ErrorMessage)); } if (action != null) { action(model); } bool isNewObject; string errorMessage; model.PivotData = LayoutPivotGridHelper.GetPivotData(model.PivotSettings, out isNewObject, out errorMessage); if (!string.IsNullOrEmpty(errorMessage)) { m_ErrorMessage = errorMessage; return(View("AvrServiceError", (object)m_ErrorMessage)); } LayoutPivotGridHelper.AddMissedValues(model, false); return(new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = "ok" }); }
public ActionResult ShowMissedValues(bool value) { AvrPivotGridModel model = GetModelFromSession(); if (model == null) { return(View("AvrServiceError", (object)m_ErrorMessage)); } model.PivotSettings.HasChanges = true; model.PivotSettings.ShowMissedValues = value; model.PivotSettings.ShowMissedValuesSaved = model.PivotSettings.ShowMissedValues; model.PivotSettings.ShowDataInPivot = true; LayoutPivotGridHelper.AddMissedValues(model, true); //return RedirectToAction("Layout", new { queryId = model.PivotSettings.QueryId, model.PivotSettings.LayoutId }); return(new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = "ok" }); //return Redirect(HttpContext.Request.UrlReferrer.AbsoluteUri); }
public ActionResult OnSaveFieldChanges (string caption, string captionEn, string aggregateFunctionId, string precision, string basicCountFunctionId, string adminUnitField, string dateField, string groupInterval, string addMissedValue, string startDate, string endDate) { AvrPivotGridModel model = GetModelFromSession(); if (model == null) { return(new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { result = "error", error = m_ErrorMessage } }); } if (model.PivotSettings.SelectedField != null) { WebPivotGridFieldClone clonedField = model.PivotSettings.SelectedField.GetClonedField(model.PivotSettings.LayoutDataset, false); if (ModelUserContext.CurrentLanguage != Localizer.lngEn) { clonedField.Caption = caption; } clonedField.CaptionEn = captionEn; clonedField.AggregateFunctionId = bv.common.Core.Utils.ToLong(aggregateFunctionId); clonedField.BasicCountFunctionId = bv.common.Core.Utils.ToLong(basicCountFunctionId); clonedField.Precision = bv.common.Core.Utils.ToNullableInt(precision); clonedField.UnitLayoutSearchFieldId = bv.common.Core.Utils.ToNullableLong(adminUnitField); clonedField.DateLayoutSearchFieldId = bv.common.Core.Utils.ToNullableLong(dateField); bool updateMissedValues = (!clonedField.AddMissedValues.Equals(bool.Parse(addMissedValue)) || !clonedField.DiapasonStartDate.Equals(bv.common.Core.Utils.ToDateNullable(startDate)) || !clonedField.DiapasonEndDate.Equals(bv.common.Core.Utils.ToDateNullable(endDate)) || !clonedField.PrivateGroupInterval.Equals(bv.common.Core.Utils.ToNullableLong(groupInterval))); clonedField.PrivateGroupInterval = bv.common.Core.Utils.ToNullableLong(groupInterval); bool fillEmptyValues = LayoutPivotGridHelper.IsFieldGroupIntervalChanged(model.PivotSettings.SelectedField, clonedField.PrivateGroupInterval.HasValue ? (PivotGroupInterval)clonedField.PrivateGroupInterval : model.PivotSettings.SelectedField.GroupInterval); clonedField.AddMissedValues = bool.Parse(addMissedValue); clonedField.DiapasonStartDate = bv.common.Core.Utils.ToDateNullable(startDate); clonedField.DiapasonEndDate = bv.common.Core.Utils.ToDateNullable(endDate); string error = ValidateFieldClone(clonedField, model.PivotSettings.SelectedField.IsDateTimeField); if (!string.IsNullOrEmpty(error)) { return(new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { result = "error", error = error } }); } bool aggregateChanged = !model.PivotSettings.SelectedField.AggregateFunctionId.Equals(clonedField.AggregateFunctionId); model.PivotSettings.SelectedField.FlashChanges(model.PivotSettings.LayoutDataset); if (aggregateChanged) { WebPivotGridField field = model.PivotSettings.SelectedField; CustomSummaryType summaryTypeType = AvrPivotGridHelper.ParseSummaryType(model.PivotSettings.SelectedField.AggregateFunctionId); field.SummaryDisplayType = PivotSummaryDisplayType.Default; PivotSummaryType summaryType = summaryTypeType == CustomSummaryType.Count ? PivotSummaryType.Count : PivotSummaryType.Custom; field.CustomSummaryType = summaryTypeType; field.SummaryType = summaryType; } if (model.PivotSettings.SelectedField.Action != WebFieldAction.Add) { model.PivotSettings.SelectedField.Action = WebFieldAction.Edit; } model.PivotSettings.UpdatedField = model.PivotSettings.SelectedField; if (model.PivotSettings.SelectedField.HasChanges) { model.PivotSettings.HasChanges = true; } if (updateMissedValues) { LayoutPivotGridHelper.CopyMissedValuesFromField(model.PivotSettings.SelectedField, model.PivotSettings.Fields); LayoutPivotGridHelper.AddMissedValues(model, true); } else if (fillEmptyValues) { LayoutPivotGridHelper.FillEmptyValuesInDataArea(model); } if (model.PivotSettings.SelectedField.Action != WebFieldAction.Add) { return(new JsonResult { Data = String.Empty, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } } return(new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { result = "refresh", function = "RefeshData2" } }); }