private void btnLuuHDNhap_Click(object sender, EventArgs e)
{
// Lấy mã hóa đơn vừa nhập
HDNhapHangDTO HDNhap = new HDNhapHangDTO();
HDNhap.MaNV = 1;
int id = HDNhapBUS.Them(HDNhap);
bool isThanhCong = true;
// Duyệt danh sách chi tiết hóa đơn (DataGridView)
foreach (DataGridViewRow row in dgvDSCTHDNhap.Rows)
{
CTHDNhapHangDTO CTHDNhap = new CTHDNhapHangDTO();
CTHDNhap.MaHD = id;
CTHDNhap.MaSach = Convert.ToInt32(row.Cells["colMaSach_CTHD"].Value);
CTHDNhap.SoLuong = Convert.ToInt32(row.Cells["colSoLuong_CTHD"].Value);
CTHDNhap.GiaBia = Convert.ToInt32(row.Cells["colGiaBia_CTHD"].Value);
isThanhCong = CTHDNhapBUS.Them(CTHDNhap);
if (!isThanhCong)
{
break;
}
sBUS.CapNhatSoLuongGiaBia(CTHDNhap.MaSach, CTHDNhap.SoLuong, CTHDNhap.GiaBia, CTHDNhap.GiaNhap);
}
if (isThanhCong)
{
MessageBox.Show("Lưu hoá đơn thành công!");
bdsSach.DataSource = sBUS.LayDanhSach();
}
else
{
MessageBox.Show("Lưu hoá đơn không thành công!");
}
dgvDSCTHDNhap.Rows.Clear();
}
public void getRow(CTHDNhapHangDTO ctnh, string tenhh, string ghiChu)
{
DataGridViewRow row = (DataGridViewRow)dtgNhaphang.Rows[0].Clone();
row.Cells[1].Value = ctnh.MaHDNH;
row.Cells[2].Value = tenhh;
row.Cells[3].Value = ctnh.Dvt;
row.Cells[4].Value = ctnh.Sl;
row.Cells[5].Value = ctnh.DonGia;
row.Cells[6].Value = ctnh.ThanhTien;
row.Cells[7].Value = ghiChu;
dtgNhaphang.Rows.Add(row);
kiemTraRowTrungValue();
}
public bool Them(CTHDNhapHangDTO CTHDNhapDTO)
{
conn.Open();
string SQL = string.Format("INSERT INTO [dbo].[CTHDNhapHang] ([MaHD],[MaSach],[SoLuong],[GiaBia],[GiaNhap]) " +
"VALUES ({0},{1},{2},{3},{4})", CTHDNhapDTO.MaHD, CTHDNhapDTO.MaSach, CTHDNhapDTO.SoLuong, CTHDNhapDTO.GiaBia, CTHDNhapDTO.GiaNhap);
SqlCommand com = new SqlCommand(SQL, conn);
int kq = com.ExecuteNonQuery();
conn.Close();
if (kq > 0)
{
return(true);
}
return(false);
}
void eventDeThemHangHoaVaoHoaDon()
{
CTHDNhapHangDTO ctnh = new CTHDNhapHangDTO();
ctnh.MaHDNH = Convert.ToInt32(txtMahh.Text);
string tehh = txtTenHH.Text;
ctnh.Dvt = lblDonvitinh.Text;
ctnh.Sl = Convert.ToInt32(txtSoluong.Text);
ctnh.DonGia = Convert.ToInt32(txtGiamua.Text);
ctnh.ThanhTien = Convert.ToInt32(txtThanhtien.Text);
string ghiChu = txtGhichu.Text;
eventGetRow(ctnh, tehh, ghiChu);
}
private void btnThanhtoan_Click(object sender, EventArgs e)
{
mangCTHD = new ArrayList();
for (int i = 0; i < dtgNhaphang.Rows.Count - 1; i++)
{
CTHDNhapHangDTO cTHDNhap = new CTHDNhapHangDTO();
cTHDNhap.SanPham = Convert.ToInt32(dtgNhaphang.Rows[i].Cells[1].Value.ToString());
cTHDNhap.Sl = Convert.ToInt32(dtgNhaphang.Rows[i].Cells[4].Value.ToString());
cTHDNhap.DonGia = Convert.ToDecimal(dtgNhaphang.Rows[i].Cells[5].Value.ToString());
mangCTHD.Add(cTHDNhap);
}
cbTenncc.ValueMember = "MaNCC";
string maNCC = cbTenncc.SelectedValue.ToString();
string tenNCC = cbTenncc.Text;
string tienHang = lblTongcong.Text;
string noCuCuaHang = lblNocucuahang.Text;
ThanhToan tt = new ThanhToan(tenNCC, tienHang, noCuCuaHang, maNCC, mangCTHD);
tt.eventLuu += thanhToan;
tt.ShowDialog();
}
public bool Them(CTHDNhapHangDTO CTHDNhapDTO)
{
return(CTHDNhapDAO.Them(CTHDNhapDTO));
}
