public void createStockBuyOrder(string referenceNumber, string shares, string orderType, string expiryDay, string allOrNone, string highPrice, string stopPrice) { HKeInvestData myHKeInvestData = new HKeInvestData(); var trans = myHKeInvestData.beginTransaction(); string sql = string.Format("INSERT INTO [StockOrderBuy] VALUES ({0}, '{1}', {2}, '{3}',", shares, orderType, int.Parse(expiryDay), allOrNone); if (orderType == "limit") { sql += highPrice + ", NULL, '" + referenceNumber + "')"; } else if (orderType == "stop") { sql += "NULL, " + stopPrice + ", '" + referenceNumber + "')"; } else if (orderType == "stop limit") { sql += highPrice + "," + stopPrice + ", '" + referenceNumber + "')"; } else { sql += "NULL, NULL, '" + referenceNumber + "')"; } myHKeInvestData.setData(sql, trans); myHKeInvestData.commitTransaction(trans); }
public void createUnitTrustBuyOrder(string referenceNumber, string amount) { HKeInvestData myHKeInvestData = new HKeInvestData(); var trans = myHKeInvestData.beginTransaction(); string sql = string.Format("INSERT INTO [UnitTrustOrderBuy] VALUES ({0}, '{1}')", decimal.Parse(amount), referenceNumber); myHKeInvestData.setData(sql, trans); myHKeInvestData.commitTransaction(trans); }
public void createBondSellOrder(string referenceNumber, string shares) { HKeInvestData myHKeInvestData = new HKeInvestData(); var trans = myHKeInvestData.beginTransaction(); string sql = string.Format("INSERT INTO [BondOrderSell] VALUES ({0}, '{1}')", decimal.Parse(shares), referenceNumber); myHKeInvestData.setData(sql, trans); myHKeInvestData.commitTransaction(trans); }
public string getUserAccountNumber(HttpSessionState session, string userName) { if (session["accountNumber"] == null) { HKeInvestData myHKeInvestData = new HKeInvestData(); string sql = "SELECT accountNumber FROM dbo.Account WHERE userName='******'"; DataTable dtAccountNumber = myHKeInvestData.getData(sql); if (dtAccountNumber.Rows.Count == 1) { session["accountNumber"] = dtAccountNumber.Rows[0].Field <string>("accountNumber"); } else { session["accountNumber"] = ""; } } return((string)session["accountNumber"]); }
public void createNewOrder(string accountNumber, string referenceNumber, string name, string code) { string status = "pending"; decimal serviceFee = 0; string date = DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss tt"); HKeInvestData myHKeInvestData = new HKeInvestData(); var trans = myHKeInvestData.beginTransaction(); string sql = string.Format("INSERT INTO [Order] VALUES ('{0}', '{1}', '{2}', {3}, '{4}', '{5}', '{6}')", referenceNumber, name, status, serviceFee, code, date, accountNumber); myHKeInvestData.setData(sql, trans); myHKeInvestData.commitTransaction(trans); }
public string getClientName(string accountNumber) { if (accountNumber == null || accountNumber.Equals("")) { return(""); } else { HKeInvestData myHKeInvestData = new HKeInvestData(); string sql = "SELECT lastName,firstName FROM dbo.[Client] WHERE accountNumber='" + accountNumber + "';"; DataTable dtName = myHKeInvestData.getData(sql); if (dtName.Rows.Count == 1) { return(dtName.Rows[0].Field <string>("firstName").Trim() + " " + dtName.Rows[0].Field <string>("lastName").Trim()); } else { return(""); } } }