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