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

namespace MMDAL.Query.Charge
{
    public static class ChargeQB
    {
        public const string GET_CHARGE = @"

SELECT

-- =====================================
-- Parent : MCHARGE
-- =====================================
C.CHARGEID                 AS ChargeId,
C.CHARGECODE               AS ChargeCode,
C.CHARGENAME               AS ChargeName,
C.CHARGETYPE               AS ChargeType,
C.REVERSEFORMULAID         AS ReverseFormulaId,

RF.FORMULACODE             AS ReverseFormulaCode,
RF.FORMULANAME             AS ReverseFormulaName,
RF.EXPRESSION              AS ReverseFormulaExpression,

C.SORTORDER                AS ChargeSortOrder,
C.STATUS                   AS ChargeStatus,
C.VERSION                  AS ChargeVersion,
C.CREATEDBYID              AS ChargeCreatedById,
C.CREATEDON                AS ChargeCreatedOn,
C.MODIFIEDBYID             AS ChargeModifiedById,
C.MODIFIEDON               AS ChargeModifiedOn,
C.SOURCETYPE               AS ChargeSourceType,
C.TENANTID                 AS TenantId,

-- =====================================
-- Child : MCHARGEDETAIL
-- =====================================
CD.CHARGEDETAILID          AS ChargeDetailId,
CD.CHARGEID                AS ChargeDetailChargeId,
CD.SLNO                    AS ChargeDetailSlNo,
CD.SECTION                 AS ChargeDetailSection,

CD.CHARGEELEMENTID         AS ChargeElementId,
CE.CHARGEELEMENTCODE       AS ChargeElementCode,
CE.CHARGEELEMENTNAME       AS ChargeElementName,

CD.FORMULAID               AS FormulaId,
F.FORMULACODE              AS FormulaCode,
F.FORMULANAME              AS FormulaName,
F.EXPRESSION               AS FormulaExpression,
F.PRINTINGNAME             AS FormulaPrintingName,

CD.OPERATIONTYPE           AS ChargeDetailOperationType,
CD.CHARGENATURE            AS ChargeDetailChargeNature,
CD.INCLUDEINCOST           AS ChargeDetailIncludeInCost,
CD.INCLUDEINREALISATION    AS ChargeDetailIncludeInRealisation,
CD.INPUTVALUETYPE          AS ChargeDetailInputValueType,
CD.INPUTTYPE               AS ChargeDetailInputType,
CD.DEFAULTINPUTVALUE       AS ChargeDetailDefaultInputValue,
CD.DEFAULTMINIMUMVALUE     AS ChargeDetailDefaultMinimumValue,
CD.DEFAULTMAXIMUMVALUE     AS ChargeDetailDefaultMaximumValue,

CD.INPUTDATAFIELDID        AS InputDataFieldId,
CD.MINIMUMDATAFIELDID      AS MinimumDataFieldId,
CD.MAXIMUMDATAFIELDID      AS MaximumDataFieldId,

CD.LOADVALIDATIONTYPE      AS ChargeDetailLoadValidationType,
CD.TOLERANCETYPE           AS ChargeDetailToleranceType,
CD.TOLERANCEPLUSVALUE      AS ChargeDetailTolerancePlusValue,
CD.TOLERANCEMINUSVALUE     AS ChargeDetailToleranceMinusValue,

CD.PARTYACCOUNTTYPE        AS ChargeDetailPartyAccountType,
CD.PARTYACCOUNTID          AS PartyAccountId,
CD.PARTYSUBACCOUNTID       AS PartySubAccountId,
CD.PARTYLINKTYPE           AS ChargeDetailPartyLinkType,

CD.CONTRAACCOUNTTYPE       AS ChargeDetailContraAccountType,
CD.CONTRAACCOUNTID         AS ContraAccountId,
CD.CONTRASUBACCOUNTID      AS ContraSubAccountId,

CD.PARTYACCOUNTCRITERIACONFIG   AS PartyAccountCriteriaConfigId,
CD.CONTRAACCOUNTCRITERIACONFIG  AS ContraAccountCriteriaConfigId,

CD.DEPENDSONCHARGEELEMENT  AS DependsOnChargeElementId,
CD.PARTYACCOUNTMERGE       AS ChargeDetailPartyAccountMerge,
CD.CONTRAACCOUNTMERGE      AS ChargeDetailContraAccountMerge,

CD.INPUTDATAFIELDTYPE      AS ChargeDetailInputDataFieldType,
CD.MINIMUMDATAFIELDTYPE    AS ChargeDetailMinimumDataFieldType,
CD.MAXIMUMDATAFIELDTYPE    AS ChargeDetailMaximumDataFieldType,
CD.PRINTREQUIRED           AS ChargeDetailPrintRequired

FROM MCHARGE C

LEFT JOIN MFORMULA RF 
    ON C.REVERSEFORMULAID = RF.FORMULAID

LEFT JOIN MCHARGEDETAIL CD 
    ON C.CHARGEID = CD.CHARGEID

LEFT JOIN MFORMULA F 
    ON CD.FORMULAID = F.FORMULAID

LEFT JOIN MCHARGEELEMENT CE 
    ON CD.CHARGEELEMENTID = CE.CHARGEELEMENTID

WHERE C.CHARGEID = @ChargeId

ORDER BY CD.SLNO;
";

        public const string SAVE_CHARGE = @"
INSERT INTO MCHARGE (
    CHARGEID,
    CHARGECODE,
    CHARGENAME,
    CHARGETYPE,
    REVERSEFORMULAID,
    SORTORDER,
    STATUS,
    VERSION,
    CREATEDBYID,
    CREATEDON,
    MODIFIEDBYID,
    MODIFIEDON,
    SOURCETYPE,
    TENANTID
)
VALUES (
    @ChargeId,
    @ChargeCode,
    @ChargeName,
    @ChargeType,
    @ReverseFormulaId,
    @ChargeSortOrder,
    @ChargeStatus,
    @ChargeVersion,
    @ChargeCreatedById,
    @ChargeCreatedOn,
    @ChargeModifiedById,
    @ChargeModifiedOn,
    @ChargeSourceType,
    @TenantId
);
";

        public const string UPDATE_CHARGE = @"
UPDATE MCHARGE
SET
    CHARGECODE = @ChargeCode,
    CHARGENAME = @ChargeName,
    CHARGETYPE = @ChargeType,
    REVERSEFORMULAID = @ReverseFormulaId,
    SORTORDER = @ChargeSortOrder,
    STATUS = @ChargeStatus,
    VERSION = @ChargeVersion,
    MODIFIEDBYID = @ChargeModifiedById,
    MODIFIEDON = @ChargeModifiedOn,
    SOURCETYPE = @ChargeSourceType,
    TENANTID = @TenantId
WHERE CHARGEID = @ChargeId;
";

        public const string DELETE_CHARGE = @"
DELETE FROM MCHARGE WHERE CHARGEID = @ChargeId;
";

        public const string GET_SELECTLIST_CHARGE = @"
SELECT
    CHARGEID   AS Id,
    CHARGECODE AS Code,
    CHARGENAME AS Name,
    CHARGETYPE AS Type
FROM MCHARGE
WHERE STATUS = 1
ORDER BY SORTORDER;
";
    }
}