public List <EXCHANGERATEINFO> QueryExchangeRateList()
{
var xchangeRateList = new EXCHANGERATELIST();
var rateInfoList = new List <EXCHANGERATEINFO>();
try
{
foreach (string CurrencyName in INIT_CURRENCY_LIST)
{
var result = oOradbaccess.GetRate(CurrencyName);
if (result != null && result.Rows.Count > 0)
{
EXCHANGERATEINFO xchngRate = null;
foreach (DataRow drTran in result.Rows)
{
xchngRate = new EXCHANGERATEINFO();
xchngRate.CURRENCY = drTran[TAG_CURRENCY].ToString();
xchngRate.BUYRATE = Convert.ToDecimal(drTran[TAG_BUY_RATE].ToString().Trim());
xchngRate.RATEDATE = DateTime.Parse(drTran[TAG_RATE_DATE].ToString().Trim(), CultureInfo.InvariantCulture).ToString("dd/MM/yyyy");
xchngRate.RATETYPE = drTran[TAG_RATE_TYPE].ToString();
xchngRate.SALERATE = Convert.ToDecimal(drTran[TAG_SALE_RATE].ToString().Trim());
rateInfoList.Add(xchngRate);
}
}
}
}
catch (Exception ex)
{
}
return(rateInfoList);
}
public EXCHANGERATELIST GetRateOnlyCashList()
{
var Result = new EXCHANGERATELIST();
try
{
List <EXCHANGERATEINFO> rateInfoList = new List <EXCHANGERATEINFO>();
rateInfoList = oOracleDBAccessServiceLayer.QueryExchangeRateList();
Result.RATELIST = rateInfoList.Where(t => t.RATETYPE == TAG_EXCHANGE_RATE_TYPE).ToList();
Result.STATUS = true;
Result.REQMSG = rateInfoList.Count.ToString();
}
catch (Exception ex)
{
Result.STATUS = false;
Result.REQMSG = (ex.InnerException != null) ? ex.Message : ex.InnerException.Message;
}
return(Result);
}
