public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["B4"].Value = inputInfo.Region.AsString();
worksheet.Cells["B5"].Value = inputInfo.Market.AsString();
worksheet.Cells["B6"].Value = inputInfo.City.AsString();
worksheet.Cells["B7"].Value = inputInfo.USCode.AsString();
worksheet.Cells["B8"].Value = inputInfo.StoreNameEN.AsString();
worksheet.Cells["B9"].Value = inputInfo.StoreNameCN.AsString();
worksheet.Cells["B10"].Value = inputInfo.OpenDate;
if (inputInfo.GBDate.HasValue)
{
worksheet.Cells["B11"].Value = inputInfo.GBDate.Value;
}
if (inputInfo.ConsCompletionDate.HasValue)
{
worksheet.Cells["B12"].Value = inputInfo.ConsCompletionDate.Value;
}
worksheet.Cells["B13"].Value = Dictionary.ParseDisplayName(inputInfo.NewDesignType);
worksheet.Cells["B14"].Value = inputInfo.NormType.AsString();
worksheet.Cells["B15"].Value = inputInfo.EstimatedSeatNO.AsString();
worksheet.Cells["B16"].Value = inputInfo.NewDTSiteArea.AsString();
worksheet.Cells["B17"].Value = inputInfo.NewOperationArea.AsString();
worksheet.Cells["B18"].Value = inputInfo.NewDiningArea.AsString();
worksheet.Cells["B19"].Value = inputInfo.WallPanelArea.AsString();
worksheet.Cells["B20"].Value = inputInfo.WallGraphicArea.AsString();
worksheet.Cells["B21"].Value = inputInfo.FacadeACMArea.AsString();
worksheet.Cells["B22"].Value = ExcelHelper.ResolveBooleanTypeFieldValue(inputInfo.NewRemoteKiosk);
worksheet.Cells["B23"].Value = ExcelHelper.ResolveBooleanTypeFieldValue(inputInfo.NewAttachedKiosk);
worksheet.Cells["B24"].Value = ExcelHelper.ResolveBooleanTypeFieldValue(inputInfo.NewMcCafe);
worksheet.Cells["B25"].Value = ExcelHelper.ResolveBooleanTypeFieldValue(inputInfo.NewMDS);
}
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["B2"].Value = inputInfo.StoreNameEN;
worksheet.Cells["B3"].Value = inputInfo.USCode;
worksheet.Cells["B5"].Value = inputInfo.City;
worksheet.Cells["B6"].Value = inputInfo.Market;
worksheet.Cells["B7"].Value = inputInfo.ActualCloseDate;
}
public override void Input(OfficeOpenXml.ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["B2"].Value = inputInfo.Market;
worksheet.Cells["B3"].Value = inputInfo.USCode;
worksheet.Cells["B4"].Value = inputInfo.StoreName;
worksheet.Cells["B5"].Value = inputInfo.OpenDate;
worksheet.Cells["B6"].Value = inputInfo.LeaseExpirationDate;
worksheet.Cells["B7"].Value = inputInfo.RenewalYears;
worksheet.Cells["B8"].Value = inputInfo.ProductSales;
worksheet.Cells["B9"].Value = inputInfo.Pac;
worksheet.Cells["B10"].Value = inputInfo.Rent;
worksheet.Cells["B11"].Value = inputInfo.DepreciationLhi;
worksheet.Cells["B12"].Value = inputInfo.InterestLhi;
worksheet.Cells["B13"].Value = inputInfo.ServiceFee;
worksheet.Cells["B14"].Value = inputInfo.Accounting;
worksheet.Cells["B15"].Value = inputInfo.Insurance;
worksheet.Cells["B16"].Value = inputInfo.TaxesAndLicenses;
worksheet.Cells["B17"].Value = inputInfo.DepreciationEssd;
worksheet.Cells["B18"].Value = inputInfo.InterestEssd;
worksheet.Cells["B19"].Value = inputInfo.OtherIncExp;
worksheet.Cells["B20"].Value = inputInfo.NonProductSales;
worksheet.Cells["B21"].Value = inputInfo.NonProductCosts;
worksheet.Cells["B22"].Value = inputInfo.REII;
worksheet.Cells["B23"].Value = inputInfo.LHIII;
worksheet.Cells["B24"].Value = inputInfo.ESSDII;
worksheet.Cells["B25"].Value = inputInfo.RENBV;
worksheet.Cells["B26"].Value = inputInfo.LHINBV;
worksheet.Cells["B27"].Value = inputInfo.ESSDNBV;
worksheet.Cells["B28"].Value = inputInfo.RECost;
worksheet.Cells["B29"].Value = inputInfo.LHICost;
worksheet.Cells["B30"].Value = inputInfo.ESSDCost;
worksheet.Cells["B31"].Value = inputInfo.TotalWriteOff;
worksheet.Cells["B32"].Value = inputInfo.RentalStructure;
worksheet.Cells["B33"].Value = inputInfo.ContributionMargin;
worksheet.Cells["B34"].Value = inputInfo.SalesCompYr1;
worksheet.Cells["B35"].Value = inputInfo.SalesCompYr2;
worksheet.Cells["B36"].Value = inputInfo.SalesCompYr3;
worksheet.Cells["B37"].Value = inputInfo.SalesCompYr4;
worksheet.Cells["B38"].Value = inputInfo.SalesCompYr5;
worksheet.Cells["B39"].Value = inputInfo.SalesCompYr6;
worksheet.Cells["B40"].Value = inputInfo.SalesCompYr7;
worksheet.Cells["B41"].Value = inputInfo.SalesCompYr8;
worksheet.Cells["B42"].Value = inputInfo.SalesCompYr9;
worksheet.Cells["B43"].Value = inputInfo.SalesCompYr10;
worksheet.Cells["B44"].Value = inputInfo.SalesCompYr11;
worksheet.Cells["B45"].Value = inputInfo.SalesCompYr12;
worksheet.Cells["B46"].Value = inputInfo.SalesCompYr13;
worksheet.Cells["B47"].Value = inputInfo.SalesCompYr14;
worksheet.Cells["B48"].Value = inputInfo.SalesCompYr15;
worksheet.Cells["B49"].Value = inputInfo.SalesCompYr16;
worksheet.Cells["B50"].Value = inputInfo.SalesCompYr17;
worksheet.Cells["B51"].Value = inputInfo.SalesCompYr18;
worksheet.Cells["B52"].Value = inputInfo.SalesCompYr19;
worksheet.Cells["B53"].Value = inputInfo.SalesCompYr20;
worksheet.Cells["B54"].Value = inputInfo.ComSalesDesc;
worksheet.Cells["B55"].Value = inputInfo.CompSales;
worksheet.Cells["B56"].Value = inputInfo.FinanceYear + "-" + inputInfo.FinanceMonth;
}
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["B2"].Value = inputInfo.Region;
worksheet.Cells["B3"].Value = inputInfo.Province;
worksheet.Cells["B4"].Value = inputInfo.City;
worksheet.Cells["B5"].Value = inputInfo.StoreName;
worksheet.Cells["B6"].Value = inputInfo.USCode;
worksheet.Cells["B7"].Value = inputInfo.OpenDate.ToString("yyyy-MM-dd");
}
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["B2"].Value = inputInfo.Region;
worksheet.Cells["B3"].Value = inputInfo.Market;
worksheet.Cells["B4"].Value = inputInfo.StoreName;
worksheet.Cells["B5"].Value = inputInfo.USCode;
worksheet.Cells["B6"].Value = inputInfo.StoreTypeName;
worksheet.Cells["B7"].Value = inputInfo.ActualCloseDate;
worksheet.Cells["B8"].Value = inputInfo.PMNameENUS;
}
public void Input(ExcelInputDTO excelInput)
{
using (var excelPackage = new ExcelPackage(_excelData.FileInfo))
{
var worksheet = excelPackage.Workbook.Worksheets[_excelData.SheetName];
_excelData.Input(worksheet, excelInput);
excelPackage.Save();
}
}
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["A" + RowNum].Value = inputInfo.Form.AsString();
worksheet.Cells["B" + RowNum].Value = inputInfo.Comments.AsString();
worksheet.Cells["C" + RowNum].Value = inputInfo.CreateBy.AsString();
worksheet.Cells["D" + RowNum].Value = inputInfo.SendTo.AsString();
worksheet.Cells["E" + RowNum].Value = inputInfo.CreateDate.AsString();
worksheet.Cells["F" + RowNum].Value = inputInfo.SenderPosition.AsString();
worksheet.Cells["G" + RowNum].Value = inputInfo.IsRead.AsString();
RowNum++;
}
public override void Input(OfficeOpenXml.ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["B2"].Value = inputInfo.Region;
worksheet.Cells["B3"].Value = inputInfo.Province;
worksheet.Cells["B4"].Value = inputInfo.City;
worksheet.Cells["B5"].Value = inputInfo.Market;
worksheet.Cells["B6"].Value = inputInfo.StoreName;
worksheet.Cells["B7"].Value = inputInfo.USCode;
worksheet.Cells["B8"].Value = inputInfo.OpenDate.ToString("yyyy-MM-dd");
worksheet.Cells["B9"].Value = inputInfo.LeaseExpirationDate.ToString("yyyy-MM-dd");
worksheet.Cells["B10"].Value = inputInfo.Priority;
}
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["B2"].Value = inputInfo.Region.AsString();
worksheet.Cells["B3"].Value = inputInfo.Province.AsString();
worksheet.Cells["B4"].Value = inputInfo.City.AsString();
worksheet.Cells["B5"].Value = inputInfo.Market.AsString();
worksheet.Cells["B6"].Value = inputInfo.StoreName.AsString();
worksheet.Cells["B7"].Value = inputInfo.USCode.AsString();
worksheet.Cells["B8"].Value = inputInfo.OpenDate;
//worksheet.Cells["B9"].Value = inputInfo.Region.AsString();
//worksheet.Cells["B10"].Value = inputInfo.Region.AsString();
//worksheet.Cells["B11"].Value = inputInfo.Region.AsString();
}
public override void Input(OfficeOpenXml.ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
string strRow = (3 + RowNumber).ToString();
worksheet.Cells["A" + strRow].Value = (RowNumber + 1).ToString();
worksheet.Cells["B" + strRow].Value = inputInfo.McdParticipants;
worksheet.Cells["C" + strRow].Value = inputInfo.Content;
worksheet.Cells["D" + strRow].Value = inputInfo.LLParticipants;
worksheet.Cells["E" + strRow].Value = inputInfo.Topic;
worksheet.Cells["F" + strRow].Value = inputInfo.Location;
worksheet.Cells["G" + strRow].Value = inputInfo.MeetingDate;
worksheet.Cells["H" + strRow].Value = inputInfo.CreateDate;
RowNumber += 1;
}
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["B2"].Value = inputInfo.Region;
worksheet.Cells["B3"].Value = inputInfo.Market;
worksheet.Cells["B4"].Value = inputInfo.StoreName;
worksheet.Cells["B5"].Value = inputInfo.USCode;
worksheet.Cells["B6"].Value = inputInfo.StoreTypeName;
if (inputInfo.ClosureDate != null && inputInfo.ClosureDate != default(DateTime))
{
worksheet.Cells["B7"].Value = inputInfo.ClosureDate;
}
worksheet.Cells["B8"].Value = inputInfo.PMNameENUS;
}
public virtual void Edit(ExcelWorksheet worksheet, ExcelInputDTO excelInput)
{
}
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
var projectInfo = ProjectInfo.FirstOrDefault(e => e.ProjectId == inputInfo.ProjectId);
if (projectInfo == null)
{
throw new Exception("Cannot find the project info!");
}
var store = StoreBasicInfo.Search(e => e.StoreCode == projectInfo.USCode).FirstOrDefault();
if (store == null)
{
throw new Exception("Cannot find Store info!");
}
var reimageSummary = BaseWFEntity.GetWorkflowEntity(inputInfo.ProjectId, FlowCode.Reimage_Summary) as ReimageSummary;
if (reimageSummary == null)
{
throw new Exception("Cannot find Reimage Summary Info!");
}
var storeSTLocation = StoreSTLocation.GetStoreSTLocation(projectInfo.USCode);
var storeLeaseInfo = new StoreProfitabilityAndLeaseInfo();
var reimageConsInfo = ReimageConsInfo.GetConsInfo(inputInfo.ProjectId);
var reinvestment = ReinvestmentBasicInfo.FirstOrDefault(e => e.ConsInfoID == reimageConsInfo.Id);
if (reimageSummary != null)
{
storeLeaseInfo =
StoreProfitabilityAndLeaseInfo.FirstOrDefault(e => e.RefId == reimageSummary.Id);
if (storeLeaseInfo != null)
{
if (storeLeaseInfo.LastRemodelDate.HasValue && storeLeaseInfo.LastRemodelDate.Value.ToString("yyyy-MM-dd") != "1900-01-01")
{
worksheet.Cells["B43"].Value = storeLeaseInfo.LastRemodelDate;
}
worksheet.Cells["B44"].Value = storeLeaseInfo.RemainingLeaseYears;
worksheet.Cells["B46"].Value = storeLeaseInfo.TTMSOIPercent / 100;
worksheet.Cells["B47"].Value = storeLeaseInfo.AsOf;
worksheet.Cells["B48"].Value = reimageSummary.OperationRequirements;
var financial = FinancialPreanalysis.FirstOrDefault(e => e.RefId == reimageSummary.Id);
worksheet.Cells["B49"].Value = TryParseDecimal(financial.TotalSalesInc);
worksheet.Cells["B45"].Value = financial.TTMSales;
worksheet.Cells["B50"].Value = TryParseDecimal(financial.StoreCM) * 100 + "%";
worksheet.Cells["B51"].Value = financial.CurrentPriceTier;
worksheet.Cells["B52"].Value = string.IsNullOrEmpty(financial.SPTAR) ? 0 : financial.SPTAR.As <decimal>();
worksheet.Cells["B53"].Value = financial.PriceTierafterReimage;
}
//worksheet.Cells["E4"].Value = financial.MarginInc;
}
else
{
var reimageInfo = ReimageInfo.FirstOrDefault(e => e.ProjectId == inputInfo.ProjectId);
var storeBasicInfo = StoreBasicInfo.FirstOrDefault(e => e.StoreCode == reimageInfo.USCode);
var storeContractInfo = StoreContractInfo.FirstOrDefault(e => e.StoreCode == reimageInfo.USCode);
int Year = 0;
if (storeContractInfo != null)
{
if (storeContractInfo.EndDate != null)
{
DateTime dtNow = DateTime.Now;
Year = int.Parse(storeContractInfo.EndDate.ToString().Split('/')[2].Substring(0, 4)) - dtNow.Year;
}
}
DateTime?dt = storeBasicInfo.ReImageDate;
if (dt != null)
{
if (dt.ToString().Substring(0, 8) == "1/1/1900")
{
dt = null;
}
}
worksheet.Cells["B43"].Value = dt;
worksheet.Cells["B44"].Value = Year;
//storeLeaseInfo.LastRemodelDate = dt;
//storeLeaseInfo.RemainingLeaseYears = Year;
}
ReinvestmentCost cost = ReinvestmentCost.FirstOrDefault(e => e.ConsInfoID == reimageConsInfo.Id);
worksheet.Cells["B2"].Value = store.Region;
worksheet.Cells["B3"].Value = store.StoreCode;
if (reinvestment != null)
{
worksheet.Cells["B8"].Value = TryParseDecimal(reinvestment.RightSizingSeatNo);
worksheet.Cells["B11"].Value = TryParseDecimal(reinvestment.EstimatedSeatNo);
worksheet.Cells["B41"].Value = reinvestment.GBDate;
worksheet.Cells["B42"].Value = reinvestment.ConsCompletionDate;
}
if (cost != null)
{
worksheet.Cells["B13"].Value = TryParseDecimal(cost.DesignFee);
worksheet.Cells["B14"].Value = TryParseDecimal(cost.PublicBudget);
worksheet.Cells["B15"].Value = TryParseDecimal(cost.BuildingFacade);
worksheet.Cells["B16"].Value = TryParseDecimal(cost.SiteBudget);
worksheet.Cells["B17"].Value = TryParseDecimal(cost.BuildingWork);
worksheet.Cells["B18"].Value = TryParseDecimal(cost.PlumbingSystem);
worksheet.Cells["B19"].Value = TryParseDecimal(cost.ElectricalSystem);
worksheet.Cells["B20"].Value = TryParseDecimal(cost.HVACDuctSystem);
worksheet.Cells["B21"].Value = TryParseDecimal(cost.Signage);
worksheet.Cells["B22"].Value = TryParseDecimal(cost.Seating);
worksheet.Cells["B23"].Value = TryParseDecimal(cost.Decor);
worksheet.Cells["B24"].Value = TryParseDecimal(cost.Kiosk);
worksheet.Cells["B25"].Value = TryParseDecimal(cost.McCafe);
worksheet.Cells["B26"].Value = TryParseDecimal(cost.MDS);
worksheet.Cells["B27"].Value = TryParseDecimal(cost.Playland);
worksheet.Cells["B28"].Value = TryParseDecimal(cost.KitchenCapacityUpgrade);
worksheet.Cells["B29"].Value = TryParseDecimal(cost.BuildingWorks);
worksheet.Cells["B30"].Value = TryParseDecimal(cost.KitchenEquipment);
worksheet.Cells["B31"].Value = TryParseDecimal(cost.HVAC);
worksheet.Cells["B32"].Value = TryParseDecimal(cost.Plumbing);
worksheet.Cells["B33"].Value = TryParseDecimal(cost.ElectricDistribution);
worksheet.Cells["B34"].Value = TryParseDecimal(cost.Structure);
worksheet.Cells["B35"].Value = TryParseDecimal(cost.Others);
worksheet.Cells["B36"].Value = TryParseDecimal(cost.LHIPMAct);
worksheet.Cells["B37"].Value = TryParseDecimal(cost.SignagePMAct);
worksheet.Cells["B38"].Value = TryParseDecimal(cost.EquipmentPMAct);
worksheet.Cells["B39"].Value = TryParseDecimal(cost.SeatingPackagePMAct);
worksheet.Cells["B40"].Value = TryParseDecimal(cost.DecorPMAct);
}
worksheet.Cells["B5"].Value = storeSTLocation.TotalArea.As <decimal>();
worksheet.Cells["B6"].Value = store.ProvinceZHCN;
worksheet.Cells["B7"].Value = store.NameZHCN;
worksheet.Cells["B4"].Value = TryParseDecimal(storeSTLocation.TotalSeatsNo);
worksheet.Cells["B9"].Value = TryParseDecimal(storeSTLocation.KitchenArea);
worksheet.Cells["B10"].Value = store.CityZHCN;
if (!string.IsNullOrEmpty(storeSTLocation.DesignStyle))
{
var dict = Dictionary.FirstOrDefault(i => i.Code == storeSTLocation.DesignStyle);
if (dict != null)
{
worksheet.Cells["B12"].Value = dict.NameZHCN;
}
else
{
worksheet.Cells["B12"].Value = storeSTLocation.DesignStyle;
}
}
//worksheet.Cells["B24"].Value = reimageSummary.ReinvestmentBasicInfo.NewKiosk;
//worksheet.Cells["B25"].Value = reimageSummary.ReinvestmentBasicInfo.NewMcCafe;
//worksheet.Cells["B26"].Value = reimageSummary.ReinvestmentBasicInfo.NewMDS;
//worksheet.Cells["B41"].Value = reimageSummary.ReinvestmentBasicInfo.GBDate;
//worksheet.Cells["B42"].Value = reimageSummary.ReinvestmentBasicInfo.ConsCompletionDate;
worksheet.Cells["B10"].Value = store.CityZHCN;
//worksheet.Cells["B11"].Value = inputInfo.StoreType;
//worksheet.Cells["B12"].Value = inputInfo.StoreType;
//worksheet.Cells["B13"].Value = inputInfo.StoreType;
//worksheet.Cells["B14"].Value = inputInfo.StoreType;
//worksheet.Cells["B15"].Value = inputInfo.StoreType;
//worksheet.Cells["B16"].Value = inputInfo.StoreType;
//worksheet.Cells["B17"].Value = inputInfo.StoreType;
//worksheet.Cells["B18"].Value = inputInfo.StoreType;
//worksheet.Cells["B19"].Value = inputInfo.StoreType;
//worksheet.Cells["B20"].Value = inputInfo.StoreType;
//worksheet.Cells["B21"].Value = inputInfo.StoreType;
//worksheet.Cells["B22"].Value = inputInfo.StoreType;
//worksheet.Cells["B23"].Value = inputInfo.StoreType;
//worksheet.Cells["B27"].Value = inputInfo.StoreType;
//worksheet.Cells["B28"].Value = inputInfo.StoreType;
//worksheet.Cells["B29"].Value = inputInfo.StoreType;
//worksheet.Cells["B30"].Value = inputInfo.StoreType;
//worksheet.Cells["B31"].Value = inputInfo.StoreType;
//worksheet.Cells["B32"].Value = inputInfo.StoreType;
//worksheet.Cells["B33"].Value = inputInfo.StoreType;
//worksheet.Cells["B34"].Value = inputInfo.StoreType;
//worksheet.Cells["B35"].Value = inputInfo.StoreType;
//worksheet.Cells["B36"].Value = inputInfo.StoreType;
//worksheet.Cells["B37"].Value = inputInfo.StoreType;
//worksheet.Cells["B38"].Value = inputInfo.StoreType;
//worksheet.Cells["B39"].Value = inputInfo.StoreType;
//worksheet.Cells["B40"].Value = inputInfo.StoreType;
//if (reimageSummary.StoreProfitabilityAndLeaseInfo != null)
//{
// worksheet.Cells["B43"].Value = reimageSummary.StoreProfitabilityAndLeaseInfo.LastRemodelDate;
// worksheet.Cells["B44"].Value = reimageSummary.StoreProfitabilityAndLeaseInfo.RemainingLeaseYears;
// worksheet.Cells["B45"].Value = reimageSummary.StoreProfitabilityAndLeaseInfo.TTMSales;
// worksheet.Cells["B46"].Value = reimageSummary.StoreProfitabilityAndLeaseInfo.TTMSOIPercent;
// worksheet.Cells["B47"].Value = reimageSummary.StoreProfitabilityAndLeaseInfo.AsOf;
//}
////worksheet.Cells["B48"].Value = reimageSummary.OperationRequirements;
//if (reimageSummary.FinancialPreanalysis != null)
//{
// worksheet.Cells["B49"].Value = reimageSummary.FinancialPreanalysis.TotalSalesInc;
// worksheet.Cells["B50"].Value = reimageSummary.FinancialPreanalysis.StoreCM;
// worksheet.Cells["B51"].Value = reimageSummary.FinancialPreanalysis.CurrentPriceTier;
// worksheet.Cells["B52"].Value = reimageSummary.FinancialPreanalysis.ISDWIP;
// worksheet.Cells["B53"].Value = reimageSummary.FinancialPreanalysis.SPTAR;
//}
}
public override void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["B2"].Value = inputInfo.StoreNameCN.AsString();
worksheet.Cells["B3"].Value = inputInfo.USCode.AsString();
worksheet.Cells["B4"].Value = inputInfo.City.AsString();
worksheet.Cells["B5"].Value = inputInfo.Market.AsString();
worksheet.Cells["B6"].Value = inputInfo.OpenDate;
worksheet.Cells["B7"].Value = inputInfo.Floor.AsString();
worksheet.Cells["B8"].Value = inputInfo.TotalArea.AsString();
worksheet.Cells["B9"].Value = inputInfo.TotalSeatsNo.AsString();
worksheet.Cells["B10"].Value = inputInfo.BE;
worksheet.Cells["B11"].Value = inputInfo.LeasingTerm;
worksheet.Cells["B12"].Value = inputInfo.RentCommencementDate;
worksheet.Cells["B13"].Value = inputInfo.LeaseExpirationDate;
worksheet.Cells["B14"].Value = inputInfo.RentType;
worksheet.Cells["B15"].Value = inputInfo.RentStructure;
worksheet.Cells["B16"].Value = TryParseDecimal(inputInfo.TotalSales_TTM);
worksheet.Cells["B17"].Value = TryParseDecimal(inputInfo.SalesComp_TTM);
worksheet.Cells["B18"].Value = TryParseDecimal(inputInfo.GCComp_TTM);
worksheet.Cells["B19"].Value = TryParseDecimal(inputInfo.PAC_TTM);
worksheet.Cells["B20"].Value = TryParseDecimal(inputInfo.SOI_TTM);
worksheet.Cells["B21"].Value = TryParseDecimal(inputInfo.CASHFLOW_TTM);
worksheet.Cells["B22"].Value = TryParseDecimal(inputInfo.TotalSales_TTMY1);
worksheet.Cells["B23"].Value = TryParseDecimal(inputInfo.CompSales_TTMY1);
worksheet.Cells["B24"].Value = TryParseDecimal(inputInfo.CompGC_TTMY1);
worksheet.Cells["B25"].Value = TryParseDecimal(inputInfo.PAC_TTMY1);
worksheet.Cells["B26"].Value = TryParseDecimal(inputInfo.SOI_TTMY1);
worksheet.Cells["B27"].Value = TryParseDecimal(inputInfo.CashFlow_TTMY1);
worksheet.Cells["B28"].Value = TryParseDecimal(inputInfo.TotalSales_TTMY2);
worksheet.Cells["B29"].Value = TryParseDecimal(inputInfo.CompSales_TTMY2);
worksheet.Cells["B30"].Value = TryParseDecimal(inputInfo.CompGC_TTMY2);
worksheet.Cells["B31"].Value = TryParseDecimal(inputInfo.PAC_TTMY2);
worksheet.Cells["B32"].Value = TryParseDecimal(inputInfo.SOI_TTMY2);
worksheet.Cells["B33"].Value = TryParseDecimal(inputInfo.CashFlow_TTMY2);
worksheet.Cells["B34"].Value = inputInfo.RemoteKiosk1_Status.AsString();
worksheet.Cells["B35"].Value = inputInfo.RemoteKiosk2_Status.AsString();
worksheet.Cells["B36"].Value = inputInfo.RemoteKiosk3_Status.AsString();
worksheet.Cells["B37"].Value = inputInfo.AttachedKiosk1_Status.AsString();
worksheet.Cells["B38"].Value = inputInfo.AttachedKiosk2_Status.AsString();
worksheet.Cells["B39"].Value = inputInfo.AttachedKiosk3_Status.AsString();
worksheet.Cells["B40"].Value = inputInfo.MDS_Status.AsString();
worksheet.Cells["B41"].Value = inputInfo.McCafe_Status.AsString();
worksheet.Cells["B42"].Value = inputInfo.TwentyFourHour_Status.AsString();
worksheet.Cells["B43"].Value = inputInfo.RemoteKiosk1_OpenDate;
worksheet.Cells["B44"].Value = inputInfo.RemoteKiosk2_OpenDate;
worksheet.Cells["B45"].Value = inputInfo.RemoteKiosk3_OpenDate;
worksheet.Cells["B46"].Value = inputInfo.AttachedKiosk1_OpenDate;
worksheet.Cells["B47"].Value = inputInfo.AttachedKiosk2_OpenDate;
worksheet.Cells["B48"].Value = inputInfo.AttachedKiosk3_OpenDate;
worksheet.Cells["B49"].Value = inputInfo.MDS_OpenDate;
worksheet.Cells["B50"].Value = inputInfo.McCafe_OpenDate;
worksheet.Cells["B51"].Value = inputInfo.TwentyFourHour_OpenDate;
worksheet.Cells["B52"].Value = TryParseDecimal(inputInfo.LHI_NBV);
worksheet.Cells["B53"].Value = TryParseDecimal(inputInfo.ESSD_NBV);
worksheet.Cells["B54"].Value = TryParseDecimal(inputInfo.TotalCost_NBV);
worksheet.Cells["B55"].Value = inputInfo.CurrentSituation.AsString();
worksheet.Cells["B56"].Value = inputInfo.NegotiationHistory.AsString();
worksheet.Cells["B57"].Value = inputInfo.ProposedSolution.AsString();
worksheet.Cells["B58"].Value = inputInfo.SalesTransfer.AsString();
worksheet.Cells["B59"].Value = inputInfo.MiniMarket.AsString();
worksheet.Cells["B60"].Value = inputInfo.StoreLocation.AsString();
}
public override void Edit(ExcelWorksheet worksheet, ExcelInputDTO excelInput)
{
worksheet.Cells["B54"].Value = excelInput.ComSalesDesc;
}
public override void Input(OfficeOpenXml.ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
worksheet.Cells["B2"].Value = inputInfo.USCode;
worksheet.Cells["B3"].Value = inputInfo.StoreNameEN;
worksheet.Cells["B4"].Value = inputInfo.StoreNameCN;
worksheet.Cells["B5"].Value = worksheet.Cells["B12"].Value = inputInfo.MinimarketPriority;
worksheet.Cells["B6"].Value = inputInfo.TADesrability;
worksheet.Cells["B7"].Value = inputInfo.MMTADescription;
worksheet.Cells["B8"].Value = inputInfo.MajorGenerators;
worksheet.Cells["B9"].Value = worksheet.Cells["B16"].Value = inputInfo.SitePortfolioType;
worksheet.Cells["B10"].Value = inputInfo.SiteRerating;
worksheet.Cells["B11"].Value = worksheet.Cells["B18"].Value = inputInfo.SiteDescription;
worksheet.Cells["B13"].Value = inputInfo.TADesrabilityNew;
worksheet.Cells["B14"].Value = inputInfo.MMTADescriptionNew;
worksheet.Cells["B15"].Value = inputInfo.MajorGeneratorsNew;
worksheet.Cells["B17"].Value = inputInfo.SiteRERatingFuture;
worksheet.Cells["B19"].Value = inputInfo.LeasedArea;
worksheet.Cells["B20"].Value = inputInfo.OperationSize;
worksheet.Cells["B21"].Value = inputInfo.Floors;
worksheet.Cells["B22"].Value = inputInfo.Seats;
worksheet.Cells["B23"].Value = inputInfo.BEType;
worksheet.Cells["B24"].Value = inputInfo.LeaseTenureAndTerm;
worksheet.Cells["B25"].Value = inputInfo.FreeRentalPeriod;
worksheet.Cells["B26"].Value = inputInfo.RentStructure;
worksheet.Cells["B27"].Value = inputInfo.MFStructure;
worksheet.Cells["B28"].Value = inputInfo.LeasedAreaNew;
worksheet.Cells["B29"].Value = inputInfo.OperationSizeNew;
worksheet.Cells["B30"].Value = inputInfo.FloorsNew;
worksheet.Cells["B31"].Value = inputInfo.SeatsNew;
worksheet.Cells["B32"].Value = inputInfo.BETypeNew;
worksheet.Cells["B33"].Value = inputInfo.LeaseTenureAndTermNew;
worksheet.Cells["B34"].Value = inputInfo.FreeRentalPeriodNew;
worksheet.Cells["B35"].Value = inputInfo.RentStructureNew;
worksheet.Cells["B36"].Value = inputInfo.MFStructureNew;
worksheet.Cells["B37"].Value = inputInfo.DRMFLastTY;
worksheet.Cells["B38"].Value = inputInfo.DRMFLastTYSales;
worksheet.Cells["B39"].Value = inputInfo.DRMF1stTY;
worksheet.Cells["B40"].Value = inputInfo.DRMF1stTYSales;
worksheet.Cells["B41"].Value = inputInfo.SRMFLastTY;
worksheet.Cells["B42"].Value = inputInfo.SRMFLastTYSales;
worksheet.Cells["B43"].Value = inputInfo.SRMF1stTY;
worksheet.Cells["B44"].Value = inputInfo.SRMF1stTYSales;
worksheet.Cells["B45"].Value = inputInfo.FairMarketRentAmount;
worksheet.Cells["B46"].Value = inputInfo.FairMarketRentAgent;
worksheet.Cells["B47"].Value = inputInfo.DR1stTYAmount;
worksheet.Cells["B48"].Value = inputInfo.AnnualSOILastTY;
worksheet.Cells["B49"].Value = inputInfo.AnnualSOIAvg;
worksheet.Cells["B50"].Value = inputInfo.CashROILastTY;
worksheet.Cells["B51"].Value = inputInfo.CashROIAvg;
worksheet.Cells["B52"].Value = inputInfo.LastRemodeling;
worksheet.Cells["B53"].Value = inputInfo.OriginalInvestment;
worksheet.Cells["B54"].Value = inputInfo.NBV;
worksheet.Cells["B55"].Value = inputInfo.AdditionalInvestmentCost;
worksheet.Cells["B56"].Value = inputInfo.ExclusivityClause;
worksheet.Cells["B57"].Value = inputInfo.McDsEarlyTerminationRight;
worksheet.Cells["B58"].Value = inputInfo.McDsEPRight;
worksheet.Cells["B59"].Value = inputInfo.LandlordEntity;
worksheet.Cells["B60"].Value = inputInfo.SpecialClauses;
worksheet.Cells["B61"].Value = inputInfo.OtherIssues;
worksheet.Cells["B62"].Value = inputInfo.ExclusivityClauseNew;
worksheet.Cells["B63"].Value = inputInfo.McDsEarlyTerminationRightNew;
worksheet.Cells["B64"].Value = inputInfo.McDsEPRightNew;
worksheet.Cells["B65"].Value = inputInfo.LandlordEntityNew;
worksheet.Cells["B66"].Value = inputInfo.SpecialClausesNew;
worksheet.Cells["B67"].Value = inputInfo.OtherIssuesNew;
worksheet.Cells["B68"].Value = inputInfo.DecisionLogic;
worksheet.Cells["B69"].Value = inputInfo.SpecialApprovalRequired;
}
public abstract void Input(ExcelWorksheet worksheet, ExcelInputDTO inputInfo);
//private string GetCellValue(decimal? val)
//{
// string result = string.Empty;
// if (val.HasValue)
// {
// result = val.Value.ToString("f2");
// }
// return result;
//}
public override void Input(OfficeOpenXml.ExcelWorksheet worksheet, ExcelInputDTO inputInfo)
{
var closureInfo = ClosureInfo.GetByProjectId(inputInfo.ProjectId);
var storeInfo = StoreBasicInfo.FirstOrDefault(s => s.StoreCode == closureInfo.USCode);
var storeContract = StoreContractInfo.Get(storeInfo.StoreCode);
ClosureTool closureTool = ClosureTool.Get(inputInfo.ProjectId);
//ClosureWOCheckList closureWoCheckList = ClosureWOCheckList.Get(inputInfo.ProjectId);
worksheet.Cells["B2"].Value = storeInfo.Market;
worksheet.Cells["B3"].Value = storeInfo.StoreCode;
worksheet.Cells["B4"].Value = storeInfo.NameZHCN;
worksheet.Cells["B5"].Value = storeInfo.OpenDate.ToString("yyyy-MM-dd");
if (storeContract != null)
{
worksheet.Cells["B6"].Value = storeContract.PartyAFullName;
worksheet.Cells["B7"].Value = storeContract.EndDate.HasValue ? storeContract.EndDate.Value.ToString("yyyy-MM-dd") : "";
}
worksheet.Cells["B8"].Value = closureInfo.ClosureTypeNameZHCN;
if (closureInfo.ActualCloseDate != null)
{
worksheet.Cells["B9"].Value = closureInfo.ActualCloseDate.Value.ToString("yyyy-MM-dd");
}
worksheet.Cells["B10"].Value = closureTool.Product_Sales_RMB_Adjustment;
worksheet.Cells["B11"].Value = closureTool.PAC_RMB_Adjustment;
worksheet.Cells["B12"].Value = closureTool.Rent_RMB_Adjustment;
worksheet.Cells["B13"].Value = closureTool.DepreciationLHI_RMB_Adjustment;
worksheet.Cells["B14"].Value = closureTool.InterestLHI_RMB_Adjustment;
//INTEREST LHI
// worksheet.Cells[15, 2].Value = closureTool..ToString();
worksheet.Cells["B15"].Value = closureTool.ServiceFee_RMB_Adjustment;
worksheet.Cells["B16"].Value = closureTool.Accounting_RMB_Adjustment;
worksheet.Cells["B17"].Value = closureTool.Accounting_RMB_Adjustment;
worksheet.Cells["B18"].Value = closureTool.TaxesLicenses_RMB_Adjustment;
worksheet.Cells["B19"].Value = closureTool.Depreciation_ESSD_RMB_Adjustment;
worksheet.Cells["B20"].Value = closureTool.Interest_ESSD_RMB_Adjustment;
worksheet.Cells["B21"].Value = closureTool.OtherIncExp_RMB_Adjustment;
worksheet.Cells["B22"].Value = closureTool.NonProduct_Sales_RMB_Adjustment;
worksheet.Cells["B23"].Value = closureTool.NonProduct_Costs_RMB_Adjustment;
worksheet.Cells["B24"].Value = closureTool.CompSalesMacket_Adjustment;
worksheet.Cells["B25"].Value = closureTool.CompCG_Adjustment;
worksheet.Cells["B26"].Value = closureTool.CompCGMacket_Adjustment;
worksheet.Cells["B27"].Value = closureTool.PACMarket_Adjustment;
worksheet.Cells["B28"].Value = closureTool.SOIMarket_Adjustment;
worksheet.Cells["B29"].Value = closureTool.TotalSales_TTMY1;
worksheet.Cells["B30"].Value = closureTool.CompSales_TTMY1;
worksheet.Cells["B31"].Value = closureTool.CompSales_Market_TTMY1;
worksheet.Cells["B32"].Value = closureTool.CompGC_TTMY1;
worksheet.Cells["B33"].Value = closureTool.CompGCMarket_TTMY1;
worksheet.Cells["B34"].Value = closureTool.PAC_TTMY1;
worksheet.Cells["B35"].Value = closureTool.PACMarket_TTMY1;
worksheet.Cells["B36"].Value = closureTool.SOI_TTMY1;
worksheet.Cells["B37"].Value = closureTool.SOIMarket_TTMY1;
worksheet.Cells["B38"].Value = closureTool.CashFlow_TTMY1;
worksheet.Cells["B39"].Value = closureTool.TotalSales_TTMY2;
//sheet.Cells[36, 2].Value = closureTool.cashflow.ToString();
worksheet.Cells["B40"].Value = closureTool.CompSales_TTMY2;
worksheet.Cells["B41"].Value = closureTool.CompSales_Market_TTMY2;
worksheet.Cells["B42"].Value = closureTool.CompGC_TTMY2;
worksheet.Cells["B43"].Value = closureTool.CompGCMarket_TTMY2;
worksheet.Cells["B44"].Value = closureTool.PAC_TTMY2;
worksheet.Cells["B45"].Value = closureTool.PACMarket_TTMY2;
worksheet.Cells["B46"].Value = closureTool.SOI_TTMY2;
worksheet.Cells["B47"].Value = closureTool.SOIMarket_TTMY2;
worksheet.Cells["B48"].Value = closureTool.CashFlow_TTMY2;
worksheet.Cells["B49"].Value = DateTime.Now.Year + " July";
var woEntity = ClosureWOCheckList.Get(closureTool.ProjectId);
if (woEntity != null)
{
worksheet.Cells["B50"].Value = woEntity.RE_Original;
worksheet.Cells["B51"].Value = woEntity.LHI_Original;
worksheet.Cells["B52"].Value = woEntity.ESSD_Original;
worksheet.Cells["B53"].Value = woEntity.RE_NBV;
worksheet.Cells["B54"].Value = woEntity.LHI_NBV;
worksheet.Cells["B55"].Value = woEntity.ESSD_NBV;
worksheet.Cells["B56"].Value = woEntity.EquipmentTransfer;
worksheet.Cells["B57"].Value = woEntity.ClosingCost;
}
var list = ClosureToolImpactOtherStore.Search(e => e.ClosureId == closureTool.Id).AsNoTracking().ToList();
if (list.Count > 0)
{
worksheet.Cells["B58"].Value = list[0].StoreCode;
worksheet.Cells["B59"].Value = list[0].NameZHCN;
worksheet.Cells["B60"].Value = list[0].ImpactSaltes;
}
if (list.Count > 1)
{
worksheet.Cells["B61"].Value = list[1].StoreCode;
worksheet.Cells["B62"].Value = list[1].NameZHCN;
worksheet.Cells["B63"].Value = list[1].ImpactSaltes;
}
worksheet.Cells["B64"].Value = closureTool.McppcoMargin;
worksheet.Cells["B65"].Value = closureTool.MccpcoCashFlow;
worksheet.Cells["B66"].Value = closureTool.Compensation;
worksheet.Cells["B67"].Value = closureTool.CompAssumption;
worksheet.Cells["B68"].Value = closureTool.CashflowGrowth;
if (closureTool.IsOptionOffered.HasValue)
{
worksheet.Cells["B69"].Value = closureTool.IsOptionOffered.Value ? "Yes" : "No";
}
worksheet.Cells["B70"].Value = closureTool.LeaseTerm;
worksheet.Cells["B71"].Value = closureTool.Investment;
worksheet.Cells["B72"].Value = closureTool.NPVRestaurantCashflows;
if (closureTool.Yr1SOI != null)
{
worksheet.Cells["B73"].Value = closureTool.Yr1SOI;
}
if (closureTool.Yr1SOI != null)
{
worksheet.Cells["B74"].Value = closureTool.IRR;
}
if (closureTool.ConclusionComment != null)
{
worksheet.Cells["B76"].Value = closureTool.ConclusionComment;
}
}
