private void Sheet2_Startup(object sender, System.EventArgs e)
{
this.Sheet2_TitleLabel.Value2 = Properties.Resources.Sheet2Title;
this.Name = Properties.Resources.Sheet2Name;
this.IceCreamLabel.Value2 = Properties.Resources.IceCreamHeader;
this.Chart_1.ChartTitle.Text = Properties.Resources.ProfitHeader;
((Excel.Axis) this.Chart_1.Axes(Excel.XlAxisType.xlValue, Excel.XlAxisGroup.xlPrimary)).AxisTitle.Text = Properties.Resources.ProfitHeader;
((Excel.Axis) this.Chart_1.Axes(Excel.XlAxisType.xlCategory, Excel.XlAxisGroup.xlPrimary)).AxisTitle.Text = Properties.Resources.DateHeader;
this.view = Globals.DataSet.CreateView();
if (this.Flavor != null)
{
view.Flavor = this.Flavor;
}
else if (view.Count != 0)
{
this.Flavor = (string)view[0].Row["Flavor"];
}
this.FlavorNamedRange.DataBindings.Add("Value2", this, "Flavor");
this.History.SetDataBinding(view, "", "Date", "Inventory", "Sold", "Profit");
this.History.ListColumns[1].Name = Properties.Resources.DateHeader;
this.History.ListColumns[2].Name = Properties.Resources.InventoryHeader;
this.History.ListColumns[3].Name = Properties.Resources.SoldHeader;
this.History.ListColumns[4].Name = Properties.Resources.ProfitHeader;
}
private void Sheet1_Startup(object sender, System.EventArgs e)
{
try
{
this.Sheet1_TitleLabel.Value2 = Properties.Resources.Sheet1Title;
this.Name = Properties.Resources.Sheet1Name;
this.newDateButton.Text = Properties.Resources.AddNewDateButton;
this.saveButton.Text = Properties.Resources.SaveDataButton;
this.dayView = Globals.DataSet.CreateView();
if (Globals.DataSet.Sales.Count != 0)
{
this.DateSelector.MinDate = Globals.DataSet.MinDate;
this.DateSelector.MaxDate = Globals.DataSet.MaxDate;
this.DateSelector.Value = this.DateSelector.MaxDate;
}
using (TextFileGenerator textFile = new TextFileGenerator(Globals.DataSet.Sales))
{
this.pivotTable = CreatePivotTable(textFile.FullPath);
}
Globals.DataSet.Sales.SalesRowChanged += new OperationsBaseData.SalesRowChangeEventHandler(Sales_SalesRowChanged);
UnscheduledOrderControl smartPaneControl = new UnscheduledOrderControl();
smartPaneControl.Dock = DockStyle.Fill;
smartPaneControl.View = this.dayView;
Globals.ThisWorkbook.ActionsPane.Controls.Add(smartPaneControl);
this.Activate();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.ToString());
MessageBox.Show(ex.Message);
}
}
