using System;
using System.Collections.Generic;

namespace Sonex.Client.Data
{
    public sealed class DataColumnDouble : DataColumnBase
    {
        public List<double?> Values { get; } = new();

        public override Type DataType => typeof(double);
        public override int RowCount => Values.Count;

        public DataColumnDouble(string key, string header, int initialRowCount = 0)
            : base(key, header)
        {
            ValueFormat = "0.00";

            for (int i = 0; i < initialRowCount; i++)
                Values.Add(null);
        }

        protected override string? FormatValue(int rowIndex)
        {
            double? value = Values[rowIndex];
            if (value is null)
                return null;

            return value.Value.ToString(string.IsNullOrWhiteSpace(ValueFormat) ? "0.00" : ValueFormat);
        }

        public override void SetValue(int rowIndex, string? value)
        {
            ValidateRowIndex(rowIndex);

            if (string.IsNullOrWhiteSpace(value))
            {
                Values[rowIndex] = null;
                return;
            }

            if (!double.TryParse(value, out double result))
                throw new FormatException($"Value '{value}' is not a valid double.");

            Values[rowIndex] = result;
        }

        public override object? GetRawValue(int rowIndex)
        {
            ValidateRowIndex(rowIndex);
            return Values[rowIndex];
        }

        public override void SetRawValue(int rowIndex, object? value)
        {
            ValidateRowIndex(rowIndex);

            if (value is null)
            {
                Values[rowIndex] = null;
                return;
            }

            if (value is double doubleValue)
            {
                Values[rowIndex] = doubleValue;
                return;
            }

            throw new InvalidCastException($"Column '{Key}' expects double.");
        }

        public override void AddEmpty()
        {
            Values.Add(null);
        }
    }
}