public void Save(PackValues packValues)
{
using (var connection = new NpgsqlConnection(_connection))
{
connection.Open();
using (var tranasction = connection.BeginTransaction())
{
SaveFinInstruments(connection, packValues.FinInstruments);
SaveFinDateValues(connection, packValues.FinInstruments);
SaveFinNumericValues(connection, packValues.FinInstruments);
SaveFinStringValues(connection, packValues.FinInstruments);
SaveFinTimeSeries(connection, packValues.FinInstruments);
tranasction.Commit();
}
}
}
public void TestSave()
{
var pack = new PackValues()
{
FinInstruments = new[]
{
new FinInstrument()
{
FinId = 1,
FinIdent = "ISIN",
DataSourceId = 0,
FinDataValues = new[]
{
new FinDataValue {
FinAttriubte = "MATURITY_DATE", FromDate = constDate, Value = constDate
}
},
FinNumericValues = new[]
{
new FinNumericValue {
FinAttriubte = "FACEVALUE", FromDate = constDate, Value = 100.0m
}
},
FinStringValues = new[]
{
new FinStringValue {
FinAttriubte = "ISIN", FromDate = constDate, Value = "RU3214123"
}
},
FinTimeSerieses = new[]
{
new FinTimeSeries {
FinAttriubte = "CLOSE", Date = constDate, Value = 132.0m
}
}
}
}
};
_saverMurrData.Save(pack);
}
private PackValues ConvertToFinInstruments(Currencies exchange)
{
var list = new List <FinInstrument>();
var packValues = new PackValues()
{
FinInstruments = list
};
foreach (var currency in exchange.ValuteCursOnDates)
{
FinInstrument finInstrument = new FinInstrument()
{
FinIdent = $"{currency.VchCode}/RUB",
DataSourceId = _cbrSource,
FinStringValues = ConvertToStringValues(currency),
FinTimeSerieses = ConvertToTimerSeries(currency)
};
list.Add(finInstrument);
}
return(packValues);
}
