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