using System;
using System.Collections.Concurrent;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Text;
using HotelPms.Share.Data;
using HotelPms.Share.Util;
using Google.Protobuf.WellKnownTypes;
using customTypes;
using System.Data.Common;

namespace HotelPms.Data.UseInfo;

/// ****************************** Description *******************************
/// ◇システム名称
/// 　ホテルPMS
/// ◇概要
/// 　
/// ◇履歴
/// 　2021/05/14  コード作成ツール    自動作成
/// ****************************** Declarations ******************************
[Serializable()]
public partial class UseRoom : RecordBase
{
    #region  ★★★★★　Property　★★★★★

    public static ConcurrentDictionary<string, int> PrimaryKey { get; } = new ConcurrentDictionary<string, int>();

    #endregion

    partial void OnConstruction()
    {
        if (PrimaryKey.Count == 0)
        {
               PrimaryKey.TryAdd("ID", 0); 
               PrimaryKey.TryAdd("DetailID", 0); 
               PrimaryKey.TryAdd("UseDate", 0); 

        }
    }

    #region  ★★★★★　Function　★★★★★

    public bool CompareTo(UseRoom item)
    {
        if (ID.CompareTo(item.ID) != 0
                || DetailID.CompareTo(item.DetailID) != 0
                || UseDate.CompareTo(item.UseDate) != 0
                || BeginTime.CompareTo(item.BeginTime) != 0
                || EndTime.CompareTo(item.EndTime) != 0
                || RoomTypeID.CompareTo(item.RoomTypeID) != 0
                || RoomKind.CompareTo(item.RoomKind) != 0
                || RoomID.CompareTo(item.RoomID) != 0
                || AgentID.CompareTo(item.AgentID) != 0
                || AgentBranchID.CompareTo(item.AgentBranchID) != 0
                || PersionCount.CompareTo(item.PersionCount) != 0
                || Adult.CompareTo(item.Adult) != 0
                || ChildA.CompareTo(item.ChildA) != 0
                || ChildB.CompareTo(item.ChildB) != 0
                || ChildC.CompareTo(item.ChildC) != 0
                || ChildD.CompareTo(item.ChildD) != 0
                || ChildE.CompareTo(item.ChildE) != 0
                || ChildF.CompareTo(item.ChildF) != 0
                || Infant.CompareTo(item.Infant) != 0
                || InFemaleAdult.CompareTo(item.InFemaleAdult) != 0
                || InFemaleChildA.CompareTo(item.InFemaleChildA) != 0
                || InFemaleChildB.CompareTo(item.InFemaleChildB) != 0
                || InFemaleChildC.CompareTo(item.InFemaleChildC) != 0
                || InFemaleChildD.CompareTo(item.InFemaleChildD) != 0
                || InFemaleChildE.CompareTo(item.InFemaleChildE) != 0
                || InFemaleChildF.CompareTo(item.InFemaleChildF) != 0
                || InFemaleInfant.CompareTo(item.InFemaleInfant) != 0
)
        {
            return false;
        }
        return true;
    }


    public override void CopyTo(object dest)
    {
        UseRoom item = dest as UseRoom;
            item.ID = ID;
            item.DetailID = DetailID;
            item.UseDate = UseDate;
            item.BeginTime = BeginTime;
            item.EndTime = EndTime;
            item.RoomTypeID = RoomTypeID;
            item.RoomKind = RoomKind;
            item.RoomID = RoomID;
            item.AgentID = AgentID;
            item.AgentBranchID = AgentBranchID;
            item.PersionCount = PersionCount;
            item.Adult = Adult;
            item.ChildA = ChildA;
            item.ChildB = ChildB;
            item.ChildC = ChildC;
            item.ChildD = ChildD;
            item.ChildE = ChildE;
            item.ChildF = ChildF;
            item.Infant = Infant;
            item.InFemaleAdult = InFemaleAdult;
            item.InFemaleChildA = InFemaleChildA;
            item.InFemaleChildB = InFemaleChildB;
            item.InFemaleChildC = InFemaleChildC;
            item.InFemaleChildD = InFemaleChildD;
            item.InFemaleChildE = InFemaleChildE;
            item.InFemaleChildF = InFemaleChildF;
            item.InFemaleInfant = InFemaleInfant;

    }

