using System;
using GeoAPI.Geometries;
using Microsoft.EntityFrameworkCore;
using NetTopologySuite;
using NetTopologySuite.Geometries;

namespace ConsoleTest
{
    public class SpatialTestContext : DbContext
    {
        public DbSet<Xy> Xys { get; set; }
        public DbSet<Xyz> Xyzs { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.EnableSensitiveDataLogging();
            optionsBuilder.UseSqlite("Filename=./Xyz.sqlite", x => x.UseNetTopologySuite());
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Xy>().Property(c => c.XyPoint)
                .ForSqliteHasSrid(4326);
            modelBuilder.Entity<Xy>().Property(c => c.XyPoint)
                .ForSqliteHasDimension(Ordinates.XY);

            modelBuilder.Entity<Xyz>().Property(c => c.XyzPoint)
                .ForSqliteHasSrid(4326);
            modelBuilder.Entity<Xyz>().Property(c => c.XyzPoint)
                .ForSqliteHasDimension(Ordinates.XYZ);
        }
    }

    public class Xy
    {
        public int Id { get; set; }
        public string Note { get; set; }
        public IPoint XyPoint { get; set; }
    }

    public class Xyz
    {
        public int Id { get; set; }
        public string Note { get; set; }
        public IPoint XyzPoint { get; set; }
    }

    internal class Program
    {
        private static void Main(string[] args)
        {
            using (var context = new SpatialTestContext())
            {
                context.Database.EnsureDeleted();
                context.Database.EnsureCreated();

                Console.WriteLine($"Create New Xy Point");

                var geometryFactory = NtsGeometryServices.Instance.CreateGeometryFactory(srid: 4326);
                var xyLocation = geometryFactory.CreatePoint(new Coordinate(-122.121512, 47.6739882));

                var newXyPoint = new Xy
                {
                    Note = $"{DateTime.Now} New Xy Point",
                    XyPoint = xyLocation
                };

                context.Xys.Add(newXyPoint);

                try
                {
                    Console.WriteLine($"Saving New Xy Point");
                    context.SaveChanges(true);
                }
                catch (Exception e)
                {
                    Console.WriteLine($"Error Saving New Xy Point {e}");
                }

                Console.WriteLine($"Create New Xyz Point");

                var xyzPoint = geometryFactory.CreatePoint(new Coordinate(-122.121512, 47.6739882, 1000));

                var newXyzPoint = new Xyz
                {
                    Note = $"{DateTime.Now} New Xyz Point",
                    XyzPoint = xyzPoint
                };

                context.Xyzs.Add(newXyzPoint);

                try
                {
                    Console.WriteLine($"Saving New Xyz Point");
                    context.SaveChanges(true);
                }
                catch (Exception e)
                {
                    Console.WriteLine($"Error Saving New Xyz Point {e}");
                }
            }
        }
    }
}