using GB5Shared.DTO.Framework.Login;
using TMSDAL.DTO.KpiPosting;

namespace TMSDAL.CustomCode.KpiPosting
{
    public interface ITmsKpiPostingDAL
    {
        Task<(int PeriodDetailId, DateTime FromDate, DateTime ToDate)?> ResolveCurrentMonthlyPeriod(LoginDTO login, CancellationToken ct);
        Task<int?> GetPreviousMonthlyPeriodDetailId(int periodDetailId, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetPreviousActual(int kpiId, int periodDetailId, int ouId, LoginDTO login, CancellationToken ct);
        Task<List<KpiStatusBandDTO>> GetStatusBands(int kpiId, LoginDTO login, CancellationToken ct);
        Task DeleteExistingValues(int periodDetailId, int ouId, List<int> kpiIds, LoginDTO login, CancellationToken ct);
        Task InsertValue(int kpiId, int periodDetailId, int ouId, decimal? actual, byte? trend, int statusId, LoginDTO login, CancellationToken ct);

        Task<decimal?> GetComplianceCoveragePct(DateTime toDate, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetNominationApprovalTatDays(DateTime fromDate, DateTime toDate, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetCostPerTrainedEmployee(DateTime fromDate, DateTime toDate, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetVenueUtilizationPct(DateTime fromDate, DateTime toDate, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetPassRatePct(DateTime fromDate, DateTime toDate, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetFirstAttemptPassRatePct(DateTime fromDate, DateTime toDate, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetSkillUpgradeApprovalRatePct(DateTime fromDate, DateTime toDate, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetCertRenewalCompliancePct(DateTime toDate, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetExpiringCertificates30D(LoginDTO login, CancellationToken ct);
        Task<decimal?> GetFeedbackResponseRatePct(DateTime fromDate, DateTime toDate, LoginDTO login, CancellationToken ct);
        Task<decimal?> GetLearningGainPct(DateTime fromDate, DateTime toDate, LoginDTO login, CancellationToken ct);
    }
}