public Ent_Recov_Pass recovery_pass(string password, string codigo)
{
string sqlquery = "USP_MVC_RecuperaPassword";
Ent_Recov_Pass recov = null;
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
try
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@password", password);
cmd.Parameters.AddWithValue("@codigo", codigo);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
recov = new Ent_Recov_Pass();
while (dr.Read())
{
recov.COD_ERROR = dr["COD_ERROR"].ToString();
recov.DESCRIPCION_ERROR = dr["DESCRIPCION_ERROR"].ToString();
}
}
}
}
catch (Exception)
{
recov = null;
}
if (cn != null)
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
}
}
catch
{
recov = null;
}
return(recov);
}
public Ent_Recov_Pass get_recov_pass(string _usv_username, string documento)
{
string sqlquery = "USP_Envia_CorreoRecuperaPassword";
Ent_Recov_Pass recov = null;
try
{
using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion))
{
try
{
if (cn.State == 0)
{
cn.Open();
}
using (SqlCommand cmd = new SqlCommand(sqlquery, cn))
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@nombreUsuario", _usv_username);
cmd.Parameters.AddWithValue("@numeroDocumento", documento);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
recov = new Ent_Recov_Pass();
while (dr.Read())
{
recov.COD_ERROR = dr["COD_ERROR"].ToString();
recov.DESCRIPCION_ERROR = dr["DESCRIPCION_ERROR"].ToString();
}
}
}
}
catch (Exception)
{
recov = null;
}
if (cn != null)
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
}
}
catch
{
recov = null;
}
return(recov);
}
public ActionResult EnviaRecoveryPass(string usuario)
{
Dat_Recov_Pass dat_usuario = new Dat_Recov_Pass();
Ent_Recov_Pass _recov_pass = dat_usuario.get_recov_pass(usuario, "");
if (_recov_pass == null)
{
_recov_pass = new Ent_Recov_Pass();
_recov_pass.COD_ERROR = "-2";
_recov_pass.DESCRIPCION_ERROR = "Error en el servidor";
}
return(Json(new { estado = _recov_pass.COD_ERROR, desmsg = _recov_pass.DESCRIPCION_ERROR }));
}
public ActionResult RecoveryPass(string codigo, string pass)
{
Dat_Recov_Pass dat_usuario = new Dat_Recov_Pass();
Ent_Recov_Pass _recov_pass = dat_usuario.recovery_pass(pass, codigo);
//_recov_pass = new Ent_Recov_Pass();
//_recov_pass.COD_ERROR = "0";
//_recov_pass.DESCRIPCION_ERROR = "Se generaro la nueva contraseña";
if (_recov_pass == null)
{
_recov_pass = new Ent_Recov_Pass();
_recov_pass.COD_ERROR = "-2";
_recov_pass.DESCRIPCION_ERROR = "Error en el servidor";
}
return(Json(new { estado = _recov_pass.COD_ERROR, desmsg = _recov_pass.DESCRIPCION_ERROR }));
}
