private void RunProcess()
{
try
{
var _bamService = new BAM_Service();
var returnList = _bamService.ExportDataToBAM(_queryBuilder).Result;
//JSON_FileExport.WriteFile(_typePrefix + "ScheduledJob_TimeStamp", returnList.NewItemList, returnList.NewItemList.Count, "ScheduleRepeaterFinal",
// _startDateTime, _currentTime);
//var countValue = (counter + 1).ToString().PadLeft(6, '0');
//JSON_FileExport.WriteFile(_typePrefix + "_ScheduleRepeater_NewItemList" + countValue, returnList.NewItemList, returnList.NewItemList.Count, "ScheduleRepeaterFinal",
// _startDateTime, _currentTime);
//JSON_FileExport.WriteFile(_typePrefix + "_ScheduleRepeater_LocationChangeList" + countValue, returnList.LocationChangeList, returnList.LocationChangeList.Count, "ScheduleRepeaterFinal",
// _startDateTime, _currentTime);
//JSON_FileExport.WriteFile(_typePrefix + "_ScheduleRepeater_AssetTagChangeList" + countValue, returnList.AssetTagChangeList, returnList.AssetTagChangeList.Count, "ScheduleRepeaterFinal",
// _startDateTime, _currentTime);
//JSON_FileExport.WriteFile(_typePrefix + "_ScheduleRepeater_DeployedToBAMUserList" + countValue, returnList.DeployedToBAMUserList, returnList.DeployedToBAMUserList.Count, "ScheduleRepeaterFinal",
// _startDateTime, _currentTime);
//JSON_FileExport.WriteFile(_typePrefix + "_ScheduleRepeater_ReturnedFromBAMUserList" + countValue, returnList.ReturnedFromBAMUserList, returnList.ReturnedFromBAMUserList.Count, "ScheduleRepeaterFinal",
// _startDateTime, _currentTime);
}
catch (Exception exp)
{
JSON_FileExport.WriteFile(_typePrefix + "_ScheduleRepeater_Exception_" + DateTime.Now.ToString("yyMMddhhmm"), exp, 0, "Exception");
}
}
private void RunProcess()
{
try
{
var _bamService = new BAM_Service();
var returnList = _bamService.ExportDataToBAM(_queryBuilder, 4).Result;
}
catch (Exception exp)
{
JSON_FileExport.WriteFile(_typePrefix + "_ScheduleRepeater_Exception_04_" + DateTime.Now.ToString("yyMMddhhmm"), exp, 0, "Exception");
}
}
private void RunProcess()
{
try
{
var _bamService = new BAM_Service();
var reports = _dbContext.ServiceProgressReport
.Where(x => x.ProcessSuccessFlag == false && x.ServiceJobType != 2).ToList(); // && x.ServiceJobType == 3
//&& (x.EsteemExtractDateTime == null || x.BAMExportDateTime == null));
if (reports == null)
{
return;
}
var whereStatement = "";
reports.ToList().ForEach(item =>
{
var erroringAssets = _dbContext.BAM_Reporting.Where(x => x.ServiceProgressReportId == item.Id).ToList();
if (erroringAssets != null && erroringAssets.Any())
{
erroringAssets.ForEach(errorItem =>
{
whereStatement += " AND [Audit_Ser_Num] LIKE '%" + errorItem.SerialNumber + "%' ";
});
}
if (!string.IsNullOrEmpty(whereStatement))
{
_queryBuilder.StartDate = (DateTime)item.QueryStartParameters;
_queryBuilder.EndDate = _queryBuilder.StartDate.AddHours(1);
//(DateTime)item.QueryStartParameters == null || (DateTime)item.QueryStartParameters == new DateTime() ?
// _queryBuilder.StartDate.AddHours(1) : _queryBuilder.EndDate;
_queryBuilder.WhereExpression = whereStatement;
var returnList = _bamService.ExportDataToBAM(_queryBuilder, 2).Result;
}
});
}
catch (Exception exp)
{
Email.SendException(exp.Message);
JSON_FileExport.WriteFile(_typePrefix + "_ScheduleRepeater_Exception_02_" + DateTime.Now.ToString("yyMMddhhmm"), exp, 0, "Exception");
}
}
public void Final_Process_All_Data()
{
try
{
Map.Init();
IQueryBuilder queryBuilder = new QueryBuilder();
queryBuilder.StartDateString = "01/01/2017";
queryBuilder.EndDateString = "01/02/2017";
queryBuilder.PageCount = 100000000;
var service = new BAM_Service();
var records = service.ExportDataToBAM(queryBuilder).Result;
}
catch (Exception ex)
{
Assert.IsNull(ex, "ErrorMessage: " + ex.InnerException);
}
}
private void RunProcess()
{
try
{
var _bamService = new BAM_Service();
var lastProcessedDateTime = new DateTime();
//var lastProcessedReport = _dbContext.ServiceProgressReport.OrderByDescending(x => x.StartDateTime).LastOrDefault();
// In the occasion that the Current Running Process over writes the Last Entry, then we need to calculate the Time Gap
var lastProcessedReports = _dbContext.ServiceProgressReport.Where(x => x.ServiceJobType == 3)
.OrderByDescending(x => x.StartDateTime).Take(2).ToList();
if (lastProcessedReports == null && !lastProcessedReports.Any())
{
return;
}
// Incase there is only one record
if (lastProcessedReports.Count > 1)
{
// Compare the difference in times
var timeSpanGap = (DateTime)lastProcessedReports[0].StartDateTime - (DateTime)lastProcessedReports[1].StartDateTime;
// This has just been run
if (((DateTime)lastProcessedReports[0].StartDateTime).AddHours(1) >= DateTime.Now)
{
if (timeSpanGap.Hours > 1)
{
lastProcessedDateTime = (DateTime)lastProcessedReports[1].StartDateTime;
}
else
{
lastProcessedDateTime = (DateTime)lastProcessedReports[0].StartDateTime;
}
}
else
{
lastProcessedDateTime = (DateTime)lastProcessedReports[0].StartDateTime;
}
}
if (lastProcessedDateTime == null || lastProcessedDateTime == new DateTime())
{
return;
}
if (lastProcessedDateTime.AddHours(1) >= DateTime.Now)
{
return;
}
var failedTimeSpan = DateTime.Now - lastProcessedDateTime;
var count = failedTimeSpan.Hours;
_queryBuilder.StartDate = lastProcessedDateTime.AddHours(-1);
_queryBuilder.TimeRange = 1;
for (var i = 0; i < count; i++)
{
var returnList = _bamService.ExportDataToBAM(_queryBuilder, 1).Result;
_queryBuilder.StartDate = _queryBuilder.StartDate.AddHours(i);
}
}
catch (Exception exp)
{
JSON_FileExport.WriteFile(_typePrefix + "_ScheduleRepeater_01_Exception_" + DateTime.Now.ToString("yyMMddhhmm"), exp, 0, "Exception");
}
}
