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