using PayRollDAL.Query.TRMEmployee;
using static GB5Shared.DTO.Framework.Enum.FrameworkEnumDTO;

namespace PayRollDAL.Query.Employee
{
    public static class EmployeeQueryProvider
    {
        // ✅ GET Employee
        public static string GetEmployeeQuery(DatabaseType dbType)
        {
            return dbType switch
            {
                DatabaseType.SQL => EmployeeQB.GET_EMPLOYEE,
                DatabaseType.POSTGRE => EmployeeQB.GET_EMPLOYEE_PG,
                _ => throw new NotSupportedException($"DatabaseType '{dbType}' is not supported.")
            };
        }

        // ✅ GET Translation Employee — fix class name here
        public static string GetTRMEmployeeQuery(DatabaseType dbType)
        {
            return dbType switch
            {
                DatabaseType.SQL => TRMEmployeeQB.GET_TRMEMPLOYEE,      // ← whatever the class name is
                DatabaseType.POSTGRE => TRMEmployeeQB.GET_TRMEMPLOYEE_PG,   // ← same class
                _ => throw new NotSupportedException($"DatabaseType '{dbType}' is not supported.")
            };
        }
    }
}