using System.Text;

namespace HotelPms.Data.Common.Util
{
    public class UseSql
    {
        /// <summary>
        /// 利用情報
        /// </summary>
        public StringBuilder Use { get; set; } = new StringBuilder();

        /// <summary>
        /// 利用者
        /// </summary>
        public StringBuilder UsePerson { get; set; } = new StringBuilder();

        /// <summary>
        /// 利用者自由集計
        /// </summary>
        public StringBuilder UsePersonFree { get; set; } = new StringBuilder();

        /// <summary>
        /// 利用者電話
        /// </summary>
        public StringBuilder UsePersonTel { get; set; } = new StringBuilder();

        /// <summary>
        /// 利用明細
        /// </summary>
        public StringBuilder UseDetail { get; set; } = new StringBuilder();

        /// <summary>
        /// 日毎利用部屋
        /// </summary>
        public StringBuilder UseRoom { get; set; } = new StringBuilder();

        /// <summary>
        /// 部屋割り
        /// </summary>
        public StringBuilder UseAllo { get; set; } = new StringBuilder();

        /// <summary>
        /// 利用単位、連泊単位、日部屋単位の自由集計
        /// </summary>
        public StringBuilder UseFree { get; set; } = new StringBuilder();

        /// <summary>
        /// 利用メモ
        /// </summary>
        public StringBuilder UseMemo { get; set; } = new StringBuilder();

        /// <summary>
        /// 売上
        /// </summary>
        public StringBuilder Sale { get; set; } = new StringBuilder();

        /// <summary>
        /// 入金
        /// </summary>
        public StringBuilder Pay { get; set; } = new StringBuilder();

        /// <summary>
        /// 手配
        /// </summary>
        public StringBuilder Arrange { get; set; } = new StringBuilder();

        /// <summary>
        /// 領収書(利用情報含まない)
        /// </summary>
        public StringBuilder Receipt { get; set; } = new StringBuilder();

        /// <summary>
        /// 領収書明細(利用情報含まない)
        /// </summary>
        public StringBuilder ReceiptDetail { get; set; } = new StringBuilder();

        /// <summary>
        /// 領収書税金(利用情報含まない)
        /// </summary>
        public StringBuilder ReceiptTax { get; set; } = new StringBuilder();

        /// <summary>
        /// 会場(利用情報含まない)
        /// </summary>
        public StringBuilder Hall { get; set; } = new StringBuilder();

        /// <summary>
        /// 貸出品
        /// </summary>
        public StringBuilder Rental { get; set; } = new StringBuilder();

        /// <summary>
        /// 新規・変更
        /// </summary>
        public bool IsNew { get; set; } = false;

        /// <summary>
        /// 利用ID
        /// </summary>
        public int ID { get; set; } = 0;

        /// <summary>
        /// 新規かどうか
        /// </summary>
        /// <param name="isNew"></param>
        public UseSql(bool isNew, int id) 
        {
            IsNew = isNew;
            ID = id;

            if (isNew)
            {
                UsePerson.AppendLine($"DELETE FROM D_UsePerson WHERE ID = {ID};");
                UsePersonFree.AppendLine($"DELETE FROM D_UsePersonFree WHERE ID = {ID};");
                UsePersonTel.AppendLine($"DELETE FROM D_UsePersonTel WHERE ID = {ID};");
                UseDetail.AppendLine($"DELETE FROM D_UseDetail WHERE ID = {ID};");
                UseRoom.AppendLine($"DELETE FROM D_UseRoom WHERE ID = {ID};");
                UseAllo.AppendLine($"DELETE FROM D_UseAllo WHERE ID = {ID};");
                UseFree.AppendLine($"DELETE FROM D_UseFree WHERE ID = {ID};");
                UseMemo.AppendLine($"DELETE FROM D_UseMemo WHERE ID = {ID};");
                Sale.AppendLine($"DELETE FROM D_Sale WHERE ID = {ID};");
                Pay.AppendLine($"DELETE FROM D_Pay WHERE ID = {ID};");
                Arrange.AppendLine($"DELETE FROM D_Arrange WHERE ID = {ID};");
                Rental.AppendLine($"DELETE FROM D_Rental WHERE ID = {ID};");
            }
        }

        /// <summary>
        /// 利用情報核心データ更新
        /// 更新順番固定!!
        /// </summary>
        /// <returns></returns>
        public override string ToString()
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendLine(SyncConfig.GetLockSql(ESyncType.Use));  //デッドロック防止
            sql.Append(UseMemo.ToString());
            sql.Append(UseFree.ToString());
            sql.Append(Arrange.ToString());
            sql.Append(UsePersonFree.ToString());
            sql.Append(UsePersonTel.ToString());
            sql.Append(UsePerson.ToString());
            sql.Append(Pay.ToString());
            sql.Append(Sale.ToString());
            sql.Append(Rental.ToString());
            sql.Append(UseAllo.ToString());
            sql.Append(UseRoom.ToString());
            sql.Append(UseDetail.ToString());
            sql.Append(Use.ToString());
            return sql.ToString();
        }
    }
}