MARKUS

Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "UploadFinal", "UploadFinal\UploadFinal.csproj", "{9CF3737A-E04D-4A55-924E-C88725DFBEC7}"

EndProject

		{9CF3737A-E04D-4A55-924E-C88725DFBEC7}.Debug|Any CPU.ActiveCfg = Debug|Any CPU

		{9CF3737A-E04D-4A55-924E-C88725DFBEC7}.Debug|Any CPU.Build.0 = Debug|Any CPU

		{9CF3737A-E04D-4A55-924E-C88725DFBEC7}.Debug|x64.ActiveCfg = Debug|Any CPU

		{9CF3737A-E04D-4A55-924E-C88725DFBEC7}.Debug|x64.Build.0 = Debug|Any CPU

		{9CF3737A-E04D-4A55-924E-C88725DFBEC7}.Release|Any CPU.ActiveCfg = Release|Any CPU

		{9CF3737A-E04D-4A55-924E-C88725DFBEC7}.Release|Any CPU.Build.0 = Release|Any CPU

		{9CF3737A-E04D-4A55-924E-C88725DFBEC7}.Release|x64.ActiveCfg = Release|Any CPU

		{9CF3737A-E04D-4A55-924E-C88725DFBEC7}.Release|x64.Build.0 = Release|Any CPU

    <ProjectReference Include="..\UploadFinal\UploadFinal.csproj">

      <Project>{9cf3737a-e04d-4a55-924e-c88725dfbec7}</Project>

      <Name>UploadFinal</Name>

    </ProjectReference>

                    string soapurl = string.Empty;

                    using (KCOMDataModel.DataModel.KCOMEntities _systemEntity = new KCOMDataModel.DataModel.KCOMEntities(KCOMDataModel.Common.ConnectStringBuilder.KCOMConnectionString().ToString()))

                        var item = _systemEntity.PROPERTIES.Where(data => data.TYPE == "UpLoadServiceUrl").FirstOrDefault();

                        soapurl = item.VALUE;

                    if(!string.IsNullOrEmpty(soapurl))

                        //Legacy IF

                        KeyValuePair<bool, string> result = UploadFinal.UploadFinal.UploadFinalPDF(e.FinalPDFPath.Replace(@"\\172.20.121.220\comment3\finalPDF\", ""), e.OriginPDFName, e.FinalPDF, soapurl);

                        if (result.Key)

                        {

                            SetFinalState(_item.ID, FinalStatus.Success);

                        }

                        else

                        {

                            SetFinalState(_item.ID, FinalStatus.Error);

                            _Log.Write("Upload error .." + e.FinalPDFPath + ",pdfname:" + e.OriginPDFName);

                        }                        

                    else

                    {

                        ///TODO: 저장할 폴더 위치를 configuration으로 빼주세요

                        string saveFolder = String.Format(Properties.Settings.Default.saveFileFolder, _item.PROJECT_NO, Convert.ToInt32(_item.DOCUMENT_ID) / 100, _item.DOCUMENT_ID);

                        if (!System.IO.Directory.Exists(saveFolder))

                        {

                            System.IO.Directory.CreateDirectory(saveFolder);

                        }

                        this._Log.Write(String.Format("saveFolder : {0}", saveFolder) + DateTime.Now);

                        System.IO.File.Copy(e.FinalPDFPath, saveFolder + e.OriginPDFName, true);

                        using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(_item.PROJECT_NO).ToString()))

                        {

                            var item = _entity.DOCUMENT_ITEM.Where(d => d.DOCUMENT_ID == _item.DOCUMENT_ID).FirstOrDefault();

                            ///TODO: RESULT FILE 경로 위치를 configuration으로 빼주세요

                            item.RESULT_FILE = String.Format(Properties.Settings.Default.resultFileFolder, _item.PROJECT_NO, Convert.ToInt32(_item.DOCUMENT_ID) / 100, _item.DOCUMENT_ID, e.OriginPDFName);

                            //@"http://cloud.devdoftech.co.kr:5977/FinalPDF/{0}_app/VPCS_DOCLIB/{1}/{2}/ToVendor/{3}"

                            sendReqLog("RESULT_FILE_PATH", item.RESULT_FILE);

                            _entity.SaveChanges();

                            SetFinalState(_item.ID, FinalStatus.Success);

                            _Thread.Remove(_T.First());

                        }

                    }                    

    <Reference Include="Telerik.Windows.Zip, Version=2019.1.215.40, Culture=neutral, PublicKeyToken=5803cfa389c90ce7, processorArchitecture=MSIL">

      <HintPath>..\..\..\lib\RCWPF\2019.1.220.40\Telerik.Windows.Zip.dll</HintPath>

using Telerik.Windows.Zip;

using System.Reflection;

using System.Runtime.CompilerServices;

using System.Runtime.InteropServices;

// General Information about an assembly is controlled through the following 

// set of attributes. Change these attribute values to modify the information

// associated with an assembly.

[assembly: AssemblyTitle("UploadFinal")]

[assembly: AssemblyDescription("")]

[assembly: AssemblyConfiguration("")]

[assembly: AssemblyCompany("")]

[assembly: AssemblyProduct("UploadFinal")]

[assembly: AssemblyCopyright("Copyright ©  2012")]

[assembly: AssemblyTrademark("")]

[assembly: AssemblyCulture("")]

// Setting ComVisible to false makes the types in this assembly not visible 

// to COM components.  If you need to access a type in this assembly from 

// COM, set the ComVisible attribute to true on that type.

[assembly: ComVisible(false)]

// The following GUID is for the ID of the typelib if this project is exposed to COM

[assembly: Guid("9cf96b56-8129-4f59-a099-c911f56caaf6")]

// Version information for an assembly consists of the following four values:

//

//      Major Version

//      Minor Version 

//      Build Number

//      Revision

//

// You can specify all the values or you can default the Build and Revision Numbers 

// by using the '*' as shown below:

// [assembly: AssemblyVersion("1.0.*")]

[assembly: AssemblyVersion("1.6.0.1")]

[assembly: AssemblyFileVersion("1.6.0.1")]

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

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

  <PropertyGroup>

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

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

    <ProductVersion>8.0.30703</ProductVersion>

    <SchemaVersion>2.0</SchemaVersion>

    <ProjectGuid>{9CF3737A-E04D-4A55-924E-C88725DFBEC7}</ProjectGuid>

    <OutputType>Library</OutputType>

    <AppDesignerFolder>Properties</AppDesignerFolder>

    <RootNamespace>UploadFinal</RootNamespace>

    <AssemblyName>UploadFinal</AssemblyName>

    <TargetFrameworkVersion>v4.0</TargetFrameworkVersion>

    <FileAlignment>512</FileAlignment>

    <TargetFrameworkProfile>

    </TargetFrameworkProfile>

  </PropertyGroup>

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

    <DebugSymbols>true</DebugSymbols>

    <DebugType>full</DebugType>

    <Optimize>false</Optimize>

    <OutputPath>bin\Debug\</OutputPath>

    <DefineConstants>DEBUG;TRACE</DefineConstants>

    <ErrorReport>prompt</ErrorReport>

    <WarningLevel>4</WarningLevel>

  </PropertyGroup>

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

    <DebugType>pdbonly</DebugType>

    <Optimize>true</Optimize>

    <OutputPath>bin\Release\</OutputPath>

    <DefineConstants>TRACE</DefineConstants>

    <ErrorReport>prompt</ErrorReport>

    <WarningLevel>4</WarningLevel>

  </PropertyGroup>

  <ItemGroup>

    <Reference Include="System" />

    <Reference Include="System.Core" />

    <Reference Include="System.Data.Entity" />

    <Reference Include="System.Runtime.Serialization" />

    <Reference Include="System.ServiceModel" />

    <Reference Include="System.Web" />

    <Reference Include="System.Xml.Linq" />

    <Reference Include="System.Data.DataSetExtensions" />

    <Reference Include="Microsoft.CSharp" />

    <Reference Include="System.Data" />

    <Reference Include="System.Xml" />

  </ItemGroup>

  <ItemGroup>

    <Compile Include="UploadPDF.cs" />

    <None Include="app.config" />

    <Compile Include="Properties\AssemblyInfo.cs" />

  </ItemGroup>

  <ItemGroup>

    <ProjectReference Include="..\KCOMDataModel\KCOMDataModel.csproj">

      <Project>{629dc8cd-d458-47ef-8f02-cd12c7001c3e}</Project>

      <Name>KCOMDataModel</Name>

    </ProjectReference>

    <ProjectReference Include="..\MarkupToPDF\MarkupToPDF.csproj">

      <Project>{a714bd67-8aac-4ed8-8ecf-7853c3549a68}</Project>

      <Name>MarkupToPDF</Name>

    </ProjectReference>

  </ItemGroup>

  <ItemGroup>

    <WCFMetadata Include="Service References\" />

  </ItemGroup>

  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />

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

       Other similar extension points exist, see Microsoft.Common.targets.

  <Target Name="BeforeBuild">

  </Target>

  <Target Name="AfterBuild">

  </Target>

  -->

</Project>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using System.Net;

using System.Xml;

using System.Xml.Linq;

using System.Net.Mail;

using System.Data.SqlClient;

using KCOMDataModel.DataModel;

using KCOMDataModel.Common;

namespace UploadFinal

{

    public class UploadFinal

    {

        public static KeyValuePair<bool, string> UploadFinalPDF(string PdfFilePath, string OriginFileName, FINAL_PDF FinalPDF, string UploadServiceUrl)

        {            

            string _vendorItemId = null;

            string _objid = null;

            string _SharepointItemID = null;

            string _slipNO = null;

            bool _ResultFlag = false;

            string _ResultMsg = "";

            try

            {

                string docurl = string.Empty;

                using (CIEntities dc = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(FinalPDF.PROJECT_NO).ToString()))

                {

                    var _docInfoList = dc.DOCINFO.Where(doc => doc.ID == FinalPDF.DOCINFO_ID);

                    if (_docInfoList.Count() > 0)

                        _SharepointItemID = _docInfoList.First().DOCUMENT_ID;

                    var _vendoritems = dc.DOCUMENT_ITEM.Where(item => item.DOCUMENT_ID == _SharepointItemID);

                    if (_vendoritems.Count() > 0)

                    {

                        _objid = _vendoritems.First().ID;

                        _slipNO = _vendoritems.First().GROUP_NO;

                        docurl = _vendoritems.First().ORIGINAL_FILE;

                    }

                }

                //EnsemblePlusWebService.DLMWebServiceClient client = new EnsemblePlusWebService.DLMWebServiceClient();

                //var result = client.fnFinalPDFCheckInService(FinalPDF.PROJECT_NO, _objid, _slipNO, PdfFilePath);

                WebClient webClient = new WebClient();

                string data = string.Empty;

                if (docurl.ToUpper().Contains("VPCS_DOCLIB"))

                {

                    string connectionString = "data source=ESB-DB;Initial Catalog=markus;uid=ProjectPortalDBConn;password=ProjectPortalDBConn";

                    SqlConnection sqlConn = new SqlConnection(connectionString);

                    SqlCommand sqlComm = new SqlCommand();

                    sqlComm.Connection = sqlConn;

                    sqlComm.CommandText = string.Format("SELECT [DBConnectString]  FROM [PortalEV].[dbo].[Setting]  where [ProjectNumber] = '{0}'", FinalPDF.PROJECT_NO);

                    string ciconnectionStr = string.Empty;

                    sqlConn.Open();

                    using (SqlDataReader SqlRs = sqlComm.ExecuteReader())

                    {

                        while (SqlRs.Read())

                        {

                            ciconnectionStr = SqlRs[0].ToString();

                        }

                    }

                    sqlConn.Close();

                    sqlConn = new SqlConnection(ciconnectionStr);

                    sqlComm.Connection = sqlConn;

                    sqlComm.CommandText = string.Format("SELECT [vendor_item_id]  FROM [vendor_item]  where [sharepoint_itemid] = '{0}'", _objid);

                    sqlConn.Open();

                    using (SqlDataReader SqlRs = sqlComm.ExecuteReader())

                    {

                        while (SqlRs.Read())

                        {

                            _objid = SqlRs[0].ToString();

                        }

                    }

                    sqlConn.Close();

                    UploadServiceUrl = "http://esb-vpcs-new.daelimplant.com/ProjectPortal/UserControls/DaelimCI2/FinalPDFUpload/UploadVpcsFile.asmx";

                    data = "<soap12:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:soap12=\"http://www.w3.org/2003/05/soap-envelope\" ><soap12:Body><UploadFinalPDF xmlns=\"http://FinalPDFUpload\">"

                                     + "<ProjectNo>" + FinalPDF.PROJECT_NO + "</ProjectNo>"

                                     + "<VendorItemID>" + _objid + "</VendorItemID>"

                                     + "<SlipNumber>" + _slipNO + "</SlipNumber>"

                                     + "<filePath>" + @"\\172.20.121.220\comment3\finalPDF\" + PdfFilePath + "</filePath>"

                                     + "<OriginFileName>" + OriginFileName + "</OriginFileName></UploadFinalPDF></soap12:Body></soap12:Envelope>";

                    //WriteLog(data);

                    webClient.Headers.Add(HttpRequestHeader.ContentType, "application/soap+xml; charset=utf-8");

                    webClient.Headers.Add("SOAPAction", "http://FinalPDFUpload/UploadFinalPDF");

                    string _result = webClient.UploadString(new Uri(UploadServiceUrl), data);

                    XmlTextReader reader = new XmlTextReader(new System.IO.StringReader(_result));

                    while (reader.Read())

                    {

                        switch (reader.NodeType)

                        {

                            case XmlNodeType.Element:

                                if (reader.Name == "Seccess")

                                {

                                    reader.Read();

                                    if (!string.IsNullOrWhiteSpace(reader.Value))

                                        _ResultFlag = Convert.ToBoolean(reader.Value);

                                }

                                if (reader.Name == "Message")

                                {

                                    reader.Read();

                                    if (!string.IsNullOrWhiteSpace(reader.Value))

                                        _ResultMsg = reader.Value;

                                }

                                if (reader.Name == "FinalPDFUrl")

                                {

                                    reader.Read();

                                    if (!string.IsNullOrWhiteSpace(reader.Value))

                                        _ResultMsg = reader.Value;

                                }

                                break;                                

                        }

                    }

                    return new KeyValuePair<bool, string>(_ResultFlag, _ResultMsg);

                }

                else

                {

                    data = "<soapenv:Envelope xmlns:soapenv=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:ens=\"http://EnsemblePlus.Webservice\"> <soapenv:Header/> <soapenv:Body> <ens:fnFinalPDFCheckInService>"

                    + "<ens:ProjectNo>" + FinalPDF.PROJECT_NO + "</ens:ProjectNo>"

                    + "<ens:ObjectId>" + _objid + "</ens:ObjectId>"

                    + "<ens:SlipNumber>" + _slipNO + "</ens:SlipNumber>"

                    + "<ens:filePath>" + PdfFilePath + "</ens:filePath>"

                    + "<ens:OriginalFileName>" + OriginFileName + "</ens:OriginalFileName>"

                    + "</ens:fnFinalPDFCheckInService> </soapenv:Body></soapenv:Envelope>";

                    webClient.Headers.Add(HttpRequestHeader.ContentType, "text/xml");

                    webClient.Headers.Add("SOAPAction", "http://EnsemblePlus.Webservice");

                    var result = webClient.UploadString(new Uri(UploadServiceUrl), data);

                    XmlDocument xmlDoc = new XmlDocument();

                    xmlDoc.LoadXml(result);

                    XmlNodeList list = xmlDoc.GetElementsByTagName("fnFinalPDFCheckInServiceReturn");

                    if (list.Count > 0)

                    {

                        if (list[0].InnerText == "Success")

                        {

                            return new KeyValuePair<bool, string>(true, "Success");

                        }

                        else

                        {

                            return new KeyValuePair<bool, string>(false, "Fail");

                        }

                    }

                    else

                    {

                        return new KeyValuePair<bool, string>(false, "Not Completed");

                    }

                }

            }

            catch (Exception ex)

            {

                return new KeyValuePair<bool, string>(false, ex.Message);

            }

            //return new KeyValuePair<bool, string>(_ResultFlag,_ResultMsg);

        }

        static void webClient_UploadStringCompleted(object sender, UploadStringCompletedEventArgs e)

        {

            Console.WriteLine("UploadStringCompleted: {0}", e.Result);

        }

        public static void SendOnMessage(string subject, string content)

        {

            //MailMessage mail = new MailMessage();

            //mail.From = new MailAddress("h2011357@daelim.co.kr", "시스템관리자", System.Text.Encoding.UTF8);

            //mail.To.Add("h2011357@daelim.co.kr");

            //mail.Subject = subject;

            //mail.Body = content;

            //mail.BodyEncoding = System.Text.Encoding.UTF8;//한글이 안깨지기 위해서 사용

            //mail.SubjectEncoding = System.Text.Encoding.UTF8;//한글이 안깨지기 위해서 사용

            //SmtpClient SmtpServer = new SmtpClient("any.daelim.co.kr");

            //SmtpServer.Send(mail); // 메일 발송

            //mail.Dispose();

        }

        public static void WriteLog(string strLog)

        {

            StreamWriter log;

            FileStream fileStream = null;

            DirectoryInfo logDirInfo = null;

            FileInfo logFileInfo;

            string logFilePath = "C:\\Logs\\";

            logFilePath = logFilePath + "Log-" + System.DateTime.Today.ToString("MM-dd-yyyy") + "." + "txt";

            logFileInfo = new FileInfo(logFilePath);

            logDirInfo = new DirectoryInfo(logFileInfo.DirectoryName);

            if (!logDirInfo.Exists) logDirInfo.Create();

            if (!logFileInfo.Exists)

            {

                fileStream = logFileInfo.Create();

            }

            else

            {

                fileStream = new FileStream(logFilePath, FileMode.Append);

            }

            log = new StreamWriter(fileStream);

            log.WriteLine(strLog);

            log.Close();

        }

    }

}

<?xml version="1.0"?>

<configuration>

    <system.serviceModel>

        <bindings />

        <client />

    </system.serviceModel>

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