public bool InsertPBH(DTO_PhieuBanHang obj)
{
using (CellphoneComponentEntities db = new CellphoneComponentEntities())
{
var result = db.Database
.SqlQuery <String>("select MaNhanVien from dbo.NhanVien where TenNhanVien = N'" + obj.TenNhanVien + "'")
.FirstOrDefault();
PhieuBanHang phieuBanHang = new PhieuBanHang();
phieuBanHang.MaPhieuBanHang = obj.MaPhieuBanHang;
phieuBanHang.NgayBan = obj.NgayBan;
phieuBanHang.MaNhanVien = result;
phieuBanHang.TenKhachHang = obj.TenKhachHang;
phieuBanHang.SoDienThoai = obj.SoDienThoai;
phieuBanHang.TongTien = obj.TongTien;
phieuBanHang.GhiChu = obj.GhiChu;
phieuBanHang.NgayChinhSua = obj.NgayChinhSua;
db.PhieuBanHangs.Add(phieuBanHang);
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
}
public UI_LapPhieuBanHang(DTO_PhieuBanHang obj)
{
InitializeComponent();
txtMaPhieuBanHang.Text = obj.MaPhieuBanHang;
dpNgayLap.SelectedDate = obj.NgayBan;
dpNgayChinhSua.SelectedDate = obj.NgayChinhSua;
txtTenNhanVien.Text = obj.TenNhanVien;
txtTenKhachHang.Text = obj.TenKhachHang;
txtSoDienThoai.Text = obj.SoDienThoai;
txtGhiChu.Text = obj.GhiChu;
txtTongTien.Text = obj.TongTien.ToString();
isNew = false;
loadCombobox();
loadChiTiet(obj.MaPhieuBanHang);
}
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 (dgvPhieuBanHang.SelectedItem != null)
{
DTO_PhieuBanHang obj = dgvPhieuBanHang.SelectedItem as DTO_PhieuBanHang;
String id = obj.MaPhieuBanHang;
if (BUS_PhieuBanHang.Delete(id))
{
dgvPhieuBanHang.ItemsSource = BUS_PhieuBanHang.showData();
}
else
{
MessageBox.Show("Xóa thất bại!");
}
}
}
}
public bool Update(DTO_PhieuBanHang obj)
{
return(PhieuBanHang.Instance.update(obj));
}
public bool InsertPBH(DTO_PhieuBanHang obj)
{
return(PhieuBanHang.Instance.InsertPBH(obj));
}
