Movie Quotes

in this project i will try to make personal copy of playphrase.me and see how it could be work.

i will use this copy of application to improve my languages and learning English/German languages (search for idioms or some specific word in movies)

Screen Shoot from app

Main Idea

in this application there is two main section

1. population section: we provide a video file (.mp4) along it's subtitle file (.srt) and the application will save them to database.
2. Search section: search for phrase/word in our database and then play it on the screen.
3. watch section: Watch the movie and save clips that have new terms and revision it latter.

Installation

1. we need to setup SqlServer and get a connection string to database similar to the following

   Server=localhost;Database=MovieQuotesDb;Trusted_Connection=True;TrustServerCertificate=True
   

2. update your connection string in AppSetting in api project and in the UI Project
3. open Terminal and install Entity Framework Core tools dotnet tool install --global dotnet-ef
4. Navigate your Terminal to the location .\Src\MovieQuotes.Infrastructure\ and write the following command

   dotnet ef database update -s ..\MovieQuotes.Api\MovieQuotes.Api.csproj
   

   which will create the database as following
5. Run the desktop application and populate the database

   dotnet run --project .\Src\MovieQuotes.UI\MovieQuotes.UI.csproj