public void UpdateMedia_CorrectMediaIdProvided_ReturnUpdatedMedia()
{
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 = new MediaLibrary.DAL.Entities.Media
{
Name = "Use of Flexbox",
Url = @"C:\Users\Ambroise\Desktop\UNamur",
Path = @"C:\Users\Ambroise\Desktop\UNamur",
Type = MediaType.Film,
Done = true
};
var addedMedia = repository.Insert(media);
var retrievedMedia = repository.GetAll().FirstOrDefault(m => m.Name.Equals(media.Name));
retrievedMedia.Name = "New name";
//ACT
var result = repository.Update(retrievedMedia);
//ASSERT
Assert.IsNotNull(result);
Assert.AreEqual("New name", result.Name);
}
}
public void UpdateMedia_MediaProvidedWithBadId_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);
var media = new MediaLibrary.DAL.Entities.Media
{
Name = "Use of Flexbox",
Url = @"C:\Users\Ambroise\Desktop\UNamur",
Path = @"C:\Users\Ambroise\Desktop\UNamur",
Type = MediaType.Film,
Done = true
};
var addedMedia = repository.Insert(media);
var retrievedMedia = repository.GetAll().FirstOrDefault(m => m.Name.Equals(media.Name));
retrievedMedia.Id = 0;
//ACT
//ASSERT
Assert.ThrowsException <ArgumentException>(() => repository.Update(retrievedMedia));
}
}
public MediaLibrary.DAL.Entities.Media InsertMedia(MediaLibrary.DAL.Entities.Media media)
{
if (media is null)
{
throw new ArgumentNullException();
}
try
{
var result = unitOfWork.MediaRepository.Insert(media);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public void AddMedia_CorrectMediaProvided_ReturnAddedMedia()
{
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 = new MediaLibrary.DAL.Entities.Media
{
Name = "Programming in C#",
Url = @"C:\Users\Ambroise\Desktop\UNamur",
Path = @"C:\Users\Ambroise\Desktop\UNamur",
Type = MediaType.Book,
Done = true
};
//ACT
var result = repository.Insert(media);
//ASSERT
Assert.IsNotNull(result);
Assert.AreEqual("Programming in C#", result.Name);
}
}
