//Import database private void ImportDatabase(string path) { DataTable dt = new DataTable(); dt = UntilitiesBusiness.ImportToDatatable(path); _TongBanGhi = dt.Rows.Count; int i = 0; foreach (DataRow rdt in dt.Rows) { #region 1.Kiểm tra từng bản ghi trong data table if (rdt["MANHOM"].ToString().Equals("")) { _ThatBai++; goto go; } if (UntilitiesBusiness.CheckEist("tbl_NHOMSANPHAM", "MaNSP_NSP", rdt["MANHOM"].ToString().Trim())) { _ThatBai++; goto go; } if (rdt["TENNHOM"].ToString().Equals("")) { _ThatBai++; goto go; } #endregion #region 2. Lấy thông tin NhomSanPhamPublic nsp = new NhomSanPhamPublic(); nsp.MaNSP_NSP = rdt["MANHOM"].ToString(); nsp.TenNSP_NSP = rdt["TENNHOM"].ToString(); nsp.GhiChu_NSP = rdt["GHICHU"].ToString(); nsp.DangDung_NSP = true; #endregion #region 3.Thêm vào csdl NhomSanPhamBusiness.ThemNhomSanPham(nsp); _ThanhCong++; #endregion #region 4. Cập nhật progressbar go: i++; worker.ReportProgress(i * 100 / dt.Rows.Count); #endregion } }