private JArray GetGridRecords(JArray columns, int rowCount, int rowOffset, int serieIndex, bool useFilter = false, string filterValue = null)
{
var data = new JArray();
string schemaName = GetSchemaName(serieIndex);
if (!string.IsNullOrEmpty(schemaName))
{
DashboardGridDataSelectBuilder selectBuilder =
GetDashboardGridDataSelectBuilder(columns, rowCount, rowOffset, serieIndex);
JToken serieParameters = GetParameters(serieIndex);
SetChartFilters(selectBuilder, serieParameters);
if (useFilter)
{
SetSerieFilter(selectBuilder, serieParameters, filterValue);
}
Select select = selectBuilder.Build();
Dictionary <string, object> entityColumnMap = selectBuilder.EntityColumnsMap;
using (var dbExecutor = UserConnection.EnsureDBConnection()) {
using (IDataReader dataReader = select.ExecuteReader(dbExecutor)) {
while (dataReader.Read())
{
var dataItem = new JObject();
foreach (var map in entityColumnMap)
{
object value = GetValueByColumnMap(dataReader, (Dictionary <string, object>)map.Value);
dataItem.Add(new JProperty(map.Key, value));
}
data.Add(dataItem);
}
}
}
}
return(data);
}
private JArray GetData()
{
var data = new JArray();
if (string.IsNullOrEmpty(GetSchemaName()))
{
return(data);
}
DashboardGridDataSelectBuilder selectBuilder = GetSelectBuilder();
ApplySectionBindingFilter(selectBuilder);
Select select = selectBuilder.Build();
var entityColumnMap = selectBuilder.EntityColumnsMap;
using (var dbExecutor = UserConnection.EnsureDBConnection()) {
using (IDataReader dataReader = select.ExecuteReader(dbExecutor)) {
while (dataReader.Read())
{
var dataItem = new JObject();
foreach (var map in entityColumnMap)
{
object value = GetValueByColumnMap(dataReader, (Dictionary <string, object>)map.Value);
dataItem.Add(new JProperty(map.Key, value));
}
data.Add(dataItem);
}
}
}
return(data);
}
private JArray GetGridRecords(JArray columns, int rowCount, int rowOffset)
{
var data = new JArray();
DashboardGridDataSelectBuilder selectBuilder = CreateDashboardGridDataSelectBuilder(columns);
string filterData = Parameters.Value <string>("filterData");
selectBuilder.AddFilterByJson(filterData);
selectBuilder.EsqOptions = new EntitySchemaQueryOptions {
PageableRowCount = rowCount,
RowsOffset = rowOffset,
PageableDirection = PageableSelectDirection.Current,
PageableConditionValues = new Dictionary <string, object>()
};
Select select = selectBuilder.Build();
var entityColumnMap = selectBuilder.EntityColumnsMap;
using (var dbExecutor = UserConnection.EnsureDBConnection()) {
using (IDataReader dataReader = select.ExecuteReader(dbExecutor)) {
while (dataReader.Read())
{
var dataItem = new JObject();
foreach (var map in entityColumnMap)
{
object value = GetValueByColumnMap(dataReader, (Dictionary <string, object>)map.Value);
dataItem.Add(new JProperty(map.Key, value));
}
data.Add(dataItem);
}
}
}
return(data);
}
private DashboardGridDataSelectBuilder GetDashboardGridDataSelectBuilder(JArray columns, int rowCount,
int rowOffset, int serieIndex)
{
string schemaName = GetSchemaName(serieIndex);
DashboardGridDataSelectBuilder builder = CreateDashboardGridDataSelectBuilder(columns, schemaName);
builder.EsqOptions = new EntitySchemaQueryOptions {
PageableRowCount = rowCount,
RowsOffset = rowOffset,
PageableDirection = PageableSelectDirection.Current,
PageableConditionValues = new Dictionary <string, object>()
};
return(builder);
}
private void SetSerieFilter(DashboardGridDataSelectBuilder builder, JToken serieParameters, string filterValue)
{
string filterColumn = serieParameters.Value <string>("xAxisColumn");
if (filterValue != null)
{
string dateTimeFormat = Parameters.Value <string>("dateTimeFormat");
bool hasDateTimeFormat = !string.IsNullOrEmpty(dateTimeFormat);
if (hasDateTimeFormat)
{
builder.AddDatePartFilter(filterColumn, filterValue, dateTimeFormat);
}
else
{
builder.AddFilter(filterColumn, filterValue);
}
}
else
{
IEntitySchemaQueryFilterItem isNullFilter = builder.Esq.CreateIsNullFilter(filterColumn);
builder.Esq.Filters.Add(isNullFilter);
}
}
protected virtual DashboardGridDataSelectBuilder CreateSelectBuilder(JArray columns)
{
selectBuilder = new DashboardGridDataSelectBuilder(UserConnection, GetSchemaName(), TimeZoneOffset, columns);
return(selectBuilder);
}
