how to get odd saturday in a month in c#

Arrogant Addax answered on June 17, 2020 Popularity 2/10 Helpfulness 1/10

answer how to get odd saturday in a month in c#

how to get odd saturday in a month in c#

Comment

int year = 2016; // 366 days in 2016 because leap year
DateTime yearStart = new DateTime(year, 1, 1);
int daysInYear = (yearStart.AddYears(1) - yearStart).Days; // 366
var oddSaturdays = Enumerable.Range(0, daysInYear)
    .Select(day => yearStart.AddDays(day))
    .Where(date => date.Day % 2 == 1 && date.DayOfWeek == DayOfWeek.Saturday);

foreach (DateTime oddSaturday in oddSaturdays)
{ 
    // ...
    string sql = string.Format("INSERT INTO {0}.[WEEKEND] ([DATE],[DAYNAME]) VALUES (@DATE, @DAYNAME)", schemaname);
    using (var cmd = new SqlCommand(sql, con))
    {
        cmd.Parameters.Add("@DATE", SqlDbType.Date).Value = oddSaturday;
        cmd.Parameters.Add("@DAYNAME", SqlDbType.VarChar).Value = oddSaturday.DayOfWeek.ToString();
        int inserted = cmd.ExecuteNonQuery();
    }
    // ...
}

Popularity 2/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: c# get

Link to this answer
Share Copy Link

Contributed on Jun 17 2020

Arrogant Addax

0 Answers Avg Quality 2/10

how to get odd saturday in a month in c#

Contents

More Related Answers

how to get odd saturday in a month in c#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.