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