using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using MMDAL.DTO.Terms;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MMDAL.CustomCode.Terms
{
    public interface ITermsDAL
    {

        /// <summary>
        /// Retrieves a single Terms by its unique identifier.
        /// </summary>
        /// <param name="TermsId">The unique identifier of the Terms.</param>
        /// <param name="LoginDTO">The current user's login details.</param>
        /// <returns>A JSON string representing the Terms details.</returns>
        Task<string> GetTerms(int TermsId, LoginDTO LoginDTO);

        /// <summary>
        /// Retrieves a list of Terms based on specified criteria.
        /// Typically used for populating dropdowns or picklists.
        /// </summary>
        /// <param name="TermsDTO">Filter criteria for selecting Terms.</param>
        /// <param name="LoginDTO">The current user's login details.</param>
        /// <returns>A JSON string representing a list of Terms.</returns>
        Task<string> GetSelectListTerms(CriteriaDTO CriteriaDTO, LoginDTO LoginDTO);

        /// <summary>
        /// Inserts a new Terms record into the database.CriteriaDTO
        /// </summary>
        /// <param name="CriteriaDTO">The Terms data to save.</param>
        /// <param name="LoginDTO">The current user's login details.</param>
        /// <returns>The number of rows affected (should be 1 if successful).</returns>
        Task<int> SaveTerms(TermsDTO TermsDTO, LoginDTO LoginDTO);

        /// <summary>
        /// Updates an existing Terms record in the database.
        /// </summary>
        /// <param name="TermsDTO">The updated Terms data.</param>
        /// <param name="LoginDTO">The current user's login details.</param>
        /// <returns>The number of rows affected (should be 1 if successful).</returns>
        Task<int> UpdateTerms(TermsDTO TermsDTO, LoginDTO LoginDTO);

        /// <summary>
        /// Deletes a Terms record by its unique identifier.
        /// </summary>
        /// <param name="TermsId">The unique identifier of the Terms to delete.</param>
        /// <param name="LoginDTO">The current user's login details.</param>
        /// <returns>A JSON string indicating success or failure of the delete operation.</returns>
        Task<string> DeleteTerms(int TermsId, LoginDTO LoginDTO);
    }
}