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());
        }
        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());
        }