public override void LoadData(DBConn dbConn)
{
dbConn.SourceInfo = "Provider.LoadData";
bureauStatus = 0;
if (dbConn.ColStatus("BureauUserDescription") == Constants.DBColumnStatus.ColumnOK)
{
// Messaging providers
bureauCode = dbConn.ColString("BureauCode");
bureauName = dbConn.ColString("BureauName");
userDescription = dbConn.ColString("BureauUserDescription");
userID = dbConn.ColString("BureauUserName");
userPassword = dbConn.ColString("BureauPassword");
merchantKey = dbConn.ColString("BureauPassword");
bureauURL = dbConn.ColString("BureauAddress");
userCode = dbConn.ColString("UserCode");
bureauType = dbConn.ColString("Type");
sender = dbConn.ColString("Sender", 0, 0);
bureauPort = dbConn.ColString("Port", 0, 0);
}
else
{
merchantKey = dbConn.ColString("Safekey");
bureauURL = dbConn.ColString("url");
userID = dbConn.ColString("MerchantUserId", 0, 0);
userPassword = dbConn.ColString("MerchantUserPassword", 0, 0);
bureauType = "PAYMENT";
bureauName = "";
// bureauCode = dbConn.ColString("BureauCode",0);
}
}
public override void LoadData(DBConn dbConn)
{
// Payment Provider
providerKey = dbConn.ColString("Safekey");
providerURL = dbConn.ColString("url");
providerAccount = dbConn.ColString("MerchantAccount", 0);
providerUserID = dbConn.ColString("MerchantUserId", 0);
providerPassword = dbConn.ColString("MerchantUserPassword", 0);
// Customer
if (dbConn.ColStatus("lastName") == Constants.DBColumnStatus.ColumnOK)
{
firstName = dbConn.ColUniCode("firstName");
lastName = dbConn.ColUniCode("lastName");
email = dbConn.ColString("email");
phoneCell = dbConn.ColString("mobile");
regionalId = dbConn.ColString("regionalId");
address1 = dbConn.ColString("address1");
address2 = dbConn.ColString("city");
postalCode = dbConn.ColString("zip_code");
provinceCode = dbConn.ColString("state");
countryCode = dbConn.ColString("countryCode");
ipAddress = dbConn.ColString("IPAddress");
}
// Payment
merchantReference = dbConn.ColString("merchantReference", 0);
merchantReferenceOriginal = dbConn.ColString("merchantReferenceOriginal", 0); // Only really for Ikajo, don't log error
paymentAmount = dbConn.ColLong("amountInCents", 0);
currencyCode = dbConn.ColString("currencyCode", 0);
paymentDescription = dbConn.ColString("description", 0);
// Card/token/transaction details, not always present, don't log errors
ccName = dbConn.ColString("nameOnCard", 0);
ccNumber = dbConn.ColString("cardNumber", 0);
ccExpiryMonth = dbConn.ColString("cardExpiryMonth", 0);
ccExpiryYear = dbConn.ColString("cardExpiryYear", 0);
ccType = dbConn.ColString("cardType", 0);
ccCVV = dbConn.ColString("cvv", 0);
ccToken = dbConn.ColString("token", 0);
ccPIN = dbConn.ColString("PIN", 0);
transactionID = dbConn.ColString("transactionId", 0);
}
public static string SQLDebug(string sql)
{
sql = Tools.NullToString(sql);
if (sql.Length < 3)
{
return("Invalid SQL" + (sql.Length > 0 ? " (" + sql + ")" : ""));
}
DBConn conn = null;
StringBuilder ret = new StringBuilder();
string str = "SQL = " + sql;
try
{
Tools.LogInfo("Tools.SQLDebug/2", str, 255);
ret.Append(str + Constants.C_HTMLBREAK());
Tools.OpenDB(ref conn);
if (conn.Execute(sql))
{
str = "Execution successful, column count = " + conn.ColumnCount.ToString() + (conn.EOF ? " (NO rows)" : " (At least one row)");
Tools.LogInfo("Tools.SQLDebug/3", str, 255);
ret.Append(str + "<hr />"); // Constants.C_HTMLBREAK());
string colType;
for (int k = 0; k < conn.ColumnCount; k++)
{
str = "(Col " + k.ToString()
+ ") Name = " + conn.ColName(k)
+ ", Type = " + conn.ColDataType("", k)
+ ", Value = ";
colType = conn.ColDataType("", k).ToUpper();
if (conn.ColStatus("", k) == Constants.DBColumnStatus.ValueIsNull)
{
str = str + "NULL";
}
else if (colType == "NVARCHAR" || colType == "NCHAR")
{
str = str + conn.ColUniCode("", 0, k);
}
else
{
str = str + conn.ColValue(k);
}
Tools.LogInfo("Tools.SQLDebug/4", str, 255);
ret.Append(str + Constants.C_HTMLBREAK());
}
}
else
{
str = "Execution failed";
Tools.LogInfo("Tools.SQLDebug/5", str, 255);
ret.Append(str + Constants.C_HTMLBREAK());
}
}
catch (Exception ex)
{
str = "Error : " + ex.Message;
Tools.LogInfo("Tools.SQLDebug/6", str, 255);
ret.Append(str + Constants.C_HTMLBREAK());
}
finally
{
Tools.CloseDB(ref conn);
}
return(ret.ToString());
}
protected int LoadDataFromSQL(object[][] parms, int maxRows, System.Type classType = null, byte pagingMode = 0, string sourceInfo = "")
{
objList.Clear();
if (Tools.OpenDB(ref dbConn))
{
int q = 0;
dbConn.SourceInfo = sourceInfo;
if (maxRows > short.MaxValue)
{
maxRows = short.MaxValue;
}
else if (maxRows < 1)
{
maxRows = Constants.MaxRowsSQL;
}
if (dbConn.Execute(sql, true, parms))
{
if (pagingMode == (byte)PCIBusiness.Constants.PagingMode.AllowScreenPaging && !dbConn.EOF && dbConn.ColStatus("RowsPerPage") == Constants.DBColumnStatus.ColumnOK)
{
rowsTotal = dbConn.ColLong("RowsTotal");
rowsPerPage = dbConn.ColLong("RowsPerPage");
dbConn.NextResultSet();
}
while (!dbConn.EOF && q < maxRows)
{
q++;
if (classType == null)
{
objItem = NewItem();
}
else
{
objItem = (PCIBusiness.BaseData)Activator.CreateInstance(classType);
}
objItem.RowNumber = q;
objItem.LoadData(dbConn);
objList.Add(objItem);
if (pagingMode != (byte)PCIBusiness.Constants.PagingMode.DoNotReadNextRow)
{
dbConn.NextRow();
}
}
}
}
Tools.CloseDB(ref dbConn);
return(objList.Count);
}
