public ActionResult Activities(string id)
{
TripAppEntities entities = new TripAppEntities();
ViewBag.TripCode = id;
return(View(entities.TripUsers.First(r => r.TripCode == id)));
}
public ActionResult Activities(string id)
{
TripAppEntities entities = new TripAppEntities();
ViewBag.TripCode = id;
return View(entities.TripUsers.First(r => r.TripCode == id));
}
public ActionResult Prizes(string id)
{
TripAppEntities entities = new TripAppEntities();
var trip = entities.TripUsers.Where(r => r.TripCode == id).FirstOrDefault().Trip;
ViewBag.TripCode = id;
return(View());
}
public ActionResult Comments(string id)
{
TripAppEntities entities = new TripAppEntities();
var tripUser = entities.TripUsers.Where(r => r.TripCode == id).First();
ViewBag.Destination = tripUser.Trip.Destination;
ViewBag.TripUser = tripUser;
ViewBag.TripCode = id;
return(View("Comments", entities.TripComments.Where(r => r.TripUser.TripId == tripUser.TripId && r.TripActivityId == 0).OrderByDescending(r => r.Date).ToList()));
}
public ActionResult Comments(string id)
{
TripAppEntities entities = new TripAppEntities();
var tripUser = entities.TripUsers.Where(r=> r.TripCode == id).First();
ViewBag.Destination = tripUser.Trip.Destination;
ViewBag.TripUser = tripUser;
ViewBag.TripCode = id;
return View("Comments", entities.TripComments.Where(r=> r.TripUser.TripId == tripUser.TripId && r.TripActivityId == 0).OrderByDescending(r=> r.Date).ToList());
}
public ActionResult ActivityDetails(int id, string code)
{
TripAppEntities entities = new TripAppEntities();
var activity = entities.TripActivities.FirstOrDefault(r => r.Id == id);
ViewBag.Comments = entities.TripComments.Where(r => r.TripActivityId != null && r.TripActivityId == id).OrderByDescending(r => r.Date).ToList();
ViewBag.createdBy = entities.TripUsers.FirstOrDefault(r => r.Id == activity.TripUserId);
ViewBag.TripUser = entities.TripUsers.FirstOrDefault(r => r.TripCode == code);
ViewBag.TripCode = id;
return(View(activity));
}
public ActionResult ActivityDetails(int id, string code)
{
TripAppEntities entities = new TripAppEntities();
var activity = entities.TripActivities.FirstOrDefault(r=> r.Id == id);
ViewBag.Comments = entities.TripComments.Where(r => r.TripActivityId != null && r.TripActivityId == id).OrderByDescending(r=> r.Date).ToList();
ViewBag.createdBy = entities.TripUsers.FirstOrDefault(r=> r.Id == activity.TripUserId);
ViewBag.TripUser = entities.TripUsers.FirstOrDefault(r=> r.TripCode == code);
ViewBag.TripCode = id;
return View(activity);
}
public ActionResult Pictures(string id)
{
TripAppEntities entities = new TripAppEntities();
var trip = entities.TripUsers.Where(r => r.TripCode == id).FirstOrDefault().Trip;
var pictures = entities.TripPictures.Where(r => r.TripUser.TripId == trip.Id).ToList();
ViewBag.UserId = id;
ViewBag.TripCode = id;
return(View(pictures));
}
public ActionResult Pictures(string id)
{
TripAppEntities entities = new TripAppEntities();
var trip = entities.TripUsers.Where(r => r.TripCode == id).FirstOrDefault().Trip;
var pictures = entities.TripPictures.Where(r => r.TripUser.TripId == trip.Id).ToList();
ViewBag.UserId = id;
ViewBag.TripCode = id;
return View(pictures);
}
public ActionResult Detail(string id)
{
TripAppEntities entities = new TripAppEntities();
var code = entities.TripUsers.Where(r => r.TripCode == id).FirstOrDefault();
if (code != null)
{
ViewBag.TripCode = id;
return(View("TripDetail", code));
}
else
{
ViewBag.IsFound = false;
return(RedirectToAction("../Home/EnterCode"));
}
}
public ActionResult Detail(string id)
{
TripAppEntities entities = new TripAppEntities();
var code = entities.TripUsers.Where(r => r.TripCode == id).FirstOrDefault();
if (code != null)
{
ViewBag.TripCode = id;
return View("TripDetail", code);
}
else
{
ViewBag.IsFound = false;
return RedirectToAction("../Home/EnterCode");
}
}
public ActionResult UploadPicture(UploadImageFile image)
{
var f = Request.Files[0];
bool success = false;
string urlSuffix = image.TripUserId + DateTime.Now.ToString() + ".jpg";
string bucket = "trip-app-pictures";
double lat = 0;
double lon = 0;
try
{
IAmazonS3 client = new AmazonS3Client("AKIAJWFD6TJO7NXPGCOA", "0MiV/p3r411kt9L5PE/Lwwg1n/2VLzbwXgRXIZLk", Amazon.RegionEndpoint.USEast1);
// get lat lon
if (!String.IsNullOrEmpty(image.Location))
{
if (image.UseCurrentLocation)
{
var latlon = image.Location.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
lat = Convert.ToDouble(latlon[0]);
lon = Convert.ToDouble(latlon[1]);
}
else if (!String.IsNullOrEmpty(image.Location))
{
var address = image.Location;
var requestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=false", Uri.EscapeDataString(address));
var georequest = WebRequest.Create(requestUri);
var response = georequest.GetResponse();
var xdoc = XDocument.Load(response.GetResponseStream());
var result = xdoc.Element("GeocodeResponse").Element("result");
var locationElement = result.Element("geometry").Element("location");
lat = Convert.ToDouble(locationElement.Element("lat").Value);
lon = Convert.ToDouble(locationElement.Element("lng").Value);
}
}
if (!String.IsNullOrEmpty(image.Description) && !String.IsNullOrEmpty(image.TripUserId) && f.InputStream != null)
{
var request = new PutObjectRequest()
{
BucketName = bucket,
CannedACL = S3CannedACL.PublicRead,
Key = string.Format(urlSuffix),
InputStream = f.InputStream
};
client.PutObject(request);
success = true;
}
}
catch (Exception ex)
{
success = false;
}
if (success)
{
TripAppEntities entities = new TripAppEntities();
var user = entities.TripUsers.Where(r => r.TripCode == image.TripUserId).FirstOrDefault();
var url = "https://s3.amazonaws.com/trip-app-pictures/" + urlSuffix;
TripPicture picture = new TripPicture();
picture.TripUserId = user.Id;
picture.Description = image.Description;
picture.Date = DateTime.Now;
picture.PictureUrl = url;
picture.LocationName = !image.UseCurrentLocation ? image.Location : null;
picture.Lat = lat;
picture.Lon = lon;
entities.TripPictures.Add(picture);
entities.SaveChanges();
}
return(RedirectToAction("../Trip/Pictures/" + image.TripUserId));
}
public ActionResult Prizes(string id)
{
TripAppEntities entities = new TripAppEntities();
var trip = entities.TripUsers.Where(r => r.TripCode == id).FirstOrDefault().Trip;
ViewBag.TripCode = id;
return View();
}
public ActionResult UploadPicture(UploadImageFile image)
{
var f = Request.Files[0];
bool success = false;
string urlSuffix = image.TripUserId + DateTime.Now.ToString() + ".jpg" ;
string bucket = "trip-app-pictures";
double lat = 0;
double lon = 0;
try
{
IAmazonS3 client = new AmazonS3Client("AKIAJWFD6TJO7NXPGCOA", "0MiV/p3r411kt9L5PE/Lwwg1n/2VLzbwXgRXIZLk", Amazon.RegionEndpoint.USEast1);
// get lat lon
if (!String.IsNullOrEmpty(image.Location))
{
if (image.UseCurrentLocation)
{
var latlon = image.Location.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
lat = Convert.ToDouble(latlon[0]);
lon = Convert.ToDouble(latlon[1]);
}
else if (!String.IsNullOrEmpty(image.Location))
{
var address = image.Location;
var requestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=false", Uri.EscapeDataString(address));
var georequest = WebRequest.Create(requestUri);
var response = georequest.GetResponse();
var xdoc = XDocument.Load(response.GetResponseStream());
var result = xdoc.Element("GeocodeResponse").Element("result");
var locationElement = result.Element("geometry").Element("location");
lat = Convert.ToDouble( locationElement.Element("lat").Value );
lon = Convert.ToDouble( locationElement.Element("lng").Value );
}
}
if (!String.IsNullOrEmpty(image.Description) && !String.IsNullOrEmpty(image.TripUserId) && f.InputStream != null)
{
var request = new PutObjectRequest()
{
BucketName = bucket,
CannedACL = S3CannedACL.PublicRead,
Key = string.Format(urlSuffix),
InputStream = f.InputStream
};
client.PutObject(request);
success = true;
}
}
catch (Exception ex)
{
success = false;
}
if (success)
{
TripAppEntities entities = new TripAppEntities();
var user = entities.TripUsers.Where(r => r.TripCode == image.TripUserId).FirstOrDefault();
var url = "https://s3.amazonaws.com/trip-app-pictures/" + urlSuffix;
TripPicture picture = new TripPicture();
picture.TripUserId = user.Id;
picture.Description = image.Description;
picture.Date = DateTime.Now;
picture.PictureUrl = url;
picture.LocationName = !image.UseCurrentLocation ? image.Location : null;
picture.Lat = lat;
picture.Lon = lon;
entities.TripPictures.Add(picture);
entities.SaveChanges();
}
return RedirectToAction("../Trip/Pictures/" + image.TripUserId);
}