Hi. I need some guidance with the Scheduler. Im basically retrieving a a list of records from the DB using the EF. I am currently binding this to the scheduler and it works like a charm. I am also populating a grid view right under my scheduler with all the appointments irrelevant of what current month the scheduler is on.
Now, i have a new requirement whereby i only show the appointments in the grid and scheduler of the selected months. So i need to filter my results (list) when the user selects the left or right arrow to cycle through the months. I will then need to identify the start date and end date of that month and filter with a where clause on the list i have in real time.
What event must i use to be initiated once the user selects one of this arrows which will also provide me the next/previous months and their days?
Is this possible please? I have been searching many examples, though i keep finding examples of specific people that fit to their needs. I do feel that im close but cant get around it.
I am currently binding my scheduler this way and listing everything.. So i just need to do the same thing but filtering using a where clause in the entity framework by getting the start date and end date of the month the user has selected.
Update:
Im going to see if i will manage using e.Command.ToString(); I will then know if i can add months or minus.. will see if i sort out what i need this way.
Now, i have a new requirement whereby i only show the appointments in the grid and scheduler of the selected months. So i need to filter my results (list) when the user selects the left or right arrow to cycle through the months. I will then need to identify the start date and end date of that month and filter with a where clause on the list i have in real time.
What event must i use to be initiated once the user selects one of this arrows which will also provide me the next/previous months and their days?
Is this possible please? I have been searching many examples, though i keep finding examples of specific people that fit to their needs. I do feel that im close but cant get around it.
I am currently binding my scheduler this way and listing everything.. So i just need to do the same thing but filtering using a where clause in the entity framework by getting the start date and end date of the month the user has selected.
private void BindScheduler() { #region Scheduler List<AppointmentInfo> appList = new List<AppointmentInfo>(); DateTime startDate, endDate; // Coming from the db, just removed the code below in the for loop.
string name; for (int schedCount = 0; schedCount <= _groupScheduleList.Count - 1; schedCount++) { Appointment appSched = new Appointment(); appSched.ID = schedCount; appSched.Start = startDate; appSched.End = endDate; appSched.Subject = name; AppointmentInfo appI = new AppointmentInfo(appSched); appList.Add(appI); } timeSlotScheduler.DataSource = appList; timeSlotScheduler.DataBind(); #endregion }
Update:
Im going to see if i will manage using e.Command.ToString(); I will then know if i can add months or minus.. will see if i sort out what i need this way.