public async Task <DropshipAccountItem[]> GetMultipleWithAccount(int take, int skip)
{
var accountTableName = ORMQueryHelper.GetTableName <DropshipAccount>();
var command = new NpgsqlCommand();
command.CommandText = $"SELECT {ORMQueryHelper.GetSelectColumns<DropshipItemModel>()},{ORMQueryHelper.GetSelectColumns<DropshipAccount>()} FROM {tableName} JOIN {accountTableName} ON {tableName}.username={accountTableName}.username LIMIT {take} OFFSET {skip};";
var items = new List <DropshipAccountItem>();
await db.CommandReaderAsync(command, reader =>
{
var item = new DropshipAccountItem();
reader.ReadModel <DropshipItemModel>(item.Item);
reader.ReadModel <DropshipAccount>(item.Account);
items.Add(item);
});
return(items.ToArray());
}
public async Task <DropshipAccountItem[]> GetMultipleWithAccountByUsername(string username)
{
var accountTableName = ORMQueryHelper.GetTableName <DropshipAccount>();
var command = new NpgsqlCommand();
command.CommandText = $"SELECT {ORMQueryHelper.GetSelectColumns<DropshipItemModel>()},{ORMQueryHelper.GetSelectColumns<DropshipAccount>()} FROM {tableName} JOIN {accountTableName} ON {tableName}.username={accountTableName}.username WHERE {tableName}.username=@username;";
command.Parameters.AddWithValue("@username", username);
var items = new List <DropshipAccountItem>();
await db.CommandReaderAsync(command, reader =>
{
var item = new DropshipAccountItem();
reader.ReadModel <DropshipItemModel>(item.Item);
reader.ReadModel <DropshipAccount>(item.Account);
items.Add(item);
});
return(items.ToArray());
}