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); }