public UserFinance GetUserFinance(User user, string Currency)
{
var finance = this._pbo.UserFinances.All
.First(x => x.UserID == user.UserID && x.Currency == Currency);
return finance;
}
public List<UserFinance> GetUserFinances(User user)
{
var finances = this._pbo.UserFinances.All
.Where(x => x.UserID == user.UserID)
.ToList();
return finances;
}
public List<FinancialTransaction> GetTransactionsForUser(User user)
{
var events = this._pbo.FinancialTransactions.All
.Where(x => x.UserID == user.UserID)
.OrderByDescending(x => x.TransactionDate)
.ToList();
return events;
}
public List<UserStock> GetUserStocks(User user)
{
var userStocks = this._pbo.UserStocks.All.Where(x => x.UserID == user.UserID).ToList();
foreach (var userStock in userStocks)
{
var stockQuote = this._sibo.GetStockQuote(userStock.StockName);
userStock.Quote = stockQuote;
}
return userStocks;
}
public UserStock GetUserStock(User user, string StockName)
{
var userStock = this._pbo.UserStocks.All.FirstOrDefault(x => x.UserID == user.UserID && x.StockName == StockName);
if (userStock == null)
{
return null;
}
var stockQuote = this._sibo.GetStockQuote(userStock.StockName);
userStock.Quote = stockQuote;
return userStock;
}
public UserStock AddNoteToUserStock(User user, string stockName, string note)
{
lock (GetCacheLock(user.UserID))
{
var userStock = this._pbo.UserStocks.All.FirstOrDefault(x => x.UserID == user.UserID && x.StockName == stockName);
if (userStock == null)
{
// Create the record for this stock and add it to the table
userStock = getBlankUserStock(stockName, user);
this._pbo.UserStocks.AddEntity(userStock);
}
userStock.UserNote = note;
userStock.UserNoteSet = DateTime.Now;
this._pbo.SaveChanges();
return userStock;
}
}
public User GetOrCreateUser(string FacebookID)
{
var u = this._pbo.Users.All.FirstOrDefault(x => x.FacebookID == FacebookID);
if (u == null)
{
u = new User();
u.FacebookID = FacebookID;
this._pbo.Users.AddEntity(u);
this._pbo.SaveChanges(); // Gives the user a UserID, so we can use it below
var uf = new UserFinance();
uf.UserID = u.UserID;
uf.Amount = Constants.MoneyUsersStartWith;
uf.Currency = Constants.Currency.USD;
this._pbo.UserFinances.AddEntity(uf);
this._pbo.SaveChanges();
}
return u;
}
private FinancialTransaction CreateAndSaveFinancialTransaction(
User user,
decimal amount,
Constants.FinancialTransactionType transactiontype,
string stockName = null,
int? numStocks = null)
{
var ft = new FinancialTransaction();
ft.Amount = amount;
if (ft.Amount < 0)
{
ft.Amount *= -1; // all transactions must be positive
}
ft.StockName = stockName;
ft.NumSharesBoughtOrSold = numStocks;
ft.TransactionDate = DateTime.Now;
ft.UserID = user.UserID;
string direction;
switch (transactiontype)
{
case Constants.FinancialTransactionType.Deposit:
direction = Constants.FinancialTransactionDirection.IN;
break;
case Constants.FinancialTransactionType.Withdrawal:
direction = Constants.FinancialTransactionDirection.OUT;
break;
case Constants.FinancialTransactionType.StockPurchase:
direction = Constants.FinancialTransactionDirection.OUT;
break;
case Constants.FinancialTransactionType.StockSale:
direction = Constants.FinancialTransactionDirection.IN;
break;
default:
throw new NotImplementedException("Must implement financial direction for financial type: " + transactiontype.ToString());
}
ft.FinancialTransactionDirection = direction;
ft.Currency = Constants.Currency.USD;
this._pbo.FinancialTransactions.AddEntity(ft);
this._pbo.SaveChanges();
return ft;
}
public void DeleteTransactionsForUser(User user)
{
lock (GetCacheLock(user.UserID))
{
var transactions = this.GetTransactionsForUser(user);
foreach (var t in transactions)
{
this._pbo.FinancialTransactions.DeleteEntity(t);
this._pbo.SaveChanges();
}
}
}
private UserStock getBlankUserStock(string stockName, User user)
{
var userStock = new UserStock();
userStock.StockName = stockName;
userStock.NumberOfStocks = 0;
userStock.TotalNumberOfStocksBought = 0;
userStock.TotalNumberOfStocksSold = 0;
userStock.TotalValueOfStocksBought = 0;
userStock.TotalValueOfStocksSold = 0;
userStock.UserID = user.UserID;
return userStock;
}
public Tuple<Constants.ReturnValues.StockTransactionResult, FinancialTransaction> BuyStock(User user, string stockName, int numSharesToBuy)
{
lock (GetCacheLock(user.UserID))
{
var stockQuote = this._sibo.GetStockQuote(stockName);
if (stockQuote == null)
{
return new Tuple<Constants.ReturnValues.StockTransactionResult,FinancialTransaction>(Constants.ReturnValues.StockTransactionResult.StockNotFound, null);
}
var stockPrice = stockQuote.Ask; // Ask is the Asking price of the stock, what you purchase it for
var totalPrice = (stockPrice.Value * numSharesToBuy);
// Load up the user's finance. If they don't have enough money, return Insufficient Funds
var uf = this.GetUserFinance(user, Constants.Currency.USD);
if (uf.Amount < totalPrice)
{
return new Tuple<Constants.ReturnValues.StockTransactionResult, FinancialTransaction>(Constants.ReturnValues.StockTransactionResult.InsufficientFunds, null);
}
// Make a new transaction for the purchase
var transaction = this.CreateAndSaveFinancialTransaction(user, totalPrice, Constants.FinancialTransactionType.StockPurchase, stockName, numSharesToBuy);
// Update the user's finance to remove the money they just used
uf.Amount -= totalPrice;
this._pbo.SaveChanges();
// Load the stock record containing how many stocks the user has
// If they have none, it means they have not dealt with this stock before
var userStock = this.GetUserStock(user, stockName);
if (userStock == null)
{
// Create the record for this stock and add it to the table
userStock = getBlankUserStock(stockName, user);
this._pbo.UserStocks.AddEntity(userStock);
}
// Update the user's stock to now have the number of shares and total values
userStock.TotalNumberOfStocksBought += numSharesToBuy;
userStock.TotalValueOfStocksBought += totalPrice;
userStock.NumberOfStocks += numSharesToBuy;
this._pbo.SaveChanges();
return new Tuple<Constants.ReturnValues.StockTransactionResult, FinancialTransaction>(Constants.ReturnValues.StockTransactionResult.Success, transaction);
}
}
public Tuple<Constants.ReturnValues.StockTransactionResult, FinancialTransaction> SellStock(User user, string stockName, int numSharesToSell)
{
lock (GetCacheLock(user.UserID))
{
// Load up the price of the stock
var stockQuote = this._sibo.GetStockQuote(stockName);
if (stockQuote == null)
{
return new Tuple<Constants.ReturnValues.StockTransactionResult, FinancialTransaction>(Constants.ReturnValues.StockTransactionResult.StockNotFound, null);
}
// Load the stock record containing how many stocks the user has
// If they have none, then return InsufficientStocks
var userStock = this.GetUserStock(user, stockName);
if (userStock == null || userStock.NumberOfStocks < numSharesToSell)
{
return new Tuple<Constants.ReturnValues.StockTransactionResult, FinancialTransaction>(Constants.ReturnValues.StockTransactionResult.InsufficientStocks, null);
}
var stockPrice = stockQuote.Bid.Value; // Bid is the Bidding price of the stock, what you sell it for
var totalPrice = (stockPrice * numSharesToSell);
// Make a new transaction for the sale
var transaction = this.CreateAndSaveFinancialTransaction(user, totalPrice, Constants.FinancialTransactionType.StockSale, stockName, numSharesToSell);
// Update the user's finance to have the amount they just sold
var uf = this.GetUserFinance(user, Constants.Currency.USD);
uf.Amount += totalPrice;
this._pbo.SaveChanges();
// Update the user's stock to now have the number of shares and total values
userStock.NumberOfStocks -= numSharesToSell;
userStock.TotalNumberOfStocksSold += numSharesToSell;
userStock.TotalValueOfStocksSold += totalPrice;
this._pbo.SaveChanges();
return new Tuple<Constants.ReturnValues.StockTransactionResult, FinancialTransaction>(Constants.ReturnValues.StockTransactionResult.Success, transaction);
}
}
public void CreateNewEvent(User user, Event toCreate)
{
toCreate.UserID = user.UserID;
this._pbo.Events.AddEntity(toCreate);
this._pbo.SaveChanges();
}
public List<Event> GetEventsForUser(User user)
{
var events = this._pbo.ValidEvents.Where(x => x.UserID == user.UserID).ToList();
return events;
}
private void SetupTest()
{
this.pbo = new TestPersistenceObject();
var sbo = new StockInformationBusinessObject();
this.fbo = new FinancialTransactionBusinessObject(pbo, sbo);
this.tud = new TestUserData(pbo);
this.user = new UserBusinessObject(this.pbo).GetOrCreateUser("9999");
}