private void bttach_Click(object sender, EventArgs e) { using (DatabaseQLTSEntities quanli = new DatabaseQLTSEntities()) { PhieuXuat px = new PhieuXuat(); px.TenDangNhap = username.Trim(); px.ThoiGianLap = DateTime.Now; quanli.PhieuXuats.Add(px); quanli.SaveChanges(); foreach (DataGridViewRow item in dgvnguyenlieu.Rows) { int manl = int.Parse(item.Cells["manl"].Value.ToString()); NguyenLieu nl = quanli.NguyenLieux.FirstOrDefault(p => p.IdNguyenLieu == manl); if (nl != null) { nl.SoLuong = nl.SoLuong - float.Parse(item.Cells["slnl"].Value.ToString()); quanli.SaveChanges(); } CTPhieuXuat ct = new CTPhieuXuat(); ct.IdPhieuXuat = px.IdPhieuXuat; ct.IdNguyenLieu = manl; ct.SoLuong = float.Parse(item.Cells["slnl"].Value.ToString()); quanli.CTPhieuXuats.Add(ct); quanli.SaveChanges(); } MessageBox.Show("Đã Xuất !"); this.Close(); } }
public void loadnl() { using (DatabaseQLTSEntities quanli = new DatabaseQLTSEntities()) { NguyenLieu nl = quanli.NguyenLieux.FirstOrDefault(p => p.IdNguyenLieu == manl); txttennl.Text = nl.TenNguyenLieu; txtsoluong.Text = ""; cbdvt.Text = nl.DonViTinh; } }