private void button4_Click_1(object sender, EventArgs e)
{
string stat = "out";
int uid = 0;
log = label3.Text;
try
{
connection.Open();
string query1 = "SELECT * from logintbl where stat = 'in' and username ='******'";
MySqlCommand cmd1 = new MySqlCommand(query1, connection);
MySqlDataReader dataReader = cmd1.ExecuteReader();
while (dataReader.Read())
{
uid = dataReader.GetInt32("userid");
}
}
catch (MySqlException) { }
connection.Close();
try
{
connection.Open();
string query = "UPDATE logintbl set stat = '" + stat + "' where userid = '" + uid + "'";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
}
catch (MySqlException) { }
connection.Close();
MessageBox.Show("Successfully logged out");
Logframe lf = new Logframe();
lf.Show();
}
private void button2_Click(object sender, EventArgs e)
{
Logframe lf = new Logframe();
lf.Show();
this.Hide();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedItem.Equals("Logout"))
{
string loguser = "";
loguser = label3.Text;
string stat = "out";
int uid = 0;
try
{
connection.Open();
string query1 = "SELECT * from logintbl where stat = 'in' and username = '******'";
MySqlCommand cmd1 = new MySqlCommand(query1, connection);
MySqlDataReader dataReader = cmd1.ExecuteReader();
while (dataReader.Read())
{
uid = dataReader.GetInt32("userid");
}
}
catch (MySqlException) { }
connection.Close();
try
{
connection.Open();
string query = "UPDATE logintbl set stat = '" + stat + "' where userid = '" + uid + "'";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
}
catch (MySqlException) { }
connection.Close();
MessageBox.Show("Successfully logged out");
Logframe lf = new Logframe();
lf.Show();
this.Hide();
}
if (comboBox1.SelectedItem.Equals("Add User"))
{
AddUser au = new AddUser();
au.Show();
comboBox1.SelectedIndex = 0;
}
if (comboBox1.SelectedItem.Equals("Add Admin"))
{
AddAdmin aa = new AddAdmin();
aa.Show();
comboBox1.SelectedIndex = 0;
}
}
private void button1_Click(object sender, EventArgs e)
{
label4.ResetText();
string user = "", pass = "", cpass = "", status = "out", username = "", userlvl = "", status1 = "";
bool check = true, checker = true, checking = true;
int ctr = 1, ctr1 = 0;
string connectionString = "datasource=localhost" + ";" + "DATABASE=dentaldb" + ";" + "UID=root"
+ ";" + "PASSWORD=password" + ";";
MySqlConnection connection = new MySqlConnection(connectionString);
user = textBox1.Text;
pass = textBox2.Text;
cpass = textBox3.Text;
try
{
connection.Open();
string query1 = "SELECT username from logintbl";
MySqlCommand cmd1 = new MySqlCommand(query1, connection);
MySqlDataReader dataReader = cmd1.ExecuteReader();
while (dataReader.Read())
{
username = dataReader.GetString("username");
ctr += 1;
ctr1 = 1;
if (user.Equals(username))
{
label4.Text = "Username already exists!";
check = true;
checker = true;
break;
}
else
{
check = false;
}
}
if (ctr1 == 0)
{
if (radioButton1.Checked == true)
{
userlvl = "Admin";
status1 = "approved";
}
else
{
userlvl = "User";
status1 = "not approved";
}
check = false;
}
else
{
if (radioButton1.Checked == true)
{
userlvl = "Admin";
status1 = "not approved";
}
else
{
userlvl = "User";
status1 = "not approved";
}
checker = false;
}
}
catch (MySqlException) { }
connection.Close();
if (cpass.Equals(pass) == false)
{
label4.Text = "Password doesn't match";
checker = true;
}
else
{
checker = false;
}
if (check == false && checker == false)
{
try
{
connection.Open();
string query1 = "INSERT into logintbl values('" + ctr + "','" + user + "','" + pass + "','" + status + "','" + userlvl + "','" + status1 + "')";
MySqlCommand cmd1 = new MySqlCommand(query1, connection);
cmd1.ExecuteNonQuery();
MessageBox.Show("Sign up successfully");
}
catch (MySqlException) { }
connection.Close();
this.Hide();
Logframe lf = new Logframe();
lf.Show();
}
}
private void button1_Click(object sender, EventArgs e)
{
label4.ResetText();
label5.ResetText();
label7.ResetText();
string pass = "", oldpass = "", newp = "", confp = "", user = "", checkuser = "";
bool check = true, checker = true, boolcheck = false;
int ctr = 0;
string connectionString = "datasource=localhost" + ";" + "DATABASE=dentaldb" + ";" + "UID=root"
+ ";" + "PASSWORD=password" + ";";
MySqlConnection connection = new MySqlConnection(connectionString);
user = textBox1.Text;
try
{
oldpass = textBox2.Text.Trim();
if (oldpass.Length == 0)
{
label4.Text = "Current password is required";
boolcheck = true;
}
}
catch (FormatException) {
}
try
{
newp = textBox3.Text.Trim();
if (newp.Length == 0)
{
label5.Text = "New password is required";
boolcheck = true;
}
confp = textBox4.Text;
}
catch (FormatException)
{
}
try
{
connection.Open();
string query1 = "SELECT username, password from logintbl where username = '******'";
MySqlCommand cmd1 = new MySqlCommand(query1, connection);
MySqlDataReader dataReader = cmd1.ExecuteReader();
while (dataReader.Read())
{
checkuser = dataReader.GetString("username");
pass = dataReader.GetString("password");
ctr = 1;
}
}
catch (MySqlException) { }
connection.Close();
if (ctr == 0)
{
label7.Text = "Username not found!";
check = true;
checker = true;
}
else
{
if (oldpass.Equals(pass))
{
check = false;
}
else
{
check = true;
label4.Text = "Incorrect current password";
}
}
if (newp.Equals(confp))
{
if (newp.Equals(pass) && confp.Equals(pass))
{
checker = true;
label5.Text = "New password is already your current password";
}
else
{
checker = false;
}
}
else
{
label5.Text = "New Password doesn't match";
check = true;
checker = true;
}
if (check == false && checker == false && boolcheck == false)
{
try
{
connection.Open();
string query2 = "UPDATE logintbl set password = '******' where username='******'";
MySqlCommand cmd2 = new MySqlCommand(query2, connection);
cmd2.ExecuteNonQuery();
MessageBox.Show("Password successfully changed");
this.Hide();
Logframe lf = new Logframe();
lf.Show();
}
catch (MySqlException) { }
connection.Close();
}
}