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); } }