private void PaginationPanel_OnEnabledPaginationChanged(object sender, RoutedEventArgs e)
{
if (_queryTransformer == null)
{
return;
}
// Turn paging on and off
if (PaginationPanel.IsEnabled)
{
_queryTransformer.Take(PaginationPanel.PageSize.ToString());
}
else
{
ResetPagination();
}
}
public ActionResult GetData()
{
var qb = _aqbs.Get(instanceId);
var conn = qb.MetadataProvider.Connection;
var sqlQuery = new SQLQuery(qb.SQLContext)
{
SQL = qb.ActiveUnionSubQuery.SQL
};
QueryTransformer qt = new QueryTransformer
{
QueryProvider = sqlQuery
};
qt.Take("7");
var columns = qt.Columns.Select(c => c.ResultName).ToList();
try
{
var data = DataBaseHelper.GetDataList(conn, qt.SQL);
var result = new { columns, data };
return(Json(result));
}
catch (Exception e)
{
var result = new { columns, data = new List <List <object> > {
new List <object> {
e.Message
}
} };
return(Json(result));
}
}
public ActionResult SelectRecordsCount(Param[] _params)
{
var qb = _aqbs.Get(instanceId);
var qt = _qts.Get(instanceId);
var qtForSelectRecordsCount = new QueryTransformer {
QueryProvider = qb.SQLQuery
};
try
{
qtForSelectRecordsCount.Assign(qt);
qtForSelectRecordsCount.Skip("");
qtForSelectRecordsCount.Take("");
qtForSelectRecordsCount.SelectRecordsCount("recCount");
try
{
var data = Execute(qtForSelectRecordsCount, _params);
return(Json(data.First().Values.First()));
}
catch (Exception e)
{
return(Json(new ErrorOutput {
Error = e.Message
}));
}
}
finally
{
qtForSelectRecordsCount.Dispose();
}
}
private void TimerForFastResult_Elapsed(object state)
{
Invoke((Action) delegate
{
resultGrid2.QueryTransformer = _queryTransformerTop10;
resultGrid2.FillDataGrid(_queryTransformerTop10.Take("10").SQL);
});
}
public ActionResult GetRecordCountSql([FromBody] GetRecordCountSqlModel model)
{
var qt = _qts.Get(model.InstanceId);
using (var qtForSelectRecordsCount = new QueryTransformer {
QueryProvider = qt.QueryProvider
})
{
qtForSelectRecordsCount.Assign(qt);
qtForSelectRecordsCount.Skip("");
qtForSelectRecordsCount.Take("");
qtForSelectRecordsCount.SelectRecordsCount("recCount");
return(Content(qtForSelectRecordsCount.SQL));
}
}
public ActionResult SelectRecordsCount([FromBody] Param[] _params)
{
var qb = _aqbs.Get(instanceId);
var qt = _qts.Get(instanceId);
var qtForSelectRecordsCount = new QueryTransformer {
QueryProvider = qb.SQLQuery
};
try
{
qtForSelectRecordsCount.Assign(qt);
qtForSelectRecordsCount.Skip("");
qtForSelectRecordsCount.Take("");
qtForSelectRecordsCount.SelectRecordsCount("recCount");
return(GetData(qtForSelectRecordsCount, _params));
}
finally
{
qtForSelectRecordsCount.Dispose();
}
}
private void UpdateRecordCount(QueryTransformer qt)
{
var qtForSelectRecordsCount = new QueryTransformer {
QueryProvider = qt.QueryProvider
};
try
{
qtForSelectRecordsCount.Assign(qt);
qtForSelectRecordsCount.Skip("");
qtForSelectRecordsCount.Take("");
qtForSelectRecordsCount.SelectRecordsCount("recCount");
var data = SelectRecordsCount.GetData(qtForSelectRecordsCount, new Param[0]);
_recordsCount = int.Parse(data.First().Values.First().ToString());
recordsCount.Text = "Records count: " + _recordsCount;
}
finally
{
qtForSelectRecordsCount.Dispose();
}
}
public override object GetDataForModel(Param[] _params)
{
var qb = QueryBuilderStore.Get("QueryResults");
var qt = QueryTransformerStore.Get("QueryResults");
var qtForSelectRecordsCount = new QueryTransformer {
QueryProvider = qt.QueryProvider
};
try
{
qtForSelectRecordsCount.Assign(qt);
qtForSelectRecordsCount.Skip("");
qtForSelectRecordsCount.Take("");
qtForSelectRecordsCount.SelectRecordsCount("recCount");
var data = GetData(qtForSelectRecordsCount, _params);
return(data.First().Values.First());
}
finally
{
qtForSelectRecordsCount.Dispose();
}
}
private void FillFastResult()
{
var result = _transformerSql.Take("10");
dataViewerFastResultSql.FillData(result.SQL, (SQLQuery)_transformerSql.Query);
}
