protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
return;
if (Request.QueryString["ID"] != null)
{
if (Request.QueryString["ID"] == "True")
{
lblMsg.Text = "Successfully Edited";
}
}
if (Request.QueryString["GroupId"] != null)
{
int GroupId = Convert.ToInt32(Request.QueryString["GroupId"]);
dtGroups = taGroups.SelectGroupbyGroupId(GroupId);
if (dtGroups.Rows.Count > 0)
{
txtTitle.Text = dtGroups[0].GroupName.ToString();
}
else
{
lblMsg.Text = "No record found";
return;
}
}
else
{
lblMsg.Text = "No record found";
return;
}
}
protected void LoadGroups()
{
dtGroups = taGroups.SelectAllGroups();
ddlGroup.DataSource = dtGroups;
ddlGroup.DataTextField = dtGroups.Columns[1].ToString();
ddlGroup.DataValueField = dtGroups.Columns[0].ToString();
ddlGroup.DataBind();
}
protected void LoadGroups()
{
dtGroups = taGroups.SelectAllGroups();
ddlGroup.DataSource = dtGroups;
ddlGroup.DataTextField = dtGroups.Columns[1].ToString();
ddlGroup.DataValueField = dtGroups.Columns[0].ToString();
ddlGroup.DataBind();
ddlGroup.Items.Insert(0, new ListItem("Please select one",""));
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Label lblGroupId = (Label)e.Row.FindControl("lblGroupId");
dtGroups = taGroups.SelectGroupNamebyGroupId(Convert.ToInt32(lblGroupId.Text));
if (dtGroups.Rows.Count > 0)
lblGroupId.Text = dtGroups[0].GroupName.ToString();
else
lblGroupId.Visible = false;
LinkButton btnDel = (LinkButton)e.Row.FindControl("lbtnDelete");
btnDel.Attributes.Add("OnClick", "return confirm('Are you sure to delete this record?');");
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
dtNewsLetterGroup = taNewsLetterGroup.SelectFromGroupWhereTitleIsNone();
if (dtNewsLetterGroup.Rows.Count > 0)
{
taSubscriber.AddSubscriber(Convert.ToInt32(dtNewsLetterGroup[0].GroupId.ToString()),
txtEmail.Text.Trim(),
txtName.Text.Trim(),
txtAddress.Text.Trim(),
ddlCity.SelectedItem.Text.Trim(),
DateTime.Now);
}
Response.Redirect("Thankyou.aspx?ID=Subscribed");
}
private void BindData()
{
dtGroups = taGroups.SelectAllGroups();
if (dtGroups.Rows.Count > 0)
{
GridView1.DataSourceID = null;
GridView1.DataSource = dtGroups;
GridView1.DataBind();
}
else
{
lblMsg.Text = "No record found";
return;
}
}
