public static bool CapNhatChiTietHD(int id1, string id2, CHITIETHOADONBANHANG ctNew, ref decimal deltaTT)
{
QLCuaHangDDSDataContext db = new QLCuaHangDDSDataContext();
var ct = db.CHITIETHOADONBANHANGs.Single(p => p.MaHD == id1 && p.TenMH == id2);
ct.SoLuong = ctNew.SoLuong;
decimal originTT = ct.ThanhTien.Value;
ct.GiamGiaTrenMatHang = ctNew.GiamGiaTrenMatHang;
ct.ThanhTien = ct.DonGia.Value * (1 - (decimal)ct.GiamGiaTrenMatHang.Value) * ct.SoLuong;
ct.GiamGiaTrenThanhTien = ctNew.GiamGiaTrenThanhTien;
ct.ThanhTien = ct.ThanhTien * (1 - (decimal)ct.GiamGiaTrenThanhTien.Value);
try
{
db.SubmitChanges();
decimal delta = ct.ThanhTien.Value - originTT;
HoaDonBanHangDAO.CapNhatTongTienHD(ct.MaHD, delta, ref deltaTT);
XtraMessageBox.Show("Cập nhật thành công!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
catch (Exception e)
{
XtraMessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public static bool ThemChiTietHD(CHITIETHOADONBANHANG ct, ref decimal result)
{
QLCuaHangDDSDataContext db = new QLCuaHangDDSDataContext();
db.CHITIETHOADONBANHANGs.InsertOnSubmit(ct);
try
{
db.SubmitChanges();
HoaDonBanHangDAO.CapNhatTongTienHD(ct.MaHD, ct.ThanhTien.Value, ref result);
XtraMessageBox.Show("Thêm thành công!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
catch (Exception e)
{
XtraMessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
private void btn_CapNhat_Click(object sender, EventArgs e)
{
CHITIETHOADONBANHANG ct = new CHITIETHOADONBANHANG();
try
{
ct.GiamGiaTrenMatHang = double.Parse(edt_GiamGiaTriSP.Text.ToString()) / 100;
ct.GiamGiaTrenThanhTien = double.Parse(edt_GiamGiaTriTT.Text.ToString()) / 100;
ct.SoLuong = int.Parse(edt_SuaSoLuong.Text.ToString());
}
catch (Exception) { return; }
decimal result = 0;
if (ChiTietHDBHBUS.CapNhatChiTietHD(this.currentMaHD, this.selectedTenMH, ct, ref result))
{
edt_TongTien.Text = result.ToString();
this.refreshTableChiTiet();
}
}
private void btn_Add_Click(object sender, EventArgs e)
{
CHITIETHOADONBANHANG ct = new CHITIETHOADONBANHANG();
ct.MaHD = this.currentMaHD;
ct.TenMH = gridViewMatHang.GetFocusedRowCellValue("Ten").ToString();
ct.GiamGiaTrenMatHang = 0;
ct.GiamGiaTrenThanhTien = 0;
ct.SoLuong = int.Parse(edt_SoLuong.Text.ToString());
ct.DonGia = decimal.Parse(gridViewMatHang.GetFocusedRowCellValue("DonGia").ToString());
ct.ThanhTien = ct.DonGia * ct.SoLuong;
decimal result = 0;
if (ChiTietHDBHBUS.ThemChiTietHD(ct, ref result))
{
edt_TongTien.Text = result.ToString();
this.refreshTableChiTiet();
}
}
public static bool CapNhatChiTietHD(int id1, string id2, CHITIETHOADONBANHANG ctNew, ref decimal deltaTT)
{
return(ChiTietHDBHDAO.CapNhatChiTietHD(id1, id2, ctNew, ref deltaTT));
}
public static bool ThemChiTietHD(CHITIETHOADONBANHANG ct, ref decimal result)
{
return(ChiTietHDBHDAO.ThemChiTietHD(ct, ref result));
}
