Your search did not match any results.
Scheduler

Web API Service

Documentation
This example demonstrates the Scheduler widget loading data from a Web API service.
@(Html.DevExtreme().Scheduler() .ID("scheduler") .DataSource(d => d.Mvc().Controller("SchedulerData").Key("AppointmentId").LoadAction("Get")) .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; namespace DevExtreme.NETCore.Demos.Models { public class Appointment { public int AppointmentId { get; set; } public string Text { get; set; } public DateTime StartDate { get; set; } public DateTime EndDate { get; set; } public bool AllDay { get; set; } 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; } } } }