protected void SetLatestNews()
{
DataTable newlist = FrontNews.GetFrontNewsList(5);
LiteralControl literalControl;
foreach (DataRow child in newlist.Rows)
{
DateTime modified = DateTime.Parse(child["Modified"].ToString());
string newsid = child["NewsID"].ToString();
string newstitle = child["NewsTitle"].ToString();
//<li><span>2009.09.18</span><a href="#">Lorem Ipsum Dolor sit amet sjtpua cons...</a></li>
literalControl = new LiteralControl(String.Format("<li><span>{0}</span><a href='{1}'>{2}</a></li>\n",
modified.ToString("yyyy'.'MM'.'dd"),
"/News/NewsList.aspx?NewsID=" + newsid,
newstitle));
ContentsPlaceHolder.Controls.Add(literalControl);
}
}
protected void BindData()
{
int howManyPages = 1;
DataTable news = SiteFrontend.FrontNews.GetNewsIDs(int.Parse(_page), _newsPerPage, out howManyPages);
NewsRepeater.DataSource = news;
NewsRepeater.DataBind();
if (_newsID == 0)
{
if (news.Rows.Count > 0)
{
DataRow row = news.Rows[0];
_newsID = int.Parse(row["NewsID"].ToString());
}
}
if (_newsID > 0)
{
DataTable n = FrontNews.GetNews(_newsID);
if (n.Rows.Count > 0)
{
DataRow r = n.Rows[0];
lblNewsTitle.Text = r["NewsTitle"].ToString();
lblNewsDate.Text = String.Format("{0:M/d/yyyy}", DateTime.Parse(r["Modified"].ToString()));
NewsContentDiv.InnerHtml = r["NewsDesc"].ToString();
}
}
if (howManyPages > 1)
{
int currentPage = Int32.Parse(_page);
pagingLabel.Visible = true;
previousLink.Visible = true;
nextLink.Visible = true;
firstLink.Visible = true;
lastLink.Visible = true;
pagingLabel.Text = _page + " / " + howManyPages.ToString();
// create previous link
if (currentPage == 1)
{
previousLink.Enabled = false;
firstLink.Enabled = false;
}
else
{
NameValueCollection query = Request.QueryString;
string paramName, newQueryString = "?";
for (int i = 0; i < query.Count; i++)
{
if (query.AllKeys[i] != null)
{
if ((paramName = query.AllKeys[i].ToString()).ToUpper() != "PAGE")
{
newQueryString += paramName + "=" + query[i] + "&";
}
}
}
previousLink.NavigateUrl = Request.Url.AbsolutePath + newQueryString + "Page=" + (currentPage - 1).ToString();
firstLink.NavigateUrl = Request.Url.AbsolutePath + newQueryString + "Page=1";
}
//create next link
if (currentPage == howManyPages)
{
nextLink.Enabled = false;
lastLink.Enabled = false;
}
else
{
NameValueCollection query = Request.QueryString;
string paramName, newQueryString = "?";
for (int i = 0; i < query.Count; i++)
{
if (query.AllKeys[i] != null)
{
if ((paramName = query.AllKeys[i].ToString()).ToUpper() != "PAGE")
{
newQueryString += paramName + "=" + query[i] + "&";
}
}
}
nextLink.NavigateUrl = Request.Url.AbsolutePath + newQueryString + "Page=" + (currentPage + 1).ToString();
lastLink.NavigateUrl = Request.Url.AbsolutePath + newQueryString + "Page=" + howManyPages.ToString();
}
}
}
