public ContentResult Data()
        {//events for loading to scheduler
            
            List<Events> lstevents = new List<Events>();
            List<AgregEventsModel> lstagregevents = new List<AgregEventsModel>();
            Guid idcgp = SessionManager.GetUserSession().idUser;            
            using (UpsilabEntities context = new UpsilabEntities())
            {
                lstevents = context.Events.Include("CRMRendezVous").Where(e => e.idUser == idcgp).ToList();
                //lstevents = context.Events.ToList();
            }
            foreach (Events m in lstevents)
            {
                AgregEventsModel aem = new AgregEventsModel()
                {
                    id = m.id,
                    text = m.text,
                    start_date = m.start_date,
                    end_date = m.end_date,
                    nom = (m.CRMRendezVous != null && m.CRMRendezVous.Nom != null)? m.CRMRendezVous.Nom : "",
                    prenom = (m.CRMRendezVous != null && m.CRMRendezVous.Prenom != null)? m.CRMRendezVous.Prenom : ""
                };
                lstagregevents.Add(aem);
            }
            var data = new SchedulerAjaxData(lstagregevents);
            data.DateFormat = "%d/%m/%y %H:%i";

            return Content(data.Render());
        }
 /// <summary>
 /// Rendering data with custom function
 /// </summary>
 /// <returns></returns>
 public ContentResult CustomData()
 {
     var data = new SchedulerAjaxData((new DHXSchedulerDataContext()).Events);
     /*
      *  return data;
      *  is equal to
      *  return Content(data.Render());
      *  SchedulerAjaxData.Render can also take Action<StringBuilder, object> as a parameter
      */
     return Content( data.Render(eventRenderer) );
 }
        /// <summary>
        /// Rendering data with custom function
        /// </summary>
        /// <returns></returns>
        public ContentResult CustomData()
        {
            var data = new SchedulerAjaxData((new DHXSchedulerModelsDataContext()).Events);

            /*
             *  return data;
             *  is equal to
             *  return Content(data.Render());
             *  SchedulerAjaxData.Render can also take Action<StringBuilder, object> as a parameter
             */
            return(Content(data.Render(eventRenderer)));
        }
        public ContentResult Data()
        {//events for loading to scheduler
            
            List<Events> lstevents = new List<Events>();
            List<AgregEventsModel> lstagregevents = new List<AgregEventsModel>();
            Guid idcgp = SessionManager.GetUserSession().idUser;
            Guid idClient = Guid.Empty;
            SessionManager.Get<Guid>(AgregAgendaClientIdSessionKey, out idClient);

            using (UpsilabEntities context = new UpsilabEntities())
            {
                lstevents = context.Events.Where(e => e.idUser == idcgp && e.idCustomer == idClient).ToList();
                //lstevents = context.Events.ToList();
            }
            foreach (Events m in lstevents)
            {
                AgregEventsModel aem = new AgregEventsModel()
                {
                    id = m.id,
                    text = m.text,
                    start_date = m.start_date,
                    end_date = m.end_date
                };
                lstagregevents.Add(aem);
            }

            var data = new SchedulerAjaxData(lstagregevents);
            data.DateFormat = "%d/%m/%y %H:%i";
            return Content(data.Render());
        }