protected void UpdateNotifyCacheInTransaction(ConnectionProvider objConnectionProvider)
        {
            try
            {
                NotifyCacheUpdate.CreateDBConnection = false;
                NotifyCacheUpdate notifyTbl = new NotifyCacheUpdate(_mainConnection);
                notifyTbl.MainConnectionProvider = objConnectionProvider;

                notifyTbl.daTimeStamp = DateTime.Now;
                notifyTbl.iID = 1;
                notifyTbl.Update();
            }
            catch (Exception ex)
            {
                _log.Error("DBInteractionBase::UpdateNotifyCacheInTransaction : {0}", ex.Message);
                throw new Exception("DBInteractionBase::UpdateNotifyCacheInTransaction::Error occured." + ex.Message, ex);
            }
            finally
            {
                NotifyCacheUpdate.CreateDBConnection = true;
            }
        }
 public void UpdateNotifyCacheUpdateTable()
 {
     try
     {
         NotifyCacheUpdate notifyTbl = new NotifyCacheUpdate(_mainConnection);
         notifyTbl.daTimeStamp = DateTime.Now;
         notifyTbl.iID = 1;
         notifyTbl.Update();
     }
     catch (Exception ex)
     {
         _log.Error("DBInteractionBase::UpdateNotifyCacheUpdateTable : {0}", ex.Message);
         throw new Exception("DBInteractionBase::UpdateNotifyCacheUpdateTable::Error occured." + ex.Message, ex);
     }
 }