public DataTable Consulta(string id = "")
{
StringBuilder sqlQuery = new StringBuilder();
SqlCommand comando = new SqlCommand();
DataTable tabla = new DataTable();
try
{
sqlQuery.Append(" Select * from usuarios ");
if (id != "")
{
sqlQuery.Append(" where correo = @usuario ");
comando.Parameters.Add("@usuario", SqlDbType.NVarChar).Value = id;
tabla = objCapaDatos.EjecutarConsulta(sqlQuery, comando);
}
else
{
tabla = objCapaDatos.EjecutarConsulta(sqlQuery);
}
return(tabla);
}
catch (Exception)
{
throw new Exception("Error en la consulta");
}
}
public DataTable consultaProg(int id)
{
capaDatos objCapaDatos = new capaDatos();
StringBuilder sqlQuery = new StringBuilder();
SqlCommand comando = new SqlCommand();
DataTable tabla = new DataTable();
try
{
sqlQuery.Append(" Select * from progreso where iduser = @usuario ");
if (id > 0)
{
comando.Parameters.Add("@usuario", SqlDbType.Int).Value = id;
tabla = objCapaDatos.EjecutarConsulta(sqlQuery, comando);
}
return(tabla);
}
catch (Exception)
{
throw new Exception("Error en la consulta");
}
}