using Google.Protobuf;
using Grpc.Core;
using Grpc.Net.Client;
using HotelPms.Data.Client;
using HotelPms.Data.Common;
using HotelPms.Data.Master;
using HotelPms.Share.Util;
using System;
using System.Data;
using System.Threading.Tasks;
using HotelPms.Data;
using System.Collections.Generic;
using HotelPms.Data.Common.Pagination;
using System.Text.Json;
using System.Threading;

namespace HotelPms.DataAccessGrpc.Client
{
    public class RoomViewLayoutAccess : IDisposable
    {
        /// <summary>
        /// チャネル
        /// </summary>
        public GrpcChannel Channel { get; private set; } = null;
        public RoomViewLayoutCore.RoomViewLayoutCoreClient Client { get; private set; } = null;


        public RoomViewLayoutAccess(GrpcChannel channel)
        {
            Channel = channel;
            Client = new RoomViewLayoutCore.RoomViewLayoutCoreClient(Channel);
        }

        public void Dispose()
        {
            
        }

        public bool Exists(int pTabID,int pRow,int pCol)
        {
            return GrpcClient.ExecuteScalarSync(Channel, $"IF EXISTS(SELECT 1 FROM M_RoomViewLayout WHERE TabID = {pTabID} AND Row = {pRow} AND Col = {pCol}) SELECT 1 ELSE SELECT 0") == "1";

        }

        public async Task<bool> ExistsAsync(int pTabID,int pRow,int pCol)
        {
            return await GrpcClient.ExecuteScalar(Channel, $"IF EXISTS(SELECT 1 FROM M_RoomViewLayout WHERE TabID = {pTabID} AND Row = {pRow} AND Col = {pCol}) SELECT 1 ELSE SELECT 0") == "1";

        }

        public async Task<FileGrpcData> OutputStream(PagingRequest request)
        {
            FileGrpcData data = null;
            request.Table = "M_RoomViewLayout";
            string json = JsonSerializer.Serialize(request);
            using (var call = Client.OutputStream(GrpcClient.CreateDataRequest(2, json)))
            {
                var reaponseStream = call.ResponseStream;
                //データの取得
                while (await reaponseStream.MoveNext(CancellationToken.None))
                {
                    data = reaponseStream.Current;
                }
            }
            return data;
        }

