//=====================================================================
// Get Visitor Name based on Visit Id
//=====================================================================
public Visitor GetVisitor(int VisitId)
{
IQueryable <Visitor> visitorQuery =
(from visitor in _context.Visitor
join visit in _context.Visit on visitor.VisitorId equals visit.VisitorId into Visit_Visitor
from joinVisitor in Visit_Visitor.DefaultIfEmpty()
where joinVisitor.VisitId == VisitId
select visitor);
return(visitorQuery.ToArray().First());
}
//=====================================================================
// Get Visitor Data as a JSON Object
//=====================================================================
public JsonResult OnGetVisitorData(int visitId)
{
IQueryable <Visitor> visitorData =
(from visitor in _context.Visitor
join visit in _context.Visit on visitor.VisitorId equals visit.VisitorId into Visit_Visitor
from joinVisitor in Visit_Visitor.DefaultIfEmpty()
where joinVisitor.VisitId == visitId
select visitor);
string jsonData = JsonConvert.SerializeObject(visitorData);
return(new JsonResult(jsonData));
}
