コード例 #1
0
        public MainViewController(string connectionString)
        {
            booksRepo   = new BooksRepository(connectionString);
            readersRepo = new ReadersRepository(connectionString);
            authorsRepo = new AuthorsRepository(connectionString);


            CommandsHandler = new Dictionary <string, Func <MainViewArgs, object> >
            {
                #region booksCRUD
                {
                    "get_books",
                    x =>
                    {
                        string res = "";
                        foreach (var book in booksRepo.GetAllBooks())
                        {
                            res += (book.ToString() + "\n");
                        }
                        return(res);
                    }
                },
                {
                    "get_book",
                    x =>
                    {
                        return(booksRepo.GetBook(x.BookId).ToString());
                    }
                },
                {
                    "delete_book",
                    x =>
                    {
                        return(GetBooLReturnMessage(booksRepo.DeleteBook(x.BookId)));
                    }
                },
                {
                    "insert_book",
                    x =>
                    {
                        return(GetBooLReturnMessage(booksRepo.InsertBook(x.Book)));
                    }
                },
                {
                    "update_book",
                    x =>
                    {
                        return(GetBooLReturnMessage(booksRepo.UpdateBook(x.Book)));
                    }
                },
                #endregion
                #region booksAuthors
                {
                    "AddAuthorToBook",
                    x =>
                    {
                        return(GetBooLReturnMessage(booksRepo.AddAuthorToBook(x.AuthorId, x.BookId)));
                    }
                },
                {
                    "DeleteAuthorFromBook",
                    x =>
                    {
                        return(GetBooLReturnMessage(booksRepo.DeleteAuthorFromBook(x.AuthorId, x.BookId)));
                    }
                },
                {
                    "GetAuthorsOfBook",
                    x =>
                    {
                        string res = "";
                        foreach (var author in booksRepo.GetAuthorsOfBook(x.BookId))
                        {
                            res += (author.ToString() + "\n");
                        }
                        return(res);
                    }
                },
                #endregion
                #region booksReaders
                {
                    "AddReaderToBook",
                    x =>
                    {
                        return(GetBooLReturnMessage(booksRepo.AddReaderToBook(x.ReaderId, x.BookId)));
                    }
                },
                {
                    "DeleteReaderFromBook",
                    x =>
                    {
                        return(GetBooLReturnMessage(booksRepo.DeleteReaderFromBook(x.ReaderId, x.BookId)));
                    }
                },
                {
                    "GetReadersOfBook",
                    x =>
                    {
                        string res = "";
                        foreach (var reader in booksRepo.GetReadersOfBook(x.BookId))
                        {
                            res += (reader.ToString() + "\n");
                        }
                        return(res);
                    }
                },
                #endregion
                #region authorsCRUD
                {
                    "get_authors",
                    x =>
                    {
                        string res = "";
                        foreach (var author in authorsRepo.GetAllAuthors())
                        {
                            res += (author.ToString() + "\n");
                        }
                        return(res);
                    }
                },
                {
                    "get_author",
                    x =>
                    {
                        return(authorsRepo.GetAuthor(x.AuthorId).ToString());
                    }
                },
                {
                    "delete_author",
                    x =>
                    {
                        return(GetBooLReturnMessage(authorsRepo.DeleteAuthor(x.AuthorId)));
                    }
                },
                {
                    "insert_author",
                    x =>
                    {
                        return(GetBooLReturnMessage(authorsRepo.InsertAuthor(x.Author)));
                    }
                },
                {
                    "update_author",
                    x =>
                    {
                        return(GetBooLReturnMessage(authorsRepo.UpdateAuthor(x.Author)));
                    }
                },
                {
                    "get_authorsbooks",
                    x =>
                    {
                        string res = "";
                        foreach (var book in authorsRepo.GetAuthorsBooks(x.AuthorId))
                        {
                            res += (book.ToString() + "\n");
                        }
                        return(res);
                    }
                },
                #endregion
                #region readersCRUD
                {
                    "get_readers",
                    x =>
                    {
                        string res = "";
                        foreach (var reader in readersRepo.GetAllReaders())
                        {
                            res += (reader.ToString() + "\n");
                        }
                        return(res);
                    }
                },
                {
                    "get_reader",
                    x =>
                    {
                        return(readersRepo.GetReader(x.ReaderId).ToString());
                    }
                },
                {
                    "delete_reader",
                    x =>
                    {
                        return(GetBooLReturnMessage(readersRepo.DeleteReader(x.ReaderId)));
                    }
                },
                {
                    "insert_reader",
                    x =>
                    {
                        return(GetBooLReturnMessage(readersRepo.InsertReader(x.Reader)));
                    }
                },
                {
                    "update_reader",
                    x =>
                    {
                        return(GetBooLReturnMessage(readersRepo.UpdateReader(x.Reader)));
                    }
                },
                {
                    "get_readersbooks",
                    x =>
                    {
                        string res = "";
                        foreach (var book in readersRepo.GetReadersBooks(x.ReaderId))
                        {
                            res += (book.ToString() + "\n");
                        }
                        return(res);
                    }
                },
                #endregion
                {
                    "add_random_authors",
                    x =>
                    {
                        return(GetBooLReturnMessage(authorsRepo.AddRandomAuthorsToDB(x.RandomCount)));
                    }
                },
                {
                    "search_books",
                    x =>
                    {
                        string res = "";
                        foreach (var book in booksRepo.SearchBooks(x.SearchBookParameters.title, x.SearchBookParameters.minPagesCount, x.SearchBookParameters.maxPagesCount))
                        {
                            res += (book.ToString() + "\n");
                        }
                        return(res);
                    }
                },
                {
                    "search_authors",
                    x =>
                    {
                        string res = "";
                        foreach (var author in authorsRepo.SearchAuthors(x.SearchAuthorParameters.Signature, x.SearchAuthorParameters.Name, x.SearchAuthorParameters.MinDate))
                        {
                            res += (author.ToString() + "\n");
                        }
                        return(res);
                    }
                },
                {
                    "search_readers",
                    x =>
                    {
                        string res = "";
                        foreach (var reader in readersRepo.SearchReaders(x.SearchReaderParameters.Favouritegenre, x.SearchReaderParameters.Name, x.SearchReaderParameters.Surname))
                        {
                            res += (reader.ToString() + "\n");
                        }
                        return(res);
                    }
                },
            };
        }