protected void Update_Click(object sender, EventArgs e) { try { //Response.Write("<script>alert('" + MDegree.Value + " and " + Address.Value + "');</script>"); SqlConnection con = new SqlConnection(strcon); if (con.State == ConnectionState.Closed) { con.Open(); } // Response.Write("<script>alert('" + password1.Value + " and " + password2.Value + "');</script>"); if (password1.Value.Trim() == password2.Value.Trim()) { string str = "", gender, user_job; string date = DateTime.Now.ToString("yyyyMMddHHmmss"); for (int i = 0; i < CheckBoxList1.Items.Count; i++) { if (CheckBoxList1.Items[i].Selected == true) { str += CheckBoxList1.Items[i].Value + ","; } } if (Male.Checked) { gender = "Male"; } else { gender = "Female"; } if (Profile_img.HasFile) { String fileExtension1 = System.IO.Path.GetExtension(Profile_img.FileName); if (fileExtension1.ToLower() != ".img" && fileExtension1.ToLower() != ".jpg" && fileExtension1.ToLower() != ".jpeg") { Response.Write("<script>alert('Please Select valid Profile Pic');</script>"); return; } else { Session["profile_pic"] = date + Profile_img.FileName; Profile_img.SaveAs(Server.MapPath("~/portfolio/uploads/Profile Pics/" + date + Profile_img.FileName)); } } if (Resume.HasFile) { String fileExtension2 = System.IO.Path.GetExtension(Resume.FileName); if (fileExtension2.ToLower() != ".pdf" && fileExtension2.ToLower() != ".doc" && fileExtension2.ToLower() != ".docx") { Response.Write("<script>alert('Please Select valid Resume ');</script>"); return; } else { Session["resume"] = date + Resume.FileName; Resume.SaveAs(Server.MapPath("~/portfolio/uploads/Resume/" + date + Resume.FileName)); } } user_job = Request.Form["user_job"]; //Response.Write("<script>alert('" + user_job + "')</script>"); SqlCommand cmd = new SqlCommand("update Persons set name=@name,gender=@gender,DOB=@DOB,job_role=@job_role,password=@password,about=@about," + "website=@website,skills=@skills,profile_pic=@profile_pic,resume=@resume,address=@address,phone=@phone where email=@email", con); cmd.Parameters.AddWithValue("@email", mail.Value); cmd.Parameters.AddWithValue("@name", name.Value); cmd.Parameters.AddWithValue("@gender", gender); cmd.Parameters.AddWithValue("@DOB", dob.Value); cmd.Parameters.AddWithValue("@job_role", user_job); cmd.Parameters.AddWithValue("@password", password1.Value); cmd.Parameters.AddWithValue("@about", about.Value); cmd.Parameters.AddWithValue("@website", website.Value); cmd.Parameters.AddWithValue("@skills", str); cmd.Parameters.AddWithValue("@profile_pic", Session["profile_pic"].ToString()); cmd.Parameters.AddWithValue("@resume", Session["resume"].ToString()); cmd.Parameters.AddWithValue("@address", Address.Value); cmd.Parameters.AddWithValue("@phone", phone.Value); int r = cmd.ExecuteNonQuery(); //Response.Write("<script>alert('person=" + r + "')</script>"); cmd.CommandText = "delete from work_exp where email='" + mail.Value + "'"; r = cmd.ExecuteNonQuery(); //Response.Write("<script>alert('Deleted work =" + r + "')</script>"); cmd.CommandText = "delete from master_degree where email='" + mail.Value + "'"; r = cmd.ExecuteNonQuery(); //Response.Write("<script>alert('Deleted Master =" + r + "')</script>"); cmd.CommandText = "delete from bachelor_degree where email='" + mail.Value + "'"; r = cmd.ExecuteNonQuery(); //Response.Write("<script>alert('Deleted bachelor =" + r + "')</script>"); cmd.CommandText = "delete from junior_college where email='" + mail.Value + "'"; r = cmd.ExecuteNonQuery(); //Response.Write("<script>alert('Deleted college =" + r + "')</script>"); if (role1.Value != "" && duration1.Value != "" && company1.Value != "" && job1.Value != "") { cmd.CommandText = "insert into work_exp (email,role,company,job_info,duration) VALUES" + "(@email1,@role1,@company1,@job_info1,@duration1)"; cmd.Parameters.AddWithValue("@email1", mail.Value); cmd.Parameters.AddWithValue("@role1", role1.Value); cmd.Parameters.AddWithValue("@company1", company1.Value); cmd.Parameters.AddWithValue("@job_info1", job1.Value); cmd.Parameters.AddWithValue("@duration1", duration1.Value); r = cmd.ExecuteNonQuery(); // Response.Write("<script>alert('work 1 =" + r + "')</script>"); } if (role2.Value != "" && duration2.Value != "" && company2.Value != "" && job2.Value != "") { cmd.CommandText = "insert into work_exp(email, role, company, job_info, duration) VALUES" + "(@email2,@role2,@company2,@job_info2,@duration2)"; cmd.Parameters.AddWithValue("@email2", mail.Value); cmd.Parameters.AddWithValue("@role2", role2.Value); cmd.Parameters.AddWithValue("@company2", company2.Value); cmd.Parameters.AddWithValue("@job_info2", job2.Value); cmd.Parameters.AddWithValue("@duration2", duration2.Value); r = cmd.ExecuteNonQuery(); //Response.Write("<script>alert('work 2=" + r + "')</script>"); } if (role3.Value != "" && duration3.Value != "" && company3.Value != "" && job3.Value != "") { cmd.CommandText = "insert into work_exp (email,role,company,job_info,duration) VALUES" + "(@email3,@role3,@company3,@job_info3,@duration3)"; cmd.Parameters.AddWithValue("@email3", mail.Value); cmd.Parameters.AddWithValue("@role3", role3.Value); cmd.Parameters.AddWithValue("@company3", company3.Value); cmd.Parameters.AddWithValue("@job_info3", job3.Value); cmd.Parameters.AddWithValue("@duration3", duration3.Value); r = cmd.ExecuteNonQuery(); //Response.Write("<script>alert('work 3=" + r + "')</script>"); } if (MDegree.Value != "" && MDuration.Value != "" && MCollege.Value != "") { cmd.CommandText = "insert into master_degree (email,mdegree,duration,college) VALUES" + "(@email4,@degree1,@Mduration,@college1)"; cmd.Parameters.AddWithValue("@email4", mail.Value); cmd.Parameters.AddWithValue("@degree1", MDegree.Value); cmd.Parameters.AddWithValue("@Mduration", MDuration.Value); cmd.Parameters.AddWithValue("@college1", MCollege.Value); r = cmd.ExecuteNonQuery(); // Response.Write("<script>alert('inserted Master =" + r + "')</script>"); } if (Bdegree.Value != "" && BDuration.Value != "" && BCollege.Value != "") { cmd.CommandText = "insert into bachelor_degree (email,bdegree,duration,college) VALUES" + "(@email5,@degree2,@Bduration,@college2)"; cmd.Parameters.AddWithValue("@email5", mail.Value); cmd.Parameters.AddWithValue("@degree2", Bdegree.Value); cmd.Parameters.AddWithValue("@Bduration", BDuration.Value); cmd.Parameters.AddWithValue("@college2", BCollege.Value); r = cmd.ExecuteNonQuery(); // Response.Write("<script>alert('bachelor=" + r + "')</script>"); } if (JCStream.Value != "" && JCDuration.Value != "" && JCCollege.Value != "") { cmd.CommandText = "insert into junior_college (email,stream,duration,college) VALUES" + "(@email6,@stream,@Jduration,@college3)"; cmd.Parameters.AddWithValue("@email6", mail.Value); cmd.Parameters.AddWithValue("@stream", JCStream.Value); cmd.Parameters.AddWithValue("@Jduration", JCDuration.Value); cmd.Parameters.AddWithValue("@college3", JCCollege.Value); r = cmd.ExecuteNonQuery(); //Response.Write("<script>alert('junior=" + r + "')</script>"); } con.Close(); Session.Clear(); Session.Add("email", mail.Value); Session.Add("pwd", password1.Value); //Response.Write("<script>alert('Sign Up Successfull!!')</script>"); Response.Write("<script language='javascript'>window.alert('Information Updated!!');window.location='/portfolio/homepage.aspx';</script>"); //Response.Redirect("/portfolio/homepage.aspx"); } else { Response.Write("<script>alert('Password are not same!!')</script>"); } } catch (Exception) { throw; } }
protected void signup_Click(object sender, EventArgs e) { // Response.Write("<script>alert('WALLA');</script>"); try { if (password1.Value == password2.Value) { string date = DateTime.Now.ToString("yyyyMMddHHmmss"); SqlConnection con = new SqlConnection(strcon); if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("select count(*) from persons where email='" + mail.Value + "';", con); int rc = (int)cmd.ExecuteScalar(); if (rc == 1) { Response.Write("<script>alert('E-mail already Exists.Please Select another E-mail ID or try Logging in.');</script>"); } else { if (Profile_img.HasFile && Resume.HasFile) { String fileExtension1 = System.IO.Path.GetExtension(Profile_img.FileName); String fileExtension2 = System.IO.Path.GetExtension(Resume.FileName); if ((fileExtension1.ToLower() != ".img" && fileExtension1.ToLower() != ".jpg" && fileExtension1.ToLower() != ".jpeg") || (fileExtension2.ToLower() != ".pdf" && fileExtension2.ToLower() != ".doc" && fileExtension2.ToLower() != ".docx")) { Response.Write("<script>alert('Please Select valid Resume and Profile Pic');</script>"); } else { string str = "", gender, user_job; for (int i = 0; i < CheckBoxList1.Items.Count; i++) { if (CheckBoxList1.Items[i].Selected == true) { str += CheckBoxList1.Items[i].Value + ","; } } if (Male.Checked) { gender = "Male"; } else { gender = "Female"; } user_job = Request.Form["user_job"]; //Response.Write("<script>alert('" + user_job + "')</script>"); cmd.CommandText = "insert into Persons (email,name,gender,DOB,job_role,password,about,website,skills,profile_pic,resume,address,phone) VALUES" + "(@email,@name,@gender,@DOB,@job_role,@password,@about,@website,@skills,@profile_pic,@resume,@address,@phone)"; cmd.Parameters.AddWithValue("@email", mail.Value); cmd.Parameters.AddWithValue("@name", name.Value); cmd.Parameters.AddWithValue("@gender", gender); cmd.Parameters.AddWithValue("@DOB", dob.Value); cmd.Parameters.AddWithValue("@job_role", user_job); cmd.Parameters.AddWithValue("@password", password1.Value); cmd.Parameters.AddWithValue("@about", about.Value); cmd.Parameters.AddWithValue("@website", website.Value); cmd.Parameters.AddWithValue("@skills", str); cmd.Parameters.AddWithValue("@profile_pic", date + Profile_img.FileName); cmd.Parameters.AddWithValue("@resume", date + Resume.FileName); cmd.Parameters.AddWithValue("@address", Address.Value); cmd.Parameters.AddWithValue("@phone", phone.Value); cmd.ExecuteNonQuery(); if (role1.Value != "" && duration1.Value != "" && company1.Value != "" && job1.Value != "") { cmd.CommandText = "insert into work_exp (email,role,company,job_info,duration) VALUES" + "(@email1,@role1,@company1,@job_info1,@duration1)"; cmd.Parameters.AddWithValue("@email1", mail.Value); cmd.Parameters.AddWithValue("@role1", role1.Value); cmd.Parameters.AddWithValue("@company1", company1.Value); cmd.Parameters.AddWithValue("@job_info1", job1.Value); cmd.Parameters.AddWithValue("@duration1", duration1.Value); cmd.ExecuteNonQuery(); } if (role2.Value != "" && duration2.Value != "" && company2.Value != "" && job2.Value != "") { cmd.CommandText = "insert into work_exp (email,role,company,job_info,duration) VALUES" + "(@email2,@role2,@company2,@job_info2,@duration2)"; cmd.Parameters.AddWithValue("@email2", mail.Value); cmd.Parameters.AddWithValue("@role2", role2.Value); cmd.Parameters.AddWithValue("@company2", company2.Value); cmd.Parameters.AddWithValue("@job_info2", job2.Value); cmd.Parameters.AddWithValue("@duration2", duration2.Value); cmd.ExecuteNonQuery(); } if (role3.Value != "" && duration3.Value != "" && company3.Value != "" && job3.Value != "") { cmd.CommandText = "insert into work_exp (email,role,company,job_info,duration) VALUES" + "(@email3,@role3,@company3,@job_info3,@duration3)"; cmd.Parameters.AddWithValue("@email3", mail.Value); cmd.Parameters.AddWithValue("@role3", role3.Value); cmd.Parameters.AddWithValue("@company3", company3.Value); cmd.Parameters.AddWithValue("@job_info3", job3.Value); cmd.Parameters.AddWithValue("@duration3", duration3.Value); cmd.ExecuteNonQuery(); } if (MDegree.Value != "" && MDuration.Value != "" && MCollege.Value != "") { cmd.CommandText = "insert into master_degree (email,mdegree,duration,college) VALUES" + "(@email4,@degree1,@Mduration,@college1)"; cmd.Parameters.AddWithValue("@email4", mail.Value); cmd.Parameters.AddWithValue("@degree1", MDegree.Value); cmd.Parameters.AddWithValue("@Mduration", MDuration.Value); cmd.Parameters.AddWithValue("@college1", MCollege.Value); cmd.ExecuteNonQuery(); } if (Bdegree.Value != "" && BDuration.Value != "" && BCollege.Value != "") { cmd.CommandText = "insert into bachelor_degree (email,bdegree,duration,college) VALUES" + "(@email5,@degree2,@Bduration,@college2)"; cmd.Parameters.AddWithValue("@email5", mail.Value); cmd.Parameters.AddWithValue("@degree2", Bdegree.Value); cmd.Parameters.AddWithValue("@Bduration", BDuration.Value); cmd.Parameters.AddWithValue("@college2", BCollege.Value); cmd.ExecuteNonQuery(); } if (JCStream.Value != "" && JCDuration.Value != "" && JCCollege.Value != "") { cmd.CommandText = "insert into junior_college (email,stream,duration,college) VALUES" + "(@email6,@stream,@Jduration,@college3)"; cmd.Parameters.AddWithValue("@email6", mail.Value); cmd.Parameters.AddWithValue("@stream", JCStream.Value); cmd.Parameters.AddWithValue("@Jduration", JCDuration.Value); cmd.Parameters.AddWithValue("@college3", JCCollege.Value); cmd.ExecuteNonQuery(); } con.Close(); Session.Add("email", mail.Value); Session.Add("pwd", password1.Value); Profile_img.SaveAs(Server.MapPath("~/portfolio/uploads/Profile Pics/" + date + Profile_img.FileName)); Resume.SaveAs(Server.MapPath("~/portfolio/uploads/Resume/" + date + Resume.FileName)); //Response.Write("<script>alert('Sign Up Successfull!!')</script>"); Response.Write("<script language='javascript'>window.alert('Sign Up Successfull!!');window.location='/portfolio/homepage.aspx';</script>"); //Response.Redirect("/portfolio/homepage.aspx"); } } else { Response.Write("<script>alert('Please Select ProFile Image and Resume!!')</script>"); } } } else { Response.Write("<script>alert('Password are not same!!')</script>"); } } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "');</script>"); throw; } }