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); }