public override void LoadData(DBConn dbConn)
{
dbConn.SourceInfo = "Provider.LoadData";
merchantKey = dbConn.ColString("Safekey");
providerURL = dbConn.ColString("url");
userID = dbConn.ColString("MerchantUserId", 0);
userPassword = dbConn.ColString("MerchantUserPassword", 0);
bureauName = "";
bureauStatus = 0;
}
public override void LoadData(DBConn dbConn)
{
dbConn.SourceInfo = "TickerState.LoadData";
tickerCode = dbConn.ColString("TickerCode");
tickerStatus = dbConn.ColString("TickerStatus");
// May not be returned, so don't log errors
userCode = dbConn.ColString("UserCode", 0, 0);
origin = dbConn.ColString("ActionOrigin", 0, 0);
// dateUpdated = dbConn.ColDate ("ActionDate",0,0);
Tools.LogInfo("TickerState.LoadData", "tickerCode=" + tickerCode + ", tickerStatus=" + tickerStatus, 10);
}
// protected void ExecuteSQLDebug()
// {
// Tools.LogInfo("SQLDebug/1","SQL = "+sql);
// if ( ExecuteSQL(null,false) == 0 )
// {
// Tools.LogInfo("SQLDebug/2","Execution successful, column count = " + dbConn.ColumnCount.ToString());
// for ( int k = 0 ; k < dbConn.ColumnCount ; k++ )
// Tools.LogInfo("SQLDebug/3","(Col " + k.ToString()
// + ") Name = " + dbConn.ColName(k)
// + ", Type = " + dbConn.ColDataType(dbConn.ColName(k))
// + ", Value = " + dbConn.ColValue(k));
// }
// else
// Tools.LogInfo("SQLDebug/4","Execution failed, return code = " + returnCode.ToString());
// Tools.CloseDB(ref dbConn);
// }
protected int ExecuteSQLUpdate(bool closeConnection = true, bool getReturnCodes = true)
{
if (ExecuteSQL(null) == 0 && getReturnCodes)
{
returnCode = dbConn.ColLong("ReturnCode");
returnMessage = dbConn.ColString("ReturnMessage");
returnData = dbConn.ColString("ReturnData");
}
if (closeConnection)
{
Tools.CloseDB(ref dbConn);
}
return(returnCode);
}
public override void LoadData(DBConn dbConn)
{
dbConn.SourceInfo = "Stock.LoadData";
stockId = dbConn.ColLong("StockId", 0, 0);
symbol = dbConn.ColString("Symbol");
exchangeCode = dbConn.ColString("BrokerExchangeCode", 0, 0);
primaryExchange = dbConn.ColString("PrimaryExchange", 0, 0);
securityType = dbConn.ColString("SecType", 0, 0);
currencyCode = dbConn.ColString("CUR", 0, 0);
resolution = dbConn.ColString("Resolution", 0, 0);
theDate = dbConn.ColDate("Date", 0, 0);
ticksMax = dbConn.ColLong("Ticks", 0, 0);
ticksSkip = dbConn.ColLong("Skip", 0, 0);
// UNIX timestamps, BigInt (64-bit)
fromDate = dbConn.ColBig("FromDate", 0, 0);
toDate = dbConn.ColBig("ToDate", 0, 0);
// UNIX timestamps, Int (32-bit)
// fromDate = dbConn.ColLong ("FromDate",0,0);
// toDate = dbConn.ColLong ("ToDate",0,0);
// Date format
// fromDate = dbConn.ColDate ("FromDate",0,0);
// toDate = dbConn.ColDate ("ToDate",0,0);
price = 0;
quantity = 0;
tickType = 0;
}
// protected void ExecuteSQLDebug()
// {
// Tools.LogInfo("SQLDebug/1","SQL = "+sql);
// if ( ExecuteSQL(null,false) == 0 )
// {
// Tools.LogInfo("SQLDebug/2","Execution successful, column count = " + dbConn.ColumnCount.ToString());
// for ( int k = 0 ; k < dbConn.ColumnCount ; k++ )
// Tools.LogInfo("SQLDebug/3","(Col " + k.ToString()
// + ") Name = " + dbConn.ColName(k)
// + ", Type = " + dbConn.ColDataType(dbConn.ColName(k))
// + ", Value = " + dbConn.ColValue(k));
// }
// else
// Tools.LogInfo("SQLDebug/4","Execution failed, return code = " + returnCode.ToString());
// Tools.CloseDB(ref dbConn);
// }
protected int ExecuteSQLUpdate(byte execMode = 1, bool closeConnection = true)
{
if (ExecuteSQL(null, execMode) == 0)
{
if (execMode == 1)
{
returnCode = dbConn.ColLong("ReturnCode");
returnMessage = dbConn.ColString("ReturnMessage", 0, 0);
returnData = dbConn.ColString("ReturnData", 0, 0);
}
else if (execMode == 2)
{
returnCode = dbConn.ReturnValue;
}
}
if (closeConnection)
{
Tools.CloseDB(ref dbConn);
}
return(returnCode);
}
public override void LoadData(DBConn dbConn)
{
string x = "Level" + level.ToString();
// menuCode = dbConn.ColString("MenuItemCode");
menuCode = dbConn.ColString(x + "ItemCode");
menuName = dbConn.ColString(x + "ItemDescription");
menuDescription = dbConn.ColString(x + "ItemDescription");
imageName = dbConn.ColString("MenuLevel1ImageFileName");
displayImageOrText = dbConn.ColString("DisplayMenuLevel1Image");
url = dbConn.ColString("URL");
routerLink = dbConn.ColString("RouterLink", 0, 0);
blocked = dbConn.ColString("Blocked", 0, 0);
// See RouterLink "Get" method
// if ( routerLink.Length < 1 && url.Length > 0 )
// routerLink = url;
// Testing
// url = dbConn.ColString("URL") + "?UserCode={UserCode}";
}
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 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);
}
}