public ViewResult Create()
{
ViewBag.Types = new SelectList(_typeService.GetAllTypes(), "Id", "Name");
ViewBag.Genres = new MultiSelectList(_genreService.GetAllGenres(), "Id", "Name");
ViewBag.Languages = new SelectList(_languageService.GetAllLanguages(), "Id", "Description");
var authors = _authorService.GetAllAuthors().Select(author => new AuthorViewModel
{
Id = author.Id,
FullName = author.Id + "-" + author.FirstName + " " + author.LastName
});
ViewBag.Authors = new SelectList(authors, "Id", "FullName");
return(View());
}
public IHttpActionResult Get()
{
GenreService genreService = CreateGenreService();
var genres = genreService.GetAllGenres();
return(Ok(genres));
}
public void GetGenresTest()
{
int expectedCount = 3;
GenreService service = new GenreService(_genreRepository);
List <Genre> artists = service.GetAllGenres();
Assert.AreEqual(expectedCount, artists.Count);
}
public void GetAllGenres_ShouldReturnAllGenresWhenNoParameters()
{
// Act
_genreRepository.Setup(g => g.GetMany(0, int.MaxValue, null, null, It.IsAny <SortDirection>(), It.IsAny <Expression <Func <Genre, object> >[]>())).Returns(_genres);
var result = _genreService.GetAllGenres();
// Assert
Assert.Equal(result.Count(), _genres.Count());
}
//DropDownList:Select Genre
public ActionResult Select()
{
//populate the viewbag with a list of genres
var genre = genreService.GetAllGenres();
ViewBag.Genre = genre.Select(s => new SelectListItem {
Value = s.Id.ToString(), Text = s.Name
});
return(View());
}
public ActionResult Genre()
{
//ViewBag of Genres
var genres = genreService.GetAllGenres();
ViewBag.Genres = genres.Select(s => new SelectListItem {
Value = s.Id.ToString(), Text = s.Name
});
return(View());
}
// GET: Genre
public ActionResult Index()
{
var userId = Guid.Parse(User.Identity.GetUserId());
var service = new GenreService(userId);
var model = service.GetAllGenres();
//List<Genre> genreList = _service.Genres.ToList();
//List<Genre> orderedList = (List<Genre>)genreList.OrderBy(alpha => alpha.GenreName);
return(View(model));
}
public IActionResult Details(int?id)
{
GenreService GenreSer = new GenreService();
//BookService bookSer = new BookService();
ViewBag.Categories = GenreSer.GetAllGenres();
BookRepository bookRepo = new BookRepository();
//Use shortbookview for when you just need a quick overview of a book
//For example when listing lots of books.
var books = bookRepo.GetShortBooksForGenre(id.GetValueOrDefault());
//var BookDetails = bookSer.GetAllBooksByID(id);
ViewBag.Books = books;
ViewBag.PageTitle = GenreSer.GetGenreNameByID(id);
return(View());
}
public void AddGenreTest()
{
int expectedCount = 4;
Genre genre = new Genre()
{
id = 4,
name = "Trance"
};
GenreService service = new GenreService(_genreRepository);
service.AddGenre(genre);
List <Genre> genres = service.GetAllGenres();
Assert.AreEqual(expectedCount, genres.Count);
}
public IActionResult Index()
{
//Quick test
/*BookRepository bookRepo = new BookRepository();
* List<BookView> books = bookRepo.GetDetailedBookView();
* books[0].Price = 100;
* books[0].ISBN = "penis";
* bookRepo.EditBook(books[0]);
* var books2 = bookRepo.GetAllBooksShortView();
*
* return View(books2);*/
GenreService GenreSer = new GenreService();
BookService BookSer = new BookService();
ViewBag.Categories = GenreSer.GetAllGenres();
ViewBag.NewestThree = BookSer.GetFirstThreeBooks();
//TestData();
return(View());
}
public void ReturnAllGenresFromRepository()
{
// Arrange
var genreMock = new Mock <Genre>();
var genreRepositoryMock = new Mock <IRepository <Genre> >();
var genreService = new GenreService(genreRepositoryMock.Object);
ICollection <Genre> genresFromRepository = new List <Genre>();
genresFromRepository.Add(genreMock.Object);
genreRepositoryMock.Setup(gr => gr.GetAll())
.Returns(genresFromRepository);
// Act
var genres = genreService.GetAllGenres();
// Assert
Assert.AreEqual(genres.Count(), genresFromRepository.Count);
CollectionAssert.Contains(genres, genreMock.Object);
}
static void Main(string[] args)
{
using (var db = new MovieShopDbContext())
{
//var genres = db.Genres.ToList();
//var movies = db.Movies.Where(m => m.Title.StartsWith("a")).ToList();
//var movies = db.Movies.ToList().Where(m => m.Title.StartsWith("A")).ToList();
var movieService = new MovieService();
var movie = movieService.GetMovieDetails(2);
Console.WriteLine(movie.Id + " " + movie.Title);
var movies = movieService.GetMoviesByGenre(4);
Console.WriteLine(movies.Count());
movies = movieService.GetMoviesByTitle("abc", 1);
Console.WriteLine(movies.Count());
movies = movieService.GetTopRatedMovies();
Console.WriteLine(movies.Count());
movies = movieService.GetTopGrossingMovies();
Console.WriteLine(movies.Count());
var genreService = new GenreService();
var genres = genreService.GetAllGenres();
Console.WriteLine(genres.Count());
var castService = new CastService();
var cast = castService.GetCastDetails(3);
Console.WriteLine(cast.Name + " " + cast.MovieCasts.Count());
var crewService = new CrewService();
var crew = crewService.GetCrewDetails(3);
Console.WriteLine(crew.Name + " " + crew.MovieCrews.Count());
Console.ReadKey();
}
}
public void ReturnTheRightCount_OfGenres()
{
// Arrange
var context = new Mock <IMusicLibraryContext>();
var mockedBaseContext = new Mock <IMusicLibraryBaseContext>();
var mockedGenreFactory = new Mock <IGenreFactory>();
var genres = GetGenres();
var expectedResult = genres.OrderBy(x => x.GenreName).AsQueryable();
var genresSetMock = QueryableDbSetMock.GetQueryableMockDbSet(genres);
context.Setup(x => x.Genres).Returns(genresSetMock);
GenreService genreService = new GenreService(context.Object, mockedBaseContext.Object, mockedGenreFactory.Object);
// Act
var actualResult = genreService.GetAllGenres();
// Assert
Assert.That(expectedResult.ToList().Count() == actualResult.Count());
}
public void ReturnsACollection_WithInstancesOfGenre()
{
// Arrange
var context = new Mock <IMusicLibraryContext>();
var mockedBaseContext = new Mock <IMusicLibraryBaseContext>();
var mockedGenreFactory = new Mock <IGenreFactory>();
var genres = GetGenres();
var expectedResult = genres.OrderBy(x => x.GenreName).AsQueryable();
var genresSetMock = QueryableDbSetMock.GetQueryableMockDbSet(genres);
context.Setup(x => x.Genres).Returns(genresSetMock);
GenreService genreService = new GenreService(context.Object, mockedBaseContext.Object, mockedGenreFactory.Object);
// Act
var actualResult = genreService.GetAllGenres();
// Assert
CollectionAssert.AllItemsAreInstancesOfType(actualResult, typeof(Genre));
}
static void Main(string[] args)
{
GenreService genreService = new GenreService();
BookService bookService = new BookService();
GenreHelper genreHelper = new GenreHelper();
BookHelper bookHelper = new BookHelper();
string[] idAndPass = HelperMethods.ReadLinesFromFile();
string id = idAndPass[0];
string password = idAndPass[1];
string connString = "Server=127.0.0.1;port=5433;User Id=" + id + ";Password="******";Database=BookGenre;";
do
{
Console.Clear();
Console.WriteLine("1 - Kitap Listele");
Console.WriteLine("2 - Kitap Sil");
Console.WriteLine("3 - Kitap Ekle");
Console.WriteLine("4 - Kitap Güncelle");
Console.WriteLine("5 - Tür Listele");
Console.WriteLine("6 - Tür Sil");
Console.WriteLine("7 - Tür Ekle");
Console.WriteLine("8 - Tür Güncelle");
Console.WriteLine("0 - Çıkış");
var userSelection = Console.ReadKey();
if (userSelection.Key == ConsoleKey.D1)
{
var books = bookService.GetAllBooks(connString);
bookHelper.ListBooks(books);
var willBeDeletedBookId = Console.ReadLine().ToInt();
}
else if (userSelection.Key == ConsoleKey.D2)
{
var idCheckBook = false;
var willBeDeletedBookId = 0;
do
{
Console.WriteLine("Choose a book for delete");
var books = bookService.GetAllBooks(connString);
bookHelper.ListBooks(books);
willBeDeletedBookId = Console.ReadLine().ToInt();
idCheckBook = HelperMethods.IsThereBookId(willBeDeletedBookId, books);
if (idCheckBook == true)
{
Console.WriteLine("Non ID you have chosen !");
Console.WriteLine("Please try again.");
}
}while (idCheckBook);
bookService.DeleteBook(willBeDeletedBookId, connString);
Console.WriteLine("The Book you choose has been deleted !");
}
else if (userSelection.Key == ConsoleKey.D3)
{
Console.WriteLine("Enter Book Genre");
Console.WriteLine("");
var genres = genreService.GetAllGenres(connString);
genreHelper.ListGenres(genres);
var newBookGenreId = Console.ReadLine().ToInt();
Console.WriteLine("Enter Book Title");
var newBookTitle = Console.ReadLine();
Console.WriteLine("Enter Author Name");
var newAuthor = Console.ReadLine();
bookService.AddBook(newBookGenreId, newBookTitle, newAuthor, connString);
Console.WriteLine("New Book Added !");
}
else if (userSelection.Key == ConsoleKey.D4)
{
bool idCheckBook = false;
var willBeUpdatedBookId = 0;
do
{
Console.WriteLine("Choose a book for update");
var books = bookService.GetAllBooks(connString);
bookHelper.ListBooks(books);
willBeUpdatedBookId = Console.ReadLine().ToInt();
idCheckBook = HelperMethods.IsThereBookId(willBeUpdatedBookId, books);
if (idCheckBook == true)
{
Console.WriteLine("Non ID you have chosen !");
Console.WriteLine("Please try again.");
}
}while (idCheckBook);
bool idCheckGenre = false;
var willBeUpdatedGenreId = 0;
do
{
Console.WriteLine("Choose a genre");
var genres = genreService.GetAllGenres(connString);
genreHelper.ListGenres(genres);
willBeUpdatedGenreId = Console.ReadLine().ToInt();
idCheckGenre = HelperMethods.IsThereGenreId(willBeUpdatedGenreId, genres);
if (idCheckGenre == false)
{
Console.WriteLine("Non ID you have chosen !");
Console.WriteLine("Please try again.");
}
}while (idCheckGenre);
Console.WriteLine("Enter new title");
var newTitle = Console.ReadLine();
Console.WriteLine("Enter new author");
var newAuthor = Console.ReadLine();
bookService.UpdateBook(willBeUpdatedBookId, willBeUpdatedGenreId, newTitle, newAuthor, connString);
Console.WriteLine("Update has been done successfully !");
}
else if (userSelection.Key == ConsoleKey.D5)
{
var genres = genreService.GetAllGenres(connString);
genreHelper.ListGenres(genres);
}
else if (userSelection.Key == ConsoleKey.D6)
{
var idCheckGenre = false;
var canBeDeleted = false;
var willBeDeletedGenreId = 0;
do
{
Console.WriteLine("Choose a genre for delete");
var genres = genreService.GetAllGenres(connString);
genreHelper.ListGenres(genres);
willBeDeletedGenreId = Console.ReadLine().ToInt();
idCheckGenre = HelperMethods.IsThereGenreId(willBeDeletedGenreId, genres);
if (idCheckGenre == true)
{
Console.WriteLine("Non ID you have chosen !");
Console.WriteLine("Please try again.");
}
canBeDeleted = HelperMethods.CanBeDeleted(willBeDeletedGenreId, connString);
if (canBeDeleted == false)
{
Console.WriteLine("The Genre you selected could not be deleted because there are books of that genre");
Console.WriteLine("Please try again!");
}
}while (idCheckGenre || !canBeDeleted);
genreService.DeleteGenre(willBeDeletedGenreId, connString);
Console.WriteLine("The Genre you choose has been deleted !");
}
else if (userSelection.Key == ConsoleKey.D7)
{
Console.WriteLine("Enter Genre Name");
var newGenreName = Console.ReadLine();
genreService.AddGenre(newGenreName, connString);
Console.WriteLine("New Genre Added !");
}
else if (userSelection.Key == ConsoleKey.D8)
{
bool idCheckGenre = false;
var willBeUpdatedGenreId = 0;
do
{
Console.WriteLine("Choose a genre for update");
var genres = genreService.GetAllGenres(connString);
genreHelper.ListGenres(genres);
willBeUpdatedGenreId = Console.ReadLine().ToInt();
idCheckGenre = HelperMethods.IsThereGenreId(willBeUpdatedGenreId, genres);
if (idCheckGenre == true)
{
Console.WriteLine("Non ID you have chosen !");
Console.WriteLine("Please try again.");
}
}while (idCheckGenre);
Console.WriteLine("Enter a genre name");
var genresNewName = Console.ReadLine();
genreService.UpdateGenre(willBeUpdatedGenreId, genresNewName, connString);
Console.WriteLine("Update has been done successfully !");
}
Console.ReadKey();
}while (true);
}
public IHttpActionResult Get()
{
var genres = _service.GetAllGenres();
return(Ok(genres));
}
public async Task <List <GenreDTO> > Get()
{
return(await genreService.GetAllGenres());
}
public ActionResult Index()
{
var genre = genreService.GetAllGenres();
return(View(genre));
}
