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