protected void btConfirmar_Click(object sender, EventArgs e)
{
string guid = Request.QueryString["guid"];
if (PasswordDAO.GetNewPwdRequestDataByGUID(guid) == null)
{
lbMensagem.ForeColor = System.Drawing.Color.Red;
lbMensagem.Text = "Guid inválido!<br />Contacte o administrador ou faça um novo pedido...";
tbxConfirmPassword.Enabled = false;
tbxPassword.Enabled = false;
btConfirmar.Enabled = false;
hlLogin.Text = "Voltar";
}
else
{
ResetPwdRequests resetPwd = PasswordDAO.GetNewPwdRequestDataByGUID(guid);
User user = UserDAO.GetUserByEmail(resetPwd.email);
int returncode = PasswordDAO.ResetPassword(user.id_User, tbxPassword.Text);
if (returncode == -1)
{
lbMensagem.ForeColor = System.Drawing.Color.Red;
lbMensagem.Text = "Guid inválido!<br />Contacte o administrador ou faça um novo pedido...";
tbxConfirmPassword.Enabled = false;
tbxPassword.Enabled = false;
btConfirmar.Enabled = false;
hlLogin.Text = "Voltar";
}
else
{
int return_code = PasswordDAO.DeletePwdRequestByEmail(resetPwd.email);
if (return_code == -1)
{
lbMensagem.ForeColor = System.Drawing.Color.Red;
lbMensagem.Text = "Guid inválido!<br />Contacte o administrador ou faça um novo pedido...";
tbxConfirmPassword.Enabled = false;
tbxPassword.Enabled = false;
btConfirmar.Enabled = false;
hlLogin.Text = "Voltar";
}
else
{
lbMensagem.ForeColor = System.Drawing.Color.Green;
lbMensagem.Text = "Reposição efetuada com sucesso!";
tbxConfirmPassword.Enabled = false;
tbxPassword.Enabled = false;
btConfirmar.Enabled = false;
hlLogin.Text = "Voltar";
}
}
}
}
public static ResetPwdRequests GetNewPwdRequestDataByGUID(string guid)
{
using (SqlConnection connection = new SqlConnection())
{
connection.ConnectionString = ConfigurationManager.ConnectionStrings["GameLibraryDBCS"].ConnectionString;
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandText = "sp_GetPwdRequestDataByGUID";
command.Parameters.AddWithValue("@guid", guid);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
using (SqlDataReader dataReader = command.ExecuteReader())
{
if (dataReader.Read())
{
if (Convert.ToInt32(dataReader["ReturnCode"]) == -1)
{
return(null);
}
if (dataReader.NextResult())
{
dataReader.Read();
ResetPwdRequests pwdRequests = new ResetPwdRequests()
{
id_resetPwdRequest = Convert.ToInt32(dataReader["id_resetPwdRequest"]),
email = dataReader["email"].ToString(),
guid = dataReader["guid"].ToString(),
date_recovery_request = Convert.ToDateTime(dataReader["date_recovery_request"].ToString())
};
return(pwdRequests);
}
}
return(null);
}
}
}
}