namespace Admin.NET.Plugin.AiDOP.SmartOps;

public static class KpiTargetSnapshotSql
{
    public static object ValueOrDbNull(KpiTargetSnapshot snap) =>
        snap.TargetValue.HasValue ? snap.TargetValue.Value : DBNull.Value;

    public static object ConfigIdOrDbNull(KpiTargetSnapshot snap) =>
        snap.TargetConfigId.HasValue ? snap.TargetConfigId.Value : DBNull.Value;

    public static object SourceOrDbNull(KpiTargetSnapshot snap) =>
        string.IsNullOrWhiteSpace(snap.TargetSource)
        || snap.TargetSource == KpiTargetSnapshotSource.Missing
            ? DBNull.Value
            : snap.TargetSource;

    public static SugarParameter[] Parameters(KpiTargetSnapshot snap) =>
    [
        new("@TargetValue", ValueOrDbNull(snap)),
        new("@TargetConfigId", ConfigIdOrDbNull(snap)),
        new("@TargetSource", SourceOrDbNull(snap)),
        new("@TargetResolvedAt", snap.ResolvedAt)
    ];
}