public static RenewalAnalysisDTO InitPage(string projectId)
{
RenewalAnalysisDTO dto = new RenewalAnalysisDTO();
var consInfo = RenewalConsInfo.Get(projectId);
var analysis = Get(projectId);
if (consInfo.HasReinvenstment)
{
var reinBasic = ReinvestmentBasicInfo.GetByConsInfoId(consInfo.Id) ?? new ReinvestmentBasicInfo();
analysis.OperationSize = reinBasic.NewOperationSize;
}
dto.Info = RenewalInfo.Get(projectId);
analysis.LastRemodeling = GetLastRemodeling(dto.Info.USCode);
dto.Entity = analysis;
dto.HasReinvenstment = consInfo.HasReinvenstment;
dto.StoreInfo = PrepareStoreInfo(projectId, dto.Info.USCode);
dto.Editable = ProjectInfo.IsFlowEditable(projectId, FlowCode.Renewal_Analysis);
dto.Recallable = ProjectInfo.IsFlowRecallable(projectId, FlowCode.Renewal_Analysis);
dto.Savable = ProjectInfo.IsFlowSavable(projectId, FlowCode.Renewal_Analysis);
return(dto);
}
private static RenewalAnalysisStoreInfo PrepareStoreInfo(string projectId, string usCode)
{
var store = StoreBasicInfo.GetStorInfo(usCode);
var storeMMInfo = StoreMMInfo.Get(usCode);
var storeContract = StoreContractInfo.Get(usCode);
var ta = StoreSTLocation.GetStoreSTLocation(usCode);
var tool = RenewalTool.Get(projectId);
var finOutput = RenewalToolFinMeasureOutput.GetByToolId(tool.Id) ?? new RenewalToolFinMeasureOutput();
var consInfo = RenewalConsInfo.Get(projectId);
var toolWriteOff = RenewalToolWriteOffAndReinCost.Get(projectId, tool.Id);
var floors = string.Join("/", new[] {
string.Join(",", new[] {
ta.Floor1,
ta.Floor2,
ta.Floor3,
ta.Floor4,
ta.Floor5
}.Where(e => !string.IsNullOrEmpty(e)).ToArray()),
string.Join(",", new[] {
ta.FrontCounterFloor1,
ta.FrontCounterFloor2
}.Where(e => !string.IsNullOrEmpty(e)).ToArray())
}.Where(e => !string.IsNullOrEmpty(e)).ToArray());
var seats = string.Join("/", new[] {
new[] { ta.Seats1, ta.Seats2, ta.Seats3, ta.Seats4, ta.Seats5, ta.FrontCounterSeats }.Select(e => {
var val = 0;
int.TryParse(e, out val);
return(val);
}).Sum(),
string.IsNullOrEmpty(ta.OutsideSeats)?0:int.Parse(ta.OutsideSeats)
});
var beTypes = string.Join(",", StoreBEInfo.Search(e => e.StoreCode == usCode && e.BETypeName != "FC" && e.BETypeName != "DT").Select(e => e.BETypeName).ToArray());
var leaseTenureAndTerm = string.Concat(storeContract.LeasePurchaseTerm, " years,from ",
storeContract.StartDate.HasValue ? storeContract.StartDate.Value.ToString("yyyy-MM-dd") : " / ",
"to",
storeContract.EndDate.HasValue ? storeContract.EndDate.Value.ToString("yyyy-MM-dd") : " / "
);
return(new RenewalAnalysisStoreInfo
{
UsCode = store.StoreCode,
NameZHCN = store.NameZHCN,
NameENUS = store.NameENUS,
MinimarketPriority = storeMMInfo.Priority,
TADesrability = storeMMInfo.Desirability,
SitePortfolioType = storeMMInfo.PortfolioTypeName,
SiteRerating = storeMMInfo.LocationRatingPP,
LeasedArea = storeContract.TotalLeasedArea,
OperationSize = ta.TotalArea,
Floors = floors,
Seats = seats,
BEType = beTypes,
LeaseTenureAndTerm = leaseTenureAndTerm,
FreeRentalPeriod = storeContract.FreeRentalPeriod,
RentStructure = storeContract.RentStructure,
DRMFLastTY = finOutput.AnnualRentExpenseLY,
DRMFLastTYSales = finOutput.RentAsProdSalesLY,
SRMFLastTY = finOutput.AnnualRentExpenseYr1,
SRMFLastTYSales = finOutput.RentAsProdSalesYr1,
SRMF1stTY = finOutput.AnnualRentExpenseAvg,
SRMF1stTYSales = finOutput.RentAsProdSalesAvg,
AnnualSOILastTY = finOutput.SOIProdSalesLY,
AnnualSOIAvg = finOutput.SOIProdSalesAvg,
CashROIAvg = finOutput.CashROIAvg,
CashROILastTY = finOutput.CashROILY,
OriginalInvestment = (toolWriteOff.REII + toolWriteOff.LHIII + toolWriteOff.ESSDII).ToString(),
NBV = (toolWriteOff.RENBV + toolWriteOff.LHINBV + toolWriteOff.ESSDNBV).ToString(),
AdditionalInvestmentCost = (toolWriteOff.RECost + toolWriteOff.LHICost + toolWriteOff.ESSDCost).ToString(),
ExclusivityClause = storeContract.ExclusivityClause,
McDsEarlyTerminationRight = storeContract.WithEarlyTerminationClause == null || storeContract.WithEarlyTerminationClause == 0 ? "N" : "Y",
LandlordEntity = storeContract.PartyAFullName,
LastRemodeling = store.ReImageDate.HasValue ? store.ReImageDate.Value.ToString("yyyy-MM-dd") : ""
});
}
public void UpdateFromProjectList()
{
using (TransactionScope tranScope = new TransactionScope())
{
var oldInfo = RenewalInfo.Get(this.ProjectId);
var consInfo = RenewalConsInfo.Get(this.ProjectId);
var analysis = RenewalAnalysis.Get(this.ProjectId);
analysis.LeaseTenureAndTerm = string.Format("{0} years,from {1:yyyy-MM-dd} to {2:yyyy-MM-dd}", this.RenewalYears, this.NewLeaseStartDate, this.NewLeaseEndDate);
analysis.Update();
if (oldInfo.NeedProjectCostEst != this.NeedProjectCostEst)
{
consInfo.HasReinvenstment = this.NeedProjectCostEst;
consInfo.Update();
if (ProjectInfo.IsFlowFinished(this.ProjectId, FlowCode.Renewal_Letter) &&
ProjectInfo.IsFlowFinished(this.ProjectId, FlowCode.Renewal_LLNegotiation))
{
if (!this.NeedProjectCostEst)
{
TaskWork.Cancel(e => e.RefID == this.ProjectId && e.Status == TaskWorkStatus.UnFinish && e.TypeCode == FlowCode.Renewal_ConsInfo);
ProjectInfo.FinishProject(this.ProjectId, FlowCode.Renewal_ConsInfo);
if (!ProjectInfo.IsFlowFinished(this.ProjectId, FlowCode.Renewal_Tool))
{
if (!TaskWork.Any(e => e.RefID == this.ProjectId && e.Status == TaskWorkStatus.UnFinish && e.TypeCode == FlowCode.Renewal_Tool))
{
GenerateSubmitTask(FlowCode.Renewal_Tool);
}
}
}
else
{
ProjectInfo.Reset(this.ProjectId, FlowCode.Renewal_ConsInfo);
GenerateSubmitTask(FlowCode.Renewal_ConsInfo);
if (!ProjectInfo.IsFlowFinished(this.ProjectId, FlowCode.Renewal_Tool))
{
TaskWork.Cancel(e => e.RefID == this.ProjectId && e.TypeCode == FlowCode.Renewal_Tool && e.Status == TaskWorkStatus.UnFinish);
ProjectInfo.Reset(this.ProjectId, FlowCode.Renewal_Tool);
}
}
}
}
if (oldInfo.RenewalYears != this.RenewalYears)
{
if (ProjectInfo.IsFlowFinished(ProjectId, FlowCode.Renewal_Analysis))
{
if (this.RenewalYears <= 2)
{
TaskWork.Finish(e => e.RefID == this.ProjectId && e.Status == TaskWorkStatus.UnFinish && e.TypeCode == FlowCode.Renewal_ClearanceReport);
ProjectInfo.FinishProject(this.ProjectId, FlowCode.Renewal_ClearanceReport);
}
else
{
if (!TaskWork.Any(e => e.RefID == ProjectId && e.TypeCode == FlowCode.Renewal_ClearanceReport && e.Status == TaskWorkStatus.UnFinish))
{
GenerateSubmitTask(FlowCode.Renewal_ClearanceReport);
}
}
}
}
this.Update();
tranScope.Complete();
}
}
public static ReopenMemo GetReopenMemo(string projectId)
{
var memo = FirstOrDefault(e => e.ProjectId.Equals(projectId));
bool isEmptyMemo = false;
if (memo == null)
{
memo = new ReopenMemo();
isEmptyMemo = true;
}
memo.ProjectId = projectId;
if (projectId.ToLower().IndexOf("rebuild") >= 0)
{
var rbdInfo = new RebuildInfo();
memo.RbdInfo = rbdInfo.GetRebuildInfo(projectId);
memo.Store = StoreBasicInfo.GetStore(memo.RbdInfo.USCode);
var consInfo = new RebuildConsInfo();
consInfo = consInfo.GetConsInfo(projectId);
var rein = ReinvestmentBasicInfo.GetByConsInfoId(consInfo.Id) ?? new ReinvestmentBasicInfo();
memo.ReinvestInfo = rein;
var recos = ReinvestmentCost.GetByConsInfoId(consInfo.Id) ?? new ReinvestmentCost();
memo.TotalReinvestmentBudget = recos.TotalReinvestmentBudget;
if (!memo.ReopenDate.HasValue)
{
memo.ReopenDate = memo.ReinvestInfo.ReopenDate;
}
if (!memo.GBDate.HasValue)
{
memo.GBDate = memo.ReinvestInfo.GBDate;
}
var gbMemo = GBMemo.GetGBMemo(projectId);
if (!memo.CompletionDate.HasValue && gbMemo != null)
{
memo.CompletionDate = gbMemo.ConstCompletionDate;
}
//if (string.IsNullOrEmpty(memo.DesignConcept))
// memo.DesignConcept = memo.ReinvestInfo.NewDesignType;
var writeoff = WriteOffAmount.GetByConsInfoId(consInfo.Id) ?? new WriteOffAmount();
memo.WriteOff = writeoff;
}
else if (projectId.ToLower().IndexOf("reimage") >= 0)
{
memo.RmgInfo = ReimageInfo.GetReimageInfo(projectId);
memo.Store = StoreBasicInfo.GetStore(memo.RmgInfo.USCode);
var consInfo = ReimageConsInfo.GetConsInfo(projectId);
var rein = ReinvestmentBasicInfo.GetByConsInfoId(consInfo.Id) ?? new ReinvestmentBasicInfo();
memo.ReinvestInfo = rein;
var recos = ReinvestmentCost.GetByConsInfoId(consInfo.Id) ?? new ReinvestmentCost();
memo.TotalReinvestmentBudget = recos.TotalReinvestmentBudget;
if (!memo.ReopenDate.HasValue)
{
memo.ReopenDate = memo.ReinvestInfo.ReopenDate;
}
if (!memo.GBDate.HasValue)
{
memo.GBDate = memo.ReinvestInfo.GBDate;
}
var gbMemo = ReimageGBMemo.GetGBMemo(projectId);
if (!memo.CompletionDate.HasValue && gbMemo != null)
{
memo.CompletionDate = gbMemo.ConstCompletionDate;
}
//if (string.IsNullOrEmpty(memo.DesignConcept))
// memo.DesignConcept = memo.ReinvestInfo.NewDesignType;
var writeoff = WriteOffAmount.GetByConsInfoId(consInfo.Id) ?? new WriteOffAmount();
memo.WriteOff = writeoff;
}
else if (projectId.ToLower().IndexOf("majorlease") >= 0)
{
var mjrInfo = new MajorLeaseInfo().GetMajorLeaseInfo(projectId);
memo.ReopenDate = mjrInfo.ReopenDate;
memo.Store = StoreBasicInfo.GetStore(mjrInfo.USCode);
var consInfo = new MajorLeaseConsInfo().GetConsInfo(projectId);
var rein = ReinvestmentBasicInfo.GetByConsInfoId(consInfo.Id) ?? new ReinvestmentBasicInfo();
memo.ReinvestInfo = rein;
var recos = ReinvestmentCost.GetByConsInfoId(consInfo.Id) ?? new ReinvestmentCost();
memo.TotalReinvestmentBudget = recos.TotalReinvestmentBudget;
if (!memo.ReopenDate.HasValue)
{
memo.ReopenDate = memo.ReinvestInfo.ReopenDate;
}
if (!memo.GBDate.HasValue)
{
memo.GBDate = memo.ReinvestInfo.GBDate;
}
var gbMemo = MajorLeaseGBMemo.GetGBMemo(projectId);
if (!memo.CompletionDate.HasValue && gbMemo != null)
{
memo.CompletionDate = gbMemo.ConstCompletionDate;
}
//if (string.IsNullOrEmpty(memo.DesignConcept))
// memo.DesignConcept = memo.ReinvestInfo.NewDesignType;
var writeoff = WriteOffAmount.GetByConsInfoId(consInfo.Id) ?? new WriteOffAmount();
memo.WriteOff = writeoff;
}
else if (projectId.ToLower().IndexOf("renewal") >= 0)
{
var renewalInfo = RenewalInfo.Get(projectId);
memo.ReopenDate = renewalInfo.NewLeaseStartDate;
memo.Store = StoreBasicInfo.GetStore(renewalInfo.USCode);
var consInfo = RenewalConsInfo.Get(projectId);
var rein = ReinvestmentBasicInfo.GetByConsInfoId(consInfo.Id) ?? new ReinvestmentBasicInfo();
memo.ReinvestInfo = rein;
var recos = ReinvestmentCost.GetByConsInfoId(consInfo.Id) ?? new ReinvestmentCost();
memo.TotalReinvestmentBudget = recos.TotalReinvestmentBudget;
if (!memo.ReopenDate.HasValue)
{
memo.ReopenDate = memo.ReinvestInfo.ReopenDate;
}
if (!memo.GBDate.HasValue)
{
memo.GBDate = memo.ReinvestInfo.GBDate;
}
var gbMemo = RenewalGBMemo.GetGBMemo(projectId);
if (!memo.CompletionDate.HasValue && gbMemo != null)
{
memo.CompletionDate = gbMemo.ConstCompletionDate;
}
//if (string.IsNullOrEmpty(memo.DesignConcept))
// memo.DesignConcept = memo.ReinvestInfo.NewDesignType;
var writeoff = WriteOffAmount.GetByConsInfoId(consInfo.Id) ?? new WriteOffAmount();
memo.WriteOff = writeoff;
}
if (isEmptyMemo)
{
if (memo.ReinvestInfo != null)
{
if (memo.ReinvestInfo.NewMcCafe.HasValue && memo.ReinvestInfo.NewMcCafe.Value)
{
memo.NewMcCafe = true;
}
if ((memo.ReinvestInfo.NewAttachedKiosk.HasValue && memo.ReinvestInfo.NewAttachedKiosk.Value) ||
(memo.ReinvestInfo.NewRemoteKiosk.HasValue && memo.ReinvestInfo.NewRemoteKiosk.Value))
{
memo.NewKiosk = true;
}
if (memo.ReinvestInfo.NewMDS.HasValue && memo.ReinvestInfo.NewMDS.Value)
{
memo.NewMDS = true;
}
if (memo.ReinvestInfo.NewTwientyFourHour.HasValue && memo.ReinvestInfo.NewTwientyFourHour.Value)
{
memo.Is24H = true;
}
//if (!string.IsNullOrEmpty(memo.ReinvestInfo.NewOperationSize))
//{
// memo.AftOperationSize = memo.ReinvestInfo.NewOperationSize;
//}
//if (!string.IsNullOrEmpty(memo.ReinvestInfo.EstimatedSeatNo))
//{
// memo.AftARSN = memo.ReinvestInfo.EstimatedSeatNo;
//}
}
memo.TTMNetSales = GetTTFinanceData(memo.Store.StoreBasicInfo.StoreCode);
}
memo.PriceTiter = GetPriceTier(memo.Store.StoreBasicInfo.StoreCode);
//if (string.IsNullOrEmpty(memo.AftARPT))
//{
// memo.AftARPT = memo.PriceTiter;
//}
//if (memo.Store != null)
//{
// memo.OriginalOperationSize = memo.Store.StoreSTLocation.TotalArea;
// memo.OriginalSeatNumber = memo.Store.StoreSTLocation.TotalSeatsNo;
//}
memo.YearMonthList = GetSelectYearMonth(memo.Store.StoreBasicInfo.StoreCode);
if (isEmptyMemo)
{
SaveReopenMemo(memo);
}
return(memo);
}
