protected void SelectSections()
{
dtSections = taSections.SelectSectionCategoryAndSectionName();
ddlSection.DataSourceID = null;
ddlSection.DataSource = dtSections;
ddlSection.DataTextField = dtSections.Columns["SectionName"].ToString();
ddlSection.DataValueField = dtSections.Columns["SectionId"].ToString();
ddlSection.DataBind();
ddlSection.Items.Insert(0, new ListItem("Please Select", ""));
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
return;
SelectCategories();
if (Request.QueryString["ID"] != null)
{
if (Request.QueryString["ID"] == "True")
{
lblMsg.Visible = true;
lblMsg.Text = "Successfully Edited";
}
}
if (Request.QueryString["SectionId"] != null)
{
int SectionId = Convert.ToInt32(Request.QueryString["SectionId"]);
dtSections = taSections.SelectSectionsbySectionId(SectionId);
if (dtSections.Rows.Count > 0)
{
ddlCategory.Items.FindByValue(dtSections[0].CategoryId.ToString()).Selected = true;
txtSectionName.Text = dtSections[0].SectionName.ToString();
}
else
{
lblMsg.Text = "No record found";
btnEdit.Visible = false;
return;
}
}
else
{
lblMsg.Text = "No record found";
btnEdit.Visible = false;
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
return;
if (Request.QueryString["SectionId"] != null)
{
int SectionId = Convert.ToInt32(Request.QueryString["SectionId"]);
dtSections = taSections.SelectSectionsbySectionId(SectionId);
if (dtSections.Rows.Count > 0)
{
dtFAQ = taFAQ.SelectQuestionsbySectionId(SectionId);
if (dtFAQ.Rows.Count > 0)
{
Repeater2.DataSource = dtFAQ;
Repeater2.DataBind();
}
else
{
Repeater2.Visible = false;
}
}
else
{
Repeater2.Visible = false;
}
}
else
{
Repeater2.Visible = false;
}
}
private void BindData()
{
if (Request.QueryString["CategoryId"] != null)
{
int CategoryId = Convert.ToInt32(Request.QueryString["CategoryId"]);
dtSections = taSections.SelectSectionsbyCategoryId(CategoryId);
ddlCategory.Items.FindByValue(CategoryId.ToString()).Selected = true;
}
else
dtSections = taSections.SelectAllSections();
if (dtSections.Rows.Count > 0)
{
GridView1.DataSourceID = null;
GridView1.DataSource = dtSections;
GridView1.DataBind();
}
else
{
lblMsg.Text = "No record found";
return;
}
}
