private void UserLogin(object sender, EventArgs e)
{
var hashedPass = GenerateHash(PasswordTB.Text);
//MessageBox.Show(LibraryDBCon.ServerVersion);
// Open DataBase
if (LibraryDBCon.State == ConnectionState.Closed)
{
LibraryDBCon.Open();
}
// Create Connection With DataBase
sqlcom.Connection = LibraryDBCon;
sqlcom.CommandType = CommandType.Text;
sqlcom.CommandText = $"SELECT FullName FROM Librarians WHERE UserName = '******' AND PassHash = '{hashedPass}'";
SqlDataReader DR = sqlcom.ExecuteReader();
if (DR.Read())
{
// Set The Id To Static To Be Avilabile To The Other Forms
UserName = DR[0].ToString();
DashBoard Admin = new DashBoard();
this.Hide();
// Reset User Name And Password Field
UserNameTB.ResetText();
PasswordTB.ResetText();
if (Admin.ShowDialog() == DialogResult.OK)
{
this.Show();
}
else
{
this.Close();
}
}
else
{
MetroFramework.MetroMessageBox.Show(this, "Worng Name or Password.", "Error Message", 100);
}
// Close Data Reader
DR.Close();
// Close DataBase Connection
if (LibraryDBCon.State == ConnectionState.Open)
{
LibraryDBCon.Close();
}
}
