Web API Service
Documentation
This example demonstrates the Scheduler widget communicating with a Web API service.
Thank you!
We appreciate your feedback.
We appreciate your feedback.
@(Html.DevExtreme().Scheduler()
.ID("scheduler")
.DataSource(d => d.Mvc()
.Controller("SchedulerData")
.Key("AppointmentId")
.LoadAction("Get")
.UpdateAction("Put")
.InsertAction("Post")
.DeleteAction("Delete")
)
.RemoteFiltering(true)
.Views(new SchedulerViewType[] {
SchedulerViewType.Day,
SchedulerViewType.WorkWeek,
SchedulerViewType.Month
})
.CurrentView(SchedulerViewType.Day)
.CurrentDate(new DateTime(2017, 5, 23))
.StartDayHour(9)
.EndDayHour(19)
.Height(600)
.TextExpr("Text")
.StartDateExpr("StartDate")
.EndDateExpr("EndDate")
.AllDayExpr("AllDay")
)
using DevExtreme.NETCore.Demos.Models.SampleData;
using DevExtreme.NETCore.Demos.ViewModels;
using Microsoft.AspNetCore.Mvc;
using System;
using System.Collections.Generic;
using System.Linq;
namespace DevExtreme.NETCore.Demos.Controllers {
public class SchedulerController : Controller {
public ActionResult WebAPIService() {
return View();
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using Microsoft.AspNetCore.Mvc;
using DevExtreme.NETCore.Demos.Models;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Caching.Memory;
using DevExtreme.AspNet.Mvc;
using DevExtreme.AspNet.Data;
using Newtonsoft.Json;
namespace DevExtreme.NETCore.Demos.Controllers.ApiControllers {
[Route("api/[controller]")]
public class SchedulerDataController : Controller {
InMemoryAppointmentsDataContext _data;
public SchedulerDataController(IHttpContextAccessor httpContextAccessor, IMemoryCache memoryCache) {
_data = new InMemoryAppointmentsDataContext(httpContextAccessor, memoryCache);
}
[HttpGet]
public object Get(DataSourceLoadOptions loadOptions) {
return DataSourceLoader.Load(_data.Appointments, loadOptions);
}
[HttpPost]
public IActionResult Post(string values) {
var newAppointment = new Appointment();
JsonConvert.PopulateObject(values, newAppointment);
if(!TryValidateModel(newAppointment))
return BadRequest(ModelState.GetFullErrorMessage());
_data.Appointments.Add(newAppointment);
_data.SaveChanges();
return Ok();
}
[HttpPut]
public IActionResult Put(int key, string values) {
var appointment = _data.Appointments.First(a => a.AppointmentId == key);
JsonConvert.PopulateObject(values, appointment);
if(!TryValidateModel(appointment))
return BadRequest(ModelState.GetFullErrorMessage());
_data.SaveChanges();
return Ok();
}
[HttpDelete]
public void Delete(int key) {
var appointment = _data.Appointments.First(a => a.AppointmentId == key);
_data.Appointments.Remove(appointment);
_data.SaveChanges();
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using Newtonsoft.Json;
namespace DevExtreme.NETCore.Demos.Models {
public class Appointment {
[JsonProperty(PropertyName = "AppointmentId")]
public int AppointmentId { get; set; }
[JsonProperty(PropertyName = "Text")]
public string Text { get; set; }
[JsonProperty(PropertyName = "Description")]
public string Description { get; set; }
[JsonProperty(PropertyName = "StartDate")]
public DateTime StartDate { get; set; }
[JsonProperty(PropertyName = "EndDate")]
public DateTime EndDate { get; set; }
[JsonProperty(PropertyName = "AllDay")]
public bool AllDay { get; set; }
[JsonProperty(PropertyName = "RecurrenceRule")]
public string RecurrenceRule { get; set; }
}
}
using System;
using System.Collections.Generic;
using System.Linq;
namespace DevExtreme.NETCore.Demos.Models.SampleData {
public partial class SampleData {
public static List<Appointment> Appointments {
get {
return new List<Appointment> {
new Appointment {
AppointmentId = 1,
Text = "Website Re-Design Plan",
StartDate = new DateTime(2017, 5, 22, 9, 30, 0),
EndDate = new DateTime(2017, 5, 22, 11, 30, 0)
},
new Appointment {
AppointmentId = 2,
Text = "Book Flights to San Fran for Sales Trip",
StartDate = new DateTime(2017, 5, 22, 12, 0, 0),
EndDate = new DateTime(2017, 5, 22, 13, 0, 0),
AllDay = true
},
new Appointment {
AppointmentId = 3,
Text = "Install New Router in Dev Room",
StartDate = new DateTime(2017, 5, 22, 14, 30, 0),
EndDate = new DateTime(2017, 5, 22, 15, 30, 0)
},
new Appointment {
AppointmentId = 4,
Text = "Approve Personal Computer Upgrade Plan",
StartDate = new DateTime(2017, 5, 23, 10, 0, 0),
EndDate = new DateTime(2017, 5, 23, 11, 0, 0)
},
new Appointment {
AppointmentId = 5,
Text = "Final Budget Review",
StartDate = new DateTime(2017, 5, 23, 12, 0, 0),
EndDate = new DateTime(2017, 5, 23, 13, 35, 0)
},
new Appointment {
AppointmentId = 6,
Text = "New Brochures",
StartDate = new DateTime(2017, 5, 23, 14, 30, 0),
EndDate = new DateTime(2017, 5, 23, 15, 45, 0)
},
new Appointment {
AppointmentId = 7,
Text = "Install New Database",
StartDate = new DateTime(2017, 5, 24, 9, 45, 0),
EndDate = new DateTime(2017, 5, 24, 11, 15, 0)
},
new Appointment {
AppointmentId = 8,
Text = "Approve New Online Marketing Strategy",
StartDate = new DateTime(2017, 5, 24, 12, 0, 0),
EndDate = new DateTime(2017, 5, 24, 14, 0, 0)
},
new Appointment {
AppointmentId = 9,
Text = "Upgrade Personal Computers",
StartDate = new DateTime(2017, 5, 24, 15, 15, 0),
EndDate = new DateTime(2017, 5, 24, 16, 30, 0)
},
new Appointment {
AppointmentId = 10,
Text = "Customer Workshop",
StartDate = new DateTime(2017, 5, 25, 11, 0, 0),
EndDate = new DateTime(2017, 5, 25, 12, 0, 0),
AllDay = true
},
new Appointment {
AppointmentId = 11,
Text = "Prepare 2015 Marketing Plan",
StartDate = new DateTime(2017, 5, 25, 11, 0, 0),
EndDate = new DateTime(2017, 5, 25, 13, 30, 0)
},
new Appointment {
AppointmentId = 12,
Text = "Brochure Design Review",
StartDate = new DateTime(2017, 5, 25, 14, 0, 0),
EndDate = new DateTime(2017, 5, 25, 15, 30, 0)
},
new Appointment {
AppointmentId = 13,
Text = "Create Icons for Website",
StartDate = new DateTime(2017, 5, 26, 10, 0, 0),
EndDate = new DateTime(2017, 5, 26, 11, 30, 0)
},
new Appointment {
AppointmentId = 14,
Text = "Upgrade Server Hardware",
StartDate = new DateTime(2017, 5, 26, 14, 30, 0),
EndDate = new DateTime(2017, 5, 26, 16, 0, 0)
},
new Appointment {
AppointmentId = 15,
Text = "Submit New Website Design",
StartDate = new DateTime(2017, 5, 26, 16, 30, 0),
EndDate = new DateTime(2017, 5, 26, 18, 0, 0)
},
new Appointment {
AppointmentId = 16,
Text = "Launch New Website",
StartDate = new DateTime(2017, 5, 26, 12, 20, 0),
EndDate = new DateTime(2017, 5, 26, 14, 0, 0)
}
};
}
}
}
}
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Caching.Memory;
using System;
using System.Collections.Generic;
using System.Linq;
namespace DevExtreme.NETCore.Demos.Models {
public class InMemoryAppointmentsDataContext {
IHttpContextAccessor _contextAccessor;
IMemoryCache _memoryCache;
public InMemoryAppointmentsDataContext(IHttpContextAccessor contextAccessor, IMemoryCache memoryCache) {
_contextAccessor = contextAccessor;
_memoryCache = memoryCache;
}
public ICollection<Appointment> Appointments {
get {
var session = _contextAccessor.HttpContext.Session;
var key = session.Id + "_Appointments";
if(_memoryCache.Get(key) == null) {
_memoryCache.Set<ICollection<Appointment>>(key, SampleData.SampleData.Appointments, new MemoryCacheEntryOptions {
SlidingExpiration = TimeSpan.FromMinutes(10)
});
session.SetInt32("dirty", 1);
}
return _memoryCache.Get<ICollection<Appointment>>(key);
}
}
public void SaveChanges() {
foreach(var appointment in Appointments.Where(a => a.AppointmentId == 0)) {
appointment.AppointmentId = Appointments.Max(a => a.AppointmentId) + 1;
}
}
}
}