public object FindByID(string entityID) { GetCohortDataResponse cohortResponse = null; using (CohortMongoContext ctx = new CohortMongoContext(_dbName)) { List <IMongoQuery> queries = new List <IMongoQuery>(); queries.Add(Query.EQ(MECohort.IdProperty, ObjectId.Parse(entityID))); queries.Add(Query.EQ(MECohort.DeleteFlagProperty, false)); IMongoQuery mQuery = Query.And(queries); MECohort meCohort = ctx.Cohorts.Collection.Find(mQuery).FirstOrDefault(); if (meCohort != null) { cohortResponse = new GetCohortDataResponse(); API.DataDomain.Cohort.DTO.CohortData cohort = new API.DataDomain.Cohort.DTO.CohortData { ID = meCohort.Id.ToString(), SName = meCohort.ShortName, Query = meCohort.Query, QueryWithFilter = meCohort.QueryWithFilter, Sort = meCohort.Sort }; cohortResponse.Cohort = cohort; } } return(cohortResponse); }
public IEnumerable <object> SelectAll() { IEnumerable <object> query = null; List <API.DataDomain.Cohort.DTO.CohortData> cohorts = null; using (CohortMongoContext ctx = new CohortMongoContext(_dbName)) { List <MECohort> meCohorts = ctx.Cohorts.Collection.Find(Query.EQ(MECohort.DeleteFlagProperty, false)).ToList(); if (meCohorts != null) { cohorts = new List <API.DataDomain.Cohort.DTO.CohortData>(); foreach (MECohort m in meCohorts) { API.DataDomain.Cohort.DTO.CohortData cohort = new API.DataDomain.Cohort.DTO.CohortData { ID = m.Id.ToString(), SName = m.ShortName, Query = m.Query, Sort = m.Sort }; cohorts.Add(cohort); } } } query = ((IEnumerable <object>)cohorts); //.AsEnumerable<object>(); return(query); }