public static IEnumerable <Image> GetSpecialDestinations()
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
var imagesExtracted = (from destination in entity.Destinations.Where(x => x.IsSpecial == true)
from image in entity.Images.Where(a => a.DestinationID == destination.DestinationID && a.Description != null)
from attraction in entity.Attractions.Where(a => a.AttractionID == image.AttractionID)
select new
{
Description = image.Description,
DestinationTitle = destination.Title,
AttractionTitle = attraction.Title,
Author = image.Author,
ImageURL = domainURL + image.FolderName.Trim() + "/2000x1125/" + image.ImageURL,
DestinationID = image.DestinationID
}).ToList().Take(5);
var imagesToReturn = (from imageData in imagesExtracted
select new Image()
{
Description = imageData.Description,
ImageURL = imageData.ImageURL,
Title = imageData.DestinationTitle + " - " + imageData.AttractionTitle,
DestinationID = imageData.DestinationID
}
).AsEnumerable();
return(imagesToReturn);
}
}
public static string GetDestinationDefaultImage(int id, char size)
{
TripXpertEntities entity = new TripXpertEntities();
string sizeString = "138x138";
switch (size)
{
case 'M':
sizeString = "/320x320/";
break;
case 'S':
sizeString = "/138x138/";
break;
case 'L':
sizeString = "/2000x1125/";
break;
default:
break;
}
using (entity)
{
Image defaultImage = (from image in entity.Images
where image.DestinationID == id && image.AttractionID != null
select image).ToList().First();
return(String.Format("{0}{1}{2}{3}", domainURL, defaultImage.FolderName.Trim(), sizeString, defaultImage.ImageURL));
}
}
public static object GetAllDestinationImages(int id)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
var matchingImages = (from image in entity.Images
where image.DestinationID == id
select new
{
Title = image.Title,
Description = (image.Author != string.Empty)?"Photo by: " + image.Author:string.Empty,
ImageURL = image.ImageURL,
FolderName = image.FolderName
}).ToList();
var imagesToReturn = (from matchingImage in matchingImages
select new
{
Title = matchingImage.Title,
Description = matchingImage.Description,
ImageURL = domainURL + matchingImage.FolderName.Trim() + "/2000x1125/" + matchingImage.ImageURL,
ThumbnailURL = domainURL + matchingImage.FolderName.Trim() + "/138x138/" + matchingImage.ImageURL
});
return(imagesToReturn);
}
}
public static object GetAllDestinationImages(int id)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
return(entity.Images.Where(x => x.DestinationID == id).ToList());
}
}
public static DateTime?GetLatestDate(int id)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
return((DateTime?)GetTourInfos(id).Max(x => x.StartDate));
}
}
public static List <Destination> GetAllDestinations()
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
return(entity.Destinations.ToList());
}
}
public static List <Destination> GetFirstDestinations()
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
var destinations = (from destionation in entity.Destinations select destionation).Take(3).ToList();
return(destinations);
}
}
public static Testimonial GetTestimonial(int testimonialID)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
return((from testimonial in entity.Testimonials
where testimonial.ID == testimonialID
select testimonial).First());
}
}
public static List <DestinationMarker> GetMarkers(int destinationID)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
return((from marker in entity.DestinationMarkers
where marker.DestinationID == destinationID
select marker).ToList());
}
}
public static List <Attraction> GetAttactionsForDestionation(int destinationID)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
return((from attraction in entity.Attractions
where attraction.DestinationID == destinationID
select attraction).ToList());
}
}
public static List <TourInfo> GetTourInfos(int id)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
return((from tourInfo in entity.TourInfos
where tourInfo.DestinationID == id
select tourInfo).ToList());
}
}
public static List <Destination> GetDestinationsByIds(List <int> ids)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
var destinations = (from destination in entity.Destinations
where ids.Contains(destination.DestinationID)
select destination).ToList();
return(destinations);
}
}
public static string GetDestinationDefaultImage(int id)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
Image defaultImage = (from image in entity.Images
where image.DestinationID == id
select image).ToList().First();
return(String.Format("{0}{1}/{2}", domainURL, defaultImage.FolderName.Trim(), defaultImage.ImageURL));
}
}
public static Destination GetDestinationById(string id)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
int destinationID = int.Parse(id);
Destination dest = (from destination in entity.Destinations
where destination.DestinationID == destinationID
select destination).First();
return(dest);
}
}
public static object GetAllAttractionImages()
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
return((from image in entity.Images
where image.AttractionID != null
select new
{
ImageURL = domainURL + image.FolderName.Trim() + "/138x138/" + image.ImageURL
}).ToList());
}
}
public static Image GetAttractionImage(int attractionID)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
Image attractionImage = (from image in entity.Images
where image.AttractionID == attractionID
select image).ToList().First();
attractionImage.ImageURL = String.Format("{0}{1}/{2}", domainURL, attractionImage.FolderName.Trim(), attractionImage.ImageURL);
return(attractionImage);
}
}
public static object GetMapData(int destinationID)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
return((from marker in entity.DestinationMarkers
where marker.DestinationID == destinationID
select new
{
Longitude = marker.Longitude,
Latitude = marker.Latitude,
Shape = "pinTarget"
}).ToList());
}
}
public static int GetLowestPriceForDestination(int id, int?min, int?max)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
if (min.HasValue && max.HasValue)
{
return((int)GetTourInfos(id).Where(t => t.PerSingleOccupancy > min.Value && t.PerSingleOccupancy < max.Value).First().PerSingleOccupancy);
}
else
{
return((int)GetTourInfos(id).Min(x => x.PerSingleOccupancy));
}
}
}
public static string GetDestinationDetailImage(int id)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
var rnd = new Random();
var detailImages = (from image in entity.Images
where image.DestinationID == id
select image).ToList();
int randomIndex = rnd.Next(detailImages.Count);
var detailImage = detailImages[randomIndex];
return(String.Format("{0}{1}/{2}", domainURL, detailImage.FolderName.Trim(), detailImage.ImageURL));
}
}
public static object GetFullDestinationInfo()
{
Dictionary <string, List <object> > dataDictionary = new Dictionary <string, List <object> >();
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
List <Destination> destinations = GetAllDestinations();
foreach (Destination destination in destinations)
{
dataDictionary.Add(destination.Title, new List <object>());
dataDictionary[destination.Title].Add(GetLowestPriceForDestination(destination.DestinationID, null, null).ToString());
dataDictionary[destination.Title].Add(destination.IsSpecial);
dataDictionary[destination.Title].Add(destination.DestinationID);
}
return(dataDictionary);
}
}
public static string GetDestinationsQueryString(string title, string typeOfOffer, string priceRange)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
string[] prices = priceRange.Split(new char[] { '-' }, StringSplitOptions.RemoveEmptyEntries);
int? id = null;
if (title != string.Empty)
{
id = (from destination in entity.Destinations
where destination.Title.Contains(title)
select destination.DestinationID).First();
return(id.ToString());
}
IEnumerable <TourInfo> infos = entity.TourInfos.ToList();
List <Destination> destinations = (from destination
in entity.Destinations
select destination).ToList();
if (prices.Length > 1)
{
int lowestPrice = int.Parse(prices[0]);
int highestPrice = int.Parse(prices[1]);
infos = infos.Where(i => i.PerSingleOccupancy > lowestPrice && i.PerSingleOccupancy < highestPrice);
destinations = GetDestinationsByIds(infos.Select(x => x.DestinationID).Distinct().ToList());
}
if (typeOfOffer != "All")
{
bool isSpecial = (typeOfOffer == "Special")?true:false;
destinations = destinations.Where(x => x.IsSpecial == isSpecial).ToList();
}
StringBuilder sb = new StringBuilder();
sb.Append(destinations[0].DestinationID.ToString());
for (int i = 1; i < destinations.Count; i++)
{
sb.Append(",");
sb.Append(destinations[i].DestinationID.ToString());
}
return(sb.ToString());
}
}
public static object GetFullAttractionInfo(string url)
{
TripXpertEntities entity = new TripXpertEntities();
using (entity)
{
Image attractionImage = (from image in entity.Images.Where(a => a.ImageURL == url) select image).First();
var data = (from attraction in entity.Attractions.Where(x => x.AttractionID == attractionImage.AttractionID)
from destination in entity.Destinations.Where(a => a.DestinationID == attraction.DestinationID)
select new
{
DestinationTitle = destination.Title,
ImageURL = domainURL + attractionImage.FolderName.Trim() + "/320x320/" + attractionImage.ImageURL,
Location = attraction.Location,
Description = attraction.Description,
AttractionTitle = attraction.Title,
DestinationID = destination.DestinationID
}).ToList();
return(data);
}
}
