private void GetPosts(int state)
{
UserServices userServices = new UserServices();
string query = "SELECT P.ID_POST, U.NAME, U.LASTNAME, U.PROFILE_PICTURE, P.TITLE, P.CAPTION, P.TIMEDATE FROM POST P" +
" INNER JOIN USERS U ON P.ID_USER = U.ID_USER" +
" WHERE P.ID_USER = "******" AND P.VISIBLE = " + state;
PostServices postServices = new PostServices();
dt = postServices.Get(query);
}
//
// GET: Posts/Details/id
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(HttpNotFound());
}
ViewBag.ForumCategories = await _forumCategriesManager.ListCategoriesForLinks();
ViewBag.Themes = await _themesManager.ListThemesForLinks();
ViewBag.PopularPosts = await _postsManager.ListMostPopular();
ViewBag.LatestComments = await _commentsManager.ListLatest();
ViewBag.FlickrPhotos = new ImageCollectionViewModel
{
CollectionName = "Flickr снимки",
ImageUrls = new List <string>
{
"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQcu__MdyeKEmtW-Ki5Bg12YYPJXN5rxQjYewBsc46LYhR3K-Xj",
"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQcu__MdyeKEmtW-Ki5Bg12YYPJXN5rxQjYewBsc46LYhR3K-Xj",
"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQcu__MdyeKEmtW-Ki5Bg12YYPJXN5rxQjYewBsc46LYhR3K-Xj",
"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQcu__MdyeKEmtW-Ki5Bg12YYPJXN5rxQjYewBsc46LYhR3K-Xj",
"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQcu__MdyeKEmtW-Ki5Bg12YYPJXN5rxQjYewBsc46LYhR3K-Xj",
"https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQcu__MdyeKEmtW-Ki5Bg12YYPJXN5rxQjYewBsc46LYhR3K-Xj"
}
};
ViewBag.Tags = await _tagsManager.ListPopularTagNames();
ViewBag.RelatedPosts = await _postsManager.GetRelatedPosts((int)id, 2);
ViewBag.HeighestScoredPosts = (await _postsManager.GetHeighestScored()).Take(3).ToList();
await _postsManager.IncreaseViews((int)id);
var post = await _postsManager.Get((int)id);
return(View(post));
}
private void pictureBox1_Click(object sender, EventArgs e)
{
Options options = new Options();
options.ID_Post = ID_Post;
options.visible = Visible;
DialogResult dr = options.ShowDialog();
if (dr == DialogResult.Yes)
{
Post post = new Post();
post.Editar = true;
post.PostEdit = postServices.Get("SELECT * FROM POST WHERE ID_POST = " + ID_Post);
post.ShowDialog();
}
else if (dr == DialogResult.No)
{
if (postServices.EditVisiblity(ID_Post, 0))
{
MessageBox.Show("El post fue ocultado");
}
else
{
MessageBox.Show("La accion no pudo realizarse correctamente");
}
}
else if (dr == DialogResult.OK)
{
if (postServices.Delete(ID_Post))
{
MessageBox.Show("Publicacion eliminada correctamente");
}
else
{
MessageBox.Show("La accion no pudo realizarse correctamente");
}
}
else if (dr == DialogResult.Retry)
{
if (postServices.EditVisiblity(ID_Post, 1))
{
MessageBox.Show("El post ya puede ser visualizado");
}
else
{
MessageBox.Show("La accion no pudo realizarse correctamente");
}
}
options.Close();
options.Dispose();
OnRefresh(e);
}
public ActionResult <List <Post> > Get()
{
return(_postService.Get());
}