protected void Page_Load(object sender, EventArgs e) { try { if (Session["uid"] != null) { string strcmd1 = "insert into tblLog (uId,log_type,log_time) values ( '" + Session["uid"] + "','out','" + DateTime.Now + "')"; int i = dbContext.ExecNonQuery(strcmd1); } } catch (Exception ex) { Log.Error(ex); } Session.Clear(); Response.Redirect("login.aspx"); }
protected void Page_Load(object sender, EventArgs e) { try { //check post back event if (!IsPostBack) { resetfail.Visible = false; reset.Visible = false; resetsuccess.Visible = false; string token = dataContext.Datadecrypt(Request.QueryString["tkn"].ToString().Trim()); //check token not empty if (token != null) { //get user details using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString.ToString())) { connection.Open(); string Strcity = "SELECT uId,status FROM tblForgotPassword WHERE token = " + Convert.ToInt32(token); SqlCommand cmd1 = new SqlCommand(Strcity, connection); SqlDataReader dr = cmd1.ExecuteReader(); if (dr.HasRows) { dr.Read(); string ststus = dr.GetValue(1).ToString(); //check status is active if (ststus.Equals("ACTIVE")) { //update to status deactive string str = "update tblForgotPassword set status ='DEACTIVE' where token = " + Convert.ToInt32(token); int i = dbContext.ExecNonQuery(str); if (i > 0) { reset.Visible = true; Session["uid"] = dr.GetValue(0).ToString(); } } else { //if password link is expired print this msg resetfail.Visible = true; reset.Visible = false; resetsuccess.Visible = true; resetfail.InnerText = "Password reset link has been expired."; } } else { //if token is not match print this msg resetfail.Visible = true; reset.Visible = false; resetfail.InnerText = "Invalid User."; } } } else { //if token is null then print this msg resetfail.Visible = true; reset.Visible = false; resetfail.InnerText = "Something went worng. Please try again."; } } } catch (Exception ex) { Log.Error(ex); Session.Clear(); Response.Redirect("~/login.aspx"); } }