private void SeriesFieldChanged(object sender, EventArgs e)
{
Model.BlockSeries series = cbSeries.Items.Count == 0 ? DataAccess.SelectAll <Model.BlockSeries>().FirstOrDefault() : cbSeries.SelectedItem as Model.BlockSeries;
if (series != null)
{
cbGenre.SelectedItem = series.GenreId;
}
__HandleSearchChanged();
}
private void GenreFieldChanged(object sender, EventArgs e)
{
Genre genre = cbGenre.Items.Count == 0 ? DataAccess.SelectAll <Genre>().FirstOrDefault() : cbGenre.SelectedItem as Genre;
if (genre != null)
{
cbSeries.Items.Clear();
Model.BlockSeries match = new Model.BlockSeries()
{
GenreId = genre
};
cbSeries.Items.AddRange(DataAccess.Match(match));
cbSeries.SelectedIndex = cbSeries.Items.Count > 0 ? 0 : -1;
__HandleSearchChanged();
}
}
protected override void LoadMyViewContext(IoMap map)
{
Outputs.First(X => X.Name == "Block.Genre").Fill(map);
Outputs.First(X => X.Name == "Block.Series").Fill(map);
cbGenre.SelectedIndex = cbGenre.Items.Count > 0 ? 0 : -1;
cbSeries.SelectedIndex = cbSeries.Items.Count > 0 ? 0 : -1;
Genre genre = cbGenre.Items.Count == 0 ? DataAccess.SelectAll <Genre>().FirstOrDefault() : cbGenre.SelectedItem as Genre;
Model.BlockSeries series = cbSeries.Items.Count == 0 ? DataAccess.SelectAll <Model.BlockSeries>().FirstOrDefault() : cbSeries.SelectedItem as Model.BlockSeries;
if (genre != null && series != null)
{
map.SetOutput("Data", DataAccess.Execute(
Resources.SelectBlockInfoQuery,
new[] { new QueryParam("seriesId", QueryParamType.Integer) },
new object[] { series.SeriesId }));
}
}
private void __HandleSearchChanged()
{
Genre genre = cbGenre.Items.Count == 0 ? DataAccess.SelectAll <Genre>().FirstOrDefault() : cbGenre.SelectedItem as Genre;
if (genre != null)
{
Model.BlockSeries series = cbSeries.Items.Count == 0 ? DataAccess.SelectAll <Model.BlockSeries>().FirstOrDefault() : cbSeries.SelectedItem as Model.BlockSeries;
if (series != null)
{
// Get the input as a queryresult
IQueryResult result = DataAccess.Execute(
Resources.SelectBlockInfoQuery,
new[] { new QueryParam("seriesId", QueryParamType.Integer) },
new object[] { series.SeriesId });
// Generate a binding source for the query
BindingSource bs = new BindingSource();
bs.DataSource = result.Source.Tables[0];
// Set the control's binding to the generated binding source
dgvData.DataSource = bs;
}
}
}