    public override void Clear()
    {
            ID = 0;
            DetailID = 0;
            UseDate = Date.Default;
            BeginTime = 0;
            EndTime = 0;
            RoomTypeID = 0;
            RoomKind = 0;
            RoomID = 0;
            AgentID = 0;
            AgentBranchID = 0;
            PersionCount = 0;
            Adult = 0;
            ChildA = 0;
            ChildB = 0;
            ChildC = 0;
            ChildD = 0;
            ChildE = 0;
            ChildF = 0;
            Infant = 0;
            InFemaleAdult = 0;
            InFemaleChildA = 0;
            InFemaleChildB = 0;
            InFemaleChildC = 0;
            InFemaleChildD = 0;
            InFemaleChildE = 0;
            InFemaleChildF = 0;
            InFemaleInfant = 0;

    }

    public UseRoom DeepClone()
    {
        UseRoom item = new UseRoom();
            item.ID = ID;
            item.DetailID = DetailID;
            item.UseDate = UseDate;
            item.BeginTime = BeginTime;
            item.EndTime = EndTime;
            item.RoomTypeID = RoomTypeID;
            item.RoomKind = RoomKind;
            item.RoomID = RoomID;
            item.AgentID = AgentID;
            item.AgentBranchID = AgentBranchID;
            item.PersionCount = PersionCount;
            item.Adult = Adult;
            item.ChildA = ChildA;
            item.ChildB = ChildB;
            item.ChildC = ChildC;
            item.ChildD = ChildD;
            item.ChildE = ChildE;
            item.ChildF = ChildF;
            item.Infant = Infant;
            item.InFemaleAdult = InFemaleAdult;
            item.InFemaleChildA = InFemaleChildA;
            item.InFemaleChildB = InFemaleChildB;
            item.InFemaleChildC = InFemaleChildC;
            item.InFemaleChildD = InFemaleChildD;
            item.InFemaleChildE = InFemaleChildE;
            item.InFemaleChildF = InFemaleChildF;
            item.InFemaleInfant = InFemaleInfant;

        return item;
    }

    public override bool ConvertDataRow(System.Data.DataRow row)
    {
            ID = CConvert.ToInt(row["ID"],ID); 
            DetailID = CConvert.ToInt(row["DetailID"],DetailID); 
            UseDate = new Date(row.IsNull("UseDate") ? 0 : CConvert.ToDateInt((System.DateTime)row["UseDate"])); 
            BeginTime = CConvert.ToInt(row["BeginTime"],BeginTime); 
            EndTime = CConvert.ToInt(row["EndTime"],EndTime); 
            RoomTypeID = CConvert.ToInt(row["RoomTypeID"],RoomTypeID); 
            RoomKind = CConvert.ToInt(row["RoomKind"],RoomKind); 
            RoomID = CConvert.ToInt(row["RoomID"],RoomID); 
            AgentID = CConvert.ToInt(row["AgentID"],AgentID); 
            AgentBranchID = CConvert.ToInt(row["AgentBranchID"],AgentBranchID); 
            PersionCount = CConvert.ToInt(row["PersionCount"],PersionCount); 
            Adult = CConvert.ToInt(row["Adult"],Adult); 
            ChildA = CConvert.ToInt(row["ChildA"],ChildA); 
            ChildB = CConvert.ToInt(row["ChildB"],ChildB); 
            ChildC = CConvert.ToInt(row["ChildC"],ChildC); 
            ChildD = CConvert.ToInt(row["ChildD"],ChildD); 
            ChildE = CConvert.ToInt(row["ChildE"],ChildE); 
            ChildF = CConvert.ToInt(row["ChildF"],ChildF); 
            Infant = CConvert.ToInt(row["Infant"],Infant); 
            InFemaleAdult = CConvert.ToInt(row["InFemaleAdult"],InFemaleAdult); 
            InFemaleChildA = CConvert.ToInt(row["InFemaleChildA"],InFemaleChildA); 
            InFemaleChildB = CConvert.ToInt(row["InFemaleChildB"],InFemaleChildB); 
            InFemaleChildC = CConvert.ToInt(row["InFemaleChildC"],InFemaleChildC); 
            InFemaleChildD = CConvert.ToInt(row["InFemaleChildD"],InFemaleChildD); 
            InFemaleChildE = CConvert.ToInt(row["InFemaleChildE"],InFemaleChildE); 
            InFemaleChildF = CConvert.ToInt(row["InFemaleChildF"],InFemaleChildF); 
            InFemaleInfant = CConvert.ToInt(row["InFemaleInfant"],InFemaleInfant); 

        return true;
    }

    public void ToDataRow(System.Data.DataRow row)
    {
            row["ID"] = ID;
            row["DetailID"] = DetailID;
            row["UseDate"] = UseDate.ToDateTime();
            row["BeginTime"] = BeginTime;
            row["EndTime"] = EndTime;
            row["RoomTypeID"] = RoomTypeID;
            row["RoomKind"] = RoomKind;
            row["RoomID"] = RoomID;
            row["AgentID"] = AgentID;
            row["AgentBranchID"] = AgentBranchID;
            row["PersionCount"] = PersionCount;
            row["Adult"] = Adult;
            row["ChildA"] = ChildA;
            row["ChildB"] = ChildB;
            row["ChildC"] = ChildC;
            row["ChildD"] = ChildD;
            row["ChildE"] = ChildE;
            row["ChildF"] = ChildF;
            row["Infant"] = Infant;
            row["InFemaleAdult"] = InFemaleAdult;
            row["InFemaleChildA"] = InFemaleChildA;
            row["InFemaleChildB"] = InFemaleChildB;
            row["InFemaleChildC"] = InFemaleChildC;
            row["InFemaleChildD"] = InFemaleChildD;
            row["InFemaleChildE"] = InFemaleChildE;
            row["InFemaleChildF"] = InFemaleChildF;
            row["InFemaleInfant"] = InFemaleInfant;

    }

    public void ConvertReader(DbDataReader row)
    {
        int i = 0;
            ID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            DetailID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            UseDate = new Date(row.IsDBNull(i) ? 0 : CConvert.ToDateInt(row.GetDateTime(i))); i++;
            BeginTime = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++;
            EndTime = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++;
            RoomTypeID = (int)(row.IsDBNull(i) ? 0 : row.GetInt16(i)); i++;
            RoomKind = (byte)(row.IsDBNull(i) ? 0x00 : row.GetByte(i)); i++;
            RoomID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            AgentID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            AgentBranchID = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            PersionCount = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            Adult = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            ChildA = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            ChildB = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            ChildC = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            ChildD = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            ChildE = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            ChildF = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            Infant = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            InFemaleAdult = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            InFemaleChildA = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            InFemaleChildB = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            InFemaleChildC = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            InFemaleChildD = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            InFemaleChildE = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            InFemaleChildF = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;
            InFemaleInfant = (int)(row.IsDBNull(i) ? 0 : row.GetInt32(i)); i++;

    }

    public string AddSql()
    {
            return $@"INSERT INTO D_UseRoom(ID,DetailID,UseDate,BeginTime,EndTime,RoomTypeID,RoomKind,RoomID,AgentID,AgentBranchID,PersionCount,Adult,ChildA,ChildB,ChildC,ChildD,ChildE,ChildF,Infant,InFemaleAdult,InFemaleChildA,InFemaleChildB,InFemaleChildC,InFemaleChildD,InFemaleChildE,InFemaleChildF,InFemaleInfant) VALUES({ID},{DetailID},{(UseDate == null ? "NULL" : UseDate.ToSqlValue())},{BeginTime},{EndTime},{RoomTypeID},{RoomKind},{RoomID},{AgentID},{AgentBranchID},{PersionCount},{Adult},{ChildA},{ChildB},{ChildC},{ChildD},{ChildE},{ChildF},{Infant},{InFemaleAdult},{InFemaleChildA},{InFemaleChildB},{InFemaleChildC},{InFemaleChildD},{InFemaleChildE},{InFemaleChildF},{InFemaleInfant});";
    }

