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