public DojoMember RequestMember(DojoOrganization organization, string organizationID) { DojoMembershipManager m = new DojoMembershipManager(); DojoMembershipCollection c = m.GetCollection("OrganizationID=" + organization.ID.ToString() + " AND " + "OrganizationMembershipID='" + organizationID + "'", string.Empty, DojoMembershipFlags.Member, DojoMembershipFlags.MemberMemberType, DojoMembershipFlags.MemberPrivateContact, DojoMembershipFlags.MemberEmergencyContact); if (c.Count < 1) { throw(new Exception("Cannot find member with the id requested.")); } if (c.Count > 1) { throw(new Exception("More than one member exists with the id requested.")); } return(c[0].Member); }
/// <summary> /// Duplicates DojoMembership object into a database; may or may not be the same database /// as the parent object. /// </summary> /// <returns> A new DojoMembership object reflecting the replicated DojoMembership object.</returns> public DojoMembership Duplicate() { DojoMembership clonedDojoMembership = this.Clone(); // Insert must be called after children are replicated! clonedDojoMembership.iD = DojoMembershipManager._insert(clonedDojoMembership); clonedDojoMembership.isSynced = true; return(clonedDojoMembership); }
/// <summary> /// Ensures that the object's fields and children are /// pre-loaded before any updates or reads. /// </summary> public void EnsurePreLoad() { if (!isPlaceHolder) { return; } DojoMembershipManager._fill(this); isPlaceHolder = false; }
/// <summary> /// Render this control to the output parameter specified. /// </summary> /// <param name="output"> The HTML writer to write out to </param> protected override void RenderContent(HtmlTextWriter output) { DojoMembershipManager m = new DojoMembershipManager(); DojoMembershipCollection dojoMembershipCollection = m.GetCollection(string.Empty, "Member_PrivateContact.LastName, Member_PrivateContact.FirstName, Member_PrivateContact.LastName", DojoMembershipFlags.Member, DojoMembershipFlags.MemberPrivateContact, DojoMembershipFlags.MembershipTemplate); // Render Header Row this.headerLockEnabled = true; RenderRow(this.HeaderRowCssClass, "Member", "Name"); bool rowflag = false; string rowCssClass; // // Render Records // foreach (DojoMembership dojoMembership in dojoMembershipCollection) { if (rowflag) { rowCssClass = defaultRowCssClass; } else { rowCssClass = alternateRowCssClass; } rowflag = !rowflag; output.WriteBeginTag("tr"); output.WriteAttribute("i", dojoMembership.ID.ToString()); output.WriteLine(HtmlTextWriter.TagRightChar); output.Indent++; output.WriteBeginTag("td"); output.WriteAttribute("class", rowCssClass); output.Write(HtmlTextWriter.TagRightChar); output.WriteLine(dojoMembership.Member.PrivateContact.FullName); output.WriteEndTag("td"); output.WriteBeginTag("td"); output.WriteAttribute("class", rowCssClass); output.Write(HtmlTextWriter.TagRightChar); output.WriteLine(dojoMembership.MembershipTemplate.Name); output.WriteEndTag("td"); output.Indent--; output.WriteEndTag("tr"); output.WriteLine(); } }
/// <summary> /// Gets a member's prior membership based on the template provided. If the member's /// membership has an associated root membership template that matches the template, /// then it will still be matched. /// </summary> /// <param name="member"></param> /// <param name="template"></param> /// <returns></returns> public DojoMembership getPrior(DojoMember member, DojoMembershipTemplate template) { if (priorMatch(member.Membership1, template)) { return(member.Membership1); } if (priorMatch(member.Membership2, template)) { return(member.Membership2); } if (priorMatch(member.Membership3, template)) { return(member.Membership3); } if (priorMatch(member.Membership4, template)) { return(member.Membership4); } if (priorMatch(member.Membership5, template)) { return(member.Membership5); } else if (member.Membership5 != null) { // Go looking for the latest membership that matches // the template's ID, since every membership slot was // full. SORT NEWEST ON TOP DojoMembershipManager m = new DojoMembershipManager(); DojoMembershipCollection memberships = m.GetCollection(1, "MembershipTemplateID=" + template.ID.ToString() + (template.RootTemplate != null ? " OR " + "MembershipTemplate.RootTemplateID=" + template.RootTemplate.ID : ""), "EndDate DESC", null); if (memberships.Count > 0) { return(memberships[0]); } } return(null); }
/// <summary> /// Saves the DojoMembership object state to the database. /// </summary> public int Save() { if (isSynced) { return(iD); } if (iD == -1) { throw (new Exception("Invalid record; cannot be saved.")); } if (iD == 0) { iD = DojoMembershipManager._insert(this); } else { DojoMembershipManager._update(this); } isSynced = iD != -1; return(iD); }
/// <summary> /// Render this control to the output parameter specified. /// </summary> /// <param name="output"> The HTML writer to write out to </param> protected override void RenderContent(HtmlTextWriter output) { DojoMembershipManager m = new DojoMembershipManager(); DojoMembershipCollection dojoMembershipCollection = m.GetCollection(string.Empty, string.Empty, null); // Render Header Row this.headerLockEnabled = true; RenderRow(this.HeaderRowCssClass, ); bool rowflag = false; string rowCssClass; // // Render Records // foreach (DojoMembership dojoMembership in dojoMembershipCollection) { if (rowflag) { rowCssClass = defaultRowCssClass; } else { rowCssClass = alternateRowCssClass; } rowflag = !rowflag; output.WriteBeginTag("tr"); output.WriteAttribute("i", dojoMembership.ID.ToString()); output.WriteLine(HtmlTextWriter.TagRightChar); output.Indent++; output.Indent--; output.WriteEndTag("tr"); output.WriteLine(); } }
/// <summary> /// Processes dues invoices, payments and organization memberships /// </summary> /// <returns>Returns active student count.</returns> public int RunDuesScan() { bool isActive = false; bool isParentActive = false; bool isPastDue = false; int activeCount = 0; DojoMemberManager mm = new DojoMemberManager(); DojoMemberCollection members = mm.GetCollection(string.Empty, string.Empty, null); DojoMembershipManager membershipManager = new DojoMembershipManager(); DojoMembershipCollection memberships = membershipManager.GetCollection(string.Empty, string.Empty, DojoMembershipFlags.InvoiceLine, DojoMembershipFlags.InvoiceLineInvoice); foreach (DojoMember member in members) { isActive = false; isParentActive = false; isPastDue = false; // Search Memberships foreach (DojoMembership membership in memberships) { if (membership.Member.ID == member.ID) { // Check Primary Organization Membership if (membership.Organization.ID == _primaryOrganization.ID) { isActive |= activityCheck(membership); isPastDue |= pastDueCheck(membership); } if (membership.Organization.ID == _parentOrganization.ID) { isParentActive |= activityCheck(membership); } } } if (member.IsPrimaryOrgActive != isActive | member.IsPastDue != isPastDue) { member.IsPrimaryOrgActive = isActive; member.IsPastDue = isPastDue; member.LastMembershipScan = DateTime.Now; if (!_testMode) { member.Save(); } } if (isActive) { activeCount++; } } return(activeCount); }
private void bindDropDownLists() { #region Bind General Child Data msMemberType.Items.Add(new ListItem("Null", "Null")); DojoMemberTypeManager memberTypeManager = new DojoMemberTypeManager(); DojoMemberTypeCollection memberTypeCollection = memberTypeManager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMemberType memberType in memberTypeCollection) { ListItem i = new ListItem(memberType.ToString(), memberType.ID.ToString()); msMemberType.Items.Add(i); } msPublicContact.Items.Add(new ListItem("Null", "Null")); GreyFoxContactManager publicContactManager = new GreyFoxContactManager("kitTessen_Members_PublicContacts"); GreyFoxContactCollection publicContactCollection = publicContactManager.GetCollection(string.Empty, string.Empty); foreach (GreyFoxContact publicContact in publicContactCollection) { ListItem i = new ListItem(publicContact.ToString(), publicContact.ID.ToString()); msPublicContact.Items.Add(i); } msParentMember.Items.Add(new ListItem("Null", "Null")); DojoMemberManager parentMemberManager = new DojoMemberManager(); DojoMemberCollection parentMemberCollection = parentMemberManager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMember parentMember in parentMemberCollection) { ListItem i = new ListItem(parentMember.ToString(), parentMember.ID.ToString()); msParentMember.Items.Add(i); } #endregion #region Bind Membership Child Data msPrimaryOrgMembership.Items.Add(new ListItem("Null", "Null")); DojoMembershipManager primaryOrgMembershipManager = new DojoMembershipManager(); DojoMembershipCollection primaryOrgMembershipCollection = primaryOrgMembershipManager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMembership primaryOrgMembership in primaryOrgMembershipCollection) { ListItem i = new ListItem(primaryOrgMembership.ToString(), primaryOrgMembership.ID.ToString()); msPrimaryOrgMembership.Items.Add(i); } msParentOrgMembership.Items.Add(new ListItem("Null", "Null")); DojoMembershipManager parentOrgMembershipManager = new DojoMembershipManager(); DojoMembershipCollection parentOrgMembershipCollection = parentOrgMembershipManager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMembership parentOrgMembership in parentOrgMembershipCollection) { ListItem i = new ListItem(parentOrgMembership.ToString(), parentOrgMembership.ID.ToString()); msParentOrgMembership.Items.Add(i); } #endregion #region Bind Attendance Child Data msInstructor1.Items.Add(new ListItem("Null", "Null")); DojoMemberManager instructor1Manager = new DojoMemberManager(); DojoMemberCollection instructor1Collection = instructor1Manager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMember instructor1 in instructor1Collection) { ListItem i = new ListItem(instructor1.ToString(), instructor1.ID.ToString()); msInstructor1.Items.Add(i); } msInstructor2.Items.Add(new ListItem("Null", "Null")); DojoMemberManager instructor2Manager = new DojoMemberManager(); DojoMemberCollection instructor2Collection = instructor2Manager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMember instructor2 in instructor2Collection) { ListItem i = new ListItem(instructor2.ToString(), instructor2.ID.ToString()); msInstructor2.Items.Add(i); } msInstructor3.Items.Add(new ListItem("Null", "Null")); DojoMemberManager instructor3Manager = new DojoMemberManager(); DojoMemberCollection instructor3Collection = instructor3Manager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMember instructor3 in instructor3Collection) { ListItem i = new ListItem(instructor3.ToString(), instructor3.ID.ToString()); msInstructor3.Items.Add(i); } #endregion #region Bind Activity Child Data msPromotionFlags.Items.Add(new ListItem("Null", "Null")); DojoPromotionFlagManager promotionFlagsManager = new DojoPromotionFlagManager(); DojoPromotionFlagCollection promotionFlagsCollection = promotionFlagsManager.GetCollection(string.Empty, string.Empty); foreach (DojoPromotionFlag promotionFlags in promotionFlagsCollection) { ListItem i = new ListItem(promotionFlags.ToString(), promotionFlags.ID.ToString()); msPromotionFlags.Items.Add(i); } msRank.Items.Add(new ListItem("Null", "Null")); DojoRankManager rankManager = new DojoRankManager(); DojoRankCollection rankCollection = rankManager.GetCollection(string.Empty, string.Empty, null); foreach (DojoRank rank in rankCollection) { ListItem i = new ListItem(rank.ToString(), rank.ID.ToString()); msRank.Items.Add(i); } #endregion #region Bind Security Child Data #endregion #region Bind Rappahanock Child Data msCustomer.Items.Add(new ListItem("Null", "Null")); RHCustomerManager customerManager = new RHCustomerManager(); RHCustomerCollection customerCollection = customerManager.GetCollection(string.Empty, string.Empty, null); foreach (RHCustomer customer in customerCollection) { ListItem i = new ListItem(customer.ToString(), customer.ID.ToString()); msCustomer.Items.Add(i); } #endregion }
/// <summary> /// Overwrites and existing DojoMembership object in the database. /// </summary> public void Overwrite(int id) { iD = id; DojoMembershipManager._update(this); isSynced = true; }
public void Delete() { DojoMembershipManager._delete(this.iD); this.iD = 0; isSynced = false; }
public DojoMembership(int id) { this.iD = id; isSynced = DojoMembershipManager._fill(this); }
private void bind() { DojoMemberManager dojoMemberManager = new DojoMemberManager(); DojoMemberCollection dojoMemberCollection = dojoMemberManager.GetCollection(string.Empty, string.Empty); foreach (DojoMember itemObject in dojoMemberCollection) { ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem(); item.Text = itemObject.ToString(); item.Value = itemObject.ID.ToString(); comboMember.Items.Add(item); } DojoOrganizationManager dojoOrganizationManager = new DojoOrganizationManager(); DojoOrganizationCollection dojoOrganizationCollection = dojoOrganizationManager.GetCollection(string.Empty, string.Empty); foreach (DojoOrganization itemObject in dojoOrganizationCollection) { ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem(); item.Text = itemObject.ToString(); item.Value = itemObject.ID.ToString(); comboOrganization.Items.Add(item); } DojoMembershipManager dojoMembershipManager = new DojoMembershipManager(); DojoMembershipCollection dojoMembershipCollection = dojoMembershipManager.GetCollection(string.Empty, string.Empty); ddParent.Items.Add(new ListItem(" ", "null")); foreach (DojoMembership itemObject in dojoMembershipCollection) { ddParent.Items.Add(new ListItem(itemObject.ToString(), itemObject.ID.ToString())); } DojoMemberTypeTemplateManager dojoMemberTypeTemplateManager = new DojoMemberTypeTemplateManager(); DojoMemberTypeTemplateCollection dojoMemberTypeTemplateCollection = dojoMemberTypeTemplateManager.GetCollection(string.Empty, string.Empty); foreach (DojoMemberTypeTemplate itemObject in dojoMemberTypeTemplateCollection) { ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem(); item.Text = itemObject.ToString(); item.Value = itemObject.ID.ToString(); comboMemberTypeTemplate.Items.Add(item); } DojoMembershipTemplateManager dojoMembershipTemplateManager = new DojoMembershipTemplateManager(); DojoMembershipTemplateCollection dojoMembershipTemplateCollection = dojoMembershipTemplateManager.GetCollection(string.Empty, string.Empty); foreach (DojoMembershipTemplate itemObject in dojoMembershipTemplateCollection) { ComponentArt.Web.UI.ComboBoxItem item = new ComponentArt.Web.UI.ComboBoxItem(); item.Text = itemObject.ToString(); item.Value = itemObject.ID.ToString(); comboMembershipTemplate.Items.Add(item); } RHInvoiceLineManager rHInvoiceLineManager = new RHInvoiceLineManager(); RHInvoiceLineCollection rHInvoiceLineCollection = rHInvoiceLineManager.GetCollection(string.Empty, string.Empty); ddInvoiceLine.Items.Add(new ListItem(" ", "null")); foreach (RHInvoiceLine itemObject in rHInvoiceLineCollection) { ddInvoiceLine.Items.Add(new ListItem(itemObject.ToString(), itemObject.ID.ToString())); } }
private void bindDropDownLists() { #region Bind Default Child Data msMember.Items.Add(new ListItem("Null", "Null")); DojoMemberManager memberManager = new DojoMemberManager(); DojoMemberCollection memberCollection = memberManager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMember member in memberCollection) { ListItem i = new ListItem(member.ToString(), member.ID.ToString()); msMember.Items.Add(i); } msMemberType.Items.Add(new ListItem("Null", "Null")); DojoMemberTypeManager memberTypeManager = new DojoMemberTypeManager(); DojoMemberTypeCollection memberTypeCollection = memberTypeManager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMemberType memberType in memberTypeCollection) { ListItem i = new ListItem(memberType.ToString(), memberType.ID.ToString()); msMemberType.Items.Add(i); } msOrganization.Items.Add(new ListItem("Null", "Null")); DojoOrganizationManager organizationManager = new DojoOrganizationManager(); DojoOrganizationCollection organizationCollection = organizationManager.GetCollection(string.Empty, string.Empty, null); foreach (DojoOrganization organization in organizationCollection) { ListItem i = new ListItem(organization.ToString(), organization.ID.ToString()); msOrganization.Items.Add(i); } msParentMembership.Items.Add(new ListItem("Null", "Null")); DojoMembershipManager parentMembershipManager = new DojoMembershipManager(); DojoMembershipCollection parentMembershipCollection = parentMembershipManager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMembership parentMembership in parentMembershipCollection) { ListItem i = new ListItem(parentMembership.ToString(), parentMembership.ID.ToString()); msParentMembership.Items.Add(i); } msSourceTemplate.Items.Add(new ListItem("Null", "Null")); DojoMembershipTemplateManager sourceTemplateManager = new DojoMembershipTemplateManager(); DojoMembershipTemplateCollection sourceTemplateCollection = sourceTemplateManager.GetCollection(string.Empty, string.Empty, null); foreach (DojoMembershipTemplate sourceTemplate in sourceTemplateCollection) { ListItem i = new ListItem(sourceTemplate.ToString(), sourceTemplate.ID.ToString()); msSourceTemplate.Items.Add(i); } #endregion #region Bind Rappahanock Child Data msInvoiceLine.Items.Add(new ListItem("Null", "Null")); RHInvoiceLineManager invoiceLineManager = new RHInvoiceLineManager(); RHInvoiceLineCollection invoiceLineCollection = invoiceLineManager.GetCollection(string.Empty, string.Empty, null); foreach (RHInvoiceLine invoiceLine in invoiceLineCollection) { ListItem i = new ListItem(invoiceLine.ToString(), invoiceLine.ID.ToString()); msInvoiceLine.Items.Add(i); } #endregion }