public ContentResult Data() { var entityContext = new EntityContext(); var cEvent = new List <CalendarEvent>(); try { var dt = DateTime.Now.AddMonths(-1); var data = entityContext.calendarInfo.Join(entityContext.reportInfo, ci => ci.ReferenceTxnID, ri => ri.ReferenceTxnID, (ci, ri) => new { cinfo = ci, rinfo = ri }).Where(t => t.cinfo.Type == "TempleEvent" && t.cinfo.StartDate.Month >= dt.Date.Month).OrderByDescending(t => t.cinfo.StartDate).ToList(); data.ForEach(q => { cEvent.Add(new CalendarEvent() { id = q.cinfo.Id, text = q.cinfo.Name + " " + q.cinfo.Text + " " + q.rinfo.FromEmailAddress + " " + q.rinfo.PhoneNo + " " + q.cinfo.Address, start_date = q.cinfo.StartDate, end_date = q.cinfo.EndDate }); }); } catch (Exception ex) { throw; } var data1 = new SchedulerAjaxData(cEvent); return((ContentResult)data1); }
public ContentResult Data() { var data = new SchedulerAjaxData(new DataClasses1DataContext().Events); //Using the Events table from our database return((ContentResult)data); }
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() { var data = new SchedulerAjaxData( new List<CalendarEvent>{ new CalendarEvent{ id = 1, text = "Sample Event", start_date = new DateTime(2012, 09, 03, 6, 00, 00), end_date = new DateTime(2012, 09, 03, 8, 00, 00) }, new CalendarEvent{ id = 2, text = "New Event", start_date = new DateTime(2012, 09, 05, 9, 00, 00), end_date = new DateTime(2012, 09, 05, 12, 00, 00) }, new CalendarEvent{ id = 3, text = "Multiday Event", start_date = new DateTime(2012, 09, 03, 10, 00, 00), end_date = new DateTime(2012, 09, 10, 12, 00, 00) } } ); return (ContentResult)data; }
public ContentResult Data() { var data = new SchedulerAjaxData(new CalendarDataContext().Events); return (ContentResult)data; // return new SchedulerAjaxData(new SampleDataContext().Events); // return (ContentResult)data; }
public ContentResult Data() { var data = new SchedulerAjaxData( new SchedulerContext().CalendarEvents.Select(e => new { e.id, e.text, e.start_date, e.end_date }).Where(t => t.id.Equals(Session["Subject_id"]))); return((ContentResult)data); }
public ActionResult Data() { //if the user is not authorized or not in the Manager Role, returns the empty dataset if (!RoleIs("Manager")) { return(new SchedulerAjaxData()); } var tasks = Repository.GetAll <Task>() .Join(Repository.GetAll <Status>(), task => task.status_id, status => status.id, (task, status) => new { Task = task, Status = status }) .Select(o => new { o.Task.id, o.Task.owner_id, o.Task.details, o.Task.end_date, o.Task.start_date, o.Task.text, o.Task.status_id }); var resp = new SchedulerAjaxData(tasks); return(resp); }
public ContentResult Data() { var data = new SchedulerAjaxData((new DHXSchedulerDataContext()).Events); return(data); }
public ContentResult Data() { var eventsList = service.GetWorkerEvents(10); var data = new SchedulerAjaxData(eventsList); return((ContentResult)data); }
public ContentResult Data() { var data = new SchedulerAjaxData((new DHXSchedulerDataContext()).Events); // data.DateFormat = "%d/%m/%Y %H:%i"; return(data); }
/// <summary> /// get database data accrding to the position /// </summary> /// <returns>details to the calander view according to the position of the user</returns> public ContentResult Data() { //if the user is a student if ((string)Session["Position"] == "student") { var supervisor = GetStudentData();//calling this method to get the supervisor model var supervisorData = from m in db.Event where m.LecturerId == supervisor.LecturerId select m; //get data from the table according to the supervisor id var data = new SchedulerAjaxData(supervisorData); return((ContentResult)data); } else { //if the user is a lecturer string lecturerId = ((string)Session["id"]); //get the data from the table according to the session id var appoinmentData = from m in db.Event where m.LecturerId == lecturerId select m; var data = new SchedulerAjaxData(appoinmentData); return((ContentResult)data); } }
public ContentResult Data() { var data = new SchedulerAjaxData( new List <CalendarEvent> { new CalendarEvent { id = 1, text = "Sample Event", start_date = new DateTime(2012, 09, 03, 6, 00, 00), end_date = new DateTime(2012, 09, 03, 8, 00, 00) }, new CalendarEvent { id = 2, text = "New Event", start_date = new DateTime(2012, 09, 05, 9, 00, 00), end_date = new DateTime(2012, 09, 05, 12, 00, 00) }, new CalendarEvent { id = 3, text = "Multiday Event", start_date = new DateTime(2012, 09, 03, 10, 00, 00), end_date = new DateTime(2012, 09, 10, 12, 00, 00) } } ); return((ContentResult)data); }
public ContentResult Data() { string u = User.Identity.Name; var data = new SchedulerAjaxData(new BookingBusiness().displayT(u)); return((ContentResult)data); }
public ContentResult Data() { var entityContext = new EntityContext(); var cEvent = new List <CalendarEvent>(); try { var data = entityContext.calendarInfo.Where(t => t.Type == "Room").ToList(); data.ForEach(q => { cEvent.Add(new CalendarEvent() { id = q.Id, text = q.Text, start_date = q.StartDate, end_date = q.EndDate }); }); } catch (Exception ex) { throw; } var data1 = new SchedulerAjaxData(cEvent); return((ContentResult)data1); }
public ContentResult Data() { var data = new SchedulerAjaxData(new SampleDataContext().Events); return((ContentResult)data); }
//Reminder calendar display public ContentResult Data() { int livedoc = Convert.ToInt16(Session["DoctorUserName"]); var data = new SchedulerAjaxData(new DocreminderDataContext().Docreminders.Where(ev => ev.USERNAME == livedoc)); return(data); }
public ContentResult Data() { //var data = new SchedulerAjaxData(new DataClasses1DataContext().Events); var data = new SchedulerAjaxData( new CRMDBContext().Shift.Select(e => new { id = e.ID, start_date = e.Start_date, end_date = e.End_date, text = e.Description }) ); return((ContentResult)data); }
public ContentResult Mixed() { // var helper = new // var helper = new ICalHelper(); // var events = helper.GetFromFeed("https://www.google.com/calendar/ical/[email protected]/public/basic.ics"); var data = new SchedulerAjaxData(); data.FromICal("https://www.google.com/calendar/ical/[email protected]/public/basic.ics"); data.Add(new DHXSchedulerModelsDataContext().Events); return data; }
public void ProcessRequest(HttpContext context) { SchedulerAjaxData data; var dc = new SchedulerDataContext(); data = new SchedulerAjaxData(dc.Events); context.Response.ContentType = "text/json"; context.Response.Write(data.ToString()); }
/// <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) ); }
public ContentResult Data(DateTime from, DateTime to) { var sections = _GetSectionsByDate(from, to); var events = _GetEventsByDate(from, to); var data = new SchedulerAjaxData(events); data.ServerList.Add("sections", sections); return(data); }
/// <summary> /// The data. /// </summary> /// <param name="userId"> /// The user Id. /// </param> /// <param name="officeId"> /// The office Id. /// </param> /// <param name="from"> /// The from. /// </param> /// <param name="to"> /// The to. /// </param> /// <returns> /// The <see cref="ContentResult"/>. /// </returns> public ContentResult Data(int userId, int officeId, string from, string to) { var employeeId = this.appointmentManager.GetEmployeeIdByUserId(userId).GetValueOrDefault(); var startDate = DateTime.Parse(from); var endDate = DateTime.Parse(to); var authorizationTicketHelper = new AuthorizationTicketHelper(); var companyId = authorizationTicketHelper.GetUserInfo().CompanyId; var items = this.appointmentManager.GetAllAppointments(officeId, (int)employeeId, startDate, endDate, companyId); var data = new SchedulerAjaxData(items); return(this.Content(data, "text/json")); }
public ContentResult Mixed() { // var helper = new // var helper = new ICalHelper(); // var events = helper.GetFromFeed("https://www.google.com/calendar/ical/[email protected]/public/basic.ics"); var data = new SchedulerAjaxData(); data.FromICal("https://www.google.com/calendar/ical/[email protected]/public/basic.ics"); data.Add(new DHXSchedulerDataContext().Events); return(data); }
/// <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 MapEvents() { var today = DateTime.Today; var data = new SchedulerAjaxData(new List<object>() { new {id=2, text="Kurtzenhouse", start_date=today.AddDays(1).AddHours(13), end_date=today.AddDays(1).AddHours(16), lat=48.7396839, lng=7.813368099999934, event_location="D37, 67240 Kurtzenhouse, France"}, new {id=3, text="Forêt Domaniale", start_date=today.AddDays(2).AddHours(10), end_date=today.AddDays(2).AddHours(12), lat=48.767333, lng=5.793258000000037, event_location="Forêt Domaniale de la Reine, Véry, 54200 Royaumeix, France"}, new {id=4, text="Windstein", start_date=today.AddDays(3).AddHours(7), end_date=today.AddDays(3).AddHours(8), lat=49.0003477, lng=7.687306499999977, event_location="1 Rue du Nagelsthal, 67110 Windstein, France"} }); return data; }
public ContentResult Data(DateTime from, DateTime to) { var rnd = new Random(); var blocked = _GetTimespansByDate(from, to, rnd); var events = _GetEventsByDate(from, to, rnd); var data = new SchedulerAjaxData(events); data.ServerList.Add("blocked_time", blocked); return(data); }
public void ProcessRequest(HttpContext context) { SchedulerAjaxData data; var dc = new SchedulerDataContext(); if (context.Request.QueryString["recurring"] == null) data = new SchedulerAjaxData(dc.Events); else data = new SchedulerAjaxData(dc.Recurrings); context.Response.ContentType = "text/json"; context.Response.Write(data.ToString()); }
public ContentResult MapEvents() { var today = DateTime.Today; var data = new SchedulerAjaxData(new List <object>() { new { id = 2, text = "Kurtzenhouse", start_date = today.AddDays(1).AddHours(13), end_date = today.AddDays(1).AddHours(16), lat = 48.7396839, lng = 7.813368099999934, event_location = "D37, 67240 Kurtzenhouse, France" }, new { id = 3, text = "Forêt Domaniale", start_date = today.AddDays(2).AddHours(10), end_date = today.AddDays(2).AddHours(12), lat = 48.767333, lng = 5.793258000000037, event_location = "Forêt Domaniale de la Reine, Véry, 54200 Royaumeix, France" }, new { id = 4, text = "Windstein", start_date = today.AddDays(3).AddHours(7), end_date = today.AddDays(3).AddHours(8), lat = 49.0003477, lng = 7.687306499999977, event_location = "1 Rue du Nagelsthal, 67110 Windstein, France" } }); return(data); }
public ContentResult Data() { var data = new SchedulerAjaxData(); List <object> list = new List <object>(); ApplicationDbContext db = new ApplicationDbContext(); ApplicationUser user = db.Users.Find(User.Identity.GetUserId()); var records = new ApplicationDbContext().Records.Where(d => d.TypeOfService.Doctor.Id == user.Id); foreach (Record record in records) { list.Add(new { id = record.Id, text = "Вільне місце", start_date = record.Date, end_date = record.Date.AddHours(2) }); } data.Add(list); return(new SchedulerAjaxData(list)); }
public ActionResult Tasks() { #region check rights if (!RoleIs("Employee")) { return(new SchedulerAjaxData());//returns the empty dataset } #endregion var result = Repository.GetAll <Task>() .Join(Repository.GetAll <Status>(), task => task.status_id, status => status.id, (task, status) => new { Task = task, Status = status }) .Select(o => new { o.Status.color, o.Task.id, o.Task.owner_id, o.Task.details, o.Task.end_date, o.Task.start_date, o.Task.text, o.Task.status_id }); var tasks = new List <object>(); foreach (var r in result.ToList()) { if (r.owner_id == Guid.Parse(AppUserManagerProvider.UserId)) { tasks.Add(new { r.color, r.id, r.owner_id, r.details, r.end_date, r.start_date, r.text, r.status_id }); } } var resp = new SchedulerAjaxData(tasks); return(resp); }
public void ProcessRequest(HttpContext context) { SchedulerAjaxData data; var dc = new SchedulerDataContext(); if (context.Request.QueryString["recurring"] == null) { data = new SchedulerAjaxData(dc.Events); } else { data = new SchedulerAjaxData(dc.Recurrings); } context.Response.ContentType = "text/json"; context.Response.Write(data.ToString());; }
public ContentResult Data() { var dc = new DHXSchedulerDataContext(); IEnumerable<Event> dataset; if (this.Request.QueryString["rooms"] == null) dataset = dc.Events; else{ var current_room = int.Parse(this.Request.QueryString["rooms"]); dataset = from ev in dc.Events where ev.room_id == current_room select ev; } var data = new SchedulerAjaxData(dataset); return (data); }
public ContentResult Data() { var userId = Int32.Parse(((ClaimsIdentity)this.User.Identity).FindFirstValue("Id")); var allBookings = this.User.IsInRole("Admin") ? _bookingServices.GetBookingList().ToList() : _bookingServices.GetBookingList().Where(book => book.User.Id == userId).ToList(); var date = new SchedulerAjaxData(allBookings .Select(e => new { id = e.Id, text = e.Court.Name, start_date = e.StartDate.DateTime, end_date = e.EndDate.DateTime, court = e.Court.Id })); return(date); }
//public ContentResult Data() //{ // var data = new SchedulerAjaxData(Repository.ColoredEvents); // return (data); //} public ContentResult Data() { IEnumerable<ColoredEvent> dataset; dataset = Repository.ColoredEvents.Where(ev => ev.room_id == 3); //if (Request.QueryString["rooms"] == null) // dataset = Repository.ColoredEvents; //else //{ // var currentRoom = int.Parse(Request.QueryString["rooms"]); // dataset = Repository.ColoredEvents.Where(ev => ev.room_id == currentRoom); // //from ev in dc.Events where ev.room_id == current_room select ev; //} var data = new SchedulerAjaxData(dataset); return (data); }
public ContentResult Mixed() { // var helper = new var helper = new ICalHelper(); var events = helper.GetFromFeed("https://www.google.com/calendar/ical/[email protected]/public/basic.ics"); var data = new SchedulerAjaxData(Repository.Events); //data.FromUrl("https://www.google.com/calendar/ical/[email protected]/public/basic.ics"); data.Add(events.Select(o => new Event() { end_date = o.end_date, id = Convert.ToInt32(o.id), start_date = o.start_date, room_id = null, text = o.text, user_id = null })); return(data); }
public ContentResult Data() { IEnumerable <Event> dataset; if (this.Request.QueryString["rooms"] == null) { dataset = Repository.Events.ToList(); } else { var currentRoom = int.Parse(this.Request.QueryString["rooms"]); dataset = Repository.Events.Where(ev => ev.room_id == currentRoom).ToList(); //from ev in dc.Events where ev.room_id == current_room select ev; } var data = new SchedulerAjaxData(dataset); return(data); }
public ContentResult Data() { var dc = new DHXSchedulerModelsDataContext(); IEnumerable <Event> dataset; if (this.Request.QueryString["rooms"] == null) { dataset = dc.Events; } else { var current_room = int.Parse(this.Request.QueryString["rooms"]); dataset = from ev in dc.Events where ev.room_id == current_room select ev; } var data = new SchedulerAjaxData(dataset); return(data); }
public ContentResult Data() { var data = new List<CalendarEvent>(); var count = 0; foreach (var item in db.Appointments.Include(p => p.sessionDetail)) { DateTime start = Convert.ToDateTime(item.startDate); DateTime stTime = Convert.ToDateTime(item.sessionDetail.startTime); DateTime end = Convert.ToDateTime(item.endDate); DateTime enTime = Convert.ToDateTime(item.sessionDetail.EndTime); var Cal = new CalendarEvent() { id = count++, text = "Meeting Schedule", start_date = new DateTime(start.Year, start.Month,start.Day, stTime.Hour,stTime.Month,stTime.Second), end_date = new DateTime(end.Year, end.Month, end.Day, enTime.Hour, enTime.Month, enTime.Second) }; data.Add(Cal); } var returnData = new SchedulerAjaxData(data); return (ContentResult)returnData; }
public ContentResult Data() { var data = new SchedulerAjaxData(new DHXSchedulerModelsDataContext().Events); return data; }
public ContentResult Data() { var data = new SchedulerAjaxData((new CustomFieldsDataContext().Grids)); return data; }
public ContentResult Data() { var data = new SchedulerAjaxData(db.Calendar.ToList()); return (ContentResult)data; }
public ContentResult Data() { int PacId = Pacjent.IdPacjenta; PrzychodniaBDEntities7 dc = new PrzychodniaBDEntities7(); List<object> items = new List<object>(); if (LekId == 0) { var items_red = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.Pacjent.IdPacjenta != PacId && rr.DataRozp >= DateTime.Now). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Termin zajety", start_date = t.DataRozp, end_date = t.DataZak, color = "red", type = "dhx_time_block" }); var items_blue = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.Pacjent.IdPacjenta == PacId && rr.DataRozp >= DateTime.Now && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() == 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Oczekiwanie na akceptacje", start_date = t.DataRozp, end_date = t.DataZak, color = "blue", type = "dhx_time_block" }); var items_yellow = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.Pacjent.IdPacjenta == PacId && rr.DataRozp >= DateTime.Now && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() > 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Wizyta zaakceptowana. Zapraszamy!", start_date = t.DataRozp, end_date = t.DataZak, color = "yellow", type = "dhx_time_block" }); var items_green = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("N") && rr.DataRozp >= DateTime.Now). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Termin wolny", start_date = t.DataRozp, end_date = t.DataZak, color = "green", type = "dhx_time_block" }); items.AddRange(items_green); items.AddRange(items_blue); items.AddRange(items_red); items.AddRange(items_yellow); } else { //var items = dc.Rejestracja.Select(t => new { id = t.IdRejestracji, text = t.IdLekarza, start_date = t.DataRozp, end_date = t.DataZak }); var items_red = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdLekarza == LekId && rr.Pacjent.IdPacjenta != PacId && rr.DataRozp >= DateTime.Now). Select(t => new { id = t.IdRejestracji, text = "Termin zajety", start_date = t.DataRozp, end_date = t.DataZak, color = "red", type = "dhx_time_block" }); var items_blue = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdLekarza == LekId && rr.Pacjent.IdPacjenta == PacId && rr.DataRozp >= DateTime.Now && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() == 0). Select(t => new { id = t.IdRejestracji, text = t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Oczekiwanie na akceptacje", start_date = t.DataRozp, end_date = t.DataZak, color = "blue", type = "dhx_time_block" }); var items_yellow = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdLekarza == LekId && rr.Pacjent.IdPacjenta == PacId && rr.DataRozp >= DateTime.Now && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() > 0). Select(t => new { id = t.IdRejestracji, text = t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Wizyta zaakceptowana. Zapraszamy!", start_date = t.DataRozp, end_date = t.DataZak, color = "yellow", type = "dhx_time_block" }); var items_green = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("N") && rr.IdLekarza == LekId && rr.DataRozp >= DateTime.Now). Select(t => new { id = t.IdRejestracji, text = "Termin wolny", start_date = t.DataRozp, end_date = t.DataZak, color = "green", type = "dhx_time_block" }); items.AddRange(items_green); items.AddRange(items_blue); items.AddRange(items_red); items.AddRange(items_red); } var data = new SchedulerAjaxData(items); return (ContentResult)data; }
public ContentResult Data() { PrzychodniaBDEntities7 dc = new PrzychodniaBDEntities7(); List<object> items = new List<object>(); if (LekId == 0 && PacId == 0) { var items_blue = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() == 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Pacjent: " + t.Pacjent.Imie + " " + t.Pacjent.Nazwisko + "\n" + "Pesel: " + t.Pacjent.Pesel + "\n" + "Oczekiwanie na akceptacje", start_date = t.DataRozp, end_date = t.DataZak, color = "blue", type = "dhx_time_block" }); var items_yellow = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() > 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Pacjent: " + t.Pacjent.Imie + " " + t.Pacjent.Nazwisko + "\n" + "Pesel: " + t.Pacjent.Pesel + "\n" + "Wizyta zaakceptowana. Zapraszamy!", start_date = t.DataRozp, end_date = t.DataZak, color = "yellow", type = "dhx_time_block" }); var items_green = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("N")). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Termin wolny", start_date = t.DataRozp, end_date = t.DataZak, color = "green", type = "dhx_time_block" }); items.AddRange(items_green); items.AddRange(items_blue); items.AddRange(items_yellow); } else if(PacId != 0 && LekId == 0) { var items_red = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdPacjenta != PacId && dc.Wizyta.Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() >= 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Pacjent: " + t.Pacjent.Imie + " " + t.Pacjent.Nazwisko + "\n" + "Pesel: " + t.Pacjent.Pesel + "\n" + "Termin zajety", start_date = t.DataRozp, end_date = t.DataZak, color = "red", type = "dhx_time_block" }); var items_blue = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdPacjenta == PacId && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() == 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Pacjent: " + t.Pacjent.Imie + " " + t.Pacjent.Nazwisko + "\n" + "Pesel: " + t.Pacjent.Pesel + "\n" + "Oczekiwanie na akceptacje", start_date = t.DataRozp, end_date = t.DataZak, color = "blue", type = "dhx_time_block" }); var items_yellow = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdPacjenta == PacId && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() > 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Pacjent: " + t.Pacjent.Imie + " " + t.Pacjent.Nazwisko + "\n" + "Pesel: " + t.Pacjent.Pesel + "\n" + "Wizyta zaakceptowana. Zapraszamy!", start_date = t.DataRozp, end_date = t.DataZak, color = "yellow", type = "dhx_time_block" }); var items_green = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("N")). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Termin wolny", start_date = t.DataRozp, end_date = t.DataZak, color = "green", type = "dhx_time_block" }); items.AddRange(items_green); items.AddRange(items_blue); items.AddRange(items_red); items.AddRange(items_yellow); } else if (PacId != 0 && LekId != 0) { var items_red = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdPacjenta != PacId && rr.IdLekarza != LekId && dc.Wizyta.Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() >= 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Pacjent: " + t.Pacjent.Imie + " " + t.Pacjent.Nazwisko + "\n" + "Pesel: " + t.Pacjent.Pesel + "\n" + "Termin zajety", start_date = t.DataRozp, end_date = t.DataZak, color = "red", type = "dhx_time_block" }); var items_blue = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdPacjenta == PacId && rr.IdLekarza != LekId && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() == 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Pacjent: " + t.Pacjent.Imie + " " + t.Pacjent.Nazwisko + "\n" + "Pesel: " + t.Pacjent.Pesel + "\n" + "Oczekiwanie na akceptacje", start_date = t.DataRozp, end_date = t.DataZak, color = "blue", type = "dhx_time_block" }); var items_yellow = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdPacjenta == PacId && rr.IdLekarza != LekId && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() > 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Pacjent: " + t.Pacjent.Imie + " " + t.Pacjent.Nazwisko + "\n" + "Pesel: " + t.Pacjent.Pesel + "\n" + "Wizyta zaakceptowana. Zapraszamy!", start_date = t.DataRozp, end_date = t.DataZak, color = "yellow", type = "dhx_time_block" }); var items_green = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("N") && rr.IdLekarza != LekId). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Termin wolny", start_date = t.DataRozp, end_date = t.DataZak, color = "green", type = "dhx_time_block" }); items.AddRange(items_green); items.AddRange(items_blue); items.AddRange(items_red); items.AddRange(items_yellow); } else if (LekId != 0 && PacId == 0) { var items_blue = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdLekarza == LekId && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() == 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Pacjent: " + t.Pacjent.Imie + " " + t.Pacjent.Nazwisko + "\n" + "Pesel: " + t.Pacjent.Pesel + "\n" + "Oczekiwanie na akceptacje", start_date = t.DataRozp, end_date = t.DataZak, color = "blue", type = "dhx_time_block" }); var items_yellow = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("Y") && rr.IdLekarza == LekId && dc.Wizyta. Where(w => w.Rejestracja.IdRejestracji == rr.IdRejestracji).Count() > 0). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Pacjent: " + t.Pacjent.Imie + " " + t.Pacjent.Nazwisko + "\n" + "Pesel: " + t.Pacjent.Pesel + "\n" + "Wizyta zaakceptowana. Zapraszamy!", start_date = t.DataRozp, end_date = t.DataZak, color = "yellow", type = "dhx_time_block" }); var items_green = dc.Rejestracja.Where(rr => rr.CzyZajeta.Equals("N") && rr.IdLekarza == LekId). Select(t => new { id = t.IdRejestracji, text = "Lekarz: " + t.Lekarz.Imie + " " + t.Lekarz.Nazwisko + "\n" + "Termin wolny", start_date = t.DataRozp, end_date = t.DataZak, color = "green", type = "dhx_time_block" }); items.AddRange(items_green); items.AddRange(items_blue); items.AddRange(items_yellow); } /* var items_red = from r in dc.Rejestracja join w in dc.Wizyta on r.IdRejestracji equals w.IdRejestracji into RecWiz from w in RecWiz.DefaultIfEmpty() select new { id = r.IdRejestracji, text = r.IdLekarza, start_date = r.DataRozp, end_date = r.DataZak, color = "red"};*/ var data = new SchedulerAjaxData(items); return (ContentResult)data; }
public ContentResult OtherData() { var data = new SchedulerAjaxData(new CustomFieldsDataContext().ColoredEvents); return data; }
public ContentResult Data() { var data = new SchedulerAjaxData(Repository.ColoredEvents); return (data); }
public ContentResult Data() { var data = new SchedulerAjaxData((new CustomFieldsDataContext()).ColoredEvents); return(data); }
public ContentResult Data(int ID, string startTime, string endTime, DateTime from, DateTime to) { List<CalendarEvent> listCalendarEvent = new List<CalendarEvent>(); // int ID = 2; DateTime dt1 = from; DateTime dt2 = to; TimeSpan from1 = DateTime.Parse("1/1/2001 " + startTime).TimeOfDay; TimeSpan to1 = DateTime.Parse("1/1/2001 " + endTime).TimeOfDay; var employeeStopPoints = _factory.GetStopPoints(SessionManagement.FactoryID, ID, dt1, dt2, from1, to1); var employeeCustomerPoints = _factory.GetGpsEmployeeCustomerPoints(ID, dt1, dt2, from1, to1); bool blnFlag; foreach (EmployeeGpsPoint p in employeeStopPoints.ToList()) { blnFlag = false; if (p.StopStartTime != null && p.StopTime != null) { TimeSpan timestop = (TimeSpan)p.StopTime; CalendarEvent stop = new CalendarEvent { id = p.SysId,latitude=p.Lat.ToString(),longtitude=p.Long.ToString(), employeeId = p.EmployeeId.ToString() ?? "0", text = Status_stop, uniqueid = p.SysId.ToString(), start_date = (DateTime)p.StopStartTime, end_date = Convert.ToDateTime(p.StopStartTime).AddMinutes(timestop.TotalMinutes), color = Category.Red.ToString() }; foreach (CalendarEvent p1 in listCalendarEvent) if (p1.uniqueid == stop.uniqueid) blnFlag = true; if (!blnFlag) listCalendarEvent.Add(stop); } } string strSubject = ""; string cur_category = ""; foreach (GpsEmployeeCustomer p in employeeCustomerPoints.ToList()) { strSubject = p.Customer.LastName + " - " + p.Customer.CustomerNumber; blnFlag = false; if (p.EmployeeGpsPoint != null) { TimeSpan timestop = (TimeSpan)p.EmployeeGpsPoint.StopTime; if (p.EmployeeGpsPoint != null && p.EmployeeGpsPoint.StopStartTime != null && p.EmployeeGpsPoint.StopTime != null) { switch (p.InsertStatus) { case 0: cur_category = Category.Green.ToString(); break; case 1: cur_category = Category.Blue.ToString(); break; case 2: cur_category = Category.Custom.ToString(); //System.Drawing.Color.FromArgb(0xFF, 0x46, 0x82, 0xB4).ToString(); //TODO: to get hexadecimal code of color break; case 3: cur_category = Category.Yellow.ToString(); break; case 4: cur_category = Category.Orange.ToString(); break; default: cur_category = null; break; } if (cur_category != null) { if (p.InsertStatus == 1) { CalendarEvent app1 = listCalendarEvent.Where(x => x.uniqueid.CompareTo(Convert.ToString(p.GpsPointId)) == 0).FirstOrDefault(); if (app1 == null) { CalendarEvent s = new CalendarEvent { id = p.SysId, latitude = p.EmployeeGpsPoint.Lat.ToString(), longtitude = p.EmployeeGpsPoint.Long.ToString(), employeeId = p.EmployeeId.ToString() ?? "0", customerId = p.CustomerId.ToString(), text = Status_1, uniqueid = Convert.ToString(p.GpsPointId), start_date = (DateTime)p.EmployeeGpsPoint.StopStartTime, end_date = Convert.ToDateTime(p.EmployeeGpsPoint.StopStartTime).AddMinutes(timestop.TotalMinutes), color = cur_category }; foreach (CalendarEvent p1 in listCalendarEvent) if (p1.uniqueid == s.uniqueid) blnFlag = true; if (!blnFlag) listCalendarEvent.Add(s); } } else { CalendarEvent s = new CalendarEvent { id = p.SysId, latitude = p.EmployeeGpsPoint.Lat.ToString(), longtitude = p.EmployeeGpsPoint.Long.ToString(), employeeId = p.EmployeeId.ToString() ?? "0", customerId = p.CustomerId.ToString(), text = strSubject, uniqueid = Convert.ToString(p.GpsPointId), start_date = (DateTime)p.EmployeeGpsPoint.StopStartTime, end_date = Convert.ToDateTime(p.EmployeeGpsPoint.StopStartTime).AddMinutes(timestop.TotalMinutes), color = cur_category }; foreach (CalendarEvent p1 in listCalendarEvent) if (p1.uniqueid == s.uniqueid) blnFlag = true; if (!blnFlag) listCalendarEvent.Add(s); } } } } } //listCalendarEvent.Add(new CalendarEvent() { id = 1, text = "test", start_date = DateTime.Now, end_date = DateTime.Now.AddMinutes(20), color = "red" }); //listCalendarEvent.Add(new CalendarEvent() { id = 2, text = "test 2", start_date = DateTime.Now.AddMinutes(30), end_date = DateTime.Now.AddMinutes(90), color = "yellow" }); var data = new SchedulerAjaxData(listCalendarEvent); return (ContentResult)data; }
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()); }
public ContentResult Data() { var data = new SchedulerAjaxData((new DHXSchedulerDataContext()).Events); return (data); }
public ContentResult Data() { var data = new SchedulerAjaxData((new DHXSchedulerDataContext()).Events); // data.DateFormat = "%d/%m/%Y %H:%i"; return (data); }
public ContentResult Data() { var data = new SchedulerAjaxData(Repository.Events); return(data); }
public ContentResult Data() { var data = new SchedulerAjaxData(); return Content(data.FromUrl("https://www.google.com/calendar/ical/[email protected]/public/basic.ics")); }
/// <summary> /// Load Data /// </summary> /// <returns></returns> public ContentResult Data() { var events = Repository.GetAll<CalendarEvent>() .Join(Repository.GetAll<Room>(), ev => ev.room_id, room => room.key, (even, room) => new {Even = even, Room = room}) .Select(e => new { e.Even.id, e.Even.owner_id, e.Even.details, e.Even.end_date, e.Even.start_date, e.Even.text, e.Even.status_id, e.Even.room_id, e.Room.label, e.Even.projector_id, e.Even.laptop_id, e.Even.user_name, e.Even.for_dept, }).ToList(); SchedulerAjaxData data = null; if (Request.IsAuthenticated) { if (User.IsInRole("Manager") || User.IsInRole("General Director") || User.IsInRole("GA")) { data = new SchedulerAjaxData(events); } //else if (User.IsInRole("GA")) //{ // data = new SchedulerAjaxData(events.Where(ev => ev.for_dept == "GA")); //} else if (User.IsInRole("Employee")) { data = new SchedulerAjaxData(events.Where(ev => ev.for_dept == "Employee")); } } else { data = new SchedulerAjaxData(events); } return data; }
public ContentResult Data() { var data = new SchedulerAjaxData((new CustomFieldsDataContext()).ColoredEvents); return (data); }