static public void DeleteAccount(Account acct)
{
using (var db = new CouatlContext())
{
db.Accounts.Attach(acct);
db.Remove(acct);
db.SaveChanges();
}
}
static private void DeletePosition(Position thePos)
{
using (var db = new CouatlContext())
{
db.Positions.Attach(thePos);
db.Remove(thePos);
db.SaveChanges();
}
}
static public void AddPrice(int securityId, DateTime date, decimal amount, bool closing)
{
Price thePrice = new Price();
thePrice.Amount = amount;
thePrice.Date = date;
thePrice.Closing = closing;
thePrice.SecurityId = securityId;
using (var db = new CouatlContext())
{
bool addNewPrice = true;
// Check for existing price.
List <Price> prices;
prices = db.Prices.Where(p => p.SecurityId == securityId && p.Date == date).ToList();
// If there is more than one price for this date, then the database is in an invalid state.
// TODO: Gracefully handle more than one price per date?
if (prices.Count > 1)
{
throw new IndexOutOfRangeException();
}
else if (prices.Count == 1)
{
// Remove the existing price, if necessary.
// A non-closing price will always be removed in favor of a more-recent price.
// A closing price will only be removed if the new price is also a closing price
// (presumanly this means that the earlier closing price was incorrect).
if (!prices[0].Closing || closing)
{
db.Attach(prices[0]);
db.Remove(prices[0]);
}
else
{
addNewPrice = false;
}
}
if (addNewPrice)
{
db.Prices.Add(thePrice);
}
db.SaveChanges();
}
}