public string UserRegistration(UserRegistrationDto userRegistrationDto)
{
using (SqlConnection conn = new SqlConnection(this.DBString))
{
var keyNew = SaltGenerator.GeneratePassword(10);
userRegistrationDto.password = SaltGenerator.Base64Encode(
SaltGenerator.EncodePassword(userRegistrationDto.password, keyNew));
using (SqlCommand cmd = new SqlCommand("spUserRegistration", conn)
{
CommandType = CommandType.StoredProcedure
})
{
cmd.Parameters.AddWithValue("@email", userRegistrationDto.email);
cmd.Parameters.AddWithValue("@email_verified", true);
cmd.Parameters.AddWithValue("@full_name", userRegistrationDto.fullName);
cmd.Parameters.AddWithValue("@password", userRegistrationDto.password);
cmd.Parameters.AddWithValue("@phone_no", userRegistrationDto.phoneNo);
cmd.Parameters.AddWithValue("@registration_date", DateTime.Now);
cmd.Parameters.AddWithValue("@user_role", userRegistrationDto.userRole);
cmd.Parameters.AddWithValue("@key_new", keyNew);
cmd.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output;
try
{
conn.Open();
cmd.ExecuteNonQuery();
string id = cmd.Parameters["@id"].Value.ToString();
if (id != "")
{
var GeneratedToken = this.GenerateJSONWebToken(Convert.ToInt32(id), "User");
MessagingService.Send("Verify Email", "Click on below given link to verify your email id " +
"<br/> <a href='http://*****:*****@gmail.com");
return(id);
}
}
catch
{
return(null);
}
finally
{
conn.Close();
}
}
}
return("");
}
public string ResetPassword(ResetPasswordDto resetPasswordDto, string userId)
{
using (SqlConnection conn = new SqlConnection(this.DBString))
{
var keyNew = SaltGenerator.GeneratePassword(10);
resetPasswordDto.password = SaltGenerator.Base64Encode(
SaltGenerator.EncodePassword(resetPasswordDto.password, keyNew));
using (SqlCommand cmd = new SqlCommand("spUserResetPassword", conn)
{
CommandType = CommandType.StoredProcedure
})
{
cmd.Parameters.AddWithValue("@user_id", userId);
cmd.Parameters.AddWithValue("@password", resetPasswordDto.password);
cmd.Parameters.AddWithValue("@key_new", keyNew);
try
{
conn.Open();
int id = cmd.ExecuteNonQuery();
if (id > 0)
{
return("Reset Password Successfully");
}
}
catch
{
return(null);
}
finally
{
conn.Close();
}
}
}
return("Failed To Reset Password");
}