//[AllowAnonymous] public async Task <ActionResult <Storie> > Post( [FromBody] Storie model, [FromServices] DataContext context, [FromServices] IStorieService storieService, [FromServices] IUserService userService ) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var validateUser = await userService.GetById(model.UserId); if (validateUser == null) { return(BadRequest(new { message = "O usuário informado não existe" })); } var postStorie = await storieService.PostStorie(context, model); if (postStorie == null) { return(BadRequest(new { message = "Não foi possível criar o storie" })); } return(Ok(model)); }
public async Task <dynamic> DeleteStorie( DataContext context, Storie model) { try { context.Stories.Remove(model); await context.SaveChangesAsync(); return(new { okMessage = "Storie deletado com sucesso!" }); } catch { return(new { badMessage = "Não foi possível excluir o storie." }); } }
public async Task <dynamic> PutStorie( DataContext context, Storie model) { try { context.Entry <Storie>(model).State = EntityState.Modified; await context.SaveChangesAsync(); return(model); } catch { return(null); } }
public async Task <dynamic> PostStorie( DataContext context, Storie model ) { try { context.Stories.Add(model); await context.SaveChangesAsync(); return(model); } catch { return("Não foi possível adicionar o storie"); } }
public JsonResult StorieFeature() { try { Storie s = sh.StorieFeature(); int showing = s.Showing; int count = s.Count; string header = s.Header; string headline = s.HeadLine; string content = s.Content; return(Json(new { success = true, header = header, headline = headline, content = content, showing = showing, count = count })); } catch (Exception e) { return(Json(new { success = false })); } }
//[Authorize(Roles = "usuario")] public async Task <ActionResult <Storie> > Put( int id, [FromServices] DataContext context, [FromBody] Storie model, [FromServices] IStorieService storieService) { var storie = await storieService.GetStorie(context, id); if (storie == null) { return(NotFound(new { message = "storie não encontrado!" })); } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var putStorie = await storieService.PutStorie(context, model); if (putStorie == null) { return(BadRequest(new { message = "Não foi possível alterar o storie." })); } return(Ok(model)); }
public override Instagram Procesar() { var insta = new Instagram(); insta.user = usuario; foreach (DataRow row in dataset.Tables["Seguidos"].Rows) { var sql = $"select * from {row["nombre_usuario"]}_POSTS;"; var adaptador = new SqlDataAdapter(sql, sqlconnection); adaptador.Fill(dataset, "Posts" + row["nombre_usuario"]); foreach (DataRow row2 in dataset.Tables["Posts" + row["nombre_usuario"]].Rows) { var post = new Post(); post.usuario = row["nombre_usuario"].ToString(); post.id = Convert.ToInt32(row2["id_foto"]); post.titulo = row2["titulo_foto"].ToString(); post.descripcion = row2["descripcion_foto"].ToString(); post.date = (DateTime)row2["fecha"]; post.url = row2["archivo"].ToString(); sql = $"select count(*) from {row["nombre_usuario"]}_{post.id}_LIKES"; // Likes SqlCommand cmd = new SqlCommand(sql, sqlconnection); cmd.ExecuteNonQuery(); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); post.likes = Convert.ToInt32(reader[0]); reader.Close(); sql = $"select * from {row["nombre_usuario"]}_{post.id}_COMENTARIOS;"; // Comentarios adaptador = new SqlDataAdapter(sql, sqlconnection); adaptador.Fill(dataset, row["nombre_usuario"] + "" + post.id + "comentarios"); foreach (DataRow row3 in dataset.Tables[row["nombre_usuario"] + "" + post.id + "comentarios"].Rows) { var comment = new Comment(); comment.id = Convert.ToInt32(row3["id_comentario"]); comment.name = row3["nombre_usuario"].ToString(); comment.data = row3["texto"].ToString(); post.comentarios.Add(comment); } sql = $"select * from {row["nombre_usuario"]}_PERFIL"; adaptador = new SqlDataAdapter(sql, sqlconnection); adaptador.Fill(dataset, "Perfil"); foreach (DataRow row4 in dataset.Tables["Perfil"].Rows) { post.foto = row4["foto"].ToString(); } insta.publico.Add(post); } sql = $"select * from {row["nombre_usuario"]}_STORIES;"; adaptador = new SqlDataAdapter(sql, sqlconnection); adaptador.Fill(dataset, "Stories"); var stories = new Stories(); foreach (DataRow row2 in dataset.Tables["Stories"].Rows) { var storie = new Storie(); storie.url = row2["archivo"].ToString(); storie.id = Convert.ToInt32(row2["id_foto"]); storie.date = (DateTime)row2["times"]; if ((DateTime.Now - storie.date).TotalDays >= 1) { sql = $"delete from {row["nombre_usuario"]}_STORIES where id_foto = {storie.id};"; var cmd = new SqlCommand(sql, sqlconnection); cmd.ExecuteNonQuery(); } else { stories.stories.Add(storie); } } if (stories.stories.Count > 0) { stories.nombre = row["nombre_usuario"].ToString(); insta.publicStories.Add(stories); } } var stories2 = new Stories(); foreach (DataRow row2 in dataset.Tables["MyStories"].Rows) { var storie = new Storie(); storie.url = row2["archivo"].ToString(); storie.id = Convert.ToInt32(row2["id_foto"]); storie.date = (DateTime)row2["times"]; if ((DateTime.Now - storie.date).TotalDays >= 1) { var sql = $"delete from {usuario}_STORIES where id_foto = {storie.id};"; var cmd = new SqlCommand(sql, sqlconnection); cmd.ExecuteNonQuery(); } else { stories2.stories.Add(storie); } } stories2.nombre = usuario; insta.stories = stories2; return(insta); }