private void exportContractorsToCSV() { try { //first step is too check if temp file exists and if it does delete it //to start again if (File.Exists(Application.StartupPath + @"\database\temp\contractorlists.csv")) { File.Delete(Application.StartupPath + @"\database\temp\contractorlists.csv"); } //now we get the value of all input and selection fields and convert them to appropriate data type exportToCSV CSV = new exportToCSV(); CSV.createContractorListsCSVDocument(); string year = textBoxSaveToCSVEndYear.Text; try { if (File.Exists(Application.StartupPath + @"\database\" + year + @"\contractors\lists\contractors.xml")) { CSV.generateContractorListsCSVDocument(Application.StartupPath + @"\database\" + year + @"\contractors\lists\contractors.xml", DateTime.Now.ToString("d/MM/yyyy"), "contractor"); } } catch (Exception err) { debugTerminal terminal = new debugTerminal(); terminal.output(err.ToString()); } //now we let the user save the temp excel file SaveFileDialog save = new SaveFileDialog(); save.Filter = "Excel|*.CSV"; save.FileName = "myContractorList.csv"; progressBar1.Value = 50; save.ShowDialog(); File.Copy(Application.StartupPath + @"\database\temp\contractorlists.csv", save.FileName); //exportCSVValidate.Text = "File Saved"; //delete temp file File.Delete(Application.StartupPath + @"\database\temp\contractorlists.csv"); progressBar1.Value = 100; } catch (Exception err) { exportCSVValidate.Text = "File was not saved"; progressBar1.Value = 0; if (File.Exists(Application.StartupPath + @"\database\temp\contractorlists.csv")) { File.Delete(Application.StartupPath + @"\database\temp\contractorlists.csv"); debugTerminal terminal = new debugTerminal(); terminal.output(err.ToString()); } } }