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