private void GetClub(int id)
{
ClubsBll obj = new ClubsBll();
obj.Id = id;
DataTable dt = new DataTable();
dt = obj.GetClubById();
if (dt.Rows.Count > 0)
{
BindDistrictNo();
lblHeading.Text = "Edit District No.";
ddlDistNo.SelectedItem.Text = dt.Rows[0]["district_no"].ToString();
txtClubNo.Text = dt.Rows[0]["club_no"].ToString();
txtClubName.Text = dt.Rows[0]["club_name"].ToString();
txtActiveMem.Text = dt.Rows[0]["active_members"].ToString();
// txtHonoraryMem.Text = dt.Rows[0]["honorary_members"].ToString();
string strEV = dt.Rows[0]["voting_eligibility"].ToString();
if (strEV == "Yes")
{
rbtnVEligibility.SelectedIndex = 0;
}
else
{
rbtnVEligibility.SelectedIndex = 1;
}
}
}
private void AddClub()
{
try
{
/************Code for find IP address of user's machine**********/
string ipaddress;
// Look for a proxy address first
ipaddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
// If there is no proxy, get the standard remote address
if (ipaddress == "" || ipaddress == null)
{
ipaddress = Request.ServerVariables["REMOTE_ADDR"];
}
/***************************************************************/
ClubsBll obj = new ClubsBll();
obj.DistrictNo = int.Parse(ddlDistNo.SelectedItem.Text.Trim().ToString());
obj.ClubNo = int.Parse(txtClubNo.Text.Trim().ToString());
obj.ClubName = txtClubName.Text.Trim().ToString();
obj.ActiveMem = int.Parse(txtActiveMem.Text.Trim().ToString());
obj.HonoraryMem = 0;
obj.EligibleVotes = 0;
obj.VotingEligibility = rbtnVEligibility.SelectedItem.Text.Trim().ToString();
obj.Ipaddress = ipaddress;
int i = obj.AddClub();
if (i > 0)
{
Clear();
string jv = "<script>alert('District Club Has Been Added Successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch (Exception ex) { }
}
private void UpdateClub(int id)
{
try
{
ClubsBll obj = new ClubsBll();
obj.Id = id;
obj.DistrictNo = int.Parse(ddlDistNo.SelectedItem.Text.Trim().ToString());
obj.ClubNo = int.Parse(txtClubNo.Text.Trim().ToString());
obj.ClubName = txtClubName.Text.Trim().ToString();
obj.ActiveMem = int.Parse(txtActiveMem.Text.Trim().ToString());
obj.HonoraryMem = 0;
obj.EligibleVotes = 0;
obj.VotingEligibility = rbtnVEligibility.SelectedItem.Text.Trim().ToString();
int i = obj.UpdateClub();
if (i > 0)
{
Clear();
showmsg("District Club Has Been Updated Successfully", "ViewDistrictClubs.aspx");
//string jv = "<script>alert('District Club Has Been Updated Successfully');</script>";
//ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch (Exception ex) { }
}
private void BindClubByDistId(int distNo)
{
ClubsBll obj = new ClubsBll();
DataTable dt = new DataTable();
obj.DistrictNo = distNo;
dt = obj.GetClubByDistNo();
ddlClubName.DataTextField = "club_name";
ddlClubName.DataValueField = "id";
ddlClubName.DataSource = dt;
ddlClubName.DataBind();
ddlClubName.Items.Insert(0, "Select");
}
protected void RadGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
string i = e.CommandArgument.ToString();
int id = int.Parse(i.ToString());
ClubsBll obj = new ClubsBll();
obj.Id = id;
if (obj.DeleteClub() > 0)
{
RadGrid1.DataBind();
}
}
}
