public static DateFilterDates GetRecTransDateFilterDates(string dateFilterName) { DateFilterDates dateFilter = new DateFilterDates(); dateFilter.FilterName = dateFilterName; switch (dateFilterName) { case "CURMONTH": dateFilter.FromDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); var cM = DateTime.Now.Month; var cY = DateTime.Now.Year; var daysInCurMonth = DateTime.DaysInMonth(cY, cM); dateFilter.ToDate = new DateTime(cY, cM, daysInCurMonth);; break; case "PREMONTH": var m = DateTime.Now.Month; var y = DateTime.Now.Year; if (m > 1) { m = m - 1; } else { m = 12; y = y - 1; } dateFilter.FromDate = new DateTime(y, m, 1); dateFilter.ToDate = new DateTime(y, m, DateTime.DaysInMonth(y, m)); break; case "30DAYS": dateFilter.FromDate = DateTime.Now; dateFilter.ToDate = dateFilter.FromDate.AddDays(30); break; case "60DAYS": dateFilter.FromDate = DateTime.Now; dateFilter.ToDate = dateFilter.FromDate.AddDays(60); break; case "90DAYS": dateFilter.FromDate = DateTime.Now;; dateFilter.ToDate = dateFilter.FromDate.AddDays(90); break; case "360DAYS": dateFilter.FromDate = DateTime.Now; dateFilter.ToDate = dateFilter.FromDate.AddDays(360); break; case "CURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 1, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 12, 31); break; case "LASTYEAR": var ty = DateTime.Now.Year; ty = ty - 1; dateFilter.FromDate = new DateTime(ty, 1, 1); dateFilter.ToDate = new DateTime(ty, 12, DateTime.DaysInMonth(ty, 12)); break; case "ALL": dateFilter.FromDate = new DateTime(1966, 8, 1); dateFilter.ToDate = DateTime.MaxValue; break; default: dateFilter.FromDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 1, 1);; dateFilter.FilterName = "CURYEAR"; break; } return(dateFilter); }
public static DateFilterDates GetDateFilterDates(string dateFilterName) { DateFilterDates dateFilter = new DateFilterDates(); dateFilter.FilterName = dateFilterName; switch (dateFilterName) { case "CURMONTH": dateFilter.FromDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dateFilter.ToDate = DateTime.Now; break; case "PREMONTH": var m = DateTime.Now.Month; var y = DateTime.Now.Year; if (m > 1) { m = m - 1; } else { m = 12; y = y - 1; } dateFilter.FromDate = new DateTime(y, m, 1); dateFilter.ToDate = new DateTime(y, m, DateTime.DaysInMonth(y, m)); break; case "30DAYS": dateFilter.ToDate = DateTime.Now; dateFilter.FromDate = dateFilter.ToDate.AddDays(-30); break; case "60DAYS": dateFilter.ToDate = DateTime.Now; dateFilter.FromDate = dateFilter.ToDate.AddDays(-60); break; case "90DAYS": dateFilter.ToDate = DateTime.Now; dateFilter.FromDate = dateFilter.ToDate.AddDays(-90); break; case "360DAYS": dateFilter.ToDate = DateTime.Now; dateFilter.FromDate = dateFilter.ToDate.AddDays(-360); break; case "CURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 1, 1); dateFilter.ToDate = DateTime.Now; break; case "JANCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 1, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 1, DateTime.DaysInMonth(DateTime.Now.Year, 1)); break; case "FEBCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 2, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 2, DateTime.DaysInMonth(DateTime.Now.Year, 2)); break; case "MARCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 3, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 3, DateTime.DaysInMonth(DateTime.Now.Year, 3)); break; case "APRCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 4, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 4, DateTime.DaysInMonth(DateTime.Now.Year, 4)); break; case "MAICURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 5, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 5, DateTime.DaysInMonth(DateTime.Now.Year, 5)); break; case "JUNCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 6, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 6, DateTime.DaysInMonth(DateTime.Now.Year, 6)); break; case "JULCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 7, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 7, DateTime.DaysInMonth(DateTime.Now.Year, 7)); break; case "AUGCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 8, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 8, DateTime.DaysInMonth(DateTime.Now.Year, 8)); break; case "SEPCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 9, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 9, DateTime.DaysInMonth(DateTime.Now.Year, 9)); break; case "OKTCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 10, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 10, DateTime.DaysInMonth(DateTime.Now.Year, 10)); break; case "NOVCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 11, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 11, DateTime.DaysInMonth(DateTime.Now.Year, 11)); break; case "DECCURYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year, 12, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year, 12, DateTime.DaysInMonth(DateTime.Now.Year, 12)); break; case "LASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 1, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 12, DateTime.DaysInMonth(DateTime.Now.Year - 1, 12)); break; case "JANLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 1, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 1, DateTime.DaysInMonth(DateTime.Now.Year - 1, 1)); break; case "FEBLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 2, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 2, DateTime.DaysInMonth(DateTime.Now.Year - 1, 2)); break; case "MARLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 3, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 3, DateTime.DaysInMonth(DateTime.Now.Year - 1, 3)); break; case "APRLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 4, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 4, DateTime.DaysInMonth(DateTime.Now.Year - 1, 4)); break; case "MAILASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 5, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 5, DateTime.DaysInMonth(DateTime.Now.Year - 1, 5)); break; case "JUNLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 6, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 6, DateTime.DaysInMonth(DateTime.Now.Year - 1, 6)); break; case "JULLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 7, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 7, DateTime.DaysInMonth(DateTime.Now.Year - 1, 7)); break; case "AUGLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 8, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 8, DateTime.DaysInMonth(DateTime.Now.Year - 1, 8)); break; case "SEPLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 9, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 9, DateTime.DaysInMonth(DateTime.Now.Year - 1, 9)); break; case "OKTLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 10, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 10, DateTime.DaysInMonth(DateTime.Now.Year - 1, 10)); break; case "NOVLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 11, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 11, DateTime.DaysInMonth(DateTime.Now.Year - 1, 11)); break; case "DECLASTYEAR": dateFilter.FromDate = new DateTime(DateTime.Now.Year - 1, 12, 1); dateFilter.ToDate = new DateTime(DateTime.Now.Year - 1, 12, DateTime.DaysInMonth(DateTime.Now.Year - 1, 12)); break; case "ALL": dateFilter.FromDate = new DateTime(1966, 8, 1); dateFilter.ToDate = DateTime.MaxValue; break; default: dateFilter.FromDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); dateFilter.ToDate = DateTime.Now; dateFilter.FilterName = "CURMONTH"; break; } return(dateFilter); }