public List <EFDataLayer.Counterparty> ListAll()
{
using (var context = new EFDataLayer.EFEntities())
{
return(context.Counterparties.OrderBy(c => c.Name).ToList());
}
}
public List <Usage> ListUsageByCounterparty(int counterpartyId)
{
using (var context = new EFDataLayer.EFEntities())
{
DateTime dt = DateTime.Today.Subtract(new TimeSpan(365, 0, 0, 0)); // get 1 years exposure
return(context.Usages.Where(u => u.CounterpartyId == counterpartyId).Where(d => d.ExposureDate > dt).OrderByDescending(u => u.ExposureDate).ToList());
}
}
public int Add(EFDataLayer.Counterparty counterparty)
{
using (var context = new EFDataLayer.EFEntities())
{
context.Counterparties.Add(counterparty);
context.SaveChanges();
return(counterparty.Id);
}
}
