public void Update(RaceOrganizer value)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
string query = @"
UPDATE [itsRunning].[RaceOrganizer]
SET [FirstName] = @FirstName
,[LastName] = @LastName
,[Username] = @Username
WHERE Id = @Id";
connection.Query(query, value);
}
}
public async Task <IActionResult> Register(RegisterViewModel model, string returnUrl = null)
{
ViewData["ReturnUrl"] = returnUrl;
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email,
Email = model.Email,
FirstName = model.FirstName,
LastName = model.LastName,
//Username = model.Username
};
var result = await _userManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
//insert race organizer into race organizer's table
var raceOrganizer = new RaceOrganizer
{
FirstName = model.FirstName,
LastName = model.LastName,
Username = model.Email
};
_raceOrganizerRepository.Insert(raceOrganizer);
_logger.LogInformation("User created a new account with password.");
var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
var callbackUrl = Url.EmailConfirmationLink(user.Id, code, Request.Scheme);
await _emailSender.SendEmailConfirmationAsync(model.Email, callbackUrl);
await _signInManager.SignInAsync(user, isPersistent : false);
_logger.LogInformation("User created a new account with password.");
return(RedirectToLocal(returnUrl));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public void Insert(RaceOrganizer value)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
string query = @"
INSERT INTO [itsRunning].[RaceOrganizer]
([FirstName]
,[LastName]
,[Username])
VALUES
(@FirstName
,@LastName
,@Username)";
connection.Query(query, value);
}
}
