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