protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
String query = "select * from Country";
ob.ExeAdapter(query, "Contry");
ob.DropList(DropDownList1, query, "Country_id", "Country_name", "---select Country---");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.Count > 0)
{
name = Request.QueryString["Email"].ToString();
string qury = "select CandidateName from CandidateRegistration where email='" + name + "'";
ds = ob.ExeAdapter(qury, "CandidateRegistration");
candidatename = "";
if (ds.Tables["CandidateRegistration"].Rows.Count > 0)
{
candidatename = ds.Tables["CandidateRegistration"].Rows[0]["CandidateName"].ToString();
}
}
else
{
Response.Redirect("Candidatelogin.aspx");
}
string qry = "select profile from CandidateRegistration where email='" + name + "'";
ds = ob.ExeAdapter(qry, "CandidateRegistration");
if (ds.Tables["CandidateRegistration"].Rows.Count > 0)
{
Image1.ImageUrl = ds.Tables["CandidateRegistration"].Rows[0]["profile"].ToString();
}
else
{
Image1.ImageUrl = ds.Tables["CandidateRegistration"].Rows[0]["profile"].ToString();
}
string query = "select * from Edit where email='" + name + "'";
ds = ob.ExeAdapter(query, "Edit");
if (ds.Tables["Edit"].Rows.Count != 0)
{
lbl_name.Text = candidatename;
Label2.Text = ds.Tables["Edit"].Rows[0]["Skill"].ToString();
Label3.Text = ds.Tables["Edit"].Rows[0]["Study"].ToString();
Label4.Text = ds.Tables["Edit"].Rows[0]["Home"].ToString();
Label5.Text = ds.Tables["Edit"].Rows[0]["Pview"].ToString();
Label6.Text = ds.Tables["Edit"].Rows[0]["Qparty"].ToString();
Label7.Text = ds.Tables["Edit"].Rows[0]["Nparty"].ToString();
Label8.Text = ds.Tables["Edit"].Rows[0]["Aparty"].ToString();
}
else
{
Label2.Text = "";
Label3.Text = "";
Label4.Text = "";
Label5.Text = "";
Label6.Text = "";
Label7.Text = "";
Label8.Text = "";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@pass", TextBox10.Text),
new SqlParameter("@cpass", chgnp.Text),
new SqlParameter("@cont", chgcon0.Text) };
string query = "select Password from CandidateRegistration where Password=@pass";
ds = ob.ExeAdapter(query, parameter, "CandidateRegistration");
int count = ds.Tables["CandidateRegistration"].Rows.Count;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@pass", TextBox10.Text),
new SqlParameter("@cpass", chgnp.Text),
new SqlParameter("@cont", chgcon0.Text) };
if (count > 0)
{
query = "update CandidateRegistration set Password=@cpass where Password=@pass";
ob.ExeQuery(query, parameters);
Response.Redirect("Candidate.aspx?Email=" + name);
}
else
{
Response.Write("<script>alert('Your password is incorrect:')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString.Count > 0)
{
string name = Request.QueryString["no"].ToString();
// Response.Write(name);
int count = Convert.ToInt32(name);
img = new Image[count];
img1 = new Image[count];
brk = new Label[count];
brk1 = new Label[count];
brk2 = new Label[count];
brk3 = new Label[count];
txt = new Label[count];
string query = "select * from CandidateRegistration";
ds = ob.ExeAdapter(query, "CandidateRegistration");
int a = ds.Tables["CandidateRegistration"].Rows.Count;
for (int index = 0; index < count; index++)
{
img[index] = new Image();
string st = ds.Tables["CandidateRegistration"].Rows[a - 1]["profile"].ToString();
img[index].ImageUrl = st;
img[index].Width = 200;
img[index].Height = 200;
string st1 = ds.Tables["CandidateRegistration"].Rows[(a - 1)]["CandidateName"].ToString();
brk[index] = new Label();
brk[index].Text = "<br/><br/>";
txt[index] = new Label();
txt[index].Text = "Candidate Name: " + st1;
txt[index].CssClass = "font";
brk2[index] = new Label();
/* img1[index] = new Image();
* string st3 = ds.Tables["CandidateRegistration"].Rows[a - 1]["ElectionSign"].ToString();
* img1[index].ImageUrl = st3;
* img1[index].Width = 200;
* img1[index].Height = 200;
*/
brk1[index] = new Label();
brk1[index].Text = "<br/><br/><hr/>";
a--;
PlaceHolder1.Controls.Add(img[index]);
PlaceHolder1.Controls.Add(brk[index]);
PlaceHolder1.Controls.Add(txt[index]);
PlaceHolder1.Controls.Add(brk1[index]);
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string Email = Cname.Text;
string password = TextBox2.Text;
string query = "select * from CandidateRegistration where email=@email and Password=@pass";
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@email", Email),
new SqlParameter("@pass", password)
};
ds = common.ExeAdapter(query, parameter, "CandidateRegistration");
int count = ds.Tables["CandidateRegistration"].Rows.Count;
if (count == 1)
{
// Response.Redirect("Candidate.aspx");
Response.Redirect("Candidate.aspx?Email=" + Cname.Text);
}
else
{
Response.Write("<script>alert('Your Name id or password is incorrect:')</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
/*Session["count"]=Convert.ToInt32(Session["count"])+1;
* Response.Write("Session Count :" + Session["count"]+"<br/>");*/
if (Session["id"] != null)
{
uid = Session["id"].ToString();
query = "Select * from user_details where userid=@id";
SqlParameter[] parameter = new SqlParameter[]
{
new SqlParameter("@id", uid)
};
DataSet ds = common.ExeAdapter(query, parameter, "users");
string username = ds.Tables["users"].Rows[0]["name"].ToString();
string email = ds.Tables["users"].Rows[0]["email"].ToString();
string path = ds.Tables["users"].Rows[0]["image"].ToString();
ImageButton1.ImageUrl = path;
alert += "Welcome " + username + "!";
alert += "EmailID : " + email;
Response.Write("<script>alert('" + alert + "')</script>");
lbl_name.Text = lbl_name2.Text = username;
txt_mail.Text = ds.Tables["users"].Rows[0]["email"].ToString();
txt_mobile.Text = ds.Tables["users"].Rows[0]["mobileno"].ToString();
//Formatting address string-----------------------------------------------------
string address = ds.Tables["users"].Rows[0]["address"].ToString();
string[] adr = address.Split('+');
address = "";
for (int i = 0; i < adr.Length; i++)
{
address += adr[i] + ",";
}
address = address.Replace('=', '-');
txt_address.Text = address;
///fetching voterID from UserID------------------------------------------
///
query = "select image from images where imageid=@id";
parameter = new SqlParameter[]
{
new SqlParameter("@id", uid)
};
object vid = common.ExeScalar(query, parameter);
voterid = vid.ToString();
img_voterid.ImageUrl = voterid;
img_voterid.AlternateText = username + "VoterID";
}
else
{
Response.Redirect("Userlogin.aspx");
}
}
