private UserItemToRecover LoginAndMailValidation(String seekingLogin, String seekingMail)
{
DataClassesDataContext d = new DataClassesDataContext();
var query = from u in d.Users where ((u.Login == seekingLogin) && (u.E_mail == seekingMail)) select u;
bool notEmpty = query.Any();
UserItemToRecover result;
if( notEmpty ) {
result = new UserItemToRecover(query.First().UserID);
}
else {
result = null;
}
d.Dispose();
return result;
}
private UserItemToRecover LoginAndMailValidation(String seekingLogin, String seekingMail)
{
DataClassesDataContext d = new DataClassesDataContext();
var query = from u in d.Users where ((u.Login == seekingLogin) && (u.E_mail == seekingMail)) select u;
bool notEmpty = query.Any();
UserItemToRecover result;
if (notEmpty)
{
result = new UserItemToRecover(query.First().UserID);
}
else
{
result = null;
}
d.Dispose();
return(result);
}
protected void Button1_Click(object sender, EventArgs e)
{
UserItemToRecover ValidationItem = LoginAndMailValidation(TextBox1.Text, TextBox2.Text);
if (ValidationItem != null)
{
String newPassword = StringGen.GenString();
PasswordSaltAndHash sah = new PasswordSaltAndHash(newPassword);
String query = SendPasswordToDatabase(sah.getPasswordSalt(), sah.getPasswordHash(), ValidationItem);
try
{
SQLConnector.ProcessQuery(query);
Panel1.Visible = false;
Panel2.Visible = true;
Label1.Text = "<p class=\"center\">Hasło zostało zmienione pomyślnie. Nowe hasło brzmi: " + newPassword + "</p>";
}
catch (System.Data.SqlClient.SqlException ex)
{
Panel1.Visible = false;
Panel2.Visible = true;
Label1.Text = "<p class=\"center\">Baza wygenerowała następującego errora: " + ex.Message + "</p>";
}
}
}
private String SendPasswordToDatabase(String PasswordSalt, String PasswordHash, UserItemToRecover ValidationItem)
{
return "UPDATE Users SET PasswordSalt = '" + PasswordSalt + "', PasswordHash='" + PasswordHash + "' WHERE UserID = " + ValidationItem.getId() + ";";
}
private String SendPasswordToDatabase(String PasswordSalt, String PasswordHash, UserItemToRecover ValidationItem)
{
return("UPDATE Users SET PasswordSalt = '" + PasswordSalt + "', PasswordHash='" + PasswordHash + "' WHERE UserID = " + ValidationItem.getId() + ";");
}
