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