private void button4_Click(object sender, EventArgs e)
{
adminHome adh = new adminHome();
adh.Show();
this.Hide();
}
private void log()
{
if (TextBox1.Text == "" || TextBox2.Text == "")
{
MessageBox.Show("Please Complete the data");
}
else
{
MySqlConnection myconn = new MySqlConnection(connection);
MySqlDataReader r;
try
{
myconn.Open();
MySqlCommand selectcomm = new MySqlCommand("employee", myconn);
selectcomm.CommandType = CommandType.StoredProcedure;
selectcomm.Parameters.AddWithValue("@k", "login");
selectcomm.Parameters.AddWithValue("@Id_par1", 0);
selectcomm.Parameters.AddWithValue("@Name_par2", "None");
selectcomm.Parameters.AddWithValue("@Job_par3", "None");
selectcomm.Parameters.AddWithValue("@Phone_par4", 0);
selectcomm.Parameters.AddWithValue("@Address_par5", "None");
selectcomm.Parameters.AddWithValue("@User_par6", TextBox1.Text);
selectcomm.Parameters.AddWithValue("@Pass_par7", TextBox2.Text);
selectcomm.Parameters.AddWithValue("@Salary_par8", 0);
selectcomm.Parameters.AddWithValue("@Shift_par9", 0);
user = TextBox1.Text;
MySqlDataAdapter adapter = new MySqlDataAdapter(selectcomm);
DataTable datatb = new DataTable();
adapter.Fill(datatb);
if (datatb.Rows.Count == 1)
{
r = selectcomm.ExecuteReader();
r.Read();
if (r.GetValue(2).ToString() == "Casher")
{
Form1 dh = new Form1();
dh.Show();
this.Hide();
}
else if (r.GetValue(2).ToString() == "Admin")
{
adminHome ad = new adminHome();
ad.Show();
this.Hide();
}
logfile log = new logfile();
bool result = log.logfilee("select user,pass,Job from employee where user = user_par6 and pass = pass_par7");
}
else
{
MessageBox.Show("Username or password incorrect");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
myconn.Close();
}
}
}
private void button14_Click(object sender, EventArgs e)
{
adminHome lg = new adminHome();
lg.Show();
}
