public Task <DataTable> getTableInformation(String Database, String Table)
{
return(Task.Run(() => {
if (BLDatabaseEngine.EngineInUse.Equals(BLDatabaseEngine.DataSource.MySQL))
{
DataTable oDT = new DAOAsphyoMySql.Server().getTableInformation(Database, Table);
if (!oDT.Rows.GetEnumerator().MoveNext())
{
throw new BEUAsphyo.Exception.BEUExceptionBL("Databases doesn´t have any tables");
}
return oDT;
}
if (BLDatabaseEngine.EngineInUse.Equals(BLDatabaseEngine.DataSource.SqlServer))
{
DataTable oDT = new DAOAsphyoSqlServer.Server().getTableInformation(Database, Table);
if (!oDT.Rows.GetEnumerator().MoveNext())
{
throw new BEUAsphyo.Exception.BEUExceptionBL("Databases doesn´t have any tables");
}
return oDT;
}
throw new BEUAsphyo.Exception.BEUExceptionBL("Unhandled error");
}));
}
public Task <List <String> > getListTables(String Database)
{
return(Task.Run(() => {
if (BLDatabaseEngine.EngineInUse.Equals(BLDatabaseEngine.DataSource.MySQL))
{
List <String> oList = new DAOAsphyoMySql.Server().getTables(Database).AsEnumerable().Select(dr => dr.Field <String>("TableName")).ToList();
if (!oList.Any())
{
throw new BEUAsphyo.Exception.BEUExceptionBL("Databases doesn´t have any tables");
}
return oList;
}
if (BLDatabaseEngine.EngineInUse.Equals(BLDatabaseEngine.DataSource.SqlServer))
{
List <String> oList = new DAOAsphyoSqlServer.Server().getTables(Database).AsEnumerable().Select(dr => dr.Field <String>("TableName")).ToList();
if (!oList.Any())
{
throw new BEUAsphyo.Exception.BEUExceptionBL("Databases doesn´t have any tables");
}
return oList;
}
throw new BEUAsphyo.Exception.BEUExceptionBL("Unhandled error");
}));
}
