protected void LogIn(object sender, EventArgs e) { if (IsValid) { // Validate the user password //var manager = new UserManager(); //ApplicationUser user = manager.Find(UserName.Text, Password.Text); //if (user != null) //{ // IdentityHelper.SignIn(manager, user, RememberMe.Checked); // IdentityHelper.RedirectToReturnUrl(Request.QueryString["ReturnUrl"], Response); //} if (UserName.Text != null) { DataAdapter da = new DataAdapter(); DataSet userSet=da.ExecuteSelectQuery("Select * from Users where UserArchived=0 and UserToken='"+UserName.Text.Replace("'","''")+"'"); if(userSet!=null && userSet.Tables.Count>0 && userSet.Tables[0].Rows.Count > 0) { da.ExecuteUpdateQuery("Update Users set UserLastLoggedIn=GETDATE() where UserToken='" + UserName.Text.Replace("'", "''") + "'"); DataTable userTable = userSet.Tables[0]; Session["UserToken"]=userTable.Rows[0]["UserId"]; IdentityHelper.RedirectToReturnUrl(Request.QueryString["ReturnUrl"], Response); } } else { FailureText.Text = "Invalid code"; ErrorMessage.Visible = true; } } }