public static bool ConfirmPassword(string password, int userId)
{
try
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
string oldPassword = (from u in data.UserDataProviders
where u.id == userId
select u.password).FirstOrDefault();
return oldPassword != null && oldPassword == password;
}
}
catch (Exception)
{
return false;
}
}