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 dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; if (e.RowIndex >= 0 && !string.IsNullOrEmpty(row.Cells[0].Value.ToString())) { var id = int.Parse(row.Cells[0].Value.ToString()); using (var ctx = new db_dataEntities()) { var order = ctx.tbl_order.Where(o => o.id == id).FirstOrDefault(); this.no_meja_txt.Text = order.no_meja; this.subtotal_txt.Text = order.subtotal.ToString(); this.total_bayar_txt.Text = order.total_bayar.ToString(); this.kembali_txt.Text = order.kembali.ToString(); if (order.status == 0) { btn_bayar.Enabled = true; btn_biling.Enabled = false; } else if (order.status == 1) { btn_bayar.Enabled = false; btn_biling.Enabled = true; } ID = id; } } }
private void btn_login_Click(object sender, EventArgs e) { using (var ctx = new db_dataEntities()) { var username = this.txtusername.Text; var password = this.txtpassword.Text; var getUser = ctx.tbl_user.Where(o => o.username == username && o.password == password).FirstOrDefault(); if (getUser != null) { ObjectCache cache = MemoryCache.Default; CacheItemPolicy cacheItemPolicy = new CacheItemPolicy(); cache.Add("userLogin", getUser, cacheItemPolicy); this.Hide(); menu_admin frm2 = new menu_admin(); frm2.Show(); } else { MessageBox.Show("please check username and password"); this.txtusername.Text = ""; this.txtpassword.Text = ""; } } }
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 } } }
public List <tbl_order> GetListOrder() { using (var ctx = new db_dataEntities()) { var getMenu = ctx.tbl_order.Where(o => o.is_active == 1).ToList(); return(getMenu); } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1) { DataGridViewRow row = dataGridView1.Rows[e.RowIndex]; if (e.RowIndex >= 0 && !string.IsNullOrEmpty(row.Cells[0].Value.ToString())) { var id = int.Parse(row.Cells[0].Value.ToString()); using (var ctx = new db_dataEntities()) { var menu = ctx.tbl_menu.Where(o => o.id == id).FirstOrDefault(); this.txt_nama_menu.Text = menu.nama_menu; this.txt_harga.Text = menu.harga_satuan.ToString(); this.txt_keterangan.Text = menu.keterangan; this.txt_foto.Text = menu.foto; if (!string.IsNullOrEmpty(menu.foto)) { // display image in picture box try { pictureBox2.Image = new Bitmap(menu.foto); } catch (Exception ex) { pictureBox2.Image = null; } } else { pictureBox2.Image = null; } foreach (var jenis in this.cmb_jenis.Items) { var namaJenis = ""; if (menu.jenis == 1) { namaJenis = "Makanan"; } else if (menu.jenis == 2) { namaJenis = "Minuman"; } if (namaJenis == jenis) { this.cmb_jenis.SelectedItem = jenis.ToString(); } } } ID = id; this.btn_simpan.Enabled = false; this.btn_update.Enabled = true; this.btn_hapus.Enabled = true; } } }
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; var date = menu.updated_date.Value.ToString("yyyy-M-dd hh:mm:ss"); var query = "UPDATE tbl_menu " + " SET " + " updated_by = '" + menu.updated_by + "'," + " updated_date = CAST('" + date + "' AS DATETIME2)," + " nama_menu = '" + menu.nama_menu + "'," + " harga_satuan = " + menu.harga_satuan + "," + " keterangan = '" + menu.keterangan + "'," + " foto = '" + menu.foto + "'," + " jenis =" + menu.jenis + " WHERE id = " + menu.id; ctx.Database.ExecuteSqlCommand(query); //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 }; var date = menu.created_date.Value.ToString("yyyy-M-dd hh:mm:ss"); using (var ctx = new db_dataEntities()) { //ctx.tbl_menu.Add(menu); //ctx.SaveChanges(); ctx.Database.ExecuteSqlCommand("INSERT INTO tbl_menu (is_active,created_by,created_date," + "nama_menu,harga_satuan,keterangan,foto,jenis) " + " VALUES (" + "" + menu.is_active + "," + "'" + menu.created_by + "'," + " CAST('" + date + "' AS DATETIME2)," + "'" + menu.nama_menu + "'," + "" + menu.harga_satuan + "," + "'" + menu.keterangan + "'," + "'" + menu.foto + "'," + "" + menu.jenis + ")"); var id = ctx.tbl_menu.OrderByDescending(o => o.id).FirstOrDefault(); } MessageBox.Show("Sukses Simpan"); Initial(); }
public List <tbl_menu> GetMenuTerlaris(int jenis, string terlaris, int page = 0, int size = 3) { using (var ctx = new db_dataEntities()) { var listMenuWithCount = new List <MenuWithCount>(); var menuIds = ctx.tbl_detail_order.Where(o => o.is_active == 1).Select(o => o.id_menu).Distinct().ToList(); foreach (var menuId in menuIds) { var count = 0; if (terlaris == "Minggu Ini") { var date = DateTime.Now.AddDays(-7); count = ctx.tbl_detail_order.Where(o => o.is_active == 1 && o.created_date >= date && o.created_date <= DateTime.Now && o.id_menu == menuId).Count(); } else if (terlaris == "Bulan Ini") { var date = DateTime.Now.AddMonths(-1); count = ctx.tbl_detail_order.Where(o => o.is_active == 1 && o.created_date >= date && o.created_date <= DateTime.Now && o.id_menu == menuId).Count(); } else { count = ctx.tbl_detail_order.Where(o => o.is_active == 1 && o.id_menu == menuId).Count(); } var menuWCount = new MenuWithCount { IdMenu = menuId.Value, Count = count }; listMenuWithCount.Add(menuWCount); } var idslistMenuWithCount = listMenuWithCount .OrderByDescending(c => c.Count) .Skip(page * size) .Take(size) .Select(c => c.IdMenu); var getMenu = ctx.tbl_menu .Where(o => o.jenis == jenis && idslistMenuWithCount.Contains(o.id)) .ToList(); return(getMenu); } }
public List <tbl_menu> GetMenu(int jenis, int page = 0, int size = 3) { using (var ctx = new db_dataEntities()) { var getMenu = ctx.tbl_menu .Where(o => o.jenis == jenis && o.is_active == 1) .OrderBy(o => o.nama_menu) .Skip(page * size) .Take(size) .ToList(); return(getMenu); } }
public int GetCountMenu(int jenis, int page = 0, int size = 3) { using (var ctx = new db_dataEntities()) { var getMenu = ctx.tbl_menu .Where(o => o.jenis == jenis) .OrderBy(o => o.nama_menu) .Skip(page * size) .Take(size) .Count(); return(getMenu); } }
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_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; var date = menu.deleted_date.Value.ToString("yyyy-M-dd hh:mm:ss"); var query = "UPDATE tbl_menu " + " SET " + " deleted_by = '" + menu.deleted_by + "'," + " deleted_date = CAST('" + date + "' AS DATETIME2)," + " is_active = " + menu.is_active + " WHERE id = " + menu.id; ctx.Database.ExecuteSqlCommand(query); //ctx.tbl_menu.AddOrUpdate(menu); //ctx.SaveChanges(); } MessageBox.Show("Sukses Delete"); Initial(); } else if (result == DialogResult.No) { //code for No } } }
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; var date = order.updated_date.Value.ToString("yyyy-M-dd hh:mm:ss"); var query = "UPDATE tbl_order " + " SET " + " updated_by = '" + order.updated_by + "'," + " updated_date = CAST('" + date + "' AS DATETIME2)," + " total_bayar = " + order.total_bayar + "," + " kembali = " + order.kembali + "," + " status = " + order.status + " WHERE id = " + order.id; ctx.Database.ExecuteSqlCommand(query); //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_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(); }
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 }; var date = data.created_date.Value.ToString("yyyy-M-dd hh:mm:ss"); using (var ctx = new db_dataEntities()) { var query = "INSERT INTO tbl_order (is_active,created_by,created_date," + "no_meja,subtotal,status) " + " VALUES (" + "" + data.is_active + "," + "'" + data.created_by + "'," + " CAST('" + date + "' AS DATETIME2)," + "'" + data.no_meja + "'," + "" + data.subtotal + "," + "" + data.status + ")"; ctx.Database.ExecuteSqlCommand(query); var id = ctx.tbl_order.OrderByDescending(o => o.id).FirstOrDefault(); //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 }; var date = detailOrder.created_date.Value.ToString("yyyy-M-dd hh:mm:ss"); using (var ctx = new db_dataEntities()) { var query = "INSERT INTO tbl_detail_order ([is-active],created_by,created_date," + "id_order,id_menu,qty,harga_satuan,harga_total) " + " VALUES (" + "" + detailOrder.is_active + "," + "'" + detailOrder.created_by + "'," + " CAST('" + date + "' AS DATETIME2)," + "" + detailOrder.id_order + "," + "" + detailOrder.id_menu + "," + "" + detailOrder.qty + "," + "" + detailOrder.harga_satuan + "," + "" + detailOrder.harga_total + ")"; ctx.Database.ExecuteSqlCommand(query); //ctx.tbl_detail_order.Add(detailOrder); //ctx.SaveChanges(); } } MessageBox.Show("Menu Telah Di Order"); Initial(); }
public void LoadReport(DateTime startDate, DateTime endDate) { reportViewer1.LocalReport.DataSources.Clear(); //reportViewer1.LocalReport.DataSources.Add(rptds); reportViewer1.LocalReport.Refresh(); ReportDataSource rptDS; this.reportViewer1.RefreshReport(); try { reportViewer1.LocalReport.ReportPath = Application.StartupPath + "\\Reports\\Report_Laporan.rdlc"; var ds = new DataSet_Billing(); var da = new SqlDataAdapter(); using (var ctx = new db_dataEntities()) { var listOrder = ctx.tbl_order.Where(o => EntityFunctions.TruncateTime(o.created_date.Value) >= startDate.Date && EntityFunctions.TruncateTime(o.created_date.Value) <= endDate.Date).ToList(); foreach (var getOrder in listOrder) { DataRow row; var status = ""; if (getOrder.status == 0) { status = "Belum Bayar"; } else if (getOrder.status == 1) { status = "Sudah Bayar"; } var getDetailOrder = ctx.tbl_detail_order.Where(o => o.id_order == getOrder.id).ToList(); foreach (var detailOrder in getDetailOrder) { var menu = ctx.tbl_menu.Where(o => o.id == detailOrder.id_menu).FirstOrDefault(); row = ds.Tables["DataTableLaporan"].NewRow(); row[0] = getOrder.id.ToString(); row[1] = getOrder.no_meja.ToString(); row[2] = menu.nama_menu.ToString(); row[3] = detailOrder.qty.ToString(); row[4] = menu.harga_satuan.ToString(); row[5] = detailOrder.harga_total.ToString(); row[6] = getOrder.subtotal.ToString(); row[7] = getOrder.total_bayar.ToString(); row[8] = getOrder.kembali.ToString(); row[9] = status.ToString(); row[10] = detailOrder.created_date.Value.Date.ToString(); ds.Tables["DataTableLaporan"].Rows.Add(row); } } } rptDS = new ReportDataSource("DataTableLaporan", ds.Tables["DataTableLaporan"]); reportViewer1.LocalReport.DataSources.Add(rptDS); reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); reportViewer1.ZoomMode = ZoomMode.Percent; reportViewer1.ZoomPercent = 100; } catch (Exception ex) { //MsgBox(ex.Message) } }