How can I show related data in full calendar from multiple tables?
I have asp.net mvc site with full calendar. I also created tables like 'Event' and 'Room'. In my event table i have RoomId field.
This is how my function looks:
$(document).ready(function () {
var events = ;
var selectedEvent = null;
FetchEventAndRenderCalendar();
function FetchEventAndRenderCalendar() {
events = ;
$.ajax({
type: "GET",
url: "/CalendarEvent/GetEvents",
success: function (data) {
$.each(data, function (i, v) {
events.push({
eventID: v.Id,
title: v.Job,
description: v.Description,
start: moment(v.Start),
end: v.DutyEnd != null ? moment(v.End) : null,
room: v.RoomId,
});
})
GenerateCalender(events);
},
error: function (error) {
alert('failed');
}
})
}
On this moment, calendar displays Id. How can I refer to another table?
And this is my controller:
public JsonResult GetEvents()
{
using (Context dc = new Context())
{
dc.Configuration.LazyLoadingEnabled = false;
var events = dc.Event.ToList();
return new JsonResult { Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
}
asp.net-mvc linq-to-sql linq-to-entities
add a comment |
I have asp.net mvc site with full calendar. I also created tables like 'Event' and 'Room'. In my event table i have RoomId field.
This is how my function looks:
$(document).ready(function () {
var events = ;
var selectedEvent = null;
FetchEventAndRenderCalendar();
function FetchEventAndRenderCalendar() {
events = ;
$.ajax({
type: "GET",
url: "/CalendarEvent/GetEvents",
success: function (data) {
$.each(data, function (i, v) {
events.push({
eventID: v.Id,
title: v.Job,
description: v.Description,
start: moment(v.Start),
end: v.DutyEnd != null ? moment(v.End) : null,
room: v.RoomId,
});
})
GenerateCalender(events);
},
error: function (error) {
alert('failed');
}
})
}
On this moment, calendar displays Id. How can I refer to another table?
And this is my controller:
public JsonResult GetEvents()
{
using (Context dc = new Context())
{
dc.Configuration.LazyLoadingEnabled = false;
var events = dc.Event.ToList();
return new JsonResult { Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
}
asp.net-mvc linq-to-sql linq-to-entities
You want to get data from the 'room' table with the id from the 'event' table?
– Örvar
Nov 22 at 19:35
Yes. In the 'Event' table, RoomID is foreign key to 'Room' table.
– Patrycja
Nov 22 at 20:19
Sounds like this is a Linq or SQL question, not a fullCalendar question. Please tag it with the area which is actually giving you the problem
– ADyson
Nov 23 at 14:27
add a comment |
I have asp.net mvc site with full calendar. I also created tables like 'Event' and 'Room'. In my event table i have RoomId field.
This is how my function looks:
$(document).ready(function () {
var events = ;
var selectedEvent = null;
FetchEventAndRenderCalendar();
function FetchEventAndRenderCalendar() {
events = ;
$.ajax({
type: "GET",
url: "/CalendarEvent/GetEvents",
success: function (data) {
$.each(data, function (i, v) {
events.push({
eventID: v.Id,
title: v.Job,
description: v.Description,
start: moment(v.Start),
end: v.DutyEnd != null ? moment(v.End) : null,
room: v.RoomId,
});
})
GenerateCalender(events);
},
error: function (error) {
alert('failed');
}
})
}
On this moment, calendar displays Id. How can I refer to another table?
And this is my controller:
public JsonResult GetEvents()
{
using (Context dc = new Context())
{
dc.Configuration.LazyLoadingEnabled = false;
var events = dc.Event.ToList();
return new JsonResult { Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
}
asp.net-mvc linq-to-sql linq-to-entities
I have asp.net mvc site with full calendar. I also created tables like 'Event' and 'Room'. In my event table i have RoomId field.
This is how my function looks:
$(document).ready(function () {
var events = ;
var selectedEvent = null;
FetchEventAndRenderCalendar();
function FetchEventAndRenderCalendar() {
events = ;
$.ajax({
type: "GET",
url: "/CalendarEvent/GetEvents",
success: function (data) {
$.each(data, function (i, v) {
events.push({
eventID: v.Id,
title: v.Job,
description: v.Description,
start: moment(v.Start),
end: v.DutyEnd != null ? moment(v.End) : null,
room: v.RoomId,
});
})
GenerateCalender(events);
},
error: function (error) {
alert('failed');
}
})
}
On this moment, calendar displays Id. How can I refer to another table?
And this is my controller:
public JsonResult GetEvents()
{
using (Context dc = new Context())
{
dc.Configuration.LazyLoadingEnabled = false;
var events = dc.Event.ToList();
return new JsonResult { Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet };
}
}
asp.net-mvc linq-to-sql linq-to-entities
asp.net-mvc linq-to-sql linq-to-entities
edited Nov 23 at 18:12
asked Nov 22 at 18:38
Patrycja
1
1
You want to get data from the 'room' table with the id from the 'event' table?
– Örvar
Nov 22 at 19:35
Yes. In the 'Event' table, RoomID is foreign key to 'Room' table.
– Patrycja
Nov 22 at 20:19
Sounds like this is a Linq or SQL question, not a fullCalendar question. Please tag it with the area which is actually giving you the problem
– ADyson
Nov 23 at 14:27
add a comment |
You want to get data from the 'room' table with the id from the 'event' table?
– Örvar
Nov 22 at 19:35
Yes. In the 'Event' table, RoomID is foreign key to 'Room' table.
– Patrycja
Nov 22 at 20:19
Sounds like this is a Linq or SQL question, not a fullCalendar question. Please tag it with the area which is actually giving you the problem
– ADyson
Nov 23 at 14:27
You want to get data from the 'room' table with the id from the 'event' table?
– Örvar
Nov 22 at 19:35
You want to get data from the 'room' table with the id from the 'event' table?
– Örvar
Nov 22 at 19:35
Yes. In the 'Event' table, RoomID is foreign key to 'Room' table.
– Patrycja
Nov 22 at 20:19
Yes. In the 'Event' table, RoomID is foreign key to 'Room' table.
– Patrycja
Nov 22 at 20:19
Sounds like this is a Linq or SQL question, not a fullCalendar question. Please tag it with the area which is actually giving you the problem
– ADyson
Nov 23 at 14:27
Sounds like this is a Linq or SQL question, not a fullCalendar question. Please tag it with the area which is actually giving you the problem
– ADyson
Nov 23 at 14:27
add a comment |
1 Answer
1
active
oldest
votes
You will need to join the event table with the room table. In your controller method GetEvents()
you can create a select query something along the lines of the following:
var query = (from event in dc.event
join rooms in dc.rooms on event.roomId equals rooms.roomId
select new
{
eventID: event.Id,
title: event.Job,
description: event.Description,
roomId: room.RoomId,
roomName: room.Name
roomSize: room.Size
}).ToList();
Hope this helps.
it compiles, but I can only display RoomId.. With room name, i have failed alert
– Patrycja
Nov 22 at 22:05
TheroomName
in the query was only an example... Try to remove it and try again.
– Örvar
Nov 23 at 10:32
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53436592%2fhow-can-i-show-related-data-in-full-calendar-from-multiple-tables%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You will need to join the event table with the room table. In your controller method GetEvents()
you can create a select query something along the lines of the following:
var query = (from event in dc.event
join rooms in dc.rooms on event.roomId equals rooms.roomId
select new
{
eventID: event.Id,
title: event.Job,
description: event.Description,
roomId: room.RoomId,
roomName: room.Name
roomSize: room.Size
}).ToList();
Hope this helps.
it compiles, but I can only display RoomId.. With room name, i have failed alert
– Patrycja
Nov 22 at 22:05
TheroomName
in the query was only an example... Try to remove it and try again.
– Örvar
Nov 23 at 10:32
add a comment |
You will need to join the event table with the room table. In your controller method GetEvents()
you can create a select query something along the lines of the following:
var query = (from event in dc.event
join rooms in dc.rooms on event.roomId equals rooms.roomId
select new
{
eventID: event.Id,
title: event.Job,
description: event.Description,
roomId: room.RoomId,
roomName: room.Name
roomSize: room.Size
}).ToList();
Hope this helps.
it compiles, but I can only display RoomId.. With room name, i have failed alert
– Patrycja
Nov 22 at 22:05
TheroomName
in the query was only an example... Try to remove it and try again.
– Örvar
Nov 23 at 10:32
add a comment |
You will need to join the event table with the room table. In your controller method GetEvents()
you can create a select query something along the lines of the following:
var query = (from event in dc.event
join rooms in dc.rooms on event.roomId equals rooms.roomId
select new
{
eventID: event.Id,
title: event.Job,
description: event.Description,
roomId: room.RoomId,
roomName: room.Name
roomSize: room.Size
}).ToList();
Hope this helps.
You will need to join the event table with the room table. In your controller method GetEvents()
you can create a select query something along the lines of the following:
var query = (from event in dc.event
join rooms in dc.rooms on event.roomId equals rooms.roomId
select new
{
eventID: event.Id,
title: event.Job,
description: event.Description,
roomId: room.RoomId,
roomName: room.Name
roomSize: room.Size
}).ToList();
Hope this helps.
answered Nov 22 at 20:52
Örvar
412315
412315
it compiles, but I can only display RoomId.. With room name, i have failed alert
– Patrycja
Nov 22 at 22:05
TheroomName
in the query was only an example... Try to remove it and try again.
– Örvar
Nov 23 at 10:32
add a comment |
it compiles, but I can only display RoomId.. With room name, i have failed alert
– Patrycja
Nov 22 at 22:05
TheroomName
in the query was only an example... Try to remove it and try again.
– Örvar
Nov 23 at 10:32
it compiles, but I can only display RoomId.. With room name, i have failed alert
– Patrycja
Nov 22 at 22:05
it compiles, but I can only display RoomId.. With room name, i have failed alert
– Patrycja
Nov 22 at 22:05
The
roomName
in the query was only an example... Try to remove it and try again.– Örvar
Nov 23 at 10:32
The
roomName
in the query was only an example... Try to remove it and try again.– Örvar
Nov 23 at 10:32
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53436592%2fhow-can-i-show-related-data-in-full-calendar-from-multiple-tables%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You want to get data from the 'room' table with the id from the 'event' table?
– Örvar
Nov 22 at 19:35
Yes. In the 'Event' table, RoomID is foreign key to 'Room' table.
– Patrycja
Nov 22 at 20:19
Sounds like this is a Linq or SQL question, not a fullCalendar question. Please tag it with the area which is actually giving you the problem
– ADyson
Nov 23 at 14:27