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