/// <summary>
/// This method invokes open file dialog and updates DataGridView with
/// table from selected CSV file.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLoadData_Click(object sender, EventArgs e)
{
openFileDialog1.Filter = FILE_TYPE_FILTER;
if (openFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
textFilePath.Text = openFileDialog1.FileName;
}
else
{
return;
}
dgvRockDataTable.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dgvRockDataTable.AutoResizeColumns();
readCSV = new ReadWriteCSV();
dt = readCSV.BindDataCSV(textFilePath.Text);
if (dt == null)
{
return;
}
dgvRockDataTable.DataSource = readCSV.BindDataCSV(textFilePath.Text);
//Assigning current array of data to global variable to be accessed for statistics calculation
currentheaders = readCSV.getAllColumnNames();
currentDataArray = readCSV.getOriginalDataArray();
populateStatisticsVariableList(currentheaders);
}
/// <summary>
/// Handling of saving of statistics CSV file.
/// </summary>
public void saveCSVStatistics()
{
string filepath;
saveCSVDialog.Filter = FILE_TYPE_FILTER_STATS;
if (saveCSVDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
filepath = saveCSVDialog.FileName;
}
else
{
return;
}
ReadWriteCSV writeCSV = new ReadWriteCSV();
writeCSV.writeCSVStatisticstoFile(filepath);
}