private static string GetLastRemodeling(string USCode)
{
var projectGBMemo =
ProjectInfo.Search(e => e.USCode.Equals(USCode) && e.FlowCode == FlowCode.Reimage_GBMemo)
.OrderByDescending(e => e.CreateTime)
.FirstOrDefault();
string returnValue = "";
if (projectGBMemo != null && projectGBMemo.Status == ProjectStatus.Finished)
{
var projectRimg =
ProjectInfo.Search(
e => e.ProjectId.Equals(projectGBMemo.ProjectId) && e.FlowCode == FlowCode.Reimage)
.FirstOrDefault();
if (projectRimg != null && projectRimg.Status == ProjectStatus.Completed)
{
var gbmemo = ReimageGBMemo.GetGBMemo(projectGBMemo.ProjectId);
if (gbmemo != null && gbmemo.ConstCompletionDate.HasValue)
{
returnValue = gbmemo.ConstCompletionDate.Value.ToString("yyyy-MM-dd");
string strCost = GetReimageInvestmentCost(projectGBMemo.ProjectId);
if (!string.IsNullOrEmpty(strCost))
{
returnValue = returnValue + "," + strCost;
}
}
}
}
return(returnValue);
}
public void GenerateConsInvtCheckingTask(bool isScheduled = false)
{
var rmgInfo = ReimageInfo.Search(e => e.ProjectId.Equals(ProjectId)).AsNoTracking().FirstOrDefault();
if (rmgInfo == null)
{
throw new Exception("Could not find the Reimage Info, please check it!");
}
var taskUrl = string.Format(@"/Reimage/Main#/ConsInvtChecking?projectId={0}", ProjectId);
var task = rmgInfo.GenerateTaskWork(WorkflowCode, WorkflowCode, WorkflowCode, taskUrl);
task.ActivityName = NodeCode.Start;
task.ActionName = SetTaskActionName(ProjectId);
if (!isScheduled)
{
TaskWork.Add(task);
}
else
{
var gbMemo = ReimageGBMemo.GetGBMemo(ProjectId);
if (gbMemo != null && gbMemo.ConstCompletionDate.HasValue)
{
ScheduleLog.GenerateTaskSchedule(gbMemo.ConstCompletionDate.Value.AddDays(60), task, ClientCookie.UserCode, ProjectId, FlowCode.Reimage_ConsInvtChecking, rmgInfo.USCode);
}
}
}
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);
}