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 keuangan_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'sembarangkasirDataSet.uang_transaksi' table. You can move, or remove it, as needed. this.uang_transaksiTableAdapter.Fill(this.sembarangkasirDataSet.uang_transaksi); var db = new sembarangkasirEntities(); var result = db.uang_transaksi.ToList(); var total = 0; foreach (var lop in result) { total += Convert.ToInt32(lop.income); } lb_total.Text = "Rp " + total; //MessageBox.Show("sd" + total); }
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(); }
private void bt_login_Click(object sender, EventArgs e) { var db = new sembarangkasirEntities(); var uname = tb_username.Text; var passwd = tb_password.Text; var mhs = (from a in db.master_user where a.username == uname && a.password == passwd select a).Count(); if (mhs > 0) { this.Hide(); Form dashboard = new dashboard(); dashboard.Show(); } else { MessageBox.Show("Login Gagal"); } }