Exemple #1
0
        private void removeFileTypeButton_Click(object sender, EventArgs e)
        {
            DialogResult result = MessageBox.Show("Are you sure you want to delete this File Type?", "Remove File Type", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation);

            if (result == DialogResult.OK)
            {
                int fileTypeID;

                DataGridViewRow fileTypeRow;

                if (fileTypeGridView.Rows.Count > 0)
                {
                    fileTypeRow = fileTypeGridView.CurrentRow;

                    fileTypeID = Convert.ToInt32(fileTypeRow.Cells["fileTypeID"].Value);

                    try
                    {
                        FileTypeDAO fileTypeDAO = new FileTypeDAO(ConfigurationDatabase);
                        fileTypeDAO.Delete(fileTypeID);

                        SettingsDAO settingsDAO = new SettingsDAO(ConfigurationDatabase);
                        settingsDAO.Delete(fileTypeID);

                        ColumnDAO columnDAO = new ColumnDAO(ConfigurationDatabase);
                        columnDAO.DeleteAll(fileTypeID);

                        HeaderDAO headerDAO = new HeaderDAO(ConfigurationDatabase);
                        headerDAO.DeleteAll(fileTypeID);

                        FooterDAO footerDAO = new FooterDAO(ConfigurationDatabase);
                        footerDAO.DeleteAll(fileTypeID);

                        FileTypes = fileTypeDAO.GetAllFileTypes();

                        if (FileTypes != null)
                        {
                            fileTypeGridView.Rows.Remove(fileTypeRow);
                            fileTypeGridView.Refresh();
                        }
                    }
                    catch (Exception exception)
                    {
                        MessageBox.Show("Failed to remove File Source. " + exception.Message, "File Source Configuration", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
            }
        }
        private void saveFileTypeButton_Click(object sender, EventArgs e)
        {
            try
            {
                SettingsDAO settingsDAO = new SettingsDAO(ConfigurationDatabase);
                settingsDAO.Delete(FileTypeID);

                settingsDAO.Insert(new Settings(FileTypeID, useFileNameCheckBox.Checked, useFileExtensionCheckBox.Checked, textToIgnoreFileNameTextBox.Text, dateTimeFormatFileNameTextBox.Text, textToIgnoreFileExtensionTextBox.Text, dateTimeFormatFileExtensionTextBox.Text, linkDateTimeCheckBox.Checked, dateTimeColumnTextBox.Text, dateTimeFormatLinkDateTextBox.Text, truncateTableCheckBox.Checked));

                ColumnDAO columnDAO = new ColumnDAO(ConfigurationDatabase);
                columnDAO.DeleteAll(FileTypeID);

                foreach (DataGridViewRow row in columnDataGridView.Rows)
                {
                    columnDAO.Insert(new Column(FileTypeID, Convert.ToInt32(row.Cells[0].Value), row.Cells[1].Value.ToString(), row.Cells[2].Value.ToString(), Convert.ToBoolean(row.Cells[3].Value), Convert.ToBoolean(row.Cells[4].Value)));
                }

                HeaderDAO headerDAO = new HeaderDAO(ConfigurationDatabase);
                headerDAO.DeleteAll(FileTypeID);

                foreach (DataGridViewRow row in headerDataGridView.Rows)
                {
                    headerDAO.Insert(new Header(FileTypeID, Convert.ToInt32(row.Cells[0].Value), row.Cells[1].Value.ToString()));
                }

                FooterDAO footerDAO = new FooterDAO(ConfigurationDatabase);
                footerDAO.DeleteAll(FileTypeID);

                foreach (DataGridViewRow row in footerDataGridView.Rows)
                {
                    footerDAO.Insert(new Footer(FileTypeID, Convert.ToInt32(row.Cells[0].Value), row.Cells[1].Value.ToString()));
                }

                MessageBox.Show("Successfully saved File Type Configuration!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);

                Close();
            }
            catch (Exception exception)
            {
                MessageBox.Show("Failed to save Column data. " + exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }