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