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