public doExchangeRateForCalendar GetCurrentExchangeRate(DateTime?targetDate)
{
if (CommonUtil.IsNullOrEmpty(targetDate))
{
return(null);
}
var results = db.tbt_RateConversion.Where(e => e.TargetDate <= targetDate).OrderByDescending(e => e.TargetDate).Select(e => new
{
target_date = e.TargetDate,
start = e.TargetDate,
end = e.TargetDate,
title = "",
color = "",
all_day = "1",
bank_rate = e.BankRateRupiahPerDollar,
tax_rate = e.TaxRateRupiahPerDollar
});
if (results.Count() < 1)
{
return(null);
}
var item = results.First();
doExchangeRateForCalendar res = new doExchangeRateForCalendar();
res.target_date = item.target_date.ToString("d-MMM-yyyy");
res.all_day = item.all_day;
res.bank_rate = !CommonUtil.IsNullOrEmpty(item.bank_rate) ? ((decimal)item.bank_rate).ToString(floatNumberFormat) : "";
res.tax_rate = !CommonUtil.IsNullOrEmpty(item.tax_rate) ? ((decimal)item.tax_rate).ToString(floatNumberFormat) : "";
res.is_today = (item.target_date.Date == DateTime.Now.Date);
if (res.is_today)
{
res.color = "#FFFF66";
}
else
{
res.color = "#FFEEEE";
}
res.end = item.end.ToString("yyyy-MM-dd");
res.start = item.start.ToString("yyyy-MM-dd");
res.title = item.title;
return(res);
}
public List <doExchangeRateForCalendar> GetAllExchangeRateForCalendar()
{
var results = db.tbt_RateConversion.Select(e => new
{
target_date = e.TargetDate,
start = e.TargetDate,
end = e.TargetDate,
title = "",
color = "",
all_day = "1",
bank_rate = e.BankRateRupiahPerDollar,
tax_rate = e.TaxRateRupiahPerDollar
});
List <doExchangeRateForCalendar> resultList = new List <doExchangeRateForCalendar>();
foreach (var item in results)
{
doExchangeRateForCalendar res = new doExchangeRateForCalendar();
res.target_date = item.target_date.ToString("d-MMM-yyyy");
res.all_day = item.all_day;
res.bank_rate = !CommonUtil.IsNullOrEmpty(item.bank_rate) ? ((decimal)item.bank_rate).ToString(floatNumberFormat) : "";
res.tax_rate = !CommonUtil.IsNullOrEmpty(item.tax_rate) ? ((decimal)item.tax_rate).ToString(floatNumberFormat) : "";
res.is_today = (item.target_date.Date == DateTime.Now.Date);
if (res.is_today)
{
res.color = "#FFFF66";
}
else
{
res.color = "#FFEEEE";
}
res.end = item.end.ToString("yyyy-MM-dd");
res.start = item.start.ToString("yyyy-MM-dd");
res.title = item.title;
resultList.Add(res);
}
return(resultList);
}
