using HotelPms.Share.Data;
using HotelPms.Share.Util;
using System.Data;
using System.Reflection;

namespace HotelPms.Data
{
    /// <summary>
    /// GrpcTableの拡張
    /// </summary>
    public partial class GrpcTable
    {
        /// <summary>
        /// 汎用クラスへバラス
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <returns></returns>
        public List<T> Convert<T>() where T : new()
        {
            List<string> nameList = new List<string>();
            List<Type> typeList = new List<Type>();
            foreach (GrpcCol col in Cols)
            {
                Type type = CConvert.ToType(col.FieldType);
                typeList.Add(type);
                nameList.Add(col.Name);
            }

            List<T> list = new List<T>();

            //TはRecordBaseの子供クラス
            if (typeof(T).IsSubclassOf(typeof(RecordBase)))
            {
                foreach (GrpcRow row in this.Rows)
                {
                    T item = new T();
                    int p = 0;
                    for (int i = 0; i < typeList.Count; i++)
                    {
                        Type type = typeList[i];
                        object val = GetFieldValue(type, row, ref p);
                        (item as RecordBase).SetField(nameList[i], val);
                    }
                    list.Add(item);
                }
            }
            else
            {
                foreach (GrpcRow row in this.Rows)
                {
                    T item = GetItem<T>(row, typeList, nameList);
                    list.Add(item);
                }
            }
            return list;
        }

        /// <summary>
        /// 一行目、一列目を返す
        /// </summary>
        /// <param name="type"></param>
        /// <returns></returns>
        public object? GetValue(Type type)
        {
            try
            {
                if (Rows.Count == 0) { return null; }
                int p = 0;
                return GetFieldValue(type, Rows[0], ref p);
            }
            catch
            {
                return null;
            }
        }

        private T GetItem<T>(GrpcRow row, List<Type> typeList, List<string> nameList) where T : new()
        {
            Type temp = typeof(T);
            T obj = new T();

            int p = 0;
            for (int i = 0; i < typeList.Count; i++)
            {
                Type type = typeList[i];
                object val = GetFieldValue(type, row, ref p);

                //↓効率悪い
                foreach (PropertyInfo pro in temp.GetProperties())
                {
                    if (pro.Name.ToUpper() == nameList[i].ToUpper())
                    {
                        pro.SetValue(obj, val, null);
                        break;
                    }
                    else
                    {
                        continue;
                    }
                }
            }

            return obj;
        }

        /// <summary>
        /// 値を返す
        /// </summary>
        /// <param name="type"></param>
        /// <param name="row"></param>
        /// <param name="p"></param>
        /// <returns></returns>
        private object GetFieldValue(Type type, GrpcRow row, ref int p)
        {
            object ret = null;
            if (type == typeof(System.Int32))
            {
                ret = BitConverter.ToInt32(row.Data.Span.Slice(p, 4).ToArray());
                p += 4;
            }
            else if (type == typeof(bool))
            {
                ret = BitConverter.ToBoolean(row.Data.Span.Slice(p, 1).ToArray());
                p += 1;
            }
            else if (type == typeof(DateTime))
            {
                DateTime dateTime = CConvert.ToDateTimeFromBytes(row.Data.Span.Slice(p, 8).ToArray());
                ret = (dateTime.CompareTo(DateTime.MinValue) == 0) ? DBNull.Value : dateTime;
                p += 8;
            }
            else if (type == typeof(float))
            {
                ret = BitConverter.ToSingle(row.Data.Span.Slice(p, 4).ToArray());
                p += 4;
            }
            else if (type == typeof(double))
            {
                ret = BitConverter.ToDouble(row.Data.Span.Slice(p, 8).ToArray());
                p += 8;
            }
            else if (type == typeof(decimal))
            {
                ret = CConvert.ToDecimal(row.Data.Span.Slice(p, 16).ToArray());
                p += 16;
            }
            else if (type == typeof(System.Byte))
            {
                ret = row.Data.Span[p];
                p += 1;
            }
            else if (type == typeof(System.Int16))
            {
                ret = BitConverter.ToInt16(row.Data.Span.Slice(p, 2).ToArray());
                p += 2;
            }
            else
            {
                //0x00まで                        
                List<byte> list = new List<byte>();
                while (true)
                {
                    byte val = row.Data.Span[p];
                    if (val == 0x00) { p++; break; }
                    list.Add(val);
                    p++;
                }
                ret = System.Text.Encoding.UTF8.GetString(list.ToArray());
            }

            return ret;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public DataTable ToDataTable()
        {
            Console.WriteLine($"ToDataTable⇒Begin：{DateTime.Now.ToString("HH:mm:ss fff")}");
            DataTable dataTable = new DataTable();
            dataTable.TableName = Name;
            List<Type> typeList = new List<Type>();
            foreach (GrpcCol col in Cols)
            {
                Type type = CConvert.ToType(col.FieldType);
                typeList.Add(type);
                dataTable.Columns.Add(col.Name, type);
            }

            //データ
            foreach (GrpcRow row in Rows)
            {
                DataRow dtRow = dataTable.NewRow();
                dataTable.Rows.Add(dtRow);

                object[] rowArray = new object[typeList.Count];
                int p = 0;
                for (int i = 0; i < typeList.Count; i++)
                {
                    Type type = typeList[i];
                    rowArray[i] = GetFieldValue(type, row, ref p);
                }
                dtRow.ItemArray = rowArray;
            }
            Console.WriteLine($"ToDataTable⇒End：{DateTime.Now.ToString("HH:mm:ss fff")}");
            return dataTable;
        }
    }
}