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;
}
