private bool CheckCapture(SAPbouiCOM.Form form)
{
try
{
var q = from a in db.CCTRANs
where a.customerID == PMCustID &&
a.command == "cc:authonly" &&
a.recDate > (DateTime.Today.AddDays(-30)) &&
!db.CCTRANs.Any(a2 => (a2.refNum == a.refNum) && (a2.command == "cc:capture"))
select a;
if (q.Count() == 0)
{
return(false);
}
foreach (CCTRAN t in q)
{
if (double.Parse(t.amount) == getItemDoubleValue(theActiveForm, fidBalance))
{
preauthCCTRAN = t;
return(true);
}
}
}catch (Exception ex)
{
errorLog(ex);
}
return(false);
}
private void job_logCustomTransaction(CustomerTransactionRequest req, TransactionResponse resp, SAPCust sapcust, CCJOB job, string InvoiceID = "")
{
CCTRAN cctran = new CCTRAN();
try
{
if (job.OrderID == null)
job.OrderID = 0;
if (job.InvoiceID == null)
job.InvoiceID = 0;
cctran.customerID = sapcust.cccust.CustomerID;
cctran.CCAccountID = 0;
cctran.jobID = (int)job.jobID;
cctran.OrderID = job.OrderID.ToString();
cctran.InvoiceID = InvoiceID;
cctran.CreditMemoID = "";
cctran.DownPaymentInvoiceID = "";
if (sapcust != null)
{
try
{
cctran.CCAccountID = int.Parse(sapcust.cccust.CCAccountID);
cctran.customerID = sapcust.cccust.CustomerID;
cctran.MethodID = sapcust.custObj.PaymentMethodProfiles[0].MethodID;
cctran.custNum = sapcust.cccust.CustNum;
cctran.crCardNum = sapcust.custObj.PaymentMethodProfiles[0].CardNumber;
cctran.CardHolder = sapcust.custObj.BillingAddress.FirstName + " " + sapcust.custObj.BillingAddress.LastName;
}catch(Exception ex)
{
errorLog(ex);
}
}
cctran.Description = req.Details.Description;
cctran.recID = req.Details.Invoice;
cctran.acsUrl = resp.AcsUrl;
cctran.authAmount = resp.AuthAmount.ToString();
cctran.authCode = resp.AuthCode;
cctran.avsResult = resp.AvsResult;
cctran.avsResultCode = resp.AvsResultCode;
cctran.batchNum = resp.BatchNum;
cctran.batchRef = resp.BatchRefNum;
cctran.cardCodeResult = resp.CardCodeResult;
cctran.cardCodeResultCode = resp.CardCodeResultCode;
cctran.cardLevelResult = resp.CardLevelResult;
cctran.cardLevelResultCode = resp.CardLevelResultCode;
cctran.conversionRate = resp.ConversionRate.ToString();
cctran.convertedAmount = resp.ConvertedAmount.ToString();
cctran.convertedAmountCurrency = resp.ConvertedAmountCurrency.ToString();
cctran.custNum = resp.CustNum;
cctran.error = resp.Error;
cctran.errorCode = resp.ErrorCode;
cctran.isDuplicate = resp.isDuplicate.ToString();
cctran.payload = resp.Payload;
cctran.profilerScore = resp.ProfilerScore;
cctran.profilerResponse = resp.ProfilerResponse;
cctran.profilerReason = resp.ProfilerReason;
cctran.refNum = resp.RefNum;
cctran.remainingBalance = resp.RemainingBalance.ToString();
cctran.result = resp.Result;
cctran.resultCode = resp.ResultCode;
cctran.status = resp.Status;
cctran.statusCode = resp.StatusCode;
cctran.vpasResultCode = resp.VpasResultCode;
cctran.recDate = DateTime.Now;//Use local time not server time
cctran.command = req.Command;
cctran.amount = req.Details.Amount.ToString();
insert(cctran);
}
catch (Exception ex)
{
errorLog(ex);
}
}
private void logTransaction(TransactionRequestObject req, TransactionResponse resp)
{
string sql = "";
try
{
string cardLastFour = "";
try
{
if (req.CreditCardData.CardNumber == null)
{
cardLastFour = "";
}
else
{
cardLastFour = req.CreditCardData.CardNumber.Substring(req.CreditCardData.CardNumber.Length - 4);
}
}catch (Exception)
{}
db.CommandTimeout = 30000;
CCTRAN cctran = new CCTRAN();
cctran.customerID = req.CustomerID;
cctran.customerName = req.BillingAddress.Company;
cctran.crCardNum = cardLastFour;
cctran.Description = req.Details.Description;
cctran.recID = req.Details.Invoice;
cctran.acsUrl = resp.AcsUrl;
cctran.authAmount = resp.AuthAmount.ToString();
cctran.authCode = resp.AuthCode;
cctran.avsResult = resp.AvsResult;
cctran.avsResultCode = resp.AvsResultCode;
cctran.batchNum = resp.BatchNum;
cctran.batchRef = resp.BatchRefNum;
cctran.cardCodeResult = resp.CardCodeResult;
cctran.cardCodeResultCode = resp.CardCodeResultCode;
cctran.cardLevelResult = resp.CardLevelResult;
cctran.cardLevelResultCode = resp.CardLevelResultCode;
cctran.conversionRate = resp.ConversionRate.ToString();
cctran.convertedAmount = resp.ConvertedAmount.ToString();
cctran.convertedAmountCurrency = resp.ConvertedAmountCurrency.ToString();
cctran.custNum = resp.CustNum;
cctran.error = resp.Error;
cctran.errorCode = resp.ErrorCode;
cctran.isDuplicate = resp.isDuplicate.ToString();
cctran.payload = resp.Payload;
cctran.profilerScore = resp.ProfilerScore;
cctran.profilerResponse = resp.ProfilerResponse;
cctran.profilerReason = resp.ProfilerReason;
cctran.refNum = resp.RefNum;
cctran.remainingBalance = resp.RemainingBalance.ToString();
cctran.result = resp.Result;
cctran.resultCode = resp.ResultCode;
cctran.status = resp.Status;
cctran.statusCode = resp.StatusCode;
cctran.vpasResultCode = resp.VpasResultCode;
cctran.recDate = DateTime.Now;//Use local time not server time
cctran.command = req.Command;
cctran.amount = req.Details.Amount.ToString();
db.CCTRANs.InsertOnSubmit(cctran);
db.SubmitChanges();
}catch (Exception ex)
{
errorLog(ex);
errorLog(sql);
}
}
private void logCustomTransaction(string id, string cardcode)
{
try
{
TransactionResponse resp = transObjForImport.Response;
CCTRAN cctran = new CCTRAN();
cctran.OrderID = id;
cctran.InvoiceID = "";
cctran.CreditMemoID = "";
cctran.customerID = cardcode;
cctran.MethodID = "";
cctran.custNum = "";
string currency = getCurrency("ORDR", id);
string group = getGroupName(cardcode);
string cardtype = transObjForImport.CreditCardData.CardType;
string acctid = "";
string cardName = getCardName(group, cardtype, currency, ref acctid);
cctran.CCAccountID = int.Parse(acctid);
cctran.crCardNum = transObjForImport.CreditCardData.CardNumber;
cctran.Description = transObjForImport.Details.Description;
cctran.recID = transObjForImport.Details.Invoice;
cctran.acsUrl = resp.AcsUrl;
cctran.authAmount = resp.AuthAmount.ToString();
cctran.authCode = resp.AuthCode;
cctran.avsResult = resp.AvsResult;
cctran.avsResultCode = resp.AvsResultCode;
cctran.batchNum = resp.BatchNum;
cctran.batchRef = resp.BatchRefNum;
cctran.cardCodeResult = resp.CardCodeResult;
cctran.cardCodeResultCode = resp.CardCodeResultCode;
cctran.cardLevelResult = resp.CardLevelResult;
cctran.cardLevelResultCode = resp.CardLevelResultCode;
cctran.conversionRate = resp.ConversionRate.ToString();
cctran.convertedAmount = resp.ConvertedAmount.ToString();
cctran.convertedAmountCurrency = resp.ConvertedAmountCurrency.ToString();
cctran.custNum = resp.CustNum;
cctran.error = resp.Error;
cctran.errorCode = resp.ErrorCode;
cctran.isDuplicate = resp.isDuplicate.ToString();
cctran.payload = resp.Payload;
cctran.profilerScore = resp.ProfilerScore;
cctran.profilerResponse = resp.ProfilerResponse;
cctran.profilerReason = resp.ProfilerReason;
cctran.refNum = resp.RefNum;
cctran.remainingBalance = resp.RemainingBalance.ToString();
cctran.result = resp.Result;
cctran.resultCode = resp.ResultCode;
cctran.status = resp.Status;
cctran.statusCode = resp.StatusCode;
cctran.vpasResultCode = resp.VpasResultCode;
cctran.recDate = DateTime.Now;//Use local time not server time
cctran.command = transObjForImport.TransactionType;
if (transObjForImport.TransactionType == "Auth Only")
{
cctran.command = "cc:authonly";
}
cctran.amount = transObjForImport.Details.Amount.ToString();
insert(cctran);
}
catch (Exception ex)
{
errorLog(ex);
}
}
