public ReminderEmailsForm(int year) { AdReminderEmail.Schema.ToString(); //Force static ctor Program.LoadTable <AdReminderEmail>(); //Will load invites as a dependency InitializeComponent(); this.year = year; Text = "Melave Malka " + year + " Reminder Emails"; listSearch.Properties.DataSource = bindingSource.DataSource = dataSource = Program.Table <MelaveMalkaInvitation>().Filter(mmi => mmi.Year == year && mmi.Person.EmailAddresses.Any()); EditorRepository.PersonOwnedLookup.Apply(listSearch.Properties); gridView.ActiveFilterCriteria = new OperandProperty("AdAmount") == 0; new AdvancedColumnsBehavior("ad amounts", fieldNames: new[] { "AdAmount" }).Apply(gridView); CheckableGridController.Handle(colShouldEmail); razor = new TemplateService(new TemplateServiceConfiguration { Resolver = Resolver }); resetSingle.Strings.AddRange(Resolver.Templates.ToArray()); resetSelected.Strings.AddRange(Resolver.Templates.ToArray()); previewAddressItem.EditValue = PreviewAddressEdit.DefaultAddress; //It is impossible to have a non-default EditValue for a BarEditItem, so I apply the default manually. }
// GET: GridDataUrl/FilterData public ActionResult Index(JArray filteredData) { FilteredTable filteredTable = new FilteredTable(); filteredTable.FilterDataRowItem = FilterDataRowItemImplement; DataTable source = filteredTable.GetFilteredTable(filteredData); JArray ja = new JArray(); foreach (DataRow row in source.Rows) { JObject jo = new JObject(); jo.Add("Id", (int)row["Id"]); jo.Add("Name", row["Name"].ToString()); jo.Add("Gender", (int)row["Gender"]); jo.Add("EntranceYear", (int)row["EntranceYear"]); jo.Add("AtSchool", (bool)row["AtSchool"]); jo.Add("Major", row["Major"].ToString()); jo.Add("Group", (int)row["Group"]); ja.Add(jo); } return(Content(ja.ToString(Newtonsoft.Json.Formatting.None))); }
public SeatingForm(int year) { //Load tables before DataMember is set in InitializeComponent //Invitations are required for validation Program.LoadTables(MelaveMalkaSeat.Schema, MelaveMalkaInvitation.Schema); InitializeComponent(); this.year = year; Text = "Melave Malka " + year + " Seating Reservations"; dataSource = Program.Table<MelaveMalkaSeat>().Filter(mms => mms.Year == year); grid.DataMember = null; grid.DataSource = searchLookup.Properties.DataSource = dataSource; Program.SuppressValidation(personSelector.Properties); EditorRepository.OptionalSeatEditor.Apply(addWomensSeats.Properties); EditorRepository.OptionalSeatEditor.Apply(addMensSeats.Properties); EditorRepository.PersonOwnedLookup.Apply(searchLookup.Properties); searchLookup.Properties.Columns.Add(new CustomColumn<MelaveMalkaSeat>( s => s.MensSeats == null ? "Not Sure" : s.MensSeats.Value.ToString(CultureInfo.CurrentCulture) ) { Caption = "Men's Seats", Width = 50 }); searchLookup.Properties.Columns.Add(new CustomColumn<MelaveMalkaSeat>( s => s.WomensSeats == null ? "Not Sure" : s.WomensSeats.Value.ToString(CultureInfo.CurrentCulture) ) { Caption = "Women's Seats", Width = 50 }); }
public AdsGridForm(JournalPresentation jp) { InitializeComponent(); journal = jp; Text = "Journal " + jp.Year + " Ads"; grid.DataMember = null; grid.DataSource = datasource = Program.Table<JournalAd>().Filter(ad => ad.Year == journal.Year); }
public void SetData(int newYear, FilteredTable<RaffleTicket> datasource) { if (datasource == null) throw new ArgumentNullException("datasource"); if (datasource.Rows.Any(t => t.Year != newYear)) throw new ArgumentException("Wrong year", "datasource"); this.year = newYear; this.tickets = datasource; }
private static IReactiveTable FilterFeedsForClientTable(ReactiveClientSession reactiveClientSession, IReactiveTable feedsAndClients) { var feedsForClients = new FilteredTable(feedsAndClients, new DelegatePredicate1 <string>( BrokerTableDefinition.BrokerClientColumns.ClientIpColumn, ip => ip == reactiveClientSession.RemoteEndPoint.Address.ToString())); return(feedsForClients); }
public ActionResult Grid1_FilterChanged(string[] Grid1_fields, JArray Grid1_filteredData) { FilteredTable filteredTable = new FilteredTable(); filteredTable.FilterDataRowItem = FilterDataRowItemImplement; DataTable table = filteredTable.GetFilteredTable(Grid1_filteredData); UIHelper.Grid("Grid1").DataSource(table, Grid1_fields); UIHelper.Label("labResult").Text(String.Format("过滤参数:<pre>{0}</pre>", Grid1_filteredData.ToString(Newtonsoft.Json.Formatting.Indented)), encodeText: false); return(UIHelper.Result()); }
public void SetData(int newYear, FilteredTable <RaffleTicket> datasource) { if (datasource == null) { throw new ArgumentNullException("datasource"); } if (datasource.Rows.Any(t => t.Year != newYear)) { throw new ArgumentException("Wrong year", "datasource"); } this.year = newYear; this.tickets = datasource; }
public ShalachManosForm(int year) { InitializeComponent(); this.year = year; Text = "Shalach Manos " + year; addPanel.Hide(); grid.DataMember = null; pledges = Program.Table <Pledge>().Filter(p => p.Date.Year == year && p.Type == PledgeType); searchLookup.Properties.DataSource = grid.DataSource = pledges; EditorRepository.PersonOwnedLookup.Apply(searchLookup.Properties); ShowHideCheckGroup(); }
public TicketsForm(int year) { InitializeComponent(); Text = year + " Tickets"; tickets = Program.Table <RaffleTicket>().Filter(t => t.Year == year); grid.DataMember = null; grid.DataSource = tickets; addPanel.SetData(year, tickets); tickets.RowAdded += Tickets_RowAdded; tickets.ValueChanged += Tickets_ValueChanged; tickets.RowRemoved += Tickets_RowRemoved; UpdateStats(); }
public TicketsForm(int year) { InitializeComponent(); Text = year + " Tickets"; tickets = Program.Table<RaffleTicket>().Filter(t => t.Year == year); grid.DataMember = null; grid.DataSource = tickets; addPanel.SetData(year, tickets); tickets.RowAdded += Tickets_RowAdded; tickets.ValueChanged += Tickets_ValueChanged; tickets.RowRemoved += Tickets_RowRemoved; UpdateStats(); }
public MainViewModel(IAccountBalanceDataService dataService) { _dataService = dataService; People = new PeopleViewModel(_dataService.People); Accounts = new AccountsViewModel(_dataService.Accounts); _accountFilter = (FilteredTable)_dataService.AccountPeople.Filter( new DelegatePredicate1 <decimal>(AccountColumns.AccountBalance, b => b > BalanceBelowFilter)); PersonAccounts = new PersonAccountsViewModel(_accountFilter, (IWritableReactiveTable)_dataService.Accounts); // PeopleBindingList = new ReactiveBindingList(App.People); StartData = new DelegateCommand(() => _dataService.Start()); StopData = new DelegateCommand(() => _dataService.Stop()); }
public ShalachManosForm(int year) { InitializeComponent(); this.year = year; Text = "Shalach Manos " + year; addPanel.Hide(); grid.DataMember = null; pledges = Program.Table<Pledge>().Filter(p => p.Date.Year == year && p.Type == PledgeType); searchLookup.Properties.DataSource = grid.DataSource = pledges; EditorRepository.PersonOwnedLookup.Apply(searchLookup.Properties); ShowHideCheckGroup(); }
public InvitationsForm(int year) { Program.LoadTable<MelaveMalkaInvitation>(); //Before DataMember is set in InitializeComponent InitializeComponent(); this.year = year; Text = "Melave Malka " + year + " Invitations"; dataSource = Program.Table<MelaveMalkaInvitation>().Filter(mmi => mmi.Year == year); grid.DataMember = null; grid.DataSource = listSearch.Properties.DataSource = dataSource; EditorRepository.MelaveMalkaSourceEditor.Apply(source.Properties); EditorRepository.PersonOwnedLookup.Apply(listSearch.Properties); Program.SuppressValidation(personSelector.Properties); if (Names.MelaveMalkaSources.Contains(DefaultSource)) source.Text = DefaultSource; }
public SyncfusionTestViewModel(IAccountBalanceDataService dataService) { var table = dataService.AccountPeople; _accountFilter = (FilteredTable)table.Filter( new DelegatePredicate1 <decimal>(AccountColumns.AccountBalance, b => b > BalanceBelowFilter)); _balanceSort = new SortedTable(_accountFilter); _balanceSort.SortBy(AccountColumns.AccountBalance, Comparer <decimal> .Default); SetTable(_balanceSort); _columnTypes = new Dictionary <string, Type> { { AccountColumns.AccountBalance, typeof(decimal) }, { PersonColumns.IdNameColumn, typeof(string) }, { PersonColumns.NameColumn, typeof(string) }, { PersonAccountColumns.AccountDetails, typeof(string) } }; Columns = new ObservableCollection <string>(_columnTypes.Keys); }
public CallerList(int year) { Program.LoadTable<Caller>(); InitializeComponent(); this.Text = "Melave Malka " + year + " Callers"; this.year = year; addCaller.Properties.DataSource = Program.Table<Person>(); EditorRepository.PersonLookup.Apply(addCaller.Properties); grid.DataMember = null; grid.DataSource = dataSource = Program.Table<Caller>().Filter(c => c.Year == year); ToggleRowsBehavior.Instance.Apply(gridView); UpdateButtons(); razor = new TemplateService(new TemplateServiceConfiguration { Resolver = Resolver }); emailTemplateList.Strings.AddRange(Resolver.Templates.ToArray()); }
public InvitationsForm(int year) { Program.LoadTable <MelaveMalkaInvitation>(); //Before DataMember is set in InitializeComponent InitializeComponent(); this.year = year; Text = "Melave Malka " + year + " Invitations"; dataSource = Program.Table <MelaveMalkaInvitation>().Filter(mmi => mmi.Year == year); grid.DataMember = null; grid.DataSource = listSearch.Properties.DataSource = dataSource; EditorRepository.MelaveMalkaSourceEditor.Apply(source.Properties); EditorRepository.PersonOwnedLookup.Apply(listSearch.Properties); Program.SuppressValidation(personSelector.Properties); if (Names.MelaveMalkaSources.Contains(DefaultSource)) { source.Text = DefaultSource; } }
public CallerList(int year) { Program.LoadTable <Caller>(); InitializeComponent(); this.Text = "Melave Malka " + year + " Callers"; this.year = year; addCaller.Properties.DataSource = Program.Table <Person>(); EditorRepository.PersonLookup.Apply(addCaller.Properties); grid.DataMember = null; grid.DataSource = dataSource = Program.Table <Caller>().Filter(c => c.Year == year); ToggleRowsBehavior.Instance.Apply(gridView); UpdateButtons(); razor = new TemplateService(new TemplateServiceConfiguration { Resolver = Resolver }); emailTemplateList.Strings.AddRange(Resolver.Templates.ToArray()); }
public SeatingForm(int year) { Program.LoadTable <SeatingReservation>(); //Before setting DataMember InitializeComponent(); loadingIconItem.EditValue = LoadingImage; colPledgeType.ColumnEdit = SeatingInfo.PledgeTypeEdit; //TODO: IEditorSettings? this.year = year; grid.DataMember = null; grid.DataSource = seats = Program.Table <SeatingReservation>().Filter(sr => sr.Pledge.Date.Year == year); Text = year.ToString(CultureInfo.CurrentCulture) + " Seating Reservations"; colChartStatus.Visible = colChartStatus.OptionsColumn.ShowInCustomizationForm = false; Program.Table <Pledge>().ValueChanged += Pledge_ValueChanged; Program.Table <SeatingReservation>().RowRemoved += SeatingReservation_RowChanged; Program.Table <SeatingReservation>().ValueChanged += SeatingReservation_ValueChanged; Program.Table <SeatingReservation>().RowAdded += SeatingReservation_RowChanged; UpdateTotals(); }
public SeatingForm(int year) { Program.LoadTable<SeatingReservation>(); //Before setting DataMember InitializeComponent(); loadingIconItem.EditValue = LoadingImage; colPledgeType.ColumnEdit = SeatingInfo.PledgeTypeEdit; //TODO: IEditorSettings? this.year = year; grid.DataMember = null; grid.DataSource = seats = Program.Table<SeatingReservation>().Filter(sr => sr.Pledge.Date.Year == year); Text = year.ToString(CultureInfo.CurrentCulture) + " Seating Reservations"; colChartStatus.Visible = colChartStatus.OptionsColumn.ShowInCustomizationForm = false; Program.Table<Pledge>().ValueChanged += Pledge_ValueChanged; Program.Table<SeatingReservation>().RowRemoved += SeatingReservation_RowChanged; Program.Table<SeatingReservation>().ValueChanged += SeatingReservation_ValueChanged; Program.Table<SeatingReservation>().RowAdded += SeatingReservation_RowChanged; UpdateTotals(); }
public ReminderEmailsForm(int year) { AdReminderEmail.Schema.ToString(); //Force static ctor Program.LoadTable<AdReminderEmail>(); //Will load invites as a dependency InitializeComponent(); Text = "Melave Malka " + year + " Reminder Emails"; listSearch.Properties.DataSource = bindingSource.DataSource = dataSource = Program.Table<MelaveMalkaInvitation>().Filter(mmi => mmi.Year == year && mmi.Person.EmailAddresses.Any()); EditorRepository.PersonOwnedLookup.Apply(listSearch.Properties); gridView.ActiveFilterCriteria = new OperandProperty("AdAmount") == 0; new AdvancedColumnsBehavior("ad amounts", fieldNames: new[] { "AdAmount" }).Apply(gridView); CheckableGridController.Handle(colShouldEmail); razor = new TemplateService(new TemplateServiceConfiguration { Resolver = Resolver }); resetSingle.Strings.AddRange(Resolver.Templates.ToArray()); resetSelected.Strings.AddRange(Resolver.Templates.ToArray()); previewAddressItem.EditValue = PreviewAddressEdit.DefaultAddress; //It is impossible to have a non-default EditValue for a BarEditItem, so I apply the default manually. }
public CallListForm(int year) { Program.LoadTable<MelaveMalkaInvitation>(); //Includes Callers as a dependency InitializeComponent(); this.year = year; Text = "Melave Malka " + year + " Call List"; grid.DataMember = null; listSearch.Properties.DataSource = grid.DataSource = dataSource = Program.Table<MelaveMalkaInvitation>().Filter(mmi => mmi.Year == year); EditorRepository.PersonOwnedLookup.Apply(listSearch.Properties); gridView.ActiveFilterCriteria = new OperandProperty("AdAmount") == 0; new AdvancedColumnsBehavior("ad amounts", fieldNames: new[] { "AdAmount" }).Apply(gridView); CheckableGridController.Handle(colShouldCall); Program.Table<Caller>().RowAdded += CallersTable_Changed; Program.Table<Caller>().RowRemoved += CallersTable_Changed; BindCallerDropDown(); }
public CallListForm(int year) { Program.LoadTable <MelaveMalkaInvitation>(); //Includes Callers as a dependency InitializeComponent(); this.year = year; Text = "Melave Malka " + year + " Call List"; grid.DataMember = null; listSearch.Properties.DataSource = grid.DataSource = dataSource = Program.Table <MelaveMalkaInvitation>().Filter(mmi => mmi.Year == year); EditorRepository.PersonOwnedLookup.Apply(listSearch.Properties); gridView.ActiveFilterCriteria = new OperandProperty("AdAmount") == 0; new AdvancedColumnsBehavior("ad amounts", fieldNames: new[] { "AdAmount" }).Apply(gridView); CheckableGridController.Handle(colShouldCall); Program.Table <Caller>().RowAdded += CallersTable_Changed; Program.Table <Caller>().RowRemoved += CallersTable_Changed; BindCallerDropDown(); }
private void SetupFeedSubscription(IReactiveTable currenciesTable, IReactiveTableProcessor <IReactiveTable> encoder) { var endPoint = new IPEndPoint(IPAddress.Loopback, (int)ServerPorts.BrokerFeedClients); var selectedCurrencies = new FilteredTable( currenciesTable, new DelegatePredicate1 <bool>(BrokerTableDefinition.BrokerClientColumns.ClientSide.Selected, selected => selected)); var client = new ReactiveTableTcpClient <IReactiveTable>(encoder, selectedCurrencies, GetEncoderState(), endPoint); _ccyPairSubscriptionClient = client; try { client.Start(); } catch (Exception ex) { Debug.WriteLine(ex); } }
public SeatingForm(int year) { //Load tables before DataMember is set in InitializeComponent //Invitations are required for validation Program.LoadTables(MelaveMalkaSeat.Schema, MelaveMalkaInvitation.Schema); InitializeComponent(); this.year = year; Text = "Melave Malka " + year + " Seating Reservations"; dataSource = Program.Table <MelaveMalkaSeat>().Filter(mms => mms.Year == year); grid.DataMember = null; grid.DataSource = searchLookup.Properties.DataSource = dataSource; mensSeatsItem.Text = MelaveMalkaSeat.MensSeatsCaption + ":"; womensSeatsItem.Text = MelaveMalkaSeat.WomensSeatsCaption + ":"; Program.SuppressValidation(personSelector.Properties); EditorRepository.OptionalSeatEditor.Apply(addWomensSeats.Properties); EditorRepository.OptionalSeatEditor.Apply(addMensSeats.Properties); EditorRepository.PersonOwnedLookup.Apply(searchLookup.Properties); searchLookup.Properties.Columns.Add(new CustomColumn <MelaveMalkaSeat>( s => s.MensSeats == null ? "Not Sure" : s.MensSeats.Value.ToString(CultureInfo.CurrentCulture) ) { Caption = MelaveMalkaSeat.MensSeatsCaption, Width = 50 }); searchLookup.Properties.Columns.Add(new CustomColumn <MelaveMalkaSeat>( s => s.WomensSeats == null ? "Not Sure" : s.WomensSeats.Value.ToString(CultureInfo.CurrentCulture) ) { Caption = MelaveMalkaSeat.WomensSeatsCaption, Width = 50 }); }
void SetAd(AdShape newAd, bool force = false) { if (this.ad == newAd && !force) { CheckWarnings(); return; } Focus(); // Commit any pending edits. DisposeDataSources(); this.ad = newAd; layoutControl1.Visible = ad != null; if (ad == null) return; adsBindingSource.Position = adsBindingSource.IndexOf(ad.Row); adType.EditValue = ad.AdType; //Singularity's dependency parser cannot handle //external rows, so I can't use ad.Row inside of //the filter. However, I want to pick up changes //to the ad's ExternalId, so I use a function. Func<int> externalId = () => ad.Row.ExternalId; pledgesSource.DataSource = pledges = Program.Table<Pledge>().Filter( p => p.ExternalSource == "Journal " + journal.Year && p.ExternalId == externalId() ); paymentsSource.DataSource = payments = Program.Table<Payment>().Filter( p => p.ExternalSource == "Journal " + journal.Year && p.ExternalId == externalId() ); CheckWarnings(); //I need to call BeginInvoke so that the new row gets painted first. pledges.RowAdded += delegate { BeginInvoke(new Action(pledgesView.BestFitColumns)); }; payments.RowAdded += delegate { BeginInvoke(new Action(paymentsView.BestFitColumns)); }; }
static void VerifyFilteredTable <TRow>(FilteredTable <TRow> ft, Func <TRow, bool> filter) where TRow : Row { CollectionAssert.AreEqual((ICollection)ft.Rows, ft.Table.Rows.Where(r => filter((TRow)r)).ToArray()); }
public FilteredTableBinder(FilteredTable <TRow> ft) : base(ft) { }