public bool ConfirmEmail(Guid tokenId)
{
bool result = false;
Token token = UserTokensService.Get(tokenId);
ApplicationUserManager userManager = UserService.GetUserManager();
ApplicationUser user = userManager.FindByName(token.UserName);
if (user != null)
{
// Set the EmailConfirmed flag in AspNetUsers table
DataProvider.ExecuteNonQuery(GetConnection, "dbo.AspNetUsers_UpdateEmailConfirmed"
, inputParamMapper : delegate(SqlParameterCollection UpdateEmailConfirmed)
{
UpdateEmailConfirmed.AddWithValue("@EmailConfirmed", true);
UpdateEmailConfirmed.AddWithValue("@UserName", token.UserName);
});
// Insert new record in Users table
ApplicationUser au = UserService.GetUserbyUserName(token.UserName);
UserInfoAddRequest req = new UserInfoAddRequest();
req.UserName = token.UserName;
req.Phone = au.PhoneNumber;
req.Email = au.Email;
Insert(req, au.Id);
// Delete the token from UserTokens table
UserTokensService.Delete(tokenId);
result = true;
}
return(result);
}
public static bool IsUser(string UserName)
{
bool result = false;
ApplicationUserManager userManager = GetUserManager();
IAuthenticationManager authenticationManager = HttpContext.Current.GetOwinContext().Authentication;
ApplicationUser user = userManager.FindByName(UserName);
if (user != null)
{
result = true;
// Set the EmailConfirmed value in AspNetUsers table
DataProvider.ExecuteNonQuery(GetConnection, "dbo.AspNetUsers_UpdateEmailConfirmed"
, inputParamMapper : delegate(SqlParameterCollection UpdateEmailConfirmed)
{
UpdateEmailConfirmed.AddWithValue("@EmailConfirmed", result);
UpdateEmailConfirmed.AddWithValue("@UserName", UserName);
});
}
return(result);
}
