MARKUS

using Dapper;

using NUnit.Framework;

using System;

using System.Collections.Generic;

namespace Markus.Service.DataBase.Test

{

    /// <summary>

    /// PostgreSQL

    /// </summary>

    public class DataBaseServiceproperties : TestBaseMSSQL

    {

        /// <summary>

        /// Get SERVICE_PROPERTIES

        /// </summary>

        [Test, Description("SERVICEPROPERTIES")]

        public void GetServiceProperties()

        {

            using (Markus.Service.DataBase.Repositories.SERVICEPROPERTIESRepository repository = new Repositories.SERVICEPROPERTIESRepository(ConnectionStr, dbtype))

            {

                var sERVICEPROPERTIEs = repository.GetAsync().GetAwaiter().GetResult();

                foreach (var serviceproperty in sERVICEPROPERTIEs) {

                    Console.WriteLine($"ID : {serviceproperty.ID}");

                    break;

                }

            }

        }

        /// <summary>

        /// Get SERVICE_PROPERTY

        /// </summary>

        [Test, Description("SERVICE_PROPERTY")]

        public void GetServiceProperty()

        {

            using (Markus.Service.DataBase.Repositories.SERVICEPROPERTIESRepository repository = new Repositories.SERVICEPROPERTIESRepository(ConnectionStr, dbtype))

            {

                var serviceDatas = repository.GetAsync().GetAwaiter().GetResult();

                if(serviceDatas.Count> 0) {

                    var serviceproperty = repository.GetSingleAsync(serviceDatas[0].ID).GetAwaiter().GetResult();

                    Console.WriteLine($"ID : {serviceproperty.ID}");

                }

            }

        }

    }

}