private void button2_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(this.textBox1.Text) || string.IsNullOrWhiteSpace(this.textBox2.Text) || string.IsNullOrEmpty(comboBox1.Text))
{
if (string.IsNullOrWhiteSpace(this.textBox1.Text))
{
MessageBox.Show("Enter User Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.textBox1.Focus();
}
else if (string.IsNullOrWhiteSpace(this.textBox2.Text))
{
MessageBox.Show("Enter Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.textBox2.Focus();
}
else
{
MessageBox.Show("Select your Status", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
///////////start of admin log in//////////////////////
if (comboBox1.SelectedIndex == 0)
{
adminControls adct = new adminControls();
try
{
conn.Open();
String admin_username = textBox1.Text;
String pass_word = textBox2.Text;
OracleCommand cmd = new OracleCommand("SELECT * FROM ADMIN WHERE ADMIN_USERNAME='******'", conn);
OracleDataReader r = cmd.ExecuteReader();
if (r.HasRows)
{
cmd = new OracleCommand("SELECT PASSWORD FROM ADMIN WHERE ADMIN_USERNAME='******'", conn);
r = cmd.ExecuteReader();
r.Read();
if (r.GetValue(0).ToString() == pass_word)
{
LoginName.name = textBox1.Text;
adct.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Invalid User Name Or Password", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBox2.Focus();
}
r.Close();
conn.Close();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
///////////End of admin log in//////////////////////
///////////start of manager log in//////////////////////
if (comboBox1.SelectedIndex == 1)
{
managerControls mnct = new managerControls();
try
{
conn.Open();
// String admin_username = textBox1.Text;
// String pass_word = textBox2.Text;
OracleCommand cmd = new OracleCommand("SELECT * FROM MANAGER_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn);
OracleDataReader r = cmd.ExecuteReader();
if (r.HasRows)
{
// MessageBox.Show();
cmd = new OracleCommand("SELECT PASSWORD FROM MANAGER_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn);
r = cmd.ExecuteReader();
r.Read();
// MessageBox.Show(r.GetString(0));
if (r.GetValue(0).ToString() == textBox2.Text)
{
// MessageBox.Show("wELCOM");
LoginName.name = textBox1.Text;
mnct.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Invalid User Name Or Password", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
r.Close();
conn.Close();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
///////////End of manager log in//////////////////////
//////////start of stuff log in/////////////////////
if (comboBox1.SelectedIndex == 2)
{
stuffControls stct = new stuffControls();
try
{
conn.Open();
// String admin_username = textBox1.Text;
// String pass_word = textBox2.Text;
OracleCommand cmd = new OracleCommand("SELECT * FROM STUFF_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn);
OracleDataReader r = cmd.ExecuteReader();
if (r.HasRows)
{
// MessageBox.Show();
cmd = new OracleCommand("SELECT PASSWORD FROM STUFF_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn);
r = cmd.ExecuteReader();
r.Read();
// MessageBox.Show(r.GetString(0));
if (r.GetValue(0).ToString() == textBox2.Text)
{
// MessageBox.Show("wELCOM");
LoginName.name = textBox1.Text;
stct.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Invalid User Name Or Password", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
r.Close();
conn.Close();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
///////////End of stuff log in//////////////////////
}
}
private void button2_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(this.textBox1.Text) || string.IsNullOrWhiteSpace(this.textBox2.Text) || string.IsNullOrEmpty(comboBox1.Text))
{
if (string.IsNullOrWhiteSpace(this.textBox1.Text))
{
MessageBox.Show("Enter User Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.textBox1.Focus();
}
else if (string.IsNullOrWhiteSpace(this.textBox2.Text))
{
MessageBox.Show("Enter Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.textBox2.Focus();
}
else
{
MessageBox.Show("Select your Status", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
///////////start of admin log in//////////////////////
if (comboBox1.SelectedIndex == 0)
{
adminControls adct = new adminControls();
try
{
conn.Open();
String admin_username = textBox1.Text;
String pass_word = textBox2.Text;
OracleCommand cmd = new OracleCommand("SELECT * FROM ADMIN WHERE ADMIN_USERNAME='******'", conn);
OracleDataReader r = cmd.ExecuteReader();
if (r.HasRows)
{
cmd = new OracleCommand("SELECT PASSWORD FROM ADMIN WHERE ADMIN_USERNAME='******'", conn);
r = cmd.ExecuteReader();
r.Read();
if (r.GetValue(0).ToString() == pass_word)
{
LoginName.name = textBox1.Text;
adct.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Invalid User Name Or Password", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBox2.Focus();
}
r.Close();
conn.Close();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
///////////End of admin log in//////////////////////
///////////start of manager log in//////////////////////
if (comboBox1.SelectedIndex == 1)
{
managerControls mnct = new managerControls();
try
{
conn.Open();
// String admin_username = textBox1.Text;
// String pass_word = textBox2.Text;
OracleCommand cmd = new OracleCommand("SELECT * FROM MANAGER_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn);
OracleDataReader r = cmd.ExecuteReader();
if (r.HasRows)
{
// MessageBox.Show();
cmd = new OracleCommand("SELECT PASSWORD FROM MANAGER_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn);
r = cmd.ExecuteReader();
r.Read();
// MessageBox.Show(r.GetString(0));
if (r.GetValue(0).ToString() == textBox2.Text)
{
// MessageBox.Show("wELCOM");
LoginName.name = textBox1.Text;
mnct.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Invalid User Name Or Password", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
r.Close();
conn.Close();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
///////////End of manager log in//////////////////////
//////////start of stuff log in/////////////////////
if (comboBox1.SelectedIndex == 2)
{
stuffControls stct = new stuffControls();
try
{
conn.Open();
// String admin_username = textBox1.Text;
// String pass_word = textBox2.Text;
OracleCommand cmd = new OracleCommand("SELECT * FROM STUFF_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn);
OracleDataReader r = cmd.ExecuteReader();
if (r.HasRows)
{
// MessageBox.Show();
cmd = new OracleCommand("SELECT PASSWORD FROM STUFF_LOGIN WHERE U_NAME='" + textBox1.Text + "'", conn);
r = cmd.ExecuteReader();
r.Read();
// MessageBox.Show(r.GetString(0));
if (r.GetValue(0).ToString() == textBox2.Text)
{
// MessageBox.Show("wELCOM");
LoginName.name = textBox1.Text;
stct.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Invalid User Name Or Password", "Access Denied", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
r.Close();
conn.Close();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
///////////End of stuff log in//////////////////////
}
}