protected void btnlogin_Click(object sender, ImageClickEventArgs e) { DBManager dm = new DBManager(); EnCryptionManager em = new EnCryptionManager(); string epass = em.encryptmydata(txtpass.Text); string cmd = "Select *from Login where userid='" + txtUID.Text + "' and pass='******' and status=true"; DataTable dt = dm.ExecuteMySelect(cmd); if (dt.Rows.Count > 0) { cmd = "update Login set Lcount=(Lcount+1),LoginTime='" + DateTime.Now.ToString() + "' where userid='" + txtUID.Text + "' and pass='******'"; bool x = dm.ExecuteMyINsertUpdateOrDelete(cmd); if (x == true) { Session["userid"] = txtUID.Text; Response.Redirect("~/Consumer Zone/Home.aspx"); } else { Response.Write("<script>alert('Unable to login!');</script>"); } } else { Response.Write("<script>alert('Invalid UserID or Password.');</script>"); } }
protected void btnSubmit_Click(object sender, EventArgs e) { string gender = ""; if (rdbmale.Checked == true) { gender = "male"; } else { gender = "female"; } if (txtcaptcha.Text == ccode) { DBManager dm = new DBManager(); string code = "select * from Login where UserID='" + txtEmail.Text + "' "; DataTable dt = dm.ExecuteMySelect(code); if (dt.Rows.Count > 0) { Response.Write("<script>alert('Email ID already REGISTERED!');</script>"); txtEmail.Text = ""; } else { string epass; EnCryptionManager em = new EnCryptionManager(); epass = em.encryptmydata(txtpass.Text); string mycommand = "Insert into Registration(ConType,UName,Gender,MobileNo,EmailId,Address,ProfilePic,Pass,RegDT,secquestion,secanswer) values('" + ddlcontype.SelectedValue + "','" + txtname.Text + "','" + gender + "','" + txtMoNo.Text + "','" + txtEmail.Text + "','" + txtaddress.Text + "','" + FuPicture.FileName + "','" + epass + "','" + DateTime.Now.ToString() + "','" + ddlsecurequest.SelectedValue + "','" + txtAnswer.Text + "')"; bool b = dm.ExecuteMyINsertUpdateOrDelete(mycommand); if (b == true) { mycommand = "Insert into Login values('" + txtEmail.Text + "','" + epass + "',1,0,'')"; b = dm.ExecuteMyINsertUpdateOrDelete(mycommand); if (b == true) { FuPicture.SaveAs(Server.MapPath("~/UserPics/" + FuPicture.FileName)); string cmd = "select CustomerId from Registration where EmailId='" + txtEmail.Text + "'"; DataTable d = dm.ExecuteMySelect(cmd); string s = d.Rows[0][0].ToString(); msgbox("You are registered successfully. Your Customer Id is: " + s + " Please note it successfully."); txtaddress.Text = ""; txtAnswer.Text = ""; txtcaptcha.Text = ""; txtconpass.Text = ""; txtEmail.Text = ""; txtMoNo.Text = ""; txtname.Text = ""; txtpass.Text = ""; } else { Response.Write("<script>alert('Your registration failed.')</script>"); } } } } }
protected void BtnChange_Click(object sender, EventArgs e) { EnCryptionManager em = new EnCryptionManager(); string ecurpass = em.encryptmydata(TxtCurPass.Text); string enewpass = em.encryptmydata(TxtNewPass.Text); string cmd = "Update Login set Pass='******' where userid='" + Session["Userid"].ToString() + "' and pass='******'"; DBManager dm = new DBManager(); bool x = dm.ExecuteMyINsertUpdateOrDelete(cmd); if (x == true) { Response.Write("<script>alert('Password updated successfiully.');</script>"); } else { Response.Write("<script>alert('Unable to update password. your current password in invalid.');</script>"); } }
protected void BtnChange_Click(object sender, EventArgs e) { DBManager dm = new DBManager(); EnCryptionManager em = new EnCryptionManager(); string OldPass = em.encryptmydata(TxtOldPass.Text); string newpass = em.encryptmydata(TxtNewPass.Text); string cm = "Update Login set Pass='******' where pass='******' and userid='" + Session["adminid"] + "'"; bool b = dm.ExecuteMyINsertUpdateOrDelete(cm); if (b == true) { Response.Write("<script>alert('Password updated successfiully.');</script>"); } else { Response.Write("<script>alert(' password not updated.');</script>"); } }
protected void BtnRegister_Click(object sender, EventArgs e) { string gender = ""; if (RdBMale.Checked == true) { gender = "Male"; } else { gender = "Female"; } if (TxtCaptcha.Text == ccode) { string epass; EnCryptionManager em = new EnCryptionManager(); epass = em.EncryptCode(TxtPass.Text); string MyCommand = "Insert into Registration values('" + TxtName.Text + "','" + TxtFName.Text + "','" + gender + "','" + TxtMobNo.Text + "','" + DDLQualification.SelectedValue + "','" + DDLSelectGroup.SelectedValue + "','" + TxtAddress.Text + "','" + TxtEmail.Text + "','" + FUPic.FileName + "','" + epass + "','" + DateTime.Now.ToString() + "')"; DBManager dm = new DBManager(); bool b = dm.ExecuteMyInsertUpdateOrDelete(MyCommand); if (b == true) { MyCommand = "Insert into Login Values('" + TxtEmail.Text + "','" + epass + "',1,0,'')"; b = dm.ExecuteMyInsertUpdateOrDelete(MyCommand); if (b == true) { FUPic.SaveAs(Server.MapPath("~/UserPics/" + FUPic.FileName)); Response.Write("<script>alert('You are Registered Successfully.');</script>"); } else { Response.Write("<script>alert('Unable to set login details.');</script>"); } } else { Response.Write("<script>alert('Sorry! Unable to Register.');</script>"); } } else { Response.Write("<script>alert('Invalid Captcha Code');</script>"); } }
protected void ImageButton3_Click(object sender, ImageClickEventArgs e) { DBManager dm = new DBManager(); EnCryptionManager em = new EnCryptionManager(); String epass = em.EncryptCode(Txtpassword.Text); string cmd = "select *from Login where userid='" + TxtAdminid.Text + "' and pass='******' and status=true"; DataTable dt = dm.ExecuteMySelect(cmd); if (dt.Rows.Count > 0) { cmd = "Update Login set Lcount=(Lcount+1),LoginTime='" + DateTime.Now.ToString() + "' where userid='" + TxtAdminid.Text + "' and pass='******'"; bool x = dm.ExecuteMyInsertUpdateOrDelete(cmd); Session["adminid"] = TxtAdminid.Text; Response.Redirect("~/Admin/AdminHome.aspx"); } else { Response.Write("<script>alert('Invalid userid or password.');</script>"); } }
protected void Button1_Click(object sender, EventArgs e) { DBManager dm = new DBManager(); EnCryptionManager em = new EnCryptionManager(); string code = "select * from Registration where EmailId='" + txtEmail.Text + "' and MobileNo='" + txtphone.Text + "' and secquestion='" + ddlquestion.SelectedValue + "' and secanswer='" + txtsecans.Text + "'"; DataTable dt = dm.ExecuteMySelect(code); if (dt.Rows.Count > 0) { string cmd = "select Pass from Login where userid='" + txtEmail.Text + "'"; DataTable d = dm.ExecuteMySelect(cmd); string s = em.decryptmydata(d.Rows[0][0].ToString()); txtEmail.Text = ""; txtsecans.Text = ""; txtphone.Text = ""; ddlquestion.SelectedIndex = 0; msgbox("Your Password is: " + s); } else { Response.Write("<script>alert('Sorry! Record not found.');</script>"); } }