public static string GetPriceTier(string uscode)
{
var financeData = DataSync_LDW_AM_STFinanceData2.Search(f => f.UsCode == uscode)
.OrderByDescending(e => e.FinanceYear)
.ThenByDescending(e => e.FinanceMonth)
.FirstOrDefault();
string returnVal = "";
if (financeData != null)
{
returnVal = financeData.Price_Tier;
}
return(returnVal);
}
public static List <string> GetYearMonths(string projectId, out string SelectedYearMonth)
{
var uscode = RenewalInfo.FirstOrDefault(ci => ci.ProjectId == projectId).USCode;
var yearMonthList = DataSync_LDW_AM_STFinanceData2.Search(f => f.UsCode == uscode).Select(i => new { YearMonth = i.FinanceYear + "-" + i.FinanceMonth }).Distinct().OrderByDescending(i => i).Take(12).ToList().Select(i => { return(i.YearMonth); }).ToList();
var ldw_financeData = LDW_FinanceData.Get(projectId);
if (ldw_financeData != null)
{
SelectedYearMonth = ldw_financeData.FinanceYear + "-" + ldw_financeData.FinanceMonth;
}
else
{
SelectedYearMonth = yearMonthList.FirstOrDefault();
}
return(yearMonthList);
}