    public string UpdateSql()
    {
            return $@"UPDATE D_UseRoom SET BeginTime = {BeginTime},EndTime = {EndTime},RoomTypeID = {RoomTypeID},RoomKind = {RoomKind},RoomID = {RoomID},AgentID = {AgentID},AgentBranchID = {AgentBranchID},PersionCount = {PersionCount},Adult = {Adult},ChildA = {ChildA},ChildB = {ChildB},ChildC = {ChildC},ChildD = {ChildD},ChildE = {ChildE},ChildF = {ChildF},Infant = {Infant},InFemaleAdult = {InFemaleAdult},InFemaleChildA = {InFemaleChildA},InFemaleChildB = {InFemaleChildB},InFemaleChildC = {InFemaleChildC},InFemaleChildD = {InFemaleChildD},InFemaleChildE = {InFemaleChildE},InFemaleChildF = {InFemaleChildF},InFemaleInfant = {InFemaleInfant} WHERE ID = {ID} AND DetailID = {DetailID} AND UseDate = {(UseDate == null ? "NULL" : UseDate.ToSqlValue())};";
    }

    public string ToText()
    {
        StringBuilder text = new StringBuilder();
            text.AppendFormat("ID={0};", ID);
            text.AppendFormat("DetailID={0};", DetailID);
            text.AppendFormat("UseDate={0};", UseDate);
            text.AppendFormat("BeginTime={0};", BeginTime);
            text.AppendFormat("EndTime={0};", EndTime);
            text.AppendFormat("RoomTypeID={0};", RoomTypeID);
            text.AppendFormat("RoomKind={0};", RoomKind);
            text.AppendFormat("RoomID={0};", RoomID);
            text.AppendFormat("AgentID={0};", AgentID);
            text.AppendFormat("AgentBranchID={0};", AgentBranchID);
            text.AppendFormat("PersionCount={0};", PersionCount);
            text.AppendFormat("Adult={0};", Adult);
            text.AppendFormat("ChildA={0};", ChildA);
            text.AppendFormat("ChildB={0};", ChildB);
            text.AppendFormat("ChildC={0};", ChildC);
            text.AppendFormat("ChildD={0};", ChildD);
            text.AppendFormat("ChildE={0};", ChildE);
            text.AppendFormat("ChildF={0};", ChildF);
            text.AppendFormat("Infant={0};", Infant);
            text.AppendFormat("InFemaleAdult={0};", InFemaleAdult);
            text.AppendFormat("InFemaleChildA={0};", InFemaleChildA);
            text.AppendFormat("InFemaleChildB={0};", InFemaleChildB);
            text.AppendFormat("InFemaleChildC={0};", InFemaleChildC);
            text.AppendFormat("InFemaleChildD={0};", InFemaleChildD);
            text.AppendFormat("InFemaleChildE={0};", InFemaleChildE);
            text.AppendFormat("InFemaleChildF={0};", InFemaleChildF);
            text.AppendFormat("InFemaleInfant={0};", InFemaleInfant);

        return text.ToString();
    }

