static void AuditTransactions(int TransactionCount, PCSAudit _Audit, PCSDataContext _PCSContext)
{
if (TransactionCount < _Audit.TransRecordCount)
{
Log.LogInfoMessage($"About to audit transactions for lane {_Audit.Lane.LaneCode} : {_Audit.AuditDate.ToShortDateString()} : {_Audit.AuditHour}");
List <int> MissingTransactions = new List <int>();
for (int i = _Audit.TransStartSeqNumber; i <= _Audit.TransEndSeqNumber; i++)
{
int i_ = i; // avoid closure issues
if (!_PCSContext.Transactions.Any(x => x.LaneTransSeqNr == i_ && x.Session.LaneGUID == _Audit.LaneGuid))
{
Log.LogTrace($"Missing transaction: {_Audit.Lane.LaneCode} : {i}");
MissingTransactions.Add(i);
}
}
if (MissingTransactions.Count > 0)
{
Log.LogInfoMessage($"About to request {MissingTransactions.Count} transactions for lane {_Audit.Lane.LaneCode}");
TollDataRequestClient.RequestDataStatic(_Audit.Lane.LaneCode, DataTypeRequest.Transaction, MissingTransactions);
}
else
{
_Audit.TransAuditStatus = (int)AuditStatus.ValidatedCorrect;
}
}
else
{
_Audit.TransAuditStatus = (int)AuditStatus.ValidatedCorrect;
}
}
public void Execute(IJobExecutionContext context)
{
Log.LogInfoMessage("[Enter] auditing");
var HistoricalDateLimit = AuditDate.AddDays(-1 * int.Parse(ConfigurationManager.AppSettings["NumberOfDaysInThePast"]));
using (PCSDataContext PCSContext = new PCSDataContext())
{
foreach (PCSAudit audit in PCSContext.Audits.Get(x => x.TransAuditStatus == (int)AuditStatus.ValidatedIncorrect)
.Where(x => x.AuditDate >= HistoricalDateLimit)
.OrderBy(x => x.AuditDate)
.ThenBy(x => x.AuditHour)
.Take(int.Parse(ConfigurationManager.AppSettings["AuditChunkSize_Trans"])))
{
PCSAudit audit_ = audit; // avoid closure issues
DateTime StartDate = audit_.AuditDate.Date;
DateTime EndDate = audit_.AuditDate.Date.AddDays(1);
var TransactionCount = PCSContext.Transactions.Count(x => x.TransDate.Hour == audit_.AuditHour &&
x.TransDate > StartDate &&
x.TransDate < EndDate &&
x.Session.Lane.LaneGUID == audit_.LaneGuid);
AuditTransactions(TransactionCount, audit, PCSContext);
}
PCSContext.Save();
}
Log.LogInfoMessage("[Exit] auditing");
}
private static void AuditIncidents(int IncidentCount, PCSAudit _Audit, PCSDataContext _PCSContext)
{
if (IncidentCount < _Audit.IncidentRecordCount)
{
List <int> MissingIncidents = new List <int>();
for (int i = _Audit.IncidentStartSeqNumber; i <= _Audit.IncidentEndSeqNumber; i++)
{
int i_ = i; // avoid closure issues
var exists = (from inc in _PCSContext.Incidents.Where(x => x.IncidentSeqNr == i_)
join sl in _PCSContext.StaffLogins.Where() on inc.StaffLoginGUID equals sl.StaffLoginGUID
where sl.LocationGUID == _Audit.LaneGuid
select inc.IncidentGUID).Any();
if (!exists)
{
MissingIncidents.Add(i);
}
}
TollDataImportDataRequestClient.RequestDataStatic(int.Parse(_Audit.Lane.LaneCode.Substring(0, 2)), DataTypeRequest.Incident, MissingIncidents);
Log.LogInfoMessage(string.Format("Incidents missing between {0}h00 and {1}h00: {2}", _Audit.AuditHour - 1, _Audit.AuditHour, MissingIncidents.Count));
}
}
public void Execute(IJobExecutionContext context)
{
var Date = DateTime.Today;
var PreviousDay = Date.AddDays(-1 * int.Parse(ConfigurationManager.AppSettings["NumberOfDaysInThePast"]));
using (PCSDataContext PCSContext = new PCSDataContext())
{
foreach (PCSAudit audit in PCSContext.Audits.Get(x => x.TransAuditStatus == (int)AuditStatus.ValidatedIncorrect)
.Where(x => x.AuditDate >= PreviousDay && (x.Lane.LaneCode == "09MS" || x.Lane.LaneCode == "12MN"))
.OrderBy(x => x.AuditDate).ThenBy(x => x.AuditHour)
.Take(int.Parse(ConfigurationManager.AppSettings["AuditChunkSize_Trans"])))
{
Log.LogInfoMessage(string.Format("Auditing transactions {0} {1} {2}", audit.Lane.LaneCode, audit.AuditDate.ToShortDateString(), audit.AuditHour));
PCSAudit audit_ = audit; // avoid closure issues
DateTime StartDate = audit_.AuditDate.Date;
DateTime EndDate = audit_.AuditDate.Date.AddDays(1);
var TransactionCount = PCSContext.Transactions.Count(x => x.TransDate.Hour == audit_.AuditHour &&
x.TransDate > StartDate &&
x.TransDate < EndDate &&
x.Session.Lane.LaneGUID == audit_.LaneGuid);
AuditTransactions(TransactionCount, audit, PCSContext);
}
/*foreach (PCSAudit audit in PCSContext.Audits.Get(x => x.IncidentAuditStatus == (int)AuditStatus.ValidatedIncorrect)
* .Where(x => x.AuditDate >= PreviousDay)
* .OrderBy(x => x.AuditDate).ThenBy(x => x.AuditHour)
* .Take(int.Parse(ConfigurationManager.AppSettings["AuditChunkSize_Inc"])))
* {
* Log.LogInfoMessage(string.Format("Auditing incidents {0} {1} {2}", audit.Lane.LaneCode, audit.AuditDate.ToShortDateString(), audit.AuditHour));
*
* PCSAudit audit_ = audit; // avoid closure issues
* DateTime StartDate = audit_.AuditDate.Date;
* DateTime EndDate = audit_.AuditDate.Date.AddDays(1);
*
* var IncidentCount = (from i in PCSContext.Incidents.Where(x => x.IncidentSetDate.Hour == audit_.AuditHour && x.IncidentSetDate > StartDate && x.IncidentSetDate < EndDate)
* join sl in PCSContext.StaffLogins.Where() on i.StaffLoginGUID equals sl.StaffLoginGUID
* where sl.LocationGUID == audit_.LaneGuid
* select i.IncidentGUID).Count();
*
* AuditIncidents(IncidentCount, audit, PCSContext);
* }*/
}
}
/*private void AuditDateFiles(DateTime Date)
* {
* var PreviousDay = Date.PreviousDay();
*
* using (PCSAgentDataContext PCSContext = new PCSAgentDataContext())
* {
* foreach (Audit audit in PCSContext.AuditRepository.Get(x => x.TransAuditStatus != (int)AuditStatus.ValidatedCorrect || x.IncidentAuditStatus != (int)AuditStatus.ValidatedCorrect ||
* x.SessionAuditStatus != (int)AuditStatus.ValidatedCorrect || x.StaffLoginAuditStatus != (int)AuditStatus.ValidatedCorrect)
* .Where(x => x.AuditDate >= PreviousDay)
* .Take(20))
* {
* Log.LogInfoMessage(string.Format("Auditing {0} {1} {2}", audit.Lane.LaneCode, audit.AuditDate.ToShortDateString(), audit.AuditHour));
*
* Audit audit_ = audit; // avoid closure issues
* DateTime StartDate = audit_.AuditDate.Date;
* DateTime EndDate = audit_.AuditDate.Date.AddDays(1);
*
* var TransactionCount = PCSContext.TransactionRepository.Count(x => x.TransDate.Hour == audit_.AuditHour && x.TransDate > StartDate && x.TransDate < EndDate);
* var IncidentCount = PCSContext.IncidentRepository.Count(x => x.IncidentSetDate.Hour == audit_.AuditHour && x.IncidentSetDate > StartDate && x.IncidentSetDate < EndDate);
* var LoginsCount = PCSContext.StaffLoginRepository.Count(x => x.StartDate.Hour == audit_.AuditHour && x.StartDate > StartDate && x.StartDate < EndDate);
* var SessionCount = PCSContext.SessionRepository.Count(x => x.StartDate.Hour == audit_.AuditHour && x.StartDate > StartDate && x.StartDate < EndDate);
*
* AuditTransactions(TransactionCount, audit, PCSContext);
* AuditIncidents(IncidentCount, audit, PCSContext);
* AuditStaffLogins(LoginsCount, audit);
* AuditSessions(SessionCount, audit, PCSContext);
* }
*
* PCSContext.Save();
* }
* }*/
private static void AuditTransactions(int TransactionCount, PCSAudit _Audit, PCSDataContext _PCSContext)
{
if (TransactionCount < _Audit.TransRecordCount)
{
List <int> MissingTransactions = new List <int>();
for (int i = _Audit.TransStartSeqNumber; i <= _Audit.TransEndSeqNumber; i++)
{
int i_ = i; // avoid closure issues
if (!_PCSContext.Transactions.Any(x => x.LaneTransSeqNr == i_ && x.Session.LaneGUID == _Audit.LaneGuid))
{
MissingTransactions.Add(i);
}
}
TollDataImportDataRequestClient.RequestDataStatic(int.Parse(_Audit.Lane.LaneCode.Substring(0, 2)), DataTypeRequest.Transaction, MissingTransactions);
_Audit.TransAuditStatus = (int)AuditStatus.ValidatedIncorrect;
Log.LogInfoMessage(string.Format("Transactions missing between {0}h00 and {1}h00: {2}", _Audit.AuditHour - 1, _Audit.AuditHour, MissingTransactions.Count));
}
}