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