private void AddOCV()
{
try
{
string h, m, am, time = "";
h = DDLTimeH.SelectedItem.Text;
m = DDLTimeM.SelectedItem.Text;
am = DDLTimeAMPM.SelectedItem.Text;
time = h + ":" + m + ":" + am;
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_AddOCVCal";
obj.AddParam("@club_name", DDLClubName.SelectedItem.Text.Trim().ToString());
obj.AddParam("@club_id", int.Parse(DDLClubName.SelectedValue.ToString()));
obj.AddParam("@date", DateTime.Parse(RadDatePicker1.SelectedDate.Value.ToString()));
obj.AddParam("@time", time);
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
string jv = "<script>alert('Record Added Successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
private void BindGrid(string yrs, string position)
{
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
// obj.SetCommandQry = "SELECT * FROM [View_DistPositionHeldMembers] where district_no='3141' and years='" + yrs + "' and avenue='" + position + "' order by Name";
obj.SetCommandSP = "z_GetPositionByAvenue";
obj.AddParam("@district_no", 3141);
obj.AddParam("@years", yrs);
obj.AddParam("@avenue", position);
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
private void GetEventByDate()
{
//string[] dFrom = dateFrom.SelectedDate.ToString().Split(' ');
//string[] dTo = dateTo.SelectedDate.ToString().Split(' ');
//string dFromm = dFrom[0].Replace('/', '-');
//string dtoo = dTo[0].Replace('/', '-');
DateTime dFromm = DateTime.Parse(dateFrom.DbSelectedDate.ToString());
DateTime dtoo = DateTime.Parse(dateTo.DbSelectedDate.ToString());
//string dtoo = dTo[0].Replace('/', '-');
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_SortOrderbyDate_sp";
obj.AddParam("@dFrom", dFromm);
obj.AddParam("@dTo", dtoo);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
private void UpdateOCV(int id)
{
try
{
string h, m, am, time = "";
h = DDLTimeH.SelectedItem.Text;
m = DDLTimeM.SelectedItem.Text;
am = DDLTimeAMPM.SelectedItem.Text;
time = h + ":" + m + ":" + am;
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_UpdateOCVCal";
obj.AddParam("@id", id);
obj.AddParam("@club_name", DDLClubName.SelectedItem.Text.Trim().ToString());
obj.AddParam("@club_id", int.Parse(DDLClubName.SelectedValue.ToString()));
obj.AddParam("@date", DateTime.Parse(RadDatePicker1.SelectedDate.Value.ToString()));
obj.AddParam("@time", time);
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
showmsg("Record updated successfully !", "view_ocv_cal.aspx");
}
}
catch { }
}
private void UpdatePastDistrictGove(int id)
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_UpdatePastDistGove";
obj.AddParam("@id", id);
string yrs = DDLYears.SelectedItem.Text.ToString();
obj.AddParam("@year", yrs);
obj.AddParam("@rotarian_name", txtRotarian.Text.ToString());
obj.AddParam("@club_name", txtClubName.Text.ToString());
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
showmsg("Record Updated Successfully", "view_past_district_gove.aspx");
//string jv = "<script>alert('Record Updated Successfully');</script>";
//ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
private void AddAward()
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_AddDistrictAward";
obj.AddParam("@category", DDLCategory.SelectedItem.Text.Trim().ToString());
obj.AddParam("@award_name", txtAwardName.Text.Trim().ToString());
string ss = DDLDonor.SelectedItem.Text.Trim().ToString();
if (ss == "Select")
{
obj.AddParam("@donor", txtOtherDonor.Text.Trim().ToString());
}
else
{
obj.AddParam("@donor", DDLDonor.SelectedItem.Text.Trim().ToString());
}
obj.AddParam("@constituted_on", DDLYear.SelectedItem.Text.Trim().ToString());
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
string jv = "<script>alert('Record Added Successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "UpdateImagetoDB";
obj.AddParam("@ID", 1);
obj.AddParam("@Name", TextBox1.Text.Trim().ToString());
obj.AddParam("@Picture", (byte[])Session["Image"]);
obj.ExecuteNonQuery();
}
private void UpdateDisconRegistrationRate(int id)
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "disc_UpdateDisconRegistrationFees";
obj.AddParam("@id", id);
obj.AddParam("@member_type", rbtnMemType.SelectedItem.Text.Trim().ToString());
obj.AddParam("@category", ddlCat.SelectedItem.Text.Trim().ToString());
obj.AddParam("@registration_fees_for", rbtnRegisFor.SelectedItem.Text.Trim().ToString());
try
{
obj.AddParam("@date_from", DateTime.Parse(dateFrom.SelectedDate.ToString()));
}
catch { obj.AddParam("@date_from", null); }
try
{
obj.AddParam("@date_to", DateTime.Parse(dateTo.SelectedDate.ToString()));
}
catch { obj.AddParam("@date_to", null); }
obj.AddParam("@amount", decimal.Parse(txtAmt.Text.Trim().ToString()));
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
showmsg("Record updated successfully !", "view_add_discon_registration_rate.aspx");
}
}
catch { }
}
private void UpdateDonors(int id)
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_UpdateBenif_Bequest";
obj.AddParam("@id", id);
obj.AddParam("@level", ddlLevel.SelectedItem.Text.ToString());
obj.AddParam("@title", drtitle.SelectedItem.Text.ToString());
obj.AddParam("@fname", txtfname.Text.ToString());
obj.AddParam("@mname", txtmname.Text.ToString());
obj.AddParam("@lname", txtlname.Text.ToString());
obj.AddParam("@DistrictClubID", int.Parse(DDLClubName.SelectedValue.ToString()));
obj.AddParam("@club_name", DDLClubName.SelectedItem.Text.ToString());
obj.AddParam("@achieved_date", DateTime.Parse(RadDatePicker1.SelectedDate.ToString()));
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
//string jv = "<script>alert('Record Has Been Updated Successfully');</script>";
//ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
showmsg("Record Has Been Updated Successfully", "view_benefactors_members.aspx");
}
}
catch { }
}
public DataTable GetDistrictClub()
{
DBconnection obj = new DBconnection();
DataTable dt = new DataTable();
obj.SetCommandSP = "z_GetDistClub";
obj.AddParam("@district_no", this.DistrictNo);
obj.AddParam("@voting_eligibility", this.VotingEligibility);
dt = obj.ExecuteTable();
return(dt);
}
public DataTable GetVoteResultByNonePref3()
{
DBconnection obj = new DBconnection();
DataTable dt = new DataTable();
obj.SetCommandSP = "z_GetVotingResultByNonePref3";
obj.AddParam("@district_no", this.DistrictNo);
obj.AddParam("@years", this.Years);
dt = obj.ExecuteTable();
return(dt);
}
public DataTable GetDesiForSendMail()
{
DBconnection obj = new DBconnection();
DataTable dt = new DataTable();
obj.SetCommandSP = "z_GetDesiForSendMail";
obj.AddParam("@district_no", this.DistrictNo);
obj.AddParam("@desig_type", this.DesiType);
dt = obj.ExecuteTable();
return(dt);
}
public DataTable GetCandidateInPref2()
{
DBconnection obj = new DBconnection();
DataTable dt = new DataTable();
obj.SetCommandSP = "z_GetCandidatesInPref2";
obj.AddParam("@district_no", this.DistrictNo);
obj.AddParam("@candidate_id", this.CandidatesId);
dt = obj.ExecuteTable();
return(dt);
}
public DataTable GetCandidateByDistNo()
{
DBconnection obj = new DBconnection();
DataTable dt = new DataTable();
obj.SetCommandSP = "z_GetCandidatesByDistNo";
obj.AddParam("@years", this.Years);
obj.AddParam("@district_no", this.DistrictNo);
dt = obj.ExecuteTable();
return(dt);
}
private void BindGridDate()
{
Session["SearchField"] = null;
Session["SearchBy"] = null;
Session["SearchByAlphabetic"] = null;
Session["SortBy"] = null;
Session["SortByDateRange"] = "Date Range";
//string[] dFrom = dateFrom.SelectedDate.ToString().Split(' ');
//string[] dTo = dateTo.SelectedDate.ToString().Split(' ');
//string dFromm = dFrom[0].Replace('/', '-');
//string dtoo = dTo[0].Replace('/', '-');
DateTime dFromm = DateTime.Parse(dateFrom.DbSelectedDate.ToString());
DateTime dtoo = DateTime.Parse(dateTo.DbSelectedDate.ToString());
//string dtoo = dTo[0].Replace('/', '-');
DBconnection obj = new DBconnection();
///************Code For Local Database **********/
//try
//{
// string distConnString = obj.GetLocalConnString();
// obj.SetConnString = distConnString;
//}
//catch
//{
//}
///*********************************************/
obj.SetCommandSP = "z_SortOrderbyDate";
obj.AddParam("@dFrom", dFromm);
obj.AddParam("@dTo", dtoo);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
PanelDate.Visible = true;
lblError.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblError.Visible = true;
RadGrid1.Visible = false;
}
}
public int UpdateColors()
{
int i = 0;
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_UpdateDistrictNo";
obj.AddParam("@id", this.id);
obj.AddParam("@district_no", this.districtNo);
i = obj.ExecuteNonQuery();
return(i);
}
public int UpdateDollorRate()
{
int i = 0;
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_UpdateDollorRate";
obj.AddParam("@id", this.id);
obj.AddParam("@dollor_rate", this.dollorRate);
i = obj.ExecuteNonQuery();
return(i);
}
public DataTable GetVotedClubs()
{
DBconnection obj = new DBconnection();
DataTable dt = new DataTable();
obj.SetCommandSP = "z_GetVotedClubs";
obj.AddParam("@district_no", this.DistrictNo);
obj.AddParam("@election_id", this.ElectionId);
// obj.AddParam("@years", this.Years);
dt = obj.ExecuteTable();
return(dt);
}
public DataTable GetVotingResultDistrictWise()
{
DBconnection obj = new DBconnection();
DataTable dt = new DataTable();
obj.SetCommandSP = "z_GetVotingResultByDistrictWise";
obj.AddParam("@election_id", this.ElectionId);
obj.AddParam("@district_no", this.DistrictNo);
dt = obj.ExecuteTable();
return(dt);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
DBconnection con = new DBconnection();
DataTable objdt = new DataTable();
con.SetCommandSP = "z_LoginUser";
con.AddParam("@uname", txtUsername.Text.Trim().ToString());
con.AddParam("@pass", txtPassword.Text.Trim().ToString());
objdt = con.ExecuteTable();
if (objdt.Rows.Count > 0)
{
// LblInvalid.Visible = false;
Session["user"] = txtUsername.Text;
Session["Admin"] = txtUsername.Text;
Session["AdminUserName"] = objdt.Rows[0]["FName"].ToString() + " " + objdt.Rows[0]["LName"].ToString();
//Session["AdminUserName"] = objdt.Rows[0]["Name"].ToString();
Session["Uid"] = objdt.Rows[0]["UID"].ToString();
Session["Add"] = objdt.Rows[0]["UAdd"].ToString();
Session["View"] = objdt.Rows[0]["UView"].ToString();
Session["Edit"] = objdt.Rows[0]["UEdit"].ToString();
Session["Delete"] = objdt.Rows[0]["UDelete"].ToString();
if (ckremember.Checked)
{
if (ckremember.Checked)
{
if (Request.Browser.Cookies == true)
{
HttpCookie loginCook = new HttpCookie("UserCook1");
loginCook["AdminUserName"] = txtUsername.Text.ToString();
loginCook["AdminPass"] = txtPassword.Text.ToString();
loginCook.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(loginCook);
}
}
}
Response.Redirect("ViewDistrictClubs.aspx");
}
else
{
//LblInvalid.Visible = true;
string msg = "Invalid Username or Password";
showmsg(msg);
}
}
}
private void UpdateAOSC(int id)
{
if (Page.IsValid)
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_UpdateAvenues_of_service";
obj.AddParam("@id", id);
obj.AddParam("@years", DDLYears.SelectedItem.Text.ToString());
obj.AddParam("@title", drtitle.SelectedItem.Text.ToString());
obj.AddParam("@fname", txtfname.Text.ToString());
obj.AddParam("@mname", txtmname.Text.ToString());
obj.AddParam("@lname", txtlname.Text.ToString());
obj.AddParam("@DistrictClubID", int.Parse(DDLClubName.SelectedValue.ToString()));
obj.AddParam("@club_name", DDLClubName.SelectedItem.Text.ToString());
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
//string jv = "<script>alert('Record Has Been Updated Successfully');</script>";
//ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
showmsg("Record Has Been Updated Successfully", "view_major_donors.aspx");
}
}
catch { }
}
}
// Add
public int AddRiDgData()
{
int i = 0;
try
{
// year, name, clubName, designation, classfication, image, description
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_AddRiDgData";
obj.AddParam("@year", this.year);
obj.AddParam("@name", this.name);
obj.AddParam("@club_name", this.clubName);
obj.AddParam("@designation", this.designation);
obj.AddParam("@classification", this.classfication);
obj.AddParam("@image", this.image);
obj.AddParam("@description", this.description);
obj.AddParam("@ipaddress", this.ipaddress);
i = obj.ExecuteNonQuery();
}
catch { }
return(i);
}
private void AddDistOfficers()
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_AddDistOfficers";
obj.AddParam("@Member_id", int.Parse(DDLMemName.SelectedValue.ToString()));
obj.AddParam("@years", DDLYears.SelectedItem.Text.Trim().ToString());
obj.AddParam("@type", rbtnType.SelectedItem.Text.Trim().ToString());
obj.AddParam("@DistDesigID", int.Parse(DDLDesig.SelectedValue.ToString()));
//try
//{
// obj.AddParam("@DistSubDesigID", int.Parse(DDLSubDesig.SelectedValue.ToString()));
//}
//catch
//{
// obj.AddParam("@DistSubDesigID", 0);
//}
//string topics = "";
//if (listTopics.Items.Count > 0)
//{
// RFVDesig.Visible = false;
// foreach (ListItem li in listTopics.Items)
// {
// topics = topics + li.Value.Trim().ToString() + ";";
// }
//}
//if (int.Parse(DDLDesig.SelectedValue.ToString())!= 0)
//{
// topics = topics + int.Parse(DDLDesig.SelectedValue.ToString());
//}
int exe = obj.ExecuteNonQuery();
if (exe > 0)
{
clear();
string jv = "<script>alert('Record has been added successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
private void SearchByAlphabet(string name)
{
rbtnSearch.ClearSelection();
txtName.Text = "";
DDLClubName.Visible = false;
txtName.Visible = true;
btnSearch.Visible = true;
Session["value"] = null;
Session["searchField"] = null;
Session["name"] = name;
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_SearchByAlphabetPeaceSeminar";
obj.AddParam("@f_name", name);
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
private void GetClubDetails(int id)
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetDistrictClubDetails";
obj.AddParam("@id", id);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
string[] time = dt.Rows[0]["time"].ToString().Split(':');
DDLTimeH.SelectedItem.Text = time[0].ToString();
DDLTimeM.SelectedItem.Text = time[1].ToString();
DDLTime.SelectedItem.Text = time[2].ToString();
txtvenue.Text = dt.Rows[0]["venue1"].ToString() + " " + dt.Rows[0]["venue2"].ToString() + " " + dt.Rows[0]["city"].ToString();
//string gps = dt.Rows[0]["gps_latitude"].ToString();
//if (gps != "")
//{
// lblGPS.Text = "Latitude : " + dt.Rows[0]["gps_latitude"].ToString() + " " + "Longitude : " + dt.Rows[0]["gps_longitude"].ToString();
//}
//else
//{
// lblGPS.Text = "";
//}
}
}
private void GetUser(int id)
{
try
{
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_GetUser";
obj.AddParam("@UID", id);
DataTable dt = new DataTable();
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
txtPassword.TextMode = TextBoxMode.SingleLine;
txtConfirmPassword.TextMode = TextBoxMode.SingleLine;
txtUsername.Text = dt.Rows[0]["UserName"].ToString();
txtPassword.Text = dt.Rows[0]["Password"].ToString();
txtConfirmPassword.Text = dt.Rows[0]["Password"].ToString();
txtFirstName.Text = dt.Rows[0]["FName"].ToString();
txtLastName.Text = dt.Rows[0]["LName"].ToString();
txtDesignation.Text = dt.Rows[0]["Designation"].ToString();
string uAdd = dt.Rows[0]["UAdd"].ToString();
if (uAdd == "True")
{
UAddCheckBox.Checked = true;
}
string uEdit = dt.Rows[0]["UEdit"].ToString();
if (uEdit == "True")
{
UEditCheckBox.Checked = true;
}
string uDelete = dt.Rows[0]["UDelete"].ToString();
if (uDelete == "True")
{
UDeleteCheckBox.Checked = true;
}
string uView = dt.Rows[0]["UView"].ToString();
if (uView == "True")
{
UViewCheckBox.Checked = true;
}
txtEmail.Text = dt.Rows[0]["Email"].ToString();
txtMobCC.Text = dt.Rows[0]["MobileCC"].ToString();
txtMobile.Text = dt.Rows[0]["Mobile"].ToString();
txtPhCC.Text = dt.Rows[0]["Phone_CC"].ToString();
txtPhAC.Text = dt.Rows[0]["Phone_AC"].ToString();
txtPhone.Text = dt.Rows[0]["Phone"].ToString();
txtCity.Text = dt.Rows[0]["City"].ToString();
txtState.Text = dt.Rows[0]["State"].ToString();
txtAddress1.Text = dt.Rows[0]["Address1"].ToString();
txtAddress2.Text = dt.Rows[0]["Address2"].ToString();
}
}
catch { }
}
private void BindGrid(string clubName)
{
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
//obj.SetCommandQry = "SELECT * FROM [View_DistPositionHeldMembers] where district_no='3141' and years='" + yrs + "' and club_name='" + clubName + "' order by Name";
obj.SetCommandSP = "z_GetClubwisePositionReport";
// obj.AddParam("@years", yrs);
obj.AddParam("@club_name", clubName);
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
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();
}
}
private void SearchByAlphabet(string name)
{
Session["name"] = name;
DataTable dt = new DataTable();
DBconnection obj = new DBconnection();
obj.SetCommandSP = "z_SearchByAlphabetProject";
obj.AddParam("@f_name", name);
dt = obj.ExecuteTable();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
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();
}
}
