public void Add(object enumItemObject) { Demographics enumItem = (Demographics)enumItemObject; using (var dbContext = new MedialynxDbDemographicsContext()) { dbContext.Demographics.Add(enumItem); dbContext.SaveChanges(); } }
public void Update(Demographics enumItem) { using (var dbContext = new MedialynxDbDemographicsContext()) { var existsItem = dbContext.Demographics.FirstOrDefault(u => u != null && u.Id == enumItem.Id); if (existsItem != null) { if (Utils.CopyPropertyValues <Demographics>(enumItem, existsItem)) { dbContext.Demographics.Update(existsItem); dbContext.SaveChanges(); } } } }
public void Generate(string cohortId) { List <CohortEnumLink> links = new List <CohortEnumLink>(); using (var dbCohortContext = new MedialynxDbCohortEnumsContext()) { foreach (CohortEnums enumItem in dbCohortContext.CohortEnums) { switch (enumItem.Id) { case CohortEnumsDictionary.DiseaseStates: using (var dbDiseaseStatesContext = new MedialynxDbDiseaseStatesContext()) { links.AddRange(ExistingOptionsAsLink <DiseaseStates>(new List <DiseaseStates>(dbDiseaseStatesContext.DiseaseStates), cohortId, enumItem.Id)); } break; case CohortEnumsDictionary.GeneticMatches: using (var dbGeneticMatchesContext = new MedialynxDbGeneticMatchesContext()) { links.AddRange(ExistingOptionsAsLink <GeneticMatches>(new List <GeneticMatches>(dbGeneticMatchesContext.GeneticMatches), cohortId, enumItem.Id)); } break; case CohortEnumsDictionary.Biomarkers: using (var dbBiomarkersContext = new MedialynxDbBiomarkersContext()) { links.AddRange(ExistingOptionsAsLink <Biomarkers>(new List <Biomarkers>(dbBiomarkersContext.Biomarkers), cohortId, enumItem.Id)); } break; case CohortEnumsDictionary.Demographics: using (var dbDemographicsContext = new MedialynxDbDemographicsContext()) { links.AddRange(ExistingOptionsAsLink <Demographics>(new List <Demographics>(dbDemographicsContext.Demographics), cohortId, enumItem.Id)); } break; case CohortEnumsDictionary.Ethnicitys: using (var dbEthnicitysContext = new MedialynxDbEthnicitysContext()) { links.AddRange(ExistingOptionsAsLink <Ethnicitys>(new List <Ethnicitys>(dbEthnicitysContext.Ethnicitys), cohortId, enumItem.Id)); } break; case CohortEnumsDictionary.StageOfDiseases: using (var dbStageOfDiseasesContext = new MedialynxDbStageOfDiseasesContext()) { links.AddRange(ExistingOptionsAsLink <StageOfDiseases>(new List <StageOfDiseases>(dbStageOfDiseasesContext.StageOfDiseases), cohortId, enumItem.Id)); } break; case CohortEnumsDictionary.Prognosis: using (var dbPrognosisContext = new MedialynxDbPrognosisContext()) { links.AddRange(ExistingOptionsAsLink <Prognosis>(new List <Prognosis>(dbPrognosisContext.Prognosis), cohortId, enumItem.Id)); } break; case CohortEnumsDictionary.PreviousTreatments: using (var dbPreviousTreatmentsContext = new MedialynxDbPreviousTreatmentsContext()) { links.AddRange(ExistingOptionsAsLink <PreviousTreatments>(new List <PreviousTreatments>(dbPreviousTreatmentsContext.PreviousTreatments), cohortId, enumItem.Id)); } break; } } using (var dbContext = new MedialynxDbCohortEnumLinkContext()) { dbContext.CohortEnumLink.AddRange(links); dbContext.SaveChanges(); } } }
public List <Demographics> Get(string filter = "", string enumItemId = "") { using (var dbContext = new MedialynxDbDemographicsContext()) { return(dbContext.Demographics.Where(enumItem => enumItemId == "" || enumItem.Id == enumItemId).Where(enumItem => filter == "" || enumItem.AgeFrom.ToString().Contains(filter) || enumItem.AgeTo.ToString().Contains(filter) || enumItem.Gender.Contains(filter)).ToList()); } }