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.