protected void Page_Load(object sender, EventArgs e)
{
dtNewsCategory = taNewsCategory.SelectNewsCategoryNameByNewsCategoryId(5);
if (dtNewsCategory.Rows.Count > 0)
{
int page = 10;
dtNews = taNews.SelectNewsbyNewsCategoryId(5);
if (dtNews.Rows.Count > 0)
{
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = dtNews.DefaultView;
objPds.AllowPaging = true;
objPds.PageSize = page;
objPds.CurrentPageIndex = CurrentPage;
Repeater1.DataSource = objPds;
Repeater1.DataBind();
}
else
{
Repeater1.Visible = false;
}
}
else
{
Repeater1.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
return;
if (Request.QueryString["NewsId"] != null)
{
int NewsId = Convert.ToInt32(Request.QueryString["NewsId"]);
dtNews = taNews.SelectNewsbyNewsId(NewsId);
if (dtNews.Rows.Count > 0)
{
lblNewsTitle.Text = dtNews[0].Title.ToString();
imgNews.ImageUrl = "thumbnail.aspx?Image=Images/NewsImages/" + dtNews[0].MainImage.ToString() + "&size=500";
lblNewsDescription.Text = dtNews[0].LongDescription.ToString();
}
else
{
imgNews.Visible = false;
lblNewsDescription.Visible = false;
}
}
else
{
imgNews.Visible = false;
lblNewsDescription.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
return;
SelectCategories();
if (Request.QueryString["ID"] != null)
{
if (Request.QueryString["ID"] == "True")
{
lblMsg.Text = "Successfully Edited";
}
}
if (Request.QueryString["NewsId"] != null)
{
int newsId = Convert.ToInt32(Request.QueryString["NewsId"].ToString());
dtNews = taNews.SelectNewsbyNewsId(newsId);
if (dtNews.Rows.Count > 0)
{
ddlType.Items.FindByValue(dtNews[0].NewsCategoryId.ToString()).Selected = true;
txtTitle.Text = dtNews[0].Title.ToString();
txtStartDate.Text = dtNews[0].StartDate.ToString();
txtShortDescription.Text = dtNews[0].ShortDescription.ToString();
txtLongDescription.Text = dtNews[0].LongDescription.ToString();
lblImage.Text = dtNews[0].MainImage.ToString();
Image1.ImageUrl = "~/thumbnail.aspx?Image=Images/NewsImages/" + dtNews[0].MainImage.ToString() +"&size=100";
}
}
else
{
btnEdit.Visible = false;
lblMsg.Text = "No Record Found";
}
}
private void BindData()
{
dtNews = taNews.SelectAllNews();
if (dtNews.Rows.Count > 0)
{
GridView1.DataSource = dtNews;
GridView1.DataBind();
}
else
{
GridView1.Visible = false;
lblMsg.Text = "No record found";
}
}
private void ItemsGet()
{
if (Request.QueryString["NewsCategoryId"] != null)
{
int NewsCategoryId = Convert.ToInt32(Request.QueryString["NewsCategoryId"]);
dtNewsCategory = taNewsCategory.SelectNewsCategoryNameByNewsCategoryId(NewsCategoryId);
if (dtNewsCategory.Rows.Count > 0)
{
int page = 10;
lblCategoryName.Text = dtNewsCategory[0].NewsCategoryTitle.ToString();
dtNews = taNews.SelectNewsbyNewsCategoryId(NewsCategoryId);
if (dtNews.Rows.Count > 0)
{
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = dtNews.DefaultView;
objPds.AllowPaging = true;
objPds.PageSize = page;
objPds.CurrentPageIndex = CurrentPage;
//objPds.CurrentPageIndex = CurrentPage - 1;
int count = objPds.PageCount;
lblCurrentPage.Text = "Page " + (CurrentPage + 1).ToString() + " of "
+ objPds.PageCount.ToString();
//Disable Prev or Next buttons if necessary
//Button1.Visible = !objPds.IsFirstPage;
//Button2.Visible = !objPds.IsLastPage;
if (objPds.IsFirstPage)
Button1.Visible = false;
else
Button1.Visible = true;
if (objPds.IsLastPage)
Button2.Visible = false;
else
Button2.Visible = true;
Repeater1.DataSource = objPds;
Repeater1.DataBind();
}
else
{
Repeater1.Visible = false;
Button1.Visible = false;
Button2.Visible = false;
}
}
else
{
Repeater1.Visible = false;
Button1.Visible = false;
Button2.Visible = false;
}
}
else
{
Repeater1.Visible = false;
Button1.Visible = false;
Button2.Visible = false;
}
}