        public async Task<RoomViewLayoutTable> GetPageData(PagingRequest request)
        {
            request.Table = "M_RoomViewLayout";
            string json = JsonSerializer.Serialize(request);
            return await Client.GetDataAsync(GrpcClient.CreateDataRequest(1, json));
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        public DataTable GetMasterGridData(string where)
        {
            GrpcTable table = GrpcClient.GetTable(Channel, (int)ETableActionType.RoomViewLayoutGrid, where);
            return table.ToDataTable();
        }

        public async Task<DataTable> GetRoomState(string where)
        {
            GrpcTable table = await GrpcClient.GetTableAsync(Channel, (int)ETableActionType.RoomViewState, where);
            return table.ToDataTable();
        }

        /// <summary>
        /// 客室状況画面の日別表示データ
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        public async Task<DataSet> GetRoomViewData(string where)
        {
            GrpcSet set = await GrpcClient.GetGrpcSet(Channel, (int)ESetActionType.RoomView, where);
            return set.ToDataSet();
        }

        /// <summary>
        /// 同期データ取得
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        public RoomViewLayoutTable GetData(string where)
        {
            return Client.GetData(GrpcClient.CreateDataRequest(0, where));
        }

        public async Task<RoomViewLayoutTable> GetDataAsync(string where)
        {
            return await Client.GetDataAsync(GrpcClient.CreateDataRequest(0, where));
        }

        /// <summary>
        /// データ取得
        /// </summary>
        /// <returns></returns>
        public RoomViewLayout GetItem(int pTabID,int pRow,int pCol)
        {
            RoomViewLayoutTable table = GetData($"TabID = {pTabID} AND Row = {pRow} AND Col = {pCol}");
            if(table == null || table.ErrNo != 0 || table.Rows.Count == 0) { return null; }
            return table.Rows[0];
        }

        public async Task<RoomViewLayoutTable> GetDataStream()
        {
            return await GetDataStream(string.Empty);
        }

        /// <summary>
        /// データ取得
        /// </summary>
        /// <returns></returns>
        public async Task<RoomViewLayoutTable> GetDataStream(string where)
        {
            RoomViewLayoutTable table = null;
            using (var call = Client.GetDataStream())
            {
                await call.RequestStream.WriteAsync(GrpcClient.CreateDataRequest(0, where));
                await call.RequestStream.CompleteAsync();   // Finish call and report results

                //データの取得
                await foreach (var message in call.ResponseStream.ReadAllAsync<RoomViewLayoutTable>())
                {
                    table = message;
                    break;
                }
            }
            return table;
        }

        public async Task<DataResult> AddAsync(RoomViewLayout data)
        {
            return await Client.AddAsync(data);
        }

        public DataResult Add(RoomViewLayout data)
        {
            return Client.Add(data);
        }

        public async Task<DataResult> UpdateAsync(RoomViewLayout data)
        {
            return await Client.UpdateAsync(data);
        }

        public DataResult Update(RoomViewLayout data)
        {
            return Client.Update(data);
        }

        /// <summary>
        /// 追加若しくは更新
        /// </summary>
        /// <param name="data"></param>
        /// <param name="add"></param>
        /// <returns></returns>
        private async Task<DataResult?> AddOrUpdateStream(RoomViewLayout data, bool add)
        {
            DataResult? result = null;
            using (var call = add ? Client.AddStream() : Client.UpdateStream())
            {
                await call.RequestStream.WriteAsync(data);
                await call.RequestStream.CompleteAsync();   // Finish call and report results

                //データの取得
                await foreach (var message in call.ResponseStream.ReadAllAsync<DataResult?>())
                {
                    result = message;
                    break;
                }
            }
            return result;
        }

        /// <summary>
        /// 追加
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public async Task<DataResult> AddStream(RoomViewLayout data)
        {
            return await AddOrUpdateStream(data, true);
        }

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public async Task<DataResult> UpdateStream(RoomViewLayout data)
        {
            return await AddOrUpdateStream(data, true);
        }

        public DataResult Remove(string where)
        {
            SqlWhere data = new SqlWhere()
            {
                Data = ByteString.CopyFromUtf8(where)
            };
            return Client.Remove(data);
        }

        public async Task<DataResult> RemoveAsync(string where)
        {
            SqlWhere data = new SqlWhere()
            {
                Data = ByteString.CopyFromUtf8(where)
            };
            return await Client.RemoveAsync(data);
        }

        /// <summary>
        /// 削除
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        public async Task<DataResult> RemoveStream(string where)
        {
            DataResult result = null;
            SqlWhere data = new SqlWhere()
            {
                Data = ByteString.CopyFromUtf8(where)
            };

            using (var call = Client.RemoveStream())
            {
                await call.RequestStream.WriteAsync(data);
                await call.RequestStream.CompleteAsync();   // Finish call and report results

                //データの取得
                await foreach (var message in call.ResponseStream.ReadAllAsync<DataResult>())
                {
                    result = message;
                    break;
                }
            }
            return result;
        }

        public DataResult SetData(RoomViewLayoutTable table)
        {
            return Client.SetData(table);
        }

        /// <summary>
        /// バッチ更新
        /// </summary>
        /// <param name="table"></param>
        /// <returns></returns>
        public async Task<DataResult> SetDataStream(RoomViewLayoutTable table)
        {
            DataResult result = null;
            using (var call = Client.SetDataStream())
            {
                await call.RequestStream.WriteAsync(table);
                await call.RequestStream.CompleteAsync();   // Finish call and report results

                //データの取得
                await foreach (var message in call.ResponseStream.ReadAllAsync<DataResult>())
                {
                    result = message;
                    break;
                }
            }
            return result;
        }
    }
}