public static Guid GetUserId(string name)
{
using (var db = new PhotoExplorationContext())
{
return(db.Users.Single(x => x.Name == name).Id);
}
}
public static string GetUserName(Guid id)
{
using (var db = new PhotoExplorationContext())
{
return(db.Users.Single(x => x.Id == id).Name);
}
}
public ActionResult DeleteComment(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var db = new PhotoExplorationContext())
{
var comment = db.Comments.Include(i => i.Photo).FirstOrDefault(x => x.Id == id);
if (comment == null)
{
return(HttpNotFound());
}
var viewComment = new CommentViewModel
{
Id = comment.Id,
Commenter = comment.User.Name,
Date = comment.Date,
PhotoName = comment.Photo.Name,
Comment = comment.Text
};
return(View(viewComment));
}
}
public static User GetUserByCredentials(string email, string password)
{
using (var db = new PhotoExplorationContext())
{
return(db.Users.FirstOrDefault(x => x.Email == email && x.Password == password));
}
}
public static List <Album> GetAlbumsByUserId(Guid id)
{
using (var db = new PhotoExplorationContext())
{
return(db.Albums.Where(x => x.UserId == id).ToList());
}
}
public IEnumerable <Album> GetItems()
{
using (var db = new PhotoExplorationContext())
{
return(db.Albums.Include("User").Include("Photos").ToList());
}
}
public IEnumerable <Photo> GetItems()
{
using (var db = new PhotoExplorationContext())
{
return(db.Photos.Include("Comments").Include("Album").Include("User").ToList());
}
}
public void Add(Album item)
{
using (var db = new PhotoExplorationContext())
{
db.Albums.Add(item);
db.SaveChanges();
}
}
public Photo FindById(Guid id)
{
using (var db = new PhotoExplorationContext())
{
var photo = db.Photos.Include("User").Include("Comments").Include("Album").FirstOrDefault(x => x.Id == id);
if (photo != null)
{
photo.Comments = db.Comments.Include("User").Where(x => x.PhotoId == photo.Id)?.ToList();
}
return(photo);
}
}
public void Add(User item)
{
using (var db = new PhotoExplorationContext())
{
db.Users.Add(new User
{
Id = item.Id,
Email = item.Email,
Name = item.Name,
Password = item.Password,
Admin = false
});
db.SaveChanges();
}
}
public void Add(Comment item)
{
using (var db = new PhotoExplorationContext())
{
db.Comments.Add(new Comment
{
Id = item.Id,
Text = item.Text,
Date = item.Date,
PhotoId = item.PhotoId,
UserId = item.UserId
});
db.SaveChanges();
}
}
public ActionResult DeleteCommentConfirmed(Guid id)
{
using (var db = new PhotoExplorationContext())
{
var comment = db.Comments.Include(i => i.Photo).FirstOrDefault(x => x.Id == id);
if (comment == null)
{
return(new HttpNotFoundResult());
}
db.Comments.Remove(comment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public Album FindById(Guid id)
{
using (var db = new PhotoExplorationContext())
{
var album = db.Albums.Include("User").Include("Photos").FirstOrDefault(x => x.Id == id);
if (album != null)
{
album.Photos =
db.Photos.Include("User")
.Include("Album")
.Include("Comments")
.Where(x => x.AlbumId == album.Id)
.ToList();
}
return(album);
}
}
// GET: Administration/Management
public ActionResult Index()
{
using (var db = new PhotoExplorationContext())
{
//var userId = User.Identity.GetUserId<Guid>();
//var comments = db.Comments.Include(i => i.Photo);
var data = new IndexViewModel();
db.Albums.ToList().ForEach(x => data.AlbumViewModels.Add(new AlbumViewModel
{
Id = x.Id,
Name = x.Name,
}));
db.Comments.Include("User").Include("Photo").ToList().ForEach(x => data.CommentViewModels.Add(new CommentViewModel
{
Id = x.Id,
Commenter = x.User.Name,
Comment = x.Text,
Date = x.Date,
PhotoName = x.Photo.Name
}));
db.Photos.Include("User").Include("Album").ToList().ForEach(x => data.PhotoViewModels.Add(new PhotoViewModel
{
Id = x.Id,
Name = x.Name,
FileName = x.FileName,
Album = x.Album.Name,
Uploader = x.User.Name,
Description = x.Description,
DateAdded = x.DateAdded
}));
db.Users.ToList().ForEach(x => data.UserViewModels.Add(new UserViewModel
{
Id = x.Id,
Name = x.Name,
Email = x.Email,
}));
return(View(data));
}
}
public static Photo GetLastUploadedPhoto()
{
using (var db = new PhotoExplorationContext())
{
var photo =
db.Photos.Include("User")
.Include("Comments")
.Include("Album")
.OrderByDescending(x => x.DateAdded)
.FirstOrDefault();
if (photo != null)
{
photo.Comments = db.Comments.Include("User").Where(x => x.PhotoId == photo.Id).ToList();
}
return(photo);
}
}
