private int?GetExchangeIdByName(string name)
{
string commandString = "SELECT Id FROM ExchangeDetails WHERE Name = @ExchangeName;";
using (IMySqlCommandWrapper commandWrapper = _commandWrapperFactory.GetCommandWrapper(commandString, _connectionWrapper))
{
commandWrapper.AddParameter("@ExchangeName", name);
lock (_lockObject)
{
using (IMySqlDataReaderWrapper dataReader = commandWrapper.ExecuteReader())
{
if (!dataReader.HasRows || !dataReader.ReadNext())
{
return(null);
}
return(dataReader.GetField <int?>("Id"));
}
}
}
}
