private void InitializeManualCode() { string CheckedMember = "CHECKED"; string DisplayMember = PPublicationTable.GetPublicationDescriptionDBName(); string ValueMember = PPublicationTable.GetPublicationCodeDBName(); DataTable Table = TDataCache.TMPartner.GetCacheableSubscriptionsTable(TCacheableSubscriptionsTablesEnum.PublicationList); DataView view = new DataView(Table); // TODO view.RowFilter = only active publications? view.Sort = ValueMember; DataTable NewTable = view.ToTable(true, new string[] { ValueMember, DisplayMember }); NewTable.Columns.Add(new DataColumn(CheckedMember, typeof(bool))); clbIncludePublication.SpecialKeys = ((SourceGrid.GridSpecialKeys)((((((SourceGrid.GridSpecialKeys.Arrows | SourceGrid.GridSpecialKeys.PageDownUp) | SourceGrid.GridSpecialKeys.Enter) | SourceGrid.GridSpecialKeys.Escape) | SourceGrid.GridSpecialKeys.Control) | SourceGrid.GridSpecialKeys.Shift))); //clbIncludePublication.SelectionMode = SourceGrid.GridSelectionMode.Row; clbIncludePublication.Columns.Clear(); clbIncludePublication.AddCheckBoxColumn("", NewTable.Columns[CheckedMember], 17, false); clbIncludePublication.AddTextColumn(Catalog.GetString("Publication Code"), NewTable.Columns[ValueMember]); clbIncludePublication.AddTextColumn(Catalog.GetString("Publication Description"), NewTable.Columns[DisplayMember]); clbIncludePublication.DataBindGrid(NewTable, ValueMember, CheckedMember, ValueMember, false, true, false); dtpDateOfSendingCopy.Date = DateTime.Now; ActiveSubscriptionsBoxChanged(null, null); }
private void UpdatePublicationCost() { DataRow[] PublicationCostRows = null; /* if the Subscription is free, the cost is always 0! */ if (this.chkPSubscriptionGratisSubscription.Checked) { SetupPublicationCost(0, ""); } else { /* If any Publications */ if (FSubscriptionDR != null) { PublicationCostRows = FPublicationCostDT.Select( PPublicationTable.GetPublicationCodeDBName() + " = '" + this.cmbPSubscriptionPublicationCode.GetSelectedString() + "'"); /* if the Subscription has a cost, set it, else set the cost to 0. */ if (PublicationCostRows.Length > 0) { SetupPublicationCost((decimal)((PPublicationCostRow)PublicationCostRows[0]).PublicationCost, ((PPublicationCostRow)PublicationCostRows[0]).CurrencyCode); } else { SetupPublicationCost(0, ""); } } else { this.btnEditIssues.Enabled = false; } } }
private void InitializePublicationCodeList() { string CheckedMember = "CHECKED"; string ValueMember = PPublicationTable.GetPublicationCodeDBName(); string DisplayMember = PPublicationTable.GetPublicationDescriptionDBName(); DataTable Publications = TDataCache.TMPartner.GetCacheableSubscriptionsTable(TCacheableSubscriptionsTablesEnum.PublicationList); DataView PublicationsView = new DataView(Publications); PublicationsView.Sort = ValueMember; DataTable PublicationsTable = PublicationsView.ToTable(true, new string[] { ValueMember, DisplayMember }); PublicationsTable.Columns.Add(new DataColumn(CheckedMember, typeof(bool))); clbPublicationCode.SpecialKeys = ((SourceGrid.GridSpecialKeys)((((((SourceGrid.GridSpecialKeys.Arrows | SourceGrid.GridSpecialKeys.PageDownUp) | SourceGrid.GridSpecialKeys.Enter) | SourceGrid.GridSpecialKeys.Escape) | SourceGrid.GridSpecialKeys.Control) | SourceGrid.GridSpecialKeys.Shift))); clbPublicationCode.Columns.Clear(); clbPublicationCode.AddCheckBoxColumn("", PublicationsTable.Columns[CheckedMember], 17, false); clbPublicationCode.AddTextColumn(Catalog.GetString("Group Code"), PublicationsTable.Columns[ValueMember]); clbPublicationCode.AddTextColumn(Catalog.GetString("Description"), PublicationsTable.Columns[DisplayMember]); clbPublicationCode.DataBindGrid(PublicationsTable, ValueMember, CheckedMember, ValueMember, false, true, false); clbPublicationCode.AutoResizeGrid(); clbPublicationCode.AutoStretchColumnsToFitWidth = true; clbPublicationCode.SetCheckedStringList(""); }