using System;
using System.Data;
using System.Globalization;
using Vision.Core.Logging.Loggers;

namespace Vision.Core.IO.SHN
{
    public class SHNResult : DataTable
    {
        private static readonly EngineLog Logger = new EngineLog(typeof(SHNResult));

        public int Count { get; protected internal set; }

        public T Read<T>(int row, string columnName, int number = 0) where T : IConvertible
        {
            return ToOrDefault<T>(Rows[row], columnName + (number != 0 ? (1 + number).ToString() : ""));
        }

        public bool HasValues => Count > 0;

        public byte[] GetBytes(int row, string columnName)
        {
            return (byte[])Rows[row][columnName];
        }

        public object[] ReadAllValuesFromField(string columnName)
        {
            var obj = new object[Count];

            for (var i = 0; i < Count; i++)
                obj[i] = Rows[i][columnName];

            return obj;
        }

        public T ToOrDefault<T>(DataRow row, string columnName) where T : IConvertible
        {
            try
            {
                return (T)Convert.ChangeType(row[columnName], typeof(T), CultureInfo.InvariantCulture);
            }
            catch (InvalidCastException ex)
            {
                Logger.Error($"SHNResult: Invalid Cast (ColumnName {columnName} : {row[columnName]})", ex);
            }
            catch (FormatException ex)
            {
                Logger.Error($"SHNResult: Invalid Format (ColumnName {columnName} : {row[columnName]})", ex);
            }
            catch (OverflowException ex)
            {
                Logger.Error($"SHNResult: Overflowed (ColumnName {columnName} : {row[columnName]})", ex);
            }
            catch (ArgumentException ex)
            {
                Logger.Error($"SHNResult: Invalid Argument (ColumnName {columnName} : {row[columnName]})", ex);
            }
            return default;
        }
	}
}