public static List<string> LoadAssets(DateTime tDebut)
{
using (parseurDataContext pdc = new parseurDataContext())
{
IQueryable<string> values = from n in pdc.HistoComponents
where n.date==tDebut
select n.name;
List<string> List = new List<string>();
foreach (string str in values)
{
List.Add(str);
}
return List;
}
}
public static DateTime[] LoadDate()
{
using (parseurDataContext pdc = new parseurDataContext())
{
IQueryable<DateTime> values = from n in pdc.HistoComponents
where n.name=="AC.PA"
select n.date;
DateTime[] TableauDates = new DateTime[values.Count()];
IEnumerator<DateTime> e ;
e = values.GetEnumerator();
e.MoveNext();
for (int i = 0; i < TableauDates.Length;i++ )
{
TableauDates[i]=e.Current;
e.MoveNext();
}
return TableauDates;
}
}
public static double[,] LoadIndice(IList<string> titres, DateTime tDeb, DateTime tFin)
{
var titreAsArray = new string[titres.Count];
for (int i = 0; i < titres.Count; i++)
{
titreAsArray[i] = titres[i];
}
using (parseurDataContext pdc = new parseurDataContext())
{
IQueryable<double> values = from n in pdc.HistoIndices
where DateTime.Compare(n.date, tFin) <= 0 && DateTime.Compare(n.date, tDeb) >= 0
orderby n.name
select n.value;
IQueryable<DateTime> date = from n in pdc.HistoComponents
where DateTime.Compare(n.date, tFin) <= 0 && DateTime.Compare(n.date, tDeb) >= 0 && titreAsArray.Contains(n.name)
select n.date;
int dates = date.Count()/titres.Count;
double [,] data = new double[dates,1];
IEnumerator<double> e = new DoubleCollection.Enumerator();
e = values.GetEnumerator();
e.MoveNext();
for (int j = 0; j < data.GetLength(1); j++)
{
for (int i = 0; i < data.GetLength(0); i++)
{
data[i, j] = e.Current;
e.MoveNext();
//Console.Write(data[i,j]);
}
}
return data;
}
}
