How to save weekend values in Database?

UPDATE: 

This is the code for bringing the DayOfWeek property dynamically. Solved it. 

                    int totalWorkingDaysInMonth = 0;
                    var timeTable = db.TimeTableAndOtherSettings
                        .Where(a => a.TimeTableAndOtherSettingsId == data.Employee.TimeTableAndOtherInforamtionsId)
                        .Include(a => a.CompanyInformation).ToList();
                    foreach (var timetabledata in timeTable)
                    {

                        totalWorkingDaysInMonth = Enumerable
                            .Range(1, DateTime.DaysInMonth(month.Value.Year, month.Value.Month))
                            .Select(day => new DateTime(month.Value.Year, month.Value.Month, day))
                            .Count(d => d.DayOfWeek != (DayOfWeek)Convert.ToInt32(timetabledata.WeekEnd1) &&
                                        d.DayOfWeek != (DayOfWeek)Convert.ToInt32(timetabledata.WeekEnd2));
                    }

I am not sure if I got this right, but you can get Day of the week by using DATENAME and DATEPART in sql server, then remove that paticular days from the list or save it in database.

Suppose, if you have DateTime saved in the database and want to check if that date is weekend value or not

SELECT DATENAME(dw,DateTimeColumn) -- Saturday
SELECT DATEPART(dw,DateTimeColumn)) -- 7

In C# linq

using System.Data.Objects.SqlClient; //Don't forget this!!

//You can access to SQL DatePart function using something like this:

YourTable.Select(t => new { DayOfWeek = SqlFunctions.DatePart("weekday", t.dateTimeField) - 1 });
//t.dateTimeField is the column with datetime value to check

//You can compare to SQL DatePart function using something like this:

DateTime dateToCompare = DateTime.Today;
YourTable.Where(t => SqlFunctions.DatePart("weekday", t.dateTimeField) - 1 == dateToCompare }); //Zero based in SQL

If you are using Entity framework check this

https://stackoverflow.com/questions/40271588/entity-framework-dayofweek

To Get the total number of working days for a month of specific period of time, here is the complete C# program

using System;
					
public class Program
{
	public static void Main()
	{
		

       int totalWorkingDaysInMonth = GetWorkingDays(DateTime.Now.AddDays(-31),DateTime.Now);
                            
		
		Console.WriteLine(totalWorkingDaysInMonth);

	}
	
	public static int GetWorkingDays(DateTime dtmStart, DateTime dtmEnd) 
    { 
		// This function includes the start and end date if it falls on a weekday 
		int dowStart = ((int)dtmStart.DayOfWeek == 0 ? 7 : (int)dtmStart.DayOfWeek); 
		
		int dowEnd = ((int)dtmEnd.DayOfWeek == 0 ? 7 : (int)dtmEnd.DayOfWeek); 
		
		TimeSpan tSpan = dtmEnd - dtmStart; 
		
		if (dowStart <= dowEnd) 
		{ 
		return (((tSpan.Days / 7) * 5) + Math.Max((Math.Min((dowEnd + 1), 6) - dowStart), 0)); 
		} 
		else 
		{ 
		return (((tSpan.Days / 7) * 5) + Math.Min((dowEnd + 6) - Math.Min(dowStart, 6), 5)); 
		} 
    } 
}

Try : https://dotnetfiddle.net/1X2nME

Output: 24