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

namespace MMDAL.CustomCode.Shift
{
    /// <summary>
    /// Data Access Layer interface for managing Shift records in the database.
    /// Provides methods to retrieve, insert, update, and delete shifts.
    /// </summary>
    public interface IShiftDAL
    {
        /// <summary>
        /// Retrieves a single shift by its unique identifier.
        /// </summary>
        /// <param name="ShiftId">The unique identifier of the shift.</param>
        /// <param name="LoginDTO">The current user's login details.</param>
        /// <returns>A JSON string representing the shift details.</returns>
        Task<string> GetShift(int ShiftId, LoginDTO LoginDTO);

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

        /// <summary>
        /// Inserts a new shift record into the database.
        /// </summary>
        /// <param name="ShiftDTO">The shift 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> SaveShift(ShiftDTO ShiftDTO, LoginDTO LoginDTO);

        /// <summary>
        /// Updates an existing shift record in the database.
        /// </summary>
        /// <param name="ShiftDTO">The updated shift 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> UpdateShift(ShiftDTO ShiftDTO, LoginDTO LoginDTO);

        /// <summary>
        /// Deletes a shift record by its unique identifier.
        /// </summary>
        /// <param name="ShiftId">The unique identifier of the shift 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> DeleteShift(int ShiftId, LoginDTO LoginDTO);
    }

}