/C#/How to get odd saturday in a month in c#

How to get odd saturday in a month in c#

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();
    }
    // ...
}

Source: stackoverflow.com

Similar codes

0 vote121 views2 answers
How many days till christmas
C#
0 vote147 views1 answer
How to make a console feedback
C#
3 votes115 views1 answer
Executable path with app name c#
C#
0 vote125 views1 answer
Iis services in asp.net
C#
1 vote141 views1 answer
Unity c#loading a scene after a few seconds
C#
1 vote121 views1 answer
The CodeDom provider type "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" could not be located.
C#
0 vote135 views1 answer
SETTING UP ARRAY FOR TEST SCORES IN C#
C#
2 votes121 views2 answers
The value '1990-10-23' is not valid for DOB. Data Annotation C#
C#
0 vote130 views1 answer
C# modulo
C#
4 votes143 views1 answer
Hyperx quadcast s uk
C#