public IEnumerable <SkycoreHRM.Shared.Department> GetData()
{
foreach (var strategy in Strategies)
{
try
{
IDbDataAdapter adapter = null;
var accessContext = new DataAccessContext(strategy);
adapter = accessContext.EstablishDataAccess(adapter);
var myRenderer = new DataRenderer(adapter);
var writer = new StringWriter();
myRenderer.Render(writer);
var result = writer.ToString().Replace(" ", string.Empty);
var rows = result.Split("\r\n").Where(e => !string.IsNullOrEmpty(e));
var departments = rows.Select(e => new SkycoreHRM.Shared.Department {
Name = e
});
return(departments);
}
catch (Exception)
{
continue;
}
}
return(null);
}
