public DashboardDto Fetch() { var result = new DashboardDto(); // open database context result.ProjectCount = MockDb.Projects.Count(); result.OpenProjectCount = MockDb.Projects.Where(r => r.Ended == null).Count(); result.ResourceCount = MockDb.Resources.Count(); return result; }
public DashboardDto Fetch() { var result = new DashboardDto(); using (var ctx = ObjectContextManager<PTrackerEntities>.GetManager("PTrackerEntities")) { result.ProjectCount = ctx.ObjectContext.Projects.Count(); result.OpenProjectCount = ctx.ObjectContext.Projects.Where(r => r.Ended == null).Count(); result.ResourceCount = ctx.ObjectContext.Resources.Count(); } return result; }