MARKUS

<?xml version="1.0" encoding="utf-8"?>

<Project ToolsVersion="4.0" DefaultTargets="Build" InitialTargets="EnsureWixToolsetInstalled" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

  <PropertyGroup>

    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>

    <Platform Condition=" '$(Platform)' == '' ">x86</Platform>

    <ProductVersion>3.10</ProductVersion>

    <ProjectGuid>ad7ee515-34e5-4123-a0cd-b2f6ecc48e56</ProjectGuid>

    <SchemaVersion>2.0</SchemaVersion>

    <OutputName>ConvertMonitorSetup</OutputName>

    <OutputType>Package</OutputType>

  </PropertyGroup>

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|x86' ">

    <OutputPath>bin\$(Configuration)\</OutputPath>

    <IntermediateOutputPath>obj\$(Configuration)\</IntermediateOutputPath>

    <DefineConstants>Debug</DefineConstants>

  </PropertyGroup>

  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|x86' ">

    <OutputPath>bin\$(Configuration)\</OutputPath>

    <IntermediateOutputPath>obj\$(Configuration)\</IntermediateOutputPath>

  </PropertyGroup>

  <ItemGroup>

    <Compile Include="Product.wxs" />

  </ItemGroup>

  <ItemGroup>

    <Content Include="ConvertMonitorSetup.wax" />

  </ItemGroup>

  <ItemGroup>

    <ProjectReference Include="..\Markus.Service.Monitor\Markus.Service.MonitorService.csproj">

      <Name>Markus.Service.MonitorService</Name>

      <Project>{3f200e07-de20-41f5-984f-a8371fef17a4}</Project>

      <Private>True</Private>

      <DoNotHarvest>True</DoNotHarvest>

      <RefProjectOutputGroups>Binaries;Content;Satellites</RefProjectOutputGroups>

      <RefTargetDir>INSTALLFOLDER</RefTargetDir>

    </ProjectReference>

  </ItemGroup>

  <Import Project="$(WixTargetsPath)" Condition=" '$(WixTargetsPath)' != '' " />

  <Import Project="$(MSBuildExtensionsPath32)\Microsoft\WiX\v3.x\Wix.targets" Condition=" '$(WixTargetsPath)' == '' AND Exists('$(MSBuildExtensionsPath32)\Microsoft\WiX\v3.x\Wix.targets') " />

  <Target Name="EnsureWixToolsetInstalled" Condition=" '$(WixTargetsImported)' != 'true' ">

    <Error Text="The WiX Toolset v3.11 (or newer) build tools must be installed to build this project. To download the WiX Toolset, see http://wixtoolset.org/releases/" />

  </Target>

  <!--

	To modify your build process, add your task inside one of the targets below and uncomment it.

	Other similar extension points exist, see Wix.targets.

	<Target Name="BeforeBuild">

	</Target>

	<Target Name="AfterBuild">

	</Target>

	-->

</Project>

<?xml version="1.0" encoding="UTF-8"?>

<Wix xmlns="http://schemas.microsoft.com/wix/2006/wi"><?define Markus.Service.MonitorService_TargetDir=$(var.Markus.Service.MonitorService.TargetDir)?><?define Markus.Service.WcfClient_TargetDir=$(var.Markus.Service.WcfClient.TargetDir)?><?define Markus.Service.Extensions_TargetDir=$(var.Markus.Service.Extensions.TargetDir)?><?define Markus.Service.Interface_TargetDir=$(var.Markus.Service.Interface.TargetDir)?>

	<Product Id="*" Name="ConvertMonitorSetup" Language="1033" Version="1.0.0.0" Manufacturer="" UpgradeCode="5b113c28-01b6-4cb2-a723-c88ed1e2b93a">

		<Package InstallerVersion="200" Compressed="yes" InstallScope="perMachine" />

		<MajorUpgrade DowngradeErrorMessage="A newer version of [ProductName] is already installed." />

		<MediaTemplate />

		<Feature Id="ProductFeature" Title="ConvertMonitorSetup" Level="1">

			<ComponentGroupRef Id="ProductComponents" />

		</Feature>

	</Product>

	<Fragment>

		<Directory Id="TARGETDIR" Name="SourceDir">

			<Directory Id="ProgramFilesFolder">

				<Directory Id="INSTALLFOLDER" Name="ConvertMonitorSetup" />

			</Directory>

		</Directory>

	</Fragment>

	<Fragment>

		<ComponentGroup Id="ProductComponents" Directory="INSTALLFOLDER">

			<!-- TODO: Remove the comments around this Component element and the ComponentRef below in order to add resources to this installer. -->

			<!-- <Component Id="ProductComponent"> -->

				<!-- TODO: Insert files, registry keys, and other resources here. -->

			<!-- </Component> -->

			<Component Id="Log.config" Guid="2109f413-8b65-42a6-a768-4bd75af0736a">

			  <File Id="Log.config" Name="Log.config" Source="$(var.Markus.Service.MonitorService_TargetDir)Log.config" />

			</Component>

			<Component Id="Markus.Service.MonitorService.exe" Guid="758f5d59-2318-4c86-a2e0-f065688f720f">

			  <File Id="Markus.Service.MonitorService.exe" Name="Markus.Service.MonitorService.exe" Source="$(var.Markus.Service.MonitorService_TargetDir)Markus.Service.MonitorService.exe" />

			</Component>

			<Component Id="Markus.Service.MonitorService.exe.config" Guid="4ed36875-8562-4e18-bb9c-5d07201f167f">

			  <File Id="Markus.Service.MonitorService.exe.config" Name="Markus.Service.MonitorService.exe.config" Source="$(var.Markus.Service.MonitorService_TargetDir)Markus.Service.MonitorService.exe.config" />

			</Component>

			<Component Id="log4net.dll" Guid="2dc76b99-a439-4ffb-86b4-8d2657badb08">

			  <File Id="log4net.dll" Name="log4net.dll" Source="$(var.Markus.Service.MonitorService_TargetDir)log4net.dll" />

			</Component>

			<Component Id="Markus.Service.WcfClient.dll" Guid="f7324b48-de59-4d2c-804a-166c89aff500">

			  <File Id="Markus.Service.WcfClient.dll" Name="Markus.Service.WcfClient.dll" Source="$(var.Markus.Service.WcfClient_TargetDir)Markus.Service.WcfClient.dll" />

			</Component>

			<Component Id="ConfigParser.dll" Guid="b80b36cb-1a1b-4c07-9aff-f4b648315f0c">

			  <File Id="ConfigParser.dll" Name="ConfigParser.dll" Source="$(var.Markus.Service.MonitorService_TargetDir)ConfigParser.dll" />

			</Component>

			<Component Id="Markus.Service.Extensions.dll" Guid="ce3c0eca-628f-4429-ac01-d1a25bc56528">

			  <File Id="Markus.Service.Extensions.dll" Name="Markus.Service.Extensions.dll" Source="$(var.Markus.Service.Extensions_TargetDir)Markus.Service.Extensions.dll" />

			</Component>

			<Component Id="Markus.Service.Interface.dll" Guid="c196ea04-f2d8-4174-8533-53a13fdc9d6c">

			  <File Id="Markus.Service.Interface.dll" Name="Markus.Service.Interface.dll" Source="$(var.Markus.Service.Interface_TargetDir)Markus.Service.Interface.dll" />

			</Component>

		</ComponentGroup>

	</Fragment>

</Wix>

        /// <summary>

        /// Item 삭제

        /// </summary>

        /// <returns></returns>

        public int RemoveItem(string convertID)

        {

            int result = 0;

            var items = entities.CONVERTER_DOC.Where(x => x.ID == convertID);

            if (items.Count() > 0)

            {

                CONVERTER_DOC item = items.First();

                entities.CONVERTER_DOC.Remove(item);

                result = entities.SaveChanges();

            }

            return result;

        }

