public bool DeleteUserSistem(UserSistem u_ser)
{
bool result = false;
query = "UPDATE user_sistem SET status_deleted = 1 WHERE id_user_sistem = '" + u_ser.Id_user_sistem + "'";
try
{
connect.Open();
cmd = new MySqlCommand(query, connect);
cmd.ExecuteNonQuery();
result = true;
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message.ToString());
result = false;
}
finally
{
connect.Close();
}
return result;
}
public bool AddUserSistem(UserSistem u_ser)
{
bool result = false;
query = "INSERT INTO user_sistem VALUES('" + u_ser.Id_user_sistem + "','" + u_ser.Nama_user + "','" + u_ser.Password_user + "','" + u_ser.Role_user + "', 0)";
try
{
connect.Open();
cmd = new MySqlCommand(query, connect);
cmd.ExecuteNonQuery();
result = true;
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message.ToString());
result = false;
}
finally
{
connect.Close();
}
return result;
}
private void btn_DeletePermanenUserSistem_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Peringatan! Anda akan menghapus semua data secara permanen. Anda yakin?", "WARNING", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
s_userSistem = new UserSistem();
s_userSistem.Id_user_sistem = Utils.ConcatMaxID(txt_IdPenggunaSistem.Text.ToString(), txt_IdPenggunaSistemNum.Text.ToString());
if (s_userSistemManager.DeleteUserSistemPermanen(s_userSistem))
{
MessageBox.Show("Data berhasil dihapus permanen");
txt_IdPenggunaSistemNum.Text = Utils.DisplayMaxID(s_userSistemManager.GetMaxIDUserSistem().Substring((s_userSistemManager.GetMaxIDUserSistem().IndexOf("-")) + 1));
ClearField();
}
else
{
MessageBox.Show("Data gagal dihapus permanen");
}
}
else
{
return;
}
}
private void btn_AddUserSistem_Click(object sender, EventArgs e)
{
if (txt_NamaPengguna.TextLength > 0 && txt_KataSandi.TextLength > 0 && txt_UlangiKataSandi.TextLength > 0 && cmb_Role.SelectedIndex != -1)
{
s_userSistem = new UserSistem(Utils.ConcatMaxID(txt_IdPenggunaSistem.Text.ToString(), txt_IdPenggunaSistemNum.Text.ToString()), txt_NamaPengguna.Text.ToString(), Utils.PassEncrypt(txt_KataSandi.Text.ToString(), true), cmb_Role.SelectedItem.ToString());
if (s_userSistemManager.AddUserSistem(s_userSistem))
{
MessageBox.Show("Data berhasil ditambah");
txt_IdPenggunaSistemNum.Text = Utils.DisplayMaxID(s_userSistemManager.GetMaxIDUserSistem().Substring(s_userSistemManager.GetMaxIDUserSistem().IndexOf("-") + 1));
ClearField();
}
else
{
MessageBox.Show("Data gagal ditambah");
}
}
else
{
MessageBox.Show("Mohon data-data dilengkapi");
}
}
public bool ValidateLogin(UserSistem u_ser)
{
bool result = false;
query = "SELECT nama_user, pass_user FROM user_sistem WHERE nama_user = '******' and pass_user = '******'";
try
{
connect.Open();
cmd = new MySqlCommand(query, connect);
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
result = true;
}
else if (reader.HasRows == false)
{
result = false;
}
reader.Close();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message.ToString());
result = false;
}
finally
{
connect.Close();
}
return result;
}
public bool UpdateUserSistem(UserSistem u_ser)
{
bool result = false;
query = "UPDATE user_sistem SET nama_user = '******', pass_user = '******', role_user = '******' WHERE id_user_sistem = '" + u_ser.Id_user_sistem + "'";
try
{
connect.Open();
cmd = new MySqlCommand(query, connect);
cmd.ExecuteNonQuery();
result = true;
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message.ToString());
result = false;
}
finally
{
connect.Close();
}
return result;
}