REATE OR ALTER PROCEDURE [dbo].[GetWorkersPage]
    @takeCount INT = 10,
    @page INT,
    @activeIndex INT,
    @orderIndex INT,
    @orderDescending bit,
    @startHour nvarchar(12),
    @startMinute nvarchar(12),
    @endHour nvarchar(12),
    @endMinute nvarchar(12),
    @offerType INT,
    @rateType INT,
    @stageId uniqueidentifier NULL,
    @TotalElementsCount INT OUT,
    @Error nvarchar(128) OUT,
    @ErrorCode nvarchar(128) OUT
AS
BEGIN
    SET NOCOUNT ON;

    SELECT
        EmployeeId,
        ShiftId,
        u.FirstName,
        u.LastName,
        (ee.ThumbsUp / ee.ThumbsUp + ee.ThumbsDown) * 5 AS Rating,
        1 AS CanCancel, --@TODO
        1 AS CanApprove --@TODO
    FROM
        ShiftOffers o
        INNER JOIN shifts s ON o.ShiftId = s.Id
        INNER JOIN Employees ee ON o.EmployeeId = ee.Id
        INNER JOIN Users u ON ee.UserId = u.Id
    WHERE
        FORMAT ( s.UtcStartDateTime ,'HH', 'en-US') = @startHour AND
        FORMAT ( s.UtcStartDateTime ,'mm', 'en-US') = @startMinute AND
        FORMAT ( s.UtcEndDateTime ,'HH', 'en-US') = @endHour AND
        FORMAT ( s.UtcEndDateTime ,'mm', 'en-US') = @endMinute AND
        s.OfferType = @offerType AND
        s.RateType = @rateType
    ORDER BY s.UtcStartDateTime
    OFFSET (@takeCount * @page) ROWS
    FETCH NEXT @takeCount ROWS ONLY;

    SET @TotalElementsCount = 10;
    SET @Error = '';
    SET @ErrorCode = '';
END