protected void Page_Load(object sender, EventArgs e) { var blogPostId = Request.GetFriendlyUrlSegments()[0]; Session["BlogPostID"] = blogPostId; if (!string.IsNullOrEmpty(blogPostId)) { ltrSocial.Text = Utility.ReadTemplateFromFile("pathSocial"); var taArticoli = new DataSetMateraArredamentiTableAdapters.NewsTableAdapter(); DataTable dtArticolo = taArticoli.GetDataByID(int.Parse(blogPostId)); var blogPostHtmlDocument = Server.MapPath(string.Format("~/public/HTML_Articoli/MateraArredamentiBlogPost_{0}.html", dtArticolo.Rows[0]["News_ID"])); try { CreatePrintableHtml(blogPostHtmlDocument, dtArticolo.Rows[0]); var fbMetaTagsTemplate = ReadTemplateFromFile("template_tagFb.htm"); if (string.IsNullOrEmpty(fbMetaTagsTemplate)) { return; } var randomVignette = Utility.GetRandomImages(Server.MapPath("~/img/outlet/")); var imagePath = string.Format("{0}img/outlet/{1}", Url, Path.GetFileName(randomVignette.FirstOrDefault())); CreateFacebookMetaTags(fbMetaTagsTemplate, imagePath, String.Format("{0}BlogPost/{1}/{2}", Url, dtArticolo.Rows[0]["News_ID"], dtArticolo.Rows[0]["Titolo"])); } catch (Exception ex) { throw ex; } } Session["AlbumID"] = 0; try { var taAlbums = new DataSetMateraArredamentiTableAdapters.AlbumsTableAdapter(); DataTable dtAlbumID = taAlbums.GetIdAlbum(int.Parse(blogPostId)); if (dtAlbumID.Rows.Count > 0) { Session["AlbumID"] = int.Parse(dtAlbumID.Rows[0][0].ToString()); } } catch (Exception) { } }
protected void _OnItemCommand(object sender, ListViewCommandEventArgs e) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; string newsID = ListViewNews.DataKeys[dataItem.DisplayIndex].Value.ToString(); if (e.CommandName == "cancella") { DataSetMateraArredamentiTableAdapters.NewsTableAdapter taNews = new DataSetMateraArredamentiTableAdapters.NewsTableAdapter(); taNews.DeleteNewsEventi(int.Parse(newsID)); } else if (e.CommandName == "modifica") { Response.Redirect("AddModNews.aspx?tipo=" + ddlTipo.SelectedValue + "&NewsID=" + newsID); } else if (e.CommandName == "fotoGallery") { DataSetVepAdminTableAdapters.NewsTableAdapter taNews = new DataSetVepAdminTableAdapters.NewsTableAdapter(); int idNews = int.Parse(newsID); DataSetVepAdminTableAdapters.AlbumsTableAdapter taAlbums = new DataSetVepAdminTableAdapters.AlbumsTableAdapter(); int albumID = 0; DataTable dtAlbum = taAlbums.GetIdAlbum(idNews); DataTable dtNews = taNews.GetDataByID(idNews); string idScuola = (string)Session["ddlScuola"]; if (dtAlbum.Rows.Count == 0) { albumID = Convert.ToInt32(taAlbums.InsertAlbumRetID(dtNews.Rows[0]["Descrizione"].ToString(), true, idNews)); //nuova news inserita faccio una redirect e nella sessione ho già l'id_news! Response.Redirect("~/Admin/Photos.aspx?AlbumID=" + albumID.ToString()); } else { Response.Redirect("~/Admin/Photos.aspx?AlbumID=" + dtAlbum.Rows[0]["AlbumID"].ToString()); } } ListViewNews.DataBind(); }