public SearchString(string str) { str = str ?? string.Empty; str = str.Trim(); _OriginalString = str.Trim(); TextSearch = _OriginalString; var splitted = str.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); Filters = splitted .Select(t => t.Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries)) .Where(kv => kv.Length == 2) .Select(kv => new KeyValuePair <string, string>(kv[0].ToLowerInvariant(), kv[1])) .ToDictionary(o => o.Key, o => o.Value); foreach (var filter in splitted) { if (filter.Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries).Length == 2) { TextSearch = TextSearch.Replace(filter, string.Empty); } } TextSearch = TextSearch.Trim(); }
void DataCommand(object parameter) { String que = "SELECT * FROM " + SelectedTableName.Name; if (SelectedAttribute.Name.Length > 0 && TextSearch.Length > 0) { que += " WHERE " + SelectedAttribute.Name + " LIKE \'%" + TextSearch.Replace(",", ".") + "%\' "; } DatabaseModel DataModel = new DatabaseModel(); try { if (SelectedTableName.Name == "Bron") { IEnumerable <Bron> Table = DataModel.Query <Bron>(sql_query: que); ShowData DataWindow = new ShowData(Table, 1); DataWindow.Show(); } else if (SelectedTableName.Name == "Amunicja") { IEnumerable <Amunicja> Table = DataModel.Query <Amunicja>(sql_query: que); ShowData DataWindow = new ShowData(Table, 2); DataWindow.Show(); } else if (SelectedTableName.Name == "Hurtowe") { IEnumerable <Hurtowe> Table = DataModel.Query <Hurtowe>(sql_query: que); ShowData DataWindow = new ShowData(Table, 3); DataWindow.Show(); } else if (SelectedTableName.Name == "Detaliczne") { IEnumerable <Detaliczne> Table = DataModel.Query <Detaliczne>(sql_query: que); ShowData DataWindow = new ShowData(Table, 4); DataWindow.Show(); } else if (SelectedTableName.Name == "Dostawa") { IEnumerable <Dostawa> Table = DataModel.Query <Dostawa>(sql_query: que); ShowData DataWindow = new ShowData(Table, 5); DataWindow.Show(); } else if (SelectedTableName.Name == "Kategoria") { IEnumerable <Kategoria> Table = DataModel.Query <Kategoria>(sql_query: que); ShowData DataWindow = new ShowData(Table, 6); DataWindow.Show(); } else if (SelectedTableName.Name == "Material") { IEnumerable <Material> Table = DataModel.Query <Material>(sql_query: que); ShowData DataWindow = new ShowData(Table, 7); DataWindow.Show(); } else if (SelectedTableName.Name == "Pracownik") { IEnumerable <Pracownik> Table = DataModel.Query <Pracownik>(sql_query: que); ShowData DataWindow = new ShowData(Table, 8); DataWindow.Show(); } else if (SelectedTableName.Name == "Produkcja") { IEnumerable <Produkcja> Table = DataModel.Query <Produkcja>(sql_query: que); ShowData DataWindow = new ShowData(Table, 9); DataWindow.Show(); } else if (SelectedTableName.Name == "Zamowienie") { IEnumerable <Zamowienie> Table = DataModel.Query <Zamowienie>(sql_query: que); ShowData DataWindow = new ShowData(Table, 10); DataWindow.Show(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }