// add product for invoice
public void FuncAddProduct(tblChiTietHoaDonBanHang invoiceDetail)
{
db.tblChiTietHoaDonBanHangs.Add(invoiceDetail);
var product = db.tblHangHoas.Find(invoiceDetail.MaHangHoa); // change quantity product after add
product.SoLuong -= (int)invoiceDetail.SoLuong;
var invoice = db.tblHoaDonBanHangs.Find(invoiceDetail.MaHoaDonBan);
invoice.SoTien += invoiceDetail.TongTien;
db.SaveChanges();
}
// delete product - invoice
public void FuncDeleteProduct(List <string> listIdProduct, string idInvoice)
{
foreach (string idProduct in listIdProduct)
{
tblChiTietHoaDonBanHang invoiceDetail = db.tblChiTietHoaDonBanHangs.Find(idInvoice, idProduct);
var product = db.tblHangHoas.Find(idProduct);
product.SoLuong += (int)invoiceDetail.SoLuong;
var invoice = db.tblHoaDonBanHangs.Find(idInvoice);
invoice.SoTien -= (double)invoiceDetail.TongTien;
db.tblChiTietHoaDonBanHangs.Remove(invoiceDetail);
db.SaveChanges();
}
}
private void btnADD_PRODUCT_Click(object sender, EventArgs e)
{
SALEMANAGEMENT_DB DB = new SALEMANAGEMENT_DB();
idProduct = dgvProduct.SelectedRows[0].Cells["MaHangHoa"].Value.ToString();
productQty = Convert.ToInt32(txtQUANTITY.Text);
pricePro = Convert.ToDouble(dgvProduct.SelectedRows[0].Cells["GiaBan"].Value.ToString());
discount = Convert.ToInt32(txtDISCOUNT.Text);
if (productQty > Convert.ToInt32(dgvProduct.SelectedRows[0].Cells["SoLuong"].Value.ToString()))
{
lbSTATUS.Text = "KHÔNG ĐỦ SL";
}
else
{
lbSTATUS.Text = "";
tblChiTietHoaDonBanHang invoiceDetail = new tblChiTietHoaDonBanHang();
invoiceDetail.MaHoaDonBan = idInvoice;
invoiceDetail.MaHangHoa = idProduct;
invoiceDetail.SoLuong = productQty;
invoiceDetail.DonGia = pricePro;
invoiceDetail.GiamGia = discount;
invoiceDetail.TongTien = pricePro * productQty - pricePro * productQty * discount / 100;
DB.tblChiTietHoaDonBanHangs.Add(invoiceDetail);
var product = DB.tblHangHoas.Find(idProduct);
product.SoLuong -= productQty;
var invoice = DB.tblHoaDonBanHangs.Find(idInvoice);
invoice.SoTien += invoiceDetail.TongTien;
DB.SaveChanges();
d(idInvoice);
DialogResult dR = MessageBox.Show("Thêm thành công hàng hóa. Bạn có muốn tiếp tục thêm?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dR == DialogResult.Yes)
{
ShowProduct();
}
else
{
this.Close();
}
}
}
// add product for invoice
private void btnAddProductForInvoice_Click(object sender, EventArgs e)
{
idProduct = dgvProduct.SelectedRows[0].Cells["MaHangHoa"].Value.ToString();
quantityProduct = Convert.ToInt32(txtQuantity.Text.Trim());
productPrice = Convert.ToDouble(dgvProduct.SelectedRows[0].Cells[3].Value.ToString());
discount = Convert.ToInt32(txtDiscount.Text.Trim());
switch (isListSale)
{
case true:
if (quantityProduct > Convert.ToInt32(dgvProduct.SelectedRows[0].Cells["SoLuong"].Value.ToString()))
{
lbSTATUS.Text = "KHÔNG ĐỦ SL";
}
else
{
lbSTATUS.Text = "";
if (BLL_LISTSALEINVOICE.Instance.isHasProductInInvoice(idInvoice, idProduct))
{
MessageBox.Show("Hàng hóa đã tồn tại trong hóa đơn!", "Trùng hàng hóa",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
tblChiTietHoaDonBanHang invoiceDetail = new tblChiTietHoaDonBanHang();
invoiceDetail.MaHoaDonBan = idInvoice;
invoiceDetail.MaHangHoa = idProduct;
invoiceDetail.SoLuong = quantityProduct;
invoiceDetail.DonGia = productPrice;
invoiceDetail.GiamGia = discount;
invoiceDetail.TongTien = productPrice * quantityProduct - productPrice * quantityProduct
* discount / 100;
BLL_LISTSALEINVOICE.Instance.FuncAddProduct(invoiceDetail);
DialogResult answer = MessageBox.Show("Thêm thành công hàng hóa. Bạn có muốn tiếp tục thêm?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (answer == DialogResult.Yes)
{
LoadProduct();
}
else
{
d(idInvoice);
this.Close();
}
}
}
break;
case false:
if (BLL_LISTIMPORTINVOICE.Instance.isHasProductInInvoice(idInvoice, idProduct))
{
MessageBox.Show("Hàng hóa đã tồn tại trong hóa đơn!", "Trùng hàng hóa",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
tblChiTietHoaDonNhapHang invoicedetail = new tblChiTietHoaDonNhapHang();
invoicedetail.MaHoaDonNhap = idInvoice;
invoicedetail.MaHangHoa = idProduct;
invoicedetail.SoLuong = quantityProduct;
invoicedetail.GiaNhap = productPrice;
invoicedetail.TongTien = productPrice * quantityProduct;
BLL_LISTIMPORTINVOICE.Instance.FuncAddProduct(invoicedetail);
DialogResult answer = MessageBox.Show("Thêm thành công hàng hóa. Bạn có muốn tiếp tục thêm?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (answer == DialogResult.Yes)
{
LoadProduct();
}
else
{
d(idInvoice);
this.Close();
}
}
break;
default:
break;
}
}
