private void btnUpdate_Click(object sender, EventArgs e)
{
ClassOrder m = new ClassOrder();
m.Status = cbStatus.Text;
md.updateAmbil(m, id);
viewData();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
string TanggalOrder = dtpOrder.Value.ToString("yyyy-MM-dd");
string TanggalRenSelesai = dtpRs.Value.ToString("yyyy-MM-dd");
ClassOrder m = new ClassOrder();
if (rbDiantar.Checked)
{
m.Id_order = tbIdOrder.Text;
m.Paket = cbPaket.Text;
m.Nama = tbNama.Text;
m.No_hp = tbNohp.Text;
m.Alamat = rtbAlamat.Text;
m.Tgl_order = TanggalOrder;
m.Tgl_ren_selesai = TanggalRenSelesai;
m.Pengiriman = rbDiantar.Text;
m.Berat = tbBerat.Text;
m.Harga = tbHarga.Text;
m.Biaya_antar = tbBiaya.Text;
m.Total_dibayar = tbTotal.Text;
m.Uang_dibayar = tbDibayar.Text;
m.Uang_kembali = tbKembali.Text;
m.Status = "Progress";
}
else
{
m.Id_order = tbIdOrder.Text;
m.Paket = cbPaket.Text;
m.Nama = tbNama.Text;
m.No_hp = tbNohp.Text;
m.Alamat = rtbAlamat.Text;
m.Tgl_order = TanggalOrder;
m.Tgl_ren_selesai = TanggalRenSelesai;
m.Pengiriman = rbDiambil.Text;
m.Berat = tbBerat.Text;
m.Harga = tbHarga.Text;
m.Biaya_antar = tbBiaya.Text;
m.Total_dibayar = tbTotal.Text;
m.Uang_dibayar = tbDibayar.Text;
m.Uang_kembali = tbKembali.Text;
m.Status = "Progress";
}
md.insertOrder(m);
MessageBox.Show("Data order berhasil ditambahkan!");
ClearAll();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
ClassOrder m = new ClassOrder();
m.Id_order = tbIdOrder.Text;
m.Paket = cbPaket.Text;
m.Nama = cbNama.Text;
m.Alamat = tbAlamat.Text;
m.No_hp = tbNoHp.Text;
m.Pengiriman = cbPengiriman.Text;
m.Status = cbStatus.Text;
md.updateOrder(m, id);
viewData();
}
public bool updateAmbil(ClassOrder m, string id)
{
Boolean stat = false;
try
{
koneksi.Open();
perintah = new MySqlCommand();
perintah.Connection = koneksi;
perintah.CommandType = CommandType.Text;
perintah.CommandText = "UPDATE tbl_order SET status='" + m.Status + "' WHERE id='" + id + "'";
perintah.ExecuteNonQuery();
stat = true;
koneksi.Close();
}
catch (MySqlException) { }
return(stat);
}
public bool updateOrder(ClassOrder m, string id)
{
Boolean stat = false;
try
{
koneksi.Open();
perintah = new MySqlCommand();
perintah.Connection = koneksi;
perintah.CommandType = CommandType.Text;
perintah.CommandText = "UPDATE tbl_order SET id_order='" + m.Id_order + "', paket='" + m.Paket + "', nama='" + m.Nama + "', alamat='" + m.Alamat + "', no_hp='" + m.No_hp + "', pengiriman='" + m.Pengiriman + "', status='" + m.Status + "' WHERE id='" + id + "'";
perintah.ExecuteNonQuery();
stat = true;
koneksi.Close();
}
catch (MySqlException) { }
return(stat);
}
public bool insertOrder(ClassOrder m)
{
Boolean stat = false;
try
{
koneksi.Open();
perintah = new MySqlCommand();
perintah.Connection = koneksi;
perintah.CommandType = CommandType.Text;
perintah.CommandText = "INSERT INTO tbl_order (id, id_order, paket, nama, no_hp, alamat, tgl_order, tgl_ren_selesai, pengiriman, berat, harga, biaya_antar, total_dibayar, uang_dibayar, uang_kembali, status) VALUES('" + "" + "','" + m.Id_order + "', '" + m.Paket + "','" + m.Nama + "', '" + m.No_hp + "', '" + m.Alamat + "', '" + m.Tgl_order + "', '" + m.Tgl_ren_selesai + "', '" + m.Pengiriman + "', '" + m.Berat + "', '" + m.Harga + "', '" + m.Biaya_antar + "', '" + m.Total_dibayar + "', '" + m.Uang_dibayar + "', '" + m.Uang_kembali + "', '" + m.Status + "')";
perintah.ExecuteNonQuery();
stat = true;
koneksi.Close();
}
catch (MySqlException) { }
return(stat);
}