private void btnBack_Click(object sender, EventArgs e) { lobbyMA lma = new lobbyMA(); lma.Show(); this.Hide(); }
private void bLogin_Click(object sender, EventArgs e) { var sha1 = System.Security.Cryptography.SHA1.Create(); var inputBytes = Encoding.ASCII.GetBytes(tBPasswd.Text); var hash = sha1.ComputeHash(inputBytes); var sb = new StringBuilder(); for (var i = 0; i < hash.Length; i++) { sb.Append(hash[i].ToString("X2")); } string passWDHash = sb.ToString(); if (attempt == 0) { MessageBox.Show("All 3 attempts have failed"); return; } SqlConnection scn = new SqlConnection(); scn.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\timos\Source\Repos\eBibliothek2\e-Bibliothek\e-Bibliothek\Database1.mdf;Integrated Security=True"; SqlCommand scmd = new SqlCommand("select count (*) as cnt from Mitarbeiter where BenutzerName=@usr and PassWD=@pwd", scn); scmd.Parameters.Clear(); scmd.Parameters.AddWithValue("@usr", tBUserN.Text); scmd.Parameters.AddWithValue("@pwd", passWDHash); scn.Open(); if (scmd.ExecuteScalar().ToString() == "1") { lobbyMA lf = new lobbyMA(); lf.Show(); this.Hide(); } else { MessageBox.Show("YOU ARE NOT GRANTED WITH ACCESS"); MessageBox.Show("You Have Only " + Convert.ToString(attempt) + " Attempt Left To Try"); --attempt; tBUserN.Clear(); tBPasswd.Clear(); } scn.Close(); }