using System.ComponentModel;
using System.Text.Json;
using Sbroenne.ExcelMcp.CLI.Daemon;
using Sbroenne.ExcelMcp.CLI.Infrastructure;
using Sbroenne.ExcelMcp.Core.Models.Actions;
using Spectre.Console;
using Spectre.Console.Cli;
namespace Sbroenne.ExcelMcp.CLI.Commands;
/// <summary>
/// Chart commands - thin wrapper that sends requests to daemon.
/// Actions: list, read, create-from-range, create-from-pivottable, delete, move, fit-to-range
/// </summary>
internal sealed class ChartCommand : AsyncCommand<ChartCommand.Settings>
{
public override async Task<int> ExecuteAsync(CommandContext context, Settings settings, CancellationToken cancellationToken)
{
if (string.IsNullOrWhiteSpace(settings.SessionId))
{
AnsiConsole.MarkupLine("[red]Session ID is required. Use --session <id>[/]");
return 1;
}
if (string.IsNullOrWhiteSpace(settings.Action))
{
AnsiConsole.MarkupLine("[red]Action is required.[/]");
return 1;
}
if (!ActionValidator.TryNormalizeAction<ChartAction>(settings.Action, out var action, out var errorMessage))
{
AnsiConsole.MarkupLine($"[red]{errorMessage}[/]");
return 1;
}
var command = $"chart.{action}";
// Note: property names must match daemon's Args classes (e.g., ChartFromRangeArgs)
object? args = action switch
{
"list" => new { sheetName = settings.SheetName },
"read" => new { sheetName = settings.SheetName, chartName = settings.ChartName },
"create-from-range" => new { sheetName = settings.SheetName, chartName = settings.ChartName, sourceRange = settings.SourceRange, chartType = settings.ChartType, left = settings.Left, top = settings.Top, width = settings.Width, height = settings.Height },
"create-from-table" => new { tableName = settings.TableName, sheetName = settings.SheetName, chartName = settings.ChartName, chartType = settings.ChartType, left = settings.Left, top = settings.Top, width = settings.Width, height = settings.Height },
"create-from-pivottable" => new { pivotTableName = settings.PivotTableName, sheetName = settings.SheetName, chartName = settings.ChartName, chartType = settings.ChartType, left = settings.Left, top = settings.Top, width = settings.Width, height = settings.Height },
"delete" => new { sheetName = settings.SheetName, chartName = settings.ChartName },
"move" => new { chartName = settings.ChartName, left = settings.Left, top = settings.Top, width = settings.Width, height = settings.Height },
"fit-to-range" => new { chartName = settings.ChartName, sheetName = settings.SheetName, rangeAddress = settings.TargetRange ?? settings.SourceRange },
_ => new { sheetName = settings.SheetName, chartName = settings.ChartName }
};
using var client = new DaemonClient();
var response = await client.SendAsync(new DaemonRequest
{
Command = command,
SessionId = settings.SessionId,
Args = args != null ? JsonSerializer.Serialize(args, DaemonProtocol.JsonOptions) : null
}, cancellationToken);
if (response.Success)
{
Console.WriteLine(!string.IsNullOrEmpty(response.Result) ? response.Result : JsonSerializer.Serialize(new { success = true }, DaemonProtocol.JsonOptions));
return 0;
}
else
{
Console.WriteLine(JsonSerializer.Serialize(new { success = false, error = response.ErrorMessage }, DaemonProtocol.JsonOptions));
return 1;
}
}
internal sealed class Settings : CommandSettings
{
[CommandArgument(0, "<ACTION>")]
[Description("The action to perform (e.g., list, read, create-from-range, delete)")]
public string Action { get; init; } = string.Empty;
[CommandOption("-s|--session <SESSION>")]
[Description("Session ID from 'session open' command")]
public string SessionId { get; init; } = string.Empty;
[CommandOption("--sheet <NAME>")]
[Description("Worksheet name")]
public string? SheetName { get; init; }
[CommandOption("--chart|--chart-name <NAME>")]
[Description("Chart name")]
public string? ChartName { get; init; }
[CommandOption("--pivot-table <NAME>")]
[Description("PivotTable name for chart creation")]
public string? PivotTableName { get; init; }
[CommandOption("--table <NAME>")]
[Description("Table name for create-from-table action")]
public string? TableName { get; init; }
[CommandOption("--source-range|--range <ADDRESS>")]
[Description("Source data range address (e.g., A1:D10)")]
public string? SourceRange { get; init; }
[CommandOption("--target-sheet <NAME>")]
[Description("Target worksheet for chart placement")]
public string? TargetSheet { get; init; }
[CommandOption("--target-range <ADDRESS>")]
[Description("Target range for fit-to-range operation")]
public string? TargetRange { get; init; }
[CommandOption("--chart-type <TYPE>")]
[Description("Chart type (e.g., ColumnClustered, Line, Pie)")]
public string? ChartType { get; init; }
[CommandOption("--position <POSITION>")]
[Description("Chart position")]
public string? Position { get; init; }
[CommandOption("--left <VALUE>")]
[Description("Left position in points")]
public double? Left { get; init; }
[CommandOption("--top <VALUE>")]
[Description("Top position in points")]
public double? Top { get; init; }
[CommandOption("--width <VALUE>")]
[Description("Width in points")]
public double? Width { get; init; }
[CommandOption("--height <VALUE>")]
[Description("Height in points")]
public double? Height { get; init; }
}
}
