public Guid GetOrCreateParticipant(ParticipantDto participant)
{
var emailHash = StringHelper.Md5HashEncode(participant.Email.ToLower());
if (_consumerManager.IsAlreadyExistingConsumerId(participant.Country, emailHash, out var consumerCrmId))
{
//var query = new Sql()
// .Select("*")
// .From<Participant>(_sqlProvider)
// .Where<Participant>(cons => cons.ConsumerCrmId == consumerCrmId, _sqlProvider);
var sqlQuery = "SELECT * FROM Participant WHERE ConsumerCrmId = @0";
return(_database.Fetch <Participant>(sqlQuery, consumerCrmId).FirstOrDefault().Id);
}
if (!string.IsNullOrEmpty(participant.ConsumerId))
{
var crmConsumerId = _consumerManager.GetOrCreateConsumerId(participant.ConsumerId, participant.Country, emailHash);
participant.ConsumerCrmId = crmConsumerId;
}
return(Create(participant.toEntity()));
}
