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()); }