public List <Models.Usuario> ListaDeSolicitacao(Models.Usuario usuario)
{
var conexaoString = Dao.Caminho();
List <Models.Usuario> ListaAmigo = new List <Models.Usuario>();
using (SqlConnection connection = new SqlConnection(conexaoString))
{
SqlCommand command = new SqlCommand($"SELECT * FROM AMIZADE WHERE Aceito = '{false}' AND DestinoId = {usuario.UsuarioId}", connection);
try
{
connection.Open();
using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
Models.Amigo amigo = new Models.Amigo();
amigo.OrigemId = (int)reader["OrigemId"];
ListaAmigo.Add(UsuarioRepositorio.SelecionarUsuario(amigo.OrigemId));
}
}
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
}
return(ListaAmigo);
}
}
public static List <Models.Usuario> AmigosLista(Models.Usuario usuario)
{
List <Models.Usuario> usuariosList = new List <Models.Usuario>();
var connectionString = Dao.Caminho();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("SELECT * FROM AMIZADE WHERE (OrigemId = @DestinoId OR DestinoId = @DestinoId) AND (Aceito = @Aceito)", connection);
command.Parameters.AddWithValue("@DestinoId", usuario.UsuarioId);
command.Parameters.AddWithValue("@Aceito", true);
try
{
connection.Open();
using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
Models.Amigo user = new Models.Amigo();
user.OrigemId = (int)reader["OrigemId"];
if (user.OrigemId != usuario.UsuarioId)
{
usuariosList.Add(UsuarioRepositorio.SelecionarUsuario(user.OrigemId));
}
else
{
user.DestinoId = (int)reader["DestinoId"];
usuariosList.Add(UsuarioRepositorio.SelecionarUsuario(user.DestinoId));
}
}
}
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
}
return(usuariosList);
}
}
public IEnumerable <Models.Postagens> ListaPostagem(Models.Usuario usuario)
{
List <Models.Postagens> listaPost = new List <Models.Postagens>();
var conexaoString = Dao.Caminho();
using (var conexao = new SqlConnection(conexaoString))
{
SqlCommand command = new SqlCommand("SELECT * FROM AMIZADE, POSTAGENS WHERE (OrigemId = @DestinoId OR DestinoId = @DestinoId) AND (Aceito = @Aceito)", conexao);
command.Parameters.AddWithValue("@DestinoId", usuario.UsuarioId);
command.Parameters.AddWithValue("Aceito", true);
try
{
conexao.Open();
using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
using (SqlConnection connection = new SqlConnection(conexaoString))
{
SqlCommand command2 = new SqlCommand($"SELECT * FROM POSTAGENS WHERE ", connection);
try
{
connection.Open();
while (reader.Read())
{
Models.Amigo user2 = new Models.Amigo();
user2.OrigemId = (int)reader["OrigemId"];
int UsuarioSession = usuario.UsuarioId;
int IdAmigo = 0;
if (user2.OrigemId != usuario.UsuarioId)
{
user2.OrigemId = (int)reader["OrigemId"];
IdAmigo = user2.OrigemId;
}
else
{
user2.DestinoId = (int)reader["DestinoId"];
IdAmigo = user2.DestinoId;
}
Models.Postagens posts = new Models.Postagens();
posts.UsuarioId = (int)reader["UsuarioId"];
//if (posts.UsuarioId == usuario.UsuarioId)
//{
// posts.PostId = (int)reader["PostId"];
// posts.UsuarioId = (int)reader["UsuarioId"];
// posts.Data = (DateTime)reader["Data"];
// posts.Midia = reader["Midia"].ToString();
// posts.Nome = reader["Nome"].ToString(); ;
// posts.Conteudo = reader["Conteudo"].ToString();
// listaPost.Add(posts);
//}
if (posts.UsuarioId == IdAmigo)
{
posts.PostId = (int)reader["PostId"];
posts.UsuarioId = (int)reader["UsuarioId"];
posts.Data = (DateTime)reader["Data"];
posts.Midia = reader["Midia"].ToString();
posts.Nome = reader["Nome"].ToString();;
posts.Conteudo = reader["Conteudo"].ToString();
listaPost.Add(posts);
}
}
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
}
}
}
}
}
catch
{
throw;
}
finally
{
conexao.Close();
}
return(listaPost);
}
}
