Ejemplo n.º 1
0
        public static int AddToFavorites(string username, string text)
        {
            string    query          = string.Format(AddToFavoritesQuery, username, text);
            iSqlQuery addToFavorites = new DB_NonQuery(query);

            return(addToFavorites.Execute());
        }
Ejemplo n.º 2
0
        public static int PurchaseStocks(int numberOfStocks,
                                         double stockUnitPrice,
                                         string userName,
                                         string email,
                                         string companyCode)
        {
            int    availableFunds     = CurrentBalance(userName);
            double moneyTryingToSpend = numberOfStocks * stockUnitPrice;

            if (moneyTryingToSpend > availableFunds)
            {
                return(-2);                // not enough funds
            }
            string query = string.Format(purchaseStocksQuery,
                                         (availableFunds - moneyTryingToSpend),
                                         userName,
                                         email,
                                         companyCode,
                                         numberOfStocks,
                                         stockUnitPrice);

            iSqlQuery purchaseStock_Query = new DB_NonQuery(query);

            return(purchaseStock_Query.Execute());
        }