Recording date range, with useful days in Dictionary

Question

I need to build two methods in my system, which do the following:

1) Save to a dictionary<T> in C#, a crease of dates. For this I have a function that consumption in the Sqlserver here from the company, who returns me a whole working day. The standard architecture is already established this way, so I have to do it this way;

The Function of Sqlserver, I consume as follows:

using (IDbConnection dbConnection = Connection)
{
    string sQuery = "select dbo.working_days(@dtUtil) as QuantidadeDiasUteis";
    dbConnection.Open();

    return dbConnection.Query<DiasUteis>(sQuery, new { dtUtil = 
    Convert.ToDateTime(DtDiaUtil) }).FirstOrDefault();

}

Note: My input parameter is a future date, and it returns me the number of working days in an integer.

2) After the dates in the Dictionary, I need to read, check the dates.

So the structure would look something like this:

31/07/2018 = 1;
01/08/2018 = 3;
06/08/2018 = 4; ==> (Ignorou os Sábados e Domingos);

I need to return this information!

Answer 1

I made 4 options of methods for calculating dates, two with list and two with Dictionary

Follows Code

public static List<DateTime> DatasUteis1(int quantidade)
{
    List<DateTime> datas = new List<DateTime>();
    DateTime data = DateTime.Today;
    for (int i = 1; i <= quantidade; i++)
    {
        if (data.AddDays(i).DayOfWeek != DayOfWeek.Saturday && data.AddDays(i).DayOfWeek != DayOfWeek.Sunday)
            datas.Add(data.AddDays(i));
    }

    return datas;
}

public static List<DateTime> DatasUteis2(int quantidade)
{
    List<DateTime> datas = new List<DateTime>();
    DateTime data = DateTime.Today;
    for (int i = 1; i <= quantidade; i++)
    {
        if (data.AddDays(i).DayOfWeek != DayOfWeek.Saturday && data.AddDays(i).DayOfWeek != DayOfWeek.Sunday)
            datas.Add(data.AddDays(i));
        else
            quantidade++;
    }

    return datas;
}

public static Dictionary<int, DateTime> DatasUteis3(int quantidade)
{
    Dictionary<int, DateTime> datas = new Dictionary<int, DateTime>();
    DateTime data = DateTime.Today;
    for (int i = 1; i <= quantidade; i++)
    {
        if (data.AddDays(i).DayOfWeek != DayOfWeek.Saturday && data.AddDays(i).DayOfWeek != DayOfWeek.Sunday)
            datas.Add(i, data.AddDays(i));
    }

    return datas;
}

public static Dictionary<int, DateTime> DatasUteis4(int quantidade)
{
    Dictionary<int, DateTime> datas = new Dictionary<int, DateTime>();
    DateTime data = DateTime.Today;
    for (int i = 1; i <= quantidade; i++)
    {
        if (data.AddDays(i).DayOfWeek != DayOfWeek.Saturday && data.AddDays(i).DayOfWeek != DayOfWeek.Sunday)
            datas.Add(i, data.AddDays(i));
        else
            quantidade++;
    }

    return datas;
}

As you said the return of the bank is number of working days, I passed this in the method parameter, the method DatasUteis1 and DatasUteis3 skip weekends and consider only the exact amount of days passed as a parameter, whereas methods DatasUteis2 and DatasUteis4 consider the total number of working days informed.

I also put in the .NET Fiddle for reference.