private void EnterUserBtn_Click(object sender, EventArgs e)
{
SqlCommand command;
SqlDataReader dataReader;
String query;
query = "Select * From LoginTable Where Username = '******' and Password = '******' and Type = 'User'";
BookDBConn.Open();
command = new SqlCommand(query, BookDBConn);
dataReader = command.ExecuteReader();
if (dataReader.Read())
{
//Add welcome later
BookStore UserAccess = new BookStore(UsernameText.Text);
this.Hide();
UserAccess.ShowDialog();
this.Show();
}
else
{
MessageBox.Show("Username or Password are not valid!", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
BookDBConn.Close();
}
