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