protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //DDLClubName.Visible = false; //txtName.Visible = true; //btnSearch.Visible = true; DDLClubName.Visible = true; //txtName.Visible = false; //btnSearch.Visible = false; rbtnSearch.SelectedIndex = 2; DDLClubName.DataSourceID = "DSDistClubNo"; DDLClubName.DataBind(); bool b; if (b = true) { Session["searchField"] = null; Session["name"] = null; Session["value"] = null; b = false; } ManageGrid(); } }
private void GetPositionHeld(int id) { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_GetPositionHeld"; obj.AddParam("@id", id); DataTable dt = new DataTable(); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { DDLClubName.DataSourceID = "DSDistClubName"; DDLClubName.DataBind(); int clubId = int.Parse(dt.Rows[0]["club_id"].ToString()); BindMembers(clubId); DDLClubName.SelectedValue = dt.Rows[0]["club_id"].ToString(); DDLMember.SelectedValue = dt.Rows[0]["member_id"].ToString(); DDLPHYear.SelectedItem.Text = dt.Rows[0]["years"].ToString(); DDLPHeld.SelectedValue = dt.Rows[0]["position_held_on"].ToString(); GetDistAvenue(DDLPHYear.SelectedItem.Text.Trim()); DDLAvenue.SelectedItem.Text = dt.Rows[0]["avenue"].ToString(); // GetDistDesignation(int.Parse(DDLAvenue.SelectedValue.ToString())); DDLPosition.SelectedItem.Text = dt.Rows[0]["position"].ToString(); } }
private void GetInstalation(int id) { DDLClubName.DataSourceID = "DSDistClubNo"; DDLClubName.DataBind(); DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_GetInstalationCal"; obj.AddParam("@id", id); DataTable dt = new DataTable(); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { DDLClubName.SelectedItem.Text = dt.Rows[0]["club_name"].ToString(); DDLClubName.SelectedValue = dt.Rows[0]["club_id"].ToString(); RadDatePicker1.DbSelectedDate = DateTime.Parse(dt.Rows[0]["date"].ToString()); string[] time = dt.Rows[0]["time"].ToString().Split(':'); DDLTimeH.SelectedValue = time[0].ToString(); DDLTimeM.SelectedValue = time[1].ToString(); DDLTimeAMPM.SelectedValue = time[2].ToString(); DDLcg.SelectedItem.Text = dt.Rows[0]["cheif_guest"].ToString(); DDLcg.SelectedValue = dt.Rows[0]["cheif_guest"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] != null) { DDLClubName.DataSourceID = "DSDistClubNo"; DDLClubName.DataBind(); if (!IsPostBack) { txtCheifGuest.Visible = false; DDLcg.SelectedIndex = 0; DDLClubName.SelectedIndex = 0; BindTime(); if (Request.QueryString["id"] != null) { int id = int.Parse(Request.QueryString["id"].ToString()); GetInstalation(id); } } } else { Session.Abandon(); Server.Transfer("Default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] != null) { if (!IsPostBack) { DDLClubName.DataSourceID = "DSDistClubNo"; DDLClubName.DataBind(); TRTopics.Visible = false; TRClubname.Visible = true; if (Request.QueryString["id"] != null) { int id = int.Parse(Request.QueryString["id"].ToString()); GetSpeaker(id); } } } else { Session.Abandon(); Response.Redirect("Default.aspx"); } }
private void GetBOD(int id) { DBconnection obj = new DBconnection(); obj.SetCommandQry = "select * from View_BodMembers where id='" + id + "'"; DataTable dt = new DataTable(); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { int clubid = int.Parse(dt.Rows[0]["DistrictClubID"].ToString()); DDLClubName.DataSourceID = "DSDistClubNo"; DDLClubName.DataBind(); BindMembers(clubid); BindDesignations(clubid); DDLClubName.SelectedItem.Text = dt.Rows[0]["club_name"].ToString(); DDLClubName.SelectedValue = dt.Rows[0]["DistrictClubID"].ToString(); try { //int desi_id = int.Parse(dt.Rows[0]["designation_id"].ToString()); //DDLDesignation.SelectedValue = desi_id.ToString(); DDLDesignation.SelectedItem.Text = dt.Rows[0]["designation"].ToString(); DDLDesignation.SelectedValue = dt.Rows[0]["designation_id"].ToString(); } catch { } try { //int mem_id = int.Parse(dt.Rows[0]["MemberId"].ToString()); //DDLMember.SelectedValue = mem_id.ToString(); DDLMember.SelectedItem.Text = dt.Rows[0]["fname"].ToString() + " " + dt.Rows[0]["lname"].ToString(); DDLMember.SelectedValue = dt.Rows[0]["MemberId"].ToString(); } catch { } DDLYears.SelectedItem.Text = dt.Rows[0]["year"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] != null) { if (!IsPostBack) { DDLClubName.DataSourceID = "DSDistClubNo"; DDLClubName.DataBind(); BindTime(); TREvents.Visible = false; TRGuestCharge.Visible = false; TRSpeaker.Visible = true; TRTopics.Visible = true; if (Request.QueryString["id"] != null) { int eid = int.Parse(Request.QueryString["id"].ToString()); GetEvents(eid); } else { //string ve = rbtnvenue.SelectedItem.Text; //if (ve == "Regular") //{ // int cid = int.Parse(Session["DistrictClubID"].ToString()); // GetClubDetails(cid); //} //else //{ // txtvenue.Text = ""; //} } } } else { Session.Abandon(); Response.Redirect("Default.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] != null) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { DDLClubName.DataSourceID = "DSDistClubNo"; DDLClubName.DataBind(); int id = int.Parse(Request.QueryString["id"].ToString()); GetBodDesignation(id); } } } else { Session.Abandon(); Response.Redirect("Default.aspx"); } }
//private void BindYears() //{ // try // { // for (Int32 i = 1992; i <= Convert.ToInt32(DateTime.Now.Year); i++) // { // string dt = i + " - " + (i + 1); // DDLYear.Items.Add(dt.ToString()); // } // DDLYear.Items.Insert(0, "Year"); // } // catch (Exception E) // { // Response.Write(E.Message.ToString()); // } //} private void GetRollHonour(int id) { DBconnection obj = new DBconnection(); obj.SetCommandSP = "z_GetRollHonour"; obj.AddParam("@id", id); DataTable dt = new DataTable(); dt = obj.ExecuteTable(); if (dt.Rows.Count > 0) { DDLClubName.DataSourceID = "DSDistClubNo"; DDLClubName.DataBind(); DDLClubName.SelectedItem.Text = dt.Rows[0]["clubname"].ToString(); DDLClubName.SelectedValue = dt.Rows[0]["DistrictClubID"].ToString(); DDLYear.SelectedItem.Text = dt.Rows[0]["years"].ToString(); DDLMember.SelectedItem.Text = dt.Rows[0]["president"].ToString(); DDLMember0.SelectedItem.Text = dt.Rows[0]["secretary"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["user"] != null) { DDLClubName.DataSourceID = "DSDistClubNo"; DDLClubName.DataBind(); if (!IsPostBack) { BindTime(); if (Request.QueryString["id"] != null) { int id = int.Parse(Request.QueryString["id"].ToString()); GetOCV(id); } } } else { Session.Abandon(); Server.Transfer("Default.aspx"); } }