private void themPhuKien() { string tenphukien = cbTen.Text; using (quanlithucungEntities1 quanli = new quanlithucungEntities1()) { PHUKIEN pk = quanli.PHUKIENs.FirstOrDefault(p => p.Tenphukien.ToLower() == tenphukien.ToLower()); if (pk == null) { Console.WriteLine("aa"); quanli.insertCTPK(mapn, int.Parse(txtSoLuong.Text), double.Parse(txtGia.Text), tenphukien, cbLoai.SelectedValue.ToString(), null, txtdonvi.Text); quanli.SaveChanges(); MessageBox.Show("Thêm thành công"); } else { pk.Soluong += int.Parse(txtSoLuong.Text); CTNhapPhuKien pkm = new CTNhapPhuKien(); pkm.MaPN = mapn; pkm.MaPhuKien = pk.Maphukien; pkm.TenPhuKien = pk.Tenphukien; pkm.MaLoai = cbLoai.SelectedValue.ToString(); pkm.GiaNhap = double.Parse(txtGia.Text); pkm.Soluong = int.Parse(txtSoLuong.Text); pkm.Donvi = txtdonvi.Text; pkm.Anh = pk.HinhAnh; quanli.CTNhapPhuKiens.Add(pkm); quanli.SaveChanges(); MessageBox.Show("Thêm thành công"); } } }
private void btnSua_Click(object sender, EventArgs e) { using (quanlithucungEntities1 quanli = new quanlithucungEntities1()) { CTNhapPhuKien sua = quanli.CTNhapPhuKiens.FirstOrDefault(p => p.MaPN == txtmaphieunhap.Text); sua.MaPN = txtmaphieunhap.Text; //sua.MaPhuKien = txtmaphukien.Text; sua.TenPhuKien = txttenphukien.Text; //sua.LoaiPhuKien = cbLoaiPhuKien.Text; sua.Soluong = int.Parse(txtSoluong.Text); sua.GiaNhap = double.Parse(txtGianhap.Text); quanli.SaveChanges(); loaddulieu(); } }
private void btnThem_Click(object sender, EventArgs e) { using (quanlithucungEntities1 quanli = new quanlithucungEntities1()) { CTNhapPhuKien them = new CTNhapPhuKien(); them.MaPN = txtmaphieunhap.Text; //them.MaPhuKien = txtmaphukien.Text; //them.LoaiPhuKien = cbLoaiPhuKien.Text; them.TenPhuKien = txttenphukien.Text; them.Soluong = int.Parse(txtSoluong.Text); them.GiaNhap = double.Parse(txtGianhap.Text); quanli.CTNhapPhuKiens.Add(them); quanli.SaveChanges(); loaddulieu(); } }