using System.Collections.Generic;
using Db4objects.Db4o;
using ObjectDatabase.Interfaces;
using ObjectDatabase.Models;
using ObjectDatabase.Properties;

namespace ObjectDatabase.Controllers
{
    public sealed class PersonController : iPerson
    {
        public bool AddPerson(string firstname, string lastname)
        {
            var newPerson = new Person(firstname,lastname);

            using (var container = Db4oEmbedded.OpenFile(Resources.Database))
            {
                if((container.Query<Person>(x => x.Firstname == firstname && x.Lastname == lastname)).Count > 0) return false;
                container.Store(newPerson);
                container.Commit();
                return true;
            }
        }

        public bool AddPerson(string firstname, string lastname, Address address)
        {
            var newPerson = new Person(firstname, lastname,address);

            using (var container = Db4oEmbedded.OpenFile(Resources.Database))
            {
                if ((container.Query<Person>(x => x.Firstname == firstname && x.Lastname == lastname)).Count > 0) return false;
                container.Store(newPerson);
                container.Commit();
                return true;
            }
        }

        public bool AddPerson(string firstname, string lastname,IEnumerable<Telephone> telephones)
        {
            var newPerson = new Person(firstname, lastname,telephones);

            using (var container = Db4oEmbedded.OpenFile(Resources.Database))
            {
                if ((container.Query<Person>(x => x.Firstname == firstname && x.Lastname == lastname)).Count > 0) return false;
                container.Store(newPerson);
                container.Commit();
                return true;
            }
        }

        public bool AddPerson(string firstname, string lastname, Address address, IEnumerable<Telephone> telephones)
        {
            var newPerson = new Person(firstname, lastname,address,telephones);

            using (var container = Db4oEmbedded.OpenFile(Resources.Database))
            {
                if ((container.Query<Person>(x => x.Firstname == firstname && x.Lastname == lastname)).Count > 0) return false;

                container.Store(newPerson);
                container.Commit();
                return true;
            }
        }

        public bool DeletePerson(string firstname, string lastname)
        {
            using (var container = Db4oEmbedded.OpenFile(Resources.Database))
            {
                var toRemove = container.Query<Person>(x => x.Firstname == firstname && x.Lastname == lastname);

                if (toRemove.Count != 1) return false;

                if (toRemove[0].Telephones != null)
                {
                    container.Delete(toRemove[0].Telephones);
                }

                if (toRemove[0].Address != null)
                {
                    container.Delete(toRemove[0].Address);
                }

                container.Delete(toRemove[0]);
                container.Commit();
                return true;
            }
        }

        public bool EditPerson(string oldFirstname, string oldLastname, string newFirstname, string newLastName)
        {
            using (var container = Db4oEmbedded.OpenFile(Resources.Database))
            {
                var toEdit = container.Query<Person>(x => x.Firstname == oldFirstname && x.Lastname == oldLastname);

                if (toEdit.Count != 1) return false;

                toEdit[0].Firstname = newFirstname;
                toEdit[0].Lastname = newLastName;
                container.Commit();
                return true;
            }
        }
    }
}