using System;

public class Program

{

    public static void Main()

    {

        var format = "yyyy-MM-ddTHH:mm:sszzz";

        // Say someone creates a Factory at 5:00pm IST

        var origOffset = new TimeSpan(5, 0, 0);

        var origDateTimeOffset = new DateTimeOffset(2022, 11, 09, 17, 0, 0, origOffset);

        var origDateTime = origDateTimeOffset.UtcDateTime;

        var origDateString = origDateTimeOffset.ToString(format); // simulate what api would do outbound. 

        var origDateTimeString = origDateTime.ToString(format); // simulate what mapping to database would do

        Console.WriteLine("Factory Created DateTimeOffset (IST).........................: " + origDateString);

        Console.WriteLine("Factory Created DateTime (Adjusted to UTC)...................: " + origDateTimeString);

        // what we save to the database

        var origDbDateOffset = origDateTimeOffset.ToUniversalTime();

        var origDbDateOffsetString = origDbDateOffset.ToString(format); // this the value stored in the database. 

        var origDbDateTime = origDbDateOffset.UtcDateTime; // converted from dto => dt

        var origDbDateTimeString = origDbDateTime.ToString(format); // this the value stored in the database. 

        Console.WriteLine("Factory Created Value in Database DateTimeOffset (UTC).......: " + origDbDateOffsetString);

        Console.WriteLine("Factory Created Value in Database DateTime (UTC).............: " + origDbDateTimeString);

        // A caller (in -5:00 locale US / Eastern time ) sends in a date parameter to an inquiry service.

        // for a factories created 07:00am EST

        var callerOffset = new TimeSpan(-5, 0, 0);

        var callerDate = new DateTimeOffset(2022, 11, 09, 7, 0, 0, callerOffset);

        var callerDateString = callerDate.ToString(format); 

        Console.WriteLine("Caller Query Date (EST)......................................: " + callerDateString);

        //transformed query date parameter sent to the database

        var callerDbDate = callerDate.ToUniversalTime();

        string sql = "select * from factory where createddate = '"+callerDbDate.ToString(format)+"'";

        Console.WriteLine("\n" +sql);

        if (origDateTimeOffset.Equals(origDbDateOffset) && origDbDateOffset.Equals(callerDate) && callerDate.Equals(callerDbDate) && origDateTime.Equals(origDbDateTime))

            Console.WriteLine("All dates are equal");

        else

            Console.WriteLine("All dates are NOT equal");

    }

}