public override string ProcessAutoBillStatusFile(String GW, string StatusFile, out string Results, RecurringOrderMgr OrderManager)
{
String Status = AppLogic.ro_OK;
StringBuilder tmpS = new StringBuilder();
try
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(StatusFile);
String Separator = String.Empty;
foreach (XmlNode n in doc.SelectNodes("/RecurringBillingReport/TX"))
{
tmpS.Append(Separator);
String TxSubID = XmlCommon.XmlAttribute(n, "RecurringSubscriptionID");
String TxStatus = XmlCommon.XmlAttribute(n, "Status").ToUpperInvariant();
String TxMsg = XmlCommon.XmlAttribute(n, "Message");
int OrigOrdNumber = AppLogic.GetOriginalRecurringOrderNumberFromSubscriptionID(TxSubID);
tmpS.Append("Processing ID ");
tmpS.Append(TxSubID);
tmpS.Append(",");
tmpS.Append(TxStatus);
tmpS.Append("=");
try
{
String tmpStatus = String.Empty;
if (TxStatus == "APPROVED")
{
int NewOrderNumber = 0;
tmpStatus = OrderManager.ProcessAutoBillApproved(OrigOrdNumber, String.Empty, DateTime.MinValue, out NewOrderNumber);
}
else
{
tmpStatus = OrderManager.ProcessAutoBillDeclined(OrigOrdNumber, String.Empty, DateTime.MinValue, TxSubID, TxMsg);
}
if (tmpStatus == AppLogic.ro_OK)
{
// mark this one as processed ok
// TBD
}
else
{
// mark this record as not processed
// TBD
}
tmpS.Append(tmpStatus);
}
catch (Exception ex)
{
tmpS.Append(ex.Message);
}
Separator = "\n";
}
Status = AppLogic.ro_OK;
}
catch (Exception ex)
{
Status = ex.Message;
}
Results = tmpS.ToString();
return(Status);
}
public virtual String ProcessAutoBillStatusFile(String GW, String StatusFile, out String Results, RecurringOrderMgr OrderManager)
{
String Status = AppLogic.ro_OK;
Results = string.Empty;
return(Status);
}
public override string ProcessAutoBillStatusFile(String GW, string StatusFile, out string Results, RecurringOrderMgr OrderManager)
{
String Status = AppLogic.ro_OK;
StringBuilder tmpS = new StringBuilder();
try
{
XmlDocument doc = new XmlDocument();
doc.LoadXml(StatusFile);
String Separator = String.Empty;
foreach (XmlNode n in doc.SelectNodes("/RecurringBillingReport/TX"))
{
tmpS.Append(Separator);
String TxSubID = XmlCommon.XmlAttribute(n, "RecurringSubscriptionID");
String TxStatus = XmlCommon.XmlAttribute(n, "Status").ToUpperInvariant();
String TxMsg = XmlCommon.XmlAttribute(n, "Message");
String TxID = XmlCommon.XmlAttribute(n, "PNREF");
String TxTime = XmlCommon.XmlAttribute(n, "Time");
DateTime dtTx = Localization.ParseNativeDateTime(TxTime);
int OrigOrdNumber = AppLogic.GetOriginalRecurringOrderNumberFromSubscriptionID(TxSubID);
tmpS.Append("Processing ID ");
tmpS.Append(TxSubID);
tmpS.Append(",");
tmpS.Append(TxStatus);
tmpS.Append("=");
try
{
String tmpStatus = String.Empty;
if (OrigOrdNumber == 0)
{
if (dtTx.Equals(DateTime.MinValue))
{
dtTx = DateTime.Now;
}
tmpStatus = "No Original Order Found";
if (TxID.Length != 0)
{
tmpStatus += ", PNREF=" + TxID;
}
DB.ExecuteSQL("insert into FailedTransaction(CustomerID,OrderNumber,IPAddress,OrderDate,PaymentGateway,PaymentMethod,TransactionCommand,TransactionResult,CustomerEMailed,RecurringSubscriptionID) values(" +
"0,0,'0.0.0.0'," + DB.DateQuote(dtTx) + "," + DB.SQuote(GW) + "," +
DB.SQuote(AppLogic.TransactionTypeEnum.RECURRING_AUTO.ToString()) + "," + DB.SQuote(AppLogic.ro_NotApplicable) + "," + DB.SQuote(tmpStatus) + ",0," + DB.SQuote(TxSubID) + ")");
}
else
{
if (TxStatus == "APPROVED")
{
int NewOrderNumber = 0;
tmpStatus = OrderManager.ProcessAutoBillApproved(OrigOrdNumber, TxID, dtTx, out NewOrderNumber);
}
else
{
tmpStatus = OrderManager.ProcessAutoBillDeclined(OrigOrdNumber, TxID, dtTx, TxSubID, TxMsg);
}
if (tmpStatus == AppLogic.ro_OK)
{
// mark this one as processed ok
// TBD
}
else
{
// mark this record as not processed
// TBD
int ProcessCustomerID = Order.GetOrderCustomerID(OrigOrdNumber);
Customer ProcessCustomer = new Customer(ProcessCustomerID, true);
if (dtTx.Equals(DateTime.MinValue))
{
dtTx = DateTime.Now;
}
if (TxID.Length != 0)
{
tmpStatus += ", PNREF=" + TxID;
}
DB.ExecuteSQL("insert into FailedTransaction(CustomerID,OrderNumber,IPAddress,OrderDate,PaymentGateway,PaymentMethod,TransactionCommand,TransactionResult,CustomerEMailed,RecurringSubscriptionID) values(" +
ProcessCustomer.CustomerID.ToString() + "," + OrigOrdNumber.ToString() + "," +
DB.SQuote(ProcessCustomer.LastIPAddress) + "," + DB.DateQuote(dtTx) + "," + DB.SQuote(GW) + "," +
DB.SQuote(AppLogic.TransactionTypeEnum.RECURRING_AUTO.ToString()) + "," + DB.SQuote(AppLogic.ro_NotApplicable) + "," + DB.SQuote(tmpStatus) + ",0," + DB.SQuote(TxSubID) + ")");
}
}
tmpS.Append(tmpStatus);
}
catch (Exception ex)
{
tmpS.Append(ex.Message);
}
Separator = "\n";
}
Status = AppLogic.ro_OK;
}
catch (Exception ex)
{
Status = ex.Message;
}
Results = tmpS.ToString();
return(Status);
}
