private void DownloadExcel_btn_Click(object sender, EventArgs e) { //string templateFileName = Application.StartupPath + "\\" + Properties.Settings.Default.TEMPLATE_FILE_MASTER; string templateFileName = Application.StartupPath + "\\" + Properties.Settings.Default.TEMPLATE_FILE_LINE; if (!File.Exists(templateFileName)) { messageData = new MessageData("mmci00011", Properties.Resources.mmci00011, Properties.Settings.Default.TEMPLATE_FILE_LINE); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } SaveFileDialog saveDialog_dlg = new SaveFileDialog(); saveDialog_dlg.Filter = "Excel Files(*.xls) |*.xls"; if (saveDialog_dlg.ShowDialog() == DialogResult.OK) { //this.StartProgress(Properties.Resources.mmci00009); try { File.Copy(templateFileName, saveDialog_dlg.FileName, true); messageData = new MessageData("mmci00021", Properties.Resources.mmci00021, Properties.Settings.Default.TEMPLATE_FILE_LINE); logger.Info(messageData); popUpMessage.Information(messageData, Text); } catch (IOException copyError) { this.CompleteProgress(); messageData = new MessageData("mmcc00001", Properties.Resources.mmcc00001, copyError.Message); popUpMessage.ApplicationError(messageData, Text); logger.Error(messageData); return; } ExportExcelProcess excelProcess = new ExportExcelProcess(); excelProcess.DownloadExcel(saveDialog_dlg.FileName, Properties.Settings.Default.EXCEL_SHEET_LINE_MASTER); this.CompleteProgress(); } }
/// <summary> /// Download Mold master excel template /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Download_btn_Click(object sender, EventArgs e) { string xlsFileName = Application.StartupPath + "\\" + Properties.Settings.Default.TEMPLATE_FILE_MASTER; if (!File.Exists(xlsFileName)) { messageData = new MessageData("mmci00011", Properties.Resources.mmci00011, Properties.Settings.Default.TEMPLATE_FILE_MASTER); logger.Info(messageData); popUpMessage.Information(messageData, Text); return; } ExcelExport_sfdlg.FileName = string.Empty; ExcelExport_sfdlg.Filter = "Excel Files(*.xls) |*.xls"; if (ExcelExport_sfdlg.ShowDialog() == DialogResult.OK) { base.StartProgress(Properties.Resources.mmci00009); try { File.Copy(xlsFileName, ExcelExport_sfdlg.FileName, true); } catch (IOException copyError) { this.CompleteProgress(); messageData = new MessageData("mmcc00001", Properties.Resources.mmcc00001, copyError.Message); popUpMessage.ApplicationError(messageData, Text); logger.Error(messageData); return; } ExportExcelProcess exportTemplate = new ExportExcelProcess(); exportTemplate.DownloadExcel(ExcelExport_sfdlg.FileName, Properties.Settings.Default.EXCEL_SHEET_MOLD); this.CompleteProgress(); } }