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