private void logoff_btn_Click(object sender, EventArgs e) { DateTime dateing = DateTime.Now; logs_class classe = new logs_class(); classe.Log_out = dateing.ToString(); classe.Log_current = 2; MySqlConnection connection = new MySqlConnection(connec); connection.Open(); string query3 = "UPDATE internal_communication_4.logs SET log_current = @log_current, log_out = @log_out Where (log_current = 1)"; MySqlCommand comm = connection.CreateCommand(); comm.CommandText = query3; comm.Parameters.AddWithValue("@log_current", classe.Log_current); comm.Parameters.AddWithValue("@log_out", classe.Log_out); comm.ExecuteNonQuery(); connection.Close(); this.Hide(); login_form gin = new login_form(); gin.Show(); }
private void del_btn_Click(object sender, EventArgs e) { if (int.TryParse(deluser_txtbx.Text, out pass2)) { user_class use = new user_class(); use.ID = int.Parse(deluser_txtbx.Text); pass2 = use.ID; } else { MessageBox.Show("Please input a correct ID"); } string message = "Do you want to proceed?"; string title = "Close Window"; MessageBoxButtons buttons = MessageBoxButtons.YesNo; DialogResult result = MessageBox.Show(message, title, buttons); if (result == DialogResult.Yes) { MySqlConnection connection = new MySqlConnection("datasource=localhost;port=3306;username=root;password=jmsb;server=127.0.0.2;database=internal_communication_4;persistsecurityinfo=True"); connection.Open(); string query = "DELETE FROM `internal_communication_4`.`user` WHERE (`user_id` = " + this.pass2 + ");"; MySqlCommand command = new MySqlCommand(query, connection); MySqlDataReader MyReader2; MyReader2 = command.ExecuteReader(); while (MyReader2.Read()) { } connection.Close(); MessageBox.Show("user successfully deleted!"); login_form lgin = new login_form(); foreach (Form var in Application.OpenForms) { var.Hide(); } postion_txtbx.Text = ""; name_txbx.Text = ""; pass = 0; lgin.Show(); } else { login_form lg = new login_form(); foreach (Form var in Application.OpenForms) { var.Hide(); } postion_txtbx.Text = ""; name_txbx.Text = ""; pass = 0; lg.Show(); } }
private void Confirm_btn_Click(object sender, EventArgs e) { if (int.TryParse(password_txtbx.Text, out psw) || int.TryParse(ID_txtbx.Text, out ident)) { psw = int.Parse(password_txtbx.Text); ident = int.Parse(ID_txtbx.Text); user_class user = new user_class(); user.ID = ident; user.Name = name_txbx.Text; user.Password = psw; user.Position = postion_txtbx.Text; identification = user.ID; pass = user.Password; identification = user.ID; position = user.Position; name = user.Name; } else { MessageBox.Show("Please input a number password AND ID"); } try { MySqlConnection connection = new MySqlConnection("datasource=localhost;port=3306;username=root;password=jmsb;server=127.0.0.2;database=internal_communication_4;persistsecurityinfo=True"); connection.Open(); if (connection.State == ConnectionState.Open) { connection1_lbl.Text = "connected"; connection1_lbl.ForeColor = Color.Green; } else { connection1_lbl.Text = "Not connected"; connection1_lbl.ForeColor = Color.Red; } MySqlCommand command = connection.CreateCommand(); command.CommandText = "INSERT INTO internal_communication_4.user(user_id,user_password,user_position,user_name) VALUES( @user_id, @user_password, @user_position, @user_name)"; command.Parameters.AddWithValue("@user_id", identification); command.Parameters.AddWithValue("@user_password", pass); command.Parameters.AddWithValue("@user_position", position); command.Parameters.AddWithValue("@user_name", name); command.ExecuteNonQuery(); MessageBox.Show("New user " + identification + " successfully created!"); connection.Close(); login_form lgin = new login_form(); foreach (Form var in Application.OpenForms) { var.Hide(); } postion_txtbx.Text = ""; name_txbx.Text = ""; pass = 0; lgin.Show(); } catch { MessageBox.Show("Cannot create user, ID already used ?"); foreach (Form var in Application.OpenForms) { var.Hide(); } login_form lgin = new login_form(); lgin.Show(); } }