using System;

using Microsoft.AspNetCore.Authentication;

public class Program

{

    public static void Main()

    {

        //****** PROCESS TO ADD A NEW USER INTO THE CROSS (cross-dev or cross-twcm-production) ******

        //1 - RUN THE CODE, THEN COPY QUERY 1 FROM THE OUTPUT CONSOLE AND RUN IT ON SQL SERVER, THEN GET THE RETURNED Id FROM THE QUERY RESULT AND REPLACE THE userAccountId variable value BELOW WITH THIS ID

        //2 - RUN THE CODE AGAIN AFTER FOLLOWING ALL THE PROCEDURES ABOVE, THEN COPY QUERY 2 FROM THE OUTPUT CONSOLE AND RUN IT ON SQL SERVER   

        //3 - RUN THE CODE AGAIN AFTER FOLLOWING ALL THE PROCEDURES ABOVE, THEN COPY QUERY 3 FROM THE OUTPUT CONSOLE AND RUN IT ON SQL SERVER, THEN GET THE RETURNED Id FROM THE QUERY RESULT AND REPLACE THE operatorIdentityId variable value BELOW WITH THIS ID

        //4 - RUN THE CODE AGAIN AFTER FOLLOWING ALL THE PROCEDURES ABOVE, THEN COPY QUERY 4 FROM THE OUTPUT CONSOLE AND RUN IT ON SQL SERVER (IF YOU ARE SETTING UP A NEW PHARMACY, RUN QUERY 5 FIRST AND GET THE TENANT ID AND REPLACE THE tenantId variable value BELOW WITH THIS ID)

        //****** END - USER CREATED! ******

        var email = "becsaev@guildlink.com.au"; //User Email

        var firstName = "Bobby";

        var lastName = "Esaev";

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

        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)           

        var userAccountId = 834227056697934848; //GET THIS INFORMATION FROM STEP 1

        var operatorSourceIdentifier = Base64UrlTextEncoder.Encode(BitConverter.GetBytes(userAccountId));

        //Console.WriteLine(BitConverter.ToInt64(Base64UrlTextEncoder.Decode("AASAkBbFkws"))); //IF YOU NEED TO DECODE THE ID

        var operatorIdentityId = 834394572669846528; //GET THIS INFORMATION FROM STEP 3

        var tenantId = 706840070690178795; //IF YOU ARE ADDING THIS USER TO AN EXISTING PHARMACY THEN GET THE TENANT ID FROM [api].[Tenant] Table, IF YOU NEED TO SET UP A NEW PHARMACY RUN QUERY 5 FIRST TO GET THE NEW PHARMACY ID

        //QUERY 1 - Adds a new user into UserAccount Table      

        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 - Adds the user acount into UserAccountIdentity Table

        var addUserAccountIdentitySQL = $@"INSERT INTO [idp].[UserAccountIdentity]

           ([Id],[IdentityProviderId],[Identifier],[UserAccountId],[Deleted])

         VALUES

           ([shared].uniqueid(0),{identityProviderId},'{email}',{userAccountId},0)

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

           ";

        //QUERY 3 - Creates a OperatorIdentity Id for the Operator table

        var addOperatorIdentitySQL = $@"INSERT INTO [api].[OperatorIdentity]

           ([Id],[Deleted])

           VALUES

           ([shared].uniqueid(0) ,0)

​

           SELECT TOP 1 * FROM [api].[OperatorIdentity] ORDER BY Id DESC

​

           ";

        //QUERY 4 - Adds a new user account to the Opertor Table

        var addOperatorSQL = $@"INSERT INTO [api].[Operator]

           ([Id],[IdentityId],[TenantId],[SourceId],[SourceIdentifier],[Surname],[GivenName],[Gender],[Deleted])

           VALUES

           ([shared].uniqueid(0),{operatorIdentityId},{tenantId},1,'{operatorSourceIdentifier}','{firstName}','{lastName}',0,0)

​

            SELECT TOP 1 * FROM [api].[Operator] ORDER BY Id DESC

​

           ";           

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

        Console.WriteLine(addUserAccountSQL);

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

        Console.WriteLine(addUserAccountIdentitySQL);

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

        Console.WriteLine(addOperatorIdentitySQL);

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

        Console.WriteLine(addOperatorSQL);

        //****** PROCESS TO SET UP A NEW PHARMACY INTO THE CROSS (cross-dev or cross-twcm-production) ******        

        //1 - RUN THE CODE AGAIN, THEN COPY QUERY 5 FROM THE OUTPUT CONSOLE AND RUN IT ON SQL SERVER    

        //****** END - PHARMACY CREATED! ******

        var clientId = 7234022819097704308; //THIS ID COMES FROM THE [api].[Client] TABLE AND WILL BE THE SAME FOR ALL TENANTS. Dev Id(7234022819097704308) - Prod Id(7234022819097704308) - Dev and prod has the same 

        var storeId = 1438; //WHEN TERRY WHITE REQUESTS US TO CREATE A NEW PHARMACY THEY PROVIDE THE STORE ID;

        var storeName = "TerryWhite Chemmart Stafford";  //WHEN TERRY WHITE REQUESTS US TO CREATE A NEW PHARMACY THEY PROVIDE THE STORE NAME;

        //QUERY 5 - Adds a new user account to the Opertor Table

        var addTenantSQL = $@"INSERT INTO [api].[Tenant]

           ([Id] ,[ClientId] ,[SharedIdentifier] ,[Name] ,[Deleted])

           VALUES

           ([shared].uniqueid(0) ,{clientId} ,'{storeId}' ,'{storeName}' ,0)

​

            SELECT TOP 1 * FROM [api].[Tenant] ORDER BY Id DESC

​

           ";   

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

        Console.WriteLine(addTenantSQL);

    }

}