MARKUS

using IKCOM;

using KCOMDataModel.Common;

using KCOMDataModel.DataModel;

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data.EntityClient;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace KCOM_API

{

    public partial class Default : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

            try

            {

                string connection = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

                EntityConnectionStringBuilder _bl = new EntityConnectionStringBuilder(connection);

                SqlConnectionStringBuilder sqpbl = new SqlConnectionStringBuilder(_bl.ProviderConnectionString);

                sqpbl.UserID = "xxxxxx";

                sqpbl.Password = "xxxxxx";

                (form1.FindControl("txtConnection") as TextBox).Text = sqpbl.ToString();

                (form1.FindControl("txtTileSource") as TextBox).Text = KCOM_API.Properties.Settings.Default.TileSoucePath;

                (form1.FindControl("txtTileSourceSub") as TextBox).Text = KCOM_API.Properties.Settings.Default.TileSoucePath_SUB;

                using (KCOMEntities uc = new KCOMEntities(connection))

                {

                    var SystemInfoSet = uc.PROPERTIES.Where(data => data.TYPE == "SystemInfo").ToList();

                    KCOM_SystemInfo sysInfo = new KCOM_SystemInfo();

                    var url = SystemInfoSet.Where(data => data.PROPERTY == "Url").FirstOrDefault();

                    if (url != null)

                    {

                        sysInfo.HostName = url.VALUE;

                    }

                    url = SystemInfoSet.Where(data => data.PROPERTY == "Port").FirstOrDefault();

                    if (url != null)

                    {

                        sysInfo.HostPort = url.VALUE;

                    }

                    url = uc.PROPERTIES.Where(data => data.TYPE == "STAMP").FirstOrDefault();

                    if (url != null)

                    {

                        sysInfo.STAMP = url.VALUE;

                    }

                    (form1.FindControl("txtHostName") as TextBox).Text = sysInfo.HostName;

                }

            }

            catch (Exception ex)

            {

                (form1.FindControl("txtHostName") as TextBox).Text = ex.ToString();

            }

        }

    }

}