    public override object GetField(string name)
    {

            if (name == "ID") { return ID; }
            else if (name == "DetailID") { return DetailID; }
            else if (name == "UseDate") { return UseDate; }
            else if (name == "BeginTime") { return BeginTime; }
            else if (name == "EndTime") { return EndTime; }
            else if (name == "RoomTypeID") { return RoomTypeID; }
            else if (name == "RoomKind") { return RoomKind; }
            else if (name == "RoomID") { return RoomID; }
            else if (name == "AgentID") { return AgentID; }
            else if (name == "AgentBranchID") { return AgentBranchID; }
            else if (name == "PersionCount") { return PersionCount; }
            else if (name == "Adult") { return Adult; }
            else if (name == "ChildA") { return ChildA; }
            else if (name == "ChildB") { return ChildB; }
            else if (name == "ChildC") { return ChildC; }
            else if (name == "ChildD") { return ChildD; }
            else if (name == "ChildE") { return ChildE; }
            else if (name == "ChildF") { return ChildF; }
            else if (name == "Infant") { return Infant; }
            else if (name == "InFemaleAdult") { return InFemaleAdult; }
            else if (name == "InFemaleChildA") { return InFemaleChildA; }
            else if (name == "InFemaleChildB") { return InFemaleChildB; }
            else if (name == "InFemaleChildC") { return InFemaleChildC; }
            else if (name == "InFemaleChildD") { return InFemaleChildD; }
            else if (name == "InFemaleChildE") { return InFemaleChildE; }
            else if (name == "InFemaleChildF") { return InFemaleChildF; }
            else if (name == "InFemaleInfant") { return InFemaleInfant; }
        else { return null; }
    }

    public override bool SetField(string name, object value)
    {

            if (name == "ID") { ID = CConvert.ToInt(value); return true; }
            else if (name == "DetailID") { DetailID = CConvert.ToInt(value); return true; }
            else if (name == "UseDate") { UseDate = new Date(CConvert.ToDateInt(value)); return true; }
            else if (name == "BeginTime") { BeginTime = CConvert.ToInt(value); return true; }
            else if (name == "EndTime") { EndTime = CConvert.ToInt(value); return true; }
            else if (name == "RoomTypeID") { RoomTypeID = CConvert.ToInt(value); return true; }
            else if (name == "RoomKind") { RoomKind = CConvert.ToInt(value); return true; }
            else if (name == "RoomID") { RoomID = CConvert.ToInt(value); return true; }
            else if (name == "AgentID") { AgentID = CConvert.ToInt(value); return true; }
            else if (name == "AgentBranchID") { AgentBranchID = CConvert.ToInt(value); return true; }
            else if (name == "PersionCount") { PersionCount = CConvert.ToInt(value); return true; }
            else if (name == "Adult") { Adult = CConvert.ToInt(value); return true; }
            else if (name == "ChildA") { ChildA = CConvert.ToInt(value); return true; }
            else if (name == "ChildB") { ChildB = CConvert.ToInt(value); return true; }
            else if (name == "ChildC") { ChildC = CConvert.ToInt(value); return true; }
            else if (name == "ChildD") { ChildD = CConvert.ToInt(value); return true; }
            else if (name == "ChildE") { ChildE = CConvert.ToInt(value); return true; }
            else if (name == "ChildF") { ChildF = CConvert.ToInt(value); return true; }
            else if (name == "Infant") { Infant = CConvert.ToInt(value); return true; }
            else if (name == "InFemaleAdult") { InFemaleAdult = CConvert.ToInt(value); return true; }
            else if (name == "InFemaleChildA") { InFemaleChildA = CConvert.ToInt(value); return true; }
            else if (name == "InFemaleChildB") { InFemaleChildB = CConvert.ToInt(value); return true; }
            else if (name == "InFemaleChildC") { InFemaleChildC = CConvert.ToInt(value); return true; }
            else if (name == "InFemaleChildD") { InFemaleChildD = CConvert.ToInt(value); return true; }
            else if (name == "InFemaleChildE") { InFemaleChildE = CConvert.ToInt(value); return true; }
            else if (name == "InFemaleChildF") { InFemaleChildF = CConvert.ToInt(value); return true; }
            else if (name == "InFemaleInfant") { InFemaleInfant = CConvert.ToInt(value); return true; }
        else { return false; }
    }

    #endregion
}