public ImageController(ImageRepository imageRepository, TagRepository tagRepository, AlbumsRepository albumsRepository, AlbumsImagesRepository albumsImagesRepository, IFileManager fileManager)
{
this.imageRepository = imageRepository;
this.tagRepository = tagRepository;
this.albumsRepository = albumsRepository;
this.albumsImagesRepository = albumsImagesRepository;
this.fileManager = fileManager;
}
public UtilityController(
UsersRepository usersRepository,
AlbumsRepository albumsRepository,
PhotosRepository photosRepository,
AlbumsService albumPreviewService
)
{
this._usersRepository = usersRepository;
this._albumsRepository = albumsRepository;
this._photosRepository = photosRepository;
this._albumPreviewService = albumPreviewService;
}
public UnitOfWork(AppDbContext dbContext)
{
_dbContext = dbContext;
Admins = new AdminsRepository(_dbContext);
Albums = new AlbumsRepository(_dbContext);
Messages = new MessagesRepository(_dbContext);
Photos = new PhotosRepository(_dbContext);
Sellers = new SellersRepository(_dbContext);
Users = new UsersRepository(_dbContext);
Reviews = new ReviewsRepository(_dbContext);
}
public AlbumsController(AlbumsRepository albumsRepository, INotificationService notificationService, IMemoryCache memoryCache)
{
this.albumsRepository = albumsRepository;
this.notificationService = notificationService;
_logger = logger;
this.memoryCache = memoryCache;
this.cacheEntryOptions = new MemoryCacheEntryOptions();
// set AbsoluteExpiration
//options.AbsoluteExpiration = DateTime.Now.AddMinutes(1);
// set SlidingExpiration
this.cacheEntryOptions.SlidingExpiration = TimeSpan.FromMinutes(10);
}
public void Task_Get_With_Relation_Return_Equal()
{
var factory = new ConnectionFactory();
var context = factory.CreateContextForSQLite();
for (int i = 1; i < 4; i++)
{
var album = new Albums()
{
AlbumId = i,
AlbumName = "Category " + i,
AlbumImagPath = "../Test/Image.png",
AlbumPrice = 1,
AlbumReleaseDate = DateTime.Now,
IsActive = true,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now,
CreatedBy = 1,
ModifiedBy = 1
};
context.Albums.Add(album);
}
for (int i = 1; i < 4; i++)
{
var albumRating = new AlbumRating()
{
AlbumRatingId = i,
AlbumId = 2,
AlbumRatingBy = i,
AlbumRatings = i,
IsActive = true,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now,
CreatedBy = 1,
ModifiedBy = 1
};
context.AlbumRating.Add(albumRating);
}
context.SaveChanges();
var albumsRepo = new AlbumsRepository(context);
var albumsService = new AlbumService(albumsRepo);
var result = albumsService.GetAlbumDetailsByAlbumId(2);
Assert.Equal(2, result.AlbumId);
}
public AlbumsService(
IMapper mapper,
UsersRepository usersRepository,
AlbumsRepository albumsRepository,
PhotosRepository photosRepository,
IOptions <ApplicationSettings> applicationSettings
)
{
this._mapper = mapper;
this._usersRepository = usersRepository;
this._albumsRepository = albumsRepository;
this._photosRepository = photosRepository;
this._applicationSettings = applicationSettings;
this._client = new MongoClient(this._applicationSettings.Value.MongoDbSettings.ConnectionString);
this._database = this._client.GetDatabase(this._applicationSettings.Value.MongoDbSettings.DatabaseName);
this._albumPreviewCollection = this._database.GetCollection <AlbumPreview>(this._applicationSettings.Value.MongoDbSettings.AlbumPreviewCollection);
}
public GalleryAlbumsController(AlbumsImagesRepository albumsImagesRepository, AlbumsRepository albumsRepository, ImageRepository imageRepository)
{
this.albumsImagesRepository = albumsImagesRepository;
this.albumsRepository = albumsRepository;
this.imageRepository = imageRepository;
}
public AlbumsCloud(AlbumsRepository albumsRepository)
{
this.albumsRepository = albumsRepository;
}
public PostsController(PostsRepository postsRepository, AlbumsRepository albumsRepository)
{
this.postsRepository = postsRepository;
this.albumsRepository = albumsRepository;
}
public AlbumsController(AlbumsRepository albumsRepository)
{
this.albumsRepository = albumsRepository;
}
public static void Main(string[] args)
{
// Connecting to database and pulling data
var musiciansRepository = new MusiciansRepository();
var albumsRepository = new AlbumsRepository();
var songsRepository = new SongsRepository();
var albumsSongsRepository = new AlbumsSongsRepository();
const string connectionString = "Data Source=(LocalDb)\\MSSQLLocalDB;Initial Catalog=Music;Integrated Security=true;MultipleActiveResultSets=true;";
using (var connection = new SqlConnection(connectionString))
{
musiciansRepository.AddList(connection.Query <Musician>("SELECT * FROM Musician").ToList());
albumsRepository.AddList(connection.Query <Album>("SELECT * FROM Album").ToList());
songsRepository.AddList(connection.Query <Song>("SELECT * FROM Song").ToList());
albumsSongsRepository.AddList(connection.Query <AlbumSong>("SELECT * FROM AlbumSong").ToList());
}
musiciansRepository.CreateRelations();
albumsRepository.CreateRelations();
// Task 1
NewTask("Task 1");
Console.WriteLine("All musicians ordered by name: ");
musiciansRepository.GetAll()
.OrderBy(musician => musician.Name)
.ToList()
.ForEach(musician => Console.WriteLine(musician.ToString()));
// Task 2
NewTask("Task 2");
Console.Write("Choose nationality (0-1): ");
var selectedNationality = (Nationalities)int.Parse(Console.ReadLine());
musiciansRepository.GetAll()
.Where(musician => musician.Nationality == selectedNationality)
.ToList()
.ForEach(musician => Console.WriteLine(musician.ToString()));
// Task 3
NewTask("Task 3");
var groupedAlbumsRepository = albumsRepository.GetAll()
.GroupBy(album => album.ReleaseDate.Year)
.ToList();
groupedAlbumsRepository.ForEach(albumGroup => {
Console.WriteLine($"{albumGroup.Key}:");
albumGroup.ToList().ForEach(album => Console.WriteLine(album.ToString()));
});
// Task 4
NewTask("Task 4");
Console.Write("Input album name: ");
var selectedText = Console.ReadLine();
Console.WriteLine("All albums containing selected text: ");
albumsRepository.GetAll()
.Where(album => selectedText != null && album.Name.Contains(selectedText))
.ToList()
.ForEach(album => Console.WriteLine(album.ToString()));
// Task 5
NewTask("Task 5");
Console.WriteLine("Duration of all albums: ");
albumsRepository.GetAll()
.ForEach(album => Console.WriteLine($"{album.Name}: {album.Duration() / 60} minutes and {album.Duration() % 60} seconds"));
// Task 6
NewTask("Task 6");
Console.Write("Input name of the song: ");
var selectedSong = Console.ReadLine();
var selectedSongAsSong = songsRepository.GetAll().FirstOrDefault(song => selectedSong != null && song.Name.Contains(selectedSong));
Console.WriteLine("All albums with selected song: ");
albumsRepository.GetAll()
.Where(album => album.SongsList.Contains(selectedSongAsSong))
.ToList()
.ForEach(album => Console.WriteLine(album.ToString()));
// Task 7
NewTask("Task 7");
Console.Write("Input musician name: ");
var selectedMusician = Console.ReadLine();
Console.Write("Input release year: ");
var selectedReleaseYear = int.Parse(Console.ReadLine());
albumsRepository.GetAll()
.Where(album => selectedMusician != null && (album.Musician.Name.Contains(selectedMusician) && album.ReleaseDate.Year > selectedReleaseYear))
.ToList()
.ForEach(album => album.SongsList.ForEach(song => Console.WriteLine(song.ToString())));
}
