public ObservableCollection <Historique> GetAllData()
{
ObservableCollection <Historique> result = new ObservableCollection <Historique>();
try
{
using (var bdd = new AcoreDBEntities())
{
List <Historique> historiques = bdd.Historique.ToList();
foreach (Historique his in historiques)
{
if (his.IdRecette != null)
{
his.Recette2 = RecetteService.GetRecetteFromId((int)his.IdRecette);
}
result.Add(his);
}
}
}
catch (Exception e)
{
Console.WriteLine("Exception: {0}", e);
}
return(result);
}
public static ObservableCollection <Options> GetAllOptionsFromTableId(int id, string table)
{
ObservableCollection <Options> result = new ObservableCollection <Options>();
try
{
using (var bdd = new AcoreDBEntities())
{
string sqlCommand = "SELECT * FROM Options WHERE " + table + " = " + id;
List <Options> options = bdd.Options.SqlQuery(sqlCommand).ToList();
foreach (Options opt in options)
{
result.Add(opt);
}
}
}
catch (Exception e)
{
Console.WriteLine("Exception: {0}", e);
}
return(result);
}
public static ObservableCollection <Automate> GetAllData()
{
ObservableCollection <Automate> result = new ObservableCollection <Automate>();
try
{
using (var bdd = new AcoreDBEntities())
{
List <Automate> automates = bdd.Automate.ToList();
foreach (Automate aut in automates)
{
aut.CreateThread();
result.Add(aut);
}
}
}
catch (Exception e)
{
Console.WriteLine("Exception: {0}", e);
}
return(result);
}
public ObservableCollection <Process> GetAllData()
{
ObservableCollection <Process> result = new ObservableCollection <Process>();
try
{
using (var bdd = new AcoreDBEntities())
{
List <Process> processes = bdd.Process.ToList();
foreach (Process pro in processes)
{
pro.Recettes = RecetteService.GetListRecetteFromProcessId(pro.Id);
pro.Options = OptionsService.GetAllOptionsFromTableId(pro.Id, "Id" + pro.GetType().Name);
result.Add(pro);
}
}
}
catch (Exception e)
{
Console.WriteLine("Exception: {0}", e);
}
return(result);
}
