private void btn_bayar_Click(object sender, EventArgs e) { if (ID != 0) { using (var ctx = new db_dataEntities()) { ObjectCache cache = MemoryCache.Default; dynamic user = cache.Get("userLogin"); var order = ctx.tbl_order.Where(o => o.id == ID).FirstOrDefault(); order.total_bayar = decimal.Parse(total_bayar_txt.Text); order.kembali = decimal.Parse(kembali_txt.Text); order.status = 1; order.updated_by = user.username; order.updated_date = DateTime.Now; ctx.tbl_order.AddOrUpdate(order); ctx.SaveChanges(); MessageBox.Show("Pembayaran Selesai"); //ID = 0; btn_bayar.Enabled = false; btn_biling.Enabled = true; MappingToDataGrid(); } } }
private void btn_hapus_Click(object sender, EventArgs e) { ObjectCache cache = MemoryCache.Default; dynamic user = cache.Get("userLogin"); int id = ID; if (id != 0) { DialogResult result = MessageBox.Show("Apakah Anda yakin ingin mengahapus data ini?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { using (var ctx = new db_dataEntities()) { var menu = ctx.tbl_menu.Where(o => o.id == id).FirstOrDefault(); menu.is_active = 0; menu.deleted_by = user.username; menu.deleted_date = DateTime.Now; ctx.tbl_menu.AddOrUpdate(menu); ctx.SaveChanges(); } MessageBox.Show("Sukses Delete"); Initial(); } else if (result == DialogResult.No) { //code for No } } }
private void button1_Click(object sender, EventArgs e) { var subTotal = listOrder.Sum(o => o.harga_total); var idOrder = 0; if (listOrder.Count > 0) { var data = new tbl_order { created_by = "user", created_date = DateTime.Now, no_meja = no_meja.Text, subtotal = subTotal, status = 0, is_active = 1 }; using (var ctx = new db_dataEntities()) { var id = ctx.tbl_order.Add(data); ctx.SaveChanges(); idOrder = id.id; } } foreach (var order in listOrder) { var detailOrder = new tbl_detail_order { created_by = "user", created_date = DateTime.Now, id_order = idOrder, id_menu = order.id_menu, qty = order.qty, harga_satuan = order.harga_satuan, harga_total = order.harga_total, is_active = 1 }; using (var ctx = new db_dataEntities()) { ctx.tbl_detail_order.Add(detailOrder); ctx.SaveChanges(); } } MessageBox.Show("Menu Telah Di Order"); Initial(); }
private void btn_update_Click(object sender, EventArgs e) { ObjectCache cache = MemoryCache.Default; dynamic user = cache.Get("userLogin"); var id = ID; if (id != 0) { using (var ctx = new db_dataEntities()) { var menu = ctx.tbl_menu.Where(o => o.id == id).FirstOrDefault(); var jenis = 0; if (this.cmb_jenis.SelectedItem == "Makanan") { jenis = 1; } else if (this.cmb_jenis.SelectedItem == "Minuman") { jenis = 2; } menu.jenis = jenis; menu.updated_by = user.username; menu.updated_date = DateTime.Now; menu.nama_menu = this.txt_nama_menu.Text; menu.harga_satuan = decimal.Parse(this.txt_harga.Text); menu.keterangan = this.txt_keterangan.Text; menu.foto = this.txt_foto.Text; ctx.tbl_menu.AddOrUpdate(menu); ctx.SaveChanges(); } MessageBox.Show("Sukses Update"); Initial(); } }
private void btn_simpan_Click(object sender, EventArgs e) { ObjectCache cache = MemoryCache.Default; dynamic user = cache.Get("userLogin"); var jenis = 0; if (this.cmb_jenis.SelectedItem == "Makanan") { jenis = 1; } else if (this.cmb_jenis.SelectedItem == "Minuman") { jenis = 2; } var menu = new tbl_menu() { is_active = 1, created_by = user.username, created_date = DateTime.Now, nama_menu = this.txt_nama_menu.Text, harga_satuan = decimal.Parse(this.txt_harga.Text), keterangan = this.txt_keterangan.Text, foto = this.txt_foto.Text, jenis = jenis }; using (var ctx = new db_dataEntities()) { ctx.tbl_menu.Add(menu); ctx.SaveChanges(); } MessageBox.Show("Sukses Simpan"); Initial(); }