Hi all,
I am using DHTMLX scheduler in MVC to book the appointment. My problem is i need to set the leave dates for different user. I need to get the holiday dates from the database. When the calendar is loaded holiday dates should be viewed in different color. Plz help me . I will share my code. Its bit urgent.
public ActionResult CalendarView( int id, Appt app )
{
app = (from s
in db.tblUsers
where s.UserTypeId == 5 && s.UserID == id
select new Appt
{
FirstName = s.FirstName,
BusinessCategory = s.tblBusinessCategory.BusinessCategory,
BusinessName = s.tblBusinessCategory.BusinessName,
StartTime = s.WorkingHour.StartTime
//UserTypeID = 5,
//UserID = s.UserID,
//Id = 2
}).FirstOrDefault();
tblBusinessUserHoliday hl = new tblBusinessUserHoliday();
var scheduler = new DHXScheduler(this);
scheduler.Skin = DHXScheduler.Skins.Flat;
scheduler.Data.Loader.PreventCache();
scheduler.EnableDynamicLoading(SchedulerDataLoader.DynamicalLoadingMode.Week);
scheduler.LoadData = true;
scheduler.EnableDataprocessor = true;
scheduler.Config.show_loading = true;
scheduler.TimeSpans.Add(new DHXMarkTime()
{
StartDate = new DateTime(2015, 8, 06), //hl.HolidayDate ?? default(DateTime),
EndDate = new DateTime(2015, 8, 10),
Day = DayOfWeek.Friday,
CssClass = "green_section",
SpanType = DHXTimeSpan.Type.BlockEvents
});
return View(scheduler);
}