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);
}
