/// <summary>
/// Setzt und prüft ob in eine MetroTextBox ein gültiges Feldtrennzeichen (gibt TRUE bei korrektem Zeichen zurück)
/// </summary>
public bool Set_Seperator(IWin32Window owner, ref AdvancedComboBox aComboBox)
{
bool correct = false;
if (aComboBox.Text.Length != 0)
{
if (aComboBox.Text == "{Leerzeichen}")
{
Separator = ' ';
correct = true;
}
else if (aComboBox.Text == "{Tabulator}")
{
Separator = '\t';
correct = true;
}
else
{
if (aComboBox.Text.Length == 1)
{
Separator = Convert.ToChar(aComboBox.Text);
correct = true;
}
else
{
aComboBox.Text = aComboBox.Text.Substring(0, 1);
Separator = Convert.ToChar(aComboBox.Text);
correct = true;
}
}
}
return(correct);
}
/// <summary>
/// Füllt die ComboBoxen Autor, Verlag und Genre
/// </summary>
public void FillComboBoxes(ref AdvancedComboBox cbAuthor, ref AdvancedComboBox cbPublisher, ref AdvancedComboBox cbGenre)
{
authorHelper.FillCombobox(ref cbAuthor, -1);
publisherHelper.FillCombobox(ref cbPublisher, -1);
genreHelper.FillCombobox(ref cbGenre, -1);
if (cbAuthor.Text == "")
{
cbAuthor.Text = "Autor";
}
if (cbPublisher.Text == "")
{
cbPublisher.Text = "Verlag";
}
if (cbGenre.Text == "")
{
cbGenre.Text = "Genre";
}
}
/// <summary>
/// fills a combobox with all the condition data
/// </summary>
/// <param name="cb"></param>
/// <param name="value"></param>
public void FillCombobox(ref AdvancedComboBox cb, object value)
{
c.FillCombobox(ref cb, value, ref table);
}
private void BackgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
try
{
BeginInvoke((Action) delegate()
{
groupMain.Enabled = false;
groupList.Enabled = false;
spinnerGridView.Visible = true;
spinnerAttributes.Visible = true;
cbAuthor.DataSource = null;
this.cbGenre.DataSource = null;
cbPublisher.DataSource = null;
gridOverview.Visible = false;
if (cbAuthor.AutoCompleteSource != AutoCompleteSource.None)
{
cbAuthor.AutoCompleteSource = AutoCompleteSource.None;
}
if (cbPublisher.AutoCompleteSource != AutoCompleteSource.None)
{
cbPublisher.AutoCompleteSource = AutoCompleteSource.None;
}
if (this.cbGenre.AutoCompleteSource != AutoCompleteSource.None)
{
this.cbGenre.AutoCompleteSource = AutoCompleteSource.None;
}
cbAuthor.Visible = false;
this.cbGenre.Visible = false;
cbPublisher.Visible = false;
});
MetroGrid mgBuSu = new MetroGrid();
AdvancedComboBox cbAutor = new AdvancedComboBox();
AdvancedComboBox cbVerlag = new AdvancedComboBox();
AdvancedComboBox cbGenre = new AdvancedComboBox();
List <int> RedBlack = new List <int>();
List <int> YellowBlack = new List <int>();
List <int> LimeBlack = new List <int>();
List <int> BlackWhite = new List <int>();
overviewHelper = new OverviewHelper();
overviewHelper.FillComboBoxes(ref cbAutor, ref cbVerlag, ref cbGenre);
overviewHelper.FillGrid(ref mgBuSu);
var dtBuSu = mgBuSu.DataSource;
while (loaded == false)
{
}
BeginInvoke((Action) delegate
{
gridOverview.DataSource = null;
gridOverview.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
gridOverview.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing;
gridOverview.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
gridOverview.AllowUserToResizeColumns = true;
gridOverview.RowHeadersVisible = false;
gridOverview.DataSource = dtBuSu;
gridOverview.Columns["Kunden ID"].Visible = false;
gridOverview.Columns["Leihnummer"].Visible = false;
gridOverview.Columns["Kunden ID"].Visible = false;
gridOverview.Columns["Vorname"].Visible = false;
gridOverview.Columns["Nachname"].Visible = false;
gridOverview.Columns["Klasse"].Visible = false;
searchActivated = false;
cbAuthor.DataSource = cbAutor.DataSource;
cbAuthor.ValueMember = "au_id";
cbAuthor.DisplayMember = "au_autor";
cbAuthor.SelectedIndex = -1;
cbPublisher.DataSource = cbVerlag.DataSource;
cbPublisher.ValueMember = "ver_id";
cbPublisher.DisplayMember = "ver_name";
cbPublisher.SelectedIndex = -1;
this.cbGenre.DataSource = cbGenre.DataSource;
this.cbGenre.ValueMember = "ger_id";
this.cbGenre.DisplayMember = "ger_name";
this.cbGenre.SelectedIndex = -1;
if (cbAuthor.Text == "")
{
cbAuthor.Text = "Autor";
}
if (cbPublisher.Text == "")
{
cbPublisher.Text = "Verlag";
}
if (this.cbGenre.Text == "")
{
this.cbGenre.Text = "Genre";
}
string rawFilter = string.Format("Convert([ExemplarID], System.String) LIKE '{0}%' AND ISBN LIKE '{1}%' AND Titel LIKE '%{2}%' AND Verlag LIKE '%{3}%' AND Genre LIKE '%{4}%' AND Autor LIKE '%{5}%'", "", "", "", "", "", "");
(gridOverview.DataSource as DataTable).DefaultView.RowFilter = rawFilter;
addRowFilter();
gridOverview.Refresh();
searchActivated = true;
ShowKundeDetails();
spinnerGridView.Visible = false;
spinnerAttributes.Visible = false;
gridOverview.Visible = true;
cbAuthor.Visible = true;
this.cbGenre.Visible = true;
cbPublisher.Visible = true;
groupMain.Enabled = true;
groupList.Enabled = true;
});
}
catch
{
try
{
BeginInvoke((Action) delegate
{
spinnerGridView.Visible = false;
spinnerAttributes.Visible = false;
gridOverview.Visible = true;
cbAuthor.Visible = true;
cbGenre.Visible = true;
cbPublisher.Visible = true;
MetroFramework.MetroMessageBox.Show(this, "Fehler beim Laden der Daten.", "Fehler", MessageBoxButtons.OK, MessageBoxIcon.Error);
});
}
catch
{
}
}
}
