using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tango.Settings;

namespace Tango.DAL.Observables
{
    public class ObservablesContext : DbContext
    {
        /// <summary>
        /// Initializes a new instance of the <see cref="ObservablesContext" /> class.
        /// </summary>
        /// <param name="path">The server file path.</param>
        /// <param name="isFile">if set to <c>true</c> will try to connect to an .mdf file.</param>
        public ObservablesContext(String path, bool isFile) : base(ComposeConnectionString(path, isFile))
        {

        }

        /// <summary>
        /// Composes the connection string.
        ///</summary>
        /// <param name="source">The source.</param>
        /// <param name="isFile">if set to <c>true</c> [is file].</param>
        /// <returns></returns>
        private static String ComposeConnectionString(String source, bool isFile)
        {
            if (!isFile)
            {
                return String.Format("Data Source={0};Initial Catalog=Tango;Integrated Security=true", source);
            }
            else
            {
                return null;
            }
        }

        /// <summary>
        /// Creates a default remote database context by the address specified in <see cref="SettingsManager.Default.DataBase.SQLServerAddress" />.
        /// </summary>
        /// <returns></returns>
        public static ObservablesContext CreateDefault()
        {
            return new ObservablesContext(SettingsManager.Default.DataBase.SQLServerAddress, false);
        }

        @foreach (var prop in Model.Properties)
        {
            <div>
                /// <summary>
                /// Gets or sets the @(prop.Name).
                /// </summary>
                public @(prop.Type) @(prop.Name) { get; set; }
            </div>
        }
    }
}