/// <summary>
/// Validar usuario
/// </summary>
/// <param name="obclsUsuarios">Objeto usuario</param>
/// <returns>Confirmacion</returns>
public bool getValidarUsuario(Models.clsUsuarios obclsUsuarios)
{
try
{
DataSet dsConsulta = new DataSet();
_SqlConnection = new SqlConnection(stConexion);
_SqlConnection.Open();
_SqlCommand = new SqlCommand("spConsultarUsuario", _SqlConnection);
_SqlCommand.CommandType = CommandType.StoredProcedure;
_SqlCommand.Parameters.Add(new SqlParameter("@cLogin", obclsUsuarios.stLogin));
_SqlCommand.Parameters.Add(new SqlParameter("@cPassword", obclsUsuarios.stPassword));
_SqlCommand.ExecuteNonQuery();
_SqlDataAdapter = new SqlDataAdapter(_SqlCommand);
_SqlDataAdapter.Fill(dsConsulta);
if (dsConsulta.Tables[0].Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex) { throw ex; }
finally { _SqlConnection.Close(); }
}
/// <summary>
/// ADministrar registro usuario
/// </summary>
/// <returns>Mensaje de proceso</returns>
public string setUsuario(Models.clsUsuarios ob)
{
try
{
_SqlConnection = new SqlConnection(stConexion);
_SqlConnection.Open();
_SqlCommand = new SqlCommand("spRegistrarUsuario", _SqlConnection);
_SqlCommand.CommandType = CommandType.StoredProcedure;
_SqlCommand.Parameters.Add(new SqlParameter("@cNombre", ob.stNombre));
_SqlCommand.Parameters.Add(new SqlParameter("@cApellido", ob.stApellido));
_SqlCommand.Parameters.Add(new SqlParameter("@cCorreo", ob.stUsuario));
_SqlCommand.Parameters.Add(new SqlParameter("@cContraseña", ob.stContraseña));
_SqlCommand.Parameters.Add(new SqlParameter("@cTelefono", ob.inTelefono));
_SqlCommand.Parameters.Add(new SqlParameter("@cTipoUsuario", "1"));
_SqlParameter = new SqlParameter();
_SqlParameter.ParameterName = "@cMensaje";
_SqlParameter.Direction = ParameterDirection.Output;
_SqlParameter.SqlDbType = SqlDbType.VarChar;
_SqlParameter.Size = 50;
_SqlCommand.Parameters.Add(_SqlParameter);
_SqlCommand.ExecuteNonQuery();
return(_SqlParameter.Value.ToString());
}
catch (Exception ex) { throw ex; }
finally { _SqlConnection.Close(); }
}
/// <summary>
/// CREAR CUENTA DE USUARIO
/// </summary>
/// <param name="obclsUsuarios">OBJETO USUARIO</param>
/// <returns>MENSAJE DE BBDD</returns>
public string setCrearCuenta(Models.clsUsuarios obclsUsuarios, int inOpcion)
{
try
{
DataSet dsConsulta = new DataSet();
_SqlConnection = new SqlConnection(stConexion);
_SqlConnection.Open();
_SqlCommand = new SqlCommand("spAdministrarUsuarios", _SqlConnection);
_SqlCommand.CommandType = CommandType.StoredProcedure;
//PARAMETROS DE ENTRADA
_SqlCommand.Parameters.Add(new SqlParameter("@cLogin", obclsUsuarios.stLogin));
_SqlCommand.Parameters.Add(new SqlParameter("@cPassword", obclsUsuarios.stPassword));
_SqlCommand.Parameters.Add(new SqlParameter("@cImagen", obclsUsuarios.stImagen));
_SqlCommand.Parameters.Add(new SqlParameter("@nOpcion", inOpcion));
//PARAMETROS DE SALIDA
_SqlParameter = new SqlParameter();
_SqlParameter.ParameterName = "@cMensaje";
_SqlParameter.Direction = ParameterDirection.Output;
_SqlParameter.SqlDbType = SqlDbType.VarChar;
_SqlParameter.Size = 50;
_SqlCommand.Parameters.Add(_SqlParameter);
_SqlCommand.ExecuteNonQuery();
return(_SqlParameter.Value.ToString());
}
catch (Exception ex) { throw ex; }
finally { _SqlConnection.Close(); }
}
public DataSet getConsultarPassword(Models.clsUsuarios obclsUsuarios)
{
try
{
DataSet dsConsulta = new DataSet();
_SqlConnection = new SqlConnection(stConexion);
_SqlConnection.Open();
_SqlCommand = new SqlCommand("spConsultarPassword", _SqlConnection);
_SqlCommand.CommandType = CommandType.StoredProcedure;
_SqlCommand.Parameters.Add(new SqlParameter("@cCorreo", obclsUsuarios.stCorreo));
_SqlCommand.ExecuteNonQuery();
_SqlDataAdapter = new SqlDataAdapter(_SqlCommand);
_SqlDataAdapter.Fill(dsConsulta);
return(dsConsulta);
}
catch (Exception ew)
{
throw ew;
}
finally { _SqlConnection.Close(); }
}
