public bool ThemHD(HoaDonNhap_DTO hd)
{
SqlConnection con = DataProvider.TaoKetNoi();
string query = "ThemHoaDonNhap";
SqlCommand cm = new SqlCommand(query, con);
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@idNhanVien", hd.idNhanVien);
cm.Parameters.AddWithValue("@maNCC", hd.maNCC);
cm.Parameters.AddWithValue("@ngayNhap", hd.ngayNhap);
cm.Parameters.AddWithValue("@tongTien", hd.tongTien);
cm.Parameters.AddWithValue("@trangThai", hd.trangThai);
int NumOfRow = cm.ExecuteNonQuery();
con.Close();
if (NumOfRow > 0)
{
return(true);
}
else
{
return(false);
}
}
private void btnHuyHoaDon_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn có chắc muốn hủy hóa đơn nhập này ??", "Thông Báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
{
HoaDonNhap_DTO hd_nhap = (lvHoaDon.Tag as HoaDonNhap_DTO);
HuyNhap(hd_nhap);
ResetNCC();
}
}
private void btnNhapKho_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Bạn muốn nhập hàng từ nhà cung cấp: " + txtTenNCC.Text + "\nVới tổng giá trị hàng là:" + txtTongTien.Text + " VND", "Thông Báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK)
{
HoaDonNhap_DTO hd_nhap = (lvHoaDon.Tag as HoaDonNhap_DTO);
NhapKho(hd_nhap);
ResetNCC();
}
}
void HuyNhap(HoaDonNhap_DTO hd_nhap)
{
HoaDonNhap_BUS hd_bus = new HoaDonNhap_BUS();
if (hd_bus.Huy(hd_nhap.id, int.Parse(txtTongTien.Text)))
{
LoadHDNhap();
MessageBox.Show("Hủy Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
txtMaNCC.Enabled = true;
btnHuyHoaDon.Enabled = false;
btnNhapKho.Enabled = false;
}
public HoaDonNhap_DTO LayHoaDonChuaNhapTheoMaNCC(string maNCC)
{
HoaDonNhap_DTO hd_nhap = new HoaDonNhap_DTO();
SqlConnection con = DataProvider.TaoKetNoi();
if (con != null)
{
SqlCommand command = new SqlCommand();
command.CommandText = @"SELECT * FROM HoaDonNhap WHERE trangThai = 0 and maNCC = '" + maNCC + "'";
command.Connection = con;
SqlDataReader dataReader = command.ExecuteReader();
if (dataReader.Read())
{
if (dataReader.IsDBNull(0) != null)
{
hd_nhap.id = (int)dataReader[0];
}
if (dataReader.IsDBNull(1) != null)
{
hd_nhap.idNhanVien = dataReader["idNhanvien"].ToString();
}
if (dataReader.IsDBNull(2) != null)
{
hd_nhap.maNCC = dataReader["maNCC"].ToString();
}
if (dataReader.IsDBNull(3) != null)
{
hd_nhap.ngayNhap = (DateTime?)dataReader["ngayNhap"];
}
if (dataReader.IsDBNull(4) != null)
{
hd_nhap.tongTien = (int)dataReader["tongTien"];
}
if (dataReader.IsDBNull(5) != null)
{
hd_nhap.trangThai = (int)dataReader["trangThai"];
}
}
dataReader.Close();
con.Close();
}
return(hd_nhap);
}
void NhapKho(HoaDonNhap_DTO hd_nhap)
{
HienThiHoaDonNhap_BUS hthdnhap_bus = new HienThiHoaDonNhap_BUS();
List <HienThiHoaDonNhap_DTO> listHTHD = hthdnhap_bus.LayDanhSachTheoIDHoaDonNhap(hd_nhap.id);
BangSize_BUS size_bus = new BangSize_BUS();
foreach (HienThiHoaDonNhap_DTO item in listHTHD)
{
size_bus.CapNhatKho(item.idGiay, item.size, item.soLuong, item.donGia);
}
HoaDonNhap_BUS hd_bus = new HoaDonNhap_BUS();
if (hd_bus.NhapKho(hd_nhap.id, int.Parse(txtTongTien.Text)))
{
LoadHDNhap();
MessageBox.Show("Thanh Toán Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
txtMaNCC.Enabled = true;
btnHuyHoaDon.Enabled = false;
btnNhapKho.Enabled = false;
}
private void btnThemSP_Click(object sender, EventArgs e)
{
if (txtTenGiay.Text != "")
{
txtMaNCC.Enabled = false;
HoaDonNhap_BUS hdnhap_bus = new HoaDonNhap_BUS();
ChiTietHoaDonNhap_BUS cthdnhap_bus = new ChiTietHoaDonNhap_BUS();
HoaDonNhap_DTO hd_nhap = new HoaDonNhap_DTO();
hd_nhap = hdnhap_bus.LayHoaDonChuaNhapTheoMaNCC(txtMaNCC.Text);
if (hd_nhap.id == -1)
{
HoaDonNhap_DTO hdnhap_moi = new HoaDonNhap_DTO(-1, BienToanCuc.nvDangNhap.idNhanVien, txtMaNCC.Text, DateTime.Now, 0, 0);
if (hdnhap_bus.Them(hdnhap_moi))
{
ChiTietHoaDonNhap_DTO cthd_nhap = new ChiTietHoaDonNhap_DTO(hdnhap_bus.LastID(), idGiay, cbSize.Text, int.Parse(txtSoLuongNhap.Text), int.Parse(txtGiaNhap.Text));
cthdnhap_bus.Them(cthd_nhap);
HienThiCTHoaDonNhap(hdnhap_bus.LastID());
lvHoaDon.Tag = hdnhap_bus.LayHoaDonChuaNhapTheoMaNCC(txtMaNCC.Text);
LoadHDNhap();
}
}
else
{
ChiTietHoaDonNhap_DTO cthd_nhap = new ChiTietHoaDonNhap_DTO(hd_nhap.id, idGiay, cbSize.Text, int.Parse(txtSoLuongNhap.Text), int.Parse(txtGiaNhap.Text));
cthdnhap_bus.Them(cthd_nhap);
HienThiCTHoaDonNhap(hd_nhap.id);
lvHoaDon.Tag = hd_nhap;
LoadHDNhap();
}
ResetSP();
}
else
{
MessageBox.Show("Vui lòng chọn sản phẩm !!", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
void LoadHDNhap()
{
if (txtMaNCC.Text != "")
{
HoaDonNhap_BUS hdnhap_bus = new HoaDonNhap_BUS();
HoaDonNhap_DTO hd_nhap = new HoaDonNhap_DTO();
hd_nhap = hdnhap_bus.LayHoaDonChuaNhapTheoMaNCC(txtMaNCC.Text);
lvHoaDon.Tag = hd_nhap;
if (hd_nhap.id == -1)
{
lvHoaDon.Items.Clear();
btnHuyHoaDon.Enabled = false;
btnNhapKho.Enabled = false;
txtTongTien.Text = "0";
}
else
{
btnHuyHoaDon.Enabled = true;
btnNhapKho.Enabled = true;
HienThiCTHoaDonNhap(hd_nhap.id);
txtTongTien.Text = hd_nhap.tongTien.ToString();
}
}
}
public bool Them(HoaDonNhap_DTO hd_nhap)
{
HoaDonNhap_DAO objHoaDonNhap_DAO = new HoaDonNhap_DAO();
return(objHoaDonNhap_DAO.ThemHD(hd_nhap));
}
