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));
}
