public string GetPasswordSalt(string username)
{
string vOut = ": Exception Occured !";
string saltedText = string.Empty;
MembershipProvider lsMembershipProvider = new MembershipProvider();
string sSqlsalt = @"SELECT Membership.PasswordSalt
FROM [dbo].[User]
INNER Join Membership
ON [dbo].[User].UserId = Membership.UserId
WHERE UserName = @UserName";
SqlConnection connection = _habibDbContext.GetConn();
connection.Open();
SqlDataReader dr;
SqlCommand command = new SqlCommand(sSqlsalt, connection);
command.Parameters.AddWithValue("UserName", username);
try
{
dr = command.ExecuteReader();
while (dr.Read())
{
saltedText = Convert.ToString(dr["PasswordSalt"]);
}
}
catch (Exception ex)
{
vOut = "Password salt not found";
throw ex;
}
saltedText = lsMembershipProvider.DecodeFromBase64String(saltedText);
return(saltedText);
}
