protected void Button3_Click(object sender, EventArgs e)
{
return_ r = new return_();
if (r.bal_("email", reset_email.Value, 4).Equals("none"))
{
Panel1.Visible = true;
Label2.Text = "Email Address doesnot exists. ";
Panel2.Visible = false;
}
else
{
maill mai = new maill();
string pass = mai.send_maill("", reset_email.Value, "Your password is ", 2);
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cnstring"].ToString();
cn.Open();
string str12 = "update signup set pass ='******' where email='" + reset_email.Value + "' ";
SqlCommand cmd = new SqlCommand(str12, cn);
cmd.ExecuteNonQuery();
cn.Close();
Panel2.Visible = true;
Label3.Text = "Password has been sent to " + reset_email.Value;;
Panel1.Visible = false;
}
}
public transaction(string sid, string tran_mess, int status)
{
try
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cnstring"].ToString();
cn.Open();
maill mailll = new maill();
String s = "insert into trans values(@sid,@tran_mess,@tran_date,@status)";
SqlCommand cmd = new SqlCommand(s, cn);
SqlParameter p = new SqlParameter("sid", sid);
SqlParameter p1 = new SqlParameter("tran_mess", tran_mess);
SqlParameter p2 = new SqlParameter("tran_date", DateTime.Now.Date.ToString("yyyy-MM-dd"));
SqlParameter p3 = new SqlParameter("status", status);
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
}
catch (Exception ew)
{
HttpContext.Current.Response.Write(ew.Message);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cnstring"].ToString();
cn.Open();
maill mailll = new maill();
String s = "insert into signup values(@name,@email,@pno,@unid,@pass,@wallet)";
SqlCommand cmd = new SqlCommand(s, cn);
SqlParameter p = new SqlParameter("name", name.Value);
SqlParameter p1 = new SqlParameter("email", email_register.Value);
SqlParameter p2 = new SqlParameter("pno", pno.Value);
string unid = "UNID" + mailll.unid();
SqlParameter p3 = new SqlParameter("unid", unid);
string passsss = mailll.send_maill(name.Value, email_register.Value, "Unique ID -" + unid, 1);
Label4.Text = passsss;
SqlParameter p4 = new SqlParameter("pass", passsss);
SqlParameter p5 = new SqlParameter("wallet", 50);
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.Parameters.Add(p5);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
name.Value = "";
email_register.Value = "";
pno.Value = "";
Panel1.Visible = false;
Label3.Text = "You have been registered.";
Panel2.Visible = true;
}
catch (Exception ew)
{
Label2.Text = "Email Address or Phone Number already exists.";
Panel1.Visible = true;
Panel2.Visible = false;
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
maill m = new maill();
string stt = m.send_maill(name1.Value, email1.Value, Message1.Value, 4);
if (stt == "done")
{
Label2.Text = "Information has been sent";
}
else
{
Label2.Text = "Connection Problem";
}
name1.Value = ""; email1.Value = ""; Message1.Value = "";
Panel1.Visible = true;
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cnstring"].ToString();
cn.Open();
maill mailll = new maill();
string code_co = mailll.passw();
String s = "insert into coupons values(@compid,@discount,@cocode,@limit)";
SqlCommand cmd = new SqlCommand(s, cn);
SqlParameter p = new SqlParameter("compid", Session["id"].ToString());
SqlParameter p1 = new SqlParameter("discount", discount.Value);
SqlParameter p2 = new SqlParameter("cocode", code_co);
SqlParameter p3 = new SqlParameter("limit", '0');
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
discount.Value = "";
Panel1.Visible = false;
Label2.Text = "coupon code : " + code_co;
Panel2.Visible = true;
}
catch (Exception ew)
{
Panel1.Visible = true;
Label1.Text = ew.Message;
Panel2.Visible = false;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cnstring"].ToString();
cn.Open();
maill mailll = new maill();
String s = "insert into banker values(@accno,@pass,@bal,@bname)";
SqlCommand cmd = new SqlCommand(s, cn);
SqlParameter p = new SqlParameter("accno", Number1.Value);
SqlParameter p1 = new SqlParameter("pass", pass.Value);
SqlParameter p2 = new SqlParameter("bal", amount.Value);
SqlParameter p3 = new SqlParameter("bname", Number2.Value);
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.ExecuteNonQuery();
cmd.Dispose();
cn.Close();
Number1.Value = "";
Number2.Value = "";
pass.Value = "";
amount.Value = "";
Panel1.Visible = false;
Panel2.Visible = true;
}
catch (Exception ew)
{
Panel1.Visible = true;
Panel2.Visible = false;
}
}
