/// <summary>
/// Performs search action and return the new DataTable
/// </summary>
/// <param name="name">Search for a name</param>
/// <param name="category">Search by category</param>
/// <param name="expansion">Search by Expansion</param>
/// <returns>DataTable with search results</returns>
private ItemModels.ModelsDataTable selectData(string name, string category, string expansion)
{
name = name.ToLower().Trim();
var query = from
m
in
itemModels.Models
select
new { m.ID, m.Name, m.Category, m.Expansion, m.Preview };
if (name.Length > 0)
{
query = query.Where(m => m.Name.ToLower().Contains(name));
}
if (category.Length > 0 && category != "all")
{
query = query.Where(m => m.Category == category);
}
if (expansion.Length > 0 && expansion != "all")
{
query = query.Where(m => m.Expansion == expansion);
}
//Create a new table for bindings
ItemModels.ModelsDataTable models = new ItemModels.ModelsDataTable();
foreach (var row in query)
{
models.Rows.Add(row.ID, row.Name, row.Category, row.Expansion, row.Preview);
}
return(models);
}
/// <summary>
/// Searchbutton click event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void search_models(object sender, EventArgs e)
{
string model_name = this.model_name_textbox.Text;
string model_category = this.model_category_selectbox.SelectedValue.ToString();
string model_expansion = this.model_expansion_selectbox.SelectedValue.ToString();
ItemModels.ModelsDataTable models = this.selectData(model_name, model_category, model_expansion);
this.model_datagrid.DataSource = models;
}
/// <summary>
/// Performs search action and return the new DataTable
/// </summary>
/// <param name="name">Search for a name</param>
/// <param name="category">Search by category</param>
/// <param name="expansion">Search by Expansion</param>
/// <returns>DataTable with search results</returns>
private ItemModels.ModelsDataTable selectData(string name, string category, string expansion)
{
name = name.ToLower().Trim();
var query = from
m
in
itemModels.Models
select
new { m.ID, m.Name, m.Category, m.Expansion, m.Preview };
if (name.Length > 0)
{
query = query.Where(m => m.Name.ToLower().Contains(name));
}
if (category.Length > 0 && category != "all")
{
query = query.Where(m => m.Category == category);
}
if (expansion.Length > 0 && expansion != "all")
{
query = query.Where(m => m.Expansion == expansion);
}
//Create a new table for bindings
ItemModels.ModelsDataTable models = new ItemModels.ModelsDataTable();
foreach (var row in query)
{
models.Rows.Add(row.ID, row.Name, row.Category, row.Expansion, row.Preview);
}
return models;
}
