private void importFromDBF()
 {
     try
     {
         dbfAdaptor = new dbf1Cv77Adaptor(_pathDB);
         ImportDataFromDBF data = new ImportDataFromDBF(dbfAdaptor, adaptorSql);
         if (data.Sync())
         {
             Logger.logger.Info(string.Format("Full Sync OK DBF to MSSQL {0} ", _pathDB));
         }
     }catch (Exception ex)
     {
         Logger.logger.Error(string.Format("importFromDBF DB:'{0}' Ex:{1}", _pathDB, ex.Message));
     }finally
     {
         Dispose();
     }
 }
 public void Dispose()
 {
     try
     {
         if (adaptorSql != null)
         {
             adaptorSql.Dispose();
         }
         if (adaptor1C != null)
         {
             adaptor1C.Dispose();
         }
         if (dbfAdaptor != null)
         {
             dbfAdaptor.Dispose();
         }
         dbfAdaptor = null;
         adaptor1C  = null;
         adaptorSql = null;
     }catch (Exception ex)
     {
         Logger.logger.Error(ex);
     }
 }
 public ImportDataFromDBF(dbf1Cv77Adaptor dbf1Cv77Adaptor, sqlAdaptor sqlAdaptor)
 {
     this._sqlAdaptor      = sqlAdaptor;
     this._dbf1Cv77Adaptor = dbf1Cv77Adaptor;
 }