public ISecurityStaticDataModel GetSecurityStaticDataModel(ISecurityStaticData securityStaticData)
{
IExchangeStaticDataModel exchangeStaticDataModel = GetExchangeStaticDataModel(securityStaticData);
var securityStaticDataModel = new SecurityStaticDataModel(exchangeStaticDataModel, securityStaticData.Symbol, securityStaticData.ShortName);
return(securityStaticDataModel);
}
private void InsertExchangeDataIfNotExists(IExchangeStaticDataModel exchangeStaticDataModel)
{
_logger.Error($"HistoricDataGrabTask: Inserting exchange data if not exists for exchange: {exchangeStaticDataModel.ExchangeName}");
if (!_persistenceManager.DoesExchangeExist(exchangeStaticDataModel))
{
_persistenceManager.InsertExchange(exchangeStaticDataModel);
}
}
public void InsertExchange(IExchangeStaticDataModel exchangeStaticData)
{
_logger.Information($"PersistenceManager: Inserting Exchange: {exchangeStaticData}");
string commandString = "INSERT INTO ExchangeDetails(Name) Values(@Name);";
var parameters = new Dictionary <string, object> {
{ "@Name", exchangeStaticData.ExchangeName }
};
ExecuteNoReadQuery(commandString, 1, parameters);
}
public bool DoesExchangeExist(IExchangeStaticDataModel exchangeStaticData)
{
_logger.Information($"PersistenceManager: Checking for the existence of exchange data: {exchangeStaticData.ExchangeName}");
int?exchangeId = GetExchangeIdByName(exchangeStaticData.ExchangeName);
string existenceLog = exchangeId.HasValue ? "exists" : "does not exist";
_logger.Information($"PersistenceManager: Exchange {exchangeStaticData.ExchangeName} {existenceLog}");
return(exchangeId.HasValue);
}
private void InsertExchangeDataIfNotExists(IExchangeStaticDataModel exchangeStaticDataModel)
{
try
{
_logger.Information($"FileBasedDataGrabTask: Inserting exchange data if not exists for exchange: {exchangeStaticDataModel.ExchangeName}");
if (!_persistenceManager.DoesExchangeExist(exchangeStaticDataModel))
{
_persistenceManager.InsertExchange(exchangeStaticDataModel);
}
}
catch(Exception exception)
{
_logger.Error($"FileBasedDataGrabTask: Error processing exchange data for exchange: {exchangeStaticDataModel.ExchangeName}");
_logger.Error(exception.ToString());
}
}
public SecurityStaticDataModel(IExchangeStaticDataModel exchangeStaticData, string symbol, string name)
{
ShortName = name;
Symbol = symbol;
ExchangeData = exchangeStaticData;
}
