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;
using System.Security.Cryptography;

namespace HotelPms.DataAccessGrpc.Client;

public class ItemAccess : IDisposable
{
    /// <summary>
    /// チャネル
    /// </summary>
    public GrpcChannel Channel { get; private set; } = null;
    public ItemCore.ItemCoreClient Client { get; private set; } = null;


    public ItemAccess(GrpcChannel channel)
    {
        Channel = channel;
        Client = new ItemCore.ItemCoreClient(Channel);
    }

    public void Dispose()
    {
            
    }

    public bool Exists(string pID)
    {
        return GrpcClient.ExecuteScalarSync(Channel, $"IF EXISTS(SELECT 1 FROM M_Item WHERE ID = N'{pID}') SELECT 1 ELSE SELECT 0") == "1";

    }

    public async Task<bool> ExistsAsync(string pID)
    {
        return await GrpcClient.ExecuteScalar(Channel, $"IF EXISTS(SELECT 1 FROM M_Item WHERE ID = N'{pID}') SELECT 1 ELSE SELECT 0") == "1";

    }

    public async Task<FileGrpcData> OutputStream(PagingRequest request)
    {
        FileGrpcData data = null;
        request.Table = "M_Item";
        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<ItemTable> GetPageData(PagingRequest request)
    {
        request.Table = "M_Item";
        string json = JsonSerializer.Serialize(request);
        return await Client.GetDataAsync(GrpcClient.CreateDataRequest(1, json));
    }

    /// <summary>
    /// 部屋タイプの基本料金を返す
    /// </summary>
    /// <param name="roomTypeID"></param>
    /// <param name="personCount"></param>
    /// <param name="useDate"></param>
    /// <returns></returns>
    public async Task<Item?> GetBaseItem(int roomTypeID, int personCount, string useDate)
    {
        ItemTable table = await Client.GetDataAsync(GrpcClient.CreateDataRequest(3, $"{roomTypeID},{personCount},{useDate}"));
        if (table == null || table.ErrNo != 0 || table.Rows.Count == 0) { return null; }
        return table.Rows[0];
    }

    public DataTable GetMasterGridData(string where)
    {
        GrpcTable table = GrpcClient.GetTable(Channel, (int)ETableActionType.BuildingMasterGrid, where);
        return table.ToDataTable();
    }

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

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

    public Item GetItem(string pID)
    {
        ItemTable table = GetData($"ID = N'{pID}'");
        if (table == null || table.ErrNo != 0 || table.Rows.Count == 0) { return null; }
        return table.Rows[0];
    }

    /// <summary>
    /// データ取得
    /// </summary>
    /// <returns></returns>
    public async Task<Item?> GetItemAsync(string pID)
    {
        ItemTable table = await GetDataAsync($"ID = N'{pID}'");
        if(table == null || table.ErrNo != 0 || table.Rows.Count == 0) { return null; }
        return table.Rows[0];
    }

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

    /// <summary>
    /// データ取得
    /// </summary>
    /// <returns></returns>
    public async Task<ItemTable> GetDataStream(string where)
    {
        ItemTable 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<ItemTable>())
            {
                table = message;
                break;
            }
        }
        return table;
    }

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

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

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

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

    /// <summary>
    /// 追加若しくは更新
    /// </summary>
    /// <param name="data"></param>
    /// <param name="add"></param>
    /// <returns></returns>
    private async Task<DataResult> AddOrUpdateStream(Item 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(Item data)
    {
        return await AddOrUpdateStream(data, true);
    }

    /// <summary>
    /// 更新
    /// </summary>
    /// <param name="data"></param>
    /// <returns></returns>
    public async Task<DataResult> UpdateStream(Item 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(ItemTable table)
    {
        return Client.SetData(table);
    }

    /// <summary>
    /// バッチ更新
    /// </summary>
    /// <param name="table"></param>
    /// <returns></returns>
    public async Task<DataResult> SetDataStream(ItemTable 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;
    }
}