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
}
