public IQueryable <DSS1_RetailerDriverStockOptimisation.BO.Statistics> Get_StockSKUStatisticForm_UnitsSKUDataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = DSS1_RetailerDriverStockOptimisation.BO.StatisticsExtensions.TotalForEachSKU(@model.WarehouseId).AsQueryable();
return(__items.Where(@this => true));
}
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Supplier> Get_SupplierListNoDT_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS5_SupplyChainFinancialsOptimisation.DAL.Repository().GetAsQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Supplier>().AsQueryable();
return(__items.Where(@this => @this.SupplierStatus == "ActiveSupplier"));
}
public string SupplierListNoDT_ExportV2Implementation(DatasourceRequest datasourceRequest, ExportOptionsV2 exportOptions, List <AggregatorInfo <DSS5_SupplyChainFinancialsOptimisation.BO.Supplier> > aggregatorsInfo)
{
var watch = System.Diagnostics.Stopwatch.StartNew();
long elapsedMilliseconds = 0;
switch (exportOptions.Range)
{
case ExportHelper.Range.ALL:
datasourceRequest.StartRow = 0;
datasourceRequest.PageSize = int.MaxValue;
break;
case ExportHelper.Range.TOP100:
datasourceRequest.StartRow = 0;
datasourceRequest.PageSize = 100;
break;
}
var queryable = Get_SupplierListNoDT_DatasourceQueryable(datasourceRequest);
var formattings = new Dictionary <string, string>();
var path = "";
var exportHelper = new ExportHelperV2 <DSS5_SupplyChainFinancialsOptimisation.BO.Supplier>(exportOptions, new Dictionary <string, Func <DSS5_SupplyChainFinancialsOptimisation.BO.Supplier, object> >
{
{ "UserName", item => item?.UserName }, { "Company", item => item?.Company }, { "Email", item => item?.Email }, { "Business", item => item?.Business }, { "SupplierStatus", item => item?.SupplierStatus },
});
if (exportHelper.Options.ColumnInfo == null)
{
exportHelper.Options.ColumnInfo = new List <ColumnOptionsV2>
{
new ColumnOptionsV2 {
Caption = BaseViewPage <object> .GetResourceValue("ActiveSuppliersList", "RES_LIST_SupplierListNoDT_COLUMN_UserName"), Formatting = "", Name = "UserName", ExcelFormat = @""
},
new ColumnOptionsV2 {
Caption = BaseViewPage <object> .GetResourceValue("ActiveSuppliersList", "RES_LIST_SupplierListNoDT_COLUMN_Company"), Formatting = "", Name = "Company", ExcelFormat = @""
},
new ColumnOptionsV2 {
Caption = BaseViewPage <object> .GetResourceValue("ActiveSuppliersList", "RES_LIST_SupplierListNoDT_COLUMN_Email"), Formatting = "", Name = "Email", ExcelFormat = @""
},
new ColumnOptionsV2 {
Caption = BaseViewPage <object> .GetResourceValue("ActiveSuppliersList", "RES_LIST_SupplierListNoDT_COLUMN_Business"), Formatting = "", Name = "Business", ExcelFormat = @""
},
new ColumnOptionsV2 {
Caption = BaseViewPage <object> .GetResourceValue("ActiveSuppliersList", "RES_LIST_SupplierListNoDT_COLUMN_SupplierStatus"), Formatting = "", Name = "SupplierStatus", ExcelFormat = @""
},
};
}
if (string.IsNullOrWhiteSpace(exportHelper.Options.Filename))
{
exportHelper.Options.Filename = "SupplierListNoDT";
}
if (datasourceRequest.GroupBy.Any())
{
var groups = DatasourceRetriever.RetrieveGrouped(datasourceRequest, queryable, q => q.UserName, aggregatorsInfo);
var aggregators = DatasourceRetriever.RetrieveGrouped(datasourceRequest, queryable, q => q.UserName, aggregatorsInfo, true);
GroupsHelper.FormatGroupedAggregators(aggregators, formattings);
watch.Stop();
elapsedMilliseconds = watch.ElapsedMilliseconds;
_logger.Info($"ExportV2 Performance: SupplierListNoDT export query with grouping and range {exportOptions.Range} took {elapsedMilliseconds}ms");
watch.Restart();
path = exportHelper.Export(groups, aggregators);
watch.Stop();
elapsedMilliseconds += watch.ElapsedMilliseconds;
_logger.Info($"ExportV2 Performance: SupplierListNoDT export to excel with grouping and range {exportOptions.Range} took {watch.ElapsedMilliseconds}ms");
}
else
{
var items = DatasourceRetriever.Retrieve(datasourceRequest, queryable);;
var aggregators = RuntimePredicateBuilder.BuildAggregatorPredicates(aggregatorsInfo);
foreach (var a in aggregators)
{
var formatting = formattings.ContainsKey(a.Column) ? formattings[a.Column] : null;
a.Calculate(queryable, formatting);
}
var loadedItems = items.ToList();
watch.Stop();
elapsedMilliseconds = watch.ElapsedMilliseconds;
_logger.Info($"ExportV2 Performance: SupplierListNoDT export query with range {exportOptions.Range} took {elapsedMilliseconds}ms");
watch.Restart();
path = exportHelper.Export(loadedItems, aggregators);
watch.Stop();
elapsedMilliseconds += watch.ElapsedMilliseconds;
_logger.Info($"ExportV2 Performance: SupplierListNoDT export to excel with range {exportOptions.Range} took {elapsedMilliseconds}ms");
}
var content = System.IO.File.ReadAllBytes(Path.Combine(Path.GetTempPath(), path));
var fileName = Path.GetFileName(path);
var downloadKey = FileHelper.PendingDownloadInstance.Add("ActiveSuppliersList", content, fileName);
_logger.Info($"ExportV2 Performance: Total export time for SupplierListNoDT: {elapsedMilliseconds}ms");
return(downloadKey);
}
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Order> Get_InvestorOrdersList_OrderDataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS5_SupplyChainFinancialsOptimisation.DAL.Repository().GetAsQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Order>().AsQueryable();
return(__items.Where(@this => true));
}
/*<Datasource:UserPreferences_LocaleBoxDataSet:1/>*/
/*<DataSourceFilter:UserPreferences_LocaleBoxDataSet:2/>*/
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationLanguage> Get_UserPreferences_LocaleBoxDataSet_DatasourceQueryable(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
if (shouldEvict)
{
@model?.Evict();
}
var __items = Get_UserPreferences_LocaleBoxDataSet_DatasourceQueryableImplementation(__request);
return(__items);
}
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Invoice> Get_TestingForm_InvoiceDataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = DSS5_SupplyChainFinancialsOptimisation.BO.InvoiceExtensions.FindAgreement().AsQueryable();
return(__items.Where(@this => true));
}
/*<Datasource:LetterOfCreditListNoDT:1/>*/
/*<DataSourceFilter:LetterOfCreditListNoDT:2/>*/
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.LetterOfCredit> Get_LetterOfCreditListNoDT_DatasourceQueryable(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
if (shouldEvict)
{
@model?.Evict();
}
var __items = Get_LetterOfCreditListNoDT_DatasourceQueryableImplementation(__request);
return(__items);
}
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationPermission> Get_ManageOperation_Button2DataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS3_LogisticsPoolingForUrbanDistribution.DAL.Repository().GetAsQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationPermission>().AsQueryable();
return(__items);
}
/*<Datasource:DropdownBox:1/>*/
/*<Datasource:DropdownBox1:1/>*/
/*<Datasource:DropdownBox2:1/>*/
/*<Datasource:ProofOfDeliveryForm_SelectOrder:1/>*/
/*<DataSourceFilter:ProofOfDeliveryForm_SelectOrder:2/>*/
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Order> Get_ProofOfDeliveryForm_SelectOrder_DatasourceQueryable(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
if (shouldEvict)
{
@model?.Evict();
}
var __items = Get_ProofOfDeliveryForm_SelectOrder_DatasourceQueryableImplementation(__request);
return(__items);
}
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Transaction> Get_InvestorTransactionsList_TransactionDataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS5_SupplyChainFinancialsOptimisation.DAL.Repository().GetAsQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Transaction>().AsQueryable();
var _var0 = @model.InvestorUsername;
return(__items.Where(@this => @this.CommercialAgreement.Agreement.Investor.UserName == _var0));
}
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.MapPoint> Get_TrackingMapForm_MapPointDataset_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = model?.MapPoints?.AsQueryable();
if (__items == null)
{
return(new List <DSS5_SupplyChainFinancialsOptimisation.BO.MapPoint>().AsQueryable());
}
return(__items.Where(@this => true));
}
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationOperation> Get_OperationsList_List1DataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationOperation>().AsQueryable();
return(__items.Where(@this => true));
}
/*<Datasource:OperationsList_List1DataSet:1/>*/
/*<DataSourceFilter:OperationsList_List1DataSet:2/>*/
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationOperation> Get_OperationsList_List1DataSet_DatasourceQueryable(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
if (shouldEvict)
{
@model?.Evict();
}
var __items = Get_OperationsList_List1DataSet_DatasourceQueryableImplementation(__request);
// Predefined Ordering
if (!__request.OrderBy.Any() && !__request.GroupBy.Any())
{
__items = __items.OrderBy(@this => @this.ParentControllerName != null ? @this.ParentControllerName : null)
;
}
return(__items);
}
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationOperation> Get_Table_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS5_SupplyChainFinancialsOptimisation.DAL.Repository().GetAsQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationOperation>().AsQueryable();
return(__items.Where(@this => true));
}
/*<Datasource:RolesList_List1DataSet:1/>*/
/*<DataSourceFilter:RolesList_List1DataSet:2/>*/
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationRole> Get_RolesList_List1DataSet_DatasourceQueryable(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
if (shouldEvict)
{
@model?.Evict();
}
var __items = Get_RolesList_List1DataSet_DatasourceQueryableImplementation(__request);
return(__items);
}
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Order> Get_ProofOfDeliveryForm_SelectOrder_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS5_SupplyChainFinancialsOptimisation.DAL.Repository().GetAsQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Order>().AsQueryable();
var _var0 = @model.ProofOfDelivery?.Transaction?.Id;
return(__items.Where(@this => @this.Transaction.Id == _var0));
}
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationRole> Get_RolesList_List1DataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS2_SynchromodalityCapacityOptimisation.DAL.Repository().GetAsQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationRole>().AsQueryable();
return(__items);
}
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.TurnoverStatistic> Get_TurnoverForm_TurnoverStatisticDataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = DSS5_SupplyChainFinancialsOptimisation.BO.TurnoverStatisticExtensions.GetTurnoverStatisticsForSupplier(@model.Supplier).AsQueryable();
return(__items.Where(@this => true));
}
/*<Datasource:CCDForm_TransactionDataSource:1/>*/
/*<DataSourceFilter:CCDForm_TransactionDataSource:2/>*/
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Transaction> Get_CCDForm_TransactionDataSource_DatasourceQueryable(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
if (shouldEvict)
{
@model?.Evict();
}
var __items = Get_CCDForm_TransactionDataSource_DatasourceQueryableImplementation(__request);
return(__items);
}
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationSetting> Get_ApplicationSettingsList_List1DataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS4_ECompliance.DAL.Repository().GetAsQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationSetting>().AsQueryable();
return(__items);
}
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.LetterOfCredit> Get_LetterOfCreditList_LetterOfCredit_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS5_SupplyChainFinancialsOptimisation.DAL.Repository().GetAsQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.LetterOfCredit>().AsQueryable();
var _var0 = zAppDev.DotNet.Framework.Identity.IdentityHelper.GetCurrentUserName();
return(__items.Where(@this => @this.Transaction.Supplier.UserName == _var0));
}
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationPermission> Get_ManageUser_Button1DataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS5_SupplyChainFinancialsOptimisation.DAL.Repository().GetAsQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationPermission>().AsQueryable();
return(__items);
}
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Order> Get_InvestorOrdersList_InvestorOrderDataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = DSS5_SupplyChainFinancialsOptimisation.BO.OrderExtensions.FindAgreement().AsQueryable();
return(__items.Where(@this => @this.Transaction.Supplier.Roles.Any((a) => a.Name == "ActiveSupplier")));
}
/*<Datasource:Button2:1/>*/
/*<DataSourceFilter:Button2:2/>*/
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationRole> Get_Button2_DatasourceQueryable(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
if (shouldEvict)
{
@model?.Evict();
}
var __items = Get_Button2_DatasourceQueryableImplementation(__request);
if (__request.ExcludeKeys != null && __request.ExcludeKeys.Any())
{
var keysToExclude = __request.ExcludeKeys.Select(x => x.ToString());
__items = __items.Where(x => !keysToExclude.Contains(x.Id.ToString()));
}
return(__items);
}
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationLanguage> Get_UserPreferences_LocaleBoxDataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = zAppDev.DotNet.Framework.Identity.ProfileHelper.GetAllAvailableLanguages().AsQueryable();
return(__items.Where(@this => true));
}
public IQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationRole> Get_ManageUser_Button2DataSet_DatasourceQueryableImplementation(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
var __items = new DSS1_RetailerDriverStockOptimisation.DAL.Repository().GetAsQueryable <zAppDev.DotNet.Framework.Identity.Model.ApplicationRole>().AsQueryable();
return(__items);
}
public string SupplierListNoDT_ExportImplementation(DatasourceRequest datasourceRequest, ExportHelper.ExportOptions exportOptions, List <AggregatorInfo <DSS5_SupplyChainFinancialsOptimisation.BO.Supplier> > aggregatorsInfo)
{
if (exportOptions.Range == ExportHelper.Range.TOP100)
{
datasourceRequest.StartRow = 0;
datasourceRequest.PageSize = 100;
}
else if (exportOptions.Range == ExportHelper.Range.ALL)
{
datasourceRequest.StartRow = 0;
datasourceRequest.PageSize = int.MaxValue;
}
if (string.IsNullOrWhiteSpace(exportOptions.Filename))
{
exportOptions.Filename = "SupplierListNoDT";
}
if (exportOptions.ColumnOptions == null)
{
exportOptions.ColumnOptions = new List <ExportHelper.ColumnOptions>
{
new ExportHelper.ColumnOptions {
Column = "UserName", IsVisible = true
},
new ExportHelper.ColumnOptions {
Column = "Company", IsVisible = true
},
new ExportHelper.ColumnOptions {
Column = "Email", IsVisible = true
},
new ExportHelper.ColumnOptions {
Column = "Business", IsVisible = true
},
new ExportHelper.ColumnOptions {
Column = "SupplierStatus", IsVisible = true
},
};
}
var queryable = Get_SupplierListNoDT_DatasourceQueryable(datasourceRequest);
var totalRows = DatasourceRetriever.ApplyDynamicFilterToQueryable(datasourceRequest, queryable).Count();
var items = DatasourceRetriever.Retrieve(datasourceRequest, queryable);;
var dto = items.Select(i => new SupplierDataSet_SupplierDTO(i));
var formattings = new Dictionary <string, string>();
var aggregators = RuntimePredicateBuilder.BuildAggregatorPredicates(aggregatorsInfo);
foreach (var a in aggregators)
{
var formatting = formattings.ContainsKey(a.Column) ? formattings[a.Column] : null;
a.Calculate(queryable, formatting);
}
var exportDataDTO = new List <ExportHelper.ExportRecordDTO>();
foreach (var record in dto)
{
var recordDTO = new ExportHelper.ExportRecordDTO();
recordDTO.Columns.Add(new ExportHelper.ExportColumnDTO
{
ColumnName = nameof(record.UserName),
Value = record?.UserName,
ColumnDataType = "string",
Format = "",
ExcelFormat = @"",
Caption = BaseViewPage <object> .GetResourceValue("ActiveSuppliersList", "RES_LIST_SupplierListNoDT_COLUMN_UserName")
});
recordDTO.Columns.Add(new ExportHelper.ExportColumnDTO
{
ColumnName = nameof(record.Company),
Value = record?.Company,
ColumnDataType = "string",
Format = "",
ExcelFormat = @"",
Caption = BaseViewPage <object> .GetResourceValue("ActiveSuppliersList", "RES_LIST_SupplierListNoDT_COLUMN_Company")
});
recordDTO.Columns.Add(new ExportHelper.ExportColumnDTO
{
ColumnName = nameof(record.Email),
Value = record?.Email,
ColumnDataType = "string",
Format = "",
ExcelFormat = @"",
Caption = BaseViewPage <object> .GetResourceValue("ActiveSuppliersList", "RES_LIST_SupplierListNoDT_COLUMN_Email")
});
recordDTO.Columns.Add(new ExportHelper.ExportColumnDTO
{
ColumnName = nameof(record.Business),
Value = record?.Business,
ColumnDataType = "string",
Format = "",
ExcelFormat = @"",
Caption = BaseViewPage <object> .GetResourceValue("ActiveSuppliersList", "RES_LIST_SupplierListNoDT_COLUMN_Business")
});
recordDTO.Columns.Add(new ExportHelper.ExportColumnDTO
{
ColumnName = nameof(record.SupplierStatus),
Value = record?.SupplierStatus,
ColumnDataType = "string",
Format = "",
ExcelFormat = @"",
Caption = BaseViewPage <object> .GetResourceValue("ActiveSuppliersList", "RES_LIST_SupplierListNoDT_COLUMN_SupplierStatus")
});
exportDataDTO.Add(recordDTO);
}
if (aggregators.Count > 0)
{
foreach (AggregatorType aggregatorType in Enum.GetValues(typeof(AggregatorType)))
{
var emptyAggregatorRow = true;
var recordDTO = new ExportHelper.ExportRecordDTO();
foreach (var columnOption in exportOptions.ColumnOptions)
{
var aggregatorValue = "";
switch (aggregatorType)
{
case AggregatorType.COUNT:
if (columnOption.CountIsVisible)
{
var averageAggregator = aggregators.SingleOrDefault(agg => agg.Column == columnOption.Column && agg.Type == AggregatorType.COUNT);
aggregatorValue = $"{BaseViewPage<object>.GetResourceValue("GlobalResources", "RES_DATALIST_AGGREGATORS_GrandCount")} {averageAggregator?.ValueFormatted}";
emptyAggregatorRow = false;
}
break;
case AggregatorType.SUM:
if (columnOption.SumIsVisible)
{
var averageAggregator = aggregators.SingleOrDefault(agg => agg.Column == columnOption.Column && agg.Type == AggregatorType.SUM);
aggregatorValue = $"{BaseViewPage<object>.GetResourceValue("GlobalResources", "RES_DATALIST_AGGREGATORS_GrandTotal")} {averageAggregator?.ValueFormatted}";
emptyAggregatorRow = false;
}
break;
case AggregatorType.AVERAGE:
if (columnOption.AverageIsVisible)
{
var averageAggregator = aggregators.SingleOrDefault(agg => agg.Column == columnOption.Column && agg.Type == AggregatorType.AVERAGE);
aggregatorValue += $"{BaseViewPage<object>.GetResourceValue("GlobalResources", "RES_DATALIST_AGGREGATORS_GrandAverage")} {averageAggregator?.ValueFormatted}";
emptyAggregatorRow = false;
}
break;
}
recordDTO.Columns.Add(new ExportHelper.ExportColumnDTO
{
ColumnName = columnOption.Column,
Value = aggregatorValue,
ColumnDataType = "string",
Format = ""
});
}
if (!emptyAggregatorRow)
{
exportDataDTO.Add(recordDTO);
}
}
}
var path = ExportHelper.ExportList(exportDataDTO, exportOptions, totalRows);
var content = System.IO.File.ReadAllBytes(Path.Combine(Path.GetTempPath(), path));
var fileName = Path.GetFileName(path);
return(FileHelper.PendingDownloadInstance.Add("ActiveSuppliersList", content, fileName));
}
public string List_ExportV2Implementation(DatasourceRequest datasourceRequest, ExportOptionsV2 exportOptions, List <AggregatorInfo <zAppDev.DotNet.Framework.Identity.Model.ApplicationRole> > aggregatorsInfo)
{
var watch = System.Diagnostics.Stopwatch.StartNew();
long elapsedMilliseconds = 0;
switch (exportOptions.Range)
{
case ExportHelper.Range.ALL:
datasourceRequest.StartRow = 0;
datasourceRequest.PageSize = int.MaxValue;
break;
case ExportHelper.Range.TOP100:
datasourceRequest.StartRow = 0;
datasourceRequest.PageSize = 100;
break;
}
var queryable = Get_List_DatasourceQueryable(datasourceRequest);
var formattings = new Dictionary <string, string>();
var path = "";
var exportHelper = new ExportHelperV2 <zAppDev.DotNet.Framework.Identity.Model.ApplicationRole>(exportOptions, new Dictionary <string, Func <zAppDev.DotNet.Framework.Identity.Model.ApplicationRole, object> >
{
{ "Name", item => item?.Name }, { "Description", item => item?.Description }, { "IsCustom", item => item?.IsCustom },
});
if (exportHelper.Options.ColumnInfo == null)
{
exportHelper.Options.ColumnInfo = new List <ColumnOptionsV2>
{
new ColumnOptionsV2 {
Caption = BaseViewPage <object> .GetResourceValue("RolesList", "RES_LIST_List_COLUMN_Name"), Formatting = "", Name = "Name", ExcelFormat = @""
},
new ColumnOptionsV2 {
Caption = BaseViewPage <object> .GetResourceValue("RolesList", "RES_LIST_List_COLUMN_Description"), Formatting = "", Name = "Description", ExcelFormat = @""
},
new ColumnOptionsV2 {
Caption = BaseViewPage <object> .GetResourceValue("RolesList", "RES_LIST_List_COLUMN_IsCustom"), Formatting = "", Name = "IsCustom", ExcelFormat = @""
},
};
}
if (string.IsNullOrWhiteSpace(exportHelper.Options.Filename))
{
exportHelper.Options.Filename = "List";
}
if (datasourceRequest.GroupBy.Any())
{
var groups = DatasourceRetriever.RetrieveGrouped(datasourceRequest, queryable, q => q.Id, aggregatorsInfo);
var aggregators = DatasourceRetriever.RetrieveGrouped(datasourceRequest, queryable, q => q.Id, aggregatorsInfo, true);
GroupsHelper.FormatGroupedAggregators(aggregators, formattings);
watch.Stop();
elapsedMilliseconds = watch.ElapsedMilliseconds;
_logger.Info($"ExportV2 Performance: List export query with grouping and range {exportOptions.Range} took {elapsedMilliseconds}ms");
watch.Restart();
path = exportHelper.Export(groups, aggregators);
watch.Stop();
elapsedMilliseconds += watch.ElapsedMilliseconds;
_logger.Info($"ExportV2 Performance: List export to excel with grouping and range {exportOptions.Range} took {watch.ElapsedMilliseconds}ms");
}
else
{
var items = DatasourceRetriever.Retrieve(datasourceRequest, queryable);;
var aggregators = RuntimePredicateBuilder.BuildAggregatorPredicates(aggregatorsInfo);
foreach (var a in aggregators)
{
var formatting = formattings.ContainsKey(a.Column) ? formattings[a.Column] : null;
a.Calculate(queryable, formatting);
}
var loadedItems = items.ToList();
watch.Stop();
elapsedMilliseconds = watch.ElapsedMilliseconds;
_logger.Info($"ExportV2 Performance: List export query with range {exportOptions.Range} took {elapsedMilliseconds}ms");
watch.Restart();
path = exportHelper.Export(loadedItems, aggregators);
watch.Stop();
elapsedMilliseconds += watch.ElapsedMilliseconds;
_logger.Info($"ExportV2 Performance: List export to excel with range {exportOptions.Range} took {elapsedMilliseconds}ms");
}
var content = System.IO.File.ReadAllBytes(Path.Combine(Path.GetTempPath(), path));
var fileName = Path.GetFileName(path);
var downloadKey = FileHelper.PendingDownloadInstance.Add("RolesList", content, fileName);
_logger.Info($"ExportV2 Performance: Total export time for List: {elapsedMilliseconds}ms");
return(downloadKey);
}
/*<Datasource:ActiveSuppliersList_SupplierDataSet:1/>*/
/*<DataSourceFilter:ActiveSuppliersList_SupplierDataSet:2/>*/
public IQueryable <DSS5_SupplyChainFinancialsOptimisation.BO.Supplier> Get_ActiveSuppliersList_SupplierDataSet_DatasourceQueryable(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
if (shouldEvict)
{
@model?.Evict();
}
var __items = Get_ActiveSuppliersList_SupplierDataSet_DatasourceQueryableImplementation(__request);
return(__items);
}
/*<Datasource:StockSKUStatisticForm_UnitsSKUDataSet:1/>*/
/*<DataSourceFilter:StockSKUStatisticForm_UnitsSKUDataSet:2/>*/
public IQueryable <DSS1_RetailerDriverStockOptimisation.BO.Statistics> Get_StockSKUStatisticForm_UnitsSKUDataSet_DatasourceQueryable(DatasourceRequest __request = null, bool shouldEvict = true)
{
__request = __request ?? new DatasourceRequest(0, int.MaxValue);
if (shouldEvict)
{
@model?.Evict();
}
var __items = Get_StockSKUStatisticForm_UnitsSKUDataSet_DatasourceQueryableImplementation(__request);
return(__items);
}
