#Video Rental Store
Commands separator ";"
1.0. Commands
- 1.1. Create Commands
--CreateCountry - params - Initials, Country Code.
--CreateTown - params - TownName, CountryId.
--CreateAddress - params - Street, PostalCode, TownID.
--CreateEmployee - params - First Name, Last Name, Salary, Manager Id.
--CreateManager - params - First Name, Last Name, Salary.
--CreateCustomer - params - First Name, Last Name, Birthdate MM/dd/YYYY.
--CreateFilm - params - Film Name, Summary, Release date MM/dd/YYYY.
--CreateFilmGenre - params - Genre.
--CreateFilmRating - params - Rating.
--CreateFilmStaff - params - First Name, Last Name, Birthdate MM/dd/YYYY, CountryId, Type.
--CreateStore - params - Store Name, AddressId.
--CreateStorage - params - Store Name, AddressId.
--CreateTarif - params - Tarif Name, Max number of days, Price.
--CreateLoan - params - StoreId, FilmId, CustomerId
- 1.2. List Commands
--ListAllCountries - no params
--CountryDetails - params - CountryId
--ListAllTowns - no params
--TownDetails - params - TownId
--ListAllAddresses - no params
--AddressDetails - params - AddressId
--ListAllEmployees - no params
--ListAllCustomers - no params
--ListAllStores - no params
--StoreDetails - params - StoreId
--ListAllStorages - no params
--StoragesDetails - params - StoreId
--ListAllTarifs - no params
--ListAllTarifsByType - params - Y/N (Active/Deactivated)
--TarifDetails - params - TarifId
--ListAllLoans - no params
- 1.3. Update Commands
--UpdateCountry - params - CountryId, Initials, Country Code.
--UpdateTown - params - TownId, TownName, CountryId.
--UpdateAddress - params - AddressId, Street, PostalCode, TownID.
--UpdateTarif - params - TarifId, Name, Price.
--EndLoan - params - LoanId.
- 1.4. Add Commands
--AddAwardToFilm - params - FilmName, Award.
--AddGenreToFilm - params - FilmName, Genre.
--AddRatingToFilm - params - FilmName, Rating.
--AddStoreEmployee - params - StoreId, EmployeeId.
--AddFilmQuantity - params - StorageId, Qunatity.
- 1.5. Remove Commands
--RemoveStoreEmployee - params - StoreId, EmployeeId.
--RemoveFilmQuantity - params - StorageId, Qunatity.
--RemoveTarif - params - TarifId.
- 1.6. Export to pdf
--ListAllAdressesToPdf - no params -
--ListAllCountriesToPdf - no params -
--ListAllCustomersToPdf - no params -
--ListAllEmployeesToPdf - no params -
--ListAllFilmsToPdf - no params -
--ListAllGenresToPdf - no params -
--ListAllLoansToPdf - no params -
--ListAllReviewsToPdf - no params -
--ListAllStoragesToPdf - no params -
--ListAllStoresToPdf - no params -
--ListAllTarifsToPdf - no params -
--ListAllTownsToPdf - no params -
- 1.7. Termination
--Exit
- 1.8. Enums
- 1.8.1 StaffType
Actor
Director
Writer
- 1.8.4 VideoFormat
CD
DVD
HDDVD
BluRay
BluRay3D
BluRay4K
VHS
- 1.8.1 StaffType