如何从当天开始即将到来的生日 [英] How do I get upcoming birthdays starting from current day

问题描述

您好b $ b

我需要快速修改我的查询以获得即将到来的生日。目前我得到了它们，但显示当月的生日。



我尝试过：

Hi
I need a quick modification of my query to get upcoming birthdays. Currently I get them but shows passed birthdays of current month.

What I have tried:

var day = DateTime.Today;
            // var currentDay = DateTime.Now.Day;
            var month = day.AddMonths(3);
            var note = (from cn in _peopleRepository.GetAll()
                        where cn.PeopleTypeId == 3
                        && cn.BirthDate.Value.Month >= day.Month && cn.BirthDate.Value.Month <= month.Month
                        orderby cn.BirthDate.Value.Month, cn.BirthDate.Value.Day
                        select new GetLandlordBirthdayOutput
                        {
                            Id = cn.Id,
                            FirstName = cn.FirstName,
                            LastSurname = cn.LastName,
                            Province = cn.Province,
                            City = cn.City,
                            Suburb = cn.Suburb,
                            Email = cn.EmailAddress,
                            Phone = cn.CellNumber,
                            Birthday = cn.BirthDate
                        }).ToList();

推荐答案

DateTime dateNext = new DateTime(day.Year,day.Month,day.Day).AddDays(1);
var upcoming = note.where(r => r.BirthDate >= dateNext);

这篇关于如何从当天开始即将到来的生日的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！