public ActionResult GetHistorias(int id) { //Historias do perfil IEnumerable <THistoria> historias = _context.THistoria.Where(h => h.UserId == id); foreach (THistoria th in historias) { bool verificador = _context.TLikeDislike.Any(ld => ld.UserId == id && ld.HistoriaId == th.Id); if (verificador) { TLikeDislike temp = _context.TLikeDislike.Where(ld => ld.UserId == id && ld.HistoriaId == th.Id).First(); if (temp.LikeDislike == true) { th.deulike = 1; } else { th.deulike = 2; } } else { th.deulike = 0; } TUsuario user = (from usuario in _context.TUsuario where th.UserId == usuario.UserId select usuario).First(); th.username = user.Nome; } return(Json(historias)); }
public IActionResult DeletarLikeDislike(TLikeDislike like_dislike) { try{ var remover = _context.TLikeDislike.Where(r => r.UserId == like_dislike.UserId && r.HistoriaId == like_dislike.HistoriaId).First(); _context.Remove(remover); _context.SaveChanges(); return(StatusCode(200)); }catch (Exception) { return(StatusCode(500)); } }
public ActionResult FeedPrincipal(int id) { try{ var amizades = _context.TAmizade.Where(a => (a.Usuario1 == id || a.Usuario2 == id) && a.Status == "Aprovada"); List <int> id_amigos = new List <int>(); id_amigos.Add(id); foreach (TAmizade t in amizades) { if (t.Usuario1 == id) { id_amigos.Add(t.Usuario2); } else { id_amigos.Add(t.Usuario1); } } var historias_filtradas = from h in _context.THistoria where id_amigos.Contains(h.UserId) orderby h.Data descending select h; foreach (THistoria th in historias_filtradas) { bool verificador = _context.TLikeDislike.Any(ld => ld.UserId == id && ld.HistoriaId == th.Id); if (verificador) { TLikeDislike temp = _context.TLikeDislike.Where(ld => ld.UserId == id && ld.HistoriaId == th.Id).First(); if (temp.LikeDislike == true) { th.deulike = 1; } else { th.deulike = 2; } } else { th.deulike = 0; } TUsuario user = (from usuario in _context.TUsuario where th.UserId == usuario.UserId select usuario).First(); th.username = user.Nome; } return(Json(historias_filtradas)); }catch (Exception) { return(StatusCode(500)); } }
public IActionResult LikeDislike(TLikeDislike like_dislike) { try{ if (like_dislike.LikeDislike == true) { bool existente = _context.TLikeDislike.Any(ld => ld.UserId == like_dislike.UserId && ld.HistoriaId == like_dislike.HistoriaId); if (!existente) { _context.TLikeDislike.Add(like_dislike); _context.SaveChanges(); return(Json("Like inserido com sucesso!")); } else { var temp = _context.TLikeDislike.Where(ld => ld.UserId == like_dislike.UserId && ld.HistoriaId == like_dislike.HistoriaId).First(); temp.LikeDislike = true; _context.SaveChanges(); return(Json("Like atualizado com sucesso!")); } } else { bool existente = _context.TLikeDislike.Any(ld => ld.UserId == like_dislike.UserId && ld.HistoriaId == like_dislike.HistoriaId); if (!existente) { _context.TLikeDislike.Add(like_dislike); _context.SaveChanges(); return(Json("Dislike inserido com sucesso!")); } else { var temp = _context.TLikeDislike.Where(ld => ld.UserId == like_dislike.UserId && ld.HistoriaId == like_dislike.HistoriaId).First(); temp.LikeDislike = false; _context.SaveChanges(); return(Json("Dislike atualizado com sucesso!")); } } }catch (Exception) { return(StatusCode(500)); } }