/// <summary>
///loads a setting from the database
/// </summary>
/// <param name="sender"></param>
public void loadSetting(object sender, Control BaseObject = null)
{
try
{
m_inloadSetting++;
/// set the value of the baseobject if necessary
if (sender.GetType() == typeof(CheckBox))
{
var cbSender = (CheckBox)sender;
var Parts = splitTag(cbSender.Tag);
if (Parts != null)
{
m_currentLoadingObject = cbSender;
cbSender.Checked = m_DBCon.getIniValue <Boolean>(m_InitGroup, Parts.IDString, Parts.DefaultValue, false, true);
m_currentLoadingObject = null;
}
}
else if ((sender.GetType() == typeof(ComboBox)) || (sender.GetType() == typeof(ComboBoxInt32)))
{
var cbSender = (ComboBox)sender;
var TagParts = splitTag(cbSender.Tag);
MethodInfo GenericMethodInfo;
Object ItemToSet = null;
Object ValueToSet = null;
if (TagParts != null)
{
// this is one of ours
m_currentLoadingObject = cbSender;
if ((cbSender.ValueMember != null) && (!String.IsNullOrEmpty(cbSender.ValueMember)))
{
// it's working with a ValueMember -> translate "Value" to "Item" and set ".SelectedItem"
var Props = cbSender.Items[0].GetType().GetProperties();
System.Reflection.PropertyInfo FoundPropertyItem = null;
Type FoundColumnType = null;
if ((cbSender.DataSource == null) || (!cbSender.DataSource.GetType().Equals(typeof(System.Data.DataTable))))
{
foreach (var PropertyItem in Props)
{
if (PropertyItem.Name == cbSender.ValueMember)
{
FoundPropertyItem = PropertyItem;
FoundColumnType = FoundPropertyItem.GetMethod.ReturnType;
break;
}
}
}
else
{
FoundColumnType = ((DataTable)cbSender.DataSource).Columns[cbSender.ValueMember].DataType;
}
if (FoundColumnType != null)
{
GenericMethodInfo = typeof(DBConnector).GetMethod("getIniValue", new Type[] { typeof(String), typeof(String), typeof(String), typeof(Boolean), typeof(Boolean) });
GenericMethodInfo = GenericMethodInfo.MakeGenericMethod(FoundColumnType);
ValueToSet = GenericMethodInfo.Invoke(m_DBCon, new object[] { m_InitGroup, TagParts.IDString, TagParts.DefaultValue, false, true });
}
if (FoundPropertyItem != null)
{
foreach (var currentComboxItem in cbSender.Items)
{
if (Convert.ChangeType(currentComboxItem.GetType().GetProperty(FoundPropertyItem.Name).GetValue(currentComboxItem, null), FoundColumnType).Equals(Convert.ChangeType(ValueToSet, FoundColumnType)))
{
ItemToSet = currentComboxItem;
break;
}
}
if (ItemToSet != null)
{
cbSender.SelectedItem = ItemToSet;
}
}
else
{
foreach (DataRowView currentDataRow in cbSender.Items)
{
if (Convert.ChangeType(currentDataRow[cbSender.ValueMember], FoundColumnType).Equals(Convert.ChangeType(ValueToSet, FoundColumnType)))
{
ItemToSet = currentDataRow;
break;
}
}
//foreach (DataRow currentDataRow in ((DataTable)cbSender.DataSource).Rows)
//{
// if(Convert.ChangeType(currentDataRow[cbSender.ValueMember], FoundColumnType).Equals(Convert.ChangeType(ValueToSet,FoundColumnType)))
// {
// ItemToSet = currentDataRow;
// break;
// }
//}
if (ItemToSet != null)
{
cbSender.SelectedItem = ItemToSet;
}
}
}
else
{
cbSender.Text = m_DBCon.getIniValue <String>(m_InitGroup, TagParts.IDString, TagParts.DefaultValue, false, true);
}
m_currentLoadingObject = null;
}
}
else if ((sender.GetType() == typeof(TextBox)) || (sender.GetType() == typeof(TextBoxInt32)) || (sender.GetType() == typeof(TextBoxDouble)))
{
var cbSender = (TextBox)sender;
var Parts = splitTag(cbSender.Tag);
if (Parts != null)
{
m_currentLoadingObject = cbSender;
if (Parts.DefaultValue.Equals("EMPTY"))
{
cbSender.Text = m_DBCon.getIniValue <String>(m_InitGroup, Parts.IDString, "");
}
else
{
cbSender.Text = m_DBCon.getIniValue <String>(m_InitGroup, Parts.IDString, Parts.DefaultValue, String.IsNullOrWhiteSpace(Parts.DefaultValue), true);
}
m_currentLoadingObject = null;
}
}
else if (sender.GetType() == typeof(NumericUpDown))
{
var cbSender = (NumericUpDown)sender;
var Parts = splitTag(cbSender.Tag);
if (Parts != null)
{
m_currentLoadingObject = cbSender;
cbSender.Text = m_DBCon.getIniValue <String>(m_InitGroup, Parts.IDString, Parts.DefaultValue, false, true);
m_currentLoadingObject = null;
}
}
else if (sender.GetType() == typeof(RadioButton))
{
// radio button will be set due to its parent container
var cbSender = (RadioButton)sender;
if (cbSender.Parent != BaseObject)
{
// avoid recursion
loadSetting(cbSender.Parent);
}
}
else if (sender.GetType() == typeof(GroupBox))
{
// a container will handle it's radiobuttons
var cbSender = (GroupBox)sender;
var Parts = splitTag(cbSender.Tag);
if (Parts != null)
{
RadioButton firstRadioButton = null;
Boolean Found = false;
String Value;
m_currentLoadingObject = cbSender;
Value = m_DBCon.getIniValue <String>(m_InitGroup, Parts.IDString, Parts.DefaultValue, false, true);
m_currentLoadingObject = null;
// Search all radionbuttons in the combobox and
// check this one with the <Value> tag. Or if not found
// set the fist found RadioButton checked
foreach (Control SubControl in cbSender.Controls)
{
if (SubControl.GetType() == typeof(RadioButton))
{
RadioButton rbControl = (RadioButton)SubControl;
if (firstRadioButton == null)
{
firstRadioButton = rbControl;
}
if (rbControl.Tag.Equals(Value))
{
rbControl.Checked = true;
Found = true;
}
else
{
rbControl.Checked = false;
}
}
}
if ((!Found) && (firstRadioButton != null))
{
firstRadioButton.Checked = true;
}
}
}
else if (sender.GetType() == typeof(DataGridViewExt))
{
var cbSender = (DataGridViewExt)sender;
var Parts = splitTag(cbSender.Tag);
System.ComponentModel.ListSortDirection Order;
String OrderStr = "";
// sortorder changed
if (Parts != null)
{
var columnName = m_DBCon.getIniValue <String>(m_InitGroup, Parts.IDString + "_SortColumn", Parts.DefaultValue, false, true);
var Column = cbSender.Columns[columnName];
OrderStr = m_DBCon.getIniValue <String>(m_InitGroup, Parts.IDString + "_SortOrder", SortOrder.Ascending.ToString(), false, true);
if (OrderStr.Equals(SortOrder.Descending.ToString(), StringComparison.InvariantCultureIgnoreCase))
{
Order = System.ComponentModel.ListSortDirection.Descending;
}
else
{
Order = System.ComponentModel.ListSortDirection.Ascending;
}
if (Column != null)
{
m_currentLoadingObject = cbSender;
cbSender.Sort(Column, Order);
m_currentLoadingObject = null;
}
String[] VisibilityStrings = null;
VisibilityStrings = m_DBCon.getIniValue(m_InitGroup, Parts.IDString + "_ColumnSettings", "").Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
Int32 ColumnIndex = 0;
cbSender.SuspendLayout();
foreach (DataGridViewColumn currentColumn in cbSender.Columns)
{
if (VisibilityStrings.GetUpperBound(0) >= ColumnIndex)
{
String[] ViParts = VisibilityStrings[ColumnIndex].Split(new char[] { '/' });
if (ViParts.GetUpperBound(0) == 5)
{
try
{
currentColumn.DisplayIndex = Int32.Parse(ViParts[0]);
currentColumn.Visible = Boolean.Parse(ViParts[1]);
currentColumn.AutoSizeMode = (DataGridViewAutoSizeColumnMode)Enum.Parse(typeof(DataGridViewAutoSizeColumnMode), (String)ViParts[2]);
switch (currentColumn.AutoSizeMode)
{
case DataGridViewAutoSizeColumnMode.Fill:
currentColumn.FillWeight = Single.Parse(ViParts[4], System.Globalization.NumberStyles.AllowDecimalPoint, System.Globalization.CultureInfo.InvariantCulture.NumberFormat);
break;
default:
currentColumn.Width = Int32.Parse(ViParts[3]);
break;
}
currentColumn.MinimumWidth = Int32.Parse(ViParts[5]);
}
catch (Exception)
{
}
}
}
if (currentColumn.DefaultHeaderCellType.BaseType.Equals(typeof(DataGridViewAutoFilter.DataGridViewAutoFilterHeaderCell)))
{
((DataGridViewAutoFilter.DataGridViewAutoFilterHeaderCell)currentColumn.HeaderCell).ColumnFilterString = m_DBCon.getIniValue(m_InitGroup, string.Format("{0}_{1}_Filter", Parts.IDString, currentColumn.Name), "");
}
ColumnIndex++;
}
cbSender.ResumeLayout();
}
}
else if (sender.GetType() == typeof(SplitContainer))
{
// got some problems with this setting so
// i deactivate it for the moment
var cbSender = (SplitContainer)sender;
var Parts = splitTag(cbSender.Tag);
Int32 SplitterRatio;
if (Parts != null)
{
SplitterRatio = m_DBCon.getIniValue <Int32>(m_InitGroup, Parts.IDString, Parts.DefaultValue, false, true);
if (cbSender.Orientation == Orientation.Vertical)
{
SplitterRatio = (Int32)Math.Round(((Single)(SplitterRatio * cbSender.Width)) / 100 - (cbSender.SplitterWidth / 2), 0);
}
else
{
SplitterRatio = (Int32)Math.Round(((Single)(SplitterRatio * cbSender.Height)) / 100 - (cbSender.SplitterWidth / 2), 0);
}
if (SplitterRatio > 0)
{
m_currentLoadingObject = cbSender;
cbSender.SplitterDistance = SplitterRatio;
m_currentLoadingObject = null;
}
}
}
m_inloadSetting--;
}
catch (Exception ex)
{
m_inloadSetting--;
m_currentLoadingObject = null;
CErr.processError(ex, "Error in loadSetting");
}
}
/// <summary>
/// saves a setting to the database
/// </summary>
/// <param name="sender"></param>
public Boolean saveSetting(object sender, Object Param1 = null)
{
Boolean retValue = false;
m_SavingLevel += 1;
try
{
// delete cache if needed
var cPartsIdString = (splitTag(((Control)sender).Tag))?.IDString;
if (!String.IsNullOrEmpty(cPartsIdString))
{
m_SettingsCache.Remove(m_InitGroup + "|" + cPartsIdString);
}
}
catch (Exception)
{
}
try
{
if ((m_inloadAllSettings == 0) && (m_currentLoadingObject != sender))
{
if (sender.GetType() == typeof(CheckBox))
{
var cbSender = (CheckBox)sender;
var Parts = splitTag(cbSender.Tag);
if (Parts != null)
{
retValue = m_DBCon.setIniValue(m_InitGroup, Parts.IDString, cbSender.Checked.ToString());
}
}
else if ((sender.GetType() == typeof(ComboBox)) || (sender.GetType() == typeof(ComboBoxInt32)))
{
var cbSender = (ComboBox)sender;
var Parts = splitTag(cbSender.Tag);
Object SelectComboBoxValue = null;
if (Parts != null)
{
if ((cbSender.ValueMember != null) && (!String.IsNullOrEmpty(cbSender.ValueMember)))
{
// it's working with a ValueMember -> translate "Value" to "Item" and set ".SelectedItem"
var Props = cbSender.Items[0].GetType().GetProperties();
System.Reflection.PropertyInfo FoundPropertyItem = null;
Type FoundColumnType = null;
if ((cbSender.DataSource == null) || (!cbSender.DataSource.GetType().Equals(typeof(System.Data.DataTable))))
{
foreach (var PropertyItem in Props)
{
if (PropertyItem.Name == cbSender.ValueMember)
{
FoundPropertyItem = PropertyItem;
FoundColumnType = FoundPropertyItem.GetMethod.ReturnType;
break;
}
}
SelectComboBoxValue = cbSender.SelectedItem.GetType().GetProperty(FoundPropertyItem.Name).GetValue(cbSender.SelectedItem, null);
}
else
{
FoundColumnType = ((DataTable)cbSender.DataSource).Columns[cbSender.ValueMember].DataType;
SelectComboBoxValue = ((DataRowView)cbSender.SelectedItem)[cbSender.ValueMember];
}
retValue = m_DBCon.setIniValue(m_InitGroup, Parts.IDString, Convert.ChangeType(SelectComboBoxValue, FoundColumnType).ToString());
}
else
{
retValue = m_DBCon.setIniValue(m_InitGroup, Parts.IDString, cbSender.Text);
}
}
//if (cbSender.ValueMember != null)
// retValue = m_DBCon.setIniValue(m_InitGroup, parts.IDString, cbSender.SelectedValue.ToString());
//else
// retValue = m_DBCon.setIniValue(m_InitGroup, parts.IDString, cbSender.Text);
}
else if ((sender.GetType() == typeof(TextBox)) || (sender.GetType() == typeof(TextBoxInt32)) || (sender.GetType() == typeof(TextBoxDouble)))
{
var cbSender = (TextBox)sender;
var Parts = splitTag(cbSender.Tag);
if (Parts != null)
{
retValue = m_DBCon.setIniValue(m_InitGroup, Parts.IDString, cbSender.Text);
}
}
else if (sender.GetType() == typeof(NumericUpDown))
{
var cbSender = (NumericUpDown)sender;
var Parts = splitTag(cbSender.Tag);
if (Parts != null)
{
retValue = m_DBCon.setIniValue(m_InitGroup, Parts.IDString, cbSender.Value.ToString());
}
}
else if (sender.GetType() == typeof(RadioButton))
{
// radio button will be set due to its parent container
var cbSender = (RadioButton)sender;
// avoid double saving (one is activated, another is deactivated)
if (cbSender.Checked)
{
retValue = saveSetting(cbSender.Parent);
}
}
else if (sender.GetType() == typeof(GroupBox))
{
// a container will handle it's radiobuttons
var cbSender = (GroupBox)sender;
var Parts = splitTag(cbSender.Tag);
if (Parts != null)
{
Boolean Found = false;
// Search all radionbuttons in the combobox and
// check this one with the <Value> tag. Or if not found
// set the fist found RadioButton checked
foreach (Control SubControl in cbSender.Controls)
{
if (SubControl.GetType() == typeof(RadioButton))
{
RadioButton rbControl = (RadioButton)SubControl;
if (rbControl.Checked)
{
retValue = m_DBCon.setIniValue(m_InitGroup, Parts.IDString, rbControl.Tag.ToString());
Found = true;
break;
}
}
}
if (!Found)
{
retValue = m_DBCon.setIniValue(m_InitGroup, Parts.IDString, Parts.DefaultValue);
}
}
}
else if (sender.GetType() == typeof(DataGridViewExt))
{
var cbSender = (DataGridViewExt)sender;
var Parts = splitTag(cbSender.Tag);
if (Parts != null)
{
if ((Param1 != null) && (Param1.GetType() == typeof(DataGridViewExt.SortedEventArgs)))
{
var SortEA = (DataGridViewExt.SortedEventArgs)Param1;
// sortorder changed
retValue = m_DBCon.setIniValue(m_InitGroup, Parts.IDString + "_SortColumn", SortEA.SortColumn.Index.ToString());
retValue |= m_DBCon.setIniValue(m_InitGroup, Parts.IDString + "_SortOrder", SortEA.SortOrder.ToString());
}
StringBuilder SaveString = new StringBuilder();
foreach (DataGridViewColumn currentColumn in cbSender.Columns)
{
SaveString.Append(String.Format("{0}/{1}/{2}/{3}/{4}/{5};", currentColumn.DisplayIndex.ToString(),
currentColumn.Visible.ToString(),
currentColumn.AutoSizeMode.ToString(),
currentColumn.Width.ToString(),
currentColumn.FillWeight.ToString().Replace(",", "."),
currentColumn.MinimumWidth.ToString()));
if (currentColumn.DefaultHeaderCellType.BaseType.Equals(typeof(DataGridViewAutoFilter.DataGridViewAutoFilterHeaderCell)))
{
m_DBCon.setIniValue(m_InitGroup, string.Format("{0}_{1}_Filter", Parts.IDString, currentColumn.Name), ((DataGridViewAutoFilter.DataGridViewAutoFilterHeaderCell)currentColumn.HeaderCell).ColumnFilterString);
}
}
m_DBCon.setIniValue(m_InitGroup, Parts.IDString + "_ColumnSettings", SaveString.ToString());
}
}
else if (sender.GetType().BaseType == typeof(DataGridViewAutoFilter.DataGridViewAutoFilterHeaderCell))
{
var cbSender = (DataGridViewAutoFilter.DataGridViewAutoFilterHeaderCell)sender;
var cbGrid = (DataGridViewExt)cbSender.DataGridView;
var Parts = splitTag(cbGrid.Tag);
if (Parts != null)
{
m_DBCon.setIniValue(m_InitGroup, string.Format("{0}_{1}_Filter", Parts.IDString, cbSender.OwningColumn.Name), cbSender.ColumnFilterString);
}
}
else if (sender.GetType() == typeof(SplitContainer))
{
var cbSender = (SplitContainer)sender;
var Parts = splitTag(cbSender.Tag);
Int32 SplitterRatio;
if (Parts != null)
{
if (cbSender.Orientation == Orientation.Vertical)
{
SplitterRatio = (Int32)Math.Round(((Single)(cbSender.SplitterDistance + (cbSender.SplitterWidth / 2)) * 100 / ((Single)cbSender.Width)), 0);
}
else
{
SplitterRatio = (Int32)Math.Round(((Single)(cbSender.SplitterDistance + (cbSender.SplitterWidth / 2)) * 100 / ((Single)cbSender.Height)), 0);
}
if (SplitterRatio > 0)
{
retValue = m_DBCon.setIniValue(m_InitGroup, Parts.IDString, SplitterRatio.ToString());
}
}
}
}
m_SavingLevel -= 1;
}
catch (Exception ex)
{
m_SavingLevel -= 1;
CErr.processError(ex, "Error in saveSetting");
}
if (retValue && (m_SavingLevel == 0))
{
DataSavedEvent.Raise(this, new EventArgs());
}
return(retValue);
}