public Task <ISolutionItem?> CreateRelatedSolutionItem(RelatedSolutionItem related)
{
if (definition.Picker == "GossipMenuParameter" &&
related.Type == RelatedSolutionItem.RelatedType.CreatureEntry)
{
var template = databaseProvider.GetCreatureTemplate((uint)related.Entry);
if (template == null || template.GossipMenuId == 0)
{
return(Task.FromResult <ISolutionItem?>(null));
}
return(tableOpenService.Create(definition, new DatabaseKey(template.GossipMenuId)));
}
return(tableOpenService.Create(definition, new DatabaseKey(related.Entry)));
}
public async Task <long?> PickByColumn(string table, DatabaseKey?key, string column, long?initialValue, string?backupColumn = null)
{
var definition = definitionProvider.GetDefinition(table);
if (definition == null)
{
throw new UnsupportedTableException(table);
}
if (definition.RecordMode != RecordMode.SingleRow && !key.HasValue)
{
throw new Exception("Pick by column is not supported for multi-row tables without key");
}
var solutionItem = await tableOpenService.Create(definition, key ?? default);
if (solutionItem == null)
{
throw new UnsupportedTableException(table);
}
bool openInNoSaveMode = IsItemAlreadyOpened((DatabaseTableSolutionItem)solutionItem, out _);
ViewModelBase tableViewModel;
if (definition.RecordMode == RecordMode.MultiRecord)
{
var multiRow = containerProvider.Resolve <MultiRowDbTableEditorViewModel>((typeof(DatabaseTableSolutionItem), solutionItem));
tableViewModel = multiRow;
multiRow.AllowMultipleKeys = false;
if (initialValue.HasValue)
{
tableViewModel.ToObservable(that => that.IsLoading)
.Where(@is => !@is)
.SubscribeOnce(@is =>
{
var group = multiRow.Rows.FirstOrDefault(row => row.Key == key);
if (group != null)
{
var row = group.FirstOrDefault(r =>
(r.Entity.GetCell(column) is DatabaseField <long> longField &&
longField.Current.Value == initialValue) ||
(backupColumn != null && r.Entity.GetCell(backupColumn) is DatabaseField <long> longField2 &&
longField2.Current.Value == initialValue));
if (row != null)
{
mainThread.Delay(() => multiRow.SelectedRow = row, TimeSpan.FromMilliseconds(1));
}
}
});
}
}
else if (definition.RecordMode == RecordMode.SingleRow)
{
var singleRow = containerProvider.Resolve <SingleRowDbTableEditorViewModel>((typeof(DatabaseTableSolutionItem), solutionItem));
tableViewModel = singleRow;
if (key != null)
{
singleRow.FilterViewModel.FilterText = $"`{definition.GroupByKeys[0]}` = {key.Value[0]}";
}
if (initialValue.HasValue)
{
singleRow.TryFind(key.HasValue ? key.Value.WithAlso(initialValue.Value) : new DatabaseKey(initialValue.Value)).ListenErrors();
}
if (key != null)
{
singleRow.FilterViewModel.ApplyFilter.Execute(null);
}
}
else
{
throw new Exception("TemplateMode not (yet?) supported");
}
var viewModel = containerProvider.Resolve <RowPickerViewModel>((typeof(ViewModelBase), tableViewModel), (typeof(bool), openInNoSaveMode));
if (await windowManager.ShowDialog(viewModel))
{
var col = viewModel.SelectedRow?.GetCell(column);
if (col is DatabaseField <long> longColumn)
{
return(longColumn.Current.Value);
}
else if (backupColumn != null)
{
col = viewModel.SelectedRow?.GetCell(backupColumn);
if (col is DatabaseField <long> longColumn2)
{
return(longColumn2.Current.Value);
}
}
Console.WriteLine($"Couldn't find column {column} or {backupColumn} in {tableViewModel.TableDefinition.Name}");
}
return(null);
}
