private void btn_beli_Click(object sender, EventArgs e) { var db = new sembarangkasirEntities(); var transaksi = new transaksi(); var qty_pembelian = Convert.ToInt32(cb_qty.SelectedItem.ToString()); var id_brg_pembelian = Convert.ToInt32(idTextBox.Text); DateTime today = DateTime.Today; transaksi.tanggal = today; transaksi.id_barang = id_brg_pembelian; transaksi.qty = qty_pembelian; db.transaksi.Add(transaksi); db.SaveChanges(); var barang = (from a in db.master_barang where a.id == id_brg_pembelian select a).Single(); var stock_new = barang.stock - qty_pembelian; var harga = barang.harga; barang.stock = stock_new; db.SaveChanges(); int transaksi_id = db.transaksi.Max(p => p.id); //MessageBox.Show("sdsd"+max); var money = new uang_transaksi(); money.id_transaksi = transaksi_id; money.income = harga * qty_pembelian; db.uang_transaksi.Add(money); db.SaveChanges(); MessageBox.Show("pembelian berhasil !"); this.master_barangTableAdapter.Fill(this.sembarangkasirDataSet.master_barang); }
private void master_restockBindingNavigatorSaveItem_Click(object sender, EventArgs e) { this.Validate(); this.master_restockBindingSource.EndEdit(); this.tableAdapterManager.UpdateAll(this.sembarangkasirDataSet); // update stock data on table barang var db = new sembarangkasirEntities(); var id_barang = Convert.ToInt32(id_barangComboBox.SelectedValue.ToString()); var qty = Convert.ToInt32(qtyTextBox.Text); var barang = (from a in db.master_barang where a.id == id_barang select a).Single(); var stock_new = barang.stock + qty; barang.stock = stock_new; db.SaveChanges(); }