Developer Assessment

Show how you would convert DateTime.UtcNow into central time zone.
IMyInterface proxy = Factory.Create<IMyInterface>();
A database table exists with the following fields: ID (int, pk), Name (varchar), IsPromoted (bit). Write a SELECT statement that accepts @Query as input, and returns all entries from this table with a partial match on this. Promoted entries, if they exist in the results, should be boosted so that they appear in every odd result, starting with position #1.
Write the HTML for a form, asking the user for their name, email and phone number.