MARKUS

        [WebGet(UriTemplate = "SetFinalPDFUrl?prj_No={prj_No}&document_Id={document_Id}&document_Url={document_Url}", BodyStyle = WebMessageBodyStyle.Wrapped, RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json)]

        [OperationContract]

        public string SetFinalPDFUrl(string prj_No, string document_Id, string document_Url)

        {

            string _result = null;

            try

            {

                logger.Info($"SetFinalPDFUrl call prj_No : {prj_No}  document_Id : {document_Id}  document_Url : {document_Url}");

                string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;

                using (CIEntities _kcomEntity = new CIEntities(sCIConnString))

                {

                    var doc = _kcomEntity.DOCUMENT_ITEM.Where(d => d.PROJECT_NO == prj_No && d.ID == document_Id).FirstOrDefault();

                    if (doc != null)

                    {

                        doc.RESULT = document_Url;

                        _kcomEntity.SaveChanges();

                        _result = true.ToString();

                    }

                    else

                    {

                        _result = $"prj_No : {prj_No}  document_Id : {document_Id}  document_Url : {document_Url} Not Found";

                    }

                }

            }

            catch (Exception ex)

            {

                logger.Error($"SetFinalPDFUrl call prj_No : {prj_No}  document_Id : {document_Id}  document_Url : {document_Url}",ex);

                _result = "Error";

            }

            return _result;

        }