// POST: api/statistics/calories public IHttpActionResult PostCalories(DateRangeInputModel model) { var userId = User.Identity.GetUserId(); var stats = db.GetAllByUser(userId).Where(x => x.StartDate >= model.StartDate && model.EndDate <= model.EndDate) .Select(x => new { Calories = x.Calories, Date = x.StartDate }).ToList(); return(Json(new { stats = stats })); }
// POST: api/statistics/calories public IHttpActionResult PostCalories(DateRangeInputModel model) { var userId = User.Identity.GetUserId(); var stats = db.GetAllByUser(userId).Where(x => x.StartDate >= model.StartDate && model.EndDate <= model.EndDate) .Select(x => new { Calories = x.Calories, Date = x.StartDate }).ToList(); return Json(new { stats = stats }); }
public IHttpActionResult GetMoviesInSpecificCinema(int cinemaId, [FromUri] DateRangeInputModel dateRange) { Cinema cinema = DatabaseAdapter.QueryCinemaByCinemaId(cinemaId); return(Ok(new JsonApiOutput <IEnumerable <MovieOutputModel> >( DatabaseAdapter.QueryMoviesInCinema(cinema, dateRange.StartDate, dateRange.EndDate).ToList() .Select <Movie, MovieOutputModel>(m => new MovieOutputModel(m)).ToList() ) )); }
public ActionResult addProjectionsForDay([Bind(Include = "StartDate,EndDate")] DateRangeInputModel dateRange) { MovieBotContext context = new MovieBotContext(); foreach (var date in DatabaseAdapter.EachDay(dateRange.StartDate, dateRange.EndDate)) { IEnumerable <Movie> movies = context.Movies.ToList(); IEnumerable <Cinema> cinemas = context.Cinemas.ToList(); IEnumerable <CinemaProjections> cprojections = getDummyCinemaProjections(movies, cinemas, date); cprojections.ToList <CinemaProjections>().ForEach( c => c.MovieProjections.ToList().ForEach( m => m.Projections.ToList().ForEach( p => context.Projections.Add(p) ) ) ); } context.SaveChanges(); return(View()); }
public IHttpActionResult getProjectionsOfMultipleImdbsForSameCinemaId(int cinemaId, [FromBody] List <string> imdbIds, [FromUri] DateRangeInputModel dateRange) { Dictionary <string, IEnumerable <ProjectionOutputModel> > result = imdbIds.Aggregate <string, Dictionary <string, IEnumerable <ProjectionOutputModel> > >(new Dictionary <string, IEnumerable <ProjectionOutputModel> >(), (current, next) => { var cinemaProjections = DatabaseAdapter.QueryProjectionsByCinemaAndMovieAndDateRange(cinemaId, next, dateRange.StartDate, dateRange.EndDate); current[next] = cinemaProjections.ToList().Select(p => new ProjectionOutputModel(p)); return(current); }); return(Ok(new JsonApiOutput <Dictionary <string, IEnumerable <ProjectionOutputModel> > >(result))); }
public IHttpActionResult getProjectionsByCinemaAndImdbId(string imdbId, int cinemaId, [FromUri] DateRangeInputModel dateRange) { IQueryable <Projection> projections = DatabaseAdapter.QueryProjectionsByCinemaAndMovieAndDateRange(cinemaId, imdbId, dateRange.StartDate, dateRange.EndDate); return(Ok(new JsonApiOutput <IEnumerable <ProjectionOutputModel> >( projections.ToList().Select <Projection, ProjectionOutputModel>(p => new ProjectionOutputModel(p)) ) )); }
public IHttpActionResult GetMoviesFromLocationAndDateRange(double latitude, double longitude, [FromUri] DateRangeInputModel dateRange, [FromUri] int maxRange = 50) { IEnumerable <Movie> movies = DatabaseAdapter.QueryMoviesFromLocation(latitude, longitude, maxRange, dateRange.StartDate, dateRange.EndDate); return(Ok(new JsonApiOutput <IEnumerable <MovieOutputModel> >(movies.ToList().Select <Movie, MovieOutputModel>(m => new MovieOutputModel(m))))); }
public IHttpActionResult GetCinemasByMovieAndLocationAndDateRange(string imdbId, double latitude, double longitude, [FromUri] DateRangeInputModel dateRange, [FromUri] int maxRange = 50) { IEnumerable <Cinema> cinemas = DatabaseAdapter.QueryCinemaFromMovie(latitude, longitude, maxRange, imdbId, dateRange.StartDate, dateRange.EndDate).ToList(); return(Ok(new JsonApiOutput <IEnumerable <CinemaOutputModel> >( cinemas.ToList().Select <Cinema, CinemaOutputModel>(c => new CinemaOutputModel(c)).ToList() ))); }
public JsonApiOutput <IEnumerable <CinemaMovieProjectionsOutputModel> > searchCinemasFromMovie([FromUri] DateRangeInputModel dateRange, [FromUri] LocationInputModel location, [FromUri] string imdbid) { return(new JsonApiOutput <IEnumerable <CinemaMovieProjectionsOutputModel> >( DatabaseAdapter.QueryCinemaProjectionsFromMovie(location.Latitude, location.Longitude, location.MaxRange, imdbid, dateRange.StartDate, dateRange.EndDate) .Select <CinemaProjections, CinemaMovieProjectionsOutputModel>(i => new CinemaMovieProjectionsOutputModel(i)))); }
public JsonApiOutput <IEnumerable <MovieOutputModel> > searchMoviesFromLocation([FromUri] DateRangeInputModel dateRange, [FromUri] LocationInputModel location) { return (new JsonApiOutput <IEnumerable <MovieOutputModel> >( DatabaseAdapter.QueryMoviesFromLocation(location.Latitude, location.Longitude, location.MaxRange, dateRange.StartDate, dateRange.EndDate) .Select <Movie, MovieOutputModel>(i => new MovieOutputModel(i)) )); }