public async Task <(Actor, string, Cast, string)[]> GetTuple()
{
string aliasactor = "actor";
string aliascast = "cast";
try
{
var query = await _dao.NewQueryBuilder()
.Select()
.AllFields <Actor>(aliasactor).Comma()
.Field <Actor>(aliasactor, a => a.ActorName, "ACTORNAME_2").Comma()
.AllFields <Cast>(aliascast).Comma()
.Field <Cast>(aliascast, c => c.Role, "ACTORROLE_2")
.From()
.Tables
(
FlatTable <Actor> .WithAlias(aliasactor),
InnerJoin <Cast> .WithAlias(aliascast),
(a, c) => a.Id == c.ActorId
)
.OrderBy <Actor>(aliasactor, a => a.Id)
.GetItemsArrayAsync <(Actor Actor, string Actorname, Cast Cast, string Role)>()
.ConfigureAwait(false);
return(query);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(null);
}
public static dynamic GetDataGridViewKey(FlatTable dgv, dynamic column)
{
if (dgv.Rows.Count < 1)
{
return(1);
}
return(dgv.Rows[GetRowIndex(dgv)].Cells[column].Value.ToString());
}
public List <FlatTable> Flatten(List <SendTable> sendTables)
{
var flattened = new List <FlatTable>();
var nameMap =
sendTables.ToDictionary(t => t.NetTableName, t => t);
foreach (var table in sendTables)
{
var excluding = new HashSet <string>();
GatherExcludes(table, nameMap, excluding);
var properties = new List <PropertyInfo>();
BuildHierarchy(properties, table, nameMap, excluding);
SortProperties(properties);
flattened.Add(
FlatTable.CreateWith(table.NetTableName, table.NeedsDecoder, properties));
}
return(flattened);
}
private int GetAccountId(FlatTable dgv)
{
return(int.Parse(ControlHelper.GetDataGridViewKey(dgv, 0)));
}
public static int GetRowIndex(FlatTable dgv)
{
return(dgv.CurrentRow?.Index ?? 0);
}
