using HotelPms.Client.Blazor.Util;
using HotelPms.Data;
using HotelPms.Data.Common;
using Grpc.Net.Client;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Threading.Channels;
using System.Threading.Tasks;
using HotelPms.Data.Client;

namespace HotelPms.Client.Blazor.ViewModel
{
    public class ColSettingData
    {
        /// <summary>
        /// 帳票ID
        /// </summary>
        public int ReportID { get; set; } = 0;

        /// <summary>
        /// 帳票名
        /// </summary>
        public string ReportName { get; set; }

        /// <summary>
        /// 項目一覧(S_ReportCol)
        /// </summary>
        public List<string> OrgColList { get; set; }

        /// <summary>
        /// 出力パターンID
        /// </summary>
        public int OutputID { get; set; }

        /// <summary>
        ///  出力パターン名
        /// </summary>
        public string OutputName { get; set; }

        /// <summary>
        /// 出力パターン候補一覧
        /// </summary>
        internal List<HotelPms.Data.Master.Output> OutputList { get; set; }

        /// <summary>
        /// 第一ソート順
        /// </summary>
        public string Sort1 { get; set; }

        /// <summary>
        /// 第二ソート順
        /// </summary>
        public string Sort2 { get; set; }

        public List<ColSettingRow> Rows { get; set; }


        /// <summary>
        /// 帳票設定データの作成
        /// </summary>
        /// <param name="reportID"></param>
        /// <param name="channel"></param>
        /// <returns></returns>
        public static async Task<ColSettingData> Create(int reportID, GrpcChannel channel)
        {
            string name = string.Empty;
            GrpcSet grpcSet = await GrpcClient.GetDataSet(channel, (int)ESetActionType.ColSetting, $"{Environment.MachineName},{EnvironmentSetting.UserName},{reportID}");
            if (grpcSet.ErrNo != 0) { return null; }

            using (DataTable dataTable = grpcSet.Tables[0].ToDataTable())
            {
                if (dataTable.Rows.Count > 0)
                {
                    name = dataTable.Rows[0]["Name"].ToString();
                }
            }

            List<string> list = new List<string>();
            using (DataTable dataTable = grpcSet.Tables[3].ToDataTable())
            {
                foreach(DataColumn col in dataTable.Columns)
                {
                    list.Add(col.ColumnName);
                }
            }

            //取得する（列設定情報）
            ColSettingData data = new ColSettingData
            {
                ReportID = reportID,
                ReportName = name,
                OutputList = grpcSet.Tables[1].Convert<HotelPms.Data.Master.Output>(),
                OrgColList = list,
                Rows = new List<ColSettingRow>(),
            };

            //Dict化
            Dictionary<int, HotelPms.Data.Master.Output> dict = new Dictionary<int, HotelPms.Data.Master.Output>();
            foreach (HotelPms.Data.Master.Output item in data.OutputList) { dict.Add(item.ID, item); } 

            //明細
            using (DataTable detail = grpcSet.Tables[2].ToDataTable())
            {
                foreach (DataRow row in detail.Rows)
                {
                    Data.Master.OutputItem outputItem = new Data.Master.OutputItem();
                    outputItem.ConvertDataRow(row);
                    Data.Master.Output parent = null;
                    if (!dict.TryGetValue(outputItem.OutputID, out parent)) { continue; }
                    parent.Items.Add(outputItem);
                }
            }

            return data;
        }
    }
}