Bdtjtk

I am using asp.net mvc to create an app to keep track of employees holidays. I have two tables created in sql server. One is a list of employees and their information and the other is a holiday request form.

I have decided to use DHTLMX scheduler to show when employees take holidays.

So far I've set up the scheduler using a timeline view and created some mock data as follows

 using System;

 using System.Collections.Generic;

 using System.Linq;

 using System.Web;

 using System.Web.Mvc;





 using DHTMLX.Scheduler;

 using DHTMLX.Common;

 using DHTMLX.Scheduler.Data;

 using DHTMLX.Scheduler.Controls;



 using LotusWorksHolidayTracker.Models;

 namespace LotusWorksHolidayTracker.Controllers

{

public class CalendarController : Controller

{

    public ActionResult Index()

    {

        var sched = new DHXScheduler(this);

        sched.Config.readonly_form = true;

        sched.Views.Clear();

        sched.InitialDate = new DateTime(2019, 1, 1);





        var unit = new UnitsView("timeline", "key");

        sched.InitialView = unit.Name;



        sched.LoadData = true;

        var dbcontext = new LotusworksHTEntities();





        var timeline = new TimelineView("timeline", "Employee Name"); // initializes the view

        timeline.FolderEventsAvailable = false;

        timeline.RenderMode = TimelineView.RenderModes.Tree;







       var section = timeline.AddOption(new TimelineUnit("1", "Full Day", true));



       section.AddOption(new TimelineUnit("2", "Conor Bloggs")); // defines the items of the folder

       section.AddOption(new TimelineUnit("3", "Joe Bloggs"));



       var section2 = timeline.AddOption(new TimelineUnit("2", "Shift C", true));



       section2.AddOption(new TimelineUnit("5", "Tom Bloggs"));

       section2.AddOption(new TimelineUnit("6", "Tim Bloggs"));



        timeline.FitEvents = false;

        timeline.SectionAutoheight = false;

        timeline.Dy = 25; 

        timeline.X_Unit = TimelineView.XScaleUnits.Day;

        timeline.X_Date = "%j";

        timeline.X_Step = 1;

        timeline.X_Size = 31;

        sched.Views.Add(timeline);











        sched.TimeSpans.Add(new DHXMarkTime() {

        Day = DayOfWeek.Saturday,

        CssClass = "green_section", 

        SpanType = DHXMarkTime.Type.Default

        });



        sched.TimeSpans.Add(new DHXMarkTime()

        {

            Day = DayOfWeek.Sunday,

            CssClass = "green_section",

            SpanType = DHXMarkTime.Type.Default

        });







return View(sched);

This has given me the correct format I'm looking for but I need to use data from my database and not mock data, how do I connect my database to the scheduler with Employee Names and down the left side and then the holidays they take on the scheduler itself.