protected void ManagePosts(object sender, EventArgs e) { if (isCorrectUserLog(LoginAccessMyPosts.Value.Trim(), PassAccessMyPosts.Text.Trim()) == true) { AppUser Usr = new AppUser(LoginAccessMyPosts.Value.Trim(), PassAccessMyPosts.Text.Trim(), AppUser.GetUserId(LoginAccessMyPosts.Value.Trim(), PassAccessMyPosts.Text.Trim())); Session["User"]= Usr; Response.Redirect("MyPosts.aspx"); } }
public static AppUser GetUser(string Log, string Pass) { try { string query = @" BEGIN SELECT [ID] ,[Login] ,[Password] ,[IsValid] ,[Firstname] ,[Name] FROM [dbo].[Users] WHERE Login like @Mail COLLATE French_BIN and Login is not null and Login <>'' and Password like @Pass COLLATE French_BIN and Password is not null and Password <>'' END "; SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["db_SE"].ConnectionString); SqlCommand command = new SqlCommand(query, connection); SqlDataAdapter adapter = new SqlDataAdapter(command); command.CommandTimeout = 0; DataSet result = new DataSet(); result.Locale = CultureInfo.InvariantCulture; command.Parameters.AddWithValue("@Mail", Log.Trim()); command.Parameters.AddWithValue("@Pass", Pass.Trim()); adapter.Fill(result); if (result != null && result.Tables.Count > 0 && result.Tables[0].Rows.Count > 0) { AppUser Usr = new AppUser(Log.Trim(), Pass.Trim(), Convert.ToInt32(result.Tables[0].Rows[0]["ID"])); return Usr; } return null; } catch (Exception ex) { return null; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] != null) { Usr = (AppUser)Session["User"]; if (Login.Value == "") { Pass.Attributes.Add("value", "ThePassword"); } else { Pass.Attributes.Add("value", ""); } ActivatedSession = 1; Login.Value = Usr.Login; } else { ActivatedSession = 0; } string _Login = Request.Params["Lgn"]; string _Pass = Request.Params["Ps"]; if (_Login != null && _Pass != "") { if (AppUser.ValidateUser(_Login, _Pass)) { PnlGoodPost.Visible = false; PnlBadAfterConf.Visible = false; PnlValidMail.Visible = true; PnlAddPost.Visible = false; } } if (!Page.IsPostBack) { Category.LoadCategoriesGen(ddlbCat); Category.LoadCategoriesGen(ddlbCat1); } }