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
}
