public IResponse <List <GenericModel> > GetAdapterData(long jobDefinitionId) { var response = new Response <List <GenericModel> > { Value = new List <GenericModel>() }; try { var adapterParameters = _jobDefinitionService.GetAdapterParameter(jobDefinitionId); if (adapterParameters.Status != StatusEnum.Success) { response.Status = StatusEnum.Error; return(response); } IAdapter adapter; switch (adapterParameters.Value.Adapter) { case AdapterTypeItemEnum.MSSQL: adapter = new MSSQLAdapter(_logger); response = adapter.ConnectAndRead(adapterParameters.Value.QueryRead, adapterParameters.Value.ConnString.MSSQLConnString); break; case AdapterTypeItemEnum.MySQL: adapter = new MySQLAdapter(_logger); response = adapter.ConnectAndRead(adapterParameters.Value.QueryRead, adapterParameters.Value.ConnString.MySQLConnString); break; case AdapterTypeItemEnum.Oracle: adapter = new OracleAdapter(_logger); response = adapter.ConnectAndRead(adapterParameters.Value.QueryRead, adapterParameters.Value.ConnString.OracleConnString); break; } } catch (Exception ex) { _logger.Information($"DbAdapterService.GetAdapterData(jobId: {jobDefinitionId})"); _logger.Error(ex.Message); response.Status = StatusEnum.Error; } return(response); }