public override List <DataFeed> genereData(DateTime debut)
{
List <DataFeed> DataFieldCal = new List <DataFeed>();
DataHistoriqueDataContext asdc = new DataHistoriqueDataContext();
List <string> reqId = asdc.HistoricalShareValues.Select(el => el.id).ToList();
List <System.DateTime> reqDate = asdc.HistoricalShareValues.Select(el => el.date).Distinct().Where(el => el.Date >= debut).Where(el => el.Date <= this.option.option.Maturity).ToList();
reqDate.Sort();
this.listeDate = new List <DateTime>(reqDate);
List <decimal> reqValue = asdc.HistoricalShareValues.Select(el => el.value).ToList();
int i = 0;
int j = 0;
foreach (DateTime date in reqDate)
{
Dictionary <string, decimal> dico = new Dictionary <string, decimal>();
var list = asdc.HistoricalShareValues.Where(el => el.date == date).Select(el => el.id);
i++;
foreach (string id in list)
{
if (option.option.UnderlyingShareIds.Contains(id.Trim()))
{
var valeur = asdc.HistoricalShareValues.Where(el => el.date == date).Where(el => el.id == id).Select(el => el.value).First();
dico.Add(id.Trim(), valeur);
j++;
}
}
DataFeed dataFeed = new DataFeed(date, dico);
DataFieldCal.Add(dataFeed);
j = 0;
}
Console.WriteLine("il y a " + DataFieldCal.Count + " dates");
this.donnees = DataFieldCal;
return(DataFieldCal);
}
public void getDatahist()
{
/*Recuperation des donnes*/
DataHistoriqueDataContext asdc = new DataHistoriqueDataContext();
List <string> reqId = asdc.HistoricalShareValues.Select(el => el.id).Distinct().ToList();
List <System.DateTime> reqDate = asdc.HistoricalShareValues.Select(el => el.date).Distinct().ToList();
List <decimal> reqValue = asdc.HistoricalShareValues.Select(el => el.value).Distinct().ToList();
Console.WriteLine("Il y a " + reqValue.Count + " valeurs");
List <Share> listeActions = new List <Share>();
foreach (string nom in reqId)
{
listeActions.Add(new Share(nom, nom));
Console.WriteLine("Action = " + nom);
}
for (int i = 0; i < reqId.Count; ++i)
{
Console.WriteLine("ID: " + i + " " + reqId[i]);
Console.WriteLine("Date: " + reqDate[i]);
Console.WriteLine("Value: " + reqValue[i]);
}
}
public void getShareName()
{
DataHistoriqueDataContext asdc = new DataHistoriqueDataContext();
List <string> names = asdc.ShareNames.Select(el => el.name).ToList();
foreach (string name in names)
{
Console.WriteLine(name);
}
}
static void LinqLambda()
{
Console.WriteLine("Récupération à l'aide de LINQ; syntaxe 'lambda-calcul'");
using (DataHistoriqueDataContext asdc = new DataHistoriqueDataContext())
{
var q3 = asdc.HistoricalShareValues.Select(ligne => ligne.id).Distinct();
foreach (string nom in q3)
{
Console.WriteLine("Nom: {0} ", nom);
}
Console.ReadLine();
}
}
static void LinqSQL()
{
Console.WriteLine("Récupération à l'aide de LINQ; syntaxe à la SQL");
using (DataHistoriqueDataContext asdc = new DataHistoriqueDataContext())
{
var q2 = (from lignes in asdc.HistoricalShareValues
select lignes.id).Distinct();
foreach (string nom in q2)
{
Console.WriteLine("Nom: {0}", nom);
}
}
Console.ReadLine();
}
static void Main2(string[] args)
{
Console.WriteLine("Démarrer");
Console.ReadLine();
DataHistoriqueDataContext asdc = new DataHistoriqueDataContext();
List <string> reqId = asdc.HistoricalShareValues.Select(el => el.id).Distinct().ToList();
List <System.DateTime> reqDate = asdc.HistoricalShareValues.Select(el => el.date).Distinct().ToList();
List <decimal> reqValue = asdc.HistoricalShareValues.Select(el => el.value).Distinct().ToList();
for (int i = 0; i < reqId.Count; ++i)
{
Console.WriteLine("ID: " + i + " " + reqId[i]);
Console.WriteLine("Date: " + reqDate[i]);
Console.WriteLine("Value: " + reqValue[i]);
}
}
