using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace FrameworkDAL.Query.BulkIce
{
    public static class BulkIceQB
    {
        public const string GET_BULKICE = @" 
        SELECT 
-- Parent: MBULKICE
BI.BULKICEID AS BulkIceId,
BI.BULKICECODE AS BulkIceCode,
BI.BULKICENAME AS BulkIceName,
BI.REMARKS AS BulkIceRemarks,
BI.NUMBEROFFILES AS BulkIceNumberOfFiles,
BI.TOTYPE AS BulkIceToType,
BI.CUSTOMPROCEDURENAME AS BulkIceCustomProcedureName,
BI.OTHERDETAILS AS BulkIceOtherDetails,
BI.SKIPOVERWRITE AS BulkIceSkipOverWrite,
BI.SORTORDER AS BulkIceSortOrder,
BI.STATUS AS BulkIceStatus,
BI.VERSION AS BulkIceVersion,
BI.CREATEDBYID AS BulkIceCreatedById,
BI.CREATEDON AS BulkIceCreatedOn,
BI.MODIFIEDBYID AS BulkIceModifiedById,
BI.MODIFIEDON AS BulkIceModifiedOn,
BI.SOURCETYPE AS BulkIceSourceType,
BI.TENANTID AS TenantId,
BI.APPROVALDURINGIMPORT AS ApprovalDuringImport,

-- Child: MBULKICEDETAIL (example columns — update as per your schema)
BID.BULKICEDETAILID AS BulkIceDetailId,
BID.BULKICEID AS BulkIceId,
BID.SLNO AS BulkIceDetailSLNo,
BID.REMARKS AS BulkIceDetailRemarks,
BID.FILETEMPLATE AS BulkIceDetailFileTemplate,
BID.TEMPTABLENAME AS BulkIceDetailTempTableName

FROM MBULKICE BI
LEFT JOIN MBULKICEDETAIL BID ON BI.BULKICEID = BID.BULKICEID
WHERE BI.BULKICEID = @bulkiceid;


        ";

        public const string GET_BULKICE_SELECTLIST = @"

WITH PagedBulkIce AS (
    SELECT
        A.BULKICEID AS BulkIceId,
        A.BULKICECODE AS BulkIceCode,
        A.BULKICENAME AS BulkIceName,
        A.NUMBEROFFILES AS NumberOfFiles,
        ROW_NUMBER() OVER (ORDER BY A.BULKICEID) AS RowNum
    FROM MBULKICE A
    WHERE (@bulkicename = '' OR A.BULKICENAME LIKE '%' + @bulkicename + '%')
)
SELECT
    BulkIceId,
    BulkIceCode,
    BulkIceName,
    NumberOfFiles
FROM PagedBulkIce
WHERE
    (@firstnumber = -1 AND @maxresult = -1)
    OR
    (RowNum BETWEEN (@firstnumber + 1) AND (@firstnumber + @maxresult));";
    }
}