public void Init()
{
if (bdd.Indices.Count() == 0)
{
MultiMondeParam newParam = new MultiMondeParam();
bdd.Parametres.Add(newParam);
Indice estox = new Indice("estox", "eur", 0);
bdd.Indices.Add(estox);
newParam.Indices.Add(estox);
Indice sp500 = new Indice("sp500", "usd", 0);
bdd.Indices.Add(sp500);
newParam.Indices.Add(sp500);
Indice n225 = new Indice("n225", "jpy", 0);
bdd.Indices.Add(n225);
newParam.Indices.Add(n225);
Indice hang = new Indice("hang", "hkd", 0);
bdd.Indices.Add(hang);
newParam.Indices.Add(hang);
Indice ftse = new Indice("ftse", "gbp", 0);
bdd.Indices.Add(ftse);
newParam.Indices.Add(ftse);
Indice asx = new Indice("asx", "aud", 0);
bdd.Indices.Add(asx);
newParam.Indices.Add(asx);
newParam.NbIndices = 6;
newParam.NbSamples = 1000;
bdd.SaveChanges();
}
}
internal void modifierIndiceVolTDC(int id, double vol)
{
Indice indAmodifier = bdd.Indices.FirstOrDefault(indice => indice.Id == id);
if (indAmodifier != null)
{
indAmodifier.MoneyVol = vol;
bdd.SaveChanges();
}
}
internal void modifierIndice(int id, double interestRateThisArea, double vol)
{
Indice indAmodifier = bdd.Indices.FirstOrDefault(indice => indice.Id == id);
if (indAmodifier != null)
{
indAmodifier.InterestRateThisArea = interestRateThisArea;
indAmodifier.Vol = vol;
bdd.SaveChanges();
}
}
internal void setCorrIndice(int id, double corrEstoxx, double corrSP500, double corrN225, double corrHANG, double corrFTSE, double corrASX, double corrEURUSD, double corrEURJPY, double corrEURHKD, double corrEURGBP, double corrEURAUD)
{
Indice indAmodifier = bdd.Indices.FirstOrDefault(indice => indice.Id == id);
if (indAmodifier != null)
{
indAmodifier.corrESTOXX = corrEstoxx;
indAmodifier.corrSP500 = corrSP500;
indAmodifier.corrN225 = corrN225;
indAmodifier.corrHANG = corrHANG;
indAmodifier.corrFTSE = corrFTSE;
indAmodifier.corrASX = corrASX;
indAmodifier.corrEURUSD = corrEURUSD;
indAmodifier.corrEURJPY = corrEURJPY;
indAmodifier.corrEURHKD = corrEURHKD;
indAmodifier.corrEURGBP = corrEURGBP;
indAmodifier.corrEURAUD = corrEURAUD;
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();
}