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); } }