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

namespace Tango.DAL.Remote.DB
{
    /// <summary>
    /// Represents an SQL Server database context.
    /// </summary>
    /// <seealso cref="System.Data.Entity.DbContext" />
    public partial class RemoteDB : DbContext
    {
        /// <summary>
        /// Initializes a new instance of the <see cref="RemoteDB"/> 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 RemoteDB(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("metadata=res://*/DB.RemoteADO.csdl|res://*/DB.RemoteADO.ssdl|res://*/DB.RemoteADO.msl;provider=System.Data.SqlClient;provider connection string=\"data source={0};initial catalog=Tango;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework\"", 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 RemoteDB CreateDefault()
        {
            return new RemoteDB(SettingsManager.Default.GetOrCreate<CoreSettings>().SQLServerAddress, false);
        }
    }
}