/// <summary>
/// Main for the FullReport.
/// </summary>
/// <param name="xlApp">Excel application</param>
public static void FullReportMain(Excel.Application xlApp)
{
DoesFolderExist.CheckForFolder();
#if DEBUG
string[] pathArray = XlFileDialog.SelectFiles();
#else
string[] pathArray = XlFileDialog.SelectFiles(xlApp);
#endif
BreastFeedingData[] breastFeedingDataArr = new BreastFeedingData[pathArray.Length];
for (int i = 0; i < pathArray.Length; i++)
{
DataTable dataTable = DataTableCreation.CreateDataTable(pathArray[i]);
breastFeedingDataArr[i] = new BreastFeedingData(dataTable);
}
// Sort Array by date.
BreastFeedingData[] sorted = breastFeedingDataArr.OrderBy(c => c.FileDate).ToArray();
// Create a new workbook
ReportWorkbook repWorkbook = new ReportWorkbook(xlApp, sorted);
try
{
// Add data to newly created workbook
repWorkbook.AddData();
}
catch (Exception)
{
repWorkbook.Workbook.Close(false);
throw;
}
// Save new workbook
string savePath = string.Format(
CultureInfo.CurrentCulture, @"C:\Users\{0}\Documents\BFMetrics\ReportFiles", Environment.UserName);
// Save in default location
const string fileName = @"\" + "BFMetricsReport";
repWorkbook.Workbook.SaveAs(savePath + fileName);
}
/// <summary>
/// Initializes a new instance of the <see cref="SaveFileAs"/> class.
/// </summary>
/// <param name="xlApp">Current instance of the Excel Application</param>
public SaveFileAs(Excel.Application xlApp)
{
this.xlApp = xlApp;
DoesFolderExist.CheckForFolder();
}