using System;
using System.Data.SQLite;
using System.Threading.Tasks;
using RepoDb;

namespace RPT.UI.WinConsole2
{
	static class Program
	{
		static async Task Main(string[] args)
		{
			SqLiteBootstrap.Initialize();

			var conn = new SQLiteConnection(@"Data Source=:memory:;Version=3;");
			await conn.OpenAsync();
			await conn.ExecuteNonQueryAsync(CreateDatabaseScripts.EnsurePersonTable);

			var person = new Person { Name = "Cal", Surname = "Crutchlow" };
			var addedFields = Field.Parse<Person>(x => new
			{
				x.Name,
				x.Surname
			});
			var insertPersonSql = $"insert into [{nameof(Person)}] " +
				$"(" +
				$"  [{nameof(Person.Name)}]" +
				$", [{nameof(Person.Surname)}]" +
				$") values (" +
				$"  '{person.Name}'" +
				$", '{person.Surname}'" +
				$")";

			person.Name += "_2";
			uint id;
			ushort i = 1;

			var affectedRows = await conn.ExecuteNonQueryAsync(insertPersonSql).TryCatch(i++);
			// works, inserts correct data, db generates Id

			var dynamicPerson_no_Id = new { Name = "Cal", Surname = "Crutchlow" };
			id = await conn.InsertAsync<dynamic, uint>(nameof(Person), entity: dynamicPerson_no_Id).TryCatch(i++);
			// {"The non-identity primary field must be present during insert operation."}

			var dynamicPerson_with_Id = new { Id = 13, Name = "Jack", Surname = "Brown" };
			id = await conn.InsertAsync<dynamic, uint>(nameof(Person), entity: dynamicPerson_with_Id).TryCatch(i++);
			// works, inserts the Id into the dynamic, returns correct Id, but it is the provided Id, it is not generated by the DB

			dynamicPerson_with_Id = new { Id = 17, Name = "Bruce", Surname = "Wayne" };
			id = await conn.InsertAsync<dynamic, uint>(nameof(Person), entity: dynamicPerson_with_Id, fields: addedFields).TryCatch(i++);
			// {"The non-identity primary field must be present during insert operation."}

			person.Id = 0;
			id = await conn.InsertAsync<Person, uint>(nameof(Person), entity: person).TryCatch(i++);
			// inserts Id = 0, returns correct inserted Id

			person.Id = 37;
			id = await conn.InsertAsync<Person, uint>(entity: person).TryCatch(i++);
			// inserts id = 37, returns correct inserted Id

			id = await conn.InsertAsync<dynamic, uint>(nameof(Person), entity: dynamicPerson_no_Id, fields: addedFields).TryCatch(i++);
			// {"The non-identity primary field must be present during insert operation."}

			id = await conn.InsertAsync<uint>(nameof(Person), entity: dynamicPerson_no_Id, fields: addedFields).TryCatch(i++);
			// {"The non-identity primary field must be present during insert operation."}

			id = await conn.InsertAsync<Person, uint>(nameof(Person), entity: person, fields: addedFields).TryCatch(i++);
			// {"The non-identity primary field must be present during insert operation."}

			id = await conn.InsertAsync<Person, uint>(person, fields: addedFields).TryCatch(i++);
			// {"The non-identity primary field must be present during insert operation."}

			Console.ReadLine();
		}
	}

	public class Person
	{
		public uint Id { get; set; }
		public string Name { get; set; }
		public string Surname { get; set; }
	}

	public static class CreateDatabaseScripts
	{
		public static string EnsurePersonTable = $"create table if not exists [{nameof(Person)}] (" +
			string.Join(",",
				$"[{nameof(Person.Id)}] integer primary key",
				$"[{nameof(Person.Name)}] text not null",
				$"[{nameof(Person.Surname)}] text not null") +
			$");";
	}

	public static class TaskMixins
	{
		public static async Task TryCatch(this Task task, ushort i)
		{
			Console.WriteLine($"#{i++}");

			try
			{
				await task;
			}
			catch (Exception ex)
			{
				Console.WriteLine(ex.Message);
			}
			finally
			{
				Console.WriteLine("-----------------------");
			}
		}

		public static async Task<T> TryCatch<T>(this Task<T> task, ushort i)
		{
			Console.WriteLine($"#{i++}");

			try
			{
				return await task;
			}
			catch (Exception ex)
			{
				Console.WriteLine(ex.Message);
			}
			finally
			{
				Console.WriteLine("-----------------------");
			}

			return default;
		}
	}
}