/// <summary>
/// Get A95_1 產業別對應Ticker補登檔
/// </summary>
/// <param name="bondNumber"></param>
/// <returns></returns>
public List <A95_1ViewModel> getA95_1(string bondNumber)
{
List <A95_1ViewModel> result = new List <A95_1ViewModel>();
using (IFRS9DBEntities db = new IFRS9DBEntities())
{
result = db.Assessment_Sub_Kind_Ticker.AsNoTracking()
.Where(x => x.Bond_Number == bondNumber, !bondNumber.IsNullOrWhiteSpace())
.AsEnumerable()
.Select(x => new A95_1ViewModel()
{
Bond_Number = x.Bond_Number,
Bloomberg_Ticker = x.Bloomberg_Ticker,
Security_Des = x.Security_Des,
Processing_Date = TypeTransfer.dateTimeNTimeSpanNToString(x.LastUpdate_Date, x.LastUpdate_Time),
Processing_User = x.LastUpdate_User
})
.ToList();
}
return(result);
}