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();
}