private static List <AvrViewColumn> FillSeriesColumns(AvrView view, string chb, string cb)
{
List <AvrViewColumn> seriesColumns;
// fill selected cells
/*GridCell[] selectedCells = view.GetSelectedCells();
* if (selectedCells.Length > 1)
* {
* seriesColumns = FillSelectedColumns(selectedCells);
* }
* // fill default series
* else*/
if ((chb != null && chb.Length > 0) || (cb != null && cb.Length > 0))
{
seriesColumns = AvrViewHelper.FillSeriesFromCombosWeb(view, chb, cb);
}
// fill whole table
else
{
seriesColumns = view.GetVisibleRowAdminColumns(false, null, false);
}
return(seriesColumns);
}
public void EmptyColumnBandViewSerializeTest()
{
var view = new AvrView(-1, "layoutName", -1);
string viewXml = AvrViewSerializer.Serialize(view);
Assert.IsNotNull(viewXml);
var bandSerializer = new EidssSerializer <AvrViewBand>();
var band = new AvrViewBand();
string bandXml = bandSerializer.Serialize(band);
Assert.IsNotNull(bandXml);
var colSerializer = new EidssSerializer <AvrViewColumn>();
var column = new AvrViewColumn();
column.FieldType = typeof(string);
string columnXml = colSerializer.Serialize(column);
Assert.IsNotNull(columnXml);
AvrViewColumn newColumn = colSerializer.Deserialize(columnXml);
Assert.AreEqual(column.FieldType, newColumn.FieldType);
}
//public static void Grid_CustomUnboundColumnData(object s, ASPxGridViewColumnDataEventArgs e)
//{
// ASPxGridView grid = (ASPxGridView)s;
// var viewModel = GetModelFromSession(grid);
// if (viewModel != null)
// {
// var col = viewModel.ViewHeader.GetColumnByOriginalName(e.Column.FieldName);
// if (col.IsAggregate && grid.Request.RequestContext.HttpContext.Session != null)
// {
// e.Value = AggregateCasheWeb.GetValue(grid.Request.RequestContext.HttpContext.Session.SessionID,
// GetLayoutId(grid),
// e.Column.FieldName, e.ListSourceRowIndex,
// (System.Data.DataTable)grid.DataSource, col);
// }
// }
//}
#region Add To Grid
public static GridViewSettings GetGridViewSettings(AvrView Model)
{
if (Model.GridViewSettings != null && Model.GridViewSettings is GridViewSettings)
{
return(Model.GridViewSettings as GridViewSettings);
}
return(CreateGridViewSettings(Model));
}
private void SaveModelInDb(AvrView model)
{
var dbService = new View_DB();
model.SetOrders();
dbService.avrView = model;
dbService.PostDetail();
}
public void PivotGridDataLoadedCommandTest()
{
Console.WriteLine(@"PivotGridDataLoadedCommandTest");
var avrView = new AvrView(-1, "", -1);
var cmd = new AvrPivotViewModel(avrView, new DataTable());
Assert.AreEqual(avrView, cmd.ViewHeader);
}
public static string SelectedColAggrFunction(this AvrView obj)
{
var field = obj.SelectedColBandObject();
if (!field.AggrFunction.HasValue)
{
return("");
}
return(field.AggrFunction.Value.ToString());
}
public static IEnumerable <ColumnElement> GetAllBandsColumns(this AvrView obj)
{
obj.FillBandsFullPaths();
var ret = new List <ColumnElement> {
new ColumnElement()
};
return(obj.GetVisibleBandsColumns("", ret));
}
private AvrPivotViewModel AdjustToNew(long layoutId, AvrView view, AvrPivotViewModel model)
{
view.SetOrders();
view.AdjustToNew(model.ViewHeader);
view.SetColumnsTypes(model.ViewData);
view.GetAggregateColumnsList().ForEach(c => AggregateCasheWeb.FillAggregateColumn(model.ViewData, c, view.GetSortExpression()));
var modelView = new AvrPivotViewModel(view, model.ViewData);
ObjectStorage.Put(Session.SessionID, layoutId, layoutId, StoragePrefix, modelView);
return(modelView);
}
private static Dictionary <int, DataRow> FillAllRows(DataTable tbl, AvrView view)
{
string filter = view.GetFilterExpression(true);
string sort = view.GetSortExpression();
DataRow[] result = tbl.Select(filter, sort);
var rows = new Dictionary <int, DataRow>();
for (int i = 0; i < result.Count(); i++)
{
rows.Add(i, result[i]);
}
return(rows);
}
public static ColumnElement SelectedColBandObject(this AvrView obj)
{
AvrViewColumn col = obj.GetColumnByOriginalName(obj.SelectedColBand);
if (col != null)
{
return(new ColumnElement(col));
}
AvrViewBand band = obj.GetBandByOriginalName(obj.SelectedColBand);
if (band != null)
{
return(new ColumnElement(band));
}
return(new ColumnElement());
}
private static void DisplayAsterisk(AvrView Model, ASPxGridViewTableDataCellEventArgs e)
{
if (e.CellValue == null || String.IsNullOrEmpty(e.CellValue.ToString()))
{
var col = Model.GetColumnByOriginalName(e.DataColumn.FieldName);
m_DisplayTextHandler.DisplayAsterisk(col, new WebGridCellDisplayTextEventArgs(e));
/*if (e.DataColumn.FieldName.Substring(0, 15) == "AggregateColumn")
* {
* e.Cell.Text = Translator.GetMessageString("strErrorCustomAggregate");
* }
* else if (BaseSettings.ShowAvrAsterisk)
* {
* e.Cell.Text = BaseSettings.Asterisk;
* }*/
}
}
public void FullViewSerializeTest()
{
AvrView avrView = AvrViewSerializer.Deserialize(SerializedViewStub.ViewXml);
Assert.IsNotNull(avrView);
string viewXmlNew = AvrViewSerializer.Serialize(avrView);
Assert.AreEqual(SerializedViewStub.ViewXml, viewXmlNew);
DataTable dataTable = DataTableSerializer.Deserialize(SerializedViewStub.DataXml);
Assert.IsNotNull(dataTable);
string dataXmlNew = DataTableSerializer.Serialize(dataTable);
Assert.AreEqual(SerializedViewStub.DataXml, dataXmlNew);
}
public void GetCachedViewTest()
{
BaseReportTests.InitDBAndLogin();
var facade = new AVRFacade(m_Container);
long layoutId = LayoutFormSave();
List <long> queryIdList = facade.GetQueryIdList();
Assert.IsNotNull(queryIdList);
Assert.IsTrue(queryIdList.Count > 0);
List <long> layoutIdList = facade.GetLayoutIdList();
Assert.IsNotNull(layoutIdList);
Assert.IsTrue(layoutIdList.Count > 0);
ViewDTO model = facade.GetCachedView("xxx", layoutId, "en");
Assert.IsNotNull(model);
Assert.IsNotNull(model.BinaryViewHeader);
Assert.IsNotNull(model.Header);
Assert.IsNotNull(model.BodyPackets);
byte[] unzippedViewStructure = BinaryCompressor.Unzip(model.BinaryViewHeader);
string xmlViewStructure = BinarySerializer.DeserializeToString(unzippedViewStructure);
AvrView view = AvrViewSerializer.Deserialize(xmlViewStructure);
string viewXmlNew = AvrViewSerializer.Serialize(view);
Assert.IsNotNull(viewXmlNew);
BaseTableDTO unzippedDTO = BinaryCompressor.Unzip(model);
DataTable viewData = BinarySerializer.DeserializeToTable(unzippedDTO);
string dataXmlNew = DataTableSerializer.Serialize(viewData);
Assert.IsNotNull(dataXmlNew);
}
public void ViewFacedeTest()
{
var facade = new AVRFacadeStub(123);
ViewDTO model = facade.GetCachedView("xxx", -1, "en");
Assert.IsNotNull(model);
Assert.IsNotNull(model.BinaryViewHeader);
Assert.IsNotNull(model.Header);
Assert.IsNotNull(model.BodyPackets);
byte[] unzippedViewStructure = BinaryCompressor.Unzip(model.BinaryViewHeader);
string xmlViewStructure = BinarySerializer.DeserializeToString(unzippedViewStructure);
AvrView view = AvrViewSerializer.Deserialize(xmlViewStructure);
string viewXmlNew = AvrViewSerializer.Serialize(view);
Assert.AreEqual(SerializedViewStub.ViewXml, viewXmlNew);
BaseTableDTO unzippedDTO = BinaryCompressor.Unzip(model);
DataTable viewData = BinarySerializer.DeserializeToTable(unzippedDTO);
string dataXmlNew = DataTableSerializer.Serialize(viewData);
Assert.AreEqual(SerializedViewStub.DataXml, dataXmlNew);
}
public static GridViewSettings CreateGridViewSettings(AvrView Model)
{
GridViewSettings settings = new GridViewSettings();
var CanUpdate = !Model.IsReadOnly && eidss.model.Core.AvrPermissions.UpdatePermission;
settings.Styles.Cell.Wrap = DefaultBoolean.True;
settings.Name = "layoutViewGrid";
settings.CallbackRouteValues = new { Controller = "ViewLayout", Action = "ViewGridView", layoutId = Model.LayoutID };
settings.KeyFieldName = "ID";
// Behavior
settings.SettingsBehavior.AllowSort = true;
settings.SettingsBehavior.EnableCustomizationWindow = CanUpdate;
settings.SettingsBehavior.ColumnResizeMode = ColumnResizeMode.Control;
settings.SettingsBehavior.AllowDragDrop = CanUpdate;
settings.SettingsBehavior.AllowSelectByRowClick = true;
settings.SettingsBehavior.AllowSelectSingleRowOnly = false;
// Context menu
settings.SettingsContextMenu.Enabled = true;
settings.SettingsContextMenu.EnableColumnMenu = DevExpress.Utils.DefaultBoolean.True;
settings.SettingsContextMenu.EnableRowMenu = DevExpress.Utils.DefaultBoolean.False;
settings.ClientSideEvents.ContextMenu = "viewGridForm.grid_OnContextMenu";
/*settings.FillContextMenuItems = (sender, e) => {
* e.Items.Add(EidssMessages.Get("RenameColumnBand"), "RenameColumnBand");
* e.Items.Add(EidssMessages.Get("btAddAggregateColumn"), "btAddAggregateColumn");
* // now we can't find which column we clicked - we cant differentiate menu for aggregate columns
* ASPxGridView grid = (ASPxGridView)sender;
* e.Items.Add(EidssMessages.Get("DeleteAggregateColumn"), "DeleteAggregateColumn");
* };*/
// show
settings.Width = Unit.Percentage(100);
settings.SettingsPager.Mode = GridViewPagerMode.ShowPager;
settings.SettingsPager.PageSize = 15;
settings.Settings.HorizontalScrollBarMode = ScrollBarMode.Visible;
settings.Styles.Header.Font.Bold = true;
settings.Styles.LoadingDiv.CssClass = "center";
settings.SettingsExport.Landscape = true;
settings.StylesPager.PageSizeItem.Wrap = DefaultBoolean.True;
// filtration
settings.Settings.ShowHeaderFilterButton = true;
settings.Settings.ShowFilterBar = GridViewStatusBarMode.Hidden;
// Aggregate functions
//settings.CustomUnboundColumnData = Grid_CustomUnboundColumnData;
// Add columns (and bands)
AddToGrid(Model, settings.Columns);
// Custom filter
settings.HeaderFilterFillItems = (sender, e) =>
{
var col = Model.GetColumnByOriginalName(e.Column.FieldName);
if (col != null && !string.IsNullOrEmpty(col.ColumnFilter) &&
!col.ColumnFilter.StartsWith("IsNullOrEmpty") && !col.ColumnFilter.StartsWith("Not IsNullOrEmpty") &&
!col.ColumnFilter.EndsWith(" Null") &&
(col.ColumnFilter.Contains(" Or ") || col.ColumnFilter.Contains(" And ") || !col.ColumnFilter.Contains(" = ")))
{
e.AddValue(col.ColumnFilter.Replace("[" + e.Column.FieldName + "] ", ""), string.Empty, col.ColumnFilter);
}
};
// Events
settings.HtmlDataCellPrepared = (sender, e) =>
{
DisplayAsterisk(Model, e);
};
settings.ClientLayout = Grid_ClientLayout;
settings.PreRender = Grid_PreRender;
settings.ClientSideEvents.CustomizationWindowCloseUp = "viewGridForm.grid_CustomizationWindowCloseUp";
settings.ClientSideEvents.ColumnResized = "viewGridForm.grid_ColumnResized";
settings.ClientSideEvents.ColumnMoving = "viewGridForm.grid_ColumnMoving";
settings.ClientSideEvents.CallbackError = "viewGridForm.grid_CallbackError";
//settings.ClientSideEvents.SelectionChanged = "viewGridForm.grid_SelectionChanged";
settings.Theme = GeneralSettings.Theme;
settings.RightToLeft = Cultures.IsRtl ? DefaultBoolean.True : DefaultBoolean.False;
Model.GridViewSettings = settings;
ResetDisplayTextHandler();
return(settings);
}
public static string SelectedColBandName(this AvrView obj)
{
var field = obj.SelectedColBandObject();
return(field.DisplayText);
}
// Main function of prepairing data for chart
private static DataTable CreateDataForChart(string rowColumn, List <AvrViewColumn> columns, Dictionary <int, DataRow> rows, AvrView view)
{
var rowColAvr = view.GetColumnByOriginalName(rowColumn);
var ds = AvrViewHelper.PrepareChartTable(view.LayoutName, columns, rowColAvr);
var dt = ds.Tables["Data"];
if (rows != null && rows.Count > 0)
{
// fill rows of table
dt.BeginLoadData();
foreach (int i in rows.Keys)
{
DataRow nRow = dt.NewRow();
nRow[rowColAvr.UniquePath] = rows[i][rowColumn];
FillMapOrChartValues(columns, rows, i, nRow, false);
dt.Rows.Add(nRow);
}
dt.EndLoadData();
dt.AcceptChanges();
}
return(dt);
}
// Main function of prepairing data for map
private static DataSet CreateDataForMap(string rowColumn, List <AvrViewColumn> columns, Dictionary <int, DataRow> rows, AvrView view)
{
var ds = AvrViewHelper.PrepareMapTable(view.LayoutName, columns);
DataTable dtData = ds.Tables["Data"];
if (rows != null && rows.Count > 0)
{
dtData.Columns.Add("UniquePath", typeof(string));
// fill rows of table
dtData.BeginLoadData();
foreach (int i in rows.Keys)
{
DataRow nRow = dtData.NewRow();
var r = (string)rows[i][rowColumn];
if (r.EndsWith(view.TotalSuffix))
{
r = r.Substring(0, r.Length - view.TotalSuffix.Length);
}
nRow["UniquePath"] = r.Trim();
FillMapOrChartValues(columns, rows, i, nRow, true);
dtData.Rows.Add(nRow);
}
AvrViewHelper.ConvertMapDataForGis(ref dtData);
dtData.Columns.Remove("UniquePath");
dtData.EndLoadData();
dtData.AcceptChanges();
}
return(ds);
}
// remember data of all rows of selected in combo column
private static Dictionary <int, DataRow> FillXAxisData(DataTable dt, string xName, AvrView view)
{
// fill selected rows or fill whole column
Dictionary <int, DataRow> xAxisData = /*view.GetSelectedCells().Length > 1
* ? FillSelectedRows(view)
* :*/FillAllRows(dt, view);
return(AvrViewHelper.FillXAxisData(xAxisData, xName, view.GrandTotalSuffix, view.TotalSuffix));
}
