protected void chngepasswordbtn_Click(object sender, EventArgs e) { if (Page.IsValid) { Juryinfo jinfo = (Juryinfo)Session["juryinfo"]; //string query1=string.Format("select count(*) from Users where Password='******'",oldpswd.Text.Trim()); string query2 = string.Format("update Jury set Password='******' where Juryid='{1}'", newpasswd.Text.Trim(), jinfo.Juryid); try { using (con = new SqlConnection(constr)) { if (con.State != ConnectionState.Open) { con.Open(); } using (cmd = new SqlCommand(query2, con)) { if (jinfo.Password == oldpswd.Text.Trim()) { int count = (int)cmd.ExecuteNonQuery(); if (count > 0) { jinfo.Password = newpasswd.Text.Trim(); Session["juryinfo"] = jinfo; string message = "Passwors is successfully changed."; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("<script type = 'text/javascript'>"); sb.Append("window.onload=function(){"); sb.Append("alert('"); sb.Append(message); sb.Append("')};"); sb.Append("</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString()); Response.AppendHeader("Refresh", "1;url=jchangePassword.aspx"); } else { changepasswordpage.Text = "Something error occured.please try again later."; } } else { changepasswordpage.Text = "You have enterened wrong old password."; } } } } catch (Exception ee) { changepasswordpage.Text = ee.Message; } finally { if (con.State != ConnectionState.Closed) { con.Close(); } } } }
protected void Page_Load(object sender, EventArgs e) { Juryinfo jinfo = (Juryinfo)Session["juryinfo"]; if (Session["juryinfo"] == null) { Response.Redirect("../Default.aspx"); } if (!IsPostBack) { lbname.Text = string.Format("Hello, {0}", jinfo.Name); } }
protected void Page_Load(object sender, EventArgs e) { Juryinfo jinfo = (Juryinfo)Session["juryinfo"]; if (Session["juryinfo"] == null) { Response.Redirect("../Default.aspx"); } if (!IsPostBack) { lblName.Text = string.Format("{0}", jinfo.Name); lblEmail.Text = string.Format("{0}", jinfo.Email); lblJuryid.Text = string.Format("{0}", jinfo.Juryid); lblSpecial.Text = string.Format("{0}", jinfo.Specialization); lblMobile.Text = string.Format("{0}", jinfo.Mobile); displaypic.ImageUrl = jinfo.Display; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["juryinfo"] == null) { Response.Redirect("../Default.aspx"); } if (!IsPostBack) { Juryinfo jinfo = (Juryinfo)Session["juryinfo"]; jid = jinfo.Juryid; column_name = jid + "_jury"; if (DateTime.Now > d2) { btnSubmt.Visible = true; lbl.Text = "00:00:00"; } else { Timer1.Enabled = true; } } }
protected void juryloginbtn_Click(object sender, EventArgs e) { string query = string.Format("select count(*) from Jury where Email='" + jemail.Text.Trim() + "' OR Juryid='" + jemail.Text.Trim() + "'"); string query1 = string.Format("select count(*) from Jury where ( Email='" + jemail.Text.Trim() + "' OR Juryid='" + jemail.Text.Trim() + "') and Password='******'"); try { using (con = new SqlConnection(constr)) { if (con.State != ConnectionState.Open) { con.Open(); } using (cmd = new SqlCommand(query, con)) { int count = (int)cmd.ExecuteScalar(); if (count == 0) { juryloginmsg.Text = "Jury does not exists."; } else { bool status = false; using (cmd = new SqlCommand(query1, con)) { count = (int)cmd.ExecuteScalar(); if (count == 0) { juryloginmsg.Text = "JuryID and Password is not matching."; } else { //code for after successfull login string query2 = string.Format("select * from Jury where ( Email='" + jemail.Text.Trim() + "' OR Juryid='" + jemail.Text.Trim() + "') and Password='******'"); cmd.CommandText = query2; SqlDataReader read = cmd.ExecuteReader(); if (read.HasRows) { read.Read(); Juryinfo jinfo = new Juryinfo(read.GetString(1), read.GetString(2), read.GetString(3), read.GetString(4), read.GetString(5), read.GetString(6), read.GetString(7)); Session["juryinfo"] = jinfo; status = true; } read.Close(); read.Dispose(); } } if (status) { Response.Redirect("jury/Home.aspx"); } } } } } catch (Exception ee) { juryloginmsg.Text = ee.Message; } finally { if (con.State != ConnectionState.Closed) { con.Close(); } } }
protected void btnSubmt_Click(object sender, EventArgs e) { Juryinfo jinfo = (Juryinfo)Session["juryinfo"]; string jid = jinfo.Juryid; string column_name = jid + "_jury"; int c = 0; for (int i = 0; i < Resultview.Rows.Count; i++) { DropDownList dlist = (DropDownList)Resultview.Rows[i].FindControl("rsltDrpdwn"); GridViewRow r = Resultview.Rows[i]; if (dlist.SelectedValue != "") { string qno = r.Cells[0].Text; string uid = r.Cells[5].Text; string res = dlist.SelectedItem.Text; c = Int32.Parse(res); string query = string.Format("Update Webdesigntable set " + column_name + "='{0}' where Qno='{1}' and Userid='{2}' ", c, qno, uid); string query1 = string.Format("Update Webdesigntable set Finalmarks= cast ((jsaurabh2794_jury+sakshirani1413_jury+stmsaurabh94_jury+suchikumari22_jury) as float)/ cast(4 as float) where Qno='{0}' and Userid='{1}' ", qno, uid); try { using (con = new SqlConnection(constr)) { if (con.State != ConnectionState.Open) { con.Open(); } using (cmd = new SqlCommand(query, con)) { cmd.ExecuteNonQuery(); f = 1; cmd.CommandText = query1; cmd.ExecuteNonQuery(); } } }catch (Exception ee) { lblmsg.Text = ee.Message; } finally{ con.Close(); } } } if (f == 1) { string message = "Successfully Submitted or Updated."; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("<script type = 'text/javascript'>"); sb.Append("window.onload=function(){"); sb.Append("alert('"); sb.Append(message); sb.Append("')};"); sb.Append("</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString()); Response.AppendHeader("Refresh", "1;url=jwebdesign.aspx"); } else { lblmsg.Text = "You have not assigned any result to the participant. "; } }
protected void chnge_Click(object sender, EventArgs e) { Juryinfo jinfo = (Juryinfo)Session["juryinfo"]; if (imageupload.HasFile) { string ext = Path.GetExtension(imageupload.PostedFile.FileName); if (ext.ToLower() == ".jpg" || ext.ToLower() == ".jpeg" || ext.ToLower() == ".png") { string fileName = Path.GetFileName(imageupload.PostedFile.FileName); string concat = jinfo.Juryid + "_"; string newfilename = concat + fileName; //imageupload.SaveAs(Server.MapPath + "~/displaypic/"); imageupload.SaveAs(Request.PhysicalApplicationPath + "/displaypic/" + newfilename); string imageSrc = "../displaypic/" + concat + imageupload.PostedFile.FileName; displaypic.ImageUrl = imageSrc; // string query = string.Format("insert into Imagetable (Userid,Imageurl) values ('{0}','{1}')",uf.Userid,imageSrc); // string query1 = string.Format("select count(*) from Imagetable where Userid='{0}'", uf.Userid); string query2 = string.Format("update Jury set Display='{0}' where Juryid='{1}'", imageSrc, jinfo.Juryid); try { using (con = new SqlConnection(constr)) { if (con.State != ConnectionState.Open) { con.Open(); } using (cmd = new SqlCommand(query2, con)) { cmd.ExecuteNonQuery(); jinfo.Display = imageSrc; Session["userinfo"] = jinfo; string message = "Successfully changed."; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("<script type = 'text/javascript'>"); sb.Append("window.onload=function(){"); sb.Append("alert('"); sb.Append(message); sb.Append("')};"); sb.Append("</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString()); Response.AppendHeader("Refresh", "1;url=jprofile.aspx"); } } } catch (Exception ee) { } finally { con.Close(); } // Response.AppendHeader("Refresh", "1;url=profile.aspx"); } else { //string message = "Only jpg,jpeg and png is supported."; //System.Text.StringBuilder sb = new System.Text.StringBuilder(); //sb.Append("<script type = 'text/javascript'>"); //sb.Append("window.onload=function(){"); //sb.Append("alert('"); //sb.Append(message); //sb.Append("')};"); //sb.Append("</script>"); //ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString()); } } }
protected void update_Click(object sender, EventArgs e) { if (Page.IsValid) { Juryinfo jinfo = (Juryinfo)Session["juryinfo"]; string updateinfo = string.Format("update Jury set Name='{0}',Email='{1}',Mobile='{2}' where Juryid='{3}'", Name.Text, email.Text.Trim(), Mob.Text.Trim(), jinfo.Juryid); string emailcheck = string.Format("select count(*) from Jury where Email='{0}'", email.Text.Trim()); try { using (con = new SqlConnection(constr)) { if (con.State != ConnectionState.Open) { con.Open(); } using (cmd = new SqlCommand(emailcheck, con)) { int count = (int)cmd.ExecuteScalar(); if (count > 0) { profilechange.Text = "This email is already associated with other user"; } else { cmd.CommandText = updateinfo; count = (int)cmd.ExecuteNonQuery(); if (count > 0) { jinfo.Name = Name.Text; jinfo.Email = email.Text.Trim(); jinfo.Mobile = Mob.Text.Trim(); Session["juryinfo"] = jinfo; string message = "Successfully updated."; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("<script type = 'text/javascript'>"); sb.Append("window.onload=function(){"); sb.Append("alert('"); sb.Append(message); sb.Append("')};"); sb.Append("</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString()); Response.AppendHeader("Refresh", "1;url=jprofile.aspx"); } else { profilechange.Text = "Some error occured.please try later."; } } } } } catch (Exception ee) { profilechange.Text = ee.Message; } finally { if (con.State != ConnectionState.Closed) { con.Close(); } } } }