public void GenerateCover()
{
if (!Attachment.Any(att => att.RefTableID == this.Id.ToString() && att.RequirementId == new Guid("9D1E247C-AAE0-44F6-869E-F50B3E633C1C")))
{
var info = RenewalInfo.Get(this.ProjectId);
var store = StoreBasicInfo.GetStorInfo(info.USCode);
var contract = StoreContractInfo.Get(info.USCode);
var context = HttpContext.Current;
var templateFileName = context.Server.MapPath("~/Template/RenewalCover_Template_v20130922.xlsx");
var fileName = context.Server.MapPath(string.Format("~/UploadFiles/{0}.xlsx", Guid.NewGuid()));
File.Copy(templateFileName, fileName);
var fileInfo = new FileInfo(fileName);
ExcelDataInputDirector excelDirector = new ExcelDataInputDirector(fileInfo, ExcelDataInputType.RenewalCover);
ExcelInputDTO excelInput = new ExcelInputDTO();
excelInput.Region = store.RegionENUS;
excelInput.Province = store.ProvinceZHCN;
excelInput.City = store.CityENUS;
excelInput.Market = store.MarketENUS;
excelInput.StoreName = store.NameZHCN;
excelInput.USCode = store.StoreCode;
excelInput.OpenDate = store.OpenDate;
excelInput.LeaseExpirationDate = contract.EndDate.Value;
excelInput.Priority = info.Priority;
excelDirector.Input(excelInput);
var att = new Attachment();
att.ID = Guid.NewGuid();
att.RefTableID = this.Id.ToString();
att.RefTableName = this.TableName;
att.RelativePath = "/";
att.TypeCode = "Cover";
att.RequirementId = Guid.Parse("9D1E247C-AAE0-44F6-869E-F50B3E633C1C");
att.Name = "Cover";
att.Extension = fileInfo.Extension;
att.InternalName = fileInfo.Name;
att.ContentType = "application/vnd.ms-excel";
att.Length = (int)fileInfo.Length;
att.CreatorID = ClientCookie.UserCode;
att.CreatorNameENUS = ClientCookie.UserNameENUS;
att.CreatorNameZHCN = ClientCookie.UserNameZHCN;
att.CreateTime = DateTime.Now;
att.Add();
}
}
public void UpdateStoreLLRecord()
{
var info = RenewalInfo.Get(this.ProjectId);
var negotiations = RenewalLLNegotiationRecord.GetRecords(this.Id);
if (negotiations.Count > 0)
{
StoreSTLLRecord record = StoreSTLLRecord.Get(info.USCode);
if (record == null)
{
var storeBasic = StoreBasicInfo.GetStorInfo(info.USCode);
record = new StoreSTLLRecord();
record.StoreCode = info.USCode;
record.StoreID = storeBasic.StoreID;
record.Id = Guid.NewGuid();
}
record.LLparticipants = negotiations[0].LLParticipants;
record.Location = negotiations[0].Location;
record.McdParticipants = negotiations[0].McdParticipants;
record.Content = negotiations[0].Content;
record.CreatedTime = negotiations[0].CreateTime;
record.Topic = negotiations[0].Topic;
record.Save();
var storeNegos = negotiations.Select(n => new StoreSTNegotiation
{
Id = Guid.NewGuid(),
StoreID = record.StoreID,
StoreCode = record.StoreCode,
IsBroker = record.IsBroker,
BrokerName = record.BrokerName,
DateTime = n.Date.Value.ToString("yyyy-MM-dd"),
Location = n.Location,
Topic = n.Topic,
McdParticipants = n.McdParticipants,
McdParticipantsAD = record.McdParticipantsAD,
LLparticipants = n.LLParticipants,
Content = n.Content,
CreatedTime = n.CreateTime
}).ToArray();
StoreSTNegotiation.Add(storeNegos);
}
}
public override string Edit()
{
if (!PreEdit(this.ProjectId))
{
return("");
}
var closureEntity = ClosureInfo.GetByProjectId(this.ProjectId);
var store = StoreBasicInfo.GetStorInfo(closureEntity.USCode);
var taskWork = new TaskWork();
var source = FlowInfo.Get(FlowCode.Closure);
var taskType = FlowInfo.Get(FlowCode.Closure_WOCheckList);
taskWork.SourceCode = source.Code;
taskWork.SourceNameZHCN = source.NameZHCN;
taskWork.SourceNameENUS = source.NameENUS;
taskWork.Status = TaskWorkStatus.UnFinish;
taskWork.StatusNameZHCN = "任务";
taskWork.StatusNameENUS = "任务";
taskWork.Title = TaskWork.BuildTitle(this.ProjectId, store.NameZHCN, store.NameENUS);
taskWork.RefID = this.ProjectId;
taskWork.StoreCode = closureEntity.USCode;
taskWork.TypeCode = taskType.Code;
taskWork.TypeNameENUS = taskType.NameENUS;
taskWork.TypeNameZHCN = taskType.NameZHCN;
taskWork.ReceiverAccount = closureEntity.PMAccount;
taskWork.ReceiverNameENUS = closureEntity.PMNameENUS;
taskWork.ReceiverNameZHCN = closureEntity.PMNameZHCN;
taskWork.Id = Guid.NewGuid();
taskWork.CreateTime = DateTime.Now;
taskWork.Url = TaskWork.BuildUrl(FlowCode.Closure_WOCheckList, this.ProjectId, "");
taskWork.ActivityName = NodeCode.Start;
TaskWork.Add(taskWork);
this.IsHistory = true;
this.RefreshClosureTool = false;
//TaskWork.SetTaskHistory(this.Id, this.ProcInstID);
this.Save();
var objectCopy = new ObjectCopy();
var newWo = objectCopy.AutoCopy(this);
newWo.Id = Guid.NewGuid();
newWo.ProcInstID = 0;
newWo.Save();
var projectEntity = ProjectInfo.Get(this.ProjectId, FlowCode.Closure_WOCheckList);
ProjectInfo.UnFinishNode(this.ProjectId, FlowCode.Closure_WOCheckList, NodeCode.Closure_WOCheckList_Approve, ProjectStatus.UnFinish);
var attList = Attachment.Search(e => e.RefTableID == this.Id.ToString() &&
e.RefTableName == ClosureWOCheckList.TableName);
var objCopy = new ObjectCopy();
var newList = new List <Attachment>();
foreach (var att in attList)
{
var newAtt = objCopy.AutoCopy(att);
newAtt.RefTableID = newWo.Id.ToString();
newAtt.ID = Guid.NewGuid();
newList.Add(newAtt);
}
Attachment.AddList(newList);
return(taskWork.Url);
}
public static void Create(PostCreateWorkflow <TempClosureInfo> tempClosure)
{
using (TransactionScope tranScope = new TransactionScope())
{
var store = StoreBasicInfo.GetStorInfo(tempClosure.Entity.USCode);
tempClosure.Entity.Id = Guid.NewGuid();
tempClosure.Entity.CreateUserAccount = ClientCookie.UserCode;
tempClosure.Entity.CreateTime = DateTime.Now;
tempClosure.Entity.StoreNameENUS = store.NameENUS;
tempClosure.Entity.StoreNameZHCN = store.NameZHCN;
tempClosure.Entity.AssetRepAccount = tempClosure.Team.AssetRep.UserAccount;
tempClosure.Entity.AssetRepNameENUS = tempClosure.Team.AssetRep.UserNameENUS;
tempClosure.Entity.AssetRepNameZHCN = tempClosure.Team.AssetRep.UserNameZHCN;
tempClosure.Entity.AssetActorAccount = tempClosure.Team.AssetActor.UserAccount;
tempClosure.Entity.AssetActorNameENUS = tempClosure.Team.AssetActor.UserNameENUS;
tempClosure.Entity.AssetActorNameZHCN = tempClosure.Team.AssetActor.UserNameZHCN;
tempClosure.Entity.FinanceAccount = tempClosure.Team.Finance.UserAccount;
tempClosure.Entity.FinanceNameENUS = tempClosure.Team.Finance.UserNameENUS;
tempClosure.Entity.FinanceNameZHCN = tempClosure.Team.Finance.UserNameZHCN;
tempClosure.Entity.PMAccount = tempClosure.Team.PM.UserAccount;
tempClosure.Entity.PMNameENUS = tempClosure.Team.PM.UserNameENUS;
tempClosure.Entity.PMNameZHCN = tempClosure.Team.PM.UserNameZHCN;
tempClosure.Entity.LegalAccount = tempClosure.Team.Legal.UserAccount;
tempClosure.Entity.LegalNameENUS = tempClosure.Team.Legal.UserNameENUS;
tempClosure.Entity.LegalNameZHCN = tempClosure.Team.Legal.UserNameZHCN;
tempClosure.Entity.AssetManagerAccount = tempClosure.Team.AssetMgr.UserAccount;
tempClosure.Entity.AssetManagerNameENUS = tempClosure.Team.AssetMgr.UserNameENUS;
tempClosure.Entity.AssetManagerNameZHCN = tempClosure.Team.AssetMgr.UserNameZHCN;
tempClosure.Entity.CMAccount = tempClosure.Team.CM.UserAccount;
tempClosure.Entity.CMNameENUS = tempClosure.Team.CM.UserNameENUS;
tempClosure.Entity.CMNameZHCN = tempClosure.Team.CM.UserNameZHCN;
var projectId = ProjectInfo.CreateMainProject(FlowCode.TempClosure, tempClosure.Entity.USCode, NodeCode.Start, tempClosure.Entity.CreateUserAccount);
tempClosure.Entity.ProjectId = projectId;
Add(tempClosure.Entity);
List <ProjectUsers> projectUsers = new List <ProjectUsers>();
tempClosure.Team.AssetRep.Id = Guid.NewGuid();
tempClosure.Team.AssetRep.ProjectId = projectId;
tempClosure.Team.AssetRep.CreateDate = DateTime.Now;
tempClosure.Team.AssetRep.CreateUserAccount = ClientCookie.UserCode;
tempClosure.Team.AssetRep.RoleCode = ProjectUserRoleCode.AssetRep;
tempClosure.Team.AssetRep.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetRep, SystemLanguage.ENUS);
tempClosure.Team.AssetRep.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetRep, SystemLanguage.ZHCN);
projectUsers.Add(tempClosure.Team.AssetRep);
tempClosure.Team.AssetActor.Id = Guid.NewGuid();
tempClosure.Team.AssetActor.ProjectId = projectId;
tempClosure.Team.AssetActor.CreateDate = DateTime.Now;
tempClosure.Team.AssetActor.CreateUserAccount = ClientCookie.UserCode;
tempClosure.Team.AssetActor.RoleCode = ProjectUserRoleCode.AssetActor;
tempClosure.Team.AssetActor.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetActor, SystemLanguage.ENUS);
tempClosure.Team.AssetActor.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetActor, SystemLanguage.ZHCN);
projectUsers.Add(tempClosure.Team.AssetActor);
tempClosure.Team.Finance.Id = Guid.NewGuid();
tempClosure.Team.Finance.ProjectId = projectId;
tempClosure.Team.Finance.CreateDate = DateTime.Now;
tempClosure.Team.Finance.CreateUserAccount = ClientCookie.UserCode;
tempClosure.Team.Finance.RoleCode = ProjectUserRoleCode.Finance;
tempClosure.Team.Finance.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.Finance, SystemLanguage.ENUS);
tempClosure.Team.Finance.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.Finance, SystemLanguage.ZHCN);
projectUsers.Add(tempClosure.Team.Finance);
tempClosure.Team.PM.Id = Guid.NewGuid();
tempClosure.Team.PM.ProjectId = projectId;
tempClosure.Team.PM.CreateDate = DateTime.Now;
tempClosure.Team.PM.CreateUserAccount = ClientCookie.UserCode;
tempClosure.Team.PM.RoleCode = ProjectUserRoleCode.PM;
tempClosure.Team.PM.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.PM, SystemLanguage.ENUS);
tempClosure.Team.PM.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.PM, SystemLanguage.ZHCN);
projectUsers.Add(tempClosure.Team.PM);
tempClosure.Team.Legal.Id = Guid.NewGuid();
tempClosure.Team.Legal.ProjectId = projectId;
tempClosure.Team.Legal.CreateDate = DateTime.Now;
tempClosure.Team.Legal.CreateUserAccount = ClientCookie.UserCode;
tempClosure.Team.Legal.RoleCode = ProjectUserRoleCode.Legal;
tempClosure.Team.Legal.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.Legal, SystemLanguage.ENUS);
tempClosure.Team.Legal.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.Legal, SystemLanguage.ZHCN);
projectUsers.Add(tempClosure.Team.Legal);
tempClosure.Team.AssetMgr.Id = Guid.NewGuid();
tempClosure.Team.AssetMgr.ProjectId = projectId;
tempClosure.Team.AssetMgr.CreateDate = DateTime.Now;
tempClosure.Team.AssetMgr.CreateUserAccount = ClientCookie.UserCode;
tempClosure.Team.AssetMgr.RoleCode = ProjectUserRoleCode.AssetManager;
tempClosure.Team.AssetMgr.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetManager, SystemLanguage.ENUS);
tempClosure.Team.AssetMgr.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetManager, SystemLanguage.ZHCN);
projectUsers.Add(tempClosure.Team.AssetMgr);
tempClosure.Team.CM.Id = Guid.NewGuid();
tempClosure.Team.CM.ProjectId = projectId;
tempClosure.Team.CM.CreateDate = DateTime.Now;
tempClosure.Team.CM.CreateUserAccount = ClientCookie.UserCode;
tempClosure.Team.CM.RoleCode = ProjectUserRoleCode.CM;
tempClosure.Team.CM.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.CM, SystemLanguage.ENUS);
tempClosure.Team.CM.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.CM, SystemLanguage.ZHCN);
projectUsers.Add(tempClosure.Team.CM);
ProjectUsers.Add(projectUsers.ToArray());
tempClosure.Viewers.ForEach(v =>
{
v.Id = Guid.NewGuid();
v.ProjectId = projectId;
v.CreateDate = DateTime.Now;
v.CreateUserAccount = ClientCookie.UserCode;
v.RoleCode = ProjectUserRoleCode.View;
});
ProjectUsers.Add(tempClosure.Viewers.ToArray());
//tempClosure.NecessaryViewers.ForEach(v =>
//{
// v.Id = Guid.NewGuid();
// v.ProjectId = projectId;
// v.CreateDate = DateTime.Now;
// v.CreateUserAccount = ClientCookie.UserCode;
// v.RoleCode = ProjectUserRoleCode.View;
//});
//ProjectUsers.Add(tempClosure.NecessaryViewers.ToArray());
Remind.SendRemind(projectId, FlowCode.TempClosure, projectUsers);
ProjectInfo.CreateSubProject(FlowCode.TempClosure_LegalReview, projectId, tempClosure.Entity.USCode, NodeCode.Start, ClientCookie.UserCode);
TempClosureLegalReview.Create(projectId);
ProjectInfo.CreateSubProject(FlowCode.TempClosure_ClosurePackage, projectId, tempClosure.Entity.USCode, NodeCode.Start, ClientCookie.UserCode);
TempClosurePackage.Create(projectId);
ProjectInfo.CreateSubProject(FlowCode.TempClosure_ClosureMemo, projectId, tempClosure.Entity.USCode, NodeCode.Start, ClientCookie.UserCode);
ProjectInfo.CreateSubProject(FlowCode.TempClosure_ReopenMemo, projectId, tempClosure.Entity.USCode, NodeCode.Start, ClientCookie.UserCode);
string taskUrl = TaskWork.BuildUrl(FlowCode.TempClosure_LegalReview, projectId, "");
string title = TaskWork.BuildTitle(projectId, store.NameZHCN, store.NameENUS);
TaskWork.SendTask(projectId, title, store.StoreCode, taskUrl, tempClosure.Team.AssetActor, FlowCode.TempClosure, FlowCode.TempClosure_LegalReview, "Start");
ProjectNode.GenerateOnCreate(FlowCode.TempClosure, projectId);
tranScope.Complete();
}
}
public string DownloadToolTemplate()
{
var templateFileName = string.Concat(SiteFilePath.Template_DIRECTORY, "/", SiteFilePath.RenewalTool_Template);
string fileName = string.Format("{0}/{1}.xlsx", SiteFilePath.TEMP_DIRECTORY, Guid.NewGuid());
File.Copy(templateFileName, fileName);
FileInfo fileInfo = new FileInfo(fileName);
ExcelDataInputDirector excelDirector = new ExcelDataInputDirector(fileInfo, ExcelDataInputType.RenewalTool);
ExcelInputDTO excelDto = new ExcelInputDTO();
var info = RenewalInfo.Get(this.ProjectId);
var storeBasic = StoreBasicInfo.GetStorInfo(info.USCode);
var storeContract = StoreContractInfo.Get(info.USCode);
var finInput = RenewalToolFinMeasureInput.Get(this.ProjectId, this.Id);
var wfAndReinCost = RenewalToolWriteOffAndReinCost.Get(this.ProjectId, this.Id);
excelDto.USCode = info.USCode;
excelDto.Market = storeBasic.Market;
excelDto.StoreName = storeBasic.NameZHCN + "/" + storeBasic.NameENUS;
excelDto.OpenDate = storeBasic.OpenDate;
if (storeContract.EndDate.HasValue)
{
excelDto.LeaseExpirationDate = storeContract.EndDate.Value;
}
excelDto.RenewalYears = info.RenewalYears;
excelDto.ProductSales = finInput.ProductSalesAdjustment;
excelDto.Pac = finInput.PacAdjustment;
excelDto.Rent = finInput.RentAdjustment;
excelDto.DepreciationLhi = finInput.DepreciationLhiAdjustment;
excelDto.InterestLhi = finInput.InterestLhiAdjustment;
excelDto.ServiceFee = finInput.ServiceFeeAdjustment;
excelDto.Accounting = finInput.AccountingAdjustment;
excelDto.Insurance = finInput.InsuranceAdjustment;
excelDto.TaxesAndLicenses = finInput.TaxesAndLicensesAdjustment;
excelDto.DepreciationEssd = finInput.DepreciationEssdAdjustment;
excelDto.InterestEssd = finInput.InterestEssdAdjustment;
excelDto.OtherIncExp = finInput.OtherIncExpAdjustment;
excelDto.NonProductSales = finInput.NonProductSalesAdjustment;
excelDto.NonProductCosts = finInput.NonProductCostsAdjustment;
excelDto.REII = wfAndReinCost.REII;
excelDto.LHIII = wfAndReinCost.LHIII;
excelDto.ESSDII = wfAndReinCost.ESSDII;
excelDto.RENBV = wfAndReinCost.RENBV;
if (wfAndReinCost.LHINBV.HasValue)
{
excelDto.LHINBV = wfAndReinCost.LHINBV.Value;
}
if (wfAndReinCost.ESSDNBV.HasValue)
{
excelDto.ESSDNBV = wfAndReinCost.ESSDNBV.Value;
}
excelDto.RECost = wfAndReinCost.RECost;
excelDto.LHICost = wfAndReinCost.LHICost;
excelDto.ESSDCost = wfAndReinCost.ESSDCost;
excelDto.TotalWriteOff = wfAndReinCost.REWriteOff + wfAndReinCost.LHIWriteOff + wfAndReinCost.ESSDWriteOff;
excelDto.RentalStructure = !string.IsNullOrEmpty(finInput.RentalStructure) ? (Nullable <decimal>)decimal.Parse(finInput.RentalStructure) : null;
excelDto.ContributionMargin = finInput.ContributionMargin;
excelDto.SalesCompYr1 = finInput.SalesCompYr1;
excelDto.SalesCompYr2 = finInput.SalesCompYr2;
excelDto.SalesCompYr3 = finInput.SalesCompYr3;
excelDto.SalesCompYr4 = finInput.SalesCompYr4;
excelDto.SalesCompYr5 = finInput.SalesCompYr5;
excelDto.SalesCompYr6 = finInput.SalesCompYr6;
excelDto.SalesCompYr7 = finInput.SalesCompYr7;
excelDto.SalesCompYr8 = finInput.SalesCompYr8;
excelDto.SalesCompYr9 = finInput.SalesCompYr9;
excelDto.SalesCompYr10 = finInput.SalesCompYr10;
excelDto.SalesCompYr11 = finInput.SalesCompYr11;
excelDto.SalesCompYr12 = finInput.SalesCompYr12;
excelDto.SalesCompYr13 = finInput.SalesCompYr13;
excelDto.SalesCompYr14 = finInput.SalesCompYr14;
excelDto.SalesCompYr15 = finInput.SalesCompYr15;
excelDto.SalesCompYr16 = finInput.SalesCompYr16;
excelDto.SalesCompYr17 = finInput.SalesCompYr17;
excelDto.SalesCompYr18 = finInput.SalesCompYr18;
excelDto.SalesCompYr19 = finInput.SalesCompYr19;
excelDto.SalesCompYr20 = finInput.SalesCompYr20;
excelDto.ComSalesDesc = this.ComSalesDesc;
excelDto.CompSales = finInput.CompSalesAdjustment;
excelDto.FinanceYear = finInput.FinanceYear;
excelDto.FinanceMonth = finInput.FinanceMonth;
excelDirector.Input(excelDto);
return(fileName);
}
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 Dictionary <string, string> GetPrintTemplateFields()
{
var project = ProjectInfo.Get(this.ProjectId, FlowCode.Renewal_Package);
var storeBasic = StoreBasicInfo.GetStorInfo(project.USCode);
var storeContract = StoreContractInfo.Search(c => c.StoreCode == project.USCode).OrderByDescending(c => c.CreatedTime).FirstOrDefault();
var info = RenewalInfo.Get(ProjectId);
var flowInfo = FlowInfo.Get(FlowCode.Renewal);
var analysis = RenewalAnalysis.Get(this.AnalysisId.Value) ?? new RenewalAnalysis();
var finOutput = RenewalToolFinMeasureOutput.GetByToolId(this.ToolId.Value);
Dictionary <string, string> templateFileds = new Dictionary <string, string>();
templateFileds.Add("WorkflowName", flowInfo.NameENUS);
templateFileds.Add("ProjectID", ProjectId);
templateFileds.Add("USCode", storeBasic.StoreCode);
templateFileds.Add("Region", storeBasic.Region);
templateFileds.Add("StoreNameEN", storeBasic.NameENUS);
templateFileds.Add("Market", storeBasic.Market);
templateFileds.Add("City", storeBasic.CityZHCN);
templateFileds.Add("StoreNameCN", storeBasic.NameZHCN);
templateFileds.Add("StoreAge", Math.Floor((DateTime.Now - storeBasic.OpenDate).TotalDays / 365D).ToString());
templateFileds.Add("OpenDate", storeBasic.OpenDate.ToString("yyyy-MM-dd"));
templateFileds.Add("CloseDate", storeBasic.CloseDate.HasValue ? (storeBasic.CloseDate.Value.Year != 1900 ? storeBasic.CloseDate.Value.ToString("yyyy-MM-dd") : "") : "");
if (storeContract != null)
{
templateFileds.Add("CurrentLeaseENDYear", storeContract.EndYear);
}
else
{
templateFileds.Add("CurrentLeaseENDYear", "");
}
templateFileds.Add("AssetsManager", info.AssetManagerNameENUS);
templateFileds.Add("AssetsActor", info.AssetActorNameENUS);
templateFileds.Add("AssetsRep", info.AssetRepNameENUS);
templateFileds.Add("NewLeaseENDYear", info.NewLeaseEndDate.HasValue ? info.NewLeaseEndDate.Value.ToString("yyyy") : "");
templateFileds.Add("ClosureDate", storeBasic.CloseDate.HasValue ? (storeBasic.CloseDate.Value.Year != 1900 ? storeBasic.CloseDate.Value.ToString("yyyy-MM-dd") : "") : "");
templateFileds.Add("FairMarketRentPerAppraisal", analysis.FairMarketRentAmount.HasValue ? DataConverter.ToMoney(analysis.FairMarketRentAmount.Value) : "");
templateFileds.Add("LeaseTenureAndTerm", analysis.LeaseTenureAndTerm);
templateFileds.Add("DR1stTYAmount", analysis.DR1stTYAmount.HasValue ? DataConverter.ToMoney(analysis.DR1stTYAmount.Value) : "");
templateFileds.Add("FreeRentalPeriod", analysis.FreeRentalPeriod);
templateFileds.Add("RentDeviation", analysis.RentDeviation.HasValue ? DataConverter.ToPercentage(analysis.RentDeviation.Value.ToString()) : "");
templateFileds.Add("RentStructureUR", analysis.RentStructure);
templateFileds.Add("MFStructureUR", analysis.MFStructureNew);
if (finOutput != null)
{
templateFileds.Add("AnnualRentExpenseLY", DataConverter.ToMoney(finOutput.AnnualRentExpenseLY));
templateFileds.Add("AnnualRentExpenseYr1", DataConverter.ToMoney(finOutput.AnnualRentExpenseLY));
templateFileds.Add("AnnualRentExpenseAvg", DataConverter.ToMoney(finOutput.AnnualRentExpenseLY));
templateFileds.Add("RentAsProdSalesLY", DataConverter.ToPercentage(finOutput.RentAsProdSalesLY));
templateFileds.Add("RentAsProdSalesYr1", DataConverter.ToPercentage(finOutput.RentAsProdSalesYr1));
templateFileds.Add("RentAsProdSalesAvg", DataConverter.ToPercentage(finOutput.RentAsProdSalesAvg));
templateFileds.Add("OccupancyProdSalesLY", DataConverter.ToPercentage(finOutput.OccupancyProdSalesLY));
templateFileds.Add("OccupancyProdSalesYr1", DataConverter.ToPercentage(finOutput.OccupancyProdSalesYr1));
templateFileds.Add("OccupancyProdSalesAvg", DataConverter.ToPercentage(finOutput.OccupancyProdSalesAvg));
templateFileds.Add("SOIProdSalesLY", DataConverter.ToPercentage(finOutput.SOIProdSalesLY));
templateFileds.Add("SOIProdSalesYr1", DataConverter.ToPercentage(finOutput.SOIProdSalesYr1));
templateFileds.Add("SOIProdSalesAvg", DataConverter.ToPercentage(finOutput.SOIProdSalesAvg));
templateFileds.Add("CashROILY", DataConverter.ToPercentage(finOutput.CashROILY));
templateFileds.Add("CashROIYr1", DataConverter.ToPercentage(finOutput.CashROIYr1));
templateFileds.Add("CashROIAvg", DataConverter.ToPercentage(finOutput.CashROIAvg));
}
else
{
templateFileds.Add("AnnualRentExpenseLY", "");
templateFileds.Add("AnnualRentExpenseYr1", "");
templateFileds.Add("AnnualRentExpenseAvg", "");
templateFileds.Add("RentAsProdSalesLY", "");
templateFileds.Add("RentAsProdSalesYr1", "");
templateFileds.Add("RentAsProdSalesAvg", "");
templateFileds.Add("OccupancyProdSalesLY", "");
templateFileds.Add("OccupancyProdSalesYr1", "");
templateFileds.Add("OccupancyProdSalesAvg", "");
templateFileds.Add("SOIProdSalesLY", "");
templateFileds.Add("SOIProdSalesYr1", "");
templateFileds.Add("SOIProdSalesAvg", "");
templateFileds.Add("CashROILY", "");
templateFileds.Add("CashROIYr1", "");
templateFileds.Add("CashROIAvg", "");
}
return(templateFileds);
}
public static void Create(PostCreateWorkflow <RenewalInfo> postCreateRenewal)
{
using (TransactionScope tranScope = new TransactionScope())
{
var usCode = postCreateRenewal.Entity.USCode;
var store = StoreBasicInfo.GetStorInfo(usCode);
var projectId = ProjectInfo.CreateMainProject(FlowCode.Renewal, usCode, NodeCode.Start, ClientCookie.UserCode);
postCreateRenewal.Entity.Id = Guid.NewGuid();
postCreateRenewal.Entity.CreateUserAccount = ClientCookie.UserCode;
postCreateRenewal.Entity.CreateTime = DateTime.Now;
postCreateRenewal.Entity.StoreNameENUS = store.NameENUS;
postCreateRenewal.Entity.StoreNameZHCN = store.NameZHCN;
postCreateRenewal.Entity.AssetRepAccount = postCreateRenewal.Team.AssetRep.UserAccount;
postCreateRenewal.Entity.AssetRepNameENUS = postCreateRenewal.Team.AssetRep.UserNameENUS;
postCreateRenewal.Entity.AssetRepNameZHCN = postCreateRenewal.Team.AssetRep.UserNameZHCN;
postCreateRenewal.Entity.AssetActorAccount = postCreateRenewal.Team.AssetActor.UserAccount;
postCreateRenewal.Entity.AssetActorNameENUS = postCreateRenewal.Team.AssetActor.UserNameENUS;
postCreateRenewal.Entity.AssetActorNameZHCN = postCreateRenewal.Team.AssetActor.UserNameZHCN;
postCreateRenewal.Entity.FinanceAccount = postCreateRenewal.Team.Finance.UserAccount;
postCreateRenewal.Entity.FinanceNameENUS = postCreateRenewal.Team.Finance.UserNameENUS;
postCreateRenewal.Entity.FinanceNameZHCN = postCreateRenewal.Team.Finance.UserNameZHCN;
postCreateRenewal.Entity.PMAccount = postCreateRenewal.Team.PM.UserAccount;
postCreateRenewal.Entity.PMNameENUS = postCreateRenewal.Team.PM.UserNameENUS;
postCreateRenewal.Entity.PMNameZHCN = postCreateRenewal.Team.PM.UserNameZHCN;
postCreateRenewal.Entity.LegalAccount = postCreateRenewal.Team.Legal.UserAccount;
postCreateRenewal.Entity.LegalNameENUS = postCreateRenewal.Team.Legal.UserNameENUS;
postCreateRenewal.Entity.LegalNameZHCN = postCreateRenewal.Team.Legal.UserNameZHCN;
postCreateRenewal.Entity.AssetManagerAccount = postCreateRenewal.Team.AssetMgr.UserAccount;
postCreateRenewal.Entity.AssetManagerNameENUS = postCreateRenewal.Team.AssetMgr.UserNameENUS;
postCreateRenewal.Entity.AssetManagerNameZHCN = postCreateRenewal.Team.AssetMgr.UserNameZHCN;
postCreateRenewal.Entity.CMAccount = postCreateRenewal.Team.CM.UserAccount;
postCreateRenewal.Entity.CMNameENUS = postCreateRenewal.Team.CM.UserNameENUS;
postCreateRenewal.Entity.CMNameZHCN = postCreateRenewal.Team.CM.UserNameZHCN;
postCreateRenewal.Entity.ProjectId = projectId;
postCreateRenewal.Entity.Add();
ProjectInfo.CreateSubProject(FlowCode.Renewal_Letter, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.AssetActor.UserAccount);
RenewalLetter.Create(projectId, postCreateRenewal.Team.AssetActor.UserAccount);
ProjectInfo.CreateSubProject(FlowCode.Renewal_LLNegotiation, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.AssetActor.UserAccount);
RenewalLLNegotiation.Create(projectId, postCreateRenewal.Team.AssetActor.UserAccount);
ProjectInfo.CreateSubProject(FlowCode.Renewal_ConsInfo, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.PM.UserAccount);
RenewalConsInfo.Create(projectId, postCreateRenewal.Team.PM.UserAccount, postCreateRenewal.Entity.NeedProjectCostEst);
ProjectInfo.CreateSubProject(FlowCode.Renewal_Tool, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.Finance.UserAccount);
var tool = RenewalTool.Create(projectId, postCreateRenewal.Team.Finance.UserAccount);
ProjectInfo.CreateSubProject(FlowCode.Renewal_ClearanceReport, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.AssetActor.UserAccount);
RenewalClearanceReport.Create(projectId, postCreateRenewal.Team.AssetActor.UserAccount);
ProjectInfo.CreateSubProject(FlowCode.Renewal_ConfirmLetter, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.AssetActor.UserAccount);
RenewalConfirmLetter.Create(projectId, postCreateRenewal.Team.AssetActor.UserAccount);
ProjectInfo.CreateSubProject(FlowCode.Renewal_Analysis, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.AssetActor.UserAccount);
var analysis = RenewalAnalysis.Create(postCreateRenewal.Entity);
ProjectInfo.CreateSubProject(FlowCode.Renewal_LegalApproval, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.AssetActor.UserAccount);
RenewalLegalApproval.Create(projectId, postCreateRenewal.Team.AssetActor.UserAccount);
ProjectInfo.CreateSubProject(FlowCode.Renewal_Package, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.AssetActor.UserAccount);
RenewalPackage.Create(projectId, postCreateRenewal.Team.AssetActor.UserAccount, analysis.Id, tool.Id);
ProjectInfo.CreateSubProject(FlowCode.Renewal_ContractInfo, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.AssetActor.UserAccount);
RenewalContractInfo.Create(projectId);
ProjectInfo.CreateSubProject(FlowCode.Renewal_SiteInfo, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.PM.UserAccount);
RenewalSiteInfo.Create(projectId, postCreateRenewal.Team.PM.UserAccount);
ProjectInfo.CreateSubProject(FlowCode.Renewal_GBMemo, projectId, usCode, NodeCode.Start, postCreateRenewal.Team.PM.UserAccount);
List <ProjectUsers> projectUsers = new List <ProjectUsers>();
postCreateRenewal.Team.AssetRep.Id = Guid.NewGuid();
postCreateRenewal.Team.AssetRep.ProjectId = projectId;
postCreateRenewal.Team.AssetRep.CreateDate = DateTime.Now;
postCreateRenewal.Team.AssetRep.CreateUserAccount = ClientCookie.UserCode;
postCreateRenewal.Team.AssetRep.RoleCode = ProjectUserRoleCode.AssetRep;
postCreateRenewal.Team.AssetRep.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetRep, SystemLanguage.ENUS);
postCreateRenewal.Team.AssetRep.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetRep, SystemLanguage.ZHCN);
projectUsers.Add(postCreateRenewal.Team.AssetRep);
postCreateRenewal.Team.AssetActor.Id = Guid.NewGuid();
postCreateRenewal.Team.AssetActor.ProjectId = projectId;
postCreateRenewal.Team.AssetActor.CreateDate = DateTime.Now;
postCreateRenewal.Team.AssetActor.CreateUserAccount = ClientCookie.UserCode;
postCreateRenewal.Team.AssetActor.RoleCode = ProjectUserRoleCode.AssetActor;
postCreateRenewal.Team.AssetActor.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetActor, SystemLanguage.ENUS);
postCreateRenewal.Team.AssetActor.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetActor, SystemLanguage.ZHCN);
projectUsers.Add(postCreateRenewal.Team.AssetActor);
postCreateRenewal.Team.Finance.Id = Guid.NewGuid();
postCreateRenewal.Team.Finance.ProjectId = projectId;
postCreateRenewal.Team.Finance.CreateDate = DateTime.Now;
postCreateRenewal.Team.Finance.CreateUserAccount = ClientCookie.UserCode;
postCreateRenewal.Team.Finance.RoleCode = ProjectUserRoleCode.Finance;
postCreateRenewal.Team.Finance.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.Finance, SystemLanguage.ENUS);
postCreateRenewal.Team.Finance.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.Finance, SystemLanguage.ZHCN);
projectUsers.Add(postCreateRenewal.Team.Finance);
postCreateRenewal.Team.PM.Id = Guid.NewGuid();
postCreateRenewal.Team.PM.ProjectId = projectId;
postCreateRenewal.Team.PM.CreateDate = DateTime.Now;
postCreateRenewal.Team.PM.CreateUserAccount = ClientCookie.UserCode;
postCreateRenewal.Team.PM.RoleCode = ProjectUserRoleCode.PM;
postCreateRenewal.Team.PM.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.PM, SystemLanguage.ENUS);
postCreateRenewal.Team.PM.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.PM, SystemLanguage.ZHCN);
projectUsers.Add(postCreateRenewal.Team.PM);
postCreateRenewal.Team.Legal.Id = Guid.NewGuid();
postCreateRenewal.Team.Legal.ProjectId = projectId;
postCreateRenewal.Team.Legal.CreateDate = DateTime.Now;
postCreateRenewal.Team.Legal.CreateUserAccount = ClientCookie.UserCode;
postCreateRenewal.Team.Legal.RoleCode = ProjectUserRoleCode.Legal;
postCreateRenewal.Team.Legal.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.Legal, SystemLanguage.ENUS);
postCreateRenewal.Team.Legal.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.Legal, SystemLanguage.ZHCN);
projectUsers.Add(postCreateRenewal.Team.Legal);
postCreateRenewal.Team.AssetMgr.Id = Guid.NewGuid();
postCreateRenewal.Team.AssetMgr.ProjectId = projectId;
postCreateRenewal.Team.AssetMgr.CreateDate = DateTime.Now;
postCreateRenewal.Team.AssetMgr.CreateUserAccount = ClientCookie.UserCode;
postCreateRenewal.Team.AssetMgr.RoleCode = ProjectUserRoleCode.AssetManager;
postCreateRenewal.Team.AssetMgr.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetManager, SystemLanguage.ENUS);
postCreateRenewal.Team.AssetMgr.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.AssetManager, SystemLanguage.ZHCN);
projectUsers.Add(postCreateRenewal.Team.AssetMgr);
postCreateRenewal.Team.CM.Id = Guid.NewGuid();
postCreateRenewal.Team.CM.ProjectId = projectId;
postCreateRenewal.Team.CM.CreateDate = DateTime.Now;
postCreateRenewal.Team.CM.CreateUserAccount = ClientCookie.UserCode;
postCreateRenewal.Team.CM.RoleCode = ProjectUserRoleCode.CM;
postCreateRenewal.Team.CM.RoleNameENUS = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.CM, SystemLanguage.ENUS);
postCreateRenewal.Team.CM.RoleNameZHCN = SystemCode.Instance.GetCodeName(ProjectUserRoleCode.CM, SystemLanguage.ZHCN);
projectUsers.Add(postCreateRenewal.Team.CM);
ProjectUsers.Add(projectUsers.ToArray());
postCreateRenewal.Viewers.ForEach(v =>
{
v.Id = Guid.NewGuid();
v.ProjectId = projectId;
v.CreateDate = DateTime.Now;
v.CreateUserAccount = ClientCookie.UserCode;
v.RoleCode = ProjectUserRoleCode.View;
});
ProjectUsers.Add(postCreateRenewal.Viewers.ToArray());
//postCreateRenewal.NecessaryViewers.ForEach(v =>
//{
// v.Id = Guid.NewGuid();
// v.ProjectId = projectId;
// v.CreateDate = DateTime.Now;
// v.CreateUserAccount = ClientCookie.UserCode;
// v.RoleCode = ProjectUserRoleCode.View;
//});
//ProjectUsers.Add(postCreateRenewal.NecessaryViewers.ToArray());
Remind.SendRemind(projectId, FlowCode.Renewal, projectUsers);
Remind.SendRemind(projectId, FlowCode.Renewal, postCreateRenewal.Viewers);
postCreateRenewal.Entity.GenerateSubmitTask(FlowCode.Renewal_Letter);
postCreateRenewal.Entity.GenerateSubmitTask(FlowCode.Renewal_LLNegotiation);
postCreateRenewal.Entity.CreateAttachmentsMemo();
ProjectNode.GenerateOnCreate(FlowCode.Renewal, projectId);
ProjectProgress.SetProgress(projectId, "10%");
tranScope.Complete();
}
}
public override string Edit()
{
if (!PreEdit(this.ProjectId))
{
return("");
}
var closureEntity = ClosureInfo.GetByProjectId(this.ProjectId);
var store = StoreBasicInfo.GetStorInfo(closureEntity.USCode);
var taskWork = new TaskWork();
var source = FlowInfo.Get(FlowCode.Closure);
var taskType = FlowInfo.Get(FlowCode.Closure_ClosureTool);
taskWork.SourceCode = source.Code;
taskWork.SourceNameZHCN = source.NameZHCN;
taskWork.SourceNameENUS = source.NameENUS;
taskWork.Status = TaskWorkStatus.UnFinish;
taskWork.StatusNameZHCN = "任务";
taskWork.StatusNameENUS = "任务";
taskWork.Title = TaskWork.BuildTitle(this.ProjectId, store.NameZHCN, store.NameENUS);
taskWork.RefID = this.ProjectId;
taskWork.StoreCode = closureEntity.USCode;
taskWork.TypeCode = taskType.Code;
taskWork.TypeNameENUS = taskType.NameENUS;
taskWork.TypeNameZHCN = taskType.NameZHCN;
taskWork.ReceiverAccount = closureEntity.FinanceAccount;
taskWork.ReceiverNameENUS = closureEntity.FinanceNameENUS;
taskWork.ReceiverNameZHCN = closureEntity.FinanceNameZHCN;
taskWork.Id = Guid.NewGuid();
taskWork.CreateTime = DateTime.Now;
taskWork.ActivityName = NodeCode.Start;
taskWork.ActionName = SetTaskActionName(ProjectId);
taskWork.Url = TaskWork.BuildUrl(FlowCode.Closure_ClosureTool, this.ProjectId, "");
TaskWork.Add(taskWork);
this.IsHistory = true;
TaskWork.SetTaskHistory(this.Id, this.ProcInstID);
this.Save();
var objectCopy = new ObjectCopy();
var newEntity = objectCopy.AutoCopy(this);
newEntity.Id = Guid.NewGuid();
newEntity.ProcInstID = 0;
newEntity.IsHistory = false;
newEntity.Save();
//复制ImpactOtherStore信息
var impactOtherStores = ClosureToolImpactOtherStore.Search(i => i.ClosureId == this.Id).AsNoTracking().ToArray();
if (impactOtherStores.Length > 0)
{
foreach (var impactItem in impactOtherStores)
{
impactItem.Id = Guid.NewGuid();
impactItem.ClosureId = newEntity.Id;
}
ClosureToolImpactOtherStore.Add(impactOtherStores);
}
ProjectInfo.Reset(this.ProjectId, FlowCode.Closure_ClosureTool);
var attList = Attachment.Search(e => e.RefTableID == this.Id.ToString() &&
e.RefTableName == ClosureTool.TableName).AsNoTracking().ToList();
var newList = new List <Attachment>();
foreach (var att in attList)
{
var newAtt = objCopy.AutoCopy(att);
newAtt.RefTableID = newEntity.Id.ToString();
newAtt.ID = Guid.NewGuid();
newList.Add(newAtt);
}
Attachment.AddList(newList);
return(taskWork.Url);
}
public void Save(bool pushOrNot)
{
using (TransactionScope tranScope = new TransactionScope())
{
var projectInfo = ProjectInfo.Get(Id);
if (projectInfo == null)
{
ProjectId = ProjectInfo.CreateDLProject(Id, FlowCode.Reimage, USCode, NodeCode.Start, ClientCookie.UserCode, pushOrNot);
var store = StoreBasicInfo.GetStorInfo(USCode);
var reimageInfo = new ReimageInfo();
reimageInfo.Id = Guid.NewGuid();
reimageInfo.ProjectId = ProjectId;
reimageInfo.USCode = USCode;
reimageInfo.CreateDate = DateTime.Now;
reimageInfo.CreateUserAccount = ClientCookie.UserCode;
reimageInfo.CreateUserNameENUS = ClientCookie.UserNameENUS;
reimageInfo.CreateUserNameZHCN = ClientCookie.UserNameZHCN;
reimageInfo.AssetRepAccount = "";
reimageInfo.AssetRepNameZHCN = "";
reimageInfo.AssetRepNameENUS = "";
reimageInfo.AssetActorAccount = "";
reimageInfo.AssetActorNameZHCN = "";
reimageInfo.AssetActorNameENUS = "";
reimageInfo.FinanceAccount = "";
reimageInfo.FinanceNameZHCN = "";
reimageInfo.FinanceNameENUS = "";
reimageInfo.PMAccount = "";
reimageInfo.PMNameZHCN = "";
reimageInfo.PMNameENUS = "";
reimageInfo.LegalAccount = "";
reimageInfo.LegalNameZHCN = "";
reimageInfo.LegalNameENUS = "";
reimageInfo.StoreNameENUS = store.NameENUS;
reimageInfo.StoreNameZHCN = store.NameZHCN;
reimageInfo.GBDate = GBDate;
reimageInfo.ReopenDate = ReopenDate;
reimageInfo.Add();
var reimageConsInfo = new ReimageConsInfo();
reimageConsInfo.Id = Guid.NewGuid();
reimageConsInfo.ProjectId = ProjectId;
reimageConsInfo.IsHistory = false;
reimageConsInfo.CreateTime = DateTime.Now;
reimageConsInfo.CreateUserAccount = ClientCookie.UserCode;
reimageConsInfo.Add();
var reinvestmentBasicInfo = new ReinvestmentBasicInfo();
reinvestmentBasicInfo.ConsInfoID = reimageConsInfo.Id;
reinvestmentBasicInfo.RightSizingSeatNo = RightSizingSeatNO;
reinvestmentBasicInfo.NewDesignType = AfterReimageDesignType;
reinvestmentBasicInfo.Add();
var reimageConsInvtChecking = new ReimageConsInvtChecking();
reimageConsInvtChecking.Id = Guid.NewGuid();
reimageConsInvtChecking.ProjectId = ProjectId;
reimageConsInvtChecking.IsHistory = false;
reimageConsInvtChecking.CreateTime = DateTime.Now;
reimageConsInvtChecking.CreateUserAccount = ClientCookie.UserCode;
reimageConsInvtChecking.Add();
var writeOffAmount = new WriteOffAmount();
writeOffAmount.Id = Guid.NewGuid();
writeOffAmount.ConsInfoID = reimageConsInvtChecking.Id;
writeOffAmount.TotalWriteOff = Reimage_Total_WO_Proj;
writeOffAmount.TotalActual = Reimage_Total_WO_Act;
writeOffAmount.Add();
var reinvestmentCost = new ReinvestmentCost();
reinvestmentCost.Id = Guid.NewGuid();
reinvestmentCost.ConsInfoID = reimageConsInvtChecking.Id;
reinvestmentCost.TotalReinvestmentBudget = Reimage_Total_Reinvestment_Proj;
reinvestmentCost.TotalReinvestmentPMAct = Reimage_Total_Reinvestment_Act;
reinvestmentCost.Add();
var reopenMemo = new ReopenMemo();
reopenMemo.Id = Guid.NewGuid();
reopenMemo.ProjectId = ProjectId;
reopenMemo.NewMcCafe = false;
reopenMemo.NewKiosk = false;
reopenMemo.NewMDS = false;
reopenMemo.Is24H = false;
reopenMemo.AftARSN = AfterReimageSeatNO;
reopenMemo.Add();
}
else
{
ProjectId = projectInfo.ProjectId;
projectInfo.IsPushed = pushOrNot;
projectInfo.Update();
var store = StoreBasicInfo.GetStorInfo(USCode);
var reimageInfo = ReimageInfo.FirstOrDefault(i => i.ProjectId == ProjectId);
if (reimageInfo != null)
{
reimageInfo.GBDate = GBDate;
reimageInfo.ReopenDate = ReopenDate;
reimageInfo.Update();
}
else
{
reimageInfo = new ReimageInfo();
reimageInfo.Id = Guid.NewGuid();
reimageInfo.ProjectId = ProjectId;
reimageInfo.USCode = USCode;
reimageInfo.CreateDate = DateTime.Now;
reimageInfo.CreateUserAccount = ClientCookie.UserCode;
reimageInfo.CreateUserNameENUS = ClientCookie.UserNameENUS;
reimageInfo.CreateUserNameZHCN = ClientCookie.UserNameZHCN;
reimageInfo.AssetRepAccount = "";
reimageInfo.AssetRepNameZHCN = "";
reimageInfo.AssetRepNameENUS = "";
reimageInfo.AssetActorAccount = "";
reimageInfo.AssetActorNameZHCN = "";
reimageInfo.AssetActorNameENUS = "";
reimageInfo.FinanceAccount = "";
reimageInfo.FinanceNameZHCN = "";
reimageInfo.FinanceNameENUS = "";
reimageInfo.PMAccount = "";
reimageInfo.PMNameZHCN = "";
reimageInfo.PMNameENUS = "";
reimageInfo.LegalAccount = "";
reimageInfo.LegalNameZHCN = "";
reimageInfo.LegalNameENUS = "";
reimageInfo.StoreNameENUS = store.NameENUS;
reimageInfo.StoreNameZHCN = store.NameZHCN;
reimageInfo.GBDate = GBDate;
reimageInfo.ReopenDate = ReopenDate;
reimageInfo.Add();
}
var reimageConsInfo = ReimageConsInfo.FirstOrDefault(i => i.ProjectId == ProjectId && i.IsHistory == false);
if (reimageConsInfo != null)
{
var reinvestmentBasicInfo = ReinvestmentBasicInfo.FirstOrDefault(i => i.ConsInfoID == reimageConsInfo.Id);
if (reinvestmentBasicInfo != null)
{
reinvestmentBasicInfo.RightSizingSeatNo = RightSizingSeatNO;
reinvestmentBasicInfo.NewDesignType = AfterReimageDesignType;
reinvestmentBasicInfo.Update();
}
else
{
reinvestmentBasicInfo = new ReinvestmentBasicInfo();
reinvestmentBasicInfo.ConsInfoID = reimageConsInfo.Id;
reinvestmentBasicInfo.RightSizingSeatNo = RightSizingSeatNO;
reinvestmentBasicInfo.NewDesignType = AfterReimageDesignType;
reinvestmentBasicInfo.Add();
}
}
else
{
reimageConsInfo = new ReimageConsInfo();
reimageConsInfo.Id = Guid.NewGuid();
reimageConsInfo.ProjectId = ProjectId;
reimageConsInfo.IsHistory = false;
reimageConsInfo.CreateTime = DateTime.Now;
reimageConsInfo.CreateUserAccount = ClientCookie.UserCode;
reimageConsInfo.Add();
var reinvestmentBasicInfo = new ReinvestmentBasicInfo();
reinvestmentBasicInfo.ConsInfoID = reimageConsInfo.Id;
reinvestmentBasicInfo.RightSizingSeatNo = RightSizingSeatNO;
reinvestmentBasicInfo.NewDesignType = AfterReimageDesignType;
reinvestmentBasicInfo.Add();
}
var reimageConsInvtChecking = ReimageConsInvtChecking.FirstOrDefault(i => i.ProjectId == ProjectId && i.IsHistory == false);
if (reimageConsInvtChecking != null)
{
var writeOffAmount = WriteOffAmount.FirstOrDefault(i => i.ConsInfoID == reimageConsInvtChecking.Id);
if (writeOffAmount != null)
{
writeOffAmount.TotalWriteOff = Reimage_Total_WO_Proj;
writeOffAmount.TotalActual = Reimage_Total_WO_Act;
writeOffAmount.Update();
}
else
{
writeOffAmount = new WriteOffAmount();
writeOffAmount.Id = Guid.NewGuid();
writeOffAmount.ConsInfoID = reimageConsInvtChecking.Id;
writeOffAmount.TotalWriteOff = Reimage_Total_WO_Proj;
writeOffAmount.TotalActual = Reimage_Total_WO_Act;
writeOffAmount.Add();
}
var reinvestmentCost = ReinvestmentCost.FirstOrDefault(i => i.ConsInfoID == reimageConsInvtChecking.Id);
if (reinvestmentCost != null)
{
reinvestmentCost.TotalReinvestmentBudget = Reimage_Total_Reinvestment_Proj;
reinvestmentCost.TotalReinvestmentPMAct = Reimage_Total_Reinvestment_Act;
reinvestmentCost.Update();
}
else
{
reinvestmentCost = new ReinvestmentCost();
reinvestmentCost.Id = Guid.NewGuid();
reinvestmentCost.ConsInfoID = reimageConsInvtChecking.Id;
reinvestmentCost.TotalReinvestmentBudget = Reimage_Total_Reinvestment_Proj;
reinvestmentCost.TotalReinvestmentPMAct = Reimage_Total_Reinvestment_Act;
reinvestmentCost.Add();
}
}
else
{
reimageConsInvtChecking = new ReimageConsInvtChecking();
reimageConsInvtChecking.Id = Guid.NewGuid();
reimageConsInvtChecking.ProjectId = ProjectId;
reimageConsInvtChecking.IsHistory = false;
reimageConsInvtChecking.CreateTime = DateTime.Now;
reimageConsInvtChecking.CreateUserAccount = ClientCookie.UserCode;
reimageConsInvtChecking.Add();
var writeOffAmount = new WriteOffAmount();
writeOffAmount.Id = Guid.NewGuid();
writeOffAmount.ConsInfoID = reimageConsInvtChecking.Id;
writeOffAmount.TotalWriteOff = Reimage_Total_WO_Proj;
writeOffAmount.TotalActual = Reimage_Total_WO_Act;
writeOffAmount.Add();
var reinvestmentCost = new ReinvestmentCost();
reinvestmentCost.Id = Guid.NewGuid();
reinvestmentCost.ConsInfoID = reimageConsInvtChecking.Id;
reinvestmentCost.TotalReinvestmentBudget = Reimage_Total_Reinvestment_Proj;
reinvestmentCost.TotalReinvestmentPMAct = Reimage_Total_Reinvestment_Act;
reinvestmentCost.Add();
}
var reopenMemo = ReopenMemo.FirstOrDefault(i => i.ProjectId == ProjectId);
if (reopenMemo != null)
{
reopenMemo.AftARSN = AfterReimageSeatNO;
reopenMemo.Update();
}
else
{
reopenMemo = new ReopenMemo();
reopenMemo.Id = Guid.NewGuid();
reopenMemo.ProjectId = ProjectId;
reopenMemo.NewMcCafe = false;
reopenMemo.NewKiosk = false;
reopenMemo.NewMDS = false;
reopenMemo.Is24H = false;
reopenMemo.AftARSN = AfterReimageSeatNO;
reopenMemo.Add();
}
}
tranScope.Complete();
}
}
public Attachment GenerateAttachment(out string filePath)
{
var info = ReimageInfo.FirstOrDefault(e => e.ProjectId == this.ProjectId);
_refId = GetRefId(this.ProjectId);
var storeInfo = StoreBasicInfo.GetStorInfo(info.USCode);
string templateFileName = string.Concat(SiteFilePath.Template_DIRECTORY, "/", SiteFilePath.Reimage_Summary_Template);
string fileName = HttpContext.Current.Server.MapPath(string.Format("~/UploadFiles/{0}.xlsx", Guid.NewGuid()));
var extetion = Path.GetExtension(fileName);
var internalName = Path.GetFileName(fileName);
File.Copy(templateFileName, fileName);
FileInfo fileInfo = new FileInfo(fileName);
ExcelDataInputDirector excelDirector = new ExcelDataInputDirector(fileInfo, ExcelDataInputType.ReimageSummary);
ExcelInputDTO excelDto = new ExcelInputDTO();
excelDto.USCode = info.USCode;
excelDto.ProjectId = info.ProjectId;
excelDirector.Input(excelDto);
var att = Attachment.FirstOrDefault(e => e.RefTableID == this.Id.ToString() && e.TypeCode == "ReimageSummary");
bool hasAttach = true;
if (att == null)
{
hasAttach = false;
att = new Attachment();
att.ID = Guid.NewGuid();
}
att.TypeCode = "ReimageSummary";
att.RefTableID = this.Id.ToString();
att.RefTableName = "ReimageSummary";
att.Name = "Reimage Summary";
att.Extension = extetion;
att.RelativePath = "/";
att.InternalName = internalName;
att.ContentType = "application/vnd.ms-excel";
att.Length = (int)fileInfo.Length;
att.CreatorID = ClientCookie.UserCode;
att.CreatorNameENUS = ClientCookie.UserNameENUS;
att.CreatorNameZHCN = ClientCookie.UserNameZHCN;
att.CreateTime = DateTime.Now;
att.RequirementId = new Guid("5647BDBB-5B5F-47CD-9AD2-3E35A16DD303");
if (hasAttach)
{
att.Update();
}
else
{
att.Add();
}
//fileInfo = new FileInfo(fileName);
//var importDirector = new ExcelDataImportDirector(fileInfo, ExcelDataImportType.FinancialPreAnalysis);
//importDirector.FillEntityEvent += FillFinancialPreAnalysisEntity;
//using (var scope = new TransactionScope())
//{
// importDirector.ParseAndImport();
// scope.Complete();
//}
filePath = fileName;
return(att);
}
public Dictionary <string, string> GetPrintTemplateFields()
{
var project = ProjectInfo.Get(ProjectId, FlowCode.Renewal_LegalApproval);
var storeBasic = StoreBasicInfo.GetStorInfo(project.USCode);
var storeContract = StoreContractInfo.Search(c => c.StoreCode == project.USCode).OrderByDescending(c => c.CreatedTime).FirstOrDefault();
var info = RenewalInfo.Get(ProjectId);
var flowInfo = FlowInfo.Get(FlowCode.Renewal);
var legal = RenewalLegalApproval.Get(project.ProjectId) ?? new RenewalLegalApproval();
Dictionary <string, string> templateFileds = new Dictionary <string, string>();
templateFileds.Add("WorkflowName", flowInfo.NameENUS);
templateFileds.Add("ProjectID", ProjectId);
templateFileds.Add("USCode", storeBasic.StoreCode);
templateFileds.Add("Region", storeBasic.Region);
templateFileds.Add("StoreNameEN", storeBasic.NameENUS);
templateFileds.Add("Market", storeBasic.Market);
templateFileds.Add("City", storeBasic.CityZHCN);
templateFileds.Add("StoreNameCN", storeBasic.NameZHCN);
templateFileds.Add("StoreAge", Math.Floor((DateTime.Now - storeBasic.OpenDate).TotalDays / 365D).ToString());
templateFileds.Add("OpenDate", storeBasic.OpenDate.ToString("yyyy-MM-dd"));
templateFileds.Add("CloseDate", storeBasic.CloseDate.HasValue ? (storeBasic.CloseDate.Value.Year != 1900 ? storeBasic.CloseDate.Value.ToString("yyyy-MM-dd") : "") : "");
if (storeContract != null)
{
templateFileds.Add("CurrentLeaseENDYear", storeContract.EndYear);
}
else
{
templateFileds.Add("CurrentLeaseENDYear", "");
}
templateFileds.Add("AssetsManager", info.AssetManagerNameENUS);
templateFileds.Add("AssetsActor", info.AssetActorNameENUS);
templateFileds.Add("AssetsRep", info.AssetRepNameENUS);
templateFileds.Add("NewLeaseENDYear", info.NewLeaseEndDate.HasValue ? info.NewLeaseEndDate.Value.ToString("yyyy") : "");
templateFileds.Add("ClosureDate", storeBasic.CloseDate.HasValue ? (storeBasic.CloseDate.Value.Year != 1900 ? storeBasic.CloseDate.Value.ToString("yyyy-MM-dd") : "") : "");
var contractData = Employee.GetEmployeeContact(ProjectId);
StringBuilder sbd = new StringBuilder();
if (contractData != null && contractData.Count > 0)
{
foreach (var item in contractData)
{
sbd.Append("<tr><td> </td>");
sbd.Append("<td>");
sbd.Append(item.NameENUS);
sbd.Append("</td>");
sbd.Append("<td>");
sbd.Append(item.PositionENUS);
sbd.Append("</td>");
sbd.Append("<td>");
sbd.Append(item.Mail);
sbd.Append("</td>");
sbd.Append("<td>");
sbd.Append(item.Phone);
sbd.Append("</td>");
sbd.Append("<td>");
sbd.Append(item.Mobile);
sbd.Append("</td>");
sbd.Append("</tr>");
}
}
else
{
sbd.Append("<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>");
}
templateFileds.Add("ContactInfoData", sbd.ToString());
//Special Application
templateFileds.Add("isurgencyyes", legal.IsUrgency ? "checked" : "");
templateFileds.Add("isurgencyno", !legal.IsUrgency ? "checked" : "");
templateFileds.Add("urgencyreason", legal.UrgencyReason);
//transaction involves
templateFileds.Add("isrecenttransfer", legal.IsRecentTransfer ? "checked" : "");
templateFileds.Add("isintermediaries", legal.IsIntermediaries ? "checked" : "");
templateFileds.Add("isrelatedparties", legal.IsRelatedParties ? "checked" : "");
templateFileds.Add("isbroker", legal.IsBroker ? "checked" : "");
templateFileds.Add("ispttp", legal.IsPTTP ? "checked" : "");
templateFileds.Add("isasiiwgo", legal.IsASIIWGO ? "checked" : "");
templateFileds.Add("isnoblclause", legal.IsNoBLClause ? "checked" : "");
templateFileds.Add("isofac", legal.IsOFAC ? "checked" : "");
templateFileds.Add("isantic", legal.IsAntiC ? "checked" : "");
templateFileds.Add("isbenefitconflict", legal.IsBenefitConflict ? "checked" : "");
templateFileds.Add("noneofabove", legal.NoneOfAbove ? "checked" : "");
//Any Legal Concerns
templateFileds.Add("anylegalconcernno", !legal.AnyLegalConcern ? "checked" : "");
templateFileds.Add("anylegalconcernyes", legal.AnyLegalConcern ? "checked" : "");
templateFileds.Add("illegalstructure", legal.IllegalStructure ? "checked" : "");
templateFileds.Add("occupying", legal.Occupying ? "checked" : "");
templateFileds.Add("noauthoritytorelease", legal.NoAuthorityToRelease ? "checked" : "");
templateFileds.Add("entrustlease", legal.EntrustLease ? "checked" : "");
templateFileds.Add("sublease", legal.SubLease ? "checked" : "");
templateFileds.Add("beingsealedup", legal.BeingSealedUp ? "checked" : "");
templateFileds.Add("beingsealedupdesc", legal.BeingSealedUpDesc);
templateFileds.Add("licensecantbeobtained", legal.LicenseCantBeObtained ? "checked" : "");
templateFileds.Add("pendingordispute", legal.PendingOrDispute ? "checked" : "");
templateFileds.Add("pendingordisputedesc", legal.PendingOrDisputeDesc);
templateFileds.Add("otherissure", legal.OtherIssure ? "checked" : "");
templateFileds.Add("OtherIssureDesc", legal.OtherIssureDesc);
//SOX Audit
templateFileds.Add("optionsforrenewalyes", legal.OptionsForRenewal ? "checked" : "");
templateFileds.Add("optionsforrenewalno", !legal.OptionsForRenewal ? "checked" : "");
templateFileds.Add("reinstatementrequirementyes", legal.ReinstatementRequirement ? "checked" : "");
templateFileds.Add("reinstatementrequirementno", !legal.ReinstatementRequirement ? "checked" : "");
//Legal Department Review
templateFileds.Add("endorsed", legal.ReviewStatus == "Endorsed" ? "checked" : "");
templateFileds.Add("legalcomments", (legal.ReviewStatus == "LegalComments") ? "checked" : "");
templateFileds.Add("notendorsed", legal.ReviewStatus == "" ? "NotEndorsed" : "");
templateFileds.Add("submitbeforesign", legal.SubmitBeforeSign ? "checked" : "");
templateFileds.Add("SubmitBeforeSignDesc", legal.SubmitBeforeSignDesc);
templateFileds.Add("landlordformleaseuserd", legal.LandlordFormLeaseUserd ? "checked" : "");
templateFileds.Add("ownerrefusetohonorlease", legal.OwnerRefuseToHonorLease ? "checked" : "");
templateFileds.Add("mortgageerefusetoguarantee", legal.MortgageeRefuseToGuarantee ? "checked" : "");
templateFileds.Add("otherlegalcomment", legal.OtherLegalComment ? "checked" : "");
templateFileds.Add("LegalComments", legal.LegalComments);
templateFileds.Add("OtherLegalCommentDesc", legal.OtherLegalCommentDesc);
templateFileds.Add("NotEndorsedIssureNo", legal.NotEndorsedIssureNo.HasValue?legal.NotEndorsedIssureNo.Value.ToString():"");
//Endorsement by General Counsel
templateFileds.Add("GCComment", legal.GCComment);
return(templateFileds);
}