✅ Converting String To DateTimeOffset & Getting Average Days To Goal

public class Goal
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string StartDate { get; set; }
    public string EndDate { get; set; }
    public string DaysToGoal { get; set; }
    public string HoursPerDay { get; set; }
    public string Achieved { get; set; }
}

public class Goal
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string StartDate { get; set; }
    public string EndDate { get; set; }
    public string DaysToGoal { get; set; }
    public string HoursPerDay { get; set; }
    public string Achieved { get; set; }
}

public static double CalculateHoursPerDay(string? startDate, string? endDate, double hoursPerDay)
{
    DateTimeOffset start = DateTimeOffset.Parse(startDate);
    DateTimeOffset end = DateTimeOffset.Parse(endDate);

    TimeSpan difference = end.Subtract(start);
    TimeSpan dtg = difference.Divide(hoursPerDay);

    double daysToGoal = Convert.ToDouble(dtg.TotalDays);
    return daysToGoal;
}

public static double CalculateHoursPerDay(string? startDate, string? endDate, double hoursPerDay)
{
    DateTimeOffset start = DateTimeOffset.Parse(startDate);
    DateTimeOffset end = DateTimeOffset.Parse(endDate);

    TimeSpan difference = end.Subtract(start);
    TimeSpan dtg = difference.Divide(hoursPerDay);

    double daysToGoal = Convert.ToDouble(dtg.TotalDays);
    return daysToGoal;
}

Create the ability to set coding goals and show how far the users are from reaching their goal, along with how many hours a day they would have to code to reach their goal. You can do it via SQL queries or with C#.

Create the ability to set coding goals and show how far the users are from reaching their goal, along with how many hours a day they would have to code to reach their goal. You can do it via SQL queries or with C#.

public static double DaysToGoal(string? startDate, string? endDate)
{
    DateTimeOffset start = DateTimeOffset.Parse(startDate);
    DateTimeOffset end = DateTimeOffset.Parse(endDate);

    TimeSpan difference = end.Subtract(start);

    double daysToGoal = Convert.ToDouble(difference.TotalDays);
    return daysToGoal;
}

public static double DaysToGoal(string? startDate, string? endDate)
{
    DateTimeOffset start = DateTimeOffset.Parse(startDate);
    DateTimeOffset end = DateTimeOffset.Parse(endDate);

    TimeSpan difference = end.Subtract(start);

    double daysToGoal = Convert.ToDouble(difference.TotalDays);
    return daysToGoal;
}

public class Goal
{
    public int? Id { get; set; }
    public string? Name { get; set; }
    public string? StartDate { get; set; }
    public string? EndDate { get; set; }
    public double? DaysToGoal { get; set; }
    public double? HoursPerDay { get; set; }
    public string? Achieved { get; set; }
}

public class Goal
{
    public int? Id { get; set; }
    public string? Name { get; set; }
    public string? StartDate { get; set; }
    public string? EndDate { get; set; }
    public double? DaysToGoal { get; set; }
    public double? HoursPerDay { get; set; }
    public string? Achieved { get; set; }
}

Console.WriteLine("\nWhen Editing Information, if you want it left the same then press ENTER to skip it.");
Console.WriteLine("\nCurrent Start Date: {currentGoal.StartDate}");
Console.Write("Enter Corrected Start Date: ");

string? input = Console.ReadLine();
string? newStartDate = UserValidation.VerifyEmptyOrChanged(
  currentGoal.StartDate,
  UserValidation.VerifyDateInput(input));

Console.WriteLine("\nWhen Editing Information, if you want it left the same then press ENTER to skip it.");
Console.WriteLine("\nCurrent Start Date: {currentGoal.StartDate}");
Console.Write("Enter Corrected Start Date: ");

string? input = Console.ReadLine();
string? newStartDate = UserValidation.VerifyEmptyOrChanged(
  currentGoal.StartDate,
  UserValidation.VerifyDateInput(input));

-------------------------
Goal Name: An Edited Test Goal
Start Date: 01/01/0001
End Date: 01/01/0001
Coding Hours Per Day: 6
Days Until Goal: 0
Goal Achieved: No
-------------------------

-------------------------
Goal Name: An Edited Test Goal
Start Date: 01/01/0001
End Date: 01/01/0001
Coding Hours Per Day: 6
Days Until Goal: 0
Goal Achieved: No
-------------------------

    public static string VerifyDateInput(string input)
    {
        CultureInfo provider = CultureInfo.InvariantCulture;
        string format = "MM/dd/yyyy";
        DateTimeStyles style = DateTimeStyles.None;
        DateTimeOffset result;

        while (!DateTimeOffset.TryParseExact(input, format, provider, style, out result) && !String.IsNullOrEmpty(input))
        {
            Console.ForegroundColor = ConsoleColor.Red;
            Console.WriteLine("[Error] Input Must Be In Format: MM/DD/YYYY");

            Console.ForegroundColor = ConsoleColor.White;
            Console.Write("Enter Corrected Date: ");

            input = Console.ReadLine();
        }

        return result.ToString(format);
    }

    public static string VerifyDateInput(string input)
    {
        CultureInfo provider = CultureInfo.InvariantCulture;
        string format = "MM/dd/yyyy";
        DateTimeStyles style = DateTimeStyles.None;
        DateTimeOffset result;

        while (!DateTimeOffset.TryParseExact(input, format, provider, style, out result) && !String.IsNullOrEmpty(input))
        {
            Console.ForegroundColor = ConsoleColor.Red;
            Console.WriteLine("[Error] Input Must Be In Format: MM/DD/YYYY");

            Console.ForegroundColor = ConsoleColor.White;
            Console.Write("Enter Corrected Date: ");

            input = Console.ReadLine();
        }

        return result.ToString(format);
    }

    public static string VerifyEmptyOrChanged(string oldEntry, string newEntry)
    {
        if (String.IsNullOrEmpty(newEntry) || newEntry == oldEntry)
        {
            return oldEntry;
        }
        else
        {
            return newEntry;
        }
    }

    public static string VerifyEmptyOrChanged(string oldEntry, string newEntry)
    {
        if (String.IsNullOrEmpty(newEntry) || newEntry == oldEntry)
        {
            return oldEntry;
        }
        else
        {
            return newEntry;
        }
    }

string? newStartDate = UserValidation.VerifyEmptyOrChanged(
    currentGoal.StartDate,
    UserValidation.VerifyDateInput(input));

string? newStartDate = UserValidation.VerifyEmptyOrChanged(
    currentGoal.StartDate,
    UserValidation.VerifyDateInput(input));

input = Console.ReadLine();
string? newStartDate = UserValidation.VerifyEmptyOrChanged(input);
newStartDate = UserValidation.VerifyDateInput(newStartDate);

input = Console.ReadLine();
string? newStartDate = UserValidation.VerifyEmptyOrChanged(input);
newStartDate = UserValidation.VerifyDateInput(newStartDate);

public static bool VerifyEmptyOrChanged(string? oldEntry, string? newEntry)
{
  if (String.IsNullOrEmpty(newEntry) || newEntry == oldEntry)
  {
    return true;
  } 
  else
  {
    return false;
}

input = Console.ReadLine();
bool dateChanged = UserValidation.VerifyEmptyOrChanged(currentGoal.StartDate, input);
newStartDate = dateChanged ? UserValidation.VerifyDateInput(input) : currentGoal.StartDate;

public static bool VerifyEmptyOrChanged(string? oldEntry, string? newEntry)
{
  if (String.IsNullOrEmpty(newEntry) || newEntry == oldEntry)
  {
    return true;
  } 
  else
  {
    return false;
}

input = Console.ReadLine();
bool dateChanged = UserValidation.VerifyEmptyOrChanged(currentGoal.StartDate, input);
newStartDate = dateChanged ? UserValidation.VerifyDateInput(input) : currentGoal.StartDate;

static bool VerifyChanged(string? old, string? newI)
{
    return (String.IsNullOrEmpty(newI) || newI == old) ? false : true;
}

static string? VerifyDateInput(string? input)
{
    CultureInfo provider = CultureInfo.InvariantCulture;
    string format = "MM/dd/yyyy";
    DateTimeStyles style = DateTimeStyles.None;
    DateTimeOffset result;

    while (!DateTimeOffset.TryParseExact(input, format, provider, style, out result) && !String.IsNullOrEmpty(input))
    {
        Console.ForegroundColor = ConsoleColor.Red;
        Console.WriteLine("[Error] Input Must Be In Format: MM/DD/YYYY");

        Console.ForegroundColor = ConsoleColor.White;
        Console.Write("Enter Corrected Date: ");

        input = Console.ReadLine();
    }

    return result.ToString(format);
}

string? currentDate = "01/01/0001";
string? input = "02/02/0002";

bool nameChanged = VerifyChanged(currentDate, input);

string? newDate = nameChanged ? VerifyDateInput(input) : currentDate;

Console.WriteLine(newDate);

static bool VerifyChanged(string? old, string? newI)
{
    return (String.IsNullOrEmpty(newI) || newI == old) ? false : true;
}

static string? VerifyDateInput(string? input)
{
    CultureInfo provider = CultureInfo.InvariantCulture;
    string format = "MM/dd/yyyy";
    DateTimeStyles style = DateTimeStyles.None;
    DateTimeOffset result;

    while (!DateTimeOffset.TryParseExact(input, format, provider, style, out result) && !String.IsNullOrEmpty(input))
    {
        Console.ForegroundColor = ConsoleColor.Red;
        Console.WriteLine("[Error] Input Must Be In Format: MM/DD/YYYY");

        Console.ForegroundColor = ConsoleColor.White;
        Console.Write("Enter Corrected Date: ");

        input = Console.ReadLine();
    }

    return result.ToString(format);
}

string? currentDate = "01/01/0001";
string? input = "02/02/0002";

bool nameChanged = VerifyChanged(currentDate, input);

string? newDate = nameChanged ? VerifyDateInput(input) : currentDate;

Console.WriteLine(newDate);

static double CalculateAverageSession(List<CodeSession?>? allSessions)
{
    List<double> values = GetTotalSessionTime(allSessions);

    double totalSeconds = 0;

    foreach (double value in values)
    {
        totalSeconds = totalSeconds + value;
    }

    double averateTime = totalSeconds / values.Count;

    TimeSpan time = TimeSpan.FromSeconds(totalSeconds);
    string str = time.ToString(@"hh\:mm\:ss");

    Console.WriteLine("Total Time: {0}", str);
    return averateTime;
}

static List<double> GetTotalSessionTime(List<CodeSession?>? allSessions)
{
    List<double> values = new();

    string format = @"hh\:mm";
    CultureInfo provider = CultureInfo.InvariantCulture;

    foreach (CodeSession session in allSessions)
    {
        TimeSpan startTime;
        TimeSpan endTime;

        TimeSpan start = TimeSpan.ParseExact(session.StartTime, format, provider);
        TimeSpan end = TimeSpan.ParseExact(session.EndTime, format, provider);
        TimeSpan difference = end.Subtract(start);

        double timeInSeconds = difference.TotalSeconds;

        values.Add(timeInSeconds);
    }

    return values;
}

List<CodeSession?>? allSessions = new() {};


CodeSession? session = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "08:00", EndTime = "12:00", Duration = "04:00:00" };
CodeSession? session1 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "09:00", EndTime = "13:00", Duration = "04:00:00" };
CodeSession? session2 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "10:00", EndTime = "14:00", Duration = "04:00:00" };
CodeSession? session3 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "11:00", EndTime = "15:00", Duration = "04:00:00" };
CodeSession? session4 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "12:00", EndTime = "16:00", Duration = "04:00:00" };
CodeSession? session5 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "13:00", EndTime = "17:00", Duration = "04:00:00" };
CodeSession? session6 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "14:00", EndTime = "18:00", Duration = "04:00:00" };

allSessions.Add(session);
allSessions.Add(session1);
allSessions.Add(session2);
allSessions.Add(session3);
allSessions.Add(session4);
allSessions.Add(session5);
allSessions.Add(session6);

double averageTime = CalculateAverageSession(allSessions);

TimeSpan time = TimeSpan.FromSeconds(averageTime);
string str = time.ToString(@"hh\:mm\:ss");

Console.WriteLine("Average Time: {0}", str);

class CodeSession
{
    public int? Id { get; set; }
    public string? TodaysDate { get; set; }
    public string? StartTime { get; set; }
    public string? EndTime { get; set; }
    public string? Duration { get; set; }
}

static double CalculateAverageSession(List<CodeSession?>? allSessions)
{
    List<double> values = GetTotalSessionTime(allSessions);

    double totalSeconds = 0;

    foreach (double value in values)
    {
        totalSeconds = totalSeconds + value;
    }

    double averateTime = totalSeconds / values.Count;

    TimeSpan time = TimeSpan.FromSeconds(totalSeconds);
    string str = time.ToString(@"hh\:mm\:ss");

    Console.WriteLine("Total Time: {0}", str);
    return averateTime;
}

static List<double> GetTotalSessionTime(List<CodeSession?>? allSessions)
{
    List<double> values = new();

    string format = @"hh\:mm";
    CultureInfo provider = CultureInfo.InvariantCulture;

    foreach (CodeSession session in allSessions)
    {
        TimeSpan startTime;
        TimeSpan endTime;

        TimeSpan start = TimeSpan.ParseExact(session.StartTime, format, provider);
        TimeSpan end = TimeSpan.ParseExact(session.EndTime, format, provider);
        TimeSpan difference = end.Subtract(start);

        double timeInSeconds = difference.TotalSeconds;

        values.Add(timeInSeconds);
    }

    return values;
}

List<CodeSession?>? allSessions = new() {};


CodeSession? session = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "08:00", EndTime = "12:00", Duration = "04:00:00" };
CodeSession? session1 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "09:00", EndTime = "13:00", Duration = "04:00:00" };
CodeSession? session2 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "10:00", EndTime = "14:00", Duration = "04:00:00" };
CodeSession? session3 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "11:00", EndTime = "15:00", Duration = "04:00:00" };
CodeSession? session4 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "12:00", EndTime = "16:00", Duration = "04:00:00" };
CodeSession? session5 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "13:00", EndTime = "17:00", Duration = "04:00:00" };
CodeSession? session6 = new() { Id = 1, TodaysDate = "10/05/2023", StartTime = "14:00", EndTime = "18:00", Duration = "04:00:00" };

allSessions.Add(session);
allSessions.Add(session1);
allSessions.Add(session2);
allSessions.Add(session3);
allSessions.Add(session4);
allSessions.Add(session5);
allSessions.Add(session6);

double averageTime = CalculateAverageSession(allSessions);

TimeSpan time = TimeSpan.FromSeconds(averageTime);
string str = time.ToString(@"hh\:mm\:ss");

Console.WriteLine("Average Time: {0}", str);

class CodeSession
{
    public int? Id { get; set; }
    public string? TodaysDate { get; set; }
    public string? StartTime { get; set; }
    public string? EndTime { get; set; }
    public string? Duration { get; set; }
}