/// <summary>
/// When the Excel is Closed, at thay time this event is called
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
///
private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
{
if (FAST._txtProcess == clsInformation.promotionsView)
{
if (!ClsPromotions.promotionsBeforeClose())
{
return;
}
bool isDirty = Globals.ThisAddIn.Application.ActiveWorkbook.Saved;
if (!isDirty)
{
return;
}
Globals.ThisAddIn.Application.ActiveWorkbook.Save();
FAST.updateEvents(true);
Globals.ThisAddIn.Application.ActiveWorkbook.Close();
}
}
/// <summary>
/// Application_WorkbookOpen Event will be called whenever a saved Workbook is Opened
/// </summary>
/// <param name="Wb">The Activeworkbook information is passed as parameter</param>
void Application_WorkbookOpen(Excel.Workbook Wb)
{
try
{
ExcelTool.Workbook excelWorkbook = Globals.Factory.GetVstoObject(Globals.ThisAddIn.Application.ActiveWorkbook);
List <string> sheetNames = new List <string>();
foreach (Excel.Worksheet sheet in excelWorkbook.Sheets)
{
sheetNames.Add(sheet.Name);
}
//if (sheetNames.Contains(clsInformation.PROMO_INPUT_TOOL))
//{
//}
//Worksheet worksheet = Globals.Factory.GetVstoObject(Globals.ThisAddIn.Application.ActiveWorkbook.Sheets[clsInformation.PROMO_INPUT_TOOL]);
Worksheet worksheet = Globals.Factory.GetVstoObject(Globals.ThisAddIn.Application.ActiveWorkbook.Sheets[sheetNames[1]]);
if (worksheet != null)
{
int range = worksheet.Rows.Count;;
if (range > 11)
{
ClsPromotions.promoUploadOnline();
FAST._verifyDownloadForUpload = true;
}
}
FAST.updateControl();
}
catch { }
}
