public frmPesanan()
{
koneksi = KoneksiDB.Koneksi.getKoneksi();
impPesanan = new ImpPesanan();
impCustomer = new ImpCustomer();
impPaket = new ImpPaket();
entPesanan = new EntPesanan();
InitializeComponent();
CmbViewCustomer.Focus();
cmbCustomer();
cmbPaket();
}
public Boolean updatePesanan(EntPesanan ep, int id_pesanan)
{
status = false;
try
{
koneksi.Open();
query = "UPDATE pesanan SET id_customer ='" + ep.getIDCustomer() + "', id_paket ='" + ep.getIDPaket() + "', tgl_pesan ='" + ep.getTgl() + "' WHERE id_pesanan=" + id_pesanan + "";
MySqlCommand command = koneksi.CreateCommand();
command.CommandText = query;
command.ExecuteNonQuery();
status = true;
koneksi.Close();
}
catch (MySqlException me)
{
Console.WriteLine(me);
}
return(status);
}
public Boolean insertPesanan(EntPesanan ep)
{
status = false;
try
{
koneksi.Open();
query = "INSERT INTO pesanan (id_customer,id_paket,tgl_pesan) VALUES ('" + ep.getIDCustomer() + "' ,'" + ep.getIDPaket() + "' , '" + ep.getTgl() + "')";
MySqlCommand command = koneksi.CreateCommand();
command.CommandText = query;
command.ExecuteNonQuery();
status = true;
koneksi.Close();
}
catch (MySqlException me)
{
Console.WriteLine(me);
}
return(status);
}
