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

namespace AdminDAL.Query.Exchange
{
    public static class ExchangeQB
    {
        public const string GET_EXCHANGE = @"SELECT
                            E.EXCHANGEID AS ExchangeId,
                            E.BASECURRENCYID AS BaseCurrencyId,
                            MC.CURRENCYCODE AS BaseCurrencyCode,
                            MC.CURRENCYNAME AS BaseCurrencyName,
                            E.CURRENCYID AS CurrencyId,
                            C.CURRENCYCODE AS CurrencyCode,
                            C.CURRENCYNAME AS CurrencyName,
                            E.EXCHANGEDATE AS ExchangeExchangeDate,
                            E.CONVERSIONRATE AS ExchangeConversionRate,
                            E.SORTORDER AS ExchangeSortOrder,
                            E.STATUS AS ExchangeStatus,
                            E.VERSION AS ExchangeVersion,
                            E.CREATEDBYID AS ExchangeCreatedById,
                            E.CREATEDON AS ExchangeCreatedOn,
                            E.MODIFIEDBYID AS ExchangeModifiedById,
                            E.MODIFIEDON AS ExchangeModifiedOn
                            FROM MEXCHANGE E
                            LEFT JOIN MCURRENCY C ON E.CURRENCYID = C.CURRENCYID
                            LEFT JOIN MCURRENCY MC ON E.BASECURRENCYID = MC.CURRENCYID
                            WHERE E.EXCHANGEID = @exchangeid;
                            ";

        public const string GET_SELECTLIST_CURRENCY_DETAILS = @"SELECT
                            E.EXCHANGEID AS ExchangeId,
                            E.BASECURRENCYID AS BaseCurrencyId,
                            MC.CURRENCYCODE AS BaseCurrencyCode,
                            MC.CURRENCYNAME AS BaseCurrencyName,
                            E.CURRENCYID AS CurrencyId,
                            C.CURRENCYCODE AS CurrencyCode,
                            C.CURRENCYNAME AS CurrencyName,
                            E.EXCHANGEDATE AS ExchangeExchangeDate,
                            E.CONVERSIONRATE AS ExchangeConversionRate,
                            E.SORTORDER AS ExchangeSortOrder,
                            E.STATUS AS ExchangeStatus,
                            E.VERSION AS ExchangeVersion,
                            E.CREATEDBYID AS ExchangeCreatedById,
                            E.CREATEDON AS ExchangeCreatedOn,
                            E.MODIFIEDBYID AS ExchangeModifiedById,
                            E.MODIFIEDON AS ExchangeModifiedOn
                            FROM MEXCHANGE E
                            LEFT JOIN MCURRENCY C ON E.CURRENCYID = C.CURRENCYID
                            LEFT JOIN MCURRENCY MC ON E.BASECURRENCYID = MC.CURRENCYID;
                            ";

        //public const string GET_SELECTLIST_EXCHANGE_DETAILS = @"SELECT
        //                    E.EXCHANGEID AS ExchangeId,
        //                    E.BASECURRENCYID AS BaseCurrencyId,
        //                    MC.CURRENCYCODE AS BaseCurrencyCode,
        //                    MC.CURRENCYNAME AS BaseCurrencyName,
        //                    E.CURRENCYID AS CurrencyId,
        //                    C.CURRENCYCODE AS CurrencyCode,
        //                    C.CURRENCYNAME AS CurrencyName,
        //                    E.EXCHANGEDATE AS ExchangeExchangeDate,
        //                    E.CONVERSIONRATE AS ExchangeConversionRate,
        //                    E.SORTORDER AS ExchangeSortOrder,
        //                    E.STATUS AS ExchangeStatus,
        //                    E.VERSION AS ExchangeVersion,
        //                    E.CREATEDBYID AS ExchangeCreatedById,
        //                    E.CREATEDON AS ExchangeCreatedOn,
        //                    E.MODIFIEDBYID AS ExchangeModifiedById,
        //                    E.MODIFIEDON AS ExchangeModifiedOn
        //                    FROM MEXCHANGE E
        //                    LEFT JOIN MCURRENCY C ON E.CURRENCYID = C.CURRENCYID
        //                    LEFT JOIN MCURRENCY MC ON E.BASECURRENCYID = MC.CURRENCYID;
        //                    ";

        public const string SAVE_EXCHANGE = @"INSERT 
                            INTO MEXCHANGE (
                                 EXCHANGEID,
                                 BASECURRENCYID,
                                 CURRENCYID,
                                 EXCHANGEDATE,
                                 CONVERSIONRATE,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON
                            ) VALUES (
                                 @ExchangeId,
                                 @BaseCurrencyId,
                                 @CurrencyId,
                                 @ExchangeExchangeDate,
                                 @ExchangeConversionRate,
                                 @ExchangeSortOrder,
                                 @ExchangeStatus,
                                 @ExchangeVersion,
                                 @ExchangeCreatedById,
                                 @ExchangeCreatedOn,
                                 @ExchangeModifiedById,
                                 @ExchangeModifiedOn
                            );
                            ";

        public const string UPDATE_EXCHANGE = @"UPDATE 
                            MEXCHANGE SET
                            BASECURRENCYID = @BaseCurrencyId,
                            CURRENCYID = @CurrencyId,
                            EXCHANGEDATE = @ExchangeExchangeDate,
                            CONVERSIONRATE = @ExchangeConversionRate,
                            SORTORDER = @ExchangeSortOrder,
                            STATUS = @ExchangeStatus,
                            VERSION = @ExchangeVersion,
                            MODIFIEDBYID = @ExchangeModifiedById,
                            MODIFIEDON = @ExchangeModifiedOn
                            WHERE EXCHANGEID = @ExchangeId;
                            ";

        public const string DELETE_EXCHANGE = @"DELETE 
                            FROM MEXCHANGE
                            WHERE EXCHANGEID = @exchangeid;
                            ";
    }
}