public void PushClassificationForCompany(long companyID, ProductAdapter productAdapter, IDatabase redisDatabase) { DataTable tblClassification = productAdapter.GetTblClassificationPushRedisForCompany(companyID); foreach (DataRow rowClassification in tblClassification.Rows) { long ClassificationID = Convert.ToInt64(rowClassification["ID"]); int count = 0; while (true) { try { redisDatabase.SetAdd("classification", ClassificationID.ToString()); break; } catch (Exception ex) { count++; if (count > 5) { break; } else { Thread.Sleep(1000); } } } } productAdapter.UpdateLastSyncClassificationRedisForCompany(companyID); }