protected override void Innit()
{
HiddenColumns.Add("ItemId");
}
protected override void Innit()
{
HiddenColumns.Add("CabinetTypeId");
}
protected override void Innit()
{
HiddenColumns.Add("TransactionsId");
HiddenColumns.Add("UserId");
HiddenColumns.Add("ItemId");
}
public void Load(string file = "Config\\DBTableEditorConfig.xml")
{
if (!Directory.Exists("Config"))
{
Directory.CreateDirectory("Config");
}
if (!File.Exists(file))
{
XmlTextWriter xw = new XmlTextWriter(File.Create(file), Encoding.UTF8);
xw.WriteStartDocument();
xw.WriteWhitespace("\n");
xw.WriteStartElement("DBTableEditorConfig");
xw.WriteWhitespace("\n\n");
xw.WriteFullEndElement();
xw.WriteEndDocument();
xw.Close();
return;
}
XmlTextReader xr = new XmlTextReader(file);
while (xr.Read())
{
if (xr.NodeType == XmlNodeType.Element)
{
if (xr.Name.Equals("FreezeKeyColumns"))
{
// Simple boolean element, read the value that follows and set property.
xr.Read();
if (xr.Value.Equals("True"))
{
FreezeKeyColumns = true;
}
else
{
FreezeKeyColumns = false;
}
}
else if (xr.Name.Equals("UseComboBoxes"))
{
// Simple boolean element, read the value that follows and set property.
xr.Read();
if (xr.Value.Equals("True"))
{
UseComboBoxes = true;
}
else
{
UseComboBoxes = false;
}
}
else if (xr.Name.Equals("ShowAllColumns"))
{
// Simple boolean element, read the value that follows and set property.
xr.Read();
if (xr.Value.Equals("True"))
{
ShowAllColumns = true;
}
else
{
ShowAllColumns = false;
}
}
else if (xr.Name.Equals("HiddenColumns"))
{
// Read until we hit the ending element
while (xr.Read())
{
if (xr.NodeType == XmlNodeType.EndElement && xr.Name.Equals("HiddenColumns"))
{
break;
}
// Skip all white space and other excess reads.
if (!xr.Name.Equals("Entry"))
{
continue;
}
// Save whether the current element is empty or not.
bool elementempty = xr.IsEmptyElement;
// Move to and pick up the key name from the elements attributes.
xr.MoveToNextAttribute();
string key = xr.Value;
List <string> columns = new List <string>();
// We have a list of columns, add them to the list.
if (!elementempty)
{
while (xr.Read())
{
if (xr.NodeType == XmlNodeType.EndElement && xr.Name.Equals("Entry"))
{
break;
}
if (xr.NodeType != XmlNodeType.Element || !xr.Name.Equals("Value"))
{
continue;
}
// Move to column name and add it to the list.
xr.Read();
columns.Add(xr.Value);
}
}
HiddenColumns.Add(new KeyValuePair <string, List <string> >(key, columns));
}
}
else if (xr.Name.Equals("ImportDirectory"))
{
// Unused string.
}
else if (xr.Name.Equals("ExportDirectory"))
{
// Unused string.
}
else if (xr.Name.Equals("ShowFilters"))
{
// Simple boolean element, read the value that follows and set property.
xr.Read();
if (xr.Value.Equals("True"))
{
ShowFilters = true;
}
else
{
ShowFilters = false;
}
}
else if (xr.Name.Equals("Filters"))
{
// Read until we hit the ending element
while (xr.Read())
{
if (xr.NodeType == XmlNodeType.EndElement && xr.Name.Equals("Filters"))
{
break;
}
// Skip all white space and other excess reads.
if (!xr.Name.Equals("Entry"))
{
continue;
}
// Save whether the current element is empty or not.
bool elementempty = xr.IsEmptyElement;
// Move to and pick up the key name from the elements attributes.
xr.MoveToNextAttribute();
string key = xr.Value;
List <DBFilter> loadedfilters = new List <DBFilter>();
// We have a list of columns, add them to the list.
if (!elementempty)
{
while (xr.Read())
{
if (xr.NodeType == XmlNodeType.EndElement && xr.Name.Equals("Entry"))
{
break;
}
if (xr.NodeType != XmlNodeType.Element || !xr.Name.Equals("Value"))
{
continue;
}
DBFilter dbf = new DBFilter();
// Read through and add all filters for this table.
while (xr.Read())
{
if (xr.NodeType == XmlNodeType.EndElement && xr.Name.Equals("Value"))
{
break;
}
if (xr.NodeType != XmlNodeType.Element)
{
continue;
}
if (xr.Name.Equals("IsActive"))
{
xr.Read();
if (xr.Value.Equals("True"))
{
dbf.IsActive = true;
}
else
{
dbf.IsActive = false;
}
}
else if (xr.Name.Equals("Name"))
{
xr.Read();
dbf.Name = xr.Value;
}
else if (xr.Name.Equals("ApplyToColumn"))
{
xr.Read();
dbf.ApplyToColumn = xr.Value;
}
else if (xr.Name.Equals("FilterValue"))
{
xr.Read();
dbf.FilterValue = xr.Value;
}
else if (xr.Name.Equals("MatchMode"))
{
xr.Read();
switch (xr.Value)
{
case "Exact":
dbf.MatchMode = MatchType.Exact;
break;
case "Partial":
dbf.MatchMode = MatchType.Partial;
break;
case "Regex":
dbf.MatchMode = MatchType.Regex;
break;
}
}
}
loadedfilters.Add(dbf);
}
}
Filters.Add(new KeyValuePair <string, List <DBFilter> >(key, loadedfilters));
}
}
}
}
xr.Close();
}
private void SelectAll_Click(object sender, RoutedEventArgs e)
{
HiddenColumns.SelectAll();
}
protected override void Innit()
{
HiddenColumns.Add("UserId");
HiddenColumns.Add("CabinetTypeId");
HiddenColumns.Add("PermissionId");
}
protected override void Innit()
{
HiddenColumns.Add("ProviderId");
}
