private void AddBodDesignation()
{
try
{
/************Code for find IP address of user's machine**********/
string ipaddress;
ipaddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ipaddress == "" || ipaddress == null)
{
ipaddress = Request.ServerVariables["REMOTE_ADDR"];
}
/***************************************************************/
BodBll obj = new BodBll();
obj.ClubId = int.Parse(DDLClubName.SelectedValue.ToString());
obj.Designation = txtBODPosi.Text.ToString();
obj.Ipaddress = ipaddress;
int exe = obj.AddBodDesignation();
if (exe > 0)
{
Clear();
string jv = "<script>alert('BOD Position Has Been Added Successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
protected void CVRImemNo_ServerValidate(object source, ServerValidateEventArgs args)
{
if (Request.QueryString["id"] != null)
{
CVPosition.Enabled = false;
}
else
{
try
{
DataTable dt = new DataTable();
BodBll obj = new BodBll();
obj.Designation = txtBODPosi.Text.Trim().ToString();
obj.ClubId = int.Parse(DDLClubName.SelectedValue.ToString());//int.Parse(Session["DistrictClubID"].ToString());
dt = obj.IsDesignationAlreadyExist();
if (dt.Rows.Count > 0)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
catch
{
args.IsValid = true;
}
}
}
private void UpdateBodMember(int id)
{
try
{
int distID = int.Parse(DDLClubName.SelectedValue.ToString());
int memid = int.Parse(DDLMember.SelectedValue.ToString());
BodBll obj = new BodBll();
obj.Id = id;
obj.ClubId = distID;
obj.MemberId = memid;
obj.DesignationId = int.Parse(DDLDesignation.SelectedValue.ToString());
obj.Year = DDLYears.SelectedItem.Text.Trim();
int exe = obj.UpdateBodMembers();
if (exe > 0)
{
clear();
showmsg("Bod Member Has Been Updated Successfully", "ViewBod.aspx");
}
}
catch { }
}
private void AddBodMembers()
{
try
{
/************Code for find IP address of user's machine**********/
string ipaddress;
ipaddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
if (ipaddress == "" || ipaddress == null)
{
ipaddress = Request.ServerVariables["REMOTE_ADDR"];
}
/***************************************************************/
int clubId = int.Parse(DDLClubName.SelectedValue.ToString());
int memid = int.Parse(DDLMember.SelectedValue.ToString());
BodBll obj = new BodBll();
obj.ClubId = clubId;
obj.MemberId = memid;
obj.DesignationId = int.Parse(DDLDesignation.SelectedValue.ToString());
obj.Year = DDLYears.SelectedItem.Text.Trim();
obj.AddedBy = "Admin";
obj.Ipaddress = ipaddress;
int exe = obj.AddBod();
if (exe > 0)
{
clear();
string jv = "<script>alert('Bod Member Has Been Added Successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
private void GetBodDesignation(int id)
{
BodBll obj = new BodBll();
obj.Id = id;
DataTable dt = new DataTable();
dt = obj.GetBodDesignationById();
if (dt.Rows.Count > 0)
{
DDLClubName.SelectedItem.Text = dt.Rows[0]["club_name"].ToString();
DDLClubName.SelectedValue = dt.Rows[0]["DistrictClubId"].ToString();
txtBODPosi.Text = dt.Rows[0]["designation"].ToString();
}
}
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());
BodBll obj = new BodBll();
obj.Id = id;
if (obj.DeleteBodDesignation() > 0)
{
ManageGrid();
}
}
}
private void UpdateBodDesignation(int id)
{
try
{
BodBll obj = new BodBll();
obj.Id = id;
obj.ClubId = int.Parse(DDLClubName.SelectedValue.ToString());
obj.Designation = txtBODPosi.Text.ToString();
int exe = obj.UpdateBodDesignation();
if (exe > 0)
{
Clear();
Showmsg("BOD Position Has Been Updated Successfully", "view_bod_position.aspx");
}
}
catch { }
}
private void BindGrid()
{
DataTable dt = new DataTable();
BodBll obj = new BodBll();
dt = obj.GetBodDesignationList();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
private void BindDesignations(int distID)
{
// int distID = int.Parse(Session["DistrictClubID"].ToString());
BodBll obj = new BodBll();
obj.ClubId = distID;
DataTable dt = new DataTable();
dt = obj.GetBodDesignationListByClubId();
DDLDesignation.DataTextField = "designation";
DDLDesignation.DataValueField = "id";
DDLDesignation.DataSource = dt;
DDLDesignation.DataBind();
// DDLDesignation.Items.Insert(0, "Select");
}
private void SearchGrid(int clubId)
{
DataTable dt = new DataTable();
BodBll obj = new BodBll();
obj.ClubId = clubId;
dt = obj.GetBodDesignationListByClubId();
if (dt.Rows.Count > 0)
{
lblMsg.Visible = false;
RadGrid1.Visible = true;
RadGrid1.DataSource = dt;
RadGrid1.Rebind();
}
else
{
lblMsg.Visible = true;
RadGrid1.Visible = false;
}
}
private void GetBodDetails(int id)
{
DataTable dt = new DataTable();
BodBll obj = new BodBll();
obj.ClubId = id;
dt = obj.GetAllBodByDist3141ClubId();
if (dt.Rows.Count > 0)
{
string desi = "";
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
try
{
desi = dt.Rows[i]["designation"].ToString();
if (desi == "President")
{
lblPresidentName.Text = "Rtn. " + dt.Rows[i]["Name"].ToString();
try
{
DateTime dojDt = DateTime.Parse(dt.Rows[0]["DOJ"].ToString());
lblJr.Text = dojDt.ToString("yyyy");
}
catch { lblJr.Text = "-"; }
string strClassification = dt.Rows[i]["classification"].ToString();
if (strClassification != "")
{
lblClassification.Text = strClassification;
}
else
{
lblClassification.Text = "-";
}
lblMobile.Text = dt.Rows[i]["Mobile1"].ToString();
lblEmail.Text = dt.Rows[i]["EmailId"].ToString();
lblPhResi.Text = dt.Rows[i]["RPhoneCc1"].ToString() + "-" + dt.Rows[i]["RPhoneAc1"].ToString() + "-" + dt.Rows[i]["RPhone1"].ToString();
lblPhOffice.Text = dt.Rows[i]["OPhoneCc1"].ToString() + "-" + dt.Rows[i]["OPhoneAc1"].ToString() + "-" + dt.Rows[i]["OPhone1"].ToString();
string strAdd1 = dt.Rows[i]["RAdd1"].ToString();
string strAdd2 = dt.Rows[i]["RAdd2"].ToString();
string strCity = dt.Rows[i]["RCity"].ToString();
string strPin = dt.Rows[i]["RPin"].ToString();
string strAddress = "";
if (strAdd1 != "")
{
strAddress = dt.Rows[i]["RAdd1"].ToString();
}
if (strAdd2 != "")
{
strAddress = strAddress + "<br />" + dt.Rows[i]["RAdd2"].ToString();
}
if (strCity != "")
{
strAddress = strAddress + "<br />" + dt.Rows[i]["RCity"].ToString();
}
if (strPin != "")
{
lblAddress.Text = strAddress + "-" + dt.Rows[i]["RPin"].ToString();
}
else
{
lblAddress.Text = strAddress;
}
try
{
DateTime dobDt = DateTime.Parse(dt.Rows[i]["DOB"].ToString());
lblDob.Text = dobDt.ToString("dd MMMM");
}
catch { lblDob.Text = "-"; }
string strBg = dt.Rows[i]["BG"].ToString().Trim();
string strRhf = dt.Rows[i]["RHF"].ToString();
if (strBg != "Select")
{
if (strBg != "")
{
lblBg.Text = strBg + strRhf;
}
}
else
{
lblBg.Text = "-";
}
try
{
DateTime sdoDt = DateTime.Parse(dt.Rows[i]["SDOB"].ToString());
lblSdob.Text = sdoDt.ToString("dd MMMM");
}
catch { lblSdob.Text = "-"; }
//lblSbg.Text = dt.Rows[i]["SBG"].ToString() + " " + dt.Rows[i]["SRHF"].ToString();
string strSBg = dt.Rows[i]["SBG"].ToString().Trim();
string strSRhf = dt.Rows[i]["SRHF"].ToString();
if (strSBg != "Select")
{
if (strSBg != "")
{
lblSbg.Text = strSBg + strSRhf;
}
}
else
{
lblSbg.Text = "-";
}
string strSpouse = dt.Rows[i]["SName"].ToString();
if (strSpouse != "")
{
lblSpouseName.Text = strSpouse;
}
else
{
lblSpouseName.Text = "-";
}
try
{
DateTime anniDt = DateTime.Parse(dt.Rows[i]["Anniversary"].ToString());
lblAnni.Text = anniDt.ToString("dd MMMM");
}
catch { lblAnni.Text = "-"; }
//string email = dt.Rows[i]["EmailId"].ToString();
//emaillink.HRef = "mailto:" + email;
string strImg = dt.Rows[i]["MemberImage"].ToString();
if (strImg != "")
{
imgPresident.Visible = true;
imgPresident.ImageUrl = "../MemberImages/" + strImg;
}
string strSImg = dt.Rows[i]["SImage"].ToString();
if (strSImg != "")
{
imgPresidentSpouse.Visible = true;
imgPresidentSpouse.ImageUrl = "../MemberImages/" + strSImg;
}
}
if (desi == "Secretary")
{
lblSecretaryName.Text = "Rtn. " + dt.Rows[i]["Name"].ToString();
try
{
DateTime dojDt = DateTime.Parse(dt.Rows[i]["DOJ"].ToString());
lblSecJr.Text = dojDt.ToString("yyyy");
}
catch { lblSecJr.Text = "-"; }
// lblSecClassi.Text = dt.Rows[i]["classification"].ToString();
string strClassification = dt.Rows[i]["classification"].ToString();
if (strClassification != "")
{
lblSecClassi.Text = strClassification;
}
else
{
lblSecClassi.Text = "-";
}
lblSecMobile.Text = dt.Rows[i]["Mobile1"].ToString();
lblSecEmail.Text = dt.Rows[i]["EmailId"].ToString();
lblSecPhResi.Text = dt.Rows[i]["RPhoneCc1"].ToString() + "-" + dt.Rows[i]["RPhoneAc1"].ToString() + "-" + dt.Rows[i]["RPhone1"].ToString();
lblSecPhOffice.Text = dt.Rows[i]["OPhoneCc1"].ToString() + "-" + dt.Rows[i]["OPhoneAc1"].ToString() + "-" + dt.Rows[i]["OPhone1"].ToString();
string strAdd1 = dt.Rows[i]["RAdd1"].ToString();
string strAdd2 = dt.Rows[i]["RAdd2"].ToString();
string strCity = dt.Rows[i]["RCity"].ToString();
string strPin = dt.Rows[i]["RPin"].ToString();
string strAddress = "";
if (strAdd1 != "")
{
strAddress = dt.Rows[i]["RAdd1"].ToString();
}
if (strAdd2 != "")
{
strAddress = strAddress + "<br />" + dt.Rows[i]["RAdd2"].ToString();
}
if (strCity != "")
{
strAddress = strAddress + "<br />" + dt.Rows[i]["RCity"].ToString();
}
if (strPin != "")
{
lblSecAddress.Text = strAddress + "-" + dt.Rows[i]["RPin"].ToString();
}
else
{
lblSecAddress.Text = strAddress;
}
string strSecSpouse = dt.Rows[i]["SName"].ToString();
if (strSecSpouse != "")
{
lblSecSpouse.Text = strSecSpouse;
}
else
{
lblSecSpouse.Text = "-";
}
try
{
DateTime dobDt = DateTime.Parse(dt.Rows[i]["DOB"].ToString());
lblSecDob.Text = dobDt.ToString("dd MMMM");
}
catch { lblSecDob.Text = "-"; }
// lblSecBg.Text = dt.Rows[i]["BG"].ToString() + " " + dt.Rows[i]["RHF"].ToString();
string strSecBg = dt.Rows[i]["BG"].ToString().Trim();
string strSecRhf = dt.Rows[i]["RHF"].ToString();
if (strSecBg != "Select")
{
if (strSecBg != "")
{
lblSecBg.Text = strSecBg + strSecRhf;
}
}
else
{
lblSecBg.Text = "-";
}
try
{
DateTime sdoDt = DateTime.Parse(dt.Rows[i]["SDOB"].ToString());
lblSecSdob.Text = sdoDt.ToString("dd MMMM");
}
catch { lblSecSdob.Text = "-"; }
// lblSecSbg.Text = dt.Rows[i]["SBG"].ToString() + " " + dt.Rows[i]["SRHF"].ToString();
string strSecSBg = dt.Rows[i]["BG"].ToString().Trim();
string strSecSRhf = dt.Rows[i]["RHF"].ToString();
if (strSecSBg != "Select")
{
if (strSecSBg != "")
{
lblSecSbg.Text = strSecSBg + strSecSRhf;
}
}
else
{
lblSecSbg.Text = "-";
}
try
{
DateTime anniDt = DateTime.Parse(dt.Rows[i]["Anniversary"].ToString());
lblSecAnni.Text = anniDt.ToString("dd MMMM");
}
catch { lblSecAnni.Text = "-"; }
string strSecImg = dt.Rows[i]["MemberImage"].ToString();
if (strSecImg != "")
{
imgSecretary.Visible = true;
imgSecretary.ImageUrl = "../MemberImages/" + strSecImg;
}
string strSesSImg = dt.Rows[i]["SImage"].ToString();
if (strSesSImg != "")
{
imgSecretarySpouse.Visible = true;
imgSecretarySpouse.ImageUrl = "../MemberImages/" + strSesSImg;
}
}
//if (desi == "President Elect")
//{
// lblPresidentName.Text = "Rtn. " + dt.Rows[i]["Name"].ToString();
// lblMobile.Text = dt.Rows[i]["Mobile1"].ToString();
// lblEmail.Text = dt.Rows[i]["EmailId"].ToString();
//}
//if (desi == "Hon. Treasurer")
//{
// lblPresidentName.Text = "Rtn. " + dt.Rows[i]["Name"].ToString();
// lblMobile.Text = dt.Rows[i]["Mobile1"].ToString();
// lblEmail.Text = dt.Rows[i]["EmailId"].ToString();
//}
}
catch { }
}
}
}
