// current user update album title // return -1 if fail // return 0 if success public static int EditAlbumTitle(AlbumDTO albumEdit) { using (var context = new CF_FamsamEntities()) { var post = context.GeneralPost.FirstOrDefault(p => p.Id == albumEdit.Id); post.lastUpdate = DateTime.Now; var album = context.Album.FirstOrDefault(a => a.id == albumEdit.Id); album.title = albumEdit.Title; try { context.Entry<Album>(album).State = EntityState.Modified; context.Entry<GeneralPost>(post).State = EntityState.Modified; context.SaveChanges(); } catch (Exception ex) { Debug.WriteLine("Exception: " + ex.StackTrace); return -1; } return 0; } }
// current user update album title // return -1 if fail // return 0 if success public static int EditAlbum(AlbumDTO albumEdit, List<PhotoDTO> listPhotoAdd, List<PhotoDTO> listPhotoRemove) { using (var context = new CF_FamsamEntities()) { var post = context.GeneralPost.FirstOrDefault(p => p.Id == albumEdit.Id); var album = post.Album; post.lastUpdate = DateTime.Now; album.title = albumEdit.Title; post.description = albumEdit.Description; try { // add new list of photos to album if (listPhotoAdd.Count > 0) { foreach (var newPhoto in listPhotoAdd) { album.Photo.Add(context.Photo.FirstOrDefault(p => p.id == newPhoto.Id)); } } // remove list of photos from album if (listPhotoRemove.Count > 0) { foreach (var removePhoto in listPhotoRemove) { album.Photo.Remove(context.Photo.FirstOrDefault(p => p.id == removePhoto.Id)); } } context.Entry<Album>(album).State = EntityState.Modified; context.Entry<GeneralPost>(post).State = EntityState.Modified; context.SaveChanges(); } catch (Exception ex) { Debug.WriteLine("Exception: " + ex.StackTrace); return -1; } return 0; } }
/// <summary> /// Update photo /// </summary> /// <param name="photo"></param> /// <returns></returns> public static int EditDescription(PhotoDTO photoDTO) { using (var db = new CF_FamsamEntities()) { Photo photo = db.Photo.Find(photoDTO.Id); if (photo == null) return -1; //update photo DateTime lastUpdate = DateTime.Now; photo.Post.lastUpdate = lastUpdate; photo.Post.description = photoDTO.Description; try { db.Entry(photo).State = EntityState.Modified; db.SaveChanges(); return 1; } catch (Exception ex) { Debug.WriteLine("Exception on Edit photo description:" + ex.ToString()); } } return 0; }