/VideoRentalSystem

generic video store db system 2017

Primary LanguageC#MIT LicenseMIT

#Video Rental Store

IMAGE ALT TEXT HERE

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