using OpenDBDiff.Abstractions.Schema;
using OpenDBDiff.Abstractions.Schema.Model;
using System;

namespace OpenDBDiff.SqlServer.Schema.Model
{
    public class FileGroupFile : SQLServerSchemaBase
    {
        public FileGroupFile(ISchemaBase parent)
            : base(parent, ObjectType.File)
        {
        }

        public override ISchemaBase Clone(ISchemaBase parent)
        {
            FileGroupFile file = new FileGroupFile(parent);
            file.Growth = this.Growth;
            file.Id = this.Id;
            file.IsPercentGrowth = this.IsPercentGrowth;
            file.IsSparse = this.IsSparse;
            file.MaxSize = this.MaxSize;
            file.Name = this.Name;
            file.PhysicalName = this.PhysicalName;
            file.Size = this.Size;
            file.Type = this.Type;
            return file;
        }

        public int Size { get; set; }

        public Boolean IsSparse { get; set; }

        public Boolean IsPercentGrowth { get; set; }

        private string TypeGrowth
        {
            get
            {
                if (Growth == 0)
                    return "";
                else
                    if (IsPercentGrowth)
                    return "%";
                else
                    return "KB";
            }
        }

        public int Growth { get; set; }

        public int MaxSize { get; set; }

        public string PhysicalName { get; set; }

        public int Type { get; set; }

        private string GetNameNewFileGroup(string path)
        {
            string result = "";
            string[] flies = path.Split('\\');
            for (int index = 0; index < flies.Length - 1; index++)
                if (!String.IsNullOrEmpty(flies[index]))
                    result += flies[index] + "\\";
            result += Parent.Parent.Name + "_" + Name + "_DB.ndf";
            return result;
        }

        /// <summary>
        /// Compara dos triggers y devuelve true si son iguales, caso contrario, devuelve false.
        /// </summary>
        public static Boolean Compare(FileGroupFile origin, FileGroupFile destination)
        {
            if (destination == null) throw new ArgumentNullException("destination");
            if (origin == null) throw new ArgumentNullException("origin");
            if (origin.Growth != destination.Growth) return false;
            if (origin.IsPercentGrowth != destination.IsPercentGrowth) return false;
            if (origin.IsSparse != destination.IsSparse) return false;
            if (origin.MaxSize != destination.MaxSize) return false;
            if (!origin.PhysicalName.Equals(destination.PhysicalName)) return false;
            return true;
        }

        public override string ToSql()
        {
            if (Type != 2)
                return "ALTER DATABASE " + Parent.Parent.FullName + "\r\nADD" + ((Type != 1) ? "" : " LOG") + " FILE ( NAME = N'" + Name + "', FILENAME = N'" + PhysicalName + "' , SIZE = " + Size * 1000 + "KB , FILEGROWTH = " + Growth * 1000 + TypeGrowth + ") TO FILEGROUP " + Parent.FullName + "\r\nGO\r\n";
            else
                return "ALTER DATABASE " + Parent.Parent.FullName + "\r\nADD" + ((Type != 1) ? "" : " LOG") + " FILE ( NAME = N'" + Name + "', FILENAME = N'" + PhysicalName + "') TO FILEGROUP " + Parent.FullName + "\r\nGO\r\n";
        }

        public override string ToSqlAdd()
        {
            if (Type != 2)
                return "ALTER DATABASE " + Parent.Parent.FullName + "\r\nADD" + ((Type != 1) ? "" : " LOG") + " FILE ( NAME = N'" + Name + "', FILENAME = N'" + GetNameNewFileGroup(PhysicalName) + "' , SIZE = " + Size * 1000 + "KB , FILEGROWTH = " + Growth * 1000 + TypeGrowth + ") TO FILEGROUP " + Parent.FullName + "\r\nGO\r\n";
            else
                return "ALTER DATABASE " + Parent.Parent.FullName + "\r\nADD" + ((Type != 1) ? "" : " LOG") + " FILE ( NAME = N'" + Name + "', FILENAME = N'" + GetNameNewFileGroup(PhysicalName) + "') TO FILEGROUP " + Parent.FullName + "\r\nGO\r\n";
        }

        public string ToSQLAlter()
        {
            if (Type != 2)
                return "ALTER DATABASE " + Parent.Parent.FullName + " MODIFY FILE ( NAME = N'" + Name + "', FILENAME = N'" + PhysicalName + "' , SIZE = " + Size * 1000 + "KB , FILEGROWTH = " + Growth * 1000 + TypeGrowth + ")";
            else
                return "ALTER DATABASE " + Parent.Parent.FullName + " MODIFY FILE ( NAME = N'" + Name + "', FILENAME = N'" + PhysicalName + "')";
        }

        public override string ToSqlDrop()
        {
            return "ALTER DATABASE " + Parent.Parent.FullName + " REMOVE FILE " + this.FullName + "\r\nGO\r\n";
        }
    }
}