private void ExportCSVFile()
{
if (dataGrid.ColumnCount > 0)
{
using (var fileDialog = new SaveFileDialog())
{
//openFileDialog.InitialDirectory = @"%HOMEPATH%";
fileDialog.Filter = Resources.csvfile_extension;
fileDialog.FilterIndex = 1;
fileDialog.RestoreDirectory = true;
if (fileDialog.ShowDialog() == DialogResult.OK)
{
// Save the contents of the dataGrid into the chosen file
if (ImpExpUtilities.ExportCSV(dataGrid, fileDialog.FileName))
{
MessageBox.Show(Resources.saveCurrent_success + fileDialog.FileName, Resources.success, MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show(Resources.saveCSV_fail_msg, Resources.fail, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
else
{
MessageBox.Show(Resources.saveEmptyTable_fail_msg, Resources.fail, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void ExportXmlFile()
{
if (dataGrid.ColumnCount > 0)
{
using (var fileDialog = new SaveFileDialog())
{
//openFileDialog.InitialDirectory = @"%HOMEPATH%";
fileDialog.Filter = Resources.xmlfile_dialogextension;
fileDialog.FilterIndex = 1;
fileDialog.RestoreDirectory = true;
if (fileDialog.ShowDialog() == DialogResult.OK)
{
var ds = (DataTable)dataGrid.DataSource;
// Save the contents of the dataGrid into the chosen file
ImpExpUtilities.ExportXML(ds, fileDialog.FileName);
currentOpenDocumentPath = fileDialog.FileName; // Save to the exported file if future edits
newDocument = false; // Set flag to false since the document was being exported to the disk
this.Text = Resources.title + '[' + Path.GetFileName(fileDialog.FileName) + ']'; // Change the Forms title to currentOpenDoc #10
MessageBox.Show(Resources.saveCurrent_success + currentOpenDocumentPath, Resources.success, MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
else
{
MessageBox.Show(Resources.saveEmptyTable_fail_msg, Resources.fail, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void ExportFile()
{
if (dataGrid.ColumnCount > 0)
{
using (var fileDialog = new SaveFileDialog())
{
fileDialog.Filter = Resources.supportedFiles_extension;
fileDialog.FilterIndex = 1;
fileDialog.RestoreDirectory = true;
if (fileDialog.ShowDialog() == DialogResult.OK)
{
var fileSuccessfullyExported = false;
switch (Path.GetExtension(fileDialog.FileName)?.ToLower())
{
// Export the file depending on the chosen extension, !Export -> if export fails, return instead is to display err msg only
case ".xml":
fileSuccessfullyExported = ImpExpUtilities.ExportXML(dataGrid.DataSource as DataTable, fileDialog.FileName);
break;
case ".xlsx":
fileSuccessfullyExported = ImpExpUtilities.ExportXLS(dataGrid.DataSource as DataTable, fileDialog.FileName);
break;
case ".csv":
fileSuccessfullyExported = ImpExpUtilities.ExportCSV(dataGrid, fileDialog.FileName);
break;
}
if (fileSuccessfullyExported)
{
currentOpenDocumentPath = fileDialog.FileName;
this.Text = Resources.title + '[' + Path.GetFileName(currentOpenDocumentPath) + ']'; // Change the Forms title to currentOpenDoc #10
MessageBox.Show(Resources.saveCurrent_success + currentOpenDocumentPath, Resources.success, MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show(string.Format(Resources.saveFile_fail_msg, fileDialog.FileName), Resources.fail, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
else
{
MessageBox.Show(Resources.saveEmptyTable_fail_msg, Resources.fail, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void OpenFile()
{
using (var openFileDialog = new OpenFileDialog())
{
openFileDialog.Filter = Resources.supportedfiles_opendialogExtension;
openFileDialog.FilterIndex = 1;
openFileDialog.RestoreDirectory = true;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
if (Regex.IsMatch(Path.GetExtension(openFileDialog.FileName)?.ToLower(), @"^.*\.(xml|xlsx|xls|csv)$"))
{
Stream openedDocument = null;
try
{
// Load the contents of the file into dataGrid
openedDocument = openFileDialog.OpenFile();
dataGrid.DataSource = (Path.GetExtension(openFileDialog.FileName)?.ToLower() == ".xml")
? ImpExpUtilities.GetXmlData(openedDocument).Tables[0] // if it's an xml document
: ImpExpUtilities.GetSpreadSheetData(openedDocument as FileStream).Tables[0]; // else if (xlsx|xls|csv)
EnableCtrl(true);
currentOpenDocumentPath = openFileDialog.FileName;
this.Text = Resources.title + '[' + openFileDialog.SafeFileName + ']'; // Change the Forms title to currentOpenDoc #10
}
catch (Exception)
{
MessageBox.Show(Resources.OpenDoc_fail_msg, Resources.fail,
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
openedDocument?.Close();
}
}
else
{
MessageBox.Show(Resources.OpenDoc_fail_msg, Resources.fail, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}
private void SaveFile()
{
if (currentOpenDocumentPath != String.Empty)
{
if (!readOnly.Checked && !newDocument)
{
var fileSuccessfullyExported = false;
switch (Path.GetExtension(currentOpenDocumentPath)?.ToLower())
{
// Save the file depending on the chosen extension, !Export -> if export fails, return instead is to display err msg only
case ".xml":
fileSuccessfullyExported = ImpExpUtilities.ExportXML(dataGrid.DataSource as DataTable, currentOpenDocumentPath);
break;
case ".xlsx":
fileSuccessfullyExported = ImpExpUtilities.ExportXLS(dataGrid.DataSource as DataTable, currentOpenDocumentPath);
break;
case ".csv":
fileSuccessfullyExported = ImpExpUtilities.ExportCSV(dataGrid, currentOpenDocumentPath);
break;
}
if (fileSuccessfullyExported)
{
MessageBox.Show(Resources.saveCurrent_success + currentOpenDocumentPath, Resources.success, MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show(string.Format(Resources.saveFile_fail_msg, currentOpenDocumentPath), Resources.fail, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (readOnly.Checked && !newDocument)
{
MessageBox.Show(Resources.saveXml_fail_msg, Resources.fail, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else if (newDocument || currentOpenDocumentPath?.Length == 0)
{
ExportFile();
}
}
private void OpenXlsFile()
{
using (var openFileDialog = new OpenFileDialog())
{
//openFileDialog.InitialDirectory = @"%HOMEPATH%";
openFileDialog.Filter = Resources.xlsfile_dialogextension;
openFileDialog.FilterIndex = 1;
openFileDialog.RestoreDirectory = true;
if (openFileDialog.ShowDialog() == DialogResult.OK)
{
if (Regex.IsMatch(Path.GetExtension(openFileDialog.FileName)?.ToLower(), @"^.*\.(xlsx|xls|csv)$"))
{
Stream xlsSheet = null;
try
{
// Load the contents of the file into dataGrid
xlsSheet = openFileDialog.OpenFile();
dataGrid.DataSource = ImpExpUtilities.GetSpreadSheetData(xlsSheet as FileStream).Tables[0];
EnableCtrl(true);
this.Text = Resources.title + '[' + openFileDialog.SafeFileName + ']'; // Change the Forms title to currentOpenDoc #10
}
catch (Exception)
{
MessageBox.Show(Resources.OpenXlsSheet_fail_msg, Resources.fail,
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
xlsSheet?.Close();
}
}
else
{
MessageBox.Show(Resources.DragDrop_wrongExt_msg, Resources.fail, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
}
private void XmlDataGrid_DragDrop(object sender, DragEventArgs e)
{
var droppedDocumentPath = (string[])e.Data.GetData(DataFormats.FileDrop, false);
if (droppedDocumentPath.Length > 1)
{
MessageBox.Show(Resources.DragDrop_many_msg, Resources.warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (Regex.IsMatch(Path.GetExtension(droppedDocumentPath[0])?.ToLower(), @"^.*\.(xml|xlsx|xls|csv)$"))
{
FileStream droppedDocument = null;
try
{
// Load the contents of the file into dataGrid
droppedDocument = new FileStream(droppedDocumentPath[0], FileMode.Open, FileAccess.Read); // [0] => the first selected file
dataGrid.DataSource = (Path.GetExtension(droppedDocumentPath[0])?.ToLower() == ".xml")
? ImpExpUtilities.GetXmlData(droppedDocument).Tables[0] // if it's an xml document
: ImpExpUtilities.GetSpreadSheetData(droppedDocument).Tables[0]; // else if (xlsx|xls|csv)
EnableCtrl(true);
currentOpenDocumentPath = (Path.GetExtension(droppedDocumentPath[0])?.ToLower() == ".xml") ? droppedDocumentPath[0] : String.Empty; // Set the currentOpenPath variable to be used later for saving
this.Text = Resources.title + '[' + Path.GetFileName(droppedDocumentPath[0]) + ']'; // Change the Forms title to currentOpenDoc #10
}
catch (Exception)
{
MessageBox.Show(Resources.OpenDoc_fail_msg, Resources.fail, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
// Fixes #29 file lock issue
droppedDocument?.Close();
}
}
else
{
MessageBox.Show(Resources.DragDrop_wrongExt_msg, Resources.warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