<?xml version="1.0" encoding="utf-8"?>

<configuration>

  <configSections>

    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />

  </configSections>

  <log4net>

    <appender name="EventLogAppender" type="log4net.Appender.EventLogAppender">

      <applicationName value="Markus Monitor Service"/>

      <layout type="log4net.Layout.PatternLayout">

        <conversionPattern value="%date [%thread] %-5level %logger - %message%newline" />

      </layout>

    </appender>

    <root>

      <level value="All" />

      <appender-ref ref="EventLogAppender" />

    </root>

  </log4net>

</configuration>

            this.serviceProcessInstaller1.Account = System.ServiceProcess.ServiceAccount.LocalSystem;

                    var convertItem = database.GetConvertItembyDocumentID(ProjectNo, DocumentID);

                    if(convertItem != null)

                    {

                        var aliveItems = AliveConvertQueue.Where(x => x.ConvertID == convertItem.ConvertID);

                    }

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

    <startup> 

        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />

    </startup>

</configuration>

<?xml version="1.0" encoding="utf-8"?>

<packages>

  <package id="Microsoft.CSharp" version="4.5.0" targetFramework="net45" />

  <package id="Salaros.ConfigParser" version="0.3.3" targetFramework="net45" />

</packages>

Project("{930C7802-8A8C-48F9-8165-68863BCCD9DD}") = "ConvertMonitorSetup", "ConvertMonitorSetup\ConvertMonitorSetup.wixproj", "{AD7EE515-34E5-4123-A0CD-B2F6ECC48E56}"

EndProject

Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "UnitTest.Markus.Service", "UnitTest.Markus.Service\UnitTest.Markus.Service.csproj", "{8555777D-922B-473F-9997-EBC63CA944C4}"

EndProject

		{AD7EE515-34E5-4123-A0CD-B2F6ECC48E56}.Debug|Any CPU.ActiveCfg = Debug|x86

		{AD7EE515-34E5-4123-A0CD-B2F6ECC48E56}.Debug|x64.ActiveCfg = Debug|x86

		{AD7EE515-34E5-4123-A0CD-B2F6ECC48E56}.Debug|x86.ActiveCfg = Debug|x86

		{AD7EE515-34E5-4123-A0CD-B2F6ECC48E56}.Debug|x86.Build.0 = Debug|x86

		{AD7EE515-34E5-4123-A0CD-B2F6ECC48E56}.Release|Any CPU.ActiveCfg = Release|x86

		{AD7EE515-34E5-4123-A0CD-B2F6ECC48E56}.Release|x64.ActiveCfg = Release|x86

		{AD7EE515-34E5-4123-A0CD-B2F6ECC48E56}.Release|x86.ActiveCfg = Release|x86

		{AD7EE515-34E5-4123-A0CD-B2F6ECC48E56}.Release|x86.Build.0 = Release|x86

		{8555777D-922B-473F-9997-EBC63CA944C4}.Debug|Any CPU.ActiveCfg = Debug|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Debug|Any CPU.Build.0 = Debug|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Debug|x64.ActiveCfg = Debug|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Debug|x64.Build.0 = Debug|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Debug|x86.ActiveCfg = Debug|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Debug|x86.Build.0 = Debug|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Release|Any CPU.ActiveCfg = Release|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Release|Any CPU.Build.0 = Release|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Release|x64.ActiveCfg = Release|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Release|x64.Build.0 = Release|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Release|x86.ActiveCfg = Release|Any CPU

		{8555777D-922B-473F-9997-EBC63CA944C4}.Release|x86.Build.0 = Release|Any CPU

using System;

using Microsoft.VisualStudio.TestTools.UnitTesting;

namespace ServiceUnitTest

{

    [TestClass]

    public class DataBaseTestBase

    {

        public Markus.Service.DataBase.ConvertDatabase database;

        public DataBaseTestBase()

        {

            string connection = @"data source=.\SQLEXPRESS;initial catalog=Markus;persist security info=True;user id=ConvertService;Password=ConvertService;MultipleActiveResultSets=True;";

            database = new Markus.Service.DataBase.ConvertDatabase(connection);

        }

    }

}

    public class DatabaseTest : DataBaseTestBase

            var item = database.GetConvertItem("111111","1");

            Assert.IsNotNull(item);

    <Compile Include="DataBaseTestBase.cs" />

using System;

using Xunit;

using Markus.Service.DataBase;

using Xunit.Priority;

using Markus.Service.Extensions;

namespace UnitTest.Markus.Service

{

    public class DataBaseTest

    {

        private readonly ConvertDatabase Database;

        private readonly string ConnectionString = @"data source=.\SQLEXPRESS;initial catalog=Markus;persist security info=True;user id=ConvertService;Password=ConvertService;MultipleActiveResultSets=True;";

        private readonly string ProjectNo;

        private readonly string ConvertID;

        public DataBaseTest()

        {

            Database = new ConvertDatabase(ConnectionString);

            ProjectNo = "000000";

            ConvertID = new Guid().CreateUniqueGuid().ToString();

        }

        [Fact,Priority(0)]

        public void AddConvertItem()

        {

            bool result = Database.SetConvertDoc(ProjectNo, ConvertID, @"c:Test.pdf", "aaaaa");

            Assert.True(result);

        }

        [Fact, Priority(1)]

        public void GetConvertItem()

        {

            var result = Database.GetConvertItem(ProjectNo, ConvertID);

            Assert.NotNull(result);

        }

        [Fact, Priority(2)]

        public void ConvertItemChnageState()

        {

            string testServiceID = new Guid().ToString();

            var result = Database.SetConvertState(testServiceID,ConvertID,1,10,10,"test");

            Assert.True(result);

        }

        [Fact, Priority(3)]

        public void ClearConvertItem()

        {

            var result = Database.SetCleanUpItem(ConvertID,1);

            Assert.True(result == 1);

        }

        [Fact, Priority(4)]

        public void RemoveConvertItem()

        {

            var result = Database.RemoveItem(ConvertID);

            Assert.True(result == 1);

        }

    }

}

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>

    <!--<TargetFramework>netcoreapp2.2</TargetFramework>-->

    <TargetFramework>net472</TargetFramework>

    <IsPackable>false</IsPackable>

  </PropertyGroup>

  <PropertyGroup Condition="'$(Configuration)|$(Platform)'=='Debug|AnyCPU'">

    <PlatformTarget>AnyCPU</PlatformTarget>

  </PropertyGroup>

  <ItemGroup>

    <PackageReference Include="EntityFramework" Version="6.2.0" />

    <PackageReference Include="EntityFramework.ko" Version="6.2.0" />

    <PackageReference Include="MarkusDatabase" Version="1.7.2" />

    <PackageReference Include="xunit" Version="2.4.1" />

    <PackageReference Include="Xunit.Priority" Version="1.1.5" />

    <PackageReference Include="xunit.runner.visualstudio" Version="2.4.1">

      <PrivateAssets>all</PrivateAssets>

      <IncludeAssets>runtime; build; native; contentfiles; analyzers</IncludeAssets>

    </PackageReference>

  </ItemGroup>

  <ItemGroup>

    <ProjectReference Include="..\Markus.Service.DataBase\Markus.Service.DataBase.csproj" />

  </ItemGroup>

  <ItemGroup>

    <Reference Include="WindowsBase" />

  </ItemGroup>

</Project>

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "15.9.0.0")]

    <Setting Name="aa" Type="System.String" Scope="User">

      <Value Profile="(Default)" />

    </Setting>