MARKUS

using System;

using System.Collections.Generic;

using System.Data.EntityClient;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

namespace MarkusDataModel.Common

{

    public class ConnectStringBuilder

    {

        private const string InitialCatalogString = "InitialCatalog";

        private const string providerName = "System.Data.SqlClient";

        //private const string providerName = "MS.Data.MySqlClient"; //MYSQL 일때 사용

        //private const string MEMBERMeta = @"res://*/DataModel.MEMBERModel.csdl|res://*/DataModel.MEMBERModel.ssdl|res://*/DataModel.MEMBERModel.msl;";

        // 개발용 테스트 ( DevMarkusModel ) 

        private const string MarkusMeta = @"res://*/DataModel.CloudMarkusModel.csdl|res://*/DataModel.CloudMarkusModel.ssdl|res://*/DataModel.CloudMarkusModel.msl";

        private const string MarkusCIMeta = @"res://*/DataModel.CloudMarkusCIModel.csdl|res://*/DataModel.CloudMarkusCIModel.ssdl|res://*/DataModel.CloudMarkusCIModel.msl";

        private const string MarkusEntitiesMeta = @"res://*/DataModel.markusEntities.csdl|res://*/DataModel.markusEntities.ssdl|res://*/DataModel.markusEntities.msl";

        //private const string MarkusEntitiesMeta = @"res://*/DataModel.HyosungMarkusEntities.csdl|res://*/DataModel.HyosungMarkusEntities.ssdl|res://*/DataModel.HyosungMarkusEntities.msl";

        // 클라우드 ( MarkusModel ) 

        //private const string MarkusMeta = @"res://*/DataModel.MarkusModel.csdl|res://*/DataModel.DevMarkusModel.ssdl|res://*/DataModel.DevMarkusModel.msl;";

        //private const string MarkusCIMeta = @"res://*/DataModel.MarkusCIModel.csdl|res://*/DataModel.DevMarkusCIModel.ssdl|res://*/DataModel.DevMarkusCIModel.msl;";

        public static EntityConnectionStringBuilder MarkusConnectionString()

        {

            SqlConnectionStringBuilder _bl = new SqlConnectionStringBuilder(string.Format(Properties.Settings.Default.ProjectConnectionString, "markus"));

            return EntityConnectionStringBuilder(_bl, MarkusMeta);

        }

        //public static EntityConnectionStringBuilder ProjectCIConnectString(string ProjectNo)

        //{

        //    return CIConnectionStringBuilder(Properties.Settings.Default.ProjectConnectionString, ProjectNo, MarkusCIMeta);

        //}

        public static EntityConnectionStringBuilder MarkusEntitiesConnectionString()

        {

            SqlConnectionStringBuilder _bl = new SqlConnectionStringBuilder(string.Format(Properties.Settings.Default.ProjectConnectionString, "markus"));

            return EntityConnectionStringBuilder(_bl, MarkusEntitiesMeta);

        }

        // 현재는 안쓰임 

        //public static EntityConnectionStringBuilder MEMBERConnectString()

        //{

        //    SqlConnectionStringBuilder _bl = new SqlConnectionStringBuilder(string.Format(Properties.Settings.Default.ProjectConnectionString, "markus"));

        //    return EntityConnectionStringBuilder(_bl, MEMBERMeta);

        //}

        //private static EntityConnectionStringBuilder CIConnectionStringBuilder(string adoConnectionString, string ProjectNo, string Metadata)

        //{

        //    try

        //    {

        //        SqlConnectionStringBuilder bl = new SqlConnectionStringBuilder(string.Format(Properties.Settings.Default.ProjectConnectionString, "markus"));

        //        using (DataModel.CloudMarkusEntities entity

        //            = new DataModel.CloudMarkusEntities(EntityConnectionStringBuilder(bl, MarkusMeta).ToString()))

        //        {

        //            var _catalog = entity.PROPERTIES.Where(property => property.TYPE == InitialCatalogString && property.PROPERTY == ProjectNo);

        //            EntityConnectionStringBuilder builder = null;

        //            if (_catalog.Count() > 0)

        //            {

        //                string _ConnectionString = string.Format(adoConnectionString, _catalog.First().VALUE);

        //                SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder(_ConnectionString);

        //                builder = ConnectStringBuilder.EntityConnectionStringBuilder(sqlBuilder, Metadata);

        //            }

        //            return builder;

        //        }

        //    }

        //    catch (Exception ex)

        //    {

        //        System.Diagnostics.Debug.WriteLine(ex.ToString());

        //    }

        //    return null;

        //}

        private static EntityConnectionStringBuilder EntityConnectionStringBuilder(SqlConnectionStringBuilder SqlStringBuilder, string EntityMetaData)

        {

            string providerString = SqlStringBuilder.ToString();

            EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();

            entityBuilder.Provider = providerName;

            entityBuilder.ProviderConnectionString = providerString;

            entityBuilder.Metadata = EntityMetaData;

            Console.WriteLine(entityBuilder.ToString());

            using (EntityConnection conn =

                new EntityConnection(entityBuilder.ToString()))

            {

                conn.Open();

                Console.WriteLine("Just testing the connection.");

                conn.Close();

            }

            return entityBuilder;

        }

    }

}