public ThongTinHoaDonDTO GETDTO(int tenKM, int idHoaDon)
{
DataTable data = DataProvider.Instance.ExecuteQuery("Select * From ThongTinHoaDon WHERE idSanPham =" + tenKM + " AND idHoaDon =" + idHoaDon);
if (data.Rows.Count > 0)
{
ThongTinHoaDonDTO km = new ThongTinHoaDonDTO(data.Rows[0]);
return(km);
}
return(null);
}
private void btSangTraiAll_Click(object sender, EventArgs e)
{
int idBanPhai = BanDAO.Instance.GetIdBanByTen(cbxBanPhai.Text);
int idHoaDonTrai = HoaDonDAO.Instance.LayIDHoaDonChuaThanhToanBangIDBan(_ban.ID);
int idHoaDonPhai = HoaDonDAO.Instance.LayIDHoaDonChuaThanhToanBangIDBan(idBanPhai);
try
{
if (idHoaDonTrai == -1)
{
if (MessageBox.Show(cbxBanPhai.Text + " chưa có hóa đơn !! Bạn có muốn tạo hóa đơn không ?", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
{
while (lsvTableTo.Items.Count > 0)
{
ListViewItem temp = lsvTableTo.Items[0];
lsvTableTo.Items.Remove(temp);
lsvTableFrom.Items.Add(temp);
string tenMon = temp.Text;
int idSanPham = SanPhamDAO.Instance.GetIDByTenSP(tenMon);
ThongTinHoaDonDTO thongtin = ThongTinHoaDonDAO.Instance.GETDTO(idSanPham, idHoaDonPhai);
int x = thongtin.SoLuong;
ThongTinHoaDonDAO.Instance.ChuyenNMon(idHoaDonPhai, idSanPham, _ban.ID, idBanPhai);
BanDAO.Instance.UpdateTrangThaiBan(idHoaDonTrai);
}
HoaDonDAO.Instance.DeleteBillTrong(idHoaDonPhai);
BanDAO.Instance.UpdateStatusTable(idBanPhai);
}
}
else
{
while (lsvTableTo.Items.Count > 0)
{
ListViewItem temp = lsvTableTo.Items[0];
lsvTableTo.Items.Remove(temp);
lsvTableFrom.Items.Add(temp);
string tenMon = temp.Text;
int idSanPham = SanPhamDAO.Instance.GetIDByTenSP(tenMon);
ThongTinHoaDonDTO thongtin = ThongTinHoaDonDAO.Instance.GETDTO(idSanPham, idHoaDonPhai);
int x = thongtin.SoLuong;
ThongTinHoaDonDAO.Instance.ChuyenNMon(idHoaDonPhai, idSanPham, _ban.ID, idBanPhai);
}
HoaDonDAO.Instance.DeleteBillTrong(idHoaDonPhai);
BanDAO.Instance.UpdateStatusTable(idBanPhai);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
