public List <clsregistrationprp> find_rec(Int32 regid) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("findreg", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@regid", SqlDbType.Int).Value = regid; SqlDataReader dr = cmd.ExecuteReader(); List <clsregistrationprp> obj = new List <clsregistrationprp>(); if (dr.HasRows) { dr.Read(); clsregistrationprp k = new clsregistrationprp(); k.regid = Convert.ToInt32(dr[0]); k.email = dr[1].ToString(); k.password = dr[5].ToString(); k.contact = dr[6].ToString(); k.f_name = dr[2].ToString(); k.l_name = dr[3].ToString(); k.address = dr[4].ToString(); obj.Add(k); } dr.Close(); cmd.Dispose(); con.Close(); return(obj); }
protected void Button1_Click(object sender, EventArgs e) { myad.clsregister obj = new myad.clsregister(); myad.clsregistrationprp objprp = new myad.clsregistrationprp(); objprp.email = txtemail.Text; objprp.f_name = txtf_name.Text; objprp.l_name = txtl_name.Text; objprp.address = txtaddress.Text; objprp.password = txtpassword.Text; objprp.contact = countrycod.Text + "-" + contact.Text; objprp.verified = "Unverified"; objprp.join_date = DateTime.Now; getguid(); objprp.guid = id; try { obj.save_rec(objprp); SendMail(txtemail.Text); txtemail.Text = string.Empty; txtf_name.Text = string.Empty; txtl_name.Text = string.Empty; txtaddress.Text = string.Empty; contact.Text = string.Empty; id = ""; Label1.Visible = true; Label1.Text = "A verification link has been sent to your email."; } catch (Exception exp) { //Label2.Visible = true; //Label2.Text = "Email Id already registered."; } }
public List <clsregistrationprp> disp_rec() { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("dispreg", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = cmd.ExecuteReader(); List <clsregistrationprp> obj = new List <clsregistrationprp>(); while (dr.Read()) { clsregistrationprp k = new clsregistrationprp(); k.regid = Convert.ToInt32(dr[0]); k.email = dr[1].ToString(); k.password = dr[2].ToString(); k.f_name = dr[3].ToString(); k.l_name = dr[4].ToString(); k.address = dr[5].ToString(); obj.Add(k); } dr.Close(); cmd.Dispose(); con.Close(); return(obj); }
public void delete_rec(clsregistrationprp p) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("delreg", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@regid", SqlDbType.Int).Value = p.regid; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
protected void Button1_Click(object sender, EventArgs e) { myad.clsregister obj = new myad.clsregister(); myad.clsregistrationprp objprp = new myad.clsregistrationprp(); objprp.email = txtemail.Text; objprp.f_name = txtf_name.Text; objprp.l_name = txtl_name.Text; objprp.address = txtaddress.Text; objprp.password = txtpassword.Text; objprp.contact = countrycod.Text + "-" + contact.Text; objprp.verified = "Unverified"; objprp.join_date = DateTime.Now; getguid(); objprp.guid = guid; try { obj.save_rec(objprp); try { CreateMail(); txtemail.Text = String.Empty; txtf_name.Text = String.Empty; txtl_name.Text = String.Empty; txtaddress.Text = String.Empty; contact.Text = String.Empty; guid = String.Empty; success.Visible = true; success.Text = "A verification link has been sent to your email."; } catch (System.Net.Mail.SmtpException ob) { error.Visible = true; error.Text = "Network Error!!Check your connectivity!"; Debug.Write("exp parul " + ob); } } catch (Exception exp) { error.Visible = true; error.Text = "Email Id already registered."; } }
public Int32 logincheck(clsregistrationprp p) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("logincheck", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@email", SqlDbType.VarChar, 100).Value = p.email; cmd.Parameters.Add("@password", SqlDbType.VarChar, 100).Value = p.password; cmd.Parameters.Add("@cod", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); Int32 a = Convert.ToInt32(cmd.Parameters["@cod"].Value); cmd.Dispose(); con.Close(); return(a); }
public void update_rec(clsregistrationprp p) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("updreg", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@regid", SqlDbType.Int).Value = p.regid; cmd.Parameters.Add("@f_name", SqlDbType.VarChar, 50).Value = p.f_name; cmd.Parameters.Add("@l_name", SqlDbType.VarChar, 50).Value = p.l_name; cmd.Parameters.Add("@contact", SqlDbType.VarChar, 20).Value = p.contact; cmd.Parameters.Add("@address", SqlDbType.VarChar, 50).Value = p.address; cmd.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = p.email; cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = p.password; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
public void save_rec(clsregistrationprp p) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("insreg", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = p.email; cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = p.password; cmd.Parameters.Add("@f_name", SqlDbType.VarChar, 50).Value = p.f_name; cmd.Parameters.Add("@l_name", SqlDbType.VarChar, 50).Value = p.l_name; cmd.Parameters.Add("@contact", SqlDbType.VarChar, 20).Value = p.contact; cmd.Parameters.Add("@address", SqlDbType.VarChar, 50).Value = p.address; cmd.Parameters.Add("@guid", SqlDbType.VarChar, 100).Value = p.guid; cmd.Parameters.Add("@verified", SqlDbType.VarChar, 50).Value = p.verified; cmd.Parameters.Add("@join_date", SqlDbType.DateTime).Value = p.join_date; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }