private void FindSong() { obj = new ComposersLibrary_EF.DBLibraryEntities1(); query = (from c in obj.SONGs select c); if (!String.IsNullOrWhiteSpace(NameTextBox.Text)) { query = query.Where(c => c.SNG_NAME.Contains(NameTextBox.Text)); } if (!String.IsNullOrWhiteSpace(GenreTextBox.Text)) { query = query.Where(c => c.SNG_GENRE.Contains(GenreTextBox.Text)); } if (!String.IsNullOrWhiteSpace(DurationTextBox.Text)) { TimeSpan time; if (TimeSpan.TryParse(DurationTextBox.Text, out time)) { query = query.Where(c => c.SNG_DURATION.Value <= time); } else { MessageBox.Show("You have entered the wrong format of duration time of song, it must be HH:MM:SS.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); DurationTextBox.Text = ""; return; } } sONGBindingSource.DataSource = query.ToList(); }
private void FindPerformances() { obj = new ComposersLibrary_EF.DBLibraryEntities1(); var query = (from c in obj.PERFORMANCEs select c); query = query.Where(c => c.PRF_DATE.Value > (DateTimePickerFrom.Value)); query = query.Where(c => c.PRF_DATE.Value < DateTimePickerTo.Value); pERFORMANCEBindingSource.DataSource = query.ToList(); }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); ctx = new ComposersLibrary_EF.DBLibraryEntities1(); ctx.SONGs.Load(); this.sONGBindingSource.DataSource = ctx.SONGs.Local.ToBindingList(); ctx.PERFORMERs.Load(); this.pERFORMERBindingSource.DataSource = ctx.PERFORMERs.Local.ToBindingList(); ctx.PERFORMANCEs.Load(); this.pERFORMANCEBindingSource.DataSource = ctx.PERFORMANCEs.Local.ToBindingList(); ctx.COMPOSERs.Load(); this.cOMPOSERBindingSource.DataSource = ctx.COMPOSERs.Local.ToBindingList(); }
private void FindComposers() { obj = new ComposersLibrary_EF.DBLibraryEntities1(); var query = (from c in obj.COMPOSERs select c); if (!String.IsNullOrWhiteSpace(NameTextBox.Text)) { query = query.Where(c => c.CMP_FULL_NAME.Contains(NameTextBox.Text)); } if (!String.IsNullOrWhiteSpace(NationalityTextBox.Text)) { query = query.Where(c => c.CMP_NATIONALITY.Contains(NationalityTextBox.Text)); } cOMPOSERBindingSource.DataSource = query.ToList(); }
private void FindPerformer() { obj = new ComposersLibrary_EF.DBLibraryEntities1(); var query = (from c in obj.PERFORMERs where c.PERFORMANCEs.Any() select c); if (!String.IsNullOrWhiteSpace(NameTextBox.Text)) { query = query.Where(c => c.PF_NAME.Contains(NameTextBox.Text)); } if (!String.IsNullOrWhiteSpace(NationalityTextBox.Text)) { query = query.Where(c => c.PF_NATIONALITY.Contains(NationalityTextBox.Text)); } pERFORMERBindingSource.DataSource = query.ToList(); }