public void saveOpti(PortefeuilleIdeal port) { PortefeuilleIdeal inBdd = bdd.GetOptim.FirstOrDefault(); if (inBdd == null) { bdd.GetOptim.Add(port); } else { inBdd.Copy(port); } bdd.SaveChanges(); }
protected override void Seed(BddContext context) { MultiMondeParam newParam = new MultiMondeParam(); context.Parametres.Add(newParam); DataStorage ds = new DataStorage(); ds.FillDataHtml("full", 2500, 2500); IndexesAtDate fillIndexDataBase; TauxDeChange fillChangeDataBase; double[] index = new double[6]; double[] change = new double[5]; var allIndexKeys = ds.asx.Keys.Union(ds.estox.Keys).Union(ds.ftse.Keys).Union(ds.hang.Keys).Union(ds.n225.Keys).Union(ds.sp500.Keys); foreach (DateTime key in allIndexKeys) { #region keyCheckIndex try { if (ds.estox[key] != 0) { index[0] = ds.estox[key]; } else { index[0] = -1; } } catch (KeyNotFoundException) { index[0] = -1; } try { if (ds.ftse[key] != 0) { index[1] = ds.ftse[key]; } else { index[1] = -1; } } catch (KeyNotFoundException) { index[1] = -1; } try { if (ds.sp500[key] != 0) { index[2] = ds.sp500[key]; } else { index[2] = -1; } } catch (KeyNotFoundException) { index[2] = -1; } try { if (ds.n225[key] != 0) { index[3] = ds.n225[key]; } else { index[3] = -1; } } catch (KeyNotFoundException) { index[3] = -1; } try { if (ds.hang[key] != 0) { index[4] = ds.hang[key]; } else { index[4] = -1; } } catch (KeyNotFoundException) { index[4] = -1; } try { if (ds.asx[key] != 0) { index[5] = ds.asx[key]; } else { index[5] = -1; } } catch (KeyNotFoundException) { index[5] = -1; } #endregion keyCheck fillIndexDataBase = new IndexesAtDate(key, index[5], index[0], index[1], index[2], index[3], index[4]); context.IndexesValue.Add(fillIndexDataBase); //newParam.IndexesValue.Add(fillIndexDataBase); } var allChangeKeys = ds.EurAud.Keys.Union(ds.EurGbp.Keys).Union(ds.EurHkd.Keys).Union(ds.EurJpy.Keys).Union(ds.EurUsd.Keys); foreach (DateTime key in allChangeKeys) { #region keyCheckChange try { if (ds.EurUsd[key] != 0) { change[0] = ds.EurUsd[key]; } else { change[0] = -1; } } catch (KeyNotFoundException) { change[0] = -1; } try { if (ds.EurAud[key] != 0) { change[1] = ds.EurAud[key]; } else { change[1] = -1; } } catch (KeyNotFoundException) { change[1] = -1; } try { if (ds.EurGbp[key] != 0) { change[2] = ds.EurGbp[key]; } else { change[2] = -1; } } catch (KeyNotFoundException) { change[2] = -1; } try { if (ds.EurJpy[key] != 0) { change[3] = ds.EurJpy[key]; } else { change[3] = -1; } } catch (KeyNotFoundException) { change[3] = -1; } try { if (ds.EurHkd[key] != 0) { change[4] = ds.EurHkd[key]; } else { change[4] = -1; } } catch (KeyNotFoundException) { change[4] = -1; } #endregion keyCheckChange fillChangeDataBase = new TauxDeChange(key, change[0], change[1], change[2], change[3], change[4]); context.GetTaux.Add(fillChangeDataBase); } newParam.NbIndices = 6; newParam.NbSamples = 100000; PortefeuilleCouverture newPort = new PortefeuilleCouverture(); context.GetPort.Add(newPort); Indice estox = new Indice("estoxx", "eur", 0.001); context.Indices.Add(estox); newParam.Indices.Add(estox); Indice sp500 = new Indice("sp500", "usd", 0.00135); context.Indices.Add(sp500); newParam.Indices.Add(sp500); Indice n225 = new Indice("n225", "jpy", 0.001); context.Indices.Add(n225); newParam.Indices.Add(n225); Indice hang = new Indice("hang", "hkd", 0.01); context.Indices.Add(hang); newParam.Indices.Add(hang); Indice ftse = new Indice("ftse", "gbp", 0.005); context.Indices.Add(ftse); newParam.Indices.Add(ftse); Indice asx = new Indice("asx", "aud", 0.015); context.Indices.Add(asx); newParam.Indices.Add(asx); PortefeuilleCouverture port = new PortefeuilleCouverture(); context.GetPort.Add(port); PortefeuilleIdeal port2 = new PortefeuilleIdeal(); context.GetOptim.Add(port2); base.Seed(context); context.SaveChanges(); }
internal void SetPort(PortefeuilleIdeal idealPort) { bdd.GetPort.FirstOrDefault().Copy(idealPort); bdd.SaveChanges(); }