public frmAgenda()
{
koneksi = KoneksiDB.Koneksi.getKoneksi();
impAgenda = new ImpAgenda();
impCustomer = new ImpCustomer();
entAgenda = new EntAgenda();
InitializeComponent();
cmbCustomer();
}
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);
}
