public void AddComment(Comment comment) { using (var ctx = new MVCLabbEntities()) { comment.Id = Guid.NewGuid(); ctx.Comments.Add(comment); ctx.SaveChanges(); } }
public void AddAlbum(Album album) { using (var ctx = new MVCLabbEntities()) { album.Id = Guid.NewGuid(); ctx.Albums.Add(album); ctx.SaveChanges(); } }
public void DeletePhotoFromDB(Photo model) { using (var ctx = new MVCLabbEntities()) { var photoToDelete = ctx.Photos.FirstOrDefault(x => x.Id == model.Id); ctx.Photos.Remove(photoToDelete); ctx.SaveChanges(); } }
public void DeleteComment(Comment comment) { using (var ctx = new MVCLabbEntities()) { var commentDB = ctx.Comments.FirstOrDefault(x => x.Id == comment.Id); ctx.Comments.Remove(commentDB); ctx.SaveChanges(); } }
public void AddUser(User user) { user.Salt = CreateSalt(10); user.Password = GenerateSHA256Hash(user.Password, user.Salt); using (var ctx = new MVCLabbEntities()) { ctx.Users.Add(user); ctx.SaveChanges(); } }
public void DeleteAlbum(Album album) { using (var ctx = new MVCLabbEntities()) { var albumDB = ctx.Albums.FirstOrDefault(x => x.Id == album.Id); ctx.Albums.Remove(albumDB); ctx.SaveChanges(); } }
public void AddPhotoToDB(Photo photoToDB) { photoToDB.AlbumID = photoToDB.AlbumID == Guid.Empty ? null : photoToDB.AlbumID; using (var ctx = new MVCLabbEntities()) { ctx.Photos.Add(photoToDB); ctx.SaveChanges(); } }
public void UpdateAlbum(Album album) { using (var ctx = new MVCLabbEntities()) { var albumDB = ctx.Albums.FirstOrDefault(x => x.Id == album.Id); albumDB.Name = album.Name; albumDB.Description = album.Description; ctx.SaveChanges(); } }
public void UdaptePhoto(Photo photo) { photo.AlbumID = photo.AlbumID == Guid.Empty ? null : photo.AlbumID; using (var ctx = new MVCLabbEntities()) { var photoFromDb = ctx.Photos.FirstOrDefault(x => x.Id == photo.Id); photoFromDb.Name = photo.Name; photoFromDb.Description = photo.Description; photoFromDb.AlbumID = photo.AlbumID; ctx.SaveChanges(); } }
public void UpdateUser(User user) { using (var ctx = new MVCLabbEntities()) { User userFromDB = ctx.Users.Where(x => x.Id == user.Id).FirstOrDefault(); userFromDB.Name = user.Name; userFromDB.Country = user.Country; userFromDB.Email = user.Email; if (userFromDB.Password != user.Password) { var salt = CreateSalt(10); var password = GenerateSHA256Hash(user.Password, salt); userFromDB.Salt = salt; userFromDB.Password = password; } ctx.SaveChanges(); } }