How can I show related data in full calendar from multiple tables?












0














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









share|improve this question
























  • 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
















0














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









share|improve this question
























  • 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














0












0








0







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









share|improve this question















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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


















  • 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












1 Answer
1






active

oldest

votes


















0














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.






share|improve this answer





















  • 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











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


}
});














draft saved

draft discarded


















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









0














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.






share|improve this answer





















  • 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
















0














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.






share|improve this answer





















  • 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














0












0








0






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.






share|improve this answer












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.







share|improve this answer












share|improve this answer



share|improve this answer










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










  • The roomName 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










  • The roomName 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


















draft saved

draft discarded




















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

What visual should I use to simply compare current year value vs last year in Power BI desktop

Alexandru Averescu

Trompette piccolo