Exemple #1
0
        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();
            }
        }
Exemple #2
0
        /// <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();
            }
        }