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