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();
}
}
}
}
