/// <summary>
/// Executes a query against the Concierge API for all open competitions related to the current association
/// </summary>
/// <returns></returns>
private void loadDataFromConcierge()
{
Search s = new Search {
Type = msCompetition.CLASS_NAME
};
s.AddOutputColumn("ID");
s.AddOutputColumn("Name");
s.AddOutputColumn("OpenDate");
s.AddOutputColumn("CloseDate");
//s.AddCriteria(Expr.IsLessThan("OpenDate",DateTime.UtcNow));
//s.AddCriteria(Expr.IsGreaterThan("CloseDate", DateTime.UtcNow));
s.AddCriteria(Expr.DoesNotEqual("IsClosed", 1));
SearchOperationGroup soPostDate = new SearchOperationGroup();
soPostDate.Criteria.Add(Expr.IsBlank("PostToWeb"));
soPostDate.Criteria.Add(Expr.IsLessThan("PostToWeb", DateTime.UtcNow));
soPostDate.GroupType = SearchOperationGroupType.Or;
SearchOperationGroup soRemoveDate = new SearchOperationGroup();
soRemoveDate.Criteria.Add(Expr.IsBlank("RemoveFromWeb"));
soRemoveDate.Criteria.Add(Expr.IsGreaterThan("RemoveFromWeb", DateTime.UtcNow));
soRemoveDate.GroupType = SearchOperationGroupType.Or;
s.AddCriteria(soPostDate);
s.AddCriteria(soRemoveDate);
s.AddSortColumn("CloseDate");
var searchResult = APIExtensions.GetSearchResult(s, 0, null);
dtCompetitions = searchResult.Table;
}
protected void addRequiredSearchParameters()
{
if (!targetSearch.OutputColumns.Exists(x => x.Name == "ID"))
{
targetSearch.OutputColumns.Add(new SearchOutputColumn {
Name = "ID", DisplayName = "ID"
});
}
if (!targetSearch.Criteria.Exists(x => x.FieldName == "IsActive"))
{
targetSearch.AddCriteria(Expr.Equals("IsActive", true));
}
if (!targetSearch.Criteria.Exists(x => x.FieldName == "IsApproved"))
{
targetSearch.AddCriteria(Expr.Equals("IsApproved", true));
}
if (Output == "zip")
{
targetSearch.OutputFormat = "builtin:zip";
}
}
private Search generateInstallmentsSearch()
{
Search s = new Search(msBillingScheduleEntry.CLASS_NAME);
s.AddCriteria(Expr.Equals("Schedule.Order.ID", ContextID));
s.AddOutputColumn("Date");
s.AddOutputColumn("Product.Name");
s.AddOutputColumn("Status");
s.AddOutputColumn("Amount");
s.AddSortColumn("Date");
return(s);
}
protected void loadDataFromConcierge()
{
Search s = new Search(msResume.CLASS_NAME);
s.AddOutputColumn("ID");
s.AddOutputColumn("LocalID");
s.AddOutputColumn("Name");
s.AddOutputColumn("File");
s.AddOutputColumn("IsActive");
s.AddCriteria(Expr.Equals("Owner", ConciergeAPI.CurrentEntity.ID));
SearchResult sr = APIExtensions.GetSearchResult(s, 0, null);
dvResumes = new DataView(sr.Table);
}
private Search generateInvoicesSearch()
{
Search s = new Search(msInvoice.CLASS_NAME);
s.AddCriteria(Expr.Equals("Order", ContextID));
s.AddOutputColumn("Date");
s.AddOutputColumn("Name");
s.AddOutputColumn("Total");
s.AddOutputColumn("AmountPaid");
s.AddOutputColumn("BalanceDue");
s.AddSortColumn("Date", true);
return(s);
}
private Search generatePaymentItemsSearch()
{
Search s = new Search(msPaymentLineItem.CLASS_NAME);
s.AddCriteria(Expr.Equals("Payment", ContextID));
s.AddOutputColumn("Type");
s.AddOutputColumn("TransactionName");
s.AddOutputColumn(msPaymentLineItem.FIELDS.Total);
s.AddOutputColumn(msPaymentLineItem.FIELDS.Invoice);
s.AddSortColumn("ListIndex");
return(s);
}
private Search generateOrderItemsSearch()
{
Search s = new Search(msOrderLineItem.CLASS_NAME);
s.AddCriteria(Expr.Equals("Order", ContextID));
s.AddOutputColumn("Product.Name");
s.AddOutputColumn("Description");
s.AddOutputColumn("Quantity");
s.AddOutputColumn("UnitPrice");
s.AddOutputColumn("Total");
s.AddOutputColumn("Status");
s.AddSortColumn("ListIndex");
return(s);
}
protected void loadDataFromConcierge()
{
var searches = new List<Search>();
// Search for confirmation emails
var sConfirmationEmails = new Search(msEmailTemplateContainer.CLASS_NAME);
sConfirmationEmails.AddOutputColumn("ID");
sConfirmationEmails.AddOutputColumn("Name");
sConfirmationEmails.AddCriteria(Expr.Equals("ApplicableType", "OrderLineItem"));
sConfirmationEmails.AddSortColumn("Name");
searches.Add(sConfirmationEmails);
var searchResults = APIExtensions.GetMultipleSearchResults(searches, 0, null);
dvConfirmationEmails = new DataView(searchResults[0].Table);
}
private string retrieveIDForDiscountCode(string discountCode)
{
Search s = new Search(msDiscountCode.CLASS_NAME);
s.AddCriteria(Expr.Equals("Code", discountCode));
using (var api = GetServiceAPIProxy())
{
var result = api.GetSearchResult(s, 0, 1);
if (result.TotalRowCount > 0)
{
return(Convert.ToString(result.Table.Rows[0]["ID"]));
}
}
return(null);
}
private void setupContacts()
{
Search s = new Search("ExhibitorContact");
s.AddCriteria(Expr.Equals("Exhibitor", targetExhibitor.ID));
s.AddSortColumn("Type.DisplayOrder");
s.AddOutputColumn("Type.Name");
s.AddOutputColumn("FirstName");
s.AddOutputColumn("LastName");
s.AddOutputColumn("EmailAddress");
s.AddOutputColumn("WorkPhone");
s.AddOutputColumn("MobilePhone");
gvBoothContacts.DataSource = APIExtensions.GetSearchResult(s, 0, null).Table;
gvBoothContacts.DataBind();
}
protected void loadDataFromConcierge()
{
Search sMembersOnList = new Search("WaivedRegistrationListMember");
sMembersOnList.AddOutputColumn("Individual.ID");
sMembersOnList.AddOutputColumn("Individual.LocalID");
sMembersOnList.AddOutputColumn("Individual.FirstName");
sMembersOnList.AddOutputColumn("Individual.LastName");
sMembersOnList.AddOutputColumn("IsRegistered");
sMembersOnList.AddCriteria(Expr.Equals("List", targetWaivedRegistrationList.ID));
sMembersOnList.AddSortColumn("Individual.LastName");
sMembersOnList.AddSortColumn("Individual.FirstName");
SearchResult srMembersOnList = APIExtensions.GetSearchResult(sMembersOnList, 0, null);
dvMembers = new DataView(srMembersOnList.Table);
}
/// <summary>
/// Executes a query against the Concierge API for all committees related to the current association
/// </summary>
/// <returns></returns>
private void loadDataFromConcierge()
{
Search s = new Search {
Type = msCommittee.CLASS_NAME
};
s.AddOutputColumn("ID");
s.AddOutputColumn("Name");
s.AddOutputColumn("CurrentMemberCount");
s.AddCriteria(Expr.Equals("ShowInPortal", true));
s.AddSortColumn("Name");
var searchResult = APIExtensions.GetSearchResult(s, 0, null);
dvCommittees = new DataView(searchResult.Table);
}
private Search generatePaymentsSearch()
{
Search s = new Search(msPaymentLineItem.CLASS_NAME);
s.AddCriteria(Expr.Equals("Invoice.Order", ContextID));
s.AddOutputColumn("Payment.Date");
s.AddOutputColumn("Payment.Owner.Name");
s.AddOutputColumn(msPaymentLineItem.FIELDS.Total);
s.AddOutputColumn("Payment");
s.AddOutputColumn("Payment.Name");
s.AddSortColumn("Payment.Date", true);
return(s);
}
protected void setTimeSlots()
{
timeslots = new List <msSessionTimeSlot>();
using (var api = GetServiceAPIProxy())
{
Search sTimeSlots = new Search {
Type = msSessionTimeSlot.CLASS_NAME
};
sTimeSlots.AddOutputColumn("ID");
sTimeSlots.AddOutputColumn("Name");
sTimeSlots.AddOutputColumn("StartTime");
sTimeSlots.AddOutputColumn("EndTime");
sTimeSlots.AddOutputColumn("AllowMultipleSessions");
sTimeSlots.AddCriteria(Expr.Equals(msSessionTimeSlot.FIELDS.Event, targetEvent.ID));
sTimeSlots.AddSortColumn("StartTime");
sTimeSlots.AddSortColumn("Name");
foreach (DataRow drResult in api.GetSearchResult(sTimeSlots, 0, null).Table.Rows)
{
timeslots.Add(MemberSuiteObject.FromDataRow(drResult).ConvertTo <msSessionTimeSlot>());
}
}
pnlSessions.Visible = false;
// add the NULL timeslot, for sessions that have not been placed into time slots
timeslots.Insert(0, new msSessionTimeSlot {
Name = "Events Happening During this Event", ID = null
});
// if there's one session, one session at all, then the panel is shown
rptSessions.DataSource = timeslots;
rptSessions.DataBind();
if (targetRegistrationFee.MaximumNumberOfSessions != null)
{
cvMaxSession.ErrorMessage =
string.Format(
"You have selected too many sessions. When registering using the '{0}' fee, you are allowed a maximum of {1} sessions.",
targetRegistrationFee.Name, targetRegistrationFee.MaximumNumberOfSessions.Value);
}
}
private void generateSearch()
{
Search s = new Search(msVolunteer.CLASS_NAME);
s.AddCriteria(Expr.Equals("ID", targetVolunteer.ID));
s.AddOutputColumn("Sponsor.Name");
s.AddOutputColumn("Individual.Name");
s.AddOutputColumn("NumberOfAssignments");
s.AddOutputColumn("TotalHoursWorked");
s.AddOutputColumn("LastAssignment.JobOccurrence.Job.Name");
s.AddOutputColumn("LastAssignment.JobOccurrence.StartDateTime");
s.AddOutputColumn("LastAssignment.JobOccurrence.EndDateTime");
drSearchResults = APIExtensions.GetSearchResult(s, 0, 1).Table.Rows[0];
trSponsor.Visible = drSearchResults["Sponsor.Name"] != DBNull.Value;
}
/// <summary>
/// Executes a query against the Concierge API for all committees related to the current association
/// </summary>
/// <returns></returns>
private void loadDataFromConcierge()
{
Search s = new Search {
Type = msEvent.CLASS_NAME
};
s.AddOutputColumn("ID");
s.AddOutputColumn("Name");
s.AddOutputColumn("StartDate");
s.AddOutputColumn("EndDate");
s.AddCriteria(Expr.Equals("Chapter.ID", targetChapter.ID));
s.AddSortColumn("StartDate");
s.AddSortColumn("EndDate");
s.AddSortColumn("Name");
var searchResult = APIExtensions.GetSearchResult(s, 0, null);
dvEvents = new DataView(searchResult.Table);
}
protected override void InitializePage()
{
base.InitializePage();
Search s = new Search(msVolunteerJobAssignment.CLASS_NAME);
s.AddCriteria(Expr.Equals(msVolunteerJobAssignment.FIELDS.Volunteer, targetVolunteer.ID));
s.AddOutputColumn("JobOccurrence.Job.Name");
s.AddOutputColumn(msVolunteerJobAssignment.FIELDS.StartDateTime);
s.AddOutputColumn(msVolunteerJobAssignment.FIELDS.EndDateTime);
s.AddOutputColumn("HoursWorked");
s.AddSortColumn(msVolunteerJobAssignment.FIELDS.StartDateTime, true);
gvHistory.DataSource = APIExtensions.GetSearchResult(s, 0, null).Table;
gvHistory.DataBind();
}
public override void GenerateSearchesToBeRun(List <Search> searchesToRun)
{
base.GenerateSearchesToBeRun(searchesToRun);
Search s = new Search(msCEUCredit.CLASS_NAME)
{
ID = "CEU"
};
s.AddCriteria(Expr.Equals("Owner", ConciergeAPI.CurrentEntity.ID));
s.AddOutputColumn("CreditDate");
s.AddOutputColumn("Type.Name");
s.AddOutputColumn("Quantity");
searchesToRun.Add(s);
return;
}
private void loadDataFromConcierge()
{
var sFinancialTransactions = new Search {
Type = msOrder.CLASS_NAME
};
sFinancialTransactions.AddCriteria(Expr.Equals(msOrder.FIELDS.BillTo, targetEntity.ID));
sFinancialTransactions.AddOutputColumn("Date");
sFinancialTransactions.AddOutputColumn("Name");
sFinancialTransactions.AddOutputColumn("Memo");
sFinancialTransactions.AddOutputColumn("Total");
sFinancialTransactions.AddSortColumn("Date", true);
var srFinancialTransactions = APIExtensions.GetSearchResult(sFinancialTransactions, 0, null);
dvFinancialTransactions = new DataView(srFinancialTransactions.Table);
}
protected void loadDataFromConcierge()
{
var searches = new List <Search>();
// Get all the chapters for the chapter & member counts
// Setup the clause to recursively find chapters that are somewhere nested under the current organizational layer
var organizationalLayerChapterClause = new SearchOperationGroup {
GroupType = SearchOperationGroupType.Or
};
organizationalLayerChapterClause.Criteria.Add(Expr.Equals("Layer", ContextID));
// Add the recursive query for all the parent organizational layers
var sbChapter = new StringBuilder("Layer");
// Add Organizational Layers
for (int i = 0; i < PortalConfiguration.OrganizationalLayerTypes.Rows.Count - 1; i++)
{
sbChapter.Append(".{0}");
organizationalLayerChapterClause.Criteria.Add(Expr.Equals(string.Format(sbChapter.ToString(), "ParentLayer"), ContextID));
}
var sChapters = new Search(msChapter.CLASS_NAME)
{
ID = msChapter.CLASS_NAME
};
sChapters.AddOutputColumn("ID");
sChapters.AddOutputColumn("Name");
sChapters.AddOutputColumn("LinkedOrganization._Preferred_Address");
sChapters.AddCriteria(organizationalLayerChapterClause);
sChapters.AddSortColumn("Name");
searches.Add(sChapters);
var sLeaders = GetOrganizationalLayerLeaderSearch(targetOrganizationalLayer.ID);
searches.Add(sLeaders);
var searchResults = APIExtensions.GetMultipleSearchResults(searches, 0, null);
dvChapters = new DataView(searchResults.Single(x => x.ID == msChapter.CLASS_NAME).Table);
leader = ConvertLeaderSearchResult(searchResults.Single(x => x.ID == "OrganizationalLayerLeader"));
}
public static msBusinessUnit GetDefaultBusinessUnit()
{
var key = "GetDefaultBusinessUnit";
return(SessionManager.Get(key, () =>
{
using (var api = ConciergeAPIProxyGenerator.GenerateProxy())
{
var s = new Search {
Type = msBusinessUnit.CLASS_NAME
};
s.AddOutputColumn("ID");
s.AddCriteria(Expr.Equals("IsDefault", true));
var businessUnit = api.GetObjectBySearch(s, null).ResultValue.ConvertTo <msBusinessUnit>();
return businessUnit;
}
}));
}
protected override void InitializePage()
{
base.InitializePage();
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.SavedPaymentMethod.Name");
s.AddOutputColumn("FutureBillingAmount");
s.AddOutputColumn("PastBillingAmount");
s.AddOutputColumn("Status");
DataRow dr = APIExtensions.GetSearchResult(s, 0, null).Table.Rows[0];
if (Convert.ToString(dr["Order.BillTo"]) != ConciergeAPI.CurrentEntity.ID)
{
throw new ApplicationException("Access denied");
}
hlOrderNo.Text = GetSearchResult(dr, "Order.LocalID", null);
hlOrderNo.NavigateUrl += targetSchedule["Order"];
lblOrderDate.Text = GetSearchResult(dr, "Order.Date", "d");
lblOrderTotal.Text = GetSearchResult(dr, "Order.Total", "C");
lblAmountRemaining.Text = GetSearchResult(dr, "FutureBillingAmount", "C");
lblAmountAlreadyBilled.Text = GetSearchResult(dr, "PastBillingAmount", "C");
lblStatus.Text = GetSearchResult(dr, "Status");
hlUpdateBilling.NavigateUrl += "?contextID=" + targetSchedule.ID;
hlUpdateBillingInfo2.NavigateUrl = hlUpdateBilling.NavigateUrl;
string info = GetSearchResult(dr, "Order.SavedPaymentMethod.Name");
if (info != null)
{
lblPaymentInfo.Text = info;
}
}
protected void loadDataFromConcierge()
{
Search sSubscription = new Search(msDiscussionTopicSubscription.CLASS_NAME);
sSubscription.AddOutputColumn("ID");
sSubscription.AddOutputColumn("Topic.Name");
sSubscription.AddOutputColumn("Topic.Forum.Name");
sSubscription.AddOutputColumn("Topic.Forum.DiscussionBoard.Name");
sSubscription.AddCriteria(Expr.Equals("Subscriber", ConciergeAPI.CurrentEntity.ID));
sSubscription.AddSortColumn("Topic.Forum.DiscussionBoard.Name");
sSubscription.AddSortColumn("Topic.Forum.Name");
sSubscription.AddSortColumn("Topic.Name");
SearchResult srSubscription = APIExtensions.GetSearchResult(sSubscription, PageStart, PAGE_SIZE);
dtSubscriptions = srSubscription.Table;
SetCurrentPageFromResults(srSubscription, hlFirstPage, hlPrevPage, hlNextPage, lNumPages, null, null,
null, lCurrentPage);
}
private void setupExamRequirements()
{
Search s = new Search("CertificationRequiredExam");
s.AddCriteria(Expr.Equals("Certification", targetCertification.ID));
s.AddOutputColumn("Type.Name");
s.AddOutputColumn("Passed");
s.AddSortColumn("Type.Name");
var dt = APIExtensions.GetSearchResult(s, 0, null).Table;
if (dt.Rows.Count == 0)
{
return;
}
pnlExamRequirements.Visible = true;
rgExams.DataSource = dt;
rgExams.DataBind();
}
protected override void InitializePage()
{
base.InitializePage();
Search s = new Search(msCertification.CLASS_NAME);
s.AddCriteria(Expr.Equals(msCertification.FIELDS.Owner, ConciergeAPI.CurrentEntity.ID));
s.AddOutputColumn("Program.Name");
s.AddOutputColumn("Status.Name");
s.AddOutputColumn("EffectiveDate");
s.AddOutputColumn("ExpirationDate");
s.AddSortColumn("EffectiveDate", true);
var results = APIExtensions.GetSearchResult(s, 0, null);
gvCredits.DataSource = results.Table;
gvCredits.DataBind();
}
private void setupRecommendations()
{
Search s = new Search(msCertificationRecommendation.CLASS_NAME);
s.AddCriteria(Expr.Equals(msCertificationRecommendation.FIELDS.Certification, targetCertification.ID));
s.AddOutputColumn("Name");
s.AddOutputColumn("EmailAddress");
s.AddOutputColumn("Status");
var dt = APIExtensions.GetSearchResult(s, 0, null).Table;
if (dt.Rows.Count == 0)
{
return;
}
pnlRecommendations.Visible = true;
rgRecommendations.DataSource = dt;
rgRecommendations.DataBind();
}
protected override void InitializePage()
{
base.InitializePage();
Search s = new Search(msCEUCredit.CLASS_NAME);
s.AddCriteria(Expr.Equals("Owner", ConciergeAPI.CurrentEntity.ID));
s.AddOutputColumn("CreditDate");
s.AddOutputColumn("Type.Name");
s.AddOutputColumn("Quantity");
s.AddOutputColumn("ComponentRegistration.Component.Name");
s.AddOutputColumn(msCEUCredit.FIELDS.Verified);
s.AddOutputColumn(msCEUCredit.FIELDS.SelfReported);
s.AddOutputColumn("Event.Name");
gvCredits.DataSource = APIExtensions.GetSearchResult(s, 0, null).Table;
gvCredits.DataBind();
btnReport.Visible = PortalConfiguration.CurrentConfig.CEUSelfReportingMode != CertificationsSelfReportingMode.Disabled;
}
protected void addRequiredSearchParameters()
{
if (!targetSearch.OutputColumns.Exists(x => x.Name == "Owner.ID"))
{
targetSearch.OutputColumns.Add(new SearchOutputColumn {
Name = "Owner.ID", DisplayName = "Owner ID"
});
}
if (!targetSearch.Criteria.Exists(x => x.FieldName == "TerminationDate"))
{
SearchOperationGroup terminationGroup = new SearchOperationGroup {
FieldName = "TerminationDate"
};
terminationGroup.Criteria.Add(Expr.Equals("TerminationDate", null));
terminationGroup.Criteria.Add(Expr.IsGreaterThan("TerminationDate", DateTime.Now));
terminationGroup.GroupType = SearchOperationGroupType.Or;
targetSearch.AddCriteria(terminationGroup);
}
}
/// <summary>
/// Executes all querys required for the current page against the Concierge API in a multi-search fashion to improve performance
/// </summary>
private void loadDataFromConcierge()
{
var searchesToRun = new List <Search>();
//Committee terms related to target committee
var sCommitteeTerm = new Search {
Type = msCommitteeTerm.CLASS_NAME
};
sCommitteeTerm.AddOutputColumn("ID");
sCommitteeTerm.AddOutputColumn("Name");
sCommitteeTerm.AddCriteria(Expr.Equals("Committee.ID", ContextID));
sCommitteeTerm.AddSortColumn("Name", true);
searchesToRun.Add(sCommitteeTerm);
//Committee Memberships related to target committee
var sCommitteeMembership = new Search {
Type = msCommitteeMembership.CLASS_NAME
};
sCommitteeMembership.AddOutputColumn("Member.ID");
sCommitteeMembership.AddOutputColumn("Member.Name");
sCommitteeMembership.AddOutputColumn("Position.Name");
sCommitteeMembership.AddOutputColumn("EffectiveStartDate");
sCommitteeMembership.AddOutputColumn("EffectiveEndDate");
sCommitteeMembership.AddOutputColumn("IsCurrent");
sCommitteeMembership.AddOutputColumn("Term.ID");
sCommitteeMembership.AddCriteria(Expr.Equals("Committee.ID", ContextID));
////sCommitteeMembership.AddSortColumn("Position.DisplayOrder");
////sCommitteeMembership.AddSortColumn("Position.Name");
sCommitteeMembership.AddSortColumn("Member.Name");
searchesToRun.Add(sCommitteeMembership);
var results = APIExtensions.GetMultipleSearchResults(searchesToRun, 0, null);
// now, assign the search results
dvCommitteeTerms = new DataView(results[0].Table);
dvCommitteeMembers = new DataView(results[1].Table);
}
protected void loadDataFromConcierge()
{
Search sJobPostings = new Search {
Type = msJobPosting.CLASS_NAME
};
sJobPostings.AddOutputColumn("ID");
sJobPostings.AddOutputColumn("LocalID");
sJobPostings.AddOutputColumn("Name");
sJobPostings.AddOutputColumn("PostOn");
sJobPostings.AddOutputColumn("ExpirationDate");
sJobPostings.AddCriteria(Expr.Equals("Owner", ConciergeAPI.CurrentEntity.ID));
// MS-4857 - show newest first
sJobPostings.AddSortColumn("PostOn", true);
SearchResult srJobPostings = APIExtensions.GetSearchResult(sJobPostings, 0, null);
dvJobPostings = new DataView(srJobPostings.Table);
}
