/// <summary> /// Retrieves all campaign liaisons on record for the specified candidate and committee. /// </summary> /// <param name="candidateID">The ID of the candidate whose liaisons are to be retrieved.</param> /// <param name="committeeID">The ID of the committee whose liaisons are to be retrieved.</param> /// <returns>A collection of all campaign liaisons on record for the specified candidate and committee, indexed by liaison ID.</returns> public Dictionary <byte, Liaison> GetLiaisons(string candidateID, char committeeID) { using (AuthorizedCommitteeTds ds = new AuthorizedCommitteeTds()) { using (CampaignLiaisonsTableAdapter ta = new CampaignLiaisonsTableAdapter()) { ta.Fill(ds.CampaignLiaisons, candidateID, committeeID.ToString()); } Dictionary <byte, Liaison> d = new Dictionary <byte, Liaison>(ds.CampaignLiaisons.Count); foreach (AuthorizedCommitteeTds.CampaignLiaisonsRow row in ds.CampaignLiaisons.Rows) { byte id; if (byte.TryParse(row.LiaisonID, out id)) { d.Add(id, new Liaison(id) { Type = CPConvert.ToLiaisonType(row.LiaisonTypeCode.Trim()) == LiaisonType.Consultant ? EntityType.Consultant : EntityType.Liaison, LiaisonType = CPConvert.ToLiaisonType(row.LiaisonTypeCode.Trim()), ContactOrder = CPConvert.ToContactOrder(row.ContactOrderCode), Honorific = CPConvert.ToHonorific(row.HonorificCode.Trim()), LastName = row.LastName.Trim(), FirstName = row.FirstName.Trim(), MiddleInitial = string.IsNullOrWhiteSpace(row.MI) ? null : row.MI.Trim().ToCharArray()[0] as char?, Address = new PostalAddress() { StreetNumber = row.StreetNumber.Trim(), StreetName = row.StreetName.Trim(), Apartment = row.Apartment.Trim(), City = row.City.Trim(), State = row.State.Trim(), Zip = new ZipCode(row.Zip.Trim()) }, DaytimePhone = new PhoneNumber(row.DaytimePhone.Trim()) { Extension = row.DaytimePhoneExt.Trim() }, EveningPhone = new PhoneNumber(row.EveningPhone.Trim()) { Extension = row.EveningPhoneExt.Trim() }, Fax = new PhoneNumber(row.Fax.Trim()), Email = row.Email.Trim(), EntityName = row.EntityName.Trim(), HasManagerialControl = "Y".Equals(row.HasManagerialControl.Trim(), System.StringComparison.OrdinalIgnoreCase), IsVGLiaison = "Y".Equals(row.IsVGLiaison.Trim(), System.StringComparison.OrdinalIgnoreCase) }); } } return(d); } }
/// <summary> /// Retrieves all authorized committees for a candidate in a specific election cycle. /// </summary> /// <param name="candidateID">The ID of the candidate whose authorized committees are to be retrieved.</param> /// <param name="electionCycle">The election cycle in which to search.</param> /// <returns>A collection of all authorized committees on record for the specified candidate and election cycle.</returns> public AuthorizedCommittees GetAuthorizedCommittees(string candidateID, string electionCycle) { using (AuthorizedCommitteeTds ds = new AuthorizedCommitteeTds()) { using (AuthorizedCommitteesTableAdapter ta = new AuthorizedCommitteesTableAdapter()) { ta.Fill(ds.AuthorizedCommittees, candidateID, electionCycle); } AuthorizedCommittees c = new AuthorizedCommittees(ds.AuthorizedCommittees.Count); foreach (AuthorizedCommitteeTds.AuthorizedCommitteesRow row in ds.AuthorizedCommittees.Rows) { if (string.IsNullOrWhiteSpace(row.CommitteeID)) { continue; } // basic committee info AuthorizedCommittee ac = new AuthorizedCommittee(row.CommitteeID.ToCharArray()[0]) { // authorized committee info NotarizationDate = row.IsSwornDateNull() ? null : row.SwornDate as DateTime?, IsActive = "Y".Equals(row.IsActive.Trim(), StringComparison.CurrentCultureIgnoreCase), IsPrincipal = "Y".Equals(row.IsPrincipal.Trim(), StringComparison.CurrentCultureIgnoreCase), ContactOrder = CPConvert.ToContactOrder(row.TreasurerContactOrder), LastUpdated = row.LastUpdated, // treasurer info Treasurer = new Entity() { Type = EntityType.Treasurer, Honorific = CPConvert.ToHonorific(row.TreasurerHonorificCode.Trim()), LastName = row.TreasurerLastName.Trim(), FirstName = row.TreasurerFirstName.Trim(), MiddleInitial = string.IsNullOrWhiteSpace(row.TreasurerMI) ? null : row.TreasurerMI.Trim().ToCharArray()[0] as char?, Address = new PostalAddress() { StreetNumber = row.TreasurerStreetNumber.Trim(), StreetName = row.TreasurerStreetName.Trim(), Apartment = row.TreasurerApartment.Trim(), City = row.TreasurerCity.Trim(), State = row.TreasurerState.Trim(), Zip = new ZipCode(row.TreasurerZip.Trim()) }, DaytimePhone = new PhoneNumber(row.TreasurerDaytimePhone.Trim()) { Extension = row.TreasurerDaytimePhoneExt.Trim() }, EveningPhone = new PhoneNumber(row.TreasurerEveningPhone.Trim()) { Extension = row.TreasurerEveningPhoneExt.Trim() }, Fax = new PhoneNumber(row.TreasurerFax.Trim()), Email = row.TreasurerEmail.Trim(), ContactOrder = CPConvert.ToContactOrder(row.TreasurerContactOrder), // treasurer employer Employer = new Entity() { Type = EntityType.Employer, LastName = row.TreasurerEmployerName.Trim(), Address = new PostalAddress() { StreetNumber = row.TreasurerEmployerStreetNumber.Trim(), StreetName = row.TreasurerEmployerStreetName.Trim(), City = row.TreasurerEmployerCity.Trim(), State = row.TreasurerEmployerState.Trim(), Zip = new ZipCode(row.TreasurerEmployerZip.Trim()) }, DaytimePhone = new PhoneNumber(row.TreasurerEmployerPhone.Trim()) { Extension = row.TreasurerEmployerPhoneExt.Trim() }, Fax = new PhoneNumber(row.TreasurerEmployerFax.Trim()), } }, // last election info LastElectionDate = row.IsLastElectionDateNull() ? null : row.LastElectionDate as DateTime?, LastElectionOffice = row.LastElectionOffice.Trim(), LastElectionDistrict = row.LastElectionDistrict.Trim(), LastPrimaryParty = row.IsLastPrimaryPartyNull() ? null : row.LastPrimaryParty.Trim() }.LoadCommitteeData(row); // liaisons ac.Liaisons = this.GetLiaisons(candidateID, ac.ID); // bank accounts ac.BankAccounts = this.GetBankAccounts(candidateID, electionCycle, ac.ID); c.Committees.Add(ac.ID, ac); } return(c); } }