protected void Button3_Click(object sender, EventArgs e) { if (TextBox2.Text == TextBox3.Text) { string connectionString = WebConfigurationManager.ConnectionStrings["Salary"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); Login = TextBox1.Text; Password = Encrypt_Service.Encrypt(TextBox2.Text); SqlCommand command = new SqlCommand($"INSERT INTO Users VALUES ('{Login}', '{Password}')", connection); using (connection) { connection.Open(); try { var res = command.ExecuteNonQuery(); HttpCookie cookie = new HttpCookie("Login", Login); Response.Cookies.Add(cookie); Response.Redirect("Default.aspx"); } catch (SqlException ex) { Label2.Text = "This login exist"; } } } else { Label2.Text = "Try again"; } }
protected void Button1_Click(object sender, EventArgs e) { string connectionString = WebConfigurationManager.ConnectionStrings["Salary"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); Login = inputLogin.Text; Password = Encrypt_Service.Encrypt(inputPassword.Text); SqlCommand command = new SqlCommand($"select dbo.LogIn('{Login}', '{Password}')", connection); using (connection) { connection.Open(); object res = command.ExecuteScalar(); if (Convert.ToBoolean(res)) { HttpCookie cookie = new HttpCookie("Login", Login); Response.Cookies.Add(cookie); Response.Redirect("Default.aspx"); } else { Label1.Text = "Try again"; Label1.ForeColor = Color.Red; } } }