private void btnLogin_Click(object sender, EventArgs e) { try { useDbSql = new UseDatabase.UseDatabase(); useDbSql.ConnectToDB(); sUsername = txtUsername.Text; sPassword = txtPassword.Text; queryString = "SELECT * FROM WORKER WHERE username='******' AND iPassword='******'"; SqlDataReader reader = useDbSql.ExecuteQuery(queryString); //Check if row was found if (reader != null && reader.HasRows) { reader.Close(); queryString = "SELECT * FROM WORKER WHERE username='******' AND iPassword='******' AND position='Supervisor'"; reader = useDbSql.ExecuteQuery(queryString); if (reader.HasRows) { reader.Close(); queryString = "UPDATE WORKER SET loggedIn = 'true' WHERE username='******' AND iPassword='******'"; bool result = useDbSql.ExecuteCommand(queryString); this.Hide(); Admin_HomeForm openAdminHome = new Admin_HomeForm(); openAdminHome.ShowDialog(); } else { reader.Close(); queryString = "UPDATE WORKER SET loggedIn = 'true' WHERE username='******' AND iPassword='******'"; bool result = useDbSql.ExecuteCommand(queryString); this.Hide(); HomeForm homeFrm = new HomeForm(); homeFrm.ShowDialog(); } } else { lblResults.Text = "Username or Password is wrong!"; } } catch (SqlException se) { MessageBox.Show("An error has occurred... " + se.Message); } finally { useDbSql.DisconnectToDB(); } }
private void LoginForm_Load(object sender, EventArgs e) { try { TcpChannel channel = new TcpChannel(); ChannelServices.RegisterChannel(channel, true); useDbSql = (UseDatabase.UseDatabase)Activator.GetObject(typeof(UseDatabase.UseDatabase), "tcp://localhost:720/GlobalHyper"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void View_Operators_Load(object sender, EventArgs e) { //// TODO: This line of code loads data into the 'globalHyperDataSet3.WORKER' table. You can move, or remove it, as needed. //this.wORKERTableAdapter1.Fill(this.globalHyperDataSet3.WORKER); //// TODO: This line of code loads data into the 'globalHyperDataSet.WORKER' table. You can move, or remove it, as needed. //this.wORKERTableAdapter.Fill(this.globalHyperDataSet.WORKER); //// TODO: This line of code loads data into the 'globalHyperDataSet1.WORKER' table. You can move, or remove it, as needed. UseDatabase.UseDatabase viewOperator = new UseDatabase.UseDatabase(); viewOperator.ConnectToDB(); DataTable dt = viewOperator.getWorker().Tables[0]; dataGridView1.DataSource = dt; viewOperator.DisconnectToDB(); }