protected void Button1_Click(object sender, EventArgs e) { string rec = Session["fname"].ToString(); string send = Session["uname"].ToString(); string stat = "0"; string dor = System.DateTime.Now.ToString(); validfriend x = new validfriend(); if (x.isinreg(rec)) { if (A.isvalid(send, rec)) { SqlConnection cn = new SqlConnection(); cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString(); SqlCommand cmd = new SqlCommand("select * from friend", cn); DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter(cmd); SqlCommandBuilder cmdb = new SqlCommandBuilder(ad); ad.Fill(ds); DataRow dr = ds.Tables[0].NewRow(); dr[1] = send; dr[2] = rec; dr[3] = stat; dr[4] = dor; ds.Tables[0].Rows.Add(dr); ad.Update(ds); cn.Close(); Response.Redirect("Profile.aspx"); } } }
protected void signup_Click(object sender, EventArgs e) { Email em = new Email(); string gender = string.Empty; string pass = string.Empty; int val = 0; DirectoryInfo d, d1; d = new DirectoryInfo(Server.MapPath("Account") + "//" + email.Value); d.Create(); d1 = new DirectoryInfo(Server.MapPath("Profileimg") + "//" + email.Value); d1.Create(); if (RadioButton1.Checked) { gender = "Male"; } else if (RadioButton2.Checked) { gender = "Female"; } pass = rand1(); if (RadioButton1.Checked == true || RadioButton2.Checked == true) { try { SqlConnection cn = new SqlConnection(); cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString(); cn.Open(); string str = "insert into reg(Name,Dob,Pno,Email,RecEmail,Gender,Status,Pass,PStatus,CoverStatus,Picprivacy,DStatus,MailSecurity) values(@name,@dob,@pno,@email,@recemail,@radio,@val,@pass,@pstatus,@coverstatus,@picprivacy,@dstatus,@mail)"; SqlCommand cmd = new SqlCommand(str, cn); SqlParameter p1 = new SqlParameter("name", name.Value); SqlParameter p2 = new SqlParameter("dob", dob.Text); if (v.ispnoexist(phone.Value)) { alert1.Visible = true; Label2.Text = "OOPs! Phone number already exist"; } else { SqlParameter p3 = new SqlParameter("pno", phone.Value); cmd.Parameters.Add(p3); } if (!v.isinreg(email.Value)) { SqlParameter p4 = new SqlParameter("email", email.Value); cmd.Parameters.Add(p4); } else { alert1.Visible = true; Label2.Text = "OOPs! E-mail address already exist"; } if (email.Value == remail.Value) { alert1.Visible = true; Label2.Text = "OOPs! Recovery E-mail cannot be same as your E-mail address"; } else { SqlParameter p5 = new SqlParameter("recemail", remail.Value); cmd.Parameters.Add(p5); } cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Parameters.AddWithValue("radio", gender); cmd.Parameters.AddWithValue("val", val); cmd.Parameters.AddWithValue("pass", pass); cmd.Parameters.AddWithValue("pstatus", 0); cmd.Parameters.AddWithValue("coverstatus", 0); cmd.Parameters.AddWithValue("picprivacy", val); cmd.Parameters.AddWithValue("dstatus", 0); cmd.Parameters.AddWithValue("mail", 0); cmd.ExecuteNonQuery(); em.send_maill(name.Value, email.Value, 1, pass); cn.Close(); Response.Redirect("login.aspx"); } catch (Exception ex) { } } else { alert1.Visible = true; Label2.Text = "OOPs! Check your details something is missing"; //ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "$('#modal2').modal({ backdrop: 'static' })", true); } }