using Google.Protobuf;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.IO;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Threading.Tasks;
using System.Web.Hosting;
using System.Web.Http;
using Tango.BL;
using Tango.Core.DB;
using Tango.Core.Helpers;
using Tango.Core.IO;
using Tango.PMR.Stubs;
using Tango.PMR.Synchronization;
using Tango.Synchronization.Local;
using Tango.Synchronization.Remote;

namespace Tango.MachineService.Controllers
{
    public class SynchronizationController : ApiController
    {
        /// <summary>
        /// Expects a DB synchronization request from a remote machine and returns the synchronized version of the machine database.
        /// </summary>
        /// <param name="request">The request.</param>
        /// <returns></returns>
        [HttpPost]
        public SynchronizeDBResponse Synchronize(SynchronizeDBRequest request)
        {
            var tempFolder = TemporaryManager.Default.CreateFolder();

            try
            {
                //File path for the reflected remote data base SQLite.
                String masterSQLiteFile = Path.Combine(tempFolder, "Remote.db");
                //File path for the received machine SQLite db.
                String slaveSQLiteFile = Path.Combine(tempFolder, "Local.db");

                //Save the machine db to file.
                File.WriteAllBytes(slaveSQLiteFile, request.LocalDB.ToByteArray());

                //Copy an SQLite db template.
                File.Copy(HostingEnvironment.MapPath(@"~/App_Data/Tango.db"), masterSQLiteFile);

                //Synchronize the SQL Server db with the new SQLite template. (Overwrite basically)
                RemoteDBSynchronizer.Synchronize(masterSQLiteFile, request.SerialNumber, true);

                //Synchronize the received machine db with the filled template.
                LocalDBSynchronizer.Synchronize(masterSQLiteFile, slaveSQLiteFile);

                //Send the synchronized machine db to the machine to the machine.
                SynchronizeDBResponse response = new SynchronizeDBResponse();
                response.RemoteDB = ByteString.CopyFrom(File.ReadAllBytes(slaveSQLiteFile));

                return response;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                //Remove all temporary files and folder.
                tempFolder.Delete();
            }
        }

        [HttpPost]
        public MachineSetupResponse MachineSetup(MachineSetupRequest request)
        {
            MachineSetupResponse response = new MachineSetupResponse();

            try
            {
                using (ObservablesContext db = ObservablesContext.CreateDefault(GetLocalServerAddress()))
                {
                    db.Configuration.LazyLoadingEnabled = false;
                    String serial_number = request.SerialNumber;

                    var machine = db.Machines.SingleOrDefault(x => x.SerialNumber == serial_number);
                    var machine_version = db.MachineVersions.SingleOrDefault(x => x.Guid == machine.MachineVersionGuid);

                    if (machine == null)
                    {
                        OnError(HttpStatusCode.NotFound, "The specified serial number could not be found.");
                    }

                    var latest_machine_version = db.TangoVersions.Where(x => x.MachineVersionGuid == machine_version.Guid).ToList().OrderByDescending(x => Version.Parse(x.Version)).FirstOrDefault();

                    response.Version = latest_machine_version.Version;

                    response.FtpAddress = GetFtpAddress();
                    response.FtpFilePath = latest_machine_version.FtpFilePath;
                    response.FtpUserName = GetFtpUserName();
                    response.FtpPassword = GetFtpPassword();

                    DbCredentials credentials = new DbCredentials();

                    using (DbManager manager = DbManager.FromAddressAndName(GetDbAddress(), "Tango"))
                    {
                        credentials = manager.CreateRandomLoginAndUser("Tango");

                        Task.Delay(TimeSpan.FromMinutes(10)).ContinueWith((x) =>
                        {
                            using (DbManager m = DbManager.FromAddressAndName(GetDbAddress(), "Tango"))
                            {
                                m.DeleteLoginAndUser(credentials.UserName, "Tango");
                            }
                        });
                    }

                    response.DbAddress = GetDbAddress();
                    response.DbUserName = credentials.UserName;
                    response.DbPassword = credentials.Password;
                }
            }
            catch (Exception ex)
            {
                OnError(HttpStatusCode.InternalServerError, ex.Message);
            }

            return response;
        }

        #region Helpers

        private void OnError(HttpStatusCode code, String message)
        {
            throw new HttpResponseException(Request.CreateErrorResponse(code, message));
        }

        private String GetLocalServerAddress()
        {
            return ConfigurationManager.AppSettings["LocalServerAddress"].ToString();
        }

        private String GetDbAddress()
        {
            return ConfigurationManager.AppSettings["DbAddress"].ToString();
        }

        private String GetFtpAddress()
        {
            return ConfigurationManager.AppSettings["FtpAddress"].ToString();
        }

        private String GetFtpUserName()
        {
            return ConfigurationManager.AppSettings["FtpUserName"].ToString();
        }

        private String GetFtpPassword()
        {
            return ConfigurationManager.AppSettings["FtpPassword"].ToString();
        }

        #endregion
    }
}