MARKUS

                        KeyValuePair<bool, string> result = UploadFinal.UploadFinal.UploadFinalPDF(filename, e.OriginPDFName, e.FinalPDF, soapurl);

        {            

            string _vendorItemId = null;

            string _objid = null;

            string _SharepointItemID = null;

            string _slipNO = null;

            bool _ResultFlag = false;

            string _ResultMsg = "";

                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 && item.PROJECT_NO == FinalPDF.PROJECT_NO);

                    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);

                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);

                    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");

                    }

                }