karenpayneoregon

Using C# create a class with a method to read a .csproj file.

1. Check if UserSecretsId node exists in a method named Exists
2. If UserSecretsId node exists return the value in a method named GetValue

<Project Sdk="Microsoft.NET.Sdk">

	<PropertyGroup>
 net9.0

karenpayneoregon

using System.Diagnostics;
using System.Reflection;

namespace TODO;

public class AssemblyHelper
{

    /// <summary>
    /// Retrieves the namespace of the calling assembly that references the current assembly.

karenpayneoregon

    /* Re-tint out-of-month or disabled days */
    .datepicker table tr td.old,
    .datepicker table tr td.new,
    .datepicker table tr td.disabled,
    .datepicker table tr td.disabled:hover {
        color: #b22222;   /* Firebrick red – pick your poison */
    }

karenpayneoregon

input[type="text"],
input[type="email"],
input[type="password"] {
    all: unset;
    box-sizing: border-box;
    display: block;
    width: 100%;
    max-width: 400px;
    padding: 10px 12px;
    font-size: 1rem;

karenpayneoregon

namespace InputsDemo;

internal partial class Program
{
    static void Main(string[] args)
    {
        var value = Prompts.GetDate();
        Console.WriteLine(value.Year == 1 ? "Cancelled" : $"Selected date: {value:MM/dd/yyyy HH:mm}");
        Console.ReadLine();
    }

karenpayneoregon

public class CatalogInfo
{
    public string ProductDisplayVersion { get; set; }
}

karenpayneoregon

using System.Xml.Linq;

namespace UpdateFrameworkApp.Classes;

public class ProjectUpdater
{
    public static string UpdateTargetFramework(string csprojPath, string oldFramework = "net7.0", string newFramework = "net9.0")
    {
        if (!File.Exists(csprojPath))
        {

karenpayneoregon

DECLARE @TableName AS NVARCHAR(MAX) = 'Birthdays'
SELECT 
    X.COLUMN_NAME AS ColumnName, 
    X.ORDINAL_POSITION AS Position, 
    X.TABLE_CATALOG AS Catalog, 
    X.TABLE_SCHEMA AS TableSchema,
    X.COLUMN_DEFAULT AS ColumnDefault, 
    X.DATA_TYPE AS DataType,
    CASE 
        WHEN KCU.COLUMN_NAME IS NOT NULL THEN CAST(1 AS BIT)

karenpayneoregon

// create a method in DapperOperations.cs named GetImageById using Dapper
public class DapperOperations
{
    private readonly string _connectionString;

    public DapperOperations(string connectionString)
    {
        _connectionString = connectionString;
    }

karenpayneoregon

public static string CalculateTimeDifference(DateTime futureDate)
{
    if (futureDate <= DateTime.Now)
    {
        return "The provided date must be in the future.";
    }

    DateTime now = DateTime.Now;

    // Calculate total months difference