private void button1_Click(object sender, EventArgs e)
{
try
{
conn.Open();
Sha sha = new Sha(password.Text);
cmd = new OleDbCommand("Select * from Users", conn);
dr = cmd.ExecuteReader();
int str = 0;
while (dr.Read())
{
str = int.Parse(dr[0].ToString());
str++;
}
dr.Close();
cmd = conn.CreateCommand();
cmd.CommandText = "insert into Users values (" + str + ",'" + username.Text + "','" + sha.GetPassword() + "',0,'" + fname.Text + "','" + lname.Text + "');";
cmd.ExecuteNonQuery();
MessageBox.Show("Create User Success!");
conn.Close();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
conn.Open();
cmd = new OleDbCommand("Select * from Users where Username='******'", conn);
dr = cmd.ExecuteReader();
Sha sha = new Sha(password.Text);
dr.Read();
if (dr["Password"].ToString() == sha.GetPassword())
{
if (int.Parse(dr["Permission"].ToString()) == 1)
{
AdminLogin admin = new AdminLogin(int.Parse(dr["id"].ToString()));
admin.Show();
this.Close();
}
else
{
Users user = new Users(int.Parse(dr["id"].ToString()));
user.Show();
this.Close();
}
}
else
{
MessageBox.Show("Error!");
}
dr.Close();
conn.Close();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.ToString());
}
}