FTA-API

Provides APIs for user authentication and authorization, including login, registration, profile updates, and password changes.

Tracks failed login attempts for a given IP and email, blocks them after 5 attempts, and alerts admin.

Checks if an IP and email are blocked.

Clears failed login attempts for a given IP and email.

Unblocks a user or IP manually by an admin.

Registers a new user in the system.

This endpoint creates a new user account with the provided username, email, password, and optional company assignment. Upon successful registration, the endpoint returns a JSON Web Token (JWT) for authentication and authorization purposes. An object containing the user registration details: Username: The desired username for the new account. Email: The user's email address. Password: The password for the new account. CompanyId: (Optional) The ID of the company to assign the user to. A response containing the JWT token and user details (user ID, username, email, and role) upon successful registration. If the registration fails due to invalid input or errors, an appropriate error message is returned. The user was successfully registered, and a JWT token was generated. Invalid registration details or user creation failed. An internal error occurred while processing the request.

Authenticates a user and returns a JSON Web Token (JWT) for secure access.

This endpoint verifies the provided username and password against the stored credentials. Upon successful authentication, it generates a JWT token that can be used for accessing protected resources. An object containing the login credentials: Username: The user's username. Password: The user's password. A response containing the JWT token and user details (user ID, username, email) upon successful login. If authentication fails, an error message is returned. The user was successfully authenticated, and a JWT token was generated. Invalid input data was provided. Authentication failed due to incorrect credentials. An internal error occurred while processing the request.

Updates the authenticated user's profile information.

This endpoint allows authenticated users to update their profile details, such as username and email. The user must be logged in and authorized to access this endpoint. An object containing the updated profile information: Username: The updated username. Email: The updated email address. A response confirming the updated profile details (username and email) upon success. If the user is not authorized or input is invalid, an error message is returned. The user's profile was successfully updated. Invalid input data was provided. The user is not authorized to update their profile. An internal error occurred while processing the request.

Updates the profile details of a specific user by ID, including an optional password update.

This endpoint allows an admin to update a user's details, such as username, email, and optionally, the CompanyId and password. The request must be authenticated, and only users with the 'Admin' role are authorized. The unique identifier of the user to be updated. An object containing the updated profile information: Username: The updated username. Email: The updated email address. CompanyId: (Optional) The updated company ID. NewPassword: (Optional) The new password for the user. A response confirming the updated profile details upon success. If the user is not authorized or input is invalid, an error message is returned. The user's profile was successfully updated. Invalid input data was provided. The user is not authorized to update user details. The user was not found. An internal error occurred while processing the request.

Deletes a user from the system by their unique ID.

This endpoint allows an admin to delete a user from the system. The request must be authenticated, and only users with the 'Admin' role are authorized. The unique identifier of the user to be deleted. A response confirming the deletion of the user upon success. If the user is not authorized or input is invalid, an error message is returned. The user was successfully deleted. An error occurred while deleting the user. The user is not authorized to delete users. The user was not found. An internal error occurred while processing the request.

Creates a new user in the system with the specified details.

This endpoint allows an admin to create a new user. The request must be authenticated, and only users with the 'Admin' role are authorized. An object containing the new user details: Username: The desired username. Email: The user's email address. Password: The user's password. CompanyId: (Optional) The ID of the company to assign the user to. A response containing the JWT token and user details (user ID, username, email, and role) upon successful creation. If the creation fails due to invalid input or errors, an appropriate error message is returned. The user was successfully created, and a JWT token was generated. Invalid user details or creation failed. The user is not authorized to create users. An internal error occurred while processing the request.

Changes the authenticated user's password.

This endpoint allows authenticated users to update their password by providing the current password and a new password. The user must be logged in and authorized to access this endpoint. An object containing the password change details: OldPassword: The current password of the user. NewPassword: The new password to be set. A confirmation message upon successful password update. If the user is unauthorized or the input is invalid, an error message is returned. The user's password was successfully updated. Invalid password details were provided. The user is not authorized to change their password. An internal error occurred while processing the request.

Generates a JSON Web Token (JWT) for a given user.

This private method is used internally to create a JWT token that encodes user-specific claims, including the username, email, and a unique identifier. The token is signed with the application's secret key and is valid for a limited time. The object representing the user for whom the token is being generated. A string representation of the generated JWT token. Thrown if the JWT secret key is missing in the configuration.

Initiates the password reset process by sending a reset link to the user's email.

The request model containing the user's email address. A confirmation message indicating that the reset link has been sent. If the email exists, a reset link has been sent. Invalid input data was provided.

Resets the user's password using the provided token and email.

The request model containing the token, email, and new password. A confirmation message indicating that the password reset was successful. Password reset successful. Invalid token, email, or input data.

Sends an email with the specified details.

The email request containing the recipient, subject, and body. A confirmation message indicating that the email was sent successfully. Email sent successfully. Invalid email request data.

Represents the request model for sending an email.

Provides endpoints for managing CMS content, including retrieval, creation, update, and deletion operations.

Retrieves CMS content details by slug.

This endpoint fetches CMS content based on the provided slug. An optional language parameter (`lang`) can be included to specify the language of the content. The unique slug of the CMS content to retrieve (e.g., "home"). (Optional) The language code for filtering the content (e.g., "en"). A response containing the CMS content details for the specified slug. If the content is not found, a `404 Not Found` status is returned. The CMS content was successfully retrieved. No CMS content was found for the provided slug. Invalid input was provided. An internal server error occurred while processing the request.

Retrieves all CMS content entries.

This endpoint returns a list of all CMS content entries. An optional language parameter (`lang`) can be included to filter the content by language. (Optional) The language code for filtering the content (e.g., "en"). A response containing a list of all CMS content entries. If no entries are found, an empty list is returned. The CMS content entries were successfully retrieved. Invalid input was provided. An internal server error occurred while processing the request.

Creates a new CMS content entry.

This endpoint allows you to create a new CMS content entry by providing the content details. Upon successful creation, the endpoint returns the created content along with its unique slug. The CMS content data to create, including fields such as: Title: The title of the CMS content. Slug: The unique identifier (slug) for the content. Body: The main content of the CMS entry. Language: The language code for the content (e.g., "en"). A response containing the created CMS content entry. If the creation fails due to invalid input, an error message is returned. The CMS content was successfully created. Invalid input data was provided. The user is not authorized to create CMS content. An internal server error occurred while processing the request.

Updates an existing CMS content entry by its ID.

This endpoint allows you to update an existing CMS content entry using its unique ID. The updated content data must be provided in the request body. If the content ID is not found, a `404 Not Found` response is returned. The unique identifier of the CMS content to update. The updated CMS content data, including fields such as: Title: The updated title of the CMS content. Slug: The updated unique identifier (slug) for the content. Body: The updated main content of the CMS entry. Language: The updated language code for the content (e.g., "en"). A response containing the updated CMS content entry. If the update fails due to invalid input or the content ID not being found, an error message is returned. The CMS content was successfully updated. Invalid input data was provided. The user is not authorized to update CMS content. The CMS content with the specified ID was not found. An internal server error occurred while processing the request.

Deletes a CMS content entry by its unique ID.

This endpoint removes a CMS content entry from the system based on its unique identifier. If the content ID is not found, a `404 Not Found` response is returned. The unique identifier of the CMS content to delete. A response indicating the result of the deletion operation. If successful, a `204 No Content` status is returned. If the content ID is not found, a `404 Not Found` response is provided. The CMS content was successfully deleted. Invalid input data was provided. You dont have permission to remove the CMS content. The CMS content with the specified ID was not found. An internal server error occurred while processing the request.

Provides CRUD operations for managing companies in the system.

Retrieves a list of all companies.

A list of companies. Returns the list of companies. An internal server error occurred while processing the request.

Retrieves details of a specific company by its ID.

The ID of the company to retrieve. The company details if found. Returns the company details. The company with the specified ID was not found. An internal server error occurred while processing the request.

Creates a new company.

The company details to create. The created company. The company was successfully created. Invalid input data was provided. The user is not authorized to update their profile. An internal server error occurred while processing the request.

Updates an existing company by its ID.

The ID of the company to update. The updated company details. The company was successfully updated. Invalid input data or mismatched IDs. The company with the specified ID was not found. The user is not authorized to update the compnay. An internal server error occurred while processing the request.

Deletes a specific company by its ID.

The ID of the company to delete. The company was successfully deleted. The company with the specified ID was not found. The user is not authorized to delete the company. An internal server error occurred while processing the request.

Manages operations related to countries and their association with Free Trade Agreements (FTAs), including CRUD operations and file processing for Most Favored Nation (MFN) data.

The controller aligns with the API schema and endpoints defined in FTACountry.yaml, which provides detailed OpenAPI documentation for these operations.

Retrieves a list of all countries.

Implements GET /FTACountry to fetch all FTA Country entries. The endpoint supports optional filtering and aligns with the FTACountry schema for the response.

Retrieves details of a specific country by its ID.

The ID of the country to retrieve. Implements GET /FTACountry/{FtaCountryId} to fetch the details of an FTA Country entry. Response aligns with the FTACountry schema.

Creates a new country entry.

The request payload containing details of the new country. Implements POST /FTACountry to create an FTA Country entry. The request uses the FTACountryInput schema. The content is successfully added. Invalid input data was provided. The user is not authorized. The content with the specified ID was not found. An internal server error occurred while processing the request.

Updates a specific country entry by its ID.

The ID of the country to update. The request payload containing updated details. Implements PUT /FTACountry/{FtaCountryId} to update an FTA Country entry. The request uses the FTACountryInput schema. The content is successfully updated. Invalid input data was provided. The user is not authorized. The content with the specified ID was not found. An internal server error occurred while processing the request.

Deletes a specific country entry by its ID.

The ID of the country to delete. Implements DELETE /FTACountry/{FtaCountryId} to remove an FTA Country entry. The content is successfully removed. Invalid input data was provided. The user is not authorized. The content with the specified ID was not found. An internal server error occurred while processing the request.

Uploads and processes MFN data from a file.

The request payload containing the file and associated details. Implements POST /FTACountry/Mfn to upload MFN data for a specific country. The file is processed and saved in the database. The content is successfully uploaded. Invalid input data was provided. The user is not authorized. An internal server error occurred while processing the request.

Retrieves MFN data for a specific country.

The ID of the country for which MFN data is to be retrieved. Implements GET /FTACountry/Mfn/{FtaCountryId} to fetch MFN data associated with a country.

Deletes a specific MFN data entry.

The ID of the MFN entry to delete. Implements DELETE /FTACountry/Mfn/{FtaCountryId} to remove MFN data for a specific country. The content is successfully removed. Invalid input data was provided. The user is not authorized. The content with the specified ID was not found. An internal server error occurred while processing the request.

Uploads the HS 2022 to 2017 correlation table for a specific country.

Form containing CountryId and Excel file HTTP 200 if successful, otherwise 400

Retrieves the HS correlation records for a specific country.

The ID of the country List of HS 2022 to 2017 mappings

Provides endpoints for managing Free Trade Agreements (FTAs), including operations for PSR and TRS data.

Creates a new Free Trade Agreement (FTA) record.

This endpoint allows the creation of a new FTA in the system. The request body must include all required details of the FTA, such as its type, LanguageId, ParentFTAId abbreviation, name, and associated metadata. If the data is valid, a new FTA entry is added to the database, and its details are returned. The FTA object containing details of the new Free Trade Agreement to be created. This includes: FTA Type LanguageId ParentFTAId Abbreviation Name Associated media and metadata A response containing the details of the newly created FTA entry. The response includes the FTA's unique ID, name, and metadata. The FTA record was successfully created. Invalid data was provided in the request body. The user is not authorized. An internal error occurred while processing the request.

Retrieves a Free Trade Agreement (FTA) record by its unique identifier.

This endpoint allows you to fetch detailed information about a specific FTA using its unique ID. If the ID is valid and the FTA exists, the details of the FTA are returned. Otherwise, an appropriate error message is provided. The unique identifier of the FTA to be retrieved. This is an integer that must be greater than zero. A response containing the FTA details, including its type, abbreviation, name, associated media, and other metadata. If the FTA is not found, an error message is returned. The FTA record was successfully retrieved. The specified FTA ID does not exist in the system. The provided FTA ID is invalid. An internal error occurred while processing the request.

Updates an existing Free Trade Agreement (FTA) record.

This endpoint allows you to update the details of an existing FTA using its unique ID. The updated FTA data is provided in the request body. If the ID is valid and the FTA exists, the record is updated, and the updated details are returned. The unique identifier of the FTA to be updated. This is an integer that must be greater than zero. The updated FTA object containing new values for the FTA's fields. This includes: FTA Type Abbreviation Name Associated media and metadata A response containing the updated FTA details if the update is successful. If the FTA ID does not exist or the data is invalid, an error message is returned. The FTA record was successfully updated. The specified FTA ID does not exist in the system. Invalid FTA data or FTA ID was provided. The user is not authorized. An internal error occurred while processing the request.

Retrieves a paginated list of Free Trade Agreements (FTAs) with optional sorting and filtering.

This endpoint returns a list of FTAs based on the provided filter, pagination, and sorting options. You can customize the results using the following parameters: Pagination: Specify the number of items per page and the page number. Sorting: Specify the field to sort by and the direction (ascending or descending). If no FTAs match the criteria, an empty list is returned. An object containing the filtering, sorting, and pagination options: NumOfItem: The number of items per page. PageNumber: The page number to retrieve. OrderBy: The field to sort by (e.g., name or date). OrderDirection: The sorting direction (ascending or descending). A response containing a paginated list of FTAs that match the provided criteria. If no criteria are specified, all FTAs are returned in a paginated format. A list of FTAs was successfully retrieved. Invalid filter options were provided in the request. An internal error occurred while processing the request.

Deletes a Free Trade Agreement (FTA) record by its unique identifier.

This endpoint allows you to delete an existing FTA from the system using its unique ID. If the ID is valid and the FTA exists, the record is deleted. Otherwise, an appropriate error message is returned. The unique identifier of the FTA to be deleted. This is an integer and must be greater than zero. A response indicating the result of the deletion operation. If successful, no content is returned. The FTA record was successfully deleted. The provided FTA ID is invalid. The user is not authorized. The specified FTA ID does not exist in the system. An internal error occurred while processing the request.

Uploads a PSR (Product-Specific Rules) Excel file for a Free Trade Agreement (FTA).

This endpoint allows the user to upload a PSR file for a specific FTA. The uploaded file is processed to extract and save PSR data associated with the specified FTA. The PSR file must be in the correct format and adhere to the data requirements of the system. An object containing the details of the PSR file upload, including: FtaId: The ID of the FTA the PSR data is associated with. PSRVersion: The version of the PSR data. Status: The status of the uploaded data. PsrFile: The PSR Excel file to be uploaded. A success message if the file is uploaded and processed successfully. Otherwise, an appropriate error message is returned. The PSR file was successfully uploaded and processed. Invalid data was provided, or the uploaded file is empty. The specified FTA does not exist in the system. The user is not authorized. An internal error occurred while processing the file.

Retrieves Product-Specific Rules (PSR) data for a specific Free Trade Agreement (FTA).

This endpoint fetches all PSR data associated with a specific FTA using its unique ID. If the FTA ID is valid and PSR data exists, the data is returned. If no PSR data is found, an appropriate error message is provided. The unique identifier of the FTA whose PSR data is to be retrieved. This is an integer and must be greater than zero. A response containing the PSR data for the specified FTA. If no PSR data exists, an error message is returned. The PSR data was successfully retrieved. No PSR data exists for the specified FTA ID. The provided FTA ID is invalid. An internal error occurred while processing the request.

Deletes a Product-Specific Rules (PSR) data record by its unique identifier.

This endpoint deletes a specific PSR record associated with a Free Trade Agreement (FTA) using its unique PSR ID. If the PSR ID is valid and the record exists, it is deleted from the system. Otherwise, an appropriate error message is returned. The unique identifier of the PSR record to be deleted. This is an integer and must be greater than zero. A response indicating the result of the deletion operation. If successful, no content is returned. The PSR record was successfully deleted. The provided PSR ID is invalid. The user is not authorized. The specified PSR ID does not exist in the system. An internal error occurred while processing the request.

Uploads a TRS (Tariff Reduction Schedule) Excel file for a Free Trade Agreement (FTA) Country.

This endpoint allows the user to upload a TRS file for a specific FTA country. The uploaded file is processed to extract and save TRS data associated with the specified FTA and country. The TRS file must adhere to the expected format and data requirements. An object containing the details of the TRS file upload, including: FtaId: The ID of the FTA the TRS data is associated with. TRSVersion: The version of the TRS data. FTACountryId: The ID of the FTA country associated with the TRS data. Status: The status of the uploaded data. TrsFile: The TRS Excel file to be uploaded. A success message if the file is uploaded and processed successfully. Otherwise, an appropriate error message is returned. The TRS file was successfully uploaded and processed. Invalid data was provided, or the uploaded file is empty. The specified FTA or FTA country does not exist in the system. The user is not authorized. An internal error occurred while processing the file.

Retrieves Tariff Reduction Schedule (TRS) data for a specific Free Trade Agreement (FTA) Country.

This endpoint fetches all TRS data associated with a specific FTA country using its unique ID. If the FTA country ID is valid and TRS data exists, the data is returned. If no TRS data is found, an appropriate error message is provided. The unique identifier of the FTA country whose TRS data is to be retrieved. This is an integer and must be greater than zero. A response containing the TRS data for the specified FTA country. If no TRS data exists, an error message is returned. The TRS data was successfully retrieved. No TRS data exists for the specified FTA country ID. The provided FTA country ID is invalid. An internal error occurred while processing the request.

Deletes a Tariff Reduction Schedule (TRS) record by its unique identifier (FTATRSId).

This endpoint deletes a specific TRS record associated with a Free Trade Agreement (FTA) country using its unique FTATRS ID. If the FTATRS ID is valid and the record exists, it is deleted from the system. Otherwise, an appropriate error message is returned. The unique identifier of the TRS record to be deleted. This is an integer and must be greater than zero. A response indicating the result of the deletion operation. If successful, no content is returned. The TRS record was successfully deleted. The specified FTATRS ID does not exist in the system. The user is not authorized. The provided FTATRS ID is invalid. An internal error occurred while processing the request.

Searches for Harmonized System (HS) codes within a specific country.

This endpoint allows users to search for HS codes in a specific country using a search key. The search results include detailed information about the matching HS codes. An object containing the search parameters: CountryId: The unique identifier of the country for the HS code search. searchKey: The keyword or partial HS code to search for. A response containing a list of HS codes that match the search criteria. If no HS codes are found, an appropriate error message is returned. The HS code search results were successfully retrieved. Invalid search parameters were provided. No HS codes match the provided search criteria. An internal error occurred while processing the request.

Searches for Free Trade Agreements (FTAs) using a specific Harmonized System (HS) code and country.

This endpoint allows users to search for FTAs based on a given HS code and a specific country. The search results include detailed information about the FTAs that match the criteria. An object containing the search parameters: CountryId: The unique identifier of the country for the FTA search. searchKey: The HS code or keyword to search for. A response containing a list of FTAs that match the search criteria. If no FTAs are found, an appropriate error message is returned. The FTA search results were successfully retrieved. Invalid search parameters were provided. No FTAs match the provided search criteria. An internal error occurred while processing the request.

Adds a new Rule of Origin.

This endpoint allows the creation of a new Rule of Origin associated with a Free Trade Agreement (FTA). The request body must include the necessary details such as the question text, language ID, parent Rule of Origin ID, and the next questions for "Yes" and "No" answers. The Rule of Origin input model containing the following fields: FtaId: The ID of the associated FTA. QuestionText: The text of the Rule of Origin question. NextQuestionIdYes: The ID of the next Rule of Origin if the answer is Yes. NextQuestionIdNo: The ID of the next Rule of Origin if the answer is No. LanguageId: The ID of the language this Rule of Origin is written in. ParentRooId: The parent Rule of Origin ID (defaults to 0 for root questions). A response containing the details of the newly created Rule of Origin. The Rule of Origin was successfully created. Invalid data was provided in the request body. The user is not authorized. The specified FTA ID does not exist. An internal error occurred while processing the request.

Updates an existing Rule of Origin.

This endpoint updates the details of an existing Rule of Origin identified by its unique ID. The request body must include the updated details such as the question text, language ID, and the next questions for "Yes" and "No" answers. The unique identifier of the Rule of Origin to update. The updated Rule of Origin input model containing the following fields: FtaId: The ID of the associated FTA. QuestionText: The text of the Rule of Origin question. NextQuestionIdYes: The ID of the next Rule of Origin if the answer is Yes. NextQuestionIdNo: The ID of the next Rule of Origin if the answer is No. LanguageId: The ID of the language this Rule of Origin is written in. ParentRooId: The parent Rule of Origin ID (defaults to 0 for root questions). A response containing the details of the updated Rule of Origin. The Rule of Origin was successfully updated. Invalid data was provided in the request body. The user is not authorized. The specified Rule of Origin ID does not exist. An internal error occurred while processing the request.

Retrieves a specific Rule of Origin by its ID.

This endpoint retrieves the details of a specific Rule of Origin identified by its unique ID. The unique identifier of the Rule of Origin to retrieve. A response containing the details of the requested Rule of Origin. The Rule of Origin was successfully retrieved. The provided Rule of Origin ID is invalid. The specified Rule of Origin ID does not exist. An internal error occurred while processing the request.

Retrieves all Rules of Origin for a specific FTA.

This endpoint retrieves all Rules of Origin associated with a specific Free Trade Agreement (FTA) identified by its unique ID. The unique identifier of the FTA to retrieve Rules of Origin for. A response containing a list of Rules of Origin associated with the specified FTA. A list of Rules of Origin was successfully retrieved. The provided FTA ID is invalid. An internal error occurred while processing the request.

Deletes a specific Rule of Origin by its ID.

This endpoint deletes a specific Rule of Origin identified by its unique ID. The unique identifier of the Rule of Origin to delete. A `204 No Content` response if the deletion is successful. The Rule of Origin was successfully deleted. The provided Rule of Origin ID is invalid. The user is not authorized. The specified Rule of Origin ID does not exist. An internal error occurred while processing the request.

Provides endpoints for managing FTACountry entries, including creation, retrieval, updates, and deletion.

Creates a new FTACountry entry.

This endpoint allows you to create a new FTACountry entry, which represents the association between a country and a Free Trade Agreement (FTA). The request body must include details such as the FTA ID, country ID, commodity classification, MFN rate, and effective date. The FTACountryInput object containing the following fields: FtaId: The ID representing the FTA type. CountryId: The ID representing the associated country. ImageId: The ID of the associated image. ComodityClassification: The commodity classification system used (e.g., "HS 2022"). MfnRate: The Most Favored Nation rate for the country (e.g., "8%"). EffectiveDate: The inforce date of the FTA (e.g., "2017-01-11"). A response containing the details of the created FTACountry entry, including its unique ID. If creation fails, an appropriate error message is returned. The FTACountry entry was successfully created. Invalid input data was provided. The user is not authorized. An internal server error occurred while processing the request.

Retrieves an FTACountry entry by its unique ID.

This endpoint fetches an FTACountry entry based on its unique identifier. The response includes details such as the associated FTA, country, commodity classification, MFN rate, and effective date. The unique identifier of the FTACountry entry to retrieve. A response containing the details of the FTACountry entry. If no entry is found for the provided ID, a `404 Not Found` status is returned. The FTACountry entry was successfully retrieved. No FTACountry entry was found for the provided ID. The provided ID was invalid. An internal server error occurred while processing the request.

Lists FTACountry entries with pagination and sorting options.

This endpoint retrieves a paginated list of FTACountry entries associated with a specific FTA, filtered by the provided options. The options include the FTA ID, number of items per page, page number, sorting column, and sorting direction. An object containing the following filtering and sorting options: FtaId: The unique identifier of the FTA to filter by. NumOfItem: The number of items to display per page (e.g., 10). PageNumber: The current page number (e.g., 1). OrderBy: The column to sort the results by (e.g., "CountryName"). OrderDirection: The sorting direction ("asc" or "desc"). A paginated response containing the list of FTACountry entries that match the provided filters. If no entries are found, an empty list is returned. The list of FTACountry entries was successfully retrieved. Invalid filter or pagination options were provided. An internal server error occurred while processing the request.

Updates an existing FTACountry entry by its unique ID.

This endpoint updates an FTACountry entry based on its unique identifier. The updated details must be provided in the request body. If the specified ID is not found, a `404 Not Found` response is returned. The unique identifier of the FTACountry entry to update. The updated FTACountryInput object containing the following fields: FtaId: The updated FTA ID associated with the entry. CountryId: The updated country ID associated with the entry. ImageId: The updated image ID linked to the entry. ComodityClassification: The updated commodity classification system (e.g., "HS 2022"). MfnRate: The updated MFN rate for the country (e.g., "5%"). EffectiveDate: The updated effective date of the FTA (e.g., "2020-06-01"). A response containing the updated FTACountry entry. If the specified ID is not found, a `404 Not Found` response is returned. The FTACountry entry was successfully updated. Invalid input data was provided. The user is not authorized. The FTACountry entry with the specified ID was not found. An internal server error occurred while processing the request.

Deletes an FTACountry entry by its unique ID.

This endpoint removes an FTACountry entry from the system based on its unique identifier. If the specified ID is not found, a `404 Not Found` response is returned. The unique identifier of the FTACountry entry to delete. A response indicating the result of the deletion operation. If successful, a `204 No Content` status is returned. If the specified ID is not found, a `404 Not Found` response is provided. The FTACountry entry was successfully deleted. Invalid ID was provided. The user is not authorized. The FTACountry entry with the specified ID was not found. An internal server error occurred while processing the request.

Provides endpoints for managing FTA types, including creation, retrieval, updates, and deletion.

Retrieves a list of all FTA types.

This endpoint returns a list of all FTA types available in the system. Each FTA type includes details such as the ID, name, status, creation, and update information. A response containing a list of all FTA types. If no entries are found, an empty list is returned. The list of FTA types was successfully retrieved. No FTA types were found in the system. Invalid request parameters were provided. An internal server error occurred while processing the request.

Retrieves an FTA type by its unique ID.

This endpoint fetches an FTA type based on its unique identifier. The response includes details such as the ID, name, status, creation, and update information. The unique identifier of the FTA type to retrieve. A response containing the details of the FTA type. If the FTA type is not found, a `404 Not Found` status is returned. The FTA type was successfully retrieved. No FTA type was found with the specified ID. The provided ID is invalid. An internal server error occurred while processing the request.

Creates a new FTA type.

This endpoint allows you to create a new FTA type by providing the necessary details. The request body must include fields such as the name and status of the FTA type. The FTATypeInput object containing the following fields: Name: The name of the FTA type (e.g., "Bilateral Agreement"). Status: The status of the FTA type (e.g., "Active"). A response containing the details of the newly created FTA type, including its unique ID. If creation fails, an appropriate error message is returned. The FTA type was successfully created. Invalid input data was provided. The user is not authorized. An internal server error occurred while processing the request.

Updates an existing FTA type by its unique ID.

This endpoint allows you to update the details of an existing FTA type by providing its unique ID and the updated details in the request body. If the FTA type is not found, a `404 Not Found` response is returned. The unique identifier of the FTA type to update. The updated FTATypeInput object containing the following fields: Name: The updated name of the FTA type (e.g., "Multilateral Agreement"). Status: The updated status of the FTA type (e.g., "Inactive"). A response containing the updated FTA type details. If the specified FTA type ID is not found, a `404 Not Found` status is returned. The FTA type was successfully updated. Invalid input data was provided. The user is not authorized. The FTA type with the specified ID was not found. An internal server error occurred while processing the request.

Deletes an FTA type by its unique ID.

This endpoint removes an FTA type from the system based on its unique identifier. If the FTA type ID is not found, a `404 Not Found` response is returned. The unique identifier of the FTA type to delete. A response indicating the result of the deletion operation. If successful, a `204 No Content` status is returned. If the specified ID is not found, a `404 Not Found` response is provided. The FTA type was successfully deleted. Invalid ID was provided. The user is not authorized. The FTA type with the specified ID was not found. An internal server error occurred while processing the request.

Creates a new language entry.

This endpoint allows adding a new language to the system. The request body must include details such as the language's name, code, status, and associated media ID. The LanguageModel object containing the following fields: MediaId: The ID of the media associated with this language (e.g., 1). Name: The name of the language (e.g., "English"). Code: The language code (e.g., "en"). Status: The status of the language (e.g., "active"). A response containing the details of the newly created language entry, including its unique ID. If creation fails due to invalid input, an appropriate error message is returned. The language entry was successfully created. Invalid input data was provided. The user is not authorized. An internal server error occurred while processing the request.

Retrieves all language entries.

This endpoint fetches a list of all languages available in the system. Each language entry includes details such as its unique ID, name, code, status, and associated media. A response containing a list of all languages. If no languages exist, an empty list is returned. The list of all languages was successfully retrieved. No language entries were found. Invalid request parameters were provided. An internal server error occurred while processing the request.

Retrieves a language entry by its unique ID.

This endpoint fetches the details of a specific language by its unique identifier. The response includes fields such as the language's ID, name, code, status, and associated media. The unique identifier of the language to retrieve. A response containing the language's details. If the specified ID is not found, a `404 Not Found` response is returned. The language entry was successfully retrieved. No language entry was found with the specified ID. The provided ID is invalid. An internal server error occurred while processing the request.

Updates an existing language entry by its unique ID.

This endpoint allows you to update the details of an existing language. The request body must include the updated fields such as name, code, status, and associated media ID. The unique identifier of the language to update. The updated LanguageModel object containing the following fields: MediaId: The updated media ID for this language (e.g., 2). Name: The updated name of the language (e.g., "French"). Code: The updated language code (e.g., "fr"). Status: The updated status of the language (e.g., "inactive"). A response containing the updated language details. If the specified ID is not found, a `404 Not Found` response is returned. The language entry was successfully updated. Invalid input data or ID was provided. The user is not authorized. The language entry with the specified ID was not found. An internal server error occurred while processing the request.

Deletes a language entry by its unique ID.

This endpoint removes a language from the system based on its unique identifier. If the specified language ID is not found, a `404 Not Found` response is returned. The unique identifier of the language to delete. A response indicating the result of the deletion operation. If successful, a `204 No Content` status is returned. If the specified ID is not found, a `404 Not Found` response is provided. The language entry was successfully deleted. Invalid ID was provided. The user is not authorized. The language entry with the specified ID was not found. An internal server error occurred while processing the request.

Retrieves all media items.

This endpoint fetches a list of all media files available in the system. Each media file includes details such as ID, file name, type, status, and associated metadata. A response containing a list of all media items. If no media items exist, an empty list is returned. Successfully retrieved the list of media items. No media items were found. Invalid request parameters were provided. An internal server error occurred while processing the request.

Retrieves a media item by its unique ID.

This endpoint fetches the details of a specific media item based on its unique identifier. The response includes fields such as the media item's ID, file name, type, status, and associated metadata. The unique identifier of the media item to retrieve. A response containing the media item's details. If the specified ID is not found, a `404 Not Found` response is returned. The media item was successfully retrieved. No media item was found with the specified ID. The provided ID is invalid. An internal server error occurred while processing the request.

Creates a new media item with an optional file upload.

This endpoint allows you to create a new media entry in the system, with the option to upload an associated file. The request body must include details such as the media's name, type, and status. An optional file can be provided for upload. The MediaModel object containing the following fields: Name: The name of the media item (e.g., "Sample Image"). Type: The type of media (e.g., "image/jpeg"). Status: The status of the media (e.g., "active"). An optional file to associate with the media entry. Supported file types depend on the implementation. A response containing the details of the newly created media item, including its unique ID. If creation fails due to invalid input, an appropriate error message is returned. The media item was successfully created. Invalid input data or file was provided. The user is not authorized. An internal server error occurred while processing the request.

Updates an existing media item by its unique ID with an optional file upload.

This endpoint allows you to update the details of an existing media entry. The request body must include updated details such as the media's name, type, and status. An optional file can also be provided to replace the existing associated file. The unique identifier of the media item to update. The MediaModel object containing the updated fields: Name: The updated name of the media item (e.g., "Updated Image"). Type: The updated type of media (e.g., "image/png"). Status: The updated status of the media (e.g., "inactive"). An optional file to replace the existing file associated with the media entry. Supported file types depend on the implementation. A response containing the updated media details. If the specified ID is not found, a `404 Not Found` response is returned. The media item was successfully updated. Invalid input data or ID was provided. The user is not authorized. The media item with the specified ID was not found. An internal server error occurred while processing the request.

Deletes a media item by its unique ID.

This endpoint removes a media item from the system based on its unique identifier. If the specified media ID is not found, a `404 Not Found` response is returned. The unique identifier of the media item to delete. A response indicating the result of the deletion operation. If successful, a `204 No Content` status is returned. If the specified ID is not found, a `404 Not Found` response is provided. The media item was successfully deleted. Invalid ID was provided. The user is not authorized. The media item with the specified ID was not found. An internal server error occurred while processing the request.

Retrieves the URL for a media item in a specified size.

This endpoint fetches the URL for a specific media item based on its unique identifier. The `size` parameter allows you to specify the desired size of the media file: `full`: The original file size. `thumbnail`: A thumbnail version of the media. `small`: A smaller version of the media. If the media item or the requested size is not available, a `404 Not Found` response is returned. The unique identifier of the media item to retrieve. The desired size of the media file. Valid values are: `full` (default) `thumbnail` `small` A response containing the media item's URL. If the specified ID or size is not found, a `404 Not Found` response is returned. Successfully retrieved the media URL. Invalid `size` parameter or ID was provided. The media item or requested size was not found. An internal server error occurred while processing the request.

Retrieves a list of all PSR records.

This endpoint retrieves a complete list of all PSR (Product Specific Rules) records stored in the system. Each record includes details such as PSR ID, name, abbreviation, description, status, and timestamps for creation and updates. A response containing an array of PSR records. If no records exist, an empty array is returned. Successfully retrieved the list of PSR records. The request contains invalid parameters or data. No PSR records were found in the system. An internal server error occurred while processing the request.

Retrieves a PSR (Product Specific Rule) by its unique ID.

This endpoint fetches the details of a specific PSR record using its unique identifier. The response includes fields such as the PSR's ID, name, abbreviation, description, status, and timestamps for creation and updates. The unique identifier of the PSR to retrieve. A response containing the PSR record details. If the specified ID is not found, a `404 Not Found` response is returned. Successfully retrieved the PSR record. Invalid PSR ID was provided. The PSR record with the specified ID was not found. An internal server error occurred while processing the request.

Creates a new PSR (Product Specific Rule).

This endpoint allows you to create a new PSR record in the system. The request body must include details such as the PSR's name, abbreviation, description, and status. Upon successful creation, the newly created PSR's details are returned, including its unique ID. The PSRInput object containing the following fields: Name: The name of the PSR (e.g., "Specific Rule 1"). Abbreviation: The abbreviation for the PSR (e.g., "SR1"). Description: A brief description of the PSR. Status: The status of the PSR (e.g., "active"). A response containing the newly created PSR's details, including its unique ID. If the creation fails due to invalid input, an appropriate error message is returned. The PSR was successfully created. Invalid input data was provided. The user is not authorized to perform this action. An internal server error occurred while processing the request.

Updates an existing PSR (Product Specific Rule) by its unique ID.

This endpoint allows you to update the details of an existing PSR record. The request body must include updated details such as the PSR's name, abbreviation, description, and status. If the specified ID is not found, a `404 Not Found` response is returned. The unique identifier of the PSR to update. The PSRInput object containing the updated fields: Name: The updated name of the PSR (e.g., "Updated Rule"). Abbreviation: The updated abbreviation for the PSR (e.g., "UR"). Description: An updated description of the PSR. Status: The updated status of the PSR (e.g., "inactive"). A response containing the updated PSR record. If the specified ID is not found, a `404 Not Found` response is returned. The PSR was successfully updated. Invalid input data or PSR ID was provided. The user is not authorized to perform this action. The PSR record with the specified ID was not found. An internal server error occurred while processing the request.

Deletes a PSR (Product Specific Rule) by its unique ID.

This endpoint removes a specific PSR record from the system based on its unique identifier. If the specified ID is not found, a `404 Not Found` response is returned. The unique identifier of the PSR to delete. A response indicating the result of the deletion operation. If successful, a `204 No Content` status is returned. If the specified ID is not found, a `404 Not Found` response is provided. The PSR record was successfully deleted. Invalid PSR ID was provided. The user is not authorized to perform this action. The PSR record with the specified ID was not found. An internal server error occurred while processing the request.

Controller for managing ratings. Requires JWT Bearer authentication.

Retrieves ratings by country ID. Requires JWT Bearer authentication.

The ID of the country List of ratings for the given country

Submits a rating for the FTA portal. Requires JWT Bearer authentication.

Rating input (Rate 1-10) Success message

Retrieves all application settings.

This endpoint fetches all key-value pairs representing the application's configuration settings. The settings include details such as the site title, API configurations, and other application-specific parameters. A response containing a list of all application settings. If no settings are found, an empty array is returned. Successfully retrieved all settings. Invalid or empty settings list provided. One or more settings keys were not found. An internal server error occurred while processing the request.

Updates the application's settings.

This endpoint allows updating multiple key-value pairs of settings at once. Each setting must include a valid key and value. If any of the keys do not exist, or if duplicate keys are provided, the update will fail. A collection of settings to be updated, where each entry includes: Key: The unique identifier for the setting (e.g., "SiteTitle"). Value: The new value for the setting (e.g., "My Website"). A response indicating the success or failure of the update operation. If successful, a confirmation message is returned. If any errors occur, appropriate error messages are provided. Successfully updated the settings. Invalid or empty settings list provided. The user is not authorized to perform this action. One or more settings keys were not found. An internal server error occurred while processing the request.

Adds a new application setting.

This endpoint allows adding a new key-value pair to the application's settings. The `key` must be unique, and the `value` must not be null or empty. If a setting with the same key already exists, the operation will fail. The `SettingModel` object containing the following fields: Key: A unique identifier for the setting (e.g., "ThemeColor"). Value: The corresponding value for the setting (e.g., "#FFFFFF"). A response indicating the success or failure of the addition operation. If successful, a confirmation message is returned. If any errors occur, appropriate error messages are provided. Successfully added the new setting. Invalid or null setting data provided, or the key already exists. The user is not authorized to perform this action. An internal server error occurred while processing the request.

Retrieves a list of all users.

A list of all users with their associated companies.

Processes each request and logs it to the database.

Primary key for the audit log entry.

Timestamp for when the request was made.

HTTP method (GET, POST, etc.) used in the request.

URL path of the request.

Query parameters in the URL.

Body of the request.

Body of the response.

HTTP status code of the response.

User ID for authenticated requests, if available.

Client IP address (IPv4 or IPv6) the request originated from.

Full name of the user for display purposes.

Model for updating a user, including optional password changes.

The full name of the user for display purposes.

The new email address for the user.

The optional company ID to update.

The optional new password for the user.

The optional role for the user (e.g., "User", "Admin", "Editor").

The full name of the user for display purposes.

The email address for the new user.

The password for the new user.

The role for the new user (e.g., "User", "Admin", "Editor"). Defaults to "User".

The email address for login.

The password for login.

The full name of the user for display purposes.

The new email address for the user.

The optional company ID to update.

The current password of the user.

The new password for the user.

Response model representing a country and its associated metadata.

Name of the country.

Khmer name of the country.

ISO code or identifier for the country.

Media identifier for any associated media resources.

Current status of the country (e.g., active, inactive).

Date and time when the country record was created.

Identifier of the user who created the country record.

Date and time when the country record was updated.

Identifier of the user who updated the country record.

Model for creating a new country entry.

Name of the country.

Khmer name of the country.

ISO code or identifier for the country.

Media identifier for any associated media resources.

Current status of the country (e.g., active, inactive).

Model for updating an existing country entry.

Name of the country.

Khmer name of the country.

ISO code or identifier for the country.

Media identifier for any associated media resources.

Current status of the country (e.g., active, inactive).

Main model representing an FTA Country entry.

Foreign key to the associated FTA.

Foreign key to the associated Country.

Foreign key to the associated Image.

Classification of commodities under the FTA.

Most Favored Nation (MFN) rate for commodities.

Date when the FTA becomes effective.

Input DTO for creating or updating an FTACountry entry.

Foreign key to the associated FTA.

Foreign key to the associated Country.

Foreign key to the associated Image.

Classification of commodities under the FTA.

Most Favored Nation (MFN) rate for commodities.

Date when the FTA becomes effective.

Filter options for listing FTACountry entries with pagination and sorting.

Filter by specific FTA ID.

Number of items to retrieve per page.

Page number for pagination.

Field by which to order the results, defaults to "FtaCountryId".

Order direction for results, either "ASC" or "DESC", defaults to "ASC".

Main FTA model representing a Free Trade Agreement with associated metadata.

Foreign key to the associated FTA type.

Model representing data for Harmonized System (HS) codes.

Filter options for listing FTAs with pagination and sorting.

Input model for searching Harmonized System (HS) codes.

Input model for searching FTAs between specific countries.

Model representing the input for creating or updating a Rule of Origin.

The ID of the FTA associated with this Rule of Origin.

The text of the Rule of Origin question.

The ID of the next question if the answer is "Yes".

The ID of the next question if the answer is "No".

The ID of the language this Rule of Origin is written in.

The parent Rule of Origin ID, if applicable. Defaults to 0 for root questions.

Model representing a response for a Rule of Origin listing or detail fetch.

Unique ID of the Rule of Origin.

The text of the Rule of Origin question.

The ID of the next question if the answer is "Yes".

The ID of the next question if the answer is "No".

The ID of the language this Rule of Origin is written in.

The parent Rule of Origin ID, if applicable.

Represents an FTAPSR entry with associated PSR data.

Foreign key linking to FTA.

PSRVersion identifier for this PSR entry.

Status of the PSR entry (e.g., active, inactive).

Creation timestamp for this PSR entry.

User who created this entry.

Last updated timestamp, if applicable.

User who last updated this entry, if applicable.

Collection of associated PSR data rows.

Represents PSR (Product-Specific Rule) data linked to an FTAPSR.

Foreign key linking to FTAPSR.

Product-specific rule code.

Description of the rule.

PSR rule value.

Represents the type of a Free Trade Agreement (FTA) with relevant metadata.

Name of the FTA type.

Status of the FTA type (e.g., active, inactive).

Date and time when the FTA type was created.

Identifier of the user who created the FTA type.

Input model for creating or updating an FTA type.

Name of the FTA type.

Status of the FTA type (e.g., active, inactive).

Represents a language entry with associated metadata.

Identifier for the associated media resource.

Name of the language (e.g., "English", "French").

ISO code for the language (e.g., "EN" for English).

Current status of the language (e.g., "active", "inactive").

Represents a media file, including metadata and audit information.

Original name of the file, including its extension (e.g., "image.jpg").

MIME type of the file (e.g., "image/jpeg").

Alternative text for accessibility, providing a description of the media content.

Current status of the media file, e.g., "Active" or "Inactive".

Date and time when the media file was created.

Identifier of the user who created this media entry.

Represents a Product-Specific Rule (PSR) entry, including core details and metadata.

Full name of the PSR.

Abbreviation for the PSR, typically a shorthand identifier.

Detailed description of the PSR, providing additional context.

Current status of the PSR (e.g., active, inactive).

Date and time when the PSR entry was created.

Identifier of the user who created the PSR entry.

Input model for creating or updating a PSR entry.

Full name of the PSR.

Abbreviation for the PSR, typically a shorthand identifier.

Detailed description of the PSR, providing additional context.

Current status of the PSR (e.g., active, inactive).

Country identifier for the rating (required by OpenAPI YAML).

Output DTO to match the OpenAPI YAML 'Ratings' schema exactly.

Output DTO for ratings list, only the required fields as per latest requirements.

Request DTO for creating a rating, allowing only the required and optional fields.

Represents a configuration setting with a unique key-value pair.

Unique identifier for the setting, used as a key. Maximum length is 50 characters.

Value associated with the setting key. Maximum length is 250 characters.

Request model for checking if a content slug exists.

The type of the content (e.g., "page", "article", "news").

The slug to check for existence.

Service for managing country entities within the application.

Retrieves a list of all countries.

Retrieves a country by its unique identifier.

Creates a new country entry.

Updates an existing country by its ID.

Deletes a country by its ID.

Parses and saves MFN data from an Excel file to the database.

Parses County MFN data from an Excel file into a list of CountyMFNData objects.

Parses FTAPSR data from an Excel file into a list of FTAPSRData objects.

Parses TRS data from an uploaded Excel file into a list of FTATRSData objects.

Parses correlation data from an uploaded Excel file into a list of CountryCorrelation objects.

Removes all dots and spaces and trims the code.

Service for managing FTA Country entities.

Creates a new FTA Country entry.

Retrieves an FTA Country by its unique identifier.

Retrieves a paginated and sorted list of FTA Countries.

Updates an existing FTA Country by its ID.

Deletes an FTA Country by its ID.

Checks whether a specific FTACountry exists by its ID.

Searches for HS codes based on the country ID and input HS code using a dynamic SQL query.

Service for managing FTA types within the application.

Retrieves a list of all FTA types.

Fetches an FTA type by its unique identifier.

Creates a new FTA type entry.

Updates an existing FTA type by its ID.

Deletes an FTA type by its ID.

Provides FTP functionality for uploading, ensuring directory existence, and deleting files on a remote server.

Uploads a file to the FTP server with a specified filename, creating the directory if it doesn't exist.

Deletes a file from the FTP server based on the specified filename.

Ensures that each directory in the specified path exists, creating it if necessary.

Interface for managing country entities within the application.

Retrieves a list of all countries.

Retrieves a country by its unique identifier.

Creates a new country entry.

The details for creating a country.

Updates an existing country by its ID.

ID of the country to update. Updated country details.

Deletes a country by its ID.

ID of the country to delete.

Parses and saves MFN data from an uploaded Excel file.

The uploaded Excel file. The ID of the country. The MFN version.

Retrieves all MFN entries for a specific country.

Deletes an MFN entry by its ID.

Interface for managing FTA Country entities.

Creates a new FTA Country entry.

Retrieves an FTA Country by its unique identifier.

Retrieves a paginated and sorted list of FTA Countries.

Updates an existing FTA Country by its ID.

Deletes an FTA Country by its ID.

Checks whether a specific FTACountry exists by its ID.

The ID of the FTACountry to check. True if the FTACountry exists; otherwise, false.

Creates a new FTA record in the database.

The FTA object to be created. JSON details can be set in the DetailsJson property. The created FTA object.

Retrieves a specific FTA by its ID, including all related details.

The ID of the FTA to retrieve. The FTA object if found; otherwise, null. JSON details are accessible via DetailsJson.

Updates an existing FTA record in the database.

The ID of the FTA to update. The updated FTA object. JSON details can be set in the DetailsJson property. The updated FTA object.

Updates only the JSON data in the Details field of an FTA.

The ID of the FTA to update. The JSON data to store in the Details field, accessible via DetailsJson. The updated FTA object.

Deletes a specific FTA by its ID.

The ID of the FTA to delete. True if the deletion was successful; otherwise, false.

Lists FTAs with pagination and sorting options.

Number of items per page. The page number to retrieve. The property to order by. The direction to order (asc or desc). A list of FTAs matching the criteria.

Searches for HS data based on the country ID and input HS code.

The country ID for the search. The HS code to search for. A list of HS data matching the criteria.

Searches for FTAs between source and destination countries based on the input HS code.

The country ID. The HS code to filter FTAs. A list of FTAs matching the search criteria.

Parses and saves PSR data from an uploaded Excel file.

The uploaded Excel file containing PSR data. The ID of the FTA to associate with the PSR data. The version of the PSR data. The user ID of the person uploading the data. The status of the FTA.

Retrieves all PSR data for a specific FTA.

The ID of the FTA to retrieve PSR data for. A list of PSR records associated with the FTA.

Deletes a specific PSR record by its ID.

The ID of the PSR record to delete. True if the deletion was successful; otherwise, false.

Adds a new Rule of Origin.

The Rule of Origin input model. The newly created Rule of Origin.

Updates an existing Rule of Origin.

The ID of the Rule of Origin to update. The updated Rule of Origin input model. The updated Rule of Origin.

Retrieves a specific Rule of Origin by its ID.

The ID of the Rule of Origin to retrieve. The Rule of Origin, or null if not found.

Retrieves all Rules of Origin for a specific FTA.

The ID of the FTA. A list of Rules of Origin for the specified FTA.

Deletes a specific Rule of Origin by its ID.

The ID of the Rule of Origin to delete. True if deletion was successful, otherwise false.

Interface for managing FTA types within the application.

Retrieves a list of all FTA types.

Fetches an FTA type by its unique identifier.

Creates a new FTA type entry.

Updates an existing FTA type by its ID.

Deletes an FTA type by its ID.

Interface for managing language entities within the application.

Creates a new language entry.

Retrieves all languages.

Fetches a language by its unique identifier.

Updates an existing language by its ID.

Deletes a language by its ID.

Retrieves all media items asynchronously.

A collection of media items.

Retrieves a single media item by its ID asynchronously.

The ID of the media item. The media item if found, otherwise null.

Creates a new media item asynchronously.

The media item to create. The file to be uploaded as part of the media item. The created media item.

Updates an existing media item by its ID asynchronously.

The ID of the media item to update. The updated media data. Optional file data to update the media item. The updated media item if successful, otherwise null.

Deletes a media item by its ID asynchronously.

The ID of the media item to delete. True if deletion was successful, otherwise false.

Retrieves the URL of a media item by its ID and size asynchronously.

The ID of the media item. The size of the media (e.g., "full", "thumbnail"). The URL of the media if found, otherwise null.

Interface for managing Product-Specific Rules (PSR) within the application.

Retrieves a list of all PSRs.

Fetches a PSR by its unique identifier.

Creates a new PSR entry.

Details for creating the PSR.

Updates an existing PSR by its ID.

ID of the PSR to update. Updated PSR details.

Deletes a PSR by its ID.

ID of the PSR to delete.

Interface for managing application settings.

Asynchronously retrieves all application settings.

An enumerable collection of representing all settings.

Asynchronously updates or adds settings. If a setting with the same key exists, it is updated; otherwise, a new setting is added.

A collection of to update or add. Returns true if the operation succeeds; otherwise, false.

Asynchronously adds a new setting if it does not already exist based on its key.

The to add. Returns true if the setting is successfully added; false if the setting already exists or an error occurs.

Interface for managing Transaction Rule Set (TRS) within the application.

Adds TRS data from an uploaded file.

The uploaded TRS file. The ID of the associated FTA. The version of the TRS data. The ID of the associated FTACountry. The status of the TRS data.

Retrieves all TRS data for a given FTA Country ID in a structured format.

The FTACountryId of the associated FTA. A collection of structured TRS data.

Deletes TRS data by its data ID.

The ID of the TRS data to delete.

Deletes all TRS data associated with the specified FTATRS ID.

The ID of the FTATRS record.

Interface for user context service.

Retrieves the ID of the currently logged-in user.

Service for managing language entries within the application.

Creates a new language entry.

Retrieves all languages.

Fetches a language by its unique identifier.

Updates an existing language by its ID.

Deletes a language by its ID.

Service for managing media items, including CRUD operations and URL retrieval.

Retrieves all media items.

Retrieves a media item by its ID.

Creates a new media item with an optional file.

Updates an existing media item with optional new file data.

Deletes a media item by its ID.

Retrieves the URL of a media item by its ID and size.

Service for managing Product-Specific Rules (PSR) within the application.

Retrieves a list of all PSRs.

Fetches a PSR by its unique identifier.

Creates a new PSR entry.

Updates an existing PSR by its ID.

Deletes a PSR by its ID.

Service for retrieving and updating application settings.

Retrieves all settings.

Updates existing settings or adds new ones if not already present.

Adds a new setting if it does not already exist.

Validates a setting's key and value.

Saves changes to the database with logging and error handling.

Provides SFTP functionality for uploading, ensuring directory existence, and deleting files on a remote server.

Uploads a file to the SFTP server with a specified filename, creating the directory if it doesn't exist.

The custom name for the file on the server (e.g., MediaId). The file stream containing the data to upload.

Deletes a file from the SFTP server based on the specified filename.

The name of the file to delete on the server (e.g., MediaId).

Ensures that each directory in the specified path exists, creating it if necessary.

The SFTP client. The remote directory path to ensure exists.

Adds TRS data parsed from an uploaded Excel file.

Retrieves connected TRS data associated with a specific FTACountryId.

Deletes TRS data by its unique ID.

Security option for SMTP connection. Valid values: None, Auto, SslOnConnect, StartTls, StartTlsWhenAvailable Default: StartTls

Skip SMTP authentication. Set to true for internal mail servers that authorize by IP address. Default: false