public Boolean updateAgenda(EntAgenda ea, int id_agenda) { status = false; try { koneksi.Open(); query = "UPDATE agenda SET id_customer ='" + ea.getIDCustomer() + "', judul_acara ='" + ea.getJudul() + "', tgl_acara ='" + ea.getTgl() + "', tempat ='" + ea.getTempat() + "' WHERE id_agenda=" + id_agenda + ""; MySqlCommand command = koneksi.CreateCommand(); command.CommandText = query; command.ExecuteNonQuery(); status = true; koneksi.Close(); } catch (MySqlException me) { Console.WriteLine(me); } return(status); }
public Boolean insertAgenda(EntAgenda ea) { status = false; try { koneksi.Open(); query = "INSERT INTO agenda (id_customer,judul_acara,tgl_acara,tempat) VALUES (" + ea.getIDCustomer() + " ,'" + ea.getJudul() + "' , '" + ea.getTgl() + "','" + ea.getTempat() + "')"; MySqlCommand command = koneksi.CreateCommand(); command.CommandText = query; command.ExecuteNonQuery(); status = true; koneksi.Close(); } catch (MySqlException me) { Console.WriteLine(me); } return(status); }