void loadData_Closed(object sender, EventArgs e) { this.Effect = null; LoadData dataWind = (LoadData)sender; if (dataWind.dataLoaded == false) { return; } //TODO: Get Name string name = ""; string stockStart = "", stockEnd = ""; if (dataWind.isLoadedFromBook == true) { try { stockStart = dataWind.startConnNo; stockEnd = dataWind.endConnNo; } catch (Exception ex) { MessageBox.Show("Error loading data: " + ex.Message, "Error"); return; } } if (dataWind.dataLoaded) { isLoadedFromBook = dataWind.isLoadedFromBook; toDate_loadDataWin = dataWind.toDate; fromDate_loadDataWin = dataWind.fromDate; } if (dataWind.isNewSheet || dataGridHelper.CurrentNumberOfSheets <= 0) { if (dataWind.isLoadedFromBook == false) { dataWind.data = UtilityClass.loadDataFromDatabase(fromDate_loadDataWin ?? DateTime.Now, toDate_loadDataWin ?? DateTime.Now, dataGridHelper.currentMaxSheetNumber + 1); } else { dataWind.data = UtilityClass.loadDataFromBook(dataGridHelper.currentMaxSheetNumber + 1, stockStart, stockEnd); } int key = dataGridHelper.addNewSheet(dataWind.data, name); addingNewPage(key); } else { if (dataWind.isLoadedFromBook == false) { dataWind.data = UtilityClass.loadDataFromDatabase(toDate_loadDataWin ?? DateTime.Now, fromDate_loadDataWin ?? DateTime.Now, dataGridHelper.currentSheetNumber); } else { dataWind.data = UtilityClass.loadDataFromBook(dataGridHelper.currentSheetNumber, stockStart, stockEnd); } dataGridHelper.addDataToCurrentSheet(dataWind.data); dataGridHelper.refreshCurrentPage(); } MessageBlock.Text = DateTime.Now.ToShortTimeString() + ": " + "Data loading successfull" + "\n" + MessageBlock.Text; }