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