public async Task <IHttpActionResult> GetPlaceDates(string place) { var photos = from photo in db.Photos join buyPhoto in db.PhotoBuyHistories on photo.Id equals buyPhoto.PhotoId into o from buyPhoto in o.DefaultIfEmpty() where photo.Valid == true && photo.Expired == false && buyPhoto.UserId == null && photo.Place == place select photo; List <string> dateStrings = new List <string>(); List <PhotoDate> dates = new List <PhotoDate>(); foreach (var photo in photos) { dateStrings.Add(photo.Date.ToString("yyyyMMdd")); } foreach (string dateString in dateStrings.Distinct()) { PhotoDate photoDate = new PhotoDate(); photoDate.DateString = dateString; dates.Add(photoDate); } return(Ok(dates.Distinct().OrderByDescending(photoDate => photoDate.DateString))); }
public IActionResult Add(AddDateViewModel addCategoryViewModel) { if (ModelState.IsValid) { PhotoDate newDate = new PhotoDate { DateTime = addCategoryViewModel.DateTime }; context.Dates.Add(newDate); context.SaveChanges(); return(Redirect("/Date")); } return(View(addCategoryViewModel)); }
public IActionResult Date(int id) { if (id == 0) { return(Redirect("/Date")); } PhotoDate theDate = context.Dates .Include(cat => cat.Photos) .Single(cat => cat.ID == id); ViewBag.title = "Photos on this date: " + theDate.DateTime; return(View("Index", theDate.Photos)); }
// [HttpPost] // public IActionResult Add(AddFieldViewModel addFieldViewModel) // if (ModelState.IsValid) // { // PhotoField newField = new PhotoField // { // Name = addFieldViewModel.Name // }; // context.Photos.Add(newField); // context.SaveChanges(); // return Redirect("/Photo"); //} public IActionResult Edit(int photoId) { AddEditPhotoViewModel addEditPhotoViewModel = new AddEditPhotoViewModel(context.Dates.ToList()); Photo photo = context.Photos.Single(c => c.ID == photoId); PhotoDate newPhotoDate = context.Dates.Single(c => c.ID == photo.DateID); addEditPhotoViewModel.PhotoId = photo.ID; addEditPhotoViewModel.Name = photo.Name; addEditPhotoViewModel.FocalLength = photo.FocalLength; addEditPhotoViewModel.DateID = photo.Date.ID; addEditPhotoViewModel.Iso = photo.ISO; addEditPhotoViewModel.Shutterspeed = photo.ShutterSpeed; return(View(addEditPhotoViewModel)); }
public IActionResult Edit(AddEditPhotoViewModel addEditPhotoViewModel) { var id = context.Photos.FirstOrDefault(c => c.ID == addEditPhotoViewModel.PhotoId); PhotoDate newPhotoDate = context.Dates.Single(c => c.ID == addEditPhotoViewModel.DateID); if (id != null) { id.Name = addEditPhotoViewModel.Name; id.FocalLength = addEditPhotoViewModel.FocalLength; id.Date = newPhotoDate; id.ISO = addEditPhotoViewModel.Iso; id.ShutterSpeed = addEditPhotoViewModel.Shutterspeed; context.Photos.Update(id); context.SaveChanges(); } return(Redirect("/")); }
public IActionResult Add(AddPhotoViewModel addPhotoViewModel) { if (ModelState.IsValid) { PhotoDate newPhotoDate = context.Dates.Single(c => c.ID == addPhotoViewModel.DateID); Photo newPhoto = new Photo { Name = addPhotoViewModel.Name, FocalLength = addPhotoViewModel.FocalLength, Date = newPhotoDate, ShutterSpeed = addPhotoViewModel.Shutterspeed, ISO = addPhotoViewModel.Iso }; context.Photos.Add(newPhoto); context.SaveChanges(); return(Redirect("/Photo")); } return(View(addPhotoViewModel)); }