private static void SaveIncident(Intertoll.Data.Incident realIncident, uspGetIncidentByLaneAndSeq_Result dbIncident, Guid staffLoginGuid, Boolean transactionExist)
{
try
{
//Insert into DB
using (var context = new PCSStagingDataContext())
{
context.Incidents.Insert(
new Incident()
{
CollectorID = dbIncident.CollectorID.HasValue ? (int)dbIncident.CollectorID : (int?)null,
Description = dbIncident.Description,
Incident_Identifier = dbIncident.Incident_Identifier.ToString(),
IncidentAckDate = realIncident.IncidentAckDate,
IncidentClearedDate = realIncident.IncidentClearedDate,
IncidentCode = dbIncident.IncidentCode,
IncidentGUID = realIncident.IncidentGUID,
IncidentSeqNr = realIncident.IncidentSeqNr,
IncidentSetDate = realIncident.IncidentSetDate,
IncidentStatusGUID = realIncident.IncidentStatusGUID,
IncidentTypeGUID = realIncident.IncidentTypeGUID,
LaneCode = dbIncident.LaneCode,
LaneSeqNr = realIncident.LaneSeqNr,
LastIncidentSeqNr = realIncident.LastIncidentSeqNr,
StaffLoginGUID = staffLoginGuid,
TimeStamp = DateTime.Now,
Transaction_Identifier = dbIncident.Transaction_Identifier.ToString(),
TransactionGUID = realIncident.TransactionGUID,
TransactionExist = transactionExist
});
context.Save();
}
}
catch (Exception ex)
{
Log.LogException(ex);
}
}
private static void SaveTransaction(Intertoll.Data.Transaction realTransaction, Intertoll.Data.ETCTransaction etcTransaction, Intertoll.Data.ETCIAuthenticator IAuthenticator, Intertoll.Data.ETCOAuthenticator OAuthenticator, uspGetTransactionByLaneAndSeq_Result dbTransaction)
{
try
{
//Insert into DB
using (var context = new PCSStagingDataContext())
{
context.Transactions.Insert(
new Transaction()
{
ANPRLicensePlate = realTransaction.ANPRLicensePlate,
AVCClass = realTransaction.AVCClassGUID.HasValue ? realTransaction.AVCClassGUID : (Guid?)null,
AVCSeqNr = realTransaction.AVCSeqNr,
AvcStatus = realTransaction.AVCDetail,
BankCardExpiryDate = dbTransaction.BankCardExpiryDate,
BankCardNumber = dbTransaction.BankCardNumber,
CollectorClass = realTransaction.ColClassGUID.HasValue ? realTransaction.ColClassGUID : (Guid?)null,
CollectorID = dbTransaction.CollectorID.HasValue ? (int)dbTransaction.CollectorID : 0,
SessionGuid = realTransaction.SessionGUID,
ContextMark = dbTransaction.ContextMark,
ContextMarkId = etcTransaction.ContextMarkId,
ETCTransactionGUID = realTransaction.ETCTransactionGuid.HasValue ? realTransaction.ETCTransactionGuid : (Guid?)null,
FrequentUserPANNumber = dbTransaction.FrequentUserPANNumber,
AccountUserGUID = realTransaction.AccountUserGUID,
IDVL = etcTransaction.IDVL,
IsKeyed = realTransaction.IsKeyed,
IssuerAuthenticator_DData = IAuthenticator.Authenticator,
IssuerAuthenticator_DMAC = dbTransaction.IssuerAuthenticator_DMAC,
IssuerAuthenticator_KRef = IAuthenticator.KeyRef,
IssuerAuthenticator_KSID = dbTransaction.IssuerAuthenticator_KSID,
IssuerAuthenticator_KV = dbTransaction.IssuerAuthenticator_KV.ToString(),
IssuerAuthenticator_MAC = IAuthenticator.Nonce,
IssuerAuthenticatorGuid = etcTransaction.IssuerAuthenticatorGuid,
LaneCode = dbTransaction.LaneCode,
LaneStatus = realTransaction.LaneStatusGUID.ToString(),
LaneTransSeqNr = realTransaction.LaneTransSeqNr,
LicensePlate = realTransaction.LicensePlate,
OperatorAuthenticator_DData = OAuthenticator.Authenticator,
OperatorAuthenticator_DMAC = dbTransaction.OperatorAuthenticator_DMAC,
OperatorAuthenticator_KRef = OAuthenticator.KeyRef,
OperatorAuthenticator_KSID = dbTransaction.OperatorAuthenticator_KSID,
OperatorAuthenticator_KV = dbTransaction.OperatorAuthenticator_MAC,
OperatorAuthenticator_MAC = OAuthenticator.Nonce,
OperatorAuthenticatorGuid = etcTransaction.OperatorAuthenticatorGuid,
PAN = etcTransaction.PAN.ToString(),
PaymentGroup = realTransaction.PaymentGroupGUID.ToString(),
PaymentMech = realTransaction.PaymentMechGUID.ToString(),
PaymentMethod = realTransaction.PaymentMethodGUID.ToString(),
PaymentType = realTransaction.PaymentTypeGUID.ToString(),
ReceiptCount = realTransaction.ReceiptCount,
ReceiptTaxInvoiceDate = realTransaction.ReceiptTaxInvoiceDate,
Shift_Identifier = dbTransaction.Shift_Identifier.HasValue ? dbTransaction.Shift_Identifier.ToString() : null,
TagClass = dbTransaction.TagClass,
TagStatus = etcTransaction.VehichleState,
TariffAmount = realTransaction.TariffAmount,
TaxInvNr = realTransaction.TaxInvNr,
TimeStamp = DateTime.Now,
Transaction_Identifier = dbTransaction.Transaction_Identifier.ToString(),
TransactionDate = realTransaction.TransDate,
TransactionStartDate = realTransaction.TransStartDate,
TransGuid = realTransaction.TransGUID,
TariffGuid = (Guid)realTransaction.TariffGUID,
TAGEFCM = dbTransaction.TAGEFCM,
TAGMAID = dbTransaction.TAGMAID,
TAGOBUID = dbTransaction.TAGOBUID
});
context.Save();
}
}
catch (Exception ex)
{
Log.LogException(ex);
}
}