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); } }
private void removeHeaderButton_Click(object sender, EventArgs e) { int headerNumber = 0; DataGridViewRow headerRow; if (headerDataGridView.Rows.Count > 0) { headerRow = headerDataGridView.CurrentRow; headerNumber = Convert.ToInt32(headerRow.Cells["headerNumber"].Value); try { HeaderDAO headerDAO = new HeaderDAO(ConfigurationDatabase); headerDAO.Delete(FileTypeID, headerNumber); Headers = headerDAO.GetHeadersByFileTypeID(FileTypeID); if (Headers != null) { headerDataGridView.Rows.Remove(headerRow); foreach (DataGridViewRow row in headerDataGridView.Rows) { row.Cells["headerNumber"].Value = row.Cells["headerNumber"].RowIndex; } headerDataGridView.Refresh(); } } catch (Exception exception) { MessageBox.Show("Failed to remove Header. " + exception.Message, "Header Configuration", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void loadEditFileTypeWorker_DoWork(object sender, DoWorkEventArgs e) { if (ConfigurationDatabase != null) { try { FileTypeDAO fileTypeDAO = new FileTypeDAO(ConfigurationDatabase); FileType = fileTypeDAO.GetFileType(FileTypeID); } catch (Exception exception) { MessageBox.Show("Failed to get File Type data. " + exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (FileType != null) { fileTypeIDTextBox.Invoke(new Action(() => fileTypeIDTextBox.Text = FileType.FileTypeID.ToString())); nameTextBox.Invoke(new Action(() => nameTextBox.Text = FileType.Name)); delimiterTextBox.Invoke(new Action(() => delimiterTextBox.Text = FileType.Delimiter.ToString())); storedProcedureTextBox.Invoke(new Action(() => storedProcedureTextBox.Text = FileType.DatabaseStoredProcedureName)); headerGroupBox.Invoke(new Action(() => headerGroupBox.Enabled = true)); footerGroupBox.Invoke(new Action(() => footerGroupBox.Enabled = true)); columnGroupBox.Invoke(new Action(() => columnGroupBox.Enabled = true)); settingsGroupBox.Invoke(new Action(() => settingsGroupBox.Enabled = true)); try { SettingsDAO settingsDAO = new SettingsDAO(ConfigurationDatabase); Settings = settingsDAO.GetSettingsByFileTypeID(FileTypeID); } catch (Exception exception) { MessageBox.Show("Failed to get Settings data. " + exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (Settings != null) { useFileNameCheckBox.Invoke(new Action(() => useFileNameCheckBox.Checked = Settings.UseFileName)); useFileExtensionCheckBox.Invoke(new Action(() => useFileExtensionCheckBox.Checked = Settings.UseFileExtension)); textToIgnoreFileNameTextBox.Invoke(new Action(() => textToIgnoreFileNameTextBox.Text = Settings.TextToIgnoreFileName)); dateTimeFormatFileNameTextBox.Invoke(new Action(() => dateTimeFormatFileNameTextBox.Text = Settings.DateTimeFormatFileName)); textToIgnoreFileExtensionTextBox.Invoke(new Action(() => textToIgnoreFileExtensionTextBox.Text = Settings.TextToIgnoreFileExtension)); dateTimeFormatFileExtensionTextBox.Invoke(new Action(() => dateTimeFormatFileExtensionTextBox.Text = Settings.DateTimeFormatFileExtension)); linkDateTimeCheckBox.Invoke(new Action(() => linkDateTimeCheckBox.Checked = Settings.LinkDateTime)); dateTimeColumnTextBox.Invoke(new Action(() => dateTimeColumnTextBox.Text = Settings.DateTimeColumn)); dateTimeFormatLinkDateTextBox.Invoke(new Action(() => dateTimeFormatLinkDateTextBox.Text = Settings.DateTimeFormatLinkDate)); truncateTableCheckBox.Invoke(new Action(() => truncateTableCheckBox.Checked = Settings.TruncateTable)); } try { HeaderDAO headerDAO = new HeaderDAO(ConfigurationDatabase); Headers = headerDAO.GetHeadersByFileTypeID(FileTypeID); } catch (Exception exception) { MessageBox.Show("Failed to get Header data. " + exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (Headers != null) { foreach (Header header in Headers) { headerDataGridView.Invoke(new Action(() => headerDataGridView.Rows.Add(header.HeaderNumber.ToString(), header.HeaderName))); } } try { ColumnDAO columnDAO = new ColumnDAO(ConfigurationDatabase); Columns = columnDAO.Read(FileTypeID); } catch (Exception exception) { MessageBox.Show("Failed to get Column data. " + exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (Columns != null) { foreach (Column column in Columns) { columnDataGridView.Invoke(new Action(() => columnDataGridView.Rows.Add(column.ColumnNumber.ToString(), column.ColumnName, column.DatabaseColumnName, column.Ignore, column.NotInFile))); } } } } }
public void Start() { try { if (!EventLog.SourceExists(Name)) { EventLog.CreateEventSource(Name, "File Reader Service"); } eventLog = new EventLog(); eventLog.Log = "File Reader Service"; eventLog.Source = Name; } catch (Exception exception) { Console.WriteLine("Failed to setup event viewer logging. " + exception.Message); } try { if (ConfigurationDatabase != null) { FileTypeDAO fileTypeDAO = new FileTypeDAO(ConfigurationDatabase); FileType = fileTypeDAO.GetFileType(FileTypeID); SettingsDAO settingsDAO = new SettingsDAO(ConfigurationDatabase); FileType.Settings = settingsDAO.GetSettingsByFileTypeID(FileTypeID); ColumnDAO columnDAO = new ColumnDAO(ConfigurationDatabase); FileType.Columns = columnDAO.Read(FileTypeID); HeaderDAO headerDAO = new HeaderDAO(ConfigurationDatabase); FileType.Headers = headerDAO.GetHeadersByFileTypeID(FileTypeID); FooterDAO footerDAO = new FooterDAO(ConfigurationDatabase); FileType.Footers = footerDAO.GetFootersByFileTypeID(FileTypeID); } } catch (Exception exception) { Console.WriteLine("Failed to get file type information from configuration database. " + exception.Message); if (eventLog != null) { eventLog.WriteEntry("Failed to get file type information from configuration database. " + exception.Message, EventLogEntryType.Error); } } try { FileSystemWatcher = new FileSystemWatcher(Directory, "*.*"); FileSystemWatcher.Changed += new FileSystemEventHandler(OnChanged); FileSystemWatcher.NotifyFilter = NotifyFilters.LastWrite; FileSystemWatcher.EnableRaisingEvents = true; } catch (Exception exception) { Console.WriteLine("Failed to setup file system watcher. " + exception.Message); if (eventLog != null) { eventLog.WriteEntry("Failed to setup file system watcher. " + exception.Message, EventLogEntryType.Error); } } }