//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
}
}
