private void BindSecondPostOnBtn(int electionId)
{
CandidatesBll obj = new CandidatesBll();
DataTable dt = new DataTable();
obj.ElectionId = electionId;
dt = obj.GetCandidateByElection();
if (dt.Rows.Count > 0)
{
btnElection.Text = "Vote for " + dt.Rows[0]["election_name"].ToString();
}
}
private void GetCandidate(int id)
{
CandidatesBll obj = new CandidatesBll();
obj.Id = id;
DataTable dt = new DataTable();
dt = obj.GetCandidateById();
if (dt.Rows.Count > 0)
{
lblHeading.Text = "Edit Candidate's Details";
BindElectionName();
ddlElectionName.SelectedItem.Text = dt.Rows[0]["election_name"].ToString();
ddlElectionName.SelectedValue = dt.Rows[0]["election_id"].ToString();
ddlDistNo.SelectedItem.Text = dt.Rows[0]["district_no"].ToString();
int distNo = int.Parse(dt.Rows[0]["district_no"].ToString());
BindClubByDistId(distNo);
DDLYears.SelectedItem.Text = dt.Rows[0]["years"].ToString();
ddlClubName.SelectedItem.Text = dt.Rows[0]["club_name"].ToString();
txtName.Text = dt.Rows[0]["name"].ToString();
joiningDate.Text = dt.Rows[0]["joining_date"].ToString();
txtClassification.Text = dt.Rows[0]["classification"].ToString();
txtMemberShipNo.Text = dt.Rows[0]["membership_no"].ToString();
txtEmail.Text = dt.Rows[0]["email"].ToString();
txtMobile.Text = dt.Rows[0]["mobile"].ToString();
birthday.DbSelectedDate = dt.Rows[0]["birthday"].ToString();
txtDesc.Content = dt.Rows[0]["description"].ToString();
string strImg = dt.Rows[0]["photo"].ToString();
if (strImg != "")
{
Session["Image"] = strImg;
candidateImage.Visible = true;
candidateImage.ImageUrl = "../CandidatesImage/" + strImg;
}
string strBiodata = dt.Rows[0]["biodata"].ToString();
if (strBiodata != "")
{
Session["Biodata"] = strBiodata;
cadBio.Visible = true;
cadBio.HRef = "../CandidatesBiodata/" + strBiodata;
lblBiodataLink.Text = "../CandidatesBiodata/" + strBiodata;
}
}
}
//private void BindCandidates(int electionId, string nextElectionId)
//private void BindCandidates(int electionId)
private void BindCandidates(int electionId, string nextElectionId)
{
CandidatesBll obj = new CandidatesBll();
DataTable dt = new DataTable();
obj.ElectionId = electionId;
dt = obj.GetCandidateByElection();
if (dt.Rows.Count > 0)
{
btnElection.Attributes.Add("ElectionId", nextElectionId + "," + electionId);
lblElecTitle.Text = "Inner Wheel " + dt.Rows[0]["elec_district"].ToString() + " Election - " + dt.Rows[0]["election_name"].ToString() + " " + dt.Rows[0]["elec_year"].ToString();
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
}
////private void BindDistrictNo()
////{
//// MastersBLL obj = new MastersBLL();
//// DataTable dt = new DataTable();
//// dt = obj.GetDistrictNoList();
//// ddlDistNo.DataTextField = "district_no";
//// ddlDistNo.DataValueField = "district_no";
//// ddlDistNo.DataSource = dt;
//// ddlDistNo.DataBind();
//// // ddlDistNo.Items.Insert(0, "0");
////}
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());
CandidatesBll obj = new CandidatesBll();
obj.Id = id;
if (obj.DeleteCandidate() > 0)
{
//RadGrid1.DataBind();
BindGrid(ddlElectionName.SelectedItem.Text.Trim().ToString());
}
}
}
private void BindGrid(string electionName)
{
CandidatesBll obj = new CandidatesBll();
obj.ElectionName = electionName;
DataTable dt = new DataTable();
dt = obj.GetCandidatesByElectionName();
if (dt.Rows.Count > 0)
{
RadGrid1.Visible = true;
RadGrid1.DataSourceID = string.Empty;
RadGrid1.DataSource = dt;
RadGrid1.DataBind();
}
}
private void UpdateCandidate(int id)
{
try
{
string bioData = "";
string photo = "";
System.Data.SqlTypes.SqlDateTime nullDate;
nullDate = SqlDateTime.Null;
CandidatesBll obj = new CandidatesBll();
obj.Id = id;
obj.ElectionId = int.Parse(ddlElectionName.SelectedValue.ToString());
obj.DistrictNo = int.Parse(ddlDistNo.SelectedItem.Text.Trim().ToString());
obj.Years = DDLYears.SelectedItem.Text.Trim().ToString();
obj.ClubName = ddlClubName.SelectedItem.Text.Trim().ToString();
obj.Name = txtName.Text.Trim().ToString();
obj.JoiningDate = joiningDate.Text.Trim();
//try
//{
// obj.JoiningDate = DateTime.Parse(joiningDate.SelectedDate.ToString());
//}
//catch { obj.JoiningDate = nullDate; }
obj.Classification = txtClassification.Text.Trim().ToString();
try
{
obj.MembershipNo = int.Parse(txtMemberShipNo.Text.Trim().ToString());
}
catch { obj.MembershipNo = 0; }
obj.Email = txtEmail.Text.Trim().ToString();
obj.Mobile = txtMobile.Text.Trim().ToString();
try
{
obj.Birthday = DateTime.Parse(birthday.SelectedDate.ToString());
}
catch { obj.Birthday = nullDate; }
try
{
obj.Photo = Session["Image"].ToString();
}
catch { obj.Photo = ""; }
try
{
obj.BioData = Session["Biodata"].ToString();
}
catch { obj.BioData = ""; }
obj.Description = txtDesc.Content;
int i = obj.UpdateCandidate();
if (i > 0)
{
Clear();
showmsg("Candidates Has Been Updated Successfully", "ViewCandidates.aspx");
//string jv = "<script>alert('Candidates Has Been Updated Successfully');</script>";
//ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch { }
}
private void AddCandidate()
{
try
{
string bioData = "";
string photo = "";
/************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"];
}
/***************************************************************/
System.Data.SqlTypes.SqlDateTime nullDate;
nullDate = SqlDateTime.Null;
CandidatesBll obj = new CandidatesBll();
obj.ElectionId = int.Parse(ddlElectionName.SelectedValue.ToString());
obj.DistrictNo = int.Parse(ddlDistNo.SelectedItem.Text.Trim().ToString());
obj.Years = DDLYears.SelectedItem.Text.Trim().ToString();
obj.ClubName = ddlClubName.SelectedItem.Text.Trim().ToString();
obj.Name = txtName.Text.Trim().ToString();
obj.JoiningDate = joiningDate.Text.Trim();
////try
////{
//// obj.JoiningDate = DateTime.Parse(joiningDate.SelectedDate.ToString());
////}
////catch { obj.JoiningDate = nullDate; }
obj.Classification = txtClassification.Text.Trim().ToString();
try
{
obj.MembershipNo = int.Parse(txtMemberShipNo.Text.Trim().ToString());
}
catch { obj.MembershipNo = 0; }
obj.Email = txtEmail.Text.Trim().ToString();
obj.Mobile = txtMobile.Text.Trim().ToString();
try
{
obj.Birthday = DateTime.Parse(birthday.SelectedDate.ToString());
}
catch { obj.Birthday = nullDate; }
try
{
obj.Photo = Session["Image"].ToString();
}
catch { obj.Photo = ""; }
try
{
obj.BioData = Session["Biodata"].ToString();
}
catch { obj.BioData = ""; }
obj.Description = txtDesc.Content;
obj.Ipaddress = ipaddress;
int i = obj.AddCandidate();
if (i > 0)
{
Clear();
string jv = "<script>alert('Candidates Has Been Added Successfully');</script>";
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "alert", jv, false);
}
}
catch (Exception ex) { string s = ex.Message; }
}
