public List <OmadaUser> GetTeamLeaders(OmadaTeam team) { List <OmadaUser> teamUsers = new List <OmadaUser>(); using (SqlConnection connection = DatabaseConnector.CreateConnection()) { using (SqlCommand command = connection.CreateCommand()) { command.CommandText = @"SELECT dbo.AspNetUsers.Id, dbo.AspNetUsers.UserName, dbo.AspNetUsers.Email FROM dbo.Users_Teams JOIN DBO.AspNetUsers ON Dbo.AspNetUsers.Id = dbo.Users_Teams.UserId AND dbo.Users_Teams.TeamId = @teamId AND dbo.Users_Teams.IsLeader = 1"; command.Parameters.AddWithValue("@teamId", team.Id); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { OmadaUser user = new OmadaUser(); user.Id = reader.GetString(0); user.UserName = reader.GetString(1); user.Email = reader.GetString(2); teamUsers.Add(user); } } } } return(teamUsers); }
public OmadaUser Edit(OmadaUser updatedUser) { var entity = db.Users.Attach(updatedUser); entity.State = EntityState.Modified; return(updatedUser); }
public List <NotTeamMember> UsersNotInTeam(int teamId) { List <NotTeamMember> teamUsersList = new List <NotTeamMember>(); using (SqlConnection connection = DatabaseConnector.CreateConnection()) { using (SqlCommand command = connection.CreateCommand()) { command.CommandText = @"SELECT Id, UserName FROM dbo.AspNetUsers WHERE Id NOT IN (SELECT UserId FROM dbo.Users_Teams WHERE TeamId = @teamId)" ; command.Parameters.AddWithValue("@teamId", teamId); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { OmadaUser user = new OmadaUser(); user.Id = reader.GetString(0); user.UserName = reader.GetString(1); teamUsersList.Add(new NotTeamMember() { User = user, IsSelected = false }); } } } } return(teamUsersList); }
public IActionResult OnGet(string userId) { DeletedUser = userData.GetUserById(userId); if (DeletedUser == null) { return(RedirectToPage("../NotFound")); } return(Page()); }
public OmadaUser Delete(string id) { OmadaUser user = GetUserById(id); if (user != null) { db.Remove(user); } return(user); }
public IActionResult OnPost(string userId) { DeletedUser = userData.Delete(userId); userData.Commit(); if (DeletedUser == null) { return(RedirectToPage("../NotFound")); } return(RedirectToPage("../UsersList")); }
public async Task <IActionResult> OnPostAsync(string returnUrl = null) { returnUrl = returnUrl ?? Url.Content("~/"); ExternalLogins = (await _signInManager.GetExternalAuthenticationSchemesAsync()).ToList(); if (ModelState.IsValid) { var user = new OmadaUser { UserName = Input.Email, Email = Input.Email }; var result = await _userManager.CreateAsync(user, Input.Password); if (result.Succeeded) { _logger.LogInformation("User created a new account with password."); var code = await _userManager.GenerateEmailConfirmationTokenAsync(user); code = WebEncoders.Base64UrlEncode(Encoding.UTF8.GetBytes(code)); var callbackUrl = Url.Page( "/Account/ConfirmEmail", pageHandler: null, values: new { area = "Identity", userId = user.Id, code = code }, protocol: Request.Scheme); await _emailSender.SendEmailAsync(Input.Email, "Confirm your email", $"Please confirm your account by <a href='{HtmlEncoder.Default.Encode(callbackUrl)}'>clicking here</a>."); if (_userManager.Options.SignIn.RequireConfirmedAccount) { return(RedirectToPage("RegisterConfirmation", new { email = Input.Email })); } else { await _signInManager.SignInAsync(user, isPersistent : false); return(LocalRedirect(returnUrl)); } } foreach (var error in result.Errors) { ModelState.AddModelError(string.Empty, error.Description); } } // If we got this far, something failed, redisplay form return(Page()); }
public static async Task RefreshLoginAsync(this HttpContext context) { if (context.User == null) { return; } var userManager = context.RequestServices .GetRequiredService <UserManager <OmadaUser> >(); var signInManager = context.RequestServices .GetRequiredService <SignInManager <OmadaUser> >(); OmadaUser user = await userManager.GetUserAsync(context.User); if (signInManager.IsSignedIn(context.User)) { await signInManager.RefreshSignInAsync(user); } }
public ActionResult OnPost([FromBody] int teamId) { Team = teamData.GetTeamById(teamId); List <OmadaUser> leaders = teamData.GetTeamLeaders(Team); EmailSender emailSender = new EmailSender(); foreach (var leader in leaders) { string email = leader.Email; string userId = userManager.GetUserId(HttpContext.User); OmadaUser user = userManager.FindByIdAsync(userId).Result; string subject = "Request to be added to team"; string body = $"Hi {leader.UserName}, <br/>" + $"{user.UserName} wants to join your team {Team.Name}<br/>" + $"Click below to make a decision<br/>" + $"<a href='{emailSender.DomainName}/AddUserToTeam/{user.Id}'>Add User To Team</a>"; if (!emailSender.SendEmail(email, subject, body)) { return(StatusCode((int)HttpStatusCode.InternalServerError, "Error occurred during sending email! Please, try again later")); } } return(StatusCode((int)HttpStatusCode.OK, "Request Sent")); }
public List <OmadaUser> GetAllUsers() { List <OmadaUser> users = new List <OmadaUser>(); using (SqlConnection connection = DatabaseConnector.CreateConnection()) { using (SqlCommand command = connection.CreateCommand()) { command.CommandText = @"SELECT Id, Email FROM dbo.AspNetUsers"; using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { OmadaUser user = new OmadaUser(); user.Id = reader.GetString(0); user.Email = reader.GetString(1); users.Add(user); } } } return(users); } }
public string GetUserEmail(OmadaUser user) { return(db.Users.Find(user).Email); }
public OmadaUser Add(OmadaUser newUser) { db.Add(newUser); return(newUser); }