/// <summary> /// Get /// Calls [usp_select_Currency] /// </summary> public static Currency Get(System.Int32?currencyId) { Rebound.GlobalTrader.DAL.CurrencyDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Currency.Get(currencyId); if (objDetails == null) { return(null); } else { Currency obj = new Currency(); obj.CurrencyId = objDetails.CurrencyId; obj.CurrencyCode = objDetails.CurrencyCode; obj.CurrencyDescription = objDetails.CurrencyDescription; obj.Symbol = objDetails.Symbol; obj.ClientNo = objDetails.ClientNo; obj.Buy = objDetails.Buy; obj.Sell = objDetails.Sell; obj.Inactive = objDetails.Inactive; obj.UpdatedBy = objDetails.UpdatedBy; obj.DLUP = objDetails.DLUP; //[001] code start obj.Notes = objDetails.Notes; //[001] code end obj.GlobalCurrencyNo = objDetails.GlobalCurrencyNo; objDetails = null; return(obj); } }
/// <summary> /// GetConvertedValueBetweenTwoCurrencies /// Calls [usp_select_Currency_ConvertedValueBetweenTwoCurrencies] /// </summary> public static Currency GetConvertedValueBetweenTwoCurrencies(System.Double?valueToBeConverted, System.Int32?currencyFromId, System.Int32?currencyToId, System.DateTime?exchangeRateDate) { Rebound.GlobalTrader.DAL.CurrencyDetails objDetails = Rebound.GlobalTrader.DAL.SiteProvider.Currency.GetConvertedValueBetweenTwoCurrencies(valueToBeConverted, currencyFromId, currencyToId, exchangeRateDate); if (objDetails == null) { return(null); } else { Currency obj = new Currency(); obj.ConvertedValue = objDetails.ConvertedValue; objDetails = null; return(obj); } }
/// <summary> /// Returns a new CurrencyDetails instance filled with the DataReader's current record data /// </summary> protected virtual CurrencyDetails GetCurrencyFromReader(DbDataReader reader) { CurrencyDetails currency = new CurrencyDetails(); if (reader.HasRows) { currency.CurrencyId = GetReaderValue_Int32(reader, "CurrencyId", 0); //From: [Table] currency.GlobalCurrencyNo = GetReaderValue_Int32(reader, "GlobalCurrencyNo", 0); //From: [Table] currency.CurrencyCode = GetReaderValue_String(reader, "CurrencyCode", ""); //From: [usp_list_Activity_by_Client_with_filter] currency.CurrencyDescription = GetReaderValue_String(reader, "CurrencyDescription", ""); //From: [usp_select_Client] currency.Symbol = GetReaderValue_String(reader, "Symbol", ""); //From: [Table] currency.ClientNo = GetReaderValue_Int32(reader, "ClientNo", 0); //From: [Table] currency.Buy = GetReaderValue_Boolean(reader, "Buy", false); //From: [Table] currency.Sell = GetReaderValue_Boolean(reader, "Sell", false); //From: [Table] currency.Inactive = GetReaderValue_Boolean(reader, "Inactive", false); //From: [Table] currency.UpdatedBy = GetReaderValue_NullableInt32(reader, "UpdatedBy", null); //From: [Table] currency.DLUP = GetReaderValue_DateTime(reader, "DLUP", DateTime.MinValue); //From: [Table] currency.ConvertedValue = GetReaderValue_NullableDouble(reader, "ConvertedValue", null); //From: [usp_select_Currency_ConvertedValueBetweenTwoCurrencies] currency.ClientDefaultCurrencyCode = GetReaderValue_String(reader, "ClientDefaultCurrencyCode", ""); //From: [usp_selectAll_Currency_for_Client] currency.ClientDefaultCurrencyNo = GetReaderValue_Int32(reader, "ClientDefaultCurrencyNo", 0); //From: [usp_selectAll_Currency_for_Client] } return(currency); }