static void Main(string[] args) { //AppDomain.CurrentDomain.SetData("DataDirectory", Environment.GetFolderPath(Environment.SpecialFolder.CommonApplicationData)); var dataContex = new ChemDBEntities(); var entityRepo = new EntityRepository(dataContex); var subsRepo = new SubstanceRepository(dataContex); foreach (var item in subsRepo.GetAll()) { Console.WriteLine(item.ProductName); } //entityRepo.Add(new Entity() { Id = Guid.NewGuid(), Name = "IGA1", Address = "La coronela", Coord_x = 19, Coord_y = 72, Email = "*****@*****.**", Fax = 1222, Organization = "AMA", Town = "La Habana" }); //entityRepo.SubmitChanges(); //var txt = File.CreateText("test"); //for (int i = 0; i < 10; i++) //{ // txt.WriteLine(Guid.NewGuid()); //} //txt.Close(); //ExcelDB excelDB = new ExcelDB("Bases de datos GPQ.xlsx"); //excelDB.MigrateSubstance(); Console.WriteLine("Todo ok"); Console.ReadLine(); }
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(); }
public void ThatSubstanceCanBeAdded() { var subst = Substance.Create(SubstanceTestFixtures.GetSubstanceWithGroup()); var repos = new SubstanceRepository(GenFormApplication.SessionFactory) { subst }; Assert.IsTrue(repos.Contains(subst)); }
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(); }
public void ThatRepositoryCanUseLinq() { var subst = CreateSubstanceWithGroup(); var repos = new SubstanceRepository(GenFormApplication.SessionFactory) { subst }; var result = repos.Select(x => x.Name == SubstanceGroupTestFixtures.GetSubstanceGroupDtoWithoutItems().Name); Assert.IsNotNull(result); }
private void InitializeSubstance(string substance) { var substanceRepo = new SubstanceRepository(new ChemDBEntities()); substanceProperties.ItemsSource = substanceRepo.GetAll().Where(p => p.ProductName == substance).Select(p => new { FormulaHill = p.FormulaHill, CAS = p.CAS, CPCU = p.CPCU, UN = p.UN }).ToList(); }