private void InitializeSynonym(string substance) { var substance_SynonymRepository = new Substance_SynonymRepository(new ChemDBEntities()); var substanceRepo = new SubstanceRepository(new ChemDBEntities()); Guid substanceId = substanceRepo.FindByName(substance).Id; var x = substance_SynonymRepository.GetAll().Where(p => p.IdSubstance == substanceId).Select(p => new { Name = p.Synonym.Name }).ToList(); synonym.ItemsSource = substance_SynonymRepository.GetAll().Where(p => p.IdSubstance == substanceId).Select(p => new { Name = p.Synonym.Name }).ToList(); }
private void InitializeGuide(string substance) { var substance_GuideRepository = new Substance_GuideRepository(new ChemDBEntities()); var substanceRepo = new SubstanceRepository(new ChemDBEntities()); Guid substanceId = substanceRepo.FindByName(substance).Id; managment.ItemsSource = substance_GuideRepository.GetAll().Where(p => p.IdSubstance == substanceId && p.Guide.Type == 0).Select(p => new { Name = p.Guide.Name }).ToList(); result.ItemsSource = substance_GuideRepository.GetAll().Where(p => p.IdSubstance == substanceId && p.Guide.Type == 1).Select(p => new { Name = p.Guide.Name }).ToList(); security.ItemsSource = substance_GuideRepository.GetAll().Where(p => p.IdSubstance == substanceId && p.Guide.Type == 2).Select(p => new { Name = p.Guide.Name }).ToList(); }
private void InitializeEntities(string substance) { var substance_EntityRepository = new Substance_EntityRepository(new ChemDBEntities()); var substanceRepo = new SubstanceRepository(new ChemDBEntities()); Guid substanceId = substanceRepo.FindByName(substance).Id; var x = substance_EntityRepository.GetAll().Where(p => p.IdSubstance == substanceId && p.Type == 0).Select(p => new { Name = p.Entity.Name }).ToList(); available.ItemsSource = substance_EntityRepository.GetAll().Where(p => p.IdSubstance == substanceId && p.Type == 0).Select(p => new { Name = p.Entity.Name }).ToList(); custumer.ItemsSource = substance_EntityRepository.GetAll().Where(p => p.IdSubstance == substanceId && p.Type == 1).Select(p => new { Name = p.Entity.Name }).ToList(); Consult.ItemsSource = substance_EntityRepository.GetAll().Where(p => p.IdSubstance == substanceId && p.Type == 2).Select(p => new { Name = p.Entity.Name }).ToList(); }