using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DevadminDAL.DTO.Replicate
{
    public class ReplicateDTO
    {
        #region PrivateMembers
        #region Replicate
        private int replicateid;                            //Id
        private string replicatedescription;                //Description
        private int replicatefromserverid;                    //FromServer
        private int replicatefromdatabaseid;                  //FromDataBase
        private int replicatetoserverid;                      //ToServer
        private int replicatetodatabaseid;                    //ToDataBase

        private string replicatefromservername;                    //FromServer
        private string replicatefromdatabasename;                  //FromDataBase
        private string replicatetoservername;                      //ToServer
        private string replicatetodatabasename;                    //ToDataBase


        #region DataSet
        private int datasetid;                            //Id
        private string datasetcode;                       //Code
        private string datasetname;                       //Name
        #endregion

        #region Scheduler
        private int schedulerid;                            //Id
        private string schedulercode;                       //Code
        private string schedulername;                       //Name
        #endregion

        private byte replicateisoverwrite;               //IsOverWrite
        private DateTime replicatelastinsertedtill;         //LastInsertedTill
        private DateTime replicatelastupdatedtill;          //LastUpdatedTill
        private DateTime replicatelastdeletedtill;          //LastDeletedTill
        #endregion

        #region Base
        private int replicatecreatedbyid;                   //CreatedById
        private string replicatecreatedbyname;                   //CreatedByName
        private DateTime replicatecreatedon;                //CreatedOn
        private int replicatemodifiedbyid;                  //ModifiedById
        private string replicatemodifiedbyname;                  //ModifiedByName
        private DateTime replicatemodifiedon;               //ModifiedOn
        private int replicatebaseclinetid;                  //BaseClinetId
        #endregion

        #region Standard
        private Int16 replicatesortorder;                     //SortOrder
        private byte replicatestatus;                    //Status
        private Int16 replicateversion;                       //Version
        private byte replicatesourcetype;                //SourceType
        private string replicatequerycondition;
        #endregion

        #endregion


        #region PublicMembers
        #region Replicate
        public int ReplicateId
        {
            get { return replicateid; }                            //Id
            set { replicateid = value; }                            //Id
        }

        public string ReplicateDescription
        {
            get { return replicatedescription; }                   //Description
            set { replicatedescription = value; }                   //Description
        }

        public int ReplicateFromServerId
        {
            get { return replicatefromserverid; }                    //FromServer
            set { replicatefromserverid = value; }                    //FromServer
        }

        public int ReplicateFromDataBaseId
        {
            get { return replicatefromdatabaseid; }                  //FromDataBase
            set { replicatefromdatabaseid = value; }                  //FromDataBase
        }

        public int ReplicateToServerId
        {
            get { return replicatetoserverid; }                      //ToServer
            set { replicatetoserverid = value; }                      //ToServer
        }

        public int ReplicateToDataBaseId
        {
            get { return replicatetodatabaseid; }                    //ToDataBase
            set { replicatetodatabaseid = value; }                    //ToDataBase
        }
        public string ReplicateFromServerName
        {
            get { return replicatefromservername; }                    //FromServer
            set { replicatefromservername = value; }                    //FromServer
        }

        public string ReplicateFromDataBaseName
        {
            get { return replicatefromdatabasename; }                  //FromDataBase
            set { replicatefromdatabasename = value; }                  //FromDataBase
        }

        public string ReplicateToServerName
        {
            get { return replicatetoservername; }                      //ToServer
            set { replicatetoservername = value; }                      //ToServer
        }

        public string ReplicateToDataBaseName
        {
            get { return replicatetodatabasename; }                    //ToDataBase
            set { replicatetodatabasename = value; }                    //ToDataBase
        }

        #region DataSet
        public int DatasetId
        {
            get { return datasetid; }                            //Id
            set { datasetid = value; }                            //Id
        }

        public string DatasetCode
        {
            get { return datasetcode; }                          //Code
            set { datasetcode = value; }                          //Code
        }

        public string DatasetName
        {
            get { return datasetname; }                          //Name
            set { datasetname = value; }                          //Name
        }
        #endregion

        #region Scheduler
        public int SchedulerId
        {
            get { return schedulerid; }                            //Id
            set { schedulerid = value; }                            //Id
        }

        public string SchedulerCode
        {
            get { return schedulercode; }                          //Code
            set { schedulercode = value; }                          //Code
        }

        public string SchedulerName
        {
            get { return schedulername; }                          //Name
            set { schedulername = value; }                          //Name
        }

        #endregion

        public byte ReplicateIsOverWrite
        {
            get { return replicateisoverwrite; }                   //IsOverWrite
            set { replicateisoverwrite = value; }                   //IsOverWrite
        }

        public DateTime ReplicateLastInsertedTill
        {
            get { return replicatelastinsertedtill; }              //LastInsertedTill
            set { replicatelastinsertedtill = value; }              //LastInsertedTill
        }

        public DateTime ReplicateLastUpdatedTill
        {
            get { return replicatelastupdatedtill; }               //LastUpdatedTill
            set { replicatelastupdatedtill = value; }               //LastUpdatedTill
        }

        public DateTime ReplicateLastDeletedTill
        {
            get { return replicatelastdeletedtill; }               //LastDeletedTill
            set { replicatelastdeletedtill = value; }               //LastDeletedTill
        }


        #endregion

        #region Base
        public int ReplicateCreatedById
        {
            get { return replicatecreatedbyid; }                   //CreatedById
            set { replicatecreatedbyid = value; }                   //CreatedById
        }

        public string ReplicateCreatedByName
        {
            get { return replicatecreatedbyname; }                   //CreatedByName
            set { replicatecreatedbyname = value; }                   //CreatedByName
        }

        public DateTime ReplicateCreatedOn
        {
            get { return replicatecreatedon; }                     //CreatedOn
            set { replicatecreatedon = value; }                     //CreatedOn
        }

        public int ReplicateModifiedById
        {
            get { return replicatemodifiedbyid; }                  //ModifiedById
            set { replicatemodifiedbyid = value; }                  //ModifiedById
        }

        public string ReplicateModifiedByName
        {
            get { return replicatemodifiedbyname; }                  //ModifiedByName
            set { replicatemodifiedbyname = value; }                  //ModifiedByName
        }

        public DateTime ReplicateModifiedOn
        {
            get { return replicatemodifiedon; }                    //ModifiedOn
            set { replicatemodifiedon = value; }                    //ModifiedOn
        }

        public int ReplicateBaseClinetId
        {
            get { return replicatebaseclinetid; }                  //BaseClinetId
            set { replicatebaseclinetid = value; }                  //BaseClinetId
        }


        #endregion

        #region Standard
        public Int16 ReplicateSortOrder
        {
            get { return replicatesortorder; }                     //SortOrder
            set { replicatesortorder = value; }                     //SortOrder
        }

        public byte ReplicateStatus
        {
            get { return replicatestatus; }                        //Status
            set { replicatestatus = value; }                        //Status
        }

        public Int16 ReplicateVersion
        {
            get { return replicateversion; }                       //Version
            set { replicateversion = value; }                       //Version
        }

        public byte ReplicateSourceType
        {
            get { return replicatesourcetype; }                    //SourceType
            set { replicatesourcetype = value; }                    //SourceType
        }

        public string ReplicateQueryCondition
        {
            get { return replicatequerycondition; }                   //ReplicateQueryCondition
            set { replicatequerycondition = value; }                  //ReplicateQueryCondition
        }

        #endregion
        #endregion
    }

    // Flat list row for the admin browse screen (tracker §41) — mirrors GET_REPLICATE_LIST's
    // own column set, not the full detail row (no need to carry every watermark/audit field
    // just to render a list).
    public class ReplicateListDTO
    {
        public int      ReplicateId              { get; set; }
        public string?  ReplicateDescription      { get; set; }
        public int      ReplicateFromServerId     { get; set; }
        public int      ReplicateFromDataBaseId   { get; set; }
        public int      ReplicateToServerId       { get; set; }
        public int      ReplicateToDataBaseId     { get; set; }
        public int      SchedulerId               { get; set; }
        public int      DatasetId                 { get; set; }
        public byte     ReplicateIsOverWrite       { get; set; }
        public DateTime ReplicateLastInsertedTill { get; set; }
        public DateTime ReplicateLastUpdatedTill  { get; set; }
        public DateTime ReplicateLastDeletedTill  { get; set; }
        public short    ReplicateSortOrder        { get; set; }
        public byte     ReplicateStatus           { get; set; }
    }
}