private void AssignChiTietHoaDon(DataRow row)
{
_chiTietHoaDon = new clsChiTietHoaDon();
int idMaVach = Convert.ToInt32(row["id"].ToString());
//ChiTietHoaDon
_chiTietHoaDon.IdMaVachSanPham = idMaVach;
_chiTietHoaDon.IdHoaDon = _ctrlHoaDon.GetIdHoaDon();
_chiTietHoaDon.SoLuong = Convert.ToInt32(row["SoLuong"].ToString());
_chiTietHoaDon.ThoiGianBaoHanh = 12;
_chiTietHoaDon.ChietKhau = 0;
_chiTietHoaDon.VAT = Convert.ToInt32(row["VAT"].ToString());
_chiTietHoaDon.DonGia = Convert.ToInt32(row["DonGia"].ToString());
_chiTietHoaDon.SanPhamComBo = 0;
_chiTietHoaDon.GiaVon = _ctrlMaVachSanPham.GetGiaVonBanLe(idMaVach, 1);
_chiTietHoaDon.GhiChu = txtGhiChuHoaDon.Text;
}
public bool AddData(clsChiTietHoaDon chiTietHoaDon)
{
if (!_mdlChiTietHoaDon.AddData(chiTietHoaDon))
{
MessageBox.Show("Thêm chi tiết hóa đơn lỗi", "Thêm chi tiết hóa đơn", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
return(true);
}
ConnectToSQL _conn = new ConnectToSQL();//Initialize connectoSQl class
public bool AddData(clsChiTietHoaDon chiTietHoaDon)
{
_conn.CMD.CommandText = String.Format("INSERT [dbo].[tbChiTietHoaDon] (idHoaDon,SoLuong,ChietKhau,DonGia,GhiChu,"
+ "idMaVachSanPham,ThoiGianBaoHanh,GiaVon,VAT,SanPhamComBo)"
+ "VALUES (N'{0}',N'{1}',N'{2}',N'{3}',N'{4}',N'{5}',N'{6}',N'{7}',N'{8}',N'{9}')"
, chiTietHoaDon.IdHoaDon, chiTietHoaDon.SoLuong, chiTietHoaDon.ChietKhau, chiTietHoaDon.DonGia, chiTietHoaDon.GhiChu
, chiTietHoaDon.IdMaVachSanPham, chiTietHoaDon.ThoiGianBaoHanh, chiTietHoaDon.GiaVon, chiTietHoaDon.VAT, chiTietHoaDon.SanPhamComBo);
return(_conn.ExecuteCMD());
}
