private static IEnumerable<string> GetTickers()
{
var tickers = new List<string>();
using (var context = new EFMMDataClassesDataContext())
{
var result = from ticker in context.getBloombergTickers(null)
select ticker.value;
tickers.AddRange(result);
}
return tickers;
}
private static void InsertData(Element fieldData, String ticker)
{
if (IsValid(fieldData))
{
using (var context = new EFMMDataClassesDataContext())
{
context.insertBloombergDownload(fieldData.GetElementAsDate(DATE).ToDateId()
, (decimal)fieldData.GetElementAsFloat64(PX_LAST)
, fieldData.GetElementAsInt64(VWAP_VOLUME)
, fieldData.GetElementAsInt64(VWAP_LIT_VOLUME)
, ticker);
context.SubmitChanges();
}
}
else
{
Logger.WarnFormat("At least one field missing for [{0}]", ticker);
}
}
