Iam having a list which contains data like a startdate , end date, name, location etc..
Now i want to write a condition like i want to get data if, the datetime.Today is between event startdate and end date then it should get the data to Ongoing events list for that true condition
also if event_startdate is lessthan datetime.Today then it should get data to pastevents list.
also id event start date is greater than datetime.Today then it should get data to Upcommingevents list.
I wrote a condition for Ongoingevents like this , it is not getting the results correctly,
indexlist = saveList.Where(i => Convert.ToDateTime(i.event_startdate) <= DateTime.Today).Union(indexlist.Where(i => Convert.ToDateTime(i.event_endDate) >= DateTime.Today)).ToList();
For Upcomming Events
indexlist = saveList.Where(i => Convert.ToDateTime(i.event_startdate) > DateTime.Today).ToList();
For Past events
indexlist = saveList.Where(i => Convert.ToDateTime(i.event_startdate) < DateTime.Today).Union(indexlist.Where(i => Convert.ToDateTime(i.event_endDate) < DateTime.Today)).ToList();
How to correct the statements and get the correct results
public class Event_Detail_Content
{
public string event_name { get; set; }
public string event_location { get; set; }
public string event_startdate { get; set; }
public string event_endDate { get; set; }
public int count { get; set; }
}
public sealed partial class eventspage:page
{
List<Event_Detail_Content> indexlist = new List<Event_Detail_Content>();
List<Event_Detail_Content> saveList = new List<Event_Detail_Content>();
}
IN the eventspage class all athe above statements are written.
Please help me.
What I have tried:
indexlist = saveList.Where(i => Convert.ToDateTime(i.event_startdate) <= DateTime.Today).Union(indexlist.Where(i => Convert.ToDateTime(i.event_endDate) >= DateTime.Today)).ToList();
For Upcomming Events
indexlist = saveList.Where(i => Convert.ToDateTime(i.event_startdate) > DateTime.Today).ToList();
For Past events
indexlist = saveList.Where(i => Convert.ToDateTime(i.event_startdate) < DateTime.Today).Union(indexlist.Where(i => Convert.ToDateTime(i.event_endDate) < DateTime.Today)).ToList();