public IHttpActionResult Get(string searchQuery) { //return events; using (Contexts.GottaHaveItContext ctx = new Contexts.GottaHaveItContext()) { var eventQuery = ctx.Events .Where(e => e.Description.Contains(searchQuery) || e.Name.Contains(searchQuery)) .Include(e => e.Location) //.Include(e => e.) .ToList(); var channelQuery = ctx.Channels .Where(c => c.Description.Contains(searchQuery) || c.Name.Contains(searchQuery)) //.Include(e => e.) .ToList(); var query = new { eventResults = eventQuery, channelResults = channelQuery }; return Ok(query); } }
public IHttpActionResult Get() { using (Contexts.GottaHaveItContext ctx = new Contexts.GottaHaveItContext()) { var query = ctx.Locations .Include(l => l.Events) //.Include(e => e.) .ToList(); return Ok(query); } }
public IHttpActionResult Get() { using (Contexts.GottaHaveItContext ctx = new Contexts.GottaHaveItContext()) { var query = ctx.Channels .Include(c => c.ChannelMemberships.Select(cm => cm.Event)) //.Include(e => e.) .ToList(); return Ok(query); } }
public IHttpActionResult Get(int id) { using (Contexts.GottaHaveItContext ctx = new Contexts.GottaHaveItContext()) { var query = ctx.Locations .Include(l => l.Events) //.Include(e => e.) .FirstOrDefault((l) => l.ID == id); if (query == null) { return NotFound(); } return Ok(query); } }
public IHttpActionResult Get(int id) { using (Contexts.GottaHaveItContext ctx = new Contexts.GottaHaveItContext()) { var query = ctx.Channels //.Include(c => c.) .Include(c => c.ChannelMemberships.Select(cm => cm.Event)) .Include(c => c.ChannelMemberships.Select(cm => cm.Event.Location)) //.Include(e => e.) .FirstOrDefault((c) => c.ID == id); if (query == null) { return NotFound(); } return Ok(query); } }
public IHttpActionResult Get(int id) { using (Contexts.GottaHaveItContext ctx = new Contexts.GottaHaveItContext()) { //var query = from e in ctx.Events // select e; var query = ctx.Events .Include(e => e.Location) .Include(e => e.ChannelMemberships.Select(cm => cm.Channel)) //.Include(e => e.) .FirstOrDefault((e) => e.ID == id); if (query == null) { return NotFound(); } return Ok(query); } }