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