using System;

using Microsoft.AspNetCore.Authentication;

public class Program

{

    public static void Main()

    {

        Console.WriteLine(BitConverter.ToInt64(Base64UrlTextEncoder.Decode("pQcAwJoK4Ao")));

        Console.WriteLine(Base64UrlTextEncoder.Encode(BitConverter.GetBytes(799529412339959191)));

        var email = "becsaev@guildlink.com.au";

        var firstName = "Bobby";

        var lastName = "Esaev";

        var today = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");

        var userAccountId = 834227056697934848; //RUN THIS CODE, THEN COPY QUERY 1 FROM THE OUTPUT CONSOLE AND RUN IT ON SQL SERVER, THEN GET THE RETURNED Id FROM THE QUERY AND PLACE IT HERE

        var identityProviderId = 693614879575114974; //THIS ID COMES FROM THE [idp].[IdentityProvider] TABLE AND WILL BE THE SAME FOR ALL USERS. Dev Id(693614879575114974) - Prod Id(718346354094507013)

        //QUERY 1

        Console.WriteLine("QUERY 1\n");

        var addUserAccountSQL = $@"INSERT INTO [idp].[UserAccount] ([Id], [Identifier] ,[Email] ,[EmailValidated] ,[EmailValidatedAt] ,[PhoneValidated] ,[Disabled] ,[Deleted], [MfaEnabled])

         VALUES ([shared].uniqueid(0), '{Guid.NewGuid().ToString()}' ,'{email}' ,1 ,'{today}' ,0 ,0 ,0 ,0)

         SELECT TOP 1 * FROM [idp].[UserAccount] ORDER BY Id DESC

         ";

        //QUERY 2

        Console.WriteLine("QUERY 1\n");

        var addUserAccountSQL = $@"INSERT INTO [idp].[UserAccount] ([Id], [Identifier] ,[Email] ,[EmailValidated] ,[EmailValidatedAt] ,[PhoneValidated] ,[Disabled] ,[Deleted], [MfaEnabled])

         VALUES ([shared].uniqueid(0), '{Guid.NewGuid().ToString()}' ,'{email}' ,1 ,'{today}' ,0 ,0 ,0 ,0)

         SELECT TOP 1 * FROM [idp].[UserAccount] ORDER BY Id DESC

         ";

        Console.WriteLine(addUserAccountSQL);

    }

}