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; } } }