public void UpdateQuote(QuotesAndTrades quote)
{
using (LoanPriceEntities context = new LoanPriceEntities())
{
QuotesAndTrades model = context.QuotesAndTrades.SingleOrDefault(c => c.ID == quote.ID);
if (model != null)
{
model.CounterParty = quote.CounterParty;
model.BidPrice = quote.BidPrice;
model.OfferPrice = quote.OfferPrice;
model.BidSpread = quote.BidSpread;
model.OfferSpread = quote.OfferSpread;
model.Traded = quote.Traded;
model.MarketValue = quote.MarketValue;
model.Country = quote.Country;
model.TimeStamp = quote.TimeStamp;
model.LoanName = quote.LoanName;
model.AvgLifeDisc = quote.AvgLifeDisc;
model.AvgLifeNonDisc = quote.AvgLifeNonDisc;
model.AvgLifeRiskDisc = quote.AvgLifeRiskDisc;
if (quote.SettlementDate != Convert.ToDateTime("01/01/0001 00:00:00"))
{
model.SettlementDate = quote.SettlementDate;
}
model.TradedDate = quote.TradedDate;
model.Margin = quote.Margin;
context.SaveChanges();
}
}
}
public QuotesAndTrades GetQuotesAndTrades(string loanName)
{
using (LoanPriceEntities context = new LoanPriceEntities())
{
QuotesAndTrades model = context.QuotesAndTrades.OrderByDescending(s => s.ID).First(c => c.LoanName == loanName);
return(model);
}
}
public void SaveQuote(QuotesAndTrades model)
{
using (LoanPriceEntities context = new LoanPriceEntities())
{
if (model.ID > 0)
{
context.AddObject("QuotesAndTrades", model);
}
context.SaveChanges();
}
}
public bool RemoveQuote(int id)
{
using (LoanPriceEntities context = new LoanPriceEntities())
{
QuotesAndTrades model = context.QuotesAndTrades.SingleOrDefault(c => c.ID == id);
if (model != null)
{
// Delete the Password policy of this account
context.QuotesAndTrades.DeleteObject(model);
context.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// New Quote and trade added
/// </summary>
/// <param name="quoteAndTrade"></param>
public static void NewQuotesAndTradeAdded(QuotesAndTrades quoteAndTrade)
{
var context = GlobalHost.ConnectionManager.GetHubContext <ApplicationHub>();
context.Clients.All.onQuotesAndTradeAdded(quoteAndTrade);
}
