I have been trying to get a scheduler to show simple events, but Im doing some wrong (probably something simple I'm not seeing.
I'm simply trying to return a list into the schedular based on the demo TaskViewModel
What am I doing wrong here.
Thanbks in advance
@(Html.Kendo().Scheduler<ShitTruckLibrary.Models.TaskViewModel>()
.Name("scheduler")
.Date(new DateTime(2021, 05, 10))
.StartTime(new DateTime(2021, 5, 08, 00, 00, 00))
.Height(600)
.Views(views =>
{
views.DayView();
views.WorkWeekView(workWeekView => workWeekView.Selected(true));
views.WeekView();
views.MonthView();
views.AgendaView();
views.TimelineView();
})
.Timezone("Etc/UTC")
.Resources(resource =>
{
resource.Add(m => m.OwnerID)
.Title("Owner")
.DataTextField("Text")
.DataValueField("Value")
.DataColorField("Color")
.BindTo(new[] {
new { Text = "STC", Value = 1, Color = "#f8a398" } ,
new { Text = "GTC", Value = 2, Color = "#51a0ed" }
});
})
.DataSource(d => d
.Model(m => {
m.Id(f => f.TaskID);
m.Field(f => f.Title).DefaultValue("No title");
m.Field(f => f.OwnerID).DefaultValue(1);
m.RecurrenceId(f => f.RecurrenceID);
})
.Read("Basic_Usage_Read", "WorkJobs")
.Filter(filters =>
{
filters.Add(model => model.OwnerID).IsEqualTo(1).Or().IsEqualTo(2);
})
)
)
public static IList<TaskViewModel> GetAllJobs()
{
List<ContactJob> c = new List<ContactJob>();
List<TaskViewModel> caLL = new List<TaskViewModel>();
DataTable dt = new DataTable();
dt = SqlStore.CreateDataSet($@"SELECT cj.*,ForeName, SurName, CompanyName,Address1,Address2 FROM [dbo].[ContactJob] cj join [dbo].[Contacts] c on cj.contactid = c.id order by JobDate desc").Tables[0];
c = DataHelper.ConvertDataTable<ContactJob>(dt);
foreach (ContactJob cc in c)
{
TaskViewModel vv = new TaskViewModel();
vv.Start = DateTime.SpecifyKind(new DateTime(cc.JobDate.Year, cc.JobDate.Month, cc.JobDate.Day, 09, 00, 00),DateTimeKind.Local);
vv.End = DateTime.SpecifyKind(new DateTime(cc.JobDate.Year, cc.JobDate.Month, cc.JobDate.Day, 10, 00, 00), DateTimeKind.Local);
vv.Title = $"{cc.CompanyName} {cc.ForeName} {cc.SurName}".Trim();
vv.Description = $"{cc.Address1} {cc.Address1}";
vv.IsAllDay = true;
vv.OwnerID = (cc.Type == "STC" ? 1 : 2);
caLL.Add(vv);
}
return caLL;
}
public virtual JsonResult Basic_Usage_Read([DataSourceRequest] DataSourceRequest request)
{
return Json(Job.GetAllJobs().ToDataSourceResult(request));
}
public static IList<TaskViewModel> GetAllJobs()
{
List<TaskViewModel> caLL = new List<TaskViewModel>();
DataTable dt = SqlStore.CreateDataSet($@"SELECT cj.*,ForeName, SurName, CompanyName,Address1,Address2 FROM [dbo].[ContactJob] cj join [dbo].[Contacts] c on cj.contactid = c.id order by JobDate desc").Tables[0];
List<ContactJob> c = DataHelper.ConvertDataTable<ContactJob>(dt);
foreach (ContactJob cc in c)
{
TaskViewModel vv = new TaskViewModel();
vv.Start = DateTime.SpecifyKind(new DateTime(cc.JobDate.Year, cc.JobDate.Month, cc.JobDate.Day, 09, 00, 00),DateTimeKind.Local);
vv.End = DateTime.SpecifyKind(new DateTime(cc.JobDate.Year, cc.JobDate.Month, cc.JobDate.Day, 10, 00, 00), DateTimeKind.Local);
vv.Title = $"{cc.CompanyName} {cc.ForeName} {cc.SurName}".Trim();
vv.Description = $"{cc.Address1} {cc.Address1}";
vv.IsAllDay = true;
vv.OwnerID = (cc.Type == "STC" ? 1 : 2);
caLL.Add(vv);
}
return caLL;
}