protected void SaveVIPRows(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
string Honourific = ((TextBox)GuestListVIP.Rows[row.RowIndex].Cells[1].Controls[0]).Text;
string Fullname = ((TextBox)GuestListVIP.Rows[row.RowIndex].Cells[2].Controls[0]).Text;
string Email = ((TextBox)GuestListVIP.Rows[row.RowIndex].Cells[3].Controls[0]).Text;
DropDownList ddl = row.FindControl("DropDownList1") as DropDownList;
string role = ddl.SelectedItem.ToString();
TextBox date = row.FindControl("Invite_dt") as TextBox;
string invite = date.Text;
string charge = ((TextBox)GuestListVIP.Rows[row.RowIndex].Cells[6].Controls[0]).Text;
int check = dao.UpdateAllGuest(Honourific, Fullname, Email, role, invite, Convert.ToDouble(charge));
GuestListVIP.EditIndex = -1;
DataTable dt = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP");
GuestListVIP.DataSource = dt;
GuestListVIP.DataBind();
DataTable dt1 = dao.GetGuestPerson(int.Parse(Request.QueryString["ID"].ToString()));
GuestListTable.DataSource = dt1;
GuestListTable.DataBind();
}
protected void RoesDdl_SelectedIndexChanged(object sender, EventArgs e)
{
GuestListTable.PageSize = int.Parse(RowsDdl1.SelectedItem.ToString());
GuestListSpeaker.PageSize = int.Parse(RowsDdl1.SelectedItem.ToString());
GuestListGuest.PageSize = int.Parse(RowsDdl1.SelectedItem.ToString());
GuestListVIP.PageSize = int.Parse(RowsDdl1.SelectedItem.ToString());
DataTable dt = dao.GetGuestPerson(int.Parse(Request.QueryString["ID"].ToString()));
GuestListTable.DataSource = dt;
GuestListTable.DataBind();
DataTable dt1 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Speaker");
GuestListSpeaker.DataSource = dt1;
GuestListSpeaker.DataBind();
DataTable dt2 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Guest");
GuestListGuest.DataSource = dt2;
GuestListGuest.DataBind();
DataTable dt3 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP");
GuestListVIP.DataSource = dt3;
GuestListVIP.DataBind();
}
protected void DeleteALLRows(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
string Email = GuestListTable.Rows[row.RowIndex].Cells[3].Text;
int check = dao.DeleteGuest(int.Parse(Request.QueryString["ID"].ToString()), Email);
DataTable dt = dao.GetGuestPerson(int.Parse(Request.QueryString["ID"].ToString()));
GuestListTable.DataSource = dt;
GuestListTable.DataBind();
DataTable dt1 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Speaker");
GuestListSpeaker.DataSource = dt1;
GuestListSpeaker.DataBind();
DataTable dt2 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Guest");
GuestListGuest.DataSource = dt2;
GuestListGuest.DataBind();
DataTable dt3 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP");
GuestListVIP.DataSource = dt3;
GuestListVIP.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = dao.GetGuestPerson(int.Parse(Request.QueryString["ID"].ToString()));
GuestListTable.DataSource = dt;
GuestListTable.DataBind();
GuestListTable.HeaderRow.TableSection = TableRowSection.TableHeader;
DataTable speaker = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Speaker");
GuestListSpeaker.DataSource = speaker;
GuestListSpeaker.DataBind();
GuestListSpeaker.HeaderRow.TableSection = TableRowSection.TableHeader;
DataTable guest = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Guest");
GuestListGuest.DataSource = guest;
GuestListGuest.DataBind();
GuestListGuest.HeaderRow.TableSection = TableRowSection.TableHeader;
DataTable vip = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP");
GuestListVIP.DataSource = vip;
GuestListVIP.DataBind();
GuestListVIP.HeaderRow.TableSection = TableRowSection.TableHeader;
}
Name.InnerText = Request.QueryString["Name"].ToString();
Datetime.InnerText = Request.QueryString["Date"].ToString();
}
protected void EditAllRows(object sender, EventArgs e)
{
LinkButton btn = (LinkButton)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
GuestListTable.EditIndex = row.RowIndex;
DataTable dt = dao.GetGuestPerson(int.Parse(Request.QueryString["ID"].ToString()));
GuestListTable.DataSource = dt;
GuestListTable.DataBind();
DataTable dt1 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Speaker");
GuestListSpeaker.DataSource = dt1;
GuestListSpeaker.DataBind();
DataTable dt2 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "Guest");
GuestListGuest.DataSource = dt2;
GuestListGuest.DataBind();
DataTable dt3 = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP");
GuestListVIP.DataSource = dt3;
GuestListVIP.DataBind();
}
protected void VIP_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GuestListVIP.PageIndex = e.NewPageIndex;
//rebind your gridview - GetSource(),Datasource of your GirdView
DataTable dt = dao.GetGuestSpecific(int.Parse(Request.QueryString["ID"].ToString()), "VIP");
GuestListVIP.DataSource = dt;
GuestListVIP.DataBind();
}
