public IHttpActionResult SearchForProjections([FromBody] dynamic Parameters)
{
int RVisitorID = Parameters.RVisitorID;
float Latitude = Parameters.Latitude;
float Longitude = Parameters.Longitude;
bool GPSAquired = Parameters.GPSAquired;
string searchQuery = Parameters.SearchQuery;
var CinemaDistances = new Dictionary <int, float>();
var CinemaIDs = new List <int>();
int CinemaID = 0;
if (GPSAquired)
{
foreach (var cinema in principal.CinemaCoordinates.Where(x => !x.Cinemas.IsDeleted).ToList())
{
var vectorTarget = new VectorN(new float[] { (float)cinema.Latitude, (float)cinema.Longitude });
var vectorMe = new VectorN(new float[] { Latitude, Longitude });
CinemaDistances.Add(cinema.CinemaID, VectorN.Subtraction(vectorMe, vectorTarget).GetLength());
}
CinemaID = CinemaDistances.OrderBy(x => x.Value).Select(y => y.Key).FirstOrDefault();
CinemaIDs.Add(CinemaID);
}
else
{
CinemaIDs.AddRange(principal.Cinemas.Where(x => !x.IsDeleted).Select(x => x.CinemaID).ToList());
}
var recommendedProjections = new List <Projections>();
if (String.IsNullOrWhiteSpace(searchQuery))
{
var recommendedMovies = GetRecommendedMovies(RVisitorID).Result;
var projections = principal.Projections
.Where(x => !x.IsDeleted &&
DbFunctions.TruncateTime(x.DateTimeStart) > DbFunctions.TruncateTime(DateTime.Today) &&
CinemaIDs.Contains(x.CinemaHalls.Cinemas.CinemaID))
.OrderBy(x => x.Movies.Name)
.DistinctBy(x => x.MovieID)
.ToList();
foreach (var movieID in recommendedMovies)
{
var projection = projections.Where(x => x.MovieID == movieID);
if (projection.Any())
{
recommendedProjections.Add(projection.FirstOrDefault());
}
}
foreach (var projection in recommendedProjections)
{
projections.Remove(projection);
}
recommendedProjections.AddRange(projections);
}
else
{
List <string> Movies = principal.Projections
.Where(x => !x.IsDeleted &&
DbFunctions.TruncateTime(x.DateTimeStart) > DbFunctions.TruncateTime(DateTime.Today) &&
CinemaIDs.Contains(x.CinemaHalls.Cinemas.CinemaID))
.OrderBy(x => x.Movies.Name)
.DistinctBy(x => x.Movies.Name)
.Select(x => x.Movies.Name + "$" + x.Movies.Synopsis)
.ToList();
Movies.ContextSort(searchQuery);
foreach (var movie in Movies)
{
string s = movie.Split('$')[0];
recommendedProjections.AddRange(principal.Projections.Where(x => !x.IsDeleted &&
DbFunctions.TruncateTime(x.DateTimeStart) > DbFunctions.TruncateTime(DateTime.Today) &&
CinemaIDs.Contains(x.CinemaHalls.Cinemas.CinemaID) && x.Movies.Name == s).OrderBy(x => x.Movies.Name)
.DistinctBy(x => x.Movies.Name).ToList());
}
}
return(Ok(recommendedProjections.Select(x => new
{
Duration = x.Movies.DurationInMinutes.ToString(),
Age = x.Movies.AgeRestrictions.Name,
Release = x.Movies.ReleaseYear.ToString(),
MovieName = x.Movies.Name,
x.MovieID,
x.CinemaHallID,
x.DateTimeStart,
x.TicketPrice,
MovieCover = Convert.ToBase64String(x.Movies.PictureBytes),
Projections = principal.Projections
.Where(y => DbFunctions.TruncateTime(y.DateTimeStart) > DbFunctions.TruncateTime(DateTime.Today) &&
y.Movies.MovieID == x.Movies.MovieID && !y.IsDeleted &&
CinemaIDs.Contains(y.CinemaHalls.Cinemas.CinemaID))
.OrderBy(y => y.DateTimeStart).Select(y => new {
y.ProjectionID,
y.MovieID,
y.CinemaHallID,
y.DateTimeStart,
y.TechnologyTypes.Name,
y.TicketPrice,
CinemaHallName = y.CinemaHalls.Name,
CinemaName = y.CinemaHalls.Cinemas.Name,
}).Take(10)
}).ToList()));
}