protected override void InitializePage() { base.InitializePage(); // load the types Search s = new Search(msCEUType.CLASS_NAME); s.AddOutputColumn("Name"); s.AddSortColumn("DisplayOrder"); s.AddSortColumn("Name"); foreach (DataRow dr in APIExtensions.GetSearchResult(s, 0, null).Table.Rows) { ddlType.Items.Add(new ListItem(dr["Name"].ToString(), dr["ID"].ToString())); } if (targetCredit != null) { ddlType.ClearSelection(); ListItem li = ddlType.Items.FindByValue(targetCredit.Type); if (li == null) { li = new ListItem(targetCredit.Type); ddlType.Items.Add(li); } li.Selected = true; dpDate.SelectedDate = targetCredit.CreditDate; tbQuantity.Text = targetCredit.Quantity.ToString(); tbNotes.Text = targetCredit.Notes; } }
protected override void InitializePage() { base.InitializePage(); Search s = new Search(msExhibitor.CLASS_NAME); s.AddCriteria(Expr.Equals(msExhibitor.FIELDS.Show, targetShow.ID)); s.AddSortColumn("Name"); s.AddOutputColumn("AssignedBooths"); s.AddOutputColumn("Name"); s.AddOutputColumn("Logo"); s.AddOutputColumn("Bio"); var dt = APIExtensions.GetSearchResult(s, 0, null).Table; if (dt.Rows.Count > 0) { lNoExhibitors.Visible = false; rptExhibitors.DataSource = dt; rptExhibitors.DataBind(); } CustomTitle.Text = string.Format("{0} Exhibitor Listing", targetShow.Name); }
private void ApplyInventory(DataTable productData) { // Initialize the Dictionary with the ProductIDs as keys var inventoriedProducts = (from DataRow dr in productData.Rows where Convert.ToBoolean(dr["TrackInventory"]) && !Convert.ToBoolean(dr["AllowBackOrders"]) select dr["ID"].ToString()).ToDictionary(k => k, v => 0m); if (inventoriedProducts.Count > 0) { var inventorySearch = new Search(msStockItemInventory.CLASS_NAME); inventorySearch.AddOutputColumn("Product"); inventorySearch.AddOutputColumn("QuantityAvailable"); inventorySearch.AddCriteria(Expr.IsOneOfTheFollowing("Product", inventoriedProducts.Keys.ToList())); inventorySearch.AddCriteria(Expr.IsGreaterThan("QuantityAvailable", 0)); var inventoryResults = APIExtensions.GetSearchResult(inventorySearch, 0, null); foreach (DataRow dr in inventoryResults.Table.Rows) { inventoriedProducts[Convert.ToString(dr["Product"])] += Convert.ToDecimal(dr["QuantityAvailable"]); } foreach (DataRow dr in productData.Rows) { var productId = Convert.ToString(dr["ID"]); if (inventoriedProducts.ContainsKey(productId)) { dr["QuantityAvailable"] = inventoriedProducts[productId]; } } } }
protected void rgAllGifts_OnNeedDataSource(object sender, GridNeedDataSourceEventArgs e) { Search s = new Search { Type = msGift.CLASS_NAME }; s.AddOutputColumn("ID"); s.AddOutputColumn("Date"); s.AddOutputColumn("Fund.Name"); s.AddOutputColumn("Type"); s.AddOutputColumn("LocalID"); s.AddOutputColumn("Total"); s.AddCriteria(Expr.Equals("Donor.ID", ConciergeAPI.CurrentEntity.ID)); var result = APIExtensions.GetSearchResult(s, 0, null); if (result.Table != null) { rgAllGifts.DataSource = result.Table; } rgAllGifts.VirtualItemCount = result.TotalRowCount; lNoGifts.Visible = result.TotalRowCount == 0; rgAllGifts.Visible = !lNoGifts.Visible; }
protected void setExistingRegistrationCountLabel() { //Search for existing registrations for the current entity/event from the Concierge API Search sRegistered = new Search { Type = msEventRegistration.CLASS_NAME, Context = targetEvent.ID }; sRegistered.AddCriteria(Expr.Equals("Owner", targetEntity.ID)); sRegistered.AddCriteria(Expr.IsBlank("CancellationDate")); sRegistered.OutputColumns.Add(new SearchOutputColumn { Name = "Name", AggregateFunction = SearchOuputAggregate.Count }); // add one more criteria - we only care about existing if the name hasn't been changed sRegistered.AddCriteria(Expr.Equals("Name", targetEntity.Name)); registrationsCount = (int)APIExtensions.GetSearchResult(sRegistered, 0, null).Table.Rows[0]["Name"]; //Display a message if there are existing registrations for the current entity if (registrationsCount > 0) { lblExistingRegistration.Text = string.Format("Note, you already have {0} registration(s) for this event.", registrationsCount); lblExistingRegistration.Visible = true; } }
/// <summary> /// This addition to the MembershipLogic class assumes that all associations, at minimum, /// define an active membership as having ReceivesMemberBenefits == true and the termination /// date is either null or in the future. /// </summary> /// <param name="entityId">Entity to check Membership for.</param> /// <returns>True if the Entity is a Member.</returns> public static bool IsActiveMember(string entityId) { if (string.IsNullOrWhiteSpace(entityId)) { return(false); } var key = string.Format(IsActiveMemberCacheKeyTemplate, entityId); var isActiveMember = SessionManager.Get <bool?>(key, () => { var search = new Search("MembershipWithFlowdown"); search.AddCriteria(Expr.Equals(msMembership.FIELDS.Owner, entityId)); search.AddCriteria(Expr.Equals(msMembership.FIELDS.ReceivesMemberBenefits, true)); var sog = new SearchOperationGroup { GroupType = SearchOperationGroupType.Or }; sog.Criteria.Add(Expr.IsBlank(msMembership.FIELDS.TerminationDate)); sog.Criteria.Add(Expr.IsGreaterThan(msMembership.FIELDS.TerminationDate, DateTime.Today.Date)); search.AddCriteria(sog); var result = APIExtensions.GetSearchResult(search, 0, 1); return(result != null && result.TotalRowCount > 0); }); return(isActiveMember.HasValue && isActiveMember.Value); }
private void setupRegistrationLinks() { hlRegistration.NavigateUrl += targetShow.ID; if (ConciergeAPI.CurrentEntity == null) { return; } ExhibitorRegistrationPermissionPacket pp; using (var api = GetConciegeAPIProxy()) { pp = api.GetAvailableExhibitorRegistrationWindows(targetShow.ID, ConciergeAPI.CurrentEntity.ID).ResultValue; } // now, let's check each window to make sure the entity doesn't have a registration foreach (var p in pp.Permissions) { // is there a registration already? Search s = new Search(msExhibitor.CLASS_NAME); s.AddCriteria(Expr.Equals(msExhibitor.FIELDS.Show, targetShow.ID)); s.AddCriteria(Expr.Equals(msExhibitor.FIELDS.Customer, p.EntityID)); if (APIExtensions.GetSearchResult(s, 0, 1).TotalRowCount == 0) { hlRegistration.Visible = true; // good to go! return; } } hlRegistration.Visible = false; // no eligible registration }
private SearchResult findComponent() { Search s = new Search(msCertificationComponent.CLASS_NAME); s.AddCriteria(Expr.Equals("Code", tbComponentID.Text.Trim())); int number; if (int.TryParse(tbComponentID.Text, out number)) { s.AddCriteria(Expr.Equals("LocalID", number)); } s.GroupType = SearchOperationGroupType.Or; // either or s.AddOutputColumn("Name"); s.AddOutputColumn("Code"); s.AddOutputColumn("LocalID"); s.AddOutputColumn(msCertificationComponent.FIELDS.StartDate); s.AddOutputColumn(msCertificationComponent.FIELDS.Description); s.AddOutputColumn(msCertificationComponent.FIELDS.AllowPartialParticipation); s.AddOutputColumn("Address"); var result = APIExtensions.GetSearchResult(s, 0, 1); return(result); }
protected void unbind() { // MS-5451 Do not allow entrants to exceed the maximum number of entries per entrant var searchCompetitionEntries = new Search { Type = msCompetitionEntry.CLASS_NAME }; searchCompetitionEntries.AddCriteria(Expr.Equals("Entrant", ConciergeAPI.CurrentEntity.ID)); searchCompetitionEntries.AddCriteria(Expr.Equals("Competition", targetCompetition.ID)); searchCompetitionEntries.AddCriteria(Expr.Equals("Status", targetCompetitionInfo.SubmittedStatusId)); var searchResultsCompetitionEntries = APIExtensions.GetSearchResult(searchCompetitionEntries, 0, null); if (!targetCompetitionInfo.CanEnter || searchResultsCompetitionEntries.TotalRowCount >= targetCompetition.MaximumNumberOfEntriesPerEntrant) { QueueBannerMessage("Please ensure that the competition is still open and that you will not exceed the maximum number of entries with this submission."); GoHome(); } targetCompetitionEntry.Name = tbEntryName.Text; targetCompetitionEntry.DateSubmitted = DateTime.UtcNow; if (MultiStepWizards.EnterCompetition.EntryFee != null) { targetCompetitionEntry.Status = targetCompetitionInfo.PendingPaymentStatusId; targetCompetitionEntry.EntryFee = MultiStepWizards.EnterCompetition.EntryFee.ID; } else { targetCompetitionEntry.Status = targetCompetitionInfo.SubmittedStatusId; } cfsEntryFields.Harvest(); }
protected void getLeader() { Search sLeaders = GetChapterLeaderSearch(targetChapter.ID); SearchResult srLeaders = APIExtensions.GetSearchResult(sLeaders, 0, 1); leader = ConvertLeaderSearchResult(srLeaders); }
protected msIndividual unbindAndSearch(string emailAddress) { Search sIndividual = new Search(msIndividual.CLASS_NAME); sIndividual.AddOutputColumn("ID"); sIndividual.AddOutputColumn("Name"); sIndividual.AddOutputColumn("FirstName"); sIndividual.AddOutputColumn("LastName"); SearchOperationGroup emailGroup = new SearchOperationGroup(); emailGroup.FieldName = "EmailAddress"; emailGroup.GroupType = SearchOperationGroupType.Or; emailGroup.Criteria.Add(Expr.Equals("EmailAddress", emailAddress)); emailGroup.Criteria.Add(Expr.Equals("EmailAddress2", emailAddress)); emailGroup.Criteria.Add(Expr.Equals("EmailAddress3", emailAddress)); sIndividual.AddCriteria(emailGroup); sIndividual.AddSortColumn("LastName"); sIndividual.AddSortColumn("FirstName"); SearchResult srIndividual = APIExtensions.GetSearchResult(sIndividual, 0, null); if (srIndividual.Table.Rows.Count > 0) { return(LoadObjectFromAPI <msIndividual>(srIndividual.Table.Rows[0]["ID"].ToString())); } return(null); }
protected void loadDataFromConcierge(IConciergeAPIService serviceProxy) { targetCompetition = serviceProxy.LoadObjectFromAPI <msCompetition>(ContextID); if (targetCompetition == null) { GoToMissingRecordPage(); return; } targetEntryInfo = targetCompetition.GetCompetitionEntryInformation(); // now check judging if (ConciergeAPI.CurrentEntity == null) { return; } Search s = new Search("JudgingTeamMember"); s.AddOutputColumn("Team.ID"); s.AddCriteria(Expr.Equals("Team.Competition.ID", targetCompetition.ID)); s.AddCriteria(Expr.Equals("Member.ID", ConciergeAPI.CurrentEntity.ID)); SearchResult sr = APIExtensions.GetSearchResult(s, 0, 1); if (sr.TotalRowCount > 0 && sr.Table != null && sr.Table.Rows.Count > 0) { judgingTeamID = sr.Table.Rows[0]["Team.ID"].ToString(); } }
/// <summary> /// Executes a search against the Concierge API for committee memberships related to the current entity /// </summary> /// <returns></returns> private void loadDataFromConcierge() { Search s = new Search { Type = msCommitteeMembership.CLASS_NAME }; s.AddOutputColumn("Committee.ID"); s.AddOutputColumn("Committee.Name"); s.AddOutputColumn("Term.Name"); s.AddOutputColumn("Position.Name"); s.AddOutputColumn("EffectiveStartDate"); s.AddOutputColumn("EffectiveEndDate"); s.AddOutputColumn("IsCurrent"); s.AddCriteria(Expr.Equals("Member.ID", ConciergeAPI.CurrentEntity.ID)); s.AddCriteria(Expr.Equals("Committee.ShowInPortal", true)); s.AddSortColumn("Committee.Name"); var searchResult = APIExtensions.GetSearchResult(s, 0, null); //Create a data view from the search results filtering on just current memberships dvCurrentCommitteeMemberships = new DataView(searchResult.Table); dvCurrentCommitteeMemberships.RowFilter = "IsCurrent=1"; //Create a data view from the search results filtering on non-current memberships dvPastCommitteeMemberships = new DataView(searchResult.Table); dvPastCommitteeMemberships.RowFilter = "IsCurrent=0"; }
private void initializeRegistrations() { Search s = new Search(msEventRegistration.CLASS_NAME); s.Context = targetEvent.ID; s.AddCriteria(Expr.Equals("Group", targetOrganization.ID)); s.AddOutputColumn("Owner.LocalID"); s.AddOutputColumn("Owner.Name"); s.AddOutputColumn("Fee.Name"); s.AddOutputColumn("Owner.LocalID"); s.AddOutputColumn(msRegistrationBase.FIELDS.CancellationDate); var dt = APIExtensions.GetSearchResult(s, 0, null).Table; dt.Columns.Add("Status"); foreach (DataRow dr in dt.Rows) { if (dr["CancellationDate"] != DBNull.Value) { dr["Status"] = "Cancelled"; } else { dr["Status"] = "Active"; } } gvRegistrants.DataSource = dt; gvRegistrants.DataBind(); }
protected void loadDataFromConcierge() { Search sScoringCriterion = new Search(msScoringCriterion.CLASS_NAME); sScoringCriterion.AddOutputColumn("Name"); sScoringCriterion.AddOutputColumn("Description"); sScoringCriterion.AddOutputColumn("MinimumScore"); sScoringCriterion.AddOutputColumn("MaximumScore"); sScoringCriterion.AddOutputColumn("AllowDecimalScores"); sScoringCriterion.AddCriteria(Expr.Equals("Competition", targetCompetitionEntry.Competition)); sScoringCriterion.AddSortColumn("DisplayOrder"); SearchResult srScoringCriterion = APIExtensions.GetSearchResult(sScoringCriterion, 0, null); dtScoringCriterion = srScoringCriterion.Table; DataColumn scScore = dtScoringCriterion.Columns.Add("Score", typeof(decimal)); foreach (DataRow drScoringCriterion in dtScoringCriterion.Rows) { DataRow criterion = drScoringCriterion; msScoreCardScore scoreCardScore = targetScoreCard.Scores.Where(x => x.Criterion == criterion["ID"].ToString()).SingleOrDefault(); if (scoreCardScore != null) { drScoringCriterion[scScore] = scoreCardScore.Score; } } }
protected void loadDataFromConcierge() { Search sLeaders = GetOrganizationalLayerLeaderSearch(targetOrganizationalLayer.ID); SearchResult srLeaders = APIExtensions.GetSearchResult(sLeaders, 0, 1); leader = ConvertLeaderSearchResult(srLeaders); }
/// <summary> /// This will tell you if a msEntity is in the applicable membership type /// </summary> /// <returns></returns> private bool isInApplicableMembershipType() { // We need to now check the Membership Type to see if the if (!targetCommittee.RestrictByMembershipType) { return(true); // ok, we're good } Search s = new Search { Type = "MembershipWithFlowDown" }; s.AddOutputColumn("Type"); s.AddCriteria(Expr.Equals("Owner", ConciergeAPI.CurrentEntity.ID)); var searchReult = APIExtensions.GetSearchResult(s, 0, null); if (searchReult.TotalRowCount > 0) { var aMembershipTypes = targetCommittee["ApplicableOpenMembershipTypes"] as List <string>; var dr = searchReult.Table.Rows[0]; if (aMembershipTypes == null) { return(false); } return(dr.ItemArray.Any(item => aMembershipTypes.Contains(item.ToString()))); } return(false); }
private void bindExhibitorMerchandise() { var s = new Search(msExhibitorMerchandise.CLASS_NAME); s.AddCriteria(Expr.Equals("Show", targetShow.ID)); s.AddCriteria(Expr.Equals("IsActive", true)); s.AddCriteria(Expr.Equals("SellOnline", true)); s.AddSortColumn("DisplayOrder"); s.AddSortColumn("Name"); var products = new List <string>(); foreach (System.Data.DataRow dr in APIExtensions.GetSearchResult(s, 0, null).Table.Rows) { products.Add(Convert.ToString(dr["ID"])); } if (products.Count > 0) { divOtherProducts.Visible = true; using (var api = GetServiceAPIProxy()) { var describedProducts = api.DescribeProducts(targetEntity.ID, products).ResultValue; rptAdditionalItems.DataSource = describedProducts; rptAdditionalItems.DataBind(); } } }
/// <summary> /// Initializes the target object for the page /// </summary> /// <remarks>Many pages have "target" objects that the page operates on. For instance, when viewing /// an event, the target object is an event. When looking up a directory, that's the target /// object. This method is intended to be overriden to initialize the target object for /// each page that needs it.</remarks> protected override void InitializeTargetObject() { base.InitializeTargetObject(); Search sDefaultMemOrg = new Search { Type = msMembershipOrganization.CLASS_NAME }; sDefaultMemOrg.AddOutputColumn("ID"); sDefaultMemOrg.AddOutputColumn(msMembershipOrganization.FIELDS.MembersCanJoinThroughThePortal); sDefaultMemOrg.AddCriteria(string.IsNullOrWhiteSpace(ContextID) ? Expr.Equals("IsDefault", true) : Expr.Equals("ID", ContextID)); SearchResult srDefaultMemOrg = APIExtensions.GetSearchResult(sDefaultMemOrg, 0, null); if (srDefaultMemOrg != null && srDefaultMemOrg.Table != null && srDefaultMemOrg.Table.Rows.Count > 0) { drMembershipOrganization = srDefaultMemOrg.Table.Rows[0]; } targetEntity = MultiStepWizards.RenewMembership.Entity ?? (!string.IsNullOrWhiteSpace(EntityID) ? LoadObjectFromAPI <msEntity>(EntityID) : CurrentEntity); if (drMembershipOrganization == null) { GoToMissingRecordPage(); return; } }
protected override void InitializePage() { base.InitializePage(); using (var api = GetServiceAPIProxy()) { foldersAndFiles = api.DescribeFolder(targetFolder.ID).ResultValue; DocumentsLogic.SetupContextAndParentFolders(api, targetFolder, hlFolderContext, foldersAndFiles, rptParentFolders, true); // get the folder path lblSourceFolder.Text = DocumentsLogic.GetFolderPath(api, targetFolder.ID) + @"\" + targetFile.Name; } Search sFolders = new Search(msFileFolder.CLASS_NAME); sFolders.AddCriteria(Expr.Equals("FileCabinet", targetFolder.FileCabinet)); sFolders.AddOutputColumn("FolderPath"); sFolders.AddSortColumn("FolderLevel"); sFolders.AddSortColumn("Name"); ddlDestination.DataSource = APIExtensions.GetSearchResult(sFolders, 0, null).Table; ddlDestination.DataTextField = "FolderPath"; ddlDestination.DataValueField = "ID"; ddlDestination.DataBind(); ddlDestination.Items.Insert(0, new ListItem("--- Select a Destination Folder ---", "")); }
protected override void InitializePage() { base.InitializePage(); // check for failed deferred billing schedules Search sBillingSchedule = new Search(msBillingSchedule.CLASS_NAME); sBillingSchedule.AddCriteria(Expr.Equals("Order.BillTo", CurrentEntity.ID)); sBillingSchedule.AddCriteria(Expr.Equals(msBillingSchedule.FIELDS.Status, "Suspended")); sBillingSchedule.AddOutputColumn("Order.Name"); sBillingSchedule.AddOutputColumn("Order.Date"); sBillingSchedule.AddOutputColumn("Order.Total"); sBillingSchedule.AddOutputColumn("Order.Memo"); var results = APIExtensions.GetSearchResult(sBillingSchedule, 0, null); if (results.TotalRowCount == 1) // just redirect { Response.Redirect("RectifySuspendedBillingSchedule.aspx?contextID=" + results.Table.Rows[0]["ID"]); } gvTransactions.DataSource = results.Table; gvTransactions.DataBind(); }
/// <summary> /// Setups the shipping section, which only dislays if the shipping method is required /// </summary> private void setupShipping() { // when the order is preprocessed, a default shipping method is selected // let's harvest that from the pre-processed order targetOrder.ShippingMethod = preProcessedOrderPacket.FinalizedOrder.SafeGetValue <string>(msOrder.FIELDS.ShippingMethod); targetOrder.ShippingAddress = preProcessedOrderPacket.FinalizedOrder.SafeGetValue <Address>(msOrder.FIELDS.ShippingAddress); // ok, so let's show the shipping panel divShipping.Visible = true; if (targetOrder.ShippingAddress == null) { targetOrder.ShippingAddress = CurrentEntityPreferredAddress; } // setup billing addresses var addresses = ConciergeAPI.CurrentEntity.Addresses; rptBillingAddress.DataSource = addresses; rptBillingAddress.DataBind(); if (targetOrder.ShippingAddress != null) { rbNewBillingAddress.Checked = true; acBillingAddress.Address = targetOrder.ShippingAddress; } // we need to get all of the available shipping methods from the API Search sShippingMethods = new Search { Type = msShippingMethod.CLASS_NAME }; sShippingMethods.AddCriteria(Expr.Equals("IsActive", true)); sShippingMethods.AddOutputColumn("Name"); sShippingMethods.AddOutputColumn("IsDefault"); sShippingMethods.AddSortColumn("Name"); var dtShippingMethods = APIExtensions.GetSearchResult(sShippingMethods, 0, null).Table; foreach (DataRow dr in dtShippingMethods.Rows) { ListItem li = new ListItem(Convert.ToString(dr["Name"]), Convert.ToString(dr["ID"])); // select the default method li.Selected = li.Value == targetOrder.ShippingMethod; rblShipping.Items.Add(li); // add it to the list } if (rblShipping.Items.Count == 0) { rblShipping.Items.Add(new ListItem("No shipping method available.", null)); } if (rblShipping.SelectedIndex < 0) { rblShipping.SelectedIndex = 0; // almost select the first } }
protected void loadDataFromConcierge() { SearchResult sr = APIExtensions.GetSearchResult(targetSearch, 0, null); dvResults = new DataView(sr.Table); lblSearchResultCount.Text = string.Format("Search returned {0} result(s).", sr.TotalRowCount); }
protected override void InitializePage() { base.InitializePage(); Search s = new Search(msGift.CLASS_NAME); s.AddCriteria(Expr.Equals("ID", targetGift.ID)); s.AddOutputColumn("Type"); s.AddOutputColumn("MasterGift.Name"); s.AddOutputColumn("MasterGift.ID"); s.AddOutputColumn("Date"); s.AddOutputColumn("Total"); s.AddOutputColumn("PaymentMethod"); s.AddOutputColumn("Fund.Name"); s.AddOutputColumn("SavedPaymentMethod.Name"); s.AddOutputColumn("NextTransactionDue"); s.AddOutputColumn("NextTransactionAmount"); s.AddOutputColumn("BalanceDue"); s.AddOutputColumn("DateOfInstallmentSuspension"); dr = APIExtensions.GetSearchResult(s, 0, 1).Table.Rows[0]; pnlRecurring.Visible = dr["NextTransactionDue"] != DBNull.Value; pnlInstallmentHistory.Visible = targetGift.Installments != null && targetGift.Installments.Count > 0; // update status if (targetGift.DateOfInstallmentSuspension == null) { lblStatus.Text = "Active"; lblStatus.ForeColor = Color.Green; } else { lblStatus.Text = "Suspended"; lblStatus.ForeColor = Color.Red; if (targetGift.LastInstallmentError != null) { lblStatus.Text += " - Reason: " + targetGift.LastInstallmentError; } } if (dr["MasterGift.ID"] != DBNull.Value) { phMasterGift.Visible = true; lblNoMasterGift.Visible = false; } hlUpdatePaymentMethod.Visible = pnlRecurring.Visible; hlUpdatePaymentMethod2.NavigateUrl = hlUpdatePaymentMethod.NavigateUrl = string.Format("/orders/updatebillinginformation.aspx?contextID={0}&returnURL={1}", ContextID, HttpUtility.UrlEncode(Request.Url.ToString())); PageTitleExtension.Text = targetGift.Name; }
protected override void InitializeTargetObject() { base.InitializeTargetObject(); if (ContextID == null) { GoToMissingRecordPage(); } Search s = new Search(msPayment.CLASS_NAME); s.AddCriteria(Expr.Equals("ID", ContextID)); s.AddOutputColumn("LocalID"); s.AddOutputColumn("Date"); s.AddOutputColumn("Total"); s.AddOutputColumn("Owner.Name"); s.AddOutputColumn("Owner"); s.AddOutputColumn("AmountRefunded"); s.AddOutputColumn("BillingAddress"); var sr = APIExtensions.GetSearchResult(s, 0, 1); if (sr.TotalRowCount == 0) { GoToMissingRecordPage(); } targetPayment = sr.Table.Rows[0]; if (string.IsNullOrWhiteSpace(LeaderOfId)) { return; } var leaderOf = APIExtensions.LoadObjectFromAPI(LeaderOfId); switch (leaderOf.ClassType) { case msChapter.CLASS_NAME: targetChapter = leaderOf.ConvertTo <msChapter>(); break; case msSection.CLASS_NAME: targetSection = leaderOf.ConvertTo <msSection>(); break; case msOrganizationalLayer.CLASS_NAME: targetOrganizationalLayer = leaderOf.ConvertTo <msOrganizationalLayer>(); break; default: QueueBannerError(string.Format("Invalid leader object type specified '{0}'", leaderOf.ClassType)); GoHome(); return; } }
protected void loadDataFromConcierge() { SearchResult srMembers = APIExtensions.GetSearchResult(targetSearch, PageStart, PAGE_SIZE); SetCurrentPageFromResults(srMembers, hlFirstPage, hlPrevPage, hlNextPage, lNumPages, lNumResults, lStartResult, lEndResult, lCurrentPage); dvMembers = new DataView(srMembers.Table); }
private bool hasPreviouslyRegisteredForComponent(string componentID) { Search s = new Search(msCertificationComponentRegistration.CLASS_NAME); s.AddCriteria(Expr.Equals("Component", componentID)); s.AddCriteria(Expr.Equals("Student", ConciergeAPI.CurrentEntity.ID)); return(APIExtensions.GetSearchResult(s, 0, 1).TotalRowCount > 0); }
protected override void InitializeTargetObject() { base.InitializeTargetObject(); if (ContextID == null) { GoToMissingRecordPage(); } Search s = new Search(msBillingSchedule.CLASS_NAME); s.AddCriteria(Expr.Equals("ID", ContextID)); s.AddOutputColumn("Order.LocalID"); s.AddOutputColumn("Order.Date"); s.AddOutputColumn("Order.Total"); s.AddOutputColumn("Order"); s.AddOutputColumn("Order.BillTo"); s.AddOutputColumn("Order.FutureBillingAmount"); var sr = APIExtensions.GetSearchResult(s, 0, 1); if (sr.TotalRowCount == 0) { GoToMissingRecordPage(); } targetSchedule = sr.Table.Rows[0]; if (Convert.ToString(targetSchedule["Order.BillTo"]) != ConciergeAPI.CurrentEntity.ID) { throw new ApplicationException("Access denied"); } targetOrder = LoadObjectFromAPI <msOrder>(Convert.ToString(targetSchedule["Order"])); if (targetOrder == null) { GoToMissingRecordPage(); } hfOrderBillToId.Value = ConciergeAPI.CurrentEntity.ID; dvPriorityData.InnerHtml = GetPriorityPaymentsConfig(hfOrderBillToId.Value); using (var api = GetServiceAPIProxy()) { var methods = api.DetermineAllowableOrderPaymentMethods(targetOrder).ResultValue; // some payments NEVER make sense in this context methods.AllowBillMeLater = false; BillingInfoWidget.AllowableMethods = methods; } }
protected void loadDataFromConcierge() { SearchResult sr = APIExtensions.GetSearchResult(targetSearch, 0, null); //get distinct rows with the ToTable method DataView tempdv = new DataView(sr.Table); dvResults = new DataView(tempdv.ToTable(true, (from DataColumn column in sr.Table.Columns where column.ColumnName.ToLower() != "row_number" select column.ColumnName).ToArray())); lblSearchResultCount.Text = string.Format("Search returned {0} result(s).", sr.TotalRowCount); }
/// <summary> /// Initializes the target object for the page /// </summary> /// <remarks>Many pages have "target" objects that the page operates on. For instance, when viewing /// an event, the target object is an event. When looking up a directory, that's the target /// object. This method is intended to be overriden to initialize the target object for /// each page that needs it.</remarks> protected override void InitializeTargetObject() { base.InitializeTargetObject(); targetCompetitionEntry = LoadObjectFromAPI <msCompetitionEntry>(ContextID); targetJudgingRound = LoadObjectFromAPI <msJudgingRound>(JudgingRoundId); if (targetCompetitionEntry == null || targetJudgingRound == null) { GoToMissingRecordPage(); return; } targetCompetition = LoadObjectFromAPI <msCompetition>(targetCompetitionEntry.Competition); if (targetCompetition == null) { GoToMissingRecordPage(); return; } targetEntrant = LoadObjectFromAPI <msIndividual>(targetCompetitionEntry.Entrant); if (targetEntrant == null) { GoToMissingRecordPage(); return; } //Search for an existing score card for this judge/competition entry/round and if not found create a new one Search sScoreCard = new Search { Type = msScoreCard.CLASS_NAME, Context = targetCompetitionEntry.ID }; sScoreCard.AddOutputColumn("ID"); sScoreCard.AddCriteria(Expr.Equals("Judge", ConciergeAPI.CurrentEntity.ID)); sScoreCard.AddCriteria(Expr.Equals("Entry", targetCompetitionEntry.ID)); sScoreCard.AddCriteria(Expr.Equals("Round", targetJudgingRound.ID)); SearchResult srScoreCard = APIExtensions.GetSearchResult(sScoreCard, 0, 1); targetScoreCard = srScoreCard.Table != null && srScoreCard.Table.Rows.Count > 0 ? LoadObjectFromAPI <msScoreCard>(srScoreCard.Table.Rows[0]["ID"].ToString()) : new msScoreCard { Entry = targetCompetitionEntry.ID, Judge = ConciergeAPI.CurrentEntity.ID, Round = targetJudgingRound.ID, Scores = new List <msScoreCardScore>(), Name = string.Format("{0} Scores for {1} {2} Round", targetCompetition.Name, targetEntrant.Name, targetJudgingRound.Name) }; }