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