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