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); }