public bool insert(DTO_PhieuDatHang obj)
{
using (CellphoneComponentEntities db = new CellphoneComponentEntities())
{
var resultMaNhanVien = db.Database
.SqlQuery <String>("select MaNhanVien from dbo.NhanVien where TenNhanVien = N'" + obj.TenNhanVien + "'")
.FirstOrDefault();
var resultMaNhaCungCap = db.Database
.SqlQuery <String>("select MaNhaCungCap from dbo.NhaCungCap where TenNhaCungCap = N'" + obj.TenNhaCungCap + "'")
.FirstOrDefault();
PhieuDatHang phieuDatHang = new PhieuDatHang();
phieuDatHang.MaPhieuDatHang = obj.MaPhieuDatHang;
phieuDatHang.MaNhaCungCap = resultMaNhaCungCap;
phieuDatHang.MaNhanVien = resultMaNhanVien;
phieuDatHang.NgayChinhSua = obj.NgayChinhSua;
phieuDatHang.NgayDat = obj.NgayDat;
phieuDatHang.TongTien = obj.TongTien;
phieuDatHang.GhiChu = obj.GhiChu;
db.PhieuDatHangs.Add(phieuDatHang);
if (db.SaveChanges() > 0)
{
return(true);
}
return(false);
}
}
public UI_LapPhieuDatHang(DTO_PhieuDatHang obj)
{
InitializeComponent();
cbbNhaCungCap.ItemsSource = BUS_NhaCungCap.showData();
getDataFromEditUI(obj);
checkGroupCTPN(isNew = false, obj);
}
private void getDataFromEditUI(DTO_PhieuDatHang obj)
{
txtMaPhieuDatHang.Text = obj.MaPhieuDatHang;
dpNgayLap.SelectedDate = obj.NgayDat;
dpNgayChinhSua.SelectedDate = obj.NgayChinhSua;
cbbNhaCungCap.SelectedValue = obj.TenNhaCungCap;
txtTenNhanVien.Text = obj.TenNhanVien;
txtGhiChu.Text = obj.GhiChu;
txtTongTien.Text = obj.TongTien.ToString();
isNew = false;
}
private void checkGroupCTPN(bool isNew, DTO_PhieuDatHang phieuDatHang)
{
if (isNew)
{
groupCTPN.IsEnabled = false;
}
else
{
groupCTPN.IsEnabled = true;
generateChiTietID();
loadCombobox();
dgvChiTietPhieuDat.ItemsSource = BUS_ChiTietPhieuDatHang.Instance.showByPhieuDatHang(item.MaPhieuDatHang);
}
}
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 (dgvPhieuDatHang.SelectedItem != null)
{
DTO_PhieuDatHang obj = new DTO_PhieuDatHang();
obj = dgvPhieuDatHang.SelectedItem as DTO_PhieuDatHang;
String id = obj.MaPhieuDatHang;
if (BUS_PhieuDatHang.Instance.Delete(id))
{
dgvPhieuDatHang.ItemsSource = BUS_PhieuNhap.showData();
}
else
{
MessageBox.Show("Xóa không thành công!!");
}
}
}
}
public bool Update(DTO_PhieuDatHang obj)
{
return(PhieuDatHang.Instance.update(obj));
}
public bool Insert(DTO_PhieuDatHang obj)
{
return(PhieuDatHang.Instance.insert(obj));
}
