public static List <SelectItem> GetSelectYearMonth(string uscode) { var financeData = DataSync_LDW_AM_STFinanceData.Search(f => f.UsCode == uscode) .Distinct() .OrderByDescending(e => e.FinanceYear) .ThenByDescending(e => e.FinanceMonth).Take(12).ToList(); List <SelectItem> returnList = new List <SelectItem>(); var index = 0; foreach (var item in financeData) { SelectItem sItem = new SelectItem(); var yearMonth = item.FinanceYear + "-" + item.FinanceMonth; sItem.Name = yearMonth; sItem.Value = item.Total_Sales_TTM; if (index == 0) { sItem.Selected = true; } else { sItem.Selected = false; } index++; returnList.Add(sItem); } return(returnList); }
public static string GetTTFinanceData(string uscode) { var financeData = DataSync_LDW_AM_STFinanceData.Search(f => f.UsCode == uscode) .OrderByDescending(e => e.FinanceYear) .ThenByDescending(e => e.FinanceMonth) .FirstOrDefault(); string returnVal = ""; if (financeData != null) { returnVal = financeData.Total_Sales_TTM; } return(returnVal); }
public FinancialPreanalysis LoadFinancialPreanalysisInfo() { var stFinanceData = DataSync_LDW_AM_STFinanceData.OrderByDescending(e => e.FinanceYear == DateTime.Now.Year.ToString(), e => e.FinanceMonth).FirstOrDefault(); if (stFinanceData == null) { throw new Exception("Could not get the latest finance month data!"); } var latestMonth = stFinanceData.FinanceMonth; using (var context = GetDb()) { var query = from financeData in context.DataSync_LDW_AM_STFinanceData join financeData2 in context.DataSync_LDW_AM_STFinanceData2 on new { financeData.UsCode, financeData.FinanceYear, financeData.FinanceMonth } equals new { financeData2.UsCode, financeData2.FinanceYear, financeData2.FinanceMonth } where financeData.FinanceMonth == latestMonth select new { TTMSales = financeData == null ? "" : financeData.Total_Sales_TTM, ROI = financeData2 == null ? "" : financeData2.C_ROI_TTM, CurrentPriceTier = financeData2 == null ? "" : financeData2.Price_Tier }; var result = query.FirstOrDefault(); return(new FinancialPreanalysis() { TTMSales = result.TTMSales.As <decimal>(), ROI = result.ROI, CurrentPriceTier = result.CurrentPriceTier }); } }
public static TTMFinanceData GetFinanceData(string projectId, string financeYear = "", string financeMonth = "") { var ldw_FinanceData = LDW_FinanceData.Get(projectId); var ttmData = new TTMFinanceData(); if (string.IsNullOrEmpty(financeYear) && string.IsNullOrEmpty(financeMonth) && ldw_FinanceData != null) { ttmData.Accounting = DataConverter.ToDecimal(ldw_FinanceData.Accounting_TTM); ttmData.DepreciationEssd = DataConverter.ToDecimal(ldw_FinanceData.Depreciation_Essd_TTM); ttmData.DepreciationLhi = DataConverter.ToDecimal(ldw_FinanceData.Depreciation_LHI_TTM); ttmData.NonProductCosts = DataConverter.ToDecimal(ldw_FinanceData.Non_Product_Costs_TTM); ttmData.NonProductSales = DataConverter.ToDecimal(ldw_FinanceData.Non_Product_Sales_TTM); ttmData.Insurance = DataConverter.ToDecimal(ldw_FinanceData.Insurance_TTM); ttmData.InterestEssd = DataConverter.ToDecimal(ldw_FinanceData.Interest_Essd_TTM); ttmData.InterestLhi = DataConverter.ToDecimal(ldw_FinanceData.Interest_LHI_TTM); ttmData.OtherIncExp = DataConverter.ToDecimal(ldw_FinanceData.Other_Exp_TTM); ttmData.Pac = DataConverter.ToDecimal(ldw_FinanceData.Pac_TTM); ttmData.ProductSales = DataConverter.ToDecimal(ldw_FinanceData.ProductSales_TTM); ttmData.Rent = DataConverter.ToDecimal(ldw_FinanceData.Rent_TTM); ttmData.ServiceFee = DataConverter.ToDecimal(ldw_FinanceData.Service_Fee_TTM); ttmData.TaxesAndLicenses = DataConverter.ToDecimal(ldw_FinanceData.Taxes_Licenses_TTM); ttmData.CompSales = DataConverter.ToDecimal(ldw_FinanceData.comp_sales_ttm); } else { var yearMonthObj = StoreSTMonthlyFinaceInfoTTM.FirstOrDefault(f => true); if (string.IsNullOrEmpty(financeYear)) { if (yearMonthObj != null && !string.IsNullOrEmpty(yearMonthObj.TTMValue)) { financeYear = yearMonthObj.TTMValue.Substring(0, yearMonthObj.TTMValue.IndexOf('-')); } else { financeYear = Utils.GetLatestYear(); } } if (string.IsNullOrEmpty(financeMonth)) { if (yearMonthObj != null && !string.IsNullOrEmpty(yearMonthObj.TTMValue)) { financeMonth = yearMonthObj.TTMValue.Substring(yearMonthObj.TTMValue.IndexOf('-') + 1); } else { financeMonth = Utils.GetLatestMonth(); } } var uscode = RenewalInfo.Get(projectId).USCode; var storeId = StoreBasicInfo.Search(s => s.StoreCode.Equals(uscode)).Select(id => id.StoreID).FirstOrDefault(); var financeData = DataSync_LDW_AM_STFinanceData.FirstOrDefault(f => f.UsCode == uscode && f.FinanceYear.Equals(financeYear) && f.FinanceMonth.Equals(financeMonth)); var financeData2 = DataSync_LDW_AM_STFinanceData2.FirstOrDefault(f => f.UsCode == uscode && f.FinanceYear.Equals(financeYear) && f.FinanceMonth.Equals(financeMonth)); var re = DataSync_LDW_AM_STMonthlyFinaceInfo.Search(f => f.StoreID == storeId).OrderByDescending(f => f.Year).FirstOrDefault(); ttmData.Accounting = DataConverter.ToDecimal(financeData2.Accounting_TTM); ttmData.DepreciationEssd = DataConverter.ToDecimal(financeData2.Depreciation_Essd_TTM); ttmData.DepreciationLhi = DataConverter.ToDecimal(financeData2.Depreciation_LHI_TTM); ttmData.NonProductCosts = DataConverter.ToDecimal(financeData2.Non_Product_Costs_TTM); ttmData.NonProductSales = DataConverter.ToDecimal(financeData2.Non_Product_Sales_TTM); ttmData.Insurance = DataConverter.ToDecimal(financeData2.Insurance_TTM); ttmData.InterestEssd = DataConverter.ToDecimal(financeData2.Interest_Essd_TTM); ttmData.InterestLhi = DataConverter.ToDecimal(financeData2.Interest_LHI_TTM); ttmData.OtherIncExp = DataConverter.ToDecimal(financeData2.Other_Exp_TTM); ttmData.Pac = DataConverter.ToDecimal(financeData2.Pac_TTM); ttmData.ProductSales = DataConverter.ToDecimal(financeData.ProductSales_TTM); ttmData.Rent = DataConverter.ToDecimal(financeData2.Rent_TTM); ttmData.ServiceFee = DataConverter.ToDecimal(financeData2.Service_Fee_TTM); ttmData.TaxesAndLicenses = DataConverter.ToDecimal(financeData2.Taxes_Licenses_TTM); ttmData.CompSales = DataConverter.ToDecimal(financeData2.comp_sales_ttm); } return(ttmData); }