public ActionResult DefaultGroupDateChanged(long value) { AvrPivotGridModel model = GetModelFromSession(); if (model == null) { return(View("AvrServiceError", (object)m_ErrorMessage)); } model.PivotSettings.HasChanges = true; model.PivotSettings.DefaultGroupInterval = value; model.PivotSettings.UpdateGroupInterval = true; if (model.PivotSettings.Fields.Any( f => f.Visible && (f.Area == PivotArea.RowArea || f.Area == PivotArea.ColumnArea) && f.IsDateTimeField)) { LayoutPivotGridHelper.FillEmptyValuesInDataArea(model); } return(new JsonResult { Data = String.Empty, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
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" } }); }