public List <TempModel> GetEST_Manufacturers(IQueryBuilder queryBuilder) //List<BAM_Manufacturer>
{
var dataExport = _estService.GetExportData(queryBuilder);
var modelDescriptions = dataExport.NewItemList.DistinctBy(x => x.Asset_Desc).Select(x => new TempModel {
ModelName = x.Asset_Desc
}).ToList();
//modelDescriptions.AddRange(dataExport.AssetTagChangeList.DistinctBy(x => x.Audit_Prod_Desc).Select(x => new TempModel { ModelName = x.Audit_Prod_Desc }).ToList());
//modelDescriptions.AddRange(dataExport.DeployedToBAMUserList.DistinctBy(x => x.Audit_Prod_Desc).Select(x => new TempModel { ModelName = x.Audit_Prod_Desc }).ToList());
//modelDescriptions.AddRange(dataExport.RetiredAssetList.DistinctBy(x => x.Audit_Prod_Desc).Select(x => new TempModel { ModelName = x.Audit_Prod_Desc }).ToList());
//modelDescriptions.AddRange(dataExport.ReturnedFromBAMList.DistinctBy(x => x.Audit_Prod_Desc).Select(x => new TempModel { ModelName = x.Audit_Prod_Desc }).ToList());
//modelDescriptions.AddRange(dataExport.SwappedAssetList.DistinctBy(x => x.Audit_Prod_Desc).Select(x => new TempModel { ModelName = x.Audit_Prod_Desc }).ToList());
return(modelDescriptions);
}
private List <SCAudit> GetAll_BaseQuery()
{
var returnValue = new EST_DataExportModel();
returnValue = _eST_Service.GetExportData(_queryBuilder);
if (returnValue.Any())
{
returnValue = returnValue
.Where
(
item => item.Audit_Part_Num.ToUpper().StartsWith("BNL") &&
item.Audit_Rem.StartsWith("Added PO") &&
(item.Audit_Dest_Site_Num.ToUpper().StartsWith("E-") || item.Audit_Dest_Site_Num.ToUpper() == "LTX")
)
.ToList();
}
return(returnValue);
}
public async Task <EST_DataExportModel> ExportDataToBAM(IQueryBuilder queryBuilder, int jobType)
{
_progressReport.StartDateTime = DateTime.Now;
_progressReport.ServiceJobType = jobType;
_progressReport = _reportingService.ServiceProgressReporting(_progressReport);
// Query, cleanse and subset the data
//if (_dataExport == null)
var _dataExport = _estService.GetExportData(queryBuilder);
queryBuilder = _estService._queryBuilder;
_progressReport.EsteemExtractDateTime = DateTime.Now;
_progressReport.QueryStartParameters = queryBuilder.StartDate;
_progressReport.QueryEndParameters = queryBuilder.EndDate;
_progressReport.QueryString = queryBuilder.LastQueryString;
_progressReport = _reportingService.ServiceProgressReporting(_progressReport);
// Process the Data
var newItemTask = Process_NewItemList(_dataExport, _progressReport);
var locationTask = Process_LocationChangeList(_dataExport, _progressReport);
var assetTagTask = Process_AssetTagChangeList(_dataExport, _progressReport);
var deployTask = Process_DeployedToBAMUserList(_dataExport, _progressReport);
var returnNewTask = Process_ReturnedFromBAMList(_dataExport, _progressReport);
var retiredTask = Process_RetiredAssetList(_dataExport, _progressReport);
var disposedTask = Process_DisplosedAssetList(_dataExport, _progressReport);
var swappedTask = Process_SwappedAssetList(_dataExport, _progressReport);
_progressReport.NewItemCount = _dataExport?.NewItemList?.Count;
_progressReport.LocationChangeCount = _dataExport?.LocationChangeList?.Count;
_progressReport.AssetTagChangeCount = _dataExport?.AssetTagChangeList?.Count;
_progressReport.DeployedCount = _dataExport?.DeployedToBAMUserList?.Count;
_progressReport.ReturnedCount = _dataExport?.ReturnedFromBAMList?.Count;
_progressReport.RetiredCount = _dataExport?.RetiredAssetList?.Count;
_progressReport.DisposedCount = _dataExport?.DisplosedAssetList?.Count;
_progressReport.SwappedCount = _dataExport?.SwappedAssetList?.Count;
_progressReport = _reportingService.ServiceProgressReporting(_progressReport);
_dataExport = (await Task.WhenAll(
newItemTask,
assetTagTask,
deployTask,
locationTask, //returnTask,
returnNewTask,
retiredTask,
disposedTask,
swappedTask)).First();
_progressReport.BAMExportDateTime = DateTime.Now;
_progressReport = _reportingService.ServiceProgressReporting(_progressReport);
// Save any Exceptions to the BAMEsteemExportDB
await _reportingService.ProcessExceptions(_reportings);
await _reportingService.ProcessBillables(_billables);
_progressReport = _reportingService.ServiceProgressReporting(_progressReport);
_progressReport.BAMExportDateTime = DateTime.Now;
_progressReport.ExceptionCountTotal = _reportings.Count;
_progressReport.ProcessSuccessFlag = _progressReport.ExceptionCountTotal == 0 ? true : false;
if (!_progressReport.ProcessSuccessFlag && jobType == 3)
{
Email.Send(_progressReport.Id);
}
_progressReport = _reportingService.ServiceProgressReporting(_progressReport);
return(_dataExport);
}