public void DeleteMedia_BadMediaIdProvided_ThrowArgumentException() { var connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=MediaLibrary;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; using (var connection = new SqlConnection(connectionString)) { //ARRANGE var repository = new MediaRepository(connection); //ACT //ASSERT Assert.ThrowsException <ArgumentException>(() => repository.Delete(0)); Assert.ThrowsException <ArgumentException>(() => repository.Delete(-1)); } }
public void WhenIDeleteAMedium_ThenItIsDeleted() { Media retrievedMedia = _mediaRepository.GetMedia(2012, 12, 18, "TestImage1"); _mediaRepository.Delete(retrievedMedia); Media deletedMedia = _mediaRepository.GetMedia(retrievedMedia.Id); Assert.That(deletedMedia, Is.Null); }
public void Delete_NonExisting_ExceptionThrown() { MediaRepository Repository = new MediaRepository(helper); Media media = new Media() { ID = Guid.NewGuid(), MediaData = "Update", RelationID = this.TestMedia2.RelationID }; Repository.Delete(media); Assert.IsNull(Repository.GetByID(media.ID)); }
//For this test, check whether the database contains at least one row before running public void DeleteMedia_CorrectMediaIdProvided_ReturnTrue() { var connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=MediaLibrary;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; using (var connection = new SqlConnection(connectionString)) { //ARRANGE var repository = new MediaRepository(connection); var media = repository.GetAll().Last(); //ACT var result = repository.Delete(media.Id); //ASSERT Assert.IsTrue(result); } }
/// <summary> /// Here we do all the business /// </summary> /// <param name="obj"></param> public void DeleteCfProfileAndRelatedData(Profile u) { //-- Delete any personality media var pMediaRepo = new UserPersonalityMediaRepository(); var mediaRepo = new MediaRepository(); var mediaOpinionRepo = new MediaOpinionRepository(); var opinionRepo = new OpinionRepository(); var ciRepo = new CheckInRepository(); var pcRepo = new PartnerCallRepository(); var postRepo = new PostRepository(); var clmRepo = new ClimbRepository(); mediaOpinionRepo.Delete(mediaOpinionRepo.GetAll().Where(mo => mo.UserID == u.ID).Select(mo => mo.ID)); opinionRepo.Delete(opinionRepo.GetAll().Where(o => o.UserID == u.ID).Select(o => o.ID)); postRepo.Delete(postRepo.GetAll().Where(p => p.UserID == u.ID).Select(p => p.ID)); //-- Delete personality media mediaRepo.Delete(pMediaRepo.GetAll().Where(pm => pm.UserID == u.ID).Select(pm => pm.MediaID)); //-- Get other media, e.g. stuff uploaded for places & climbs //-- Remove all the personal tags mediaRepo.RemoveAllMediaTagForObject(u.ID); var otherMedia = mediaRepo.GetAll().Where(pm => pm.AddedByUserID == u.ID); foreach (var m in otherMedia) { m.AddedByUserID = Stgs.SystemID; } mediaRepo.Update(otherMedia); ciRepo.Delete(ciRepo.GetAll().Where(ci => ci.UserID == u.ID).Select(ci => ci.ID)); pcRepo.Delete(pcRepo.GetAll().Where(pc => pc.UserID == u.ID).Select(pc => pc.ID)); //-- geo problems , e.g. a user ads a area, location or climb or is listed as a setter var usersSetClimbs = clmRepo.GetAll().Where(c => c.SetterID == u.ID); foreach (var c in usersSetClimbs) { c.SetterID = null; } clmRepo.Update(usersSetClimbs); //-- If everything else has been removed this should work.... profileRepo.Delete(u.ID); }
public IHttpActionResult Delete(Guid id) { try { var video = _mediaRepository.GetById(id); var physicalFile = HttpContext.Current.Server.MapPath(video.Url); File.Delete(physicalFile); _mediaRepository.Delete(id); return(Ok(id)); } catch (Exception) { throw; } }
public void DeleteMedia() { // Arrange IScopeProvider provider = ScopeProvider; using (IScope scope = provider.CreateScope()) { MediaRepository repository = CreateRepository(provider, out MediaTypeRepository mediaTypeRepository); // Act IMedia media = repository.Get(_testFile.Id); repository.Delete(media); IMedia deleted = repository.Get(_testFile.Id); bool exists = repository.Exists(_testFile.Id); // Assert Assert.That(deleted, Is.Null); Assert.That(exists, Is.False); } }
public void Delete_NullEntity_ExceptionThrown() { MediaRepository Repository = new MediaRepository(helper); Repository.Delete(null); }