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

namespace AdminDAL.Query.Currency
{
    public static class CurrencyQB
    {
        public const string GET_CURRENCY = @"SELECT
                                            CUR.CURRENCYID                 AS CurrencyId,
                                            CUR.CURRENCYCODE               AS CurrencyCode,
                                            CUR.CURRENCYNAME               AS CurrencyName,
                                            CUR.CURRENCYSYMBOL             AS CurrencySymbol,
                                            CUR.CURRENCYFULL               AS CurrencyFull,
                                            CUR.CURRENCYDECIMAL            AS CurrencyCurrencyDecimal,
                                            CUR.GSTCURRENCYCODE            AS CurrencyGstCurrencyCode,
                                            CUR.NUMBEROFDECIMAL            AS CurrencyNumberOfDecimal,
                                            CUR.DECIMALNAME                AS CurrencyDecimalName,
                                            CUR.CREATEDBYID                AS CurrencyCreatedById,
                                            CB.EMPLOYEENAME                AS CurrencyCreatedByName,
                                            CUR.CREATEDON                  AS CurrencyCreatedOn,

                                            CUR.MODIFIEDBYID               AS CurrencyModifiedById,
                                            MB.EMPLOYEENAME                AS CurrencyModifiedByName,
                                            CUR.MODIFIEDON                 AS CurrencyModifiedOn,

                                            CUR.SORTORDER                  AS CurrencySortOrder,
                                            CUR.STATUS                     AS CurrencyStatus,
                                            CUR.VERSION                    AS CurrencyVersion,
                                            
                                            CUR.SOURCETYPE                 AS CurrencySourceType,   
                                            CUR.TENANTID                   AS TenantId,
                                            CUR.GAINACCOUNTID              AS GainAccountId,
                                            GA.ACCOUNTCODE                 AS GainAccountCode,
                                            GA.ACCOUNTNAME                 AS GainAccountName,

                                            CUR.LOSSACCOUNTID              AS LossAccountId,
                                            LA.ACCOUNTCODE                 AS LossAccountCode,
                                            LA.ACCOUNTNAME                 AS LossAccountName

                                        FROM MCURRENCY CUR
                                        LEFT JOIN MEMPLOYEE CB ON CUR.CREATEDBYID = CB.EMPLOYEEID
                                        LEFT JOIN MEMPLOYEE MB ON CUR.MODIFIEDBYID = MB.EMPLOYEEID
                                        LEFT JOIN MACCOUNT GA ON CUR.GAINACCOUNTID = GA.ACCOUNTID
                                        LEFT JOIN MACCOUNT LA ON CUR.LOSSACCOUNTID = LA.ACCOUNTID
                                        WHERE
                                        CUR.CURRENCYID = @currencyid;";


        public const string SAVE_CURRENCY = @"INSERT INTO MCURRENCY 
                                            (
                                                CURRENCYID,
                                                CURRENCYCODE,
                                                CURRENCYSYMBOL,
                                                CURRENCYNAME,
                                                CURRENCYFULL,
                                                CURRENCYDECIMAL,
                                                SORTORDER,
                                                STATUS,
                                                VERSION,
                                                CREATEDBYID,
                                                CREATEDON,
                                                MODIFIEDBYID,
                                                MODIFIEDON,
                                                GAINACCOUNTID,
                                                LOSSACCOUNTID,
                                                DECIMALNAME,
                                                GSTCURRENCYCODE,
                                                NUMBEROFDECIMAL
                                            )
                                            VALUES
                                            (
                                                @CurrencyId,    
                                                @CurrencyCode,
                                                @CurrencySymbol,
                                                @CurrencyName,
                                                @CurrencyFull,
                                                @CurrencyCurrencyDecimal,
                                                @CurrencySortOrder,
                                                @CurrencyStatus,
                                                @CurrencyVersion,
                                                @CurrencyCreatedById,
                                                @CurrencyCreatedOn,
                                                @CurrencyModifiedById,
                                                @CurrencyModifiedOn,
                                                @GainAccountId,
                                                @LossAccountId,
                                                @CurrencyDecimalName,
                                                @CurrencyGstCurrencyCode,
                                                @CurrencyNumberOfDecimal
                                            );";

        public const string UPDATE_CURRENCY = @"UPDATE MCURRENCY
                                                SET
                                                    CURRENCYCODE = @CurrencyCode,
                                                    CURRENCYSYMBOL = @CurrencySymbol,
                                                    CURRENCYNAME = @CurrencyName,
                                                    CURRENCYFULL = @CurrencyFull,
                                                    CURRENCYDECIMAL = @CurrencyCurrencyDecimal,
                                                    SORTORDER = @CurrencySortOrder,
                                                    STATUS = @CurrencyStatus,
                                                    VERSION = @CurrencyVersion,
                                                    MODIFIEDBYID = @CurrencyModifiedById,
                                                    MODIFIEDON = @CurrencyModifiedOn,
                                                    GAINACCOUNTID = @GainAccountId,
                                                    LOSSACCOUNTID = @LossAccountId,
                                                    DECIMALNAME = @CurrencyDecimalName,
                                                    GSTCURRENCYCODE = @CurrencyGstCurrencyCode,
                                                    NUMBEROFDECIMAL = @CurrencyNumberOfDecimal
                                                WHERE
                                                    CURRENCYID = @CurrencyId;";


        public const string DELETE_CURRENCY = @"DELETE FROM MCURRENCY
                                                WHERE CURRENCYID = @currencyid;";


        public const string GET_SELECTLIST_CURRENCY = @"SELECT
                                                        CURRENCYID            AS Id,
                                                        CURRENCYCODE          AS Code,
                                                        CURRENCYNAME          AS Name,
                                                        CURRENCYSYMBOL        AS Symbol,
                                                        CURRENCYDECIMAL       AS CurrencyDecimal
                                                    FROM MCURRENCY
                                                    ORDER BY CURRENCYNAME;";
    }
}