private void btnDelete_Click(object sender, RoutedEventArgs e) { MessageBoxResult result = MessageBox.Show("Bạn có muốn xóa dòng này?", "Confirmation", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { if (dgvChiTietPhieuDat.SelectedItem != null) { DTO_ChiTietPhieuDatHang obj = dgvChiTietPhieuDat.SelectedItem as DTO_ChiTietPhieuDatHang; String id = obj.MaChiTietPhieuDat; if (BUS_ChiTietPhieuDatHang.Instance.Delete(id)) { dgvChiTietPhieuDat.ItemsSource = BUS_ChiTietPhieuDatHang.Instance.showByPhieuDatHang(item.MaPhieuDatHang); calTongTien(true, obj.ThanhTien); } } } }
public bool insert(DTO_ChiTietPhieuDatHang obj) { using (CellphoneComponentEntities db = new CellphoneComponentEntities()) { var resultMaHangHoa = db.Database .SqlQuery <String>("select MaHangHoa from dbo.HangHoa where TenHangHoa = N'" + obj.TenHangHoa + "'") .FirstOrDefault(); ChiTietPhieuDatHang chiTietPhieuDatHang = new ChiTietPhieuDatHang(); chiTietPhieuDatHang.MaChiTietPhieuDat = obj.MaChiTietPhieuDat; chiTietPhieuDatHang.MaHangHoa = resultMaHangHoa; chiTietPhieuDatHang.MaPhieuDatHang = obj.MaPhieuDatHang; chiTietPhieuDatHang.SoLuong = obj.SoLuong; chiTietPhieuDatHang.Gia = obj.Gia; chiTietPhieuDatHang.ThanhTien = obj.ThanhTien; db.ChiTietPhieuDatHangs.Add(chiTietPhieuDatHang); if (db.SaveChanges() > 0) { return(true); } return(false); } }
public bool Insert(DTO_ChiTietPhieuDatHang obj) { return(ChiTietPhieuDatHang.Instance.insert(obj)); }