public IHttpActionResult GetTTMAndRoI(string projectId, string usCode, string dateTime, string pageType = "") { string year = string.Empty; string month = string.Empty; if (!string.IsNullOrEmpty(dateTime)) { //string time=dateTime.Split(',')[0]; //time = time.Split(':')[1]; //year = time.Split('-')[0].Substring(1, 4); //month = time.Split('-')[1].Substring(0, 2); year = dateTime.Split('-')[0]; month = dateTime.Split('-')[1]; } var data = DataSync_LDW_AM_STFinanceData.FirstOrDefault(e => e.FinanceYear == year && e.FinanceMonth == month && e.UsCode == usCode); var data2 = DataSync_LDW_AM_STFinanceData2.FirstOrDefault(e => e.FinanceYear == year && e.FinanceMonth == month && e.UsCode == usCode); if (data != null) { data.SOI_TTM = Math.Round(CovertToDecimalPercent(data.SOIPct_TTM), 1).ToString(); } var financialPreanalysisDto = new FinancialPreanalysisDto(); financialPreanalysisDto.STFinanceData = data; var reimageSum = ReimageSummary.GetReimageSummaryInfo(projectId); if (reimageSum != null && reimageSum.FinancialPreanalysis != null) { financialPreanalysisDto.Id = reimageSum.FinancialPreanalysis.Id; if (!reimageSum.FinancialPreanalysis.TTMSales.HasValue) { financialPreanalysisDto.TTMSales = data == null ? 0 : Convert.ToDecimal(data.Total_Sales_TTM); } else { financialPreanalysisDto.TTMSales = reimageSum.FinancialPreanalysis.TTMSales; } financialPreanalysisDto.ROI = reimageSum.FinancialPreanalysis.ROI; financialPreanalysisDto.PaybackYears = reimageSum.FinancialPreanalysis.PaybackYears; if (string.IsNullOrEmpty(reimageSum.FinancialPreanalysis.PaybackYears)) { financialPreanalysisDto.CurrentPriceTier = data2 == null ? "" : data2.Price_Tier; } else { financialPreanalysisDto.CurrentPriceTier = reimageSum.FinancialPreanalysis.CurrentPriceTier; } } return(Ok(financialPreanalysisDto)); //} }
public IHttpActionResult InitReimageSummary(string projectId, string entityId = "") { var entity = ReimageSummary.GetReimageSummaryInfo(projectId, entityId); return(Ok(new { entity = entity, isActor = ProjectUsers.IsRole(projectId, ClientCookie.UserCode, ProjectUserRoleCode.AssetActor) })); }
public IHttpActionResult GetReimageInfo(string projectId) { var reimageInfo = ReimageInfo.FirstOrDefault(e => e.ProjectId.Equals(projectId)); if (reimageInfo != null) { reimageInfo.IsSiteInfoSaveable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Reimage_SiteInfo); var siteInfo = ProjectInfo.FirstOrDefault(e => e.ProjectId.Equals(projectId) && e.FlowCode == FlowCode.Reimage_SiteInfo); if (siteInfo != null) { reimageInfo.SiteInfoId = siteInfo.Id; var estimatedVsActualConstruction = EstimatedVsActualConstruction.FirstOrDefault(e => e.RefId == siteInfo.Id); if (estimatedVsActualConstruction == null) { var consInfo = ReimageConsInfo.GetConsInfo(projectId); var reinBasicInfo = consInfo.ReinBasicInfo; var gbMemo = ReimageGBMemo.GetGBMemo(projectId); var storeInfo = StoreSTLocation.FirstOrDefault(e => e.StoreCode == siteInfo.USCode); var summary = ReimageSummary.GetReimageSummaryInfo(projectId); var afterReimagePriceTier = summary.FinancialPreanalysis != null ? summary.FinancialPreanalysis.PriceTierafterReimage : null; estimatedVsActualConstruction = new EstimatedVsActualConstruction { RefId = siteInfo.Id, GBDate = gbMemo.GBDate, CompletionDate = gbMemo.ConstCompletionDate, ARDC = reinBasicInfo.NewDesignType, OriginalOperationSize = storeInfo.TotalArea, OriginalSeatNumber = storeInfo.TotalSeatsNo, ARPT = afterReimagePriceTier }; } reimageInfo.EstimatedVsActualConstruction = estimatedVsActualConstruction; } } return(Ok(reimageInfo)); }
public IHttpActionResult GetSelectYearMonth(string projectId) { using (var amdb = new McdAMEntities()) { var selectItemList = new List <SelectItem>(); var uscode = ReimageInfo.FirstOrDefault(e => e.ProjectId == projectId).USCode; var reimageSummary = ReimageSummary.GetReimageSummaryInfo(projectId); if (reimageSummary != null) { var refId = reimageSummary.Id; var storeProfitabilityAndLeaseInfo = StoreProfitabilityAndLeaseInfo.FirstOrDefault(e => e.RefId == refId); var asOf = storeProfitabilityAndLeaseInfo != null ? storeProfitabilityAndLeaseInfo.AsOf : string.Empty; var yearMonthList = amdb.DataSync_LDW_AM_STFinanceData2.Where(f => f.UsCode == uscode).Select(i => new { financeYearMonth = i.FinanceYear + "-" + i.FinanceMonth }).Distinct().OrderByDescending(i => i.financeYearMonth).Take(12).ToList(); var ldw_financeData = LDW_FinanceData.Get(projectId); foreach (var _yearMonth in yearMonthList) { var selectItem = new SelectItem(); selectItem.name = _yearMonth.financeYearMonth; selectItem.value = _yearMonth.financeYearMonth; if (ldw_financeData != null) { selectItem.selected = _yearMonth.financeYearMonth == ldw_financeData.FinanceYear + "-" + ldw_financeData.FinanceMonth; } else { // selectItem.selected = false; selectItem.selected = _yearMonth.financeYearMonth == asOf; } selectItemList.Add(selectItem); } if (string.IsNullOrEmpty(asOf) && selectItemList.Count > 0) { selectItemList[0].selected = true; } } return(Ok(new { data = selectItemList })); } }