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();
}
}