MARKUS

using System.Net;

using System.Xml;

                string ifsign = getEnsembleSign(user_id);

                if (string.IsNullOrEmpty(ifsign))

                    var ModelWFConnectionString = ConnectStringBuilder.ProjectCIConnectString(project_no).ToString();

                    if (null != ModelWFConnectionString)

                        using (CIEntities entity = new CIEntities(ModelWFConnectionString))

                            var _sign = entity.SIGN_INFO.Where(sin => sin.MEMBER_USER_ID == user_id);

                            if (_sign.Count() > 0)

                            {

                                result = _sign.First().SIGN_STR;

                            }

                            else

                            {

                                return null;

                            }

                else

                {

                    result = ifsign;

                }

        #region Legacy System I/F

        /// <summary>

        /// Ensemble+ Sign Data Return

        /// </summary>

        /// <param name="user_id"></param>

        /// <returns></returns>

        private string getEnsembleSign(string user_id)

        {

            string result = string.Empty;

            string soapurl = string.Empty;

            try

            {

                using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))

                {

                    var item = Entity.PROPERTIES.Where(d => d.TYPE == "UpLoadServiceUrl").FirstOrDefault();

                    soapurl = item.VALUE;

                }

                WebClient webClient = new WebClient();

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

                    + "<ens:sUserNo>" + user_id + "</ens:sUserNo>"

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

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

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

                var _result = webClient.UploadString(new Uri(soapurl), data);

                XmlDocument xmlDoc = new XmlDocument();

                xmlDoc.LoadXml(_result);

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

                foreach (XmlNode xn in list)

                {

                    result = xn["checkoutSignImageReturn"].InnerText;

                }

                if (!result.Contains("No business object"))

                {

                    return result;

                }

                else

                {

                    return null;

                }

            }

            catch (Exception ex)

            {

                return null;

            }

        }

        #endregion