public void CreateEmployee()
{
MySqlConnection connection = conn.OpenConnection();
connection.Open();
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "INSERT INTO employee(NIK, Fullname, Nickname, KTP, " +
"Jamsostek, BankID, Rekening, NPWP, StatusPajak, DOB, Gender, Religion, MaritalStatus) " +
"VALUES (@nik, @fullname, @nickname, @ktp, @jamsostek, @bankid, @rekening, @npwp, " +
"@statuspajak, @dob, @gender, @religion, @maritalstatus)";
cmd.Parameters.AddWithValue("@nik", NIK.ToString());
cmd.Parameters.AddWithValue("@fullname", fullName);
cmd.Parameters.AddWithValue("@nickname", nickname);
cmd.Parameters.AddWithValue("@ktp", KTP);
cmd.Parameters.AddWithValue("@jamsostek", jamsostek);
cmd.Parameters.AddWithValue("@bankid", bankID.ToString());
cmd.Parameters.AddWithValue("@rekening", rekening);
cmd.Parameters.AddWithValue("@npwp", NPWP);
cmd.Parameters.AddWithValue("@statuspajak", statusPajak);
cmd.Parameters.AddWithValue("@dob", DOB);
cmd.Parameters.AddWithValue("@gender", gender);
cmd.Parameters.AddWithValue("@religion", religion);
cmd.Parameters.AddWithValue("@maritalstatus", maritalStatus);
cmd.ExecuteNonQuery();
MessageBox.Show("Data Created Successfully!");
connection.Close();
}
