private void btnLuu_Click(object sender, EventArgs e)
{
if (txtSoLuong.Text.Trim() == "" || txtSoLuong.Text == null || Convert.ToInt32(txtSoLuong.Text) == 0)
{
MessageBox.Show("Vui lòng kiểm tra lại số lượng", "Lỗi");
}
else if (Convert.ToInt32(txtSoLuong.Text) > Convert.ToInt32(lbSoLuongTon.Text))
{
//đã xử lý sự kiện trong textleave
txtSoLuong.Focus();
}
else
{
var HDX = dt.selectTTHDX(Convert.ToInt32(lbMaHD.Text)).FirstOrDefault();
if (HDX == null)
{
Image QR;
Zen.Barcode.CodeQrBarcodeDraw qr = Zen.Barcode.BarcodeDrawFactory.CodeQr;
QR = qr.Draw(lbMaHD.Text, 50);
MemoryStream stream = new MemoryStream();
QR.Save(stream, ImageFormat.Jpeg);
dt.insertHDX(Convert.ToInt32(lbMaHD.Text), MaKH, FormDangNhap.ThongTinNVDangNhap.MaNVDangNhap, Convert.ToDateTime(DateTime.Now), null, stream.ToArray());
dt.insertCTHDX(Convert.ToInt32(lbMaHD.Text), Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue),
Convert.ToInt32(cbbMau.SelectedValue), Convert.ToInt32(txtSoLuong.Text),
dongia * Convert.ToInt32(txtSoLuong.Text));
dt.updateTongTienHDX(Convert.ToInt32(lbMaHD.Text), dongia * Convert.ToInt32(txtSoLuong.Text));
dt.updateSLT(Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue),
Convert.ToInt32(cbbMau.SelectedValue), Convert.ToInt32(lbSoLuongTon.Text) - Convert.ToInt32(txtSoLuong.Text));
dgvCTHDX.AutoGenerateColumns = false;
dgvCTHDX.DataSource = dt.selectCTHDX(Convert.ToInt32(lbMaHD.Text));
MessageBox.Show("Thêm thành công");
cbbSP.Enabled = false;
cbbSize.Enabled = false;
cbbMau.Enabled = false;
btnThem.Enabled = true;
btnLuu.Enabled = false;
btnHuy.Enabled = true;
txtSoLuong.ResetText();
lbThanhTien.Text = "0";
txtSoLuong.Enabled = false;
lbTren.Visible = false;
lbSoLuongTon.Visible = false;
lbDonGia.Visible = false;
lbThanhTien.Visible = false;
}
else if (HDX != null)
{
var CTHDX = dt.selectTTCTHDX(Convert.ToInt32(lbMaHD.Text), Convert.ToInt32(cbbSP.SelectedValue),
Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue)).FirstOrDefault();
if (CTHDX == null)
{
dt.insertCTHDX(Convert.ToInt32(lbMaHD.Text), Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue),
Convert.ToInt32(cbbMau.SelectedValue), Convert.ToInt32(txtSoLuong.Text),
dongia * Convert.ToInt32(txtSoLuong.Text));
int tongtien = 0;
foreach (var a in dt.selectCTHDX(Convert.ToInt32(lbMaHD.Text)))
{
tongtien = tongtien + Convert.ToInt32(a.ThanhTien);
}
dt.updateTongTienHDX(Convert.ToInt32(lbMaHD.Text), tongtien);
dt.updateSLT(Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue),
Convert.ToInt32(cbbMau.SelectedValue), Convert.ToInt32(lbSoLuongTon.Text) - Convert.ToInt32(txtSoLuong.Text));
dgvCTHDX.AutoGenerateColumns = false;
dgvCTHDX.DataSource = dt.selectCTHDX(Convert.ToInt32(lbMaHD.Text));
MessageBox.Show("Thêm sản phẩm thành công");
}
else if (CTHDX != null)
{
var TTCTHDX = dt.selectTTCTHDX(Convert.ToInt32(lbMaHD.Text), Convert.ToInt32(cbbSP.SelectedValue),
Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue)).FirstOrDefault();
dt.updateSoLuongTTCTHDX(Convert.ToInt32(lbMaHD.Text), Convert.ToInt32(cbbSP.SelectedValue),
Convert.ToInt32(cbbSize.SelectedValue), Convert.ToInt32(cbbMau.SelectedValue),
(TTCTHDX.SoLuong + Convert.ToInt32(txtSoLuong.Text)),
(TTCTHDX.ThanhTien + (Convert.ToInt32(txtSoLuong.Text) * dongia)));
int tongtien = 0;
foreach (var a in dt.selectCTHDX(Convert.ToInt32(lbMaHD.Text)))
{
tongtien = tongtien + Convert.ToInt32(a.ThanhTien);
}
dt.updateTongTienHDX(Convert.ToInt32(lbMaHD.Text), tongtien);
dt.updateSLT(Convert.ToInt32(cbbSP.SelectedValue), Convert.ToInt32(cbbSize.SelectedValue),
Convert.ToInt32(cbbMau.SelectedValue), Convert.ToInt32(lbSoLuongTon.Text) - Convert.ToInt32(txtSoLuong.Text));
dgvCTHDX.AutoGenerateColumns = false;
dgvCTHDX.DataSource = dt.selectCTHDX(Convert.ToInt32(lbMaHD.Text));
MessageBox.Show("Thêm số lượng thành công");
}
cbbSP.Enabled = false;
cbbSize.Enabled = false;
cbbMau.Enabled = false;
btnThem.Enabled = true;
btnLuu.Enabled = false;
btnHuy.Enabled = true;
txtSoLuong.ResetText();
lbThanhTien.Text = "0";
txtSoLuong.Enabled = false;
lbTren.Visible = false;
lbSoLuongTon.Visible = false;
lbDonGia.Visible = false;
lbThanhTien.Visible = false;
gunaGradientCircleButton1.Visible = false;
txtTimKiem.Visible = false;
dgvSanPham.Visible = false;
}
}
}
private void btnThem_Click(object sender, EventArgs e)
{
var HDX = dt.selectHoaDon(lbMaHD.Text).FirstOrDefault();
if (txtSL.Text.Trim() == "" || txtSL.Text.Trim() == null)
{
MessageBox.Show("Bạn chưa nhập số lượng", "Thông báo");
}
else if (Convert.ToInt32(txtSL.Text) == 0)
{
MessageBox.Show("Số lượng phải lớn hơn 0");
}
else
{
if (HDX == null)
{
Image QR;
Zen.Barcode.CodeQrBarcodeDraw qr = Zen.Barcode.BarcodeDrawFactory.CodeQr;
QR = qr.Draw(lbMaHD.Text, 50);
MemoryStream stream = new MemoryStream();
QR.Save(stream, ImageFormat.Jpeg);
dt.Insert_HoaDon(lbMaHD.Text, Convert.ToString(cbbMaKH.SelectedValue), DangNhap.TTNV.MaNV,
Convert.ToDateTime(DateTime.Now), Convert.ToInt32(numericChietKhau.Value), 0, Convert.ToBoolean("true"), stream.ToArray());
dt.INSERT_CTHD(lbMaHD.Text, cbbTenSP.SelectedValue.ToString(), Convert.ToInt32(txtSL.Text),
(Convert.ToDouble(txtSL.Text) * Convert.ToDouble(lbDongia.Text)));
double thanhtien = 0;
foreach (var a in dt.selectCTHD(lbMaHD.Text))
{
thanhtien = thanhtien + Convert.ToDouble(a.GIABAN) * Convert.ToDouble(a.SL);
}
dt.UPDATE_ThanhTien(lbMaHD.Text, thanhtien);
MessageBox.Show("Thêm thành công", "Thêm");
numericChietKhau.Enabled = false;
var sp = dt.selectSP(cbbTenSP.SelectedValue.ToString()).FirstOrDefault();
label2.Text = sp.SOLUONG.ToString();
}
else if (HDX != null)
{
var CTX = dt.selectAll_CTHD(lbMaHD.Text, cbbTenSP.SelectedValue.ToString()).FirstOrDefault();
if (CTX == null)
{
dt.INSERT_CTHD(lbMaHD.Text, cbbTenSP.SelectedValue.ToString(), Convert.ToInt32(txtSL.Text),
(Convert.ToDouble(txtSL.Text) * Convert.ToDouble(lbDongia.Text)));
double thanhtien = 0;
foreach (var a in dt.selectCTHD(lbMaHD.Text))
{
thanhtien = thanhtien + Convert.ToDouble(a.GIABAN) * Convert.ToDouble(a.SL);
}
dt.UPDATE_ThanhTien(lbMaHD.Text, thanhtien);
MessageBox.Show("Thêm thành công", "Thêm");
var sp = dt.selectSP(cbbTenSP.SelectedValue.ToString()).FirstOrDefault();
label2.Text = sp.SOLUONG.ToString();
}
else if (CTX != null)
{
dt.updateSL_CTHD(lbMaHD.Text, cbbTenSP.SelectedValue.ToString(), Convert.ToInt32(txtSL.Text) + CTX.SL,
CTX.THANHTIEN + (Convert.ToDouble(txtSL.Text) * Convert.ToDouble(lbDongia.Text)));
double thanhtien = 0;
foreach (var a in dt.selectCTHD(lbMaHD.Text))
{
thanhtien = thanhtien + Convert.ToDouble(a.GIABAN) * Convert.ToDouble(a.SL);
}
dt.UPDATE_ThanhTien(lbMaHD.Text, thanhtien);
MessageBox.Show("Thêm thành công", "Thêm");
var sp = dt.selectSP(cbbTenSP.SelectedValue.ToString()).FirstOrDefault();
label2.Text = sp.SOLUONG.ToString();
}
}
}
dgvHD.DataSource = dt.selectCTHD(lbMaHD.Text);
txtSL.ResetText();
double TongTienHD = 0;
double TongTienDiscount = 0;
foreach (var a in dt.selectCTHD(lbMaHD.Text))
{
TongTienHD = TongTienHD + Convert.ToDouble(a.GIABAN) * Convert.ToDouble(a.SL);
}
TongTienDiscount = TongTienHD - ((Convert.ToDouble(numericChietKhau.Value) * TongTienHD) * 0.01);
dt.UPDATE_TONGTIEN(lbMaHD.Text, TongTienDiscount);
lbTongTien.Text = TongTienDiscount.ToString("N0");
}
