public async Task <ActionResult <object> > Create([FromBody] CreateAccountRequest reqObj)
{
using (var connection = new NpgsqlConnection(this.config["ConnectionString"]))
{
var sql = $"CALL create_member_user('{reqObj.Username}', '{reqObj.Password}', '{reqObj.FirstName}', '{reqObj.LastName}')";
var result = await connection.ExecuteAsync(sql);
// TODO: Find out why the following is throwing error.
// var queryParameters = new DynamicParameters();
// queryParameters.Add("@un", reqObj.Username, dbType: DbType.AnsiString);
// queryParameters.Add("@pw", reqObj.Password, dbType: DbType.AnsiString);
// queryParameters.Add("@fn", reqObj.FirstName, dbType: DbType.AnsiString);
// queryParameters.Add("@ln", reqObj.LastName, dbType: DbType.AnsiString);
// return await connection.ExecuteAsync(
// "create_member_user",
// queryParameters,
// commandType: CommandType.StoredProcedure);
var evt = new NewUserCreatedEvent(reqObj.FirstName, reqObj.LastName, "some_uuid", reqObj.Username, "member");
this.integrationEventService.PublishThroughEventBus(evt);
return(result);
}
}
private async Task <IHttpActionResult> Handle(NewUserCreatedEvent @event)
{
string recipient = @event.Email;
const string Subject = "Välkommen till Snittlistan!";
string activationKey = @event.ActivationKey;
string id = @event.UserId;
await Emails.UserRegistered(recipient, Subject, id, activationKey);
return(Ok());
}
