using System.Collections.Generic;
public static void Main()
GetRecord1(TimeRange.Yesterday);
private static void GetRecord1(TimeRange timeRange)
var dateFrom = DateTime.Today;
var dateTo = DateTime.Today; ;
case TimeRange.Yesterday:
dateFrom = dateFrom.AddDays(-1);
dateTo = dateTo.AddSeconds(-1);
Console.WriteLine("dateFrom :"+dateFrom);
Console.WriteLine("dateTo :"+dateTo);
var thisWeekStart = dateFrom.AddDays(-(int)dateFrom.DayOfWeek);
var thisWeekEnd = thisWeekStart.AddDays(7).AddSeconds(-1);
dateFrom = thisWeekStart.AddDays(-7);
dateTo = thisWeekStart.AddSeconds(-1);
case TimeRange.lastmonth:
var thisMonthStart = dateFrom.AddDays(1 - dateFrom.Day);
var thisMonthEnd = thisMonthStart.AddMonths(1).AddSeconds(-1);
dateFrom = thisMonthStart.AddMonths(-1);
dateTo = thisMonthStart.AddSeconds(-1);
case TimeRange.Last7days:
dateFrom = dateFrom.AddDays(-7);
case TimeRange.Last30days:
dateFrom = dateFrom.AddDays(-30);
var year = dateFrom.Year;
dateFrom = new DateTime(year - 1, 1, 1);
dateTo = new DateTime(year - 1, 12, 31);