public IEnumerable <ISQLTableColumn> GetTableData(ISQLTable SQLTable)
{
var Result = new List <SQLTableColumn>( );
DataTable Schema = ConnectionManager.GetSchema(SQLTable.ConnectionCredentials,
EMSSQLSchemaType.TColumns,
new ColumnSchemaRestrictions( )
{
Table = SQLTable.Name
});
foreach (String ColumnName in Schema.GetColumnNameValues("COLUMN_NAME"))
{
ISQLTableColumnKey ISQLTableColumnKey = new SQLTableColumnKey(ColumnName);
Result.Add(new SQLTableColumn(ColumnName, SQLTable));
}
foreach (String[] SQLResultRow in ExecuteSQL(SQLTable.ConnectionCredentials, $"SELECT * FROM {SQLTable.Name}"))
{
for (int i = 0; i < SQLResultRow.Length; i++)
{
Result[i].AddValue(SQLResultRow[i]);
}
}
return(Result.AsReadOnly( ));
}
public AttributeQuery(IAttributeQueryView view)
{
this._sqlTable = SQLTable.CallMe;
this._views = new List<IAttributeQueryView>();
if (view != null)
{
this._views.Add(view);
}
}
public QueryThua(IQueryThuaView view)
{
_views = new List<IQueryThuaView>();
_views.Add(view);
_sqlTable = SQLTable.CallMe;
this._bwk = new BackgroundWorker();
this._bwk.DoWork += new DoWorkEventHandler(_bwk_DoWork);
this._config = CurrentConfig.CallMe();
}
public SQLTableColumn(String Name, ISQLTableColumnKey ColumnKey, ISQLTable Table) : this(Name, Table)
{
if (Table == null)
{
throw new ArgumentOutOfRangeException("SQL Table Column ColumnKey Cannot Be Null.");
}
this.ColumnKey = ColumnKey;
}
public SQLTableColumn(String Name, ISQLTable Table)
{
if (String.IsNullOrWhiteSpace(Name))
{
throw new ArgumentOutOfRangeException("SQL Table Column Name Cannot Be Null Or Whitespace.");
}
if (Table == null)
{
throw new ArgumentOutOfRangeException("SQL Table Column Table Cannot Be Null.");
}
this.Name = Name;
this.Table = Table;
}
private TnRoles()
{
users = new DataSet();
sqlTable=SQLTable.CallMe;
_lstCurUsers = new List<string>();
}
public IEnumerable <ISQLTableColumn> GetData(ISQLTable ISQLTable)
{
return(_ISQLServerInterop.GetTableData(ISQLTable));
}
