private void SimpanData()
{
if (tbnama.Text != "" && tbnohp.Text != "" && tbberat.Text != "" && tbjenispaket.Text != "" && tbharga.Text != "" && tbhargatotal.Text != "" && dateTimePicker2.Text != "" &&
dateTimePicker1.Text != "")
{
using (var db = new PelangganModel())
{
pelanggan = new Pelanggan
{
Nama = tbnama.Text,
No_Hp = tbnohp.Text,
Berat_Cucian = Convert.ToInt32(tbberat.Text),
Jenis_Paket = tbjenispaket.Text,
Harga_Paket = Convert.ToDouble(tbharga.Text),
Harga_Total = Convert.ToDouble(tbhargatotal.Text),
Tanggal_Pemsanan = Convert.ToDateTime(dateTimePicker2.Text),
Tanggal_Pengambilan = Convert.ToDateTime(dateTimePicker1.Text),
};
db.Pelanggans.Add(pelanggan);
db.SaveChanges();
MessageBox.Show("Pesanan Disimpan");
}
}
else
{
MessageBox.Show("Nama, Nomor Hp, Berat Cucian, Jenis Paket, Tanggal Pemesanan harus diisi");
}
}
private void button6_Click(object sender, EventArgs e)
{
lbpesanan.Items.Clear();
groupBox1.Visible = false;
groupBox2.Visible = true;
using (var db = new PelangganModel())
{
var query = from pelanggan in db.Pelanggans
where pelanggan.Nama != ""
select pelanggan;
foreach (var item in query)
{
lbpesanan.Items.Add(item.Nama + "\t" + item.Jenis_Paket + "\t" + item.Berat_Cucian + "\t" + item.Tanggal_Pemsanan + "\t" + item.Tanggal_Pengambilan + "\t" + item.Harga_Total);
}
}
}
