namespace AdminDAL.Query.Charge
{
    public static class ChargeQB
    {
        public const string GET_CHARGE = @"
SELECT
    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,
    CD.CHARGEDETAILID                   AS ChargeDetailId,
    C.CHARGEID                          AS ChargeId,
    C.CHARGECODE                        AS ChargeCode,
    C.CHARGENAME                        AS ChargeName,
    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;";
    }
}