protected void Page_Load(object sender, EventArgs e) { int itemGet = 0; if (Request.QueryString["newsId"] != null) { itemGet = int.Parse(Request.QueryString["newsId"]); } else { Response.Redirect("default.aspx"); } string newsDetailString = "", picThumbString = ""; tblNewsDetailsCollection newsDetailsTbl = new tblNewsDetailsCollection(); newsDetailsTbl.ReadList(Criteria.NewCriteria(tblNewsDetails.Columns.id, CriteriaOperators.Equal, itemGet)); int idCounter = 0; //news image string imagesString = "<div class=\"ws_images\"><ul>"; if (newsDetailsTbl[0].topPageFileType == 0) { imagesString += "<li><img src='images/news/top/" + newsDetailsTbl[0].topPageFileAddr + "' alt='اخبار دنیای ورزشی " + newsDetailsTbl[0].id + "' title='دنیای ورزشی' id='wows1_" + idCounter + "'/></li>"; picThumbString += "<a href='#wows1_" + idCounter + "' title='اخبار دنیای ورزشی'><img src='images/news/top/" + newsDetailsTbl[0].topPageFileAddr + "' alt='اخبار دنیای ورزشی " + newsDetailsTbl[0].id + "' title='دنیای ورزشی' /></a>"; } else if (newsDetailsTbl[0].topPageFileType == 1) { imagesString += "<li><video id='wows1_" + idCounter + "'><source src='../movie/news/top/" + newsDetailsTbl[0].topPageFileAddr + "' type='video/mp4'>Your browser does not support HTML5 video.</video></li>"; picThumbString += "<a href='#wows1_" + idCounter + "'' title='اخبار دنیای ورزشی'><video id='video" + idCounter + "'><source src='../movie/news/top/" + newsDetailsTbl[0].topPageFileAddr + "' type='video/mp4'>Your browser does not support HTML5 video.</video></a>"; } else { imagesString += "<li id='wows1_" + idCounter + "'>" + newsDetailsTbl[0].topPageFileAddr + "</li>"; picThumbString += "<a href='#wows1_" + idCounter + "'' title='اخبار دنیای ورزشی'>" + newsDetailsTbl[0].topPageFileAddr + "</a>"; } idCounter++; tblNewsPicCollection newsPicTbl = new tblNewsPicCollection(); newsPicTbl.ReadList(Criteria.NewCriteria(tblNewsPic.Columns.newsId, CriteriaOperators.Equal, itemGet)); for (int i = 0; i < newsPicTbl.Count; i++) { imagesString += "<li><img src='images/news/sport/" + newsPicTbl[i].picName + "' alt='اخبار دنیای ورزشی " + newsPicTbl[i].id + "' title='دنیای ورزشی' id='wows1_" + idCounter + "'/></li>"; picThumbString += "<a href='#wows1_" + idCounter + "' title='اخبار دنیای ورزشی'><img src='images/news/sport/" + newsPicTbl[i].picName + "' alt='اخبار دنیای ورزشی " + newsPicTbl[i].id + "' title='دنیای ورزشی' /></a>"; idCounter++; } tblNewsMovieCollection newsMovieTbl = new tblNewsMovieCollection(); newsMovieTbl.ReadList(Criteria.NewCriteria(tblNewsMovie.Columns.newsId, CriteriaOperators.Equal, itemGet)); for (int i = 0; i < newsMovieTbl.Count; i++) { imagesString += "<li><video id='video" + idCounter + "'><source src='../movie/news/sport/" + newsMovieTbl[i].movieName + "' type='video/mp4' id='wows1_" + newsPicTbl[i].id + "'>Your browser does not support HTML5 video.</video></li>"; picThumbString += "<a href='#wows1_" + idCounter + "' title='اخبار دنیای ورزشی'><video id='video" + newsMovieTbl[i].id + "'><source src='../movie/news/sport/" + newsMovieTbl[i].movieName + "' type='video/mp4'>Your browser does not support HTML5 video.</video></a>"; idCounter++; } tblNewsHyperlinkCollection newsLinksTbl = new tblNewsHyperlinkCollection(); newsLinksTbl.ReadList(Criteria.NewCriteria(tblNewsHyperlink.Columns.newsId, CriteriaOperators.Equal, itemGet)); for (int i = 0; i < newsLinksTbl.Count; i++) { imagesString += "<li id='wows1_" + idCounter + "'>" + newsLinksTbl[i].HyperlinkAddr + "</li>"; picThumbString += "<a href='#wows1_" + idCounter + "' title='اخبار دنیای ورزشی'>" + newsLinksTbl[i].HyperlinkAddr + "</a>"; idCounter++; } imagesString += "</ul></div><div class=\"ws_thumbs\"><div>"; imagesString += picThumbString; imagesString += "</div></div>" + "<div class=\"ws_script\" style=\"position:absolute;left:-99%\"></div>" + "<div class=\"ws_shadow\"></div>"; imgNewsHtml.InnerHtml = imagesString; //news details newsDetailString += "<ul class='article-info'><li class='article-category'><a href='#'>ورزشی</a></li><li class='article-type'><i class='fa fa-file-text'></i></li></ul>" + "<h1 class='farsi-font-title farsi-align farsi-direction article-title'>" + newsDetailsTbl[0].newsDetTitle + "</h1>" + "<ul class='article-meta'><li><i class='fa fa-clock-o'></i> " + newsDetailsTbl[0].newsDetInsertDate + " </li></ul>" + "<p class='farsi-font-text farsi-align farsi-direction'>" + newsDetailsTbl[0].newsDetDetails + "</p>"; newsDetailHtml.InnerHtml = newsDetailString; }
protected void Page_Load(object sender, EventArgs e) { int itemGet = 0; if (Request.QueryString["item"] != null) { itemGet = int.Parse(Request.QueryString["item"]); } else { Response.Redirect("news-add.aspx"); } //fill data tblNewsDetailsCollection newsDetailsTbl = new tblNewsDetailsCollection(); newsDetailsTbl.ReadList(Criteria.NewCriteria(tblNewsDetails.Columns.id, CriteriaOperators.Equal, itemGet)); tblNewsPicCollection newsPicTbl = new tblNewsPicCollection(); newsPicTbl.ReadList(Criteria.NewCriteria(tblNewsPic.Columns.newsId, CriteriaOperators.Equal, itemGet)); tblNewsHyperlinkCollection newsHypTbl = new tblNewsHyperlinkCollection(); newsHypTbl.ReadList(Criteria.NewCriteria(tblNewsHyperlink.Columns.newsId, CriteriaOperators.Equal, itemGet)); if (newsDetailsTbl.Count > 0) { if (newsDetailsTbl[0].topPageFileAddr.Length > 3) { if (newsDetailsTbl[0].topPageFileType == 0) { setPicHtml.InnerHtml = "<img src='../images/news/" + newsDetailsTbl[0].topPageFileAddr + "' class='img-responsive' draggable='false'>"; } else if (newsDetailsTbl[0].topPageFileType == 1) { setPicHtml.InnerHtml = "<video id='video1'><source src='../movie/news/" + newsDetailsTbl[0].topPageFileAddr + "' type='video/mp4'>Your browser does not support HTML5 video.</video>"; } else { setPicHtml.InnerHtml = newsDetailsTbl[0].topPageFileAddr; } } } string writerStr = string.Empty; tblStaffCollection NewsCreatorTbl = new tblStaffCollection(); NewsCreatorTbl.ReadList(Criteria.NewCriteria(tblStaff.Columns.id, CriteriaOperators.Equal, newsDetailsTbl[0].idStaffCreator)); if (NewsCreatorTbl.Count > 0) { writerStr = NewsCreatorTbl[0].StaffName + " " + NewsCreatorTbl[0].StaffFamily; } string addDataString = string.Empty; addDataString += "<h3>" + newsDetailsTbl[0].newsDetTitle + "</h3><br>" + "<h5 class='farsi-direction farsi-font-text subtitle-text'>" + newsDetailsTbl[0].newsDetSubtitle + "</h5>" + "<span class='code'>Writer: <a>" + writerStr + "</a></span>" + "<p>News Details: " + newsDetailsTbl[0].newsDetDetails + "</p>" + "<div class='price'>" + "<span class='text'></span>"; addDataString += "<span class='price-new'></span>"; addDataString += "<span class='price-tax'><label class='checkbox'></label></span><br>"; addDataString += "<span class='points'><small>Insert Date: " + newsDetailsTbl[0].newsDetInsertDate + "</small></span><br>"; addDataString += "</div>"; addDetailHtml.InnerHtml = addDataString; //fill data in change part //Groups tblNewsGroupCollection newsGroupTbl = new tblNewsGroupCollection(); newsGroupTbl.ReadList(); //Select old items if (!IsPostBack) { if (newsDetailsTbl[0].newsDetTitle.Length > 0) { txtTitle.Text = newsDetailsTbl[0].newsDetTitle; } if (newsDetailsTbl[0].newsDetDetails.Length > 0) { ckNews.Text = newsDetailsTbl[0].newsDetDetails; } for (int i = 0; i < newsGroupTbl.Count; i++) { ddlNewsGroup.Items.Add(new ListItem(newsGroupTbl[i].newsGroupTitle, newsGroupTbl[i].id.ToString())); } ddlNewsGroup.SelectedValue = newsDetailsTbl[0].idGroup.ToString(); } #region extera items(Pics/Movies/Links) //extra pictures and movies tblNewsMovieCollection newsMovieTbl = new tblNewsMovieCollection(); newsMovieTbl.ReadList(Criteria.NewCriteria(tblNewsMovie.Columns.newsId, CriteriaOperators.Equal, itemGet)); tblNewsPicCollection newsPictureTbl = new tblNewsPicCollection(); newsPictureTbl.ReadList(Criteria.NewCriteria(tblNewsPic.Columns.newsId, CriteriaOperators.Equal, itemGet)); string extraMovieString = "", extraPicturesString = "", extraHypString = ""; extraMovieString += "<h3>Movies: </h3><ul>"; extraPicturesString += "<h3>Pictures: </h3><ul>"; extraHypString += "<h3>External links: </h3><ul>"; for (int i = 0; i < newsMovieTbl.Count; i++) { extraMovieString += "<li class='tumb-ul'> <video id='image-extra video1' ><source src='../movie/news/sport/" + newsMovieTbl[i].movieName + "' type='video/mp4'>Your browser does not support HTML5 video.</video></li>"; } if (newsMovieTbl.Count == 0) { extraMovieString += "<li class='tumb-ul'>There is no video to show</li>"; } for (int i = 0; i < newsPictureTbl.Count; i++) { extraPicturesString += "<li class='tumb-ul'><img src='../images/news/sport/" + newsPictureTbl[i].picName + "' class='image-extra thumbnail-pictures' alt='" + newsPictureTbl[i].picName + "' /></li>"; } if (newsPictureTbl.Count == 0) { extraPicturesString += "<li class='tumb-ul'>There is no picture to show</li>"; } for (int i = 0; i < newsHypTbl.Count; i++) { extraHypString += "<li class='tumb-ul'>" + newsHypTbl[i].HyperlinkAddr + "</li>"; } if (newsHypTbl.Count == 0) { extraHypString += "<li class='tumb-ul'>There is no external link to show</li>"; } extraMovieString += "</ul>"; extraPicturesString += "</ul>"; extraHypString += "</ul>"; extraMovieHtml.InnerHtml = extraMovieString; extraPictureHtml.InnerHtml = extraPicturesString; extraHypHtml.InnerHtml = extraHypString; #endregion }