private static void RunCommandLineShell(string[] args)
{
bool bDisplayHelp = (args.Length > 3 && args.Length < 11);
System.Array.Resize(ref args, 11);
string ParentString = args[1];
string ChildString = args[2];
int MatchingAlgorithm = ClassLibraryStandard.HelperMethods.IsInteger(args[3]) ? int.Parse(args[3], UserHelper.culture) : ExplorerForm.SetComparisonType(DataAccess.GetUserPreferenceByPreferenceName(Constants.DB_MATCHING_ALGORITHM));
bool MakeCaseInsensitive = args[4] != null?ClassLibraryStandard.HelperMethods.ToBoolean(args[4]) : ClassLibraryStandard.HelperMethods.ToBoolean(DataAccess.GetUserPreferenceByPreferenceName(Constants.DB_APPLY_CASE_INSENSITIVITY));
bool PadToEqualLength = args[5] != null?ClassLibraryStandard.HelperMethods.ToBoolean(args[5]) : ClassLibraryStandard.HelperMethods.ToBoolean(DataAccess.GetUserPreferenceByPreferenceName(Constants.DB_PAD_TEXT));
bool RemoveWhitespace = args[6] != null?ClassLibraryStandard.HelperMethods.ToBoolean(args[6]) : ClassLibraryStandard.HelperMethods.ToBoolean(DataAccess.GetUserPreferenceByPreferenceName(Constants.DB_REMOVE_NOISE_CHARACTERS));
bool ReverseComparison = args[7] != null?ClassLibraryStandard.HelperMethods.ToBoolean(args[7]) : ClassLibraryStandard.HelperMethods.ToBoolean(DataAccess.GetUserPreferenceByPreferenceName(Constants.DB_REVERSE_COMPARE));
bool PhoneticFilter = args[9] != null?ClassLibraryStandard.HelperMethods.ToBoolean(args[9]) : ClassLibraryStandard.HelperMethods.ToBoolean(DataAccess.GetUserPreferenceByPreferenceName(Constants.DB_PHONETIC_FILTER));
bool WholeWordComparison = args[10] != null?ClassLibraryStandard.HelperMethods.ToBoolean(args[10]) : ClassLibraryStandard.HelperMethods.ToBoolean(DataAccess.GetUserPreferenceByPreferenceName(Constants.DB_WHOLE_WORD_MATCH));
if (bDisplayHelp || ((ParentString.ToLower(UserHelper.culture) == "help" || ParentString == "?") && ChildString == null))
{
System.Console.WriteLine(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_COMMANDLINE_HELP, System.Environment.NewLine, args[0], Constants.METHOD_RATCLIFF_OBERSHELP, Constants.METHOD_LEVENSHTEIN_DISTANCE, Constants.METHOD_HAMMING_DISTANCE, Constants.METHOD_RATCLIFF_OBERSHELP_VALUE, Constants.METHOD_LEVENSHTEIN_DISTANCE_VALUE, Constants.METHOD_HAMMING_DISTANCE_VALUE));
}
int iCompare = ExplorerForm.GetComparisonPercentage(MatchingAlgorithm, ParentString, ChildString, RemoveWhitespace, MakeCaseInsensitive, PadToEqualLength, ReverseComparison, PhoneticFilter, WholeWordComparison);
TraceInitialisationComplete("TRACE - Commandline method complete");
System.Diagnostics.Trace.WriteLine(null);
System.Environment.Exit(iCompare);
}
public static void DataGridViewCellContentClick()
{
ExplorerForm.GetResultDataGridView().CommitEdit(System.Windows.Forms.DataGridViewDataErrorContexts.Commit);
System.Windows.Forms.DataGridViewRow row = ExplorerForm.GetResultDataGridView().CurrentRow;
bool bDeleteRowFlag = System.Convert.ToBoolean(row.Cells[Constants.COLUMN_DELETE_FLAG].Value, UserHelper.culture);
switch (row.Cells[Constants.COLUMN_MATCHTYPE].Value)
{
case Constants.MATCH_ASSOCIATE:
row.DefaultCellStyle.BackColor = (bDeleteRowFlag) ? Constants.COLOR_MATCH_ASSOCIATE_DELETE : Constants.COLOR_MATCH_ASSOCIATE;
break;
case Constants.MATCH_PRINCIPLE:
row.DefaultCellStyle.BackColor = (bDeleteRowFlag) ? Constants.COLOR_MATCH_PRINCIPLE_DELETE : Constants.COLOR_MATCH_PRINCIPLE;
break;
default:
row.DefaultCellStyle.BackColor = Constants.COLOR_DEFAULT;
break;
}
SetRowBackgroundColor(row.Cells[Constants.COLUMN_ROW_ID].Value, row.Cells[Constants.COLUMN_MATCHTYPE].Value, bDeleteRowFlag);
}
public static void SetDataGridViewRowBackgroundColour()
{
foreach (System.Windows.Forms.DataGridViewRow row in ExplorerForm.GetResultDataGridView().Rows)
{
bool bDeleteRowFlag = System.Convert.ToBoolean(row.Cells[Constants.COLUMN_DELETE_FLAG].Value, UserHelper.culture);
switch (row.Cells[Constants.COLUMN_MATCHTYPE].Value)
{
case Constants.MATCH_ASSOCIATE:
row.DefaultCellStyle.BackColor = (bDeleteRowFlag) ? Constants.COLOR_MATCH_ASSOCIATE_DELETE : Constants.COLOR_MATCH_ASSOCIATE;
break;
case Constants.MATCH_PRINCIPLE:
row.DefaultCellStyle.BackColor = (bDeleteRowFlag) ? Constants.COLOR_MATCH_PRINCIPLE_DELETE : Constants.COLOR_MATCH_PRINCIPLE;
break;
default:
row.DefaultCellStyle.BackColor = Constants.COLOR_DEFAULT;
break;
}
SetRowBackgroundColor(row.Cells[Constants.COLUMN_ROW_ID].Value, row.Cells[Constants.COLUMN_MATCHTYPE].Value, bDeleteRowFlag);
}
}
internal static void DeleteRowsMenuItemClick()
{
System.Collections.ArrayList keyArray = new System.Collections.ArrayList();
int rowCount = GetDistinctRows();
if (rowCount < 2)
{
ExplorerForm.DeleteSelectedRows(keyArray);
}
else
{
ConfirmDeleteRows();
}
int GetDistinctRows()
{
foreach (System.Windows.Forms.DataGridViewRow row in ExplorerForm.GetResultDataGridView().Rows)
{
if (row.IsNewRow)
{
break;
}
if ((string)row.Cells[Constants.COLUMN_MATCHTYPE].Value == Constants.MATCH_ASSOCIATE)
{
int i = (int)row.Cells[Constants.COLUMN_ROW_ID].Value;
if (!keyArray.Contains(i))
{
keyArray.Add(i);
}
}
}
return(keyArray.Count);
}
void ConfirmDeleteRows()
{
switch (System.Windows.Forms.MessageBox.Show(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_DELETE_ROWSCOUNT, System.Environment.NewLine, rowCount), Properties.Resources.CAPTION_COMPARE, System.Windows.Forms.MessageBoxButtons.YesNoCancel, System.Windows.Forms.MessageBoxIcon.Exclamation, System.Windows.Forms.MessageBoxDefaultButton.Button3))
{
case System.Windows.Forms.DialogResult.Yes:
ExplorerForm.DeleteSelectedRows(keyArray);
break;
default:
break;
}
}
}
private static bool GetResetPending(System.Windows.Forms.DataGridViewRow row)
{
if (row == null) return true;
if (row.IsNewRow)
{
if (row.Index == 0) ExplorerForm.ResetExplorerForm();
return true;
}
return false;
}
public static void ResumeDataGridViews()
{
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
ResumeDataGridViewDrawing();
void ResumeDataGridViewDrawing()
{
NAVForm.ResumeSheetDataGridView();
ExplorerForm.ResumeResultDataGridView();
}
}
public static void SuspendDataGridViews()
{
WorkTables.SetSheetDataGridViewFocus();
System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
SuspendDataGridViewDrawing();
void SuspendDataGridViewDrawing()
{
NAVForm.SuspendSheetDataGridView();
ExplorerForm.SuspendResultDataGridView();
}
}
private void SheetDataGridViewMouseDownEvent(object sender, MouseEventArgs e)
{
int columns = SheetDataGridView.Columns.GetColumnCount(DataGridViewElementStates.Visible);
int rows = (ExplorerForm.GetResultDataGridView().RowCount == 0) ? 0 : SheetDataGridView.Rows.GetRowCount(DataGridViewElementStates.Visible);
int row = (columns == 0) ? 0 : SheetDataGridView.RowCount;
DeleteColumnMenuItem.Enabled = columns != 0;
DeleteRowsMenuItem.Enabled = rows != 0;
DeleteRowMenuItem.Enabled = row != 0;
RestoreColumnsMenuItem.Enabled = columns < GetSheetColumnInitialTotal();
if (e.Button == MouseButtons.Right)
{
DataGridView.HitTestInfo hitTest = SheetDataGridView.HitTest(e.X, e.Y);
switch (hitTest.Type)
{
case DataGridViewHitTestType.ColumnHeader:
SheetDataGridView.ClearSelection();
SheetDataGridView.CurrentCell = SheetDataGridView[hitTest.ColumnIndex, 0];
break;
case DataGridViewHitTestType.RowHeader:
if (columns != 0)
{
SheetDataGridView.ClearSelection();
SheetDataGridView.CurrentCell = SheetDataGridView[SheetDataGridView.Columns.GetFirstColumn(DataGridViewElementStates.Visible).DisplayIndex, hitTest.RowIndex];
}
break;
case DataGridViewHitTestType.Cell:
if (hitTest.RowIndex >= 0)
{
SheetDataGridView.ClearSelection();
SheetDataGridView.CurrentCell = SheetDataGridView[hitTest.ColumnIndex, hitTest.RowIndex];
}
break;
default:
DeleteColumnMenuItem.Enabled = false;
break;
}
}
}
private static void SaveAsLastFileOpened(string fileName)
{
if (fileName != null)
{
Dapper.DynamicParameters param = new Dapper.DynamicParameters();
param.Add("@" + Constants.COLUMN_USER_ID, UserHelper.UserPropertiesModel.iUserID);
param.Add("@" + Constants.COLUMN_USER_LAST_FILENAME_OPENED, fileName);
param.Add("@" + Constants.COLUMN_USER_LAST_TAB_FOCUS, UserHelper.UserStateModel.nvLastTabFocus);
param.Add("@" + Constants.COLUMN_USER_LAST_TABLE_FOCUS, UserHelper.UserStateModel.nvLastTableFocus);
param.Add("@" + Constants.COLUMN_USER_BUILD_VERSION, Constants.BUILD_VERSION);
DataAccess.InsertUserStateLogEntry(param);
UserHelper.UserStateModel.nvLastFilenameOpened = fileName;
ExplorerForm.ResetExplorerForm();
}
}
private static void RestoreColumnMenuItemClickEvent()
{
DataGridViewColumn firstVisibleColumn = SheetDataGridView.Columns.GetFirstColumn(DataGridViewElementStates.Visible);
bool bComparisonRebuild = false;
foreach (DataGridViewColumn column in SheetDataGridView.Columns)
{
if (column.Name != Constants.KEY_COLUMN)
{
if (!column.Visible)
{
column.Visible = true;
bComparisonRebuild = true;
}
}
}
if (bComparisonRebuild)
{
if (firstVisibleColumn != SheetDataGridView.Columns.GetFirstColumn(DataGridViewElementStates.Visible))
{
ClassLibraryFramework.DataGridViewMethods.SortOnFirstVisibleColumn(SheetDataGridView);
}
ComparisonReset();
}
if (ExplorerForm.GetResultDataGridView() != null)
{
if (ExplorerForm.GetResultDataGridView().Rows.Count == 0)
{
ClassLibraryFramework.DataGridViewMethods.SetBackgroundColour(SheetDataGridView, Constants.COLOR_DEFAULT);
}
}
WorkTables.SetSheetDataGridViewFocus();
}
private void InitializePreferencesForm()
{
UserPreferencesDataTable = ClassLibraryStandard.DataTableMethods.GetDataTable(DataAccess.GetUserPreferences());
BuildFormControls();
void BuildFormControls()
{
using (ClassLibraryFramework.DrawingInteropServices.PauseDrawing(this))
{
int axisY = 0;
for (int rowIndex = 0; rowIndex < UserPreferencesDataTable.Rows.Count; rowIndex++)
{
if (GroupHeaderRequired(rowIndex))
{
GroupHeaderInsert(rowIndex, axisY);
axisY += 19;
}
PreferenceNameInsert(rowIndex, axisY);
PreferenceValueInsert(rowIndex, axisY);
axisY += 19;
}
RestoreDefaultsButton(axisY += 10);
axisY += 5;
PreferenceDescriptionHeaderInsert(axisY += 19);
PreferenceDescriptionInsert(axisY += 19);
InstantiatePreferenceDelegates();
}
}
void RestoreDefaultsButton(int axisY)
{
Button restoreDefaultsButton = new Button
{
Anchor = (AnchorStyles.Top | AnchorStyles.Right),
Name = Constants.CONTROL_RESTOREBUTTON_SYMBOL,
Location = new System.Drawing.Point(351, axisY),
Size = new System.Drawing.Size(100, 23),
Text = Properties.Resources.CONTROL_RESTOREBUTTON_TEXT,
UseVisualStyleBackColor = true,
FlatStyle = FlatStyle.Flat,
TabIndex = 1000
};
PreferenceToolTips.SetToolTip(restoreDefaultsButton, Properties.Resources.TOOLTIP_RESTOREDEFAULTSBUTTON);
restoreDefaultsButton.FlatAppearance.BorderColor = System.Drawing.Color.Gainsboro;
restoreDefaultsButton.Enter += PreferenceDescriptionLeave;
restoreDefaultsButton.Click += RestoreDefaultsButtonClick;
Controls.Add(restoreDefaultsButton);
}
void PreferenceDescriptionHeaderInsert(int axisY)
{
TextBox PreferenceDescriptionHeader = new TextBox
{
Name = Constants.CONTROL_PREFERENCEHEADER_SYMBOL,
Text = null,
Anchor = ((AnchorStyles.Top | AnchorStyles.Left) | AnchorStyles.Right),
BackColor = Constants.COLOR_DEFAULT_BACKCOLOR,
BorderStyle = BorderStyle.None,
Cursor = Cursors.Arrow,
ReadOnly = true,
Location = new System.Drawing.Point(0, axisY),
Margin = new Padding(3, 3, 3, 3),
Multiline = false,
Size = new System.Drawing.Size(451, 85),
TabIndex = 0,
TabStop = false
};
PreferenceDescriptionHeader.GotFocus += (s1, e1) => { ClassLibraryStandard.TextBoxInteropServices.HideCaret(PreferenceDescriptionHeader.Handle); };
Controls.Add(PreferenceDescriptionHeader);
}
void PreferenceDescriptionInsert(int axisY)
{
TextBox PreferenceDescription = new TextBox
{
Name = Constants.CONTROL_PREFERENCEDESCRIPTION_SYMBOL,
Text = null,
Anchor = ((AnchorStyles.Top | AnchorStyles.Left) | AnchorStyles.Right),
BackColor = Constants.COLOR_DEFAULT_BACKCOLOR,
BorderStyle = BorderStyle.None,
Cursor = Cursors.Arrow,
ReadOnly = true,
Location = new System.Drawing.Point(0, axisY),
Margin = new Padding(3, 3, 3, 3),
Multiline = true,
Size = new System.Drawing.Size(451, 85),
TabIndex = 0,
TabStop = false
};
PreferenceDescription.GotFocus += (s1, e1) => { ClassLibraryStandard.TextBoxInteropServices.HideCaret(PreferenceDescription.Handle); };
Controls.Add(PreferenceDescription);
}
void GroupHeaderInsert(int rowIndex, int axisY)
{
string controlName = Constants.CONTROL_DIVIDER_SYMBOL + UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_USER_PREFERENCE_ID].ToString().Trim();
TextBox DividerTextBox = new TextBox
{
Name = controlName,
Location = new System.Drawing.Point(0, axisY),
Text = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_PREFERENCE_TYPE].ToString().Trim(),
Anchor = ((AnchorStyles.Top | AnchorStyles.Left) | AnchorStyles.Right),
BackColor = Constants.COLOR_MATCH_ASSOCIATE,
ForeColor = Constants.COLOR_DEFAULT_TEXT,
BorderStyle = BorderStyle.FixedSingle,
Cursor = Cursors.Arrow,
ReadOnly = true,
Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))),
RightToLeft = RightToLeft.No,
Size = new System.Drawing.Size(451, 20),
TabIndex = rowIndex + 500
};
DividerTextBox.GotFocus += (s1, e1) => { ClassLibraryStandard.TextBoxInteropServices.HideCaret(DividerTextBox.Handle); };
DividerTextBox.Enter += PreferenceDescriptionLeave;
DividerTextBox.Enter += TextBoxBackColorChange;
DividerTextBox.Leave += TextBoxBackColorChange;
DividerTextBox.KeyDown += TextBoxKeyDown;
Controls.Add(DividerTextBox);
}
void PreferenceNameInsert(int rowIndex, int axisY)
{
string controlName = Constants.CONTROL_PREFERENCE_SYMBOL + UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_USER_PREFERENCE_ID].ToString().Trim();
TextBox PreferenceTextBox = new TextBox
{
Name = controlName,
Location = new System.Drawing.Point(0, axisY),
Text = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_PREFERENCE_NAME].ToString().Trim(),
Anchor = ((((AnchorStyles.Top | AnchorStyles.Bottom) | AnchorStyles.Left))),
BackColor = Constants.COLOR_MATCH_ASSOCIATE,
ForeColor = Constants.COLOR_DEFAULT_TEXT,
BorderStyle = BorderStyle.FixedSingle,
Cursor = Cursors.Arrow,
ReadOnly = true,
Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))),
RightToLeft = RightToLeft.No,
Size = new System.Drawing.Size(135, 20),
AccessibleDescription = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_PREFERENCE_DESCRIPTION].ToString().Trim(),
AccessibleName = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_PREFERENCE_NAME].ToString().Trim(),
TabIndex = rowIndex + 500
};
PreferenceTextBox.GotFocus += (s1, e1) => { ClassLibraryStandard.TextBoxInteropServices.HideCaret(PreferenceTextBox.Handle); };
PreferenceTextBox.Enter += TextBoxBackColorChange;
PreferenceTextBox.Enter += PreferenceDescriptionEnter;
PreferenceTextBox.Leave += TextBoxBackColorChange;
PreferenceTextBox.KeyDown += TextBoxKeyDown;
Controls.Add(PreferenceTextBox);
}
void PreferenceValueInsert(int rowIndex, int axisY)
{
string controlName = Constants.CONTROL_VALUE_SYMBOL + UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_USER_PREFERENCE_ID].ToString().Trim();
string nvClientPreferenceName = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_PREFERENCE_NAME].ToString().Trim();
bool bClientOverride = ClassLibraryStandard.HelperMethods.ToBoolean(UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_OVERRIDE_FLAG].ToString());
bool bSystemOverride = ClassLibraryStandard.HelperMethods.ToBoolean(UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_SYSTEM_OVERRIDE_FLAG].ToString());
if (ClassLibraryStandard.HelperMethods.ToBoolean(UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_VALUE_REQUIRED_FLAG].ToString()))
{
switch (nvClientPreferenceName)
{
case Constants.DB_MATCHING_ALGORITHM:
BuildListValueComboBox();
break;
default:
BuildValueTextBox();
break;
}
}
else
{
BuildValueComboBox();
}
void BuildListValueComboBox()
{
ClassLibraryFramework.ComboBoxEx ListValueComboBox = new ClassLibraryFramework.ComboBoxEx
{
Name = controlName,
Location = new System.Drawing.Point(134, axisY - 1),
Anchor = (((((AnchorStyles.Top | AnchorStyles.Bottom) | AnchorStyles.Left) | AnchorStyles.Right))),
BackColor = Constants.COLOR_DEFAULT,
ForeColor = (bClientOverride || bSystemOverride) ? System.Drawing.Color.DimGray : System.Drawing.Color.Black,
FormattingEnabled = true,
RightToLeft = RightToLeft.No,
Size = new System.Drawing.Size(317, 21),
AccessibleDescription = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_PREFERENCE_DESCRIPTION].ToString().Trim(),
AccessibleDefaultActionDescription = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_USER_PREFERENCE_VALUE].ToString().Trim(),
AccessibleName = nvClientPreferenceName,
TabIndex = rowIndex
};
switch (nvClientPreferenceName)
{
case Constants.DB_MATCHING_ALGORITHM:
ListValueComboBox.Items.AddRange(new object[] { Constants.METHOD_RATCLIFF_OBERSHELP, Constants.METHOD_LEVENSHTEIN_DISTANCE, Constants.METHOD_HAMMING_DISTANCE });
ListValueComboBox.SelectedIndex = ExplorerForm.GetComparisonType(UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_USER_PREFERENCE_VALUE].ToString().Trim());
break;
default:
ListValueComboBox.Items.AddRange(new object[] { Properties.Resources.FIELD_VALUE_YES, Properties.Resources.FIELD_VALUE_NO });
ListValueComboBox.SelectedIndex = ListValueComboBox.Items.IndexOf(ClassLibraryStandard.HelperMethods.ToBoolean(UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_USER_PREFERENCE_FLAG].ToString()) ? Properties.Resources.FIELD_VALUE_YES : Properties.Resources.FIELD_VALUE_NO);
break;
}
ListValueComboBox.Enter += PreferenceDescriptionEnter;
if (bClientOverride || bSystemOverride)
{
ListValueComboBox.Enabled = false;
}
if (ListValueComboBox.Enabled)
{
ListValueComboBox.TextChanged += UpdatePreferenceAttribute;
}
Controls.Add(ListValueComboBox);
}
void BuildValueTextBox()
{
TextBox ValueTextBox = new TextBox
{
Name = controlName,
Location = new System.Drawing.Point(134, axisY),
Text = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_USER_PREFERENCE_VALUE].ToString().Trim(),
Anchor = (((((AnchorStyles.Top | AnchorStyles.Bottom) | AnchorStyles.Left) | AnchorStyles.Right))),
BackColor = Constants.COLOR_DEFAULT,
ForeColor = (bClientOverride || bSystemOverride) ? System.Drawing.Color.DimGray : System.Drawing.Color.Black,
MaxLength = 1000,
RightToLeft = RightToLeft.No,
Size = new System.Drawing.Size(317, 20),
AccessibleDescription = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_PREFERENCE_DESCRIPTION].ToString().Trim(),
AccessibleDefaultActionDescription = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_USER_PREFERENCE_VALUE].ToString().Trim(),
AccessibleName = nvClientPreferenceName,
TabIndex = rowIndex
};
ValueTextBox.Enter += PreferenceDescriptionEnter;
if (bClientOverride || bSystemOverride)
{
ValueTextBox.Enabled = false;
}
if (ValueTextBox.Enabled)
{
ValueTextBox.Leave += UpdatePreferenceAttribute;
}
Controls.Add(ValueTextBox);
}
void BuildValueComboBox()
{
ClassLibraryFramework.ComboBoxEx ValueComboBox = new ClassLibraryFramework.ComboBoxEx
{
Name = controlName,
Location = new System.Drawing.Point(134, axisY - 1),
Anchor = (((((AnchorStyles.Top | AnchorStyles.Bottom) | AnchorStyles.Left) | AnchorStyles.Right))),
BackColor = Constants.COLOR_DEFAULT,
ForeColor = (bClientOverride || bSystemOverride) ? System.Drawing.Color.DimGray : System.Drawing.Color.Black,
FormattingEnabled = true,
RightToLeft = RightToLeft.No,
Size = new System.Drawing.Size(317, 21),
AccessibleDescription = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_PREFERENCE_DESCRIPTION].ToString().Trim(),
AccessibleDefaultActionDescription = UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_USER_PREFERENCE_VALUE].ToString().Trim(),
AccessibleName = nvClientPreferenceName,
TabIndex = rowIndex
};
ValueComboBox.Items.AddRange(new object[] { Properties.Resources.FIELD_VALUE_YES, Properties.Resources.FIELD_VALUE_NO });
ValueComboBox.SelectedIndex = ValueComboBox.Items.IndexOf(ClassLibraryStandard.HelperMethods.ToBoolean(UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_USER_PREFERENCE_FLAG].ToString()) ? Properties.Resources.FIELD_VALUE_YES : Properties.Resources.FIELD_VALUE_NO);
ValueComboBox.Enter += PreferenceDescriptionEnter;
if (bClientOverride || bSystemOverride)
{
ValueComboBox.Enabled = false;
}
if (ValueComboBox.Enabled)
{
ValueComboBox.TextChanged += UpdatePreferenceAttribute;
}
Controls.Add(ValueComboBox);
}
}
bool GroupHeaderRequired(int rowIndex)
{
if (UserPreferencesDataTable != null)
{
if (rowIndex == 0)
{
return(true);
}
else
{
return(UserPreferencesDataTable.Rows[rowIndex - 1][Constants.COLUMN_CLIENT_PREFERENCE_TYPE].ToString().Trim() != UserPreferencesDataTable.Rows[rowIndex][Constants.COLUMN_CLIENT_PREFERENCE_TYPE].ToString().Trim());
}
}
return(false);
}
}
private void SheetDataGridViewCellValueChanged(object sender, DataGridViewCellEventArgs e)
{
ExplorerForm.SheetDataGridViewCellValueChanged();
}
private static void DeleteSelectedRows(System.Collections.ArrayList keyArray = null)
{
ExplorerForm.DeleteSelectedRows(keyArray);
}
private static void ComparisonReset()
{
SetSpreadsheetChanges(true);
ExplorerForm.ResetExplorerForm();
}
internal static void ApplyPreferenceChange(System.Collections.Generic.Dictionary <int, NAVChangePreferencesModel> map)
{
if (map != null)
{
string nvClientPreferenceType = map[1].nvClientPreferenceType.Trim();
string nvClientPreferenceName = map[1].nvClientPreferenceName.Trim();
bool bPreference = map[1].bPreference;
switch (nvClientPreferenceType)
{
case Constants.DB_SLIDE_PANEL_TAB_VIEWS:
switch (nvClientPreferenceName)
{
case Constants.DB_HIDE_ABBREVIATIONS: break;
case Constants.DB_HIDE_EXPLORER: break;
case Constants.DB_OPEN_LAST_TAB: break;
default: ClientPreferenceNameError(); break;
}
break;
case Constants.DB_IMPORT_FILE_PERMISSIONS:
switch (nvClientPreferenceName)
{
case Constants.DB_ORDER_COLUMNS: break;
case Constants.DB_DELETE_ROWS: break;
case Constants.DB_EDIT_CELLS: break;
case Constants.DB_CREATE_ROWS: break;
case Constants.DB_OPEN_LAST_FILE: break;
case Constants.DB_OPEN_LAST_WORKSHEET: break;
default: ClientPreferenceNameError(); break;
}
break;
case Constants.DB_ABBREVIATION_TAB_PERMISSIONS:
switch (nvClientPreferenceName)
{
case Constants.DB_REPLACE_WORDS:
UserHelper.SetReplaceAllWords(bPreference);
ExplorerForm.SetComparisonReset(true);
break;
case Constants.DB_PERMIT_DEFAULTS:
UserHelper.SetReplaceDefaultWordsOnly(bPreference);
ExplorerForm.SetComparisonReset(true);
break;
case Constants.DB_PULL_ABBREVIATIONS:
UserHelper.SetPullAbbreviations(bPreference);
ExplorerForm.SetComparisonReset(true);
break;
case Constants.DB_DELETE_ABBREVIATIONS: break;
case Constants.DB_ADD_NEW_ABBREVIATIONS: break;
case Constants.DB_EDIT_ABBREVIATIONS: break;
default: ClientPreferenceNameError(); break;
}
break;
case Constants.DB_ERROR_LOG_PREFERENCES:
switch (nvClientPreferenceName)
{
case Constants.DB_LOG_ERRORS:
UserHelper.SetLogErrors(bPreference);
break;
case Constants.DB_LOG_ERRORS_TO_FILE: break; // TO DO: log4net - disabled (redundant?)
case Constants.DB_ERROR_LOG_FILE_LOCATION: break; // TO DO: log4net - disabled (redundant?)
case Constants.DB_ERROR_LOG_MAXIMUM_SIZE: break; // TO DO: log4net - disabled (redundant?)
case Constants.DB_ERROR_LOG_ARCHIVE_TOTAL: break; // TO DO: log4net - disabled (redundant?)
default: ClientPreferenceNameError(); break;
}
break;
case Constants.DB_DATA_CONNECTION_ATTRIBUTES:
switch (nvClientPreferenceName)
{
case Constants.DB_CLOUD_CONNECTION_STRING: break; // TO DO: return value in ConnectionHelper.cs - disabled (redundant?)
case Constants.DB_LOCAL_CONNECTION_STRING: break; // TO DO: return value in ConnectionHelper.cs - disabled (redundant?)
default: ClientPreferenceNameError(); break;
}
break;
case Constants.DB_USER_INTERFACE_THEMES:
switch (nvClientPreferenceName)
{
case Constants.DB_COLOUR_SCHEME: break; // TO DO: future imiplementation - disabled
case Constants.DB_INTERFACE_LANGUAGE: break; // TO DO: future imiplementation - disabled
case Constants.DB_APPLY_RTL_ORIENTATION: break; // TO DO: future imiplementation - disabled
default: ClientPreferenceNameError(); break;
}
break;
case Constants.DB_SEARCH_PREFERENCES:
switch (nvClientPreferenceName)
{
case Constants.DB_PULL_ABBREVIATIONS: break;
case Constants.DB_REMOVE_NOISE_CHARACTERS: break;
case Constants.DB_APPLY_CASE_INSENSITIVITY: break;
case Constants.DB_PAD_TEXT: break;
case Constants.DB_REVERSE_COMPARE: break;
case Constants.DB_MATCH_ABBREVIATIONS: break;
case Constants.DB_PHONETIC_FILTER: break;
case Constants.DB_WHOLE_WORD_MATCH: break;
case Constants.DB_PERCENTAGE_INTEREST: break;
case Constants.DB_MATCHING_ALGORITHM: break;
default: ClientPreferenceNameError(); break;
}
break;
default:
ClientPreferenceTypeError();
break;
}
void ClientPreferenceTypeError()
{
SetNotifyPreferenceChange(false);
MessageBox.Show(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_UPDATE_PREFERENCE, nvClientPreferenceName, nvClientPreferenceType), Properties.Resources.CAPTION_PREFERENCES_ERROR, MessageBoxButtons.OK, MessageBoxIcon.Error);
if (log != null)
{
log.Error(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_UPDATE_PREFERENCE, nvClientPreferenceName, nvClientPreferenceType));
}
}
void ClientPreferenceNameError()
{
MessageBox.Show(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_UPDATE_PREFERENCENAME, nvClientPreferenceName), Properties.Resources.CAPTION_PREFERENCES_ERROR, MessageBoxButtons.OK, MessageBoxIcon.Error);
if (log != null)
{
log.Error(string.Format(UserHelper.culture, Properties.Resources.NOTIFY_UPDATE_PREFERENCENAME, nvClientPreferenceName));
}
}
}
}
private void InitializePanels()
{
BackColor = Constants.COLOR_DEFAULT_BACKCOLOR;
SetNotifyPreferenceChange(false);
SetEnablePreferenceChange(true);
InitializeLeftPanelForm();
InitializeRightPanelForm();
initializeCaptions();
initializeToolTips();
LogHelper.TraceInitialisationComplete();
void NAVFormShownEventHandler(object sender, EventArgs e)
{
UpdateHelper.CheckForUpdates();
}
void initializeCaptions()
{
Text = ConnectionHelper.ApplicationName();
TABExplorer.Text = Properties.Resources.CAPTION_TAB_EXPLORER;
TABPreferences.Text = Properties.Resources.CAPTION_TAB_PREFERENCES;
TABAbbreviations.Text = Properties.Resources.CAPTION_TAB_ABBREVIATIONS;
LABELExplorer.Text = Properties.Resources.CAPTION_SIMILARITY;
LABELPreferences.Text = Properties.Resources.CAPTION_PREFERENCES;
LABELAbbreviations.Text = Properties.Resources.CAPTION_ABBREVIATIONS;
}
void initializeToolTips()
{
TABToolTips.SetToolTip(PanelSliderPictureBox, Properties.Resources.TOOLTIP_PANELSLIDERPICTUREBOX);
TABToolTips.SetToolTip(NewButton, Properties.Resources.TOOLTIP_NEWBUTTON);
TABToolTips.SetToolTip(DeleteButton, Properties.Resources.TOOLTIP_DELETEBUTTON);
nvWord.ToolTipText = Properties.Resources.TOOLTIP_WORDTEXT;
nvAbbreviation.ToolTipText = Properties.Resources.TOOLTIP_ABBREVIATIONTEXT;
nvAbbreviationDescription.ToolTipText = Properties.Resources.TOOLTIP_ABBREVIATIONDESCRIPTIONTEXT;
bAlwaysUse.ToolTipText = Properties.Resources.TOOLTIP_ALWAYSUSETEXT;
}
void InitializeLeftPanelForm()
{
NAVFormSplitContainer.BackColor = Constants.COLOR_DEFAULT_BACKCOLOR;
NAVFormSplitContainer.Panel2Collapsed = true;
NAVForm.Shown += new EventHandler(NAVFormShownEventHandler);
NAVForm.TopLevel = false;
NAVForm.FormBorderStyle = FormBorderStyle.None;
NAVForm.Parent = NAVFormSplitContainer.Panel1;
NAVForm.Dock = DockStyle.Fill;
NAVForm.Show();
}
void InitializeRightPanelForm()
{
Cursor = Cursors.WaitCursor;
InitializeAbbreviations();
InitializePreferences();
InitializeExplorer();
Cursor = Cursors.Default;
void InitializeAbbreviations()
{
AbbreviationsDataGridView.ReadOnly = !EditAbbreviations;
AbbreviationsDataGridView.AllowUserToAddRows = false;
AbbreviationsDataGridView.AllowUserToDeleteRows = false;
AbbreviationsDataGridView.AllowUserToOrderColumns = true;
AbbreviationsDataGridView.AllowUserToResizeColumns = false;
AbbreviationsDataGridView.AllowUserToResizeRows = false;
try
{
AbbreviationTypeComboBox.BackColor = Constants.COLOR_DEFAULT_BACKCOLOR;
AbbreviationTypeComboBox.DataSource = DataAccess.GetAbbreviationTypes();
AbbreviationTypeComboBox.DisplayMember = Constants.COLUMN_ABBREVIATION_TYPE;
AbbreviationTypeComboBox.SelectedIndexChanged += (object sender, EventArgs e) => GetAbbreviationDataGridView();
}
catch (System.Data.SqlClient.SqlException ex)
{
MessageBox.Show(Properties.Resources.NOTIFY_ABBREVIATION_FAIL, Properties.Resources.CAPTION_ABBREVIATIONS, MessageBoxButtons.OK, MessageBoxIcon.Error);
if (log != null)
{
log.Error(Properties.Resources.NOTIFY_ABBREVIATION_FAIL, ex);
}
}
NAVPanelFormTabControl.SelectedIndexChanged += TABPreferencesLeave;
AbbreviationsDataGridView.CellValueChanged += AbbreviationsCellValueChanged;
AbbreviationsDataGridView.RowValidating += AbbreviationsRowValidating;
AbbreviationsDataGridView.MouseDown += AbbreviationsDataGridViewMouseDownEvent;
AbbreviationsDataGridView.MouseUp += AbbreviationsMouseUp;
AbbreviationMenuItemDelete.Enabled = DeleteAbbreviations;
AbbreviationMenuItemNew.Enabled = AddNewAbbreviations;
DeleteButton.Enabled = DeleteAbbreviations;
NewButton.Enabled = AddNewAbbreviations;
using (ClassLibraryFramework.DrawingInteropServices.PauseDrawing(AbbreviationsDataGridView))
{
if (HideAbbreviations)
{
if (NAVPanelFormTabControl.TabPages.Contains(TABAbbreviations))
{
NAVPanelFormTabControl.TabPages.Remove(TABAbbreviations);
}
}
else
{
GetAbbreviationDataGridView();
}
if (HideExplorer)
{
if (NAVPanelFormTabControl.TabPages.Contains(TABExplorer))
{
NAVPanelFormTabControl.TabPages.Remove(TABExplorer);
}
}
}
}
void InitializeExplorer()
{
ExplorerForm explorerForm = new ExplorerForm()
{
TopLevel = false,
FormBorderStyle = FormBorderStyle.None,
Dock = DockStyle.Fill
};
ExplorerFormPanel.BackColor = Constants.COLOR_DEFAULT_WINDOW;
ExplorerFormPanel.Controls.Add(explorerForm);
explorerForm.Show();
}
void InitializePreferences()
{
PreferencesForm preferencesForm = new PreferencesForm
{
TopLevel = false,
FormBorderStyle = FormBorderStyle.None,
Dock = DockStyle.Fill
};
TABPreferences.BackColor = Constants.COLOR_DEFAULT_WINDOW;
PreferenceFormPanel.Controls.Add(preferencesForm);
preferencesForm.Show();
}
}
}