/*private async Task<string> GetData<T>(DataPivotRequest<T> request)
* {
* HttpClient client = new HttpClient();
* string jsonstring = JsonConvert.SerializeObject(request);
* var httpContent = new StringContent(jsonstring, Encoding.UTF8, "application/JSON");
* var response = await client.PostAsync(request.DataSourceURL, httpContent);
*
* var responseString = await response.Content.ReadAsStringAsync();
* return responseString;
* }*/
public DataPivotResponse <ICollection> CacheData <T>(ICollection data, DataPivotRequest <T> request)
{
var response = new DataPivotResponse <ICollection>();
if (string.IsNullOrEmpty(request.GridGuid))
{
request.GridGuid = Guid.NewGuid().ToString();
}
//Now try to store the
try
{
_cache.Set(request.GridGuid, data, new MemoryCacheEntryOptions
{
Priority = CacheItemPriority.Normal,
SlidingExpiration = TimeSpan.FromHours(8)
});
//response.Data = data;
response.GridId = request.GridGuid;
}
catch (Exception e)
{
_logger.LogError(e, "Error Storing Grid cache data");
response.State = ResponseState.Error;
response.Messages.Add(e.Message);
}
return(response);
}
public DataPivotResponse <DataTable> GetPivotDataV2 <T>(DataPivotRequest <object> request)
{
DataPivotResponse <DataTable> gridData = new DataPivotResponse <DataTable>();
gridData.GridId = request.GridGuid;
if ((request?.ColumnHeaders?.Count ?? 0) > 0)
{
gridData.HeaderMetaData = _metaDataHelper.GetColumnsMetaData(request.ColumnHeaders);
}
DataTable data = _pivotRepository.ExtractRawDataFromCube(this.cubeCacheServerUrl, request);
gridData.Data = data;
gridData.TotalDataCount = data?.Rows?.Count ?? 0;
gridData.GridId = request.GridGuid;
return(gridData);
}
public DataPivotResponse <ICollection> GetPivotData <T>(DataPivotRequest <T> request)
{
DataPivotResponse <ICollection> gridData = new DataPivotResponse <ICollection>();
gridData.GridId = request.GridGuid;
gridData.Data = new List <Dictionary <string, object> >();
if (request.ColumnHeaders.Count > 0)
{
gridData.HeaderMetaData = _metaDataHelper.GetColumnsMetaData(request.ColumnHeaders);
}
if (!string.IsNullOrWhiteSpace(request.AlwaysGroupOnColumn))
{
if (request.RequestModel.rowGroupCols.Count > 0)
{
if (request.RequestModel.rowGroupCols[request.RequestModel.rowGroupCols.Count - 1].field != request.AlwaysGroupOnColumn)
{
return(gridData);
}
}
else
{
return(gridData);
}
}
List <Dictionary <string, object> > data = _pivotRepository.ExtractDataFromCube(request);
int PageIndex = (request.RequestModel.endRow) / (request.RequestModel.endRow - request.RequestModel.startRow);
int PageSize = (request.RequestModel.endRow - request.RequestModel.startRow);
var queryResult = data.AsEnumerable();
if (request.RequestModel.sortModel != null && request.RequestModel.sortModel.Count > 0)
{
queryResult = Sort(queryResult, string.Join(",", request.RequestModel.sortModel.Select(s => s.ToString())));
}
/*if (request.RequestModel.sortModel != null && request.RequestModel.sortModel.Count > 0)
* {
* try
* {
* queryResult = queryResult.OrderBy(string.Join(",", request.RequestModel.sortModel.Select(s => s.ToString())));
* }
* catch (Exception ex)
* {
* //ignore as the grid layout might change and the previsouly-sorted-by column might not exist at all.
* }
* }*/
if (queryResult.Count() > 0)
{
gridData.Data = queryResult.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToDynamicList();
gridData.TotalDataCount = queryResult.Count();
}
else
{
gridData.Data = queryResult.ToDynamicList();
gridData.TotalDataCount = queryResult.Count();
}
gridData.GridId = request.GridGuid;
return(gridData);
/*Task<string> result = GetData(request);
* result.Wait();
* string data = result.Result;
* int PageIndex = (request.RequestModel.endRow) / (request.RequestModel.endRow - request.RequestModel.startRow);
* int PageSize = (request.RequestModel.endRow - request.RequestModel.startRow);
* //use the cache instead.
* DataPivotResponse<ICollection> gridData = JsonConvert.DeserializeObject<DataPivotResponse<ICollection>>(data);
* int a = 0;
* ICollection pivotData;
* if (_cache.TryGetValue(gridData.GridId, out pivotData))
* {
* var queryResult = GenerateFilterQuery(pivotData, request.RequestModel.filterModel);
* if (request.RequestModel.sortModel != null && request.RequestModel.sortModel.Count > 0)
* {
* try
* {
* queryResult = queryResult.OrderBy(string.Join(",", request.RequestModel.sortModel.Select(s => s.ToString())));
* }
* catch (Exception ex)
* {
* //ignore as the grid layout might change and the previsouly-sorted-by column might not exist at all.
* }
* }
* if (queryResult.Count() > 0)
* {
* gridData.Data = queryResult.Skip((PageIndex - 1) * PageSize).Take(PageSize).ToDynamicList();
* gridData.TotalDataCount = queryResult.Count();
*
* }
* else
* {
* gridData.Data = queryResult.ToDynamicList();
* gridData.TotalDataCount = queryResult.Count();
*
* }
* gridData.GridId = request.GridGuid;
*
* }
* return gridData;*/
//var response = new DataPivotResponse<ICollection>();
//string CacheKey=_pivotCacheRepository.GetCacheKey(request.Filters,request.MDXProcedure);
//string TableName = _pivotCacheRepository.GetCachTable(CacheKey,PivotMode.SERVER);
//List<string> secondaryColumnFields = null;
//if (TableName != null)
//{
// secondaryColumnFields = _pivotCacheRepository.GetSecondaryColumns(TableName);
//}
//else
//{
// DataTable data=_pivotRepository.GetDataFromDB(request.FieldToProcedureParamLookup, request.MDXProcedure);
// TableName = "pvt_" + Guid.NewGuid().ToString();
// PivotData pivotData=_pivotRepository.TransformData(data, request.RequestModel);
// secondaryColumnFields = pivotData.SecondaryColumns;
// _pivotCacheRepository.CachePivotData(TableName, pivotData.Data,pivotData.SecondaryColumns, request.RequestModel);
// _pivotCacheRepository.AddSecondaryColumns(TableName, secondaryColumnFields);
// _pivotCacheRepository.AddCachTable(CacheKey, TableName,PivotMode.SERVER);
//}
//dynamic pivotResult=_pivotCacheRepository.GetDataFromCache(TableName, secondaryColumnFields, request.RequestModel);
//response.Data = pivotResult.Data;
//response.TotlaDataCount = pivotResult.RowsCount;
//response.GridId = TableName;
//response.SecondaryColumns = secondaryColumnFields;
//return response;
/*var response = new DataPivotResponse<ICollection>();
* string CacheKey = _pivotSegmentCacheRepository.GetCacheKey(request.Filters, request.MDXProcedure,request.RequestModel);
* string CacheKeyAll = _pivotSegmentCacheRepository.GetCacheKey(request.Filters, request.MDXProcedure, request.FieldToProcedureParamLookup, request.RequestModel);
*
* string TableName = _pivotSegmentCacheRepository.GetCachTable(CacheKey, PivotMode.SERVER);
* string TableNameAll = _pivotSegmentCacheRepository.GetCachTable(CacheKeyAll, PivotMode.SERVER);
*
* List<string> secondaryColumnFields = null;
* if(TableNameAll==null)
* {
* DataTable data = _pivotRepository.GetDataFromDB(request.FieldToProcedureParamLookup, request.MDXProcedure);
* TableNameAll = "pvt_" + Guid.NewGuid().ToString();
* PivotData pivotData = _pivotRepository.TransformData(data, request.RequestModel);
* secondaryColumnFields = pivotData.SecondaryColumns;
* _pivotSegmentCacheRepository.CachePivotData(TableNameAll, pivotData.Data, pivotData.SecondaryColumns, request.RequestModel);
* _pivotSegmentCacheRepository.AddSecondaryColumns(TableNameAll, secondaryColumnFields);
* _pivotSegmentCacheRepository.AddCachTable(CacheKeyAll, TableNameAll, PivotMode.SERVER);
* }
* if (TableName != null)
* {
* secondaryColumnFields = _pivotSegmentCacheRepository.GetSecondaryColumns(TableName);
* }
* else
* {
* List<MDXParam> Params = new List<MDXParam>();
* if (request.RequestModel.pivotCols.Count > 0)
* {
* List<MDXParam> res = request.FieldToProcedureParamLookup.Where(x => x.FieldName.Equals(request.RequestModel.pivotCols[0].field,StringComparison.CurrentCultureIgnoreCase)).ToList<MDXParam>();
* Params.AddRange(res);
* }
*
* foreach(PivotColumn pc in request.RequestModel.rowGroupCols)
* {
* List<MDXParam> param = request.FieldToProcedureParamLookup.Where(x => x.FieldName.Equals(pc.field, StringComparison.CurrentCultureIgnoreCase)).ToList<MDXParam>();
* Params.AddRange(param);
* }
* DataTable data = _pivotRepository.GetDataFromDB(Params, request.MDXProcedure);
* TableName = "pvt_" + Guid.NewGuid().ToString();
* PivotData pivotData = _pivotRepository.TransformData(data, request.RequestModel);
* secondaryColumnFields = pivotData.SecondaryColumns;
* _pivotSegmentCacheRepository.CachePivotData(TableName, pivotData.Data, pivotData.SecondaryColumns, request.RequestModel);
* _pivotSegmentCacheRepository.AddSecondaryColumns(TableName, secondaryColumnFields);
* _pivotSegmentCacheRepository.AddCachTable(CacheKey, TableName, PivotMode.SERVER);
* }
* dynamic pivotResult = _pivotSegmentCacheRepository.GetDataFromCache(TableName, secondaryColumnFields, request.RequestModel);
* response.Data = pivotResult.Data;
* response.TotlaDataCount = pivotResult.RowsCount;
* response.GridId = TableNameAll;
* response.SecondaryColumns = secondaryColumnFields;
* return response;*/
return(null);
}
