private AvrPivotGridModel GetModelFromSession(long layoutId = -1)
{
if (layoutId <= 0)
{
NameValueCollection nameValueCollection = HttpUtility.ParseQueryString(Request.UrlReferrer.Query);
layoutId = Convert.ToInt64(nameValueCollection["layoutId"]);
}
//var model = ModelStorage.Get(Session.SessionID, layoutId, StoragePrefix, false) as AvrPivotGridModel;
var model = ObjectStorage.Using <AvrPivotGridModel, AvrPivotGridModel>(o => o, Session.SessionID, layoutId, StoragePrefix, false);
if (model == null)
{
long queryId = 0L;
try
{
AvrServiceAccessability access = AvrServiceAccessability.Check();
if (!access.IsOk)
{
m_ErrorMessage = access.ErrorMessage;
return(null);
}
model = FillData(ref queryId, layoutId);
}
catch (Exception ex)
{
m_ErrorMessage = ex.Message;
return(null);
}
ObjectStorage.Put(Session.SessionID, queryId, layoutId, StoragePrefix, model);
}
LayoutPivotGridHelper.ResetDisplayTextHandler();
return(model);
}
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 static AvrPivotGridModel FillData(ref long queryId, long layoutId)
{
var service = new WebLayoutDB();
var sessionDataSet = (LayoutDetailDataSet)service.GetDetail(layoutId);
if (queryId <= 0)
{
queryId = ((LayoutDetailDataSet.LayoutRow)sessionDataSet.Layout.Rows[0]).idflQuery;
}
var helper = new LayoutHelper(sessionDataSet);
var settings = new AvrPivotSettings(queryId, layoutId);
helper.InitAvrPivotSettings(settings);
bool isNewObject;
string errorMessage;
AvrDataTable data = LayoutPivotGridHelper.GetPivotData(
helper.LayoutDataSet,
queryId,
layoutId,
settings.UseArchiveData,
settings.ApplyFilter ? settings.FilterCriteriaString :string.Empty,
out isNewObject, out errorMessage);
if (!string.IsNullOrEmpty(errorMessage))
{
throw new AvrException(errorMessage);
}
settings.Fields = AvrPivotGridHelper.CreateFields <WebPivotGridField>(data);
helper.PrepareWebFields(settings);
List <IAvrPivotGridField> fields = settings.Fields.Cast <IAvrPivotGridField>().ToList();
LayoutValidateResult result = helper.LoadPivotFromDB(new AvrPivotGridData(data), fields, isNewObject);
var model = new AvrPivotGridModel(settings, data);
if (result.IsCancelOrUserDialogCancel())
{
model.HideDataForComplexLayout();
}
return(model);
}
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" }
});
}
