AIMS_BD_IATI.DAL.AimsDAL.GetExchangesRateToUSD C# (CSharp) Method

        public List<ExchangeRateModel> GetExchangesRateToUSD(string fromCurrencyISOcode, DateTime? date = null)
        {
            var q = (from e in dbContext.tblExchangeRateBBApis.Where(k => k.ISO_CURRENCY_CODE == fromCurrencyISOcode
                && (date == null ? true : k.DATE == date))
                     select new ExchangeRateModel
                     {
                         DATE = e.DATE,
                         ISO_CURRENCY_CODE = e.ISO_CURRENCY_CODE,

                         DOLLAR_PER_CURRENCY = e.DOLLAR_PER_CURRENCY,
                         CURRENCY_PER_DOLLAR = e.CURRENCY_PER_DOLLAR,

                         TAKA_PER_DOLLAR = e.TAKA_PER_CURRENCY / e.DOLLAR_PER_CURRENCY
                     })
                .ToList();


            return q;
        }
    }