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); } }