Example #1
0
        public bool SaveData(AvrPivotSettings settings)
        {
            List <IAvrPivotGridField> fields = settings.Fields.Cast <IAvrPivotGridField>().ToList();

            AvrPivotGridHelper.PrepareLayoutSearchFieldsBeforePost(fields,
                                                                   LayoutDataSet.LayoutSearchField, settings.QueryId, settings.LayoutId);
            var db = new WebLayoutDB();

            db.SetQueryID(settings.QueryId);
            LayoutRow.idfsDefaultGroupDate           = settings.DefaultGroupInterval;
            LayoutRow.blnShowColsTotals              = settings.ShowColumnTotals;
            LayoutRow.blnShowRowsTotals              = settings.ShowRowTotals;
            LayoutRow.blnShowColGrandTotals          = settings.ShowColumnGrandTotals;
            LayoutRow.blnShowRowGrandTotals          = settings.ShowRowGrandTotals;
            LayoutRow.blnShowForSingleTotals         = settings.ShowTotalsForSingleValues;
            LayoutRow.blnShowMissedValuesInPivotGrid = settings.ShowMissedValues;
            LayoutRow.blnApplyPivotGridFilter        = settings.ApplyFilter;
            LayoutRow.blnCompactPivotGrid            = settings.CompactLayout;
            LayoutRow.blnFreezeRowHeaders            = settings.FreezeRowHeaders;
            LayoutRow.blnUseArchivedData             = settings.UseArchiveData;
            LayoutRow.strPivotGridSettings           = settings.FilterCriteriaString;
            LayoutRow.blnShowDataInPivotGrid         = settings.ShowDataInPivot;
            return(db.PostDetail(m_DataSet, (int)PostType.FinalPosting));
        }