private MpPledge MapRecordToPledge(Dictionary <string, object> record) { return(new MpPledge() { PledgeId = record.ToInt("Pledge_ID"), PledgeCampaignId = record.ToInt("Pledge_Campaign_ID"), DonorId = record.ToInt("Donor_ID"), PledgeStatus = record.ToString("Pledge_Status"), CampaignName = record.ToString("Campaign_Name"), PledgeTotal = record["Total_Pledge"] as decimal? ?? 0, PledgeDonations = record["Donation_Total"] as decimal? ?? 0, CampaignStartDate = record.ToDate("Start_Date"), CampaignEndDate = record.ToDate("End_Date"), CampaignTypeId = record.ToInt("Pledge_Campaign_Type_ID"), CampaignTypeName = record.ToString("Campaign_Type") }); }
private static MpMyContact ParseProfileRecord(Dictionary <string, object> recordsDict) { var contact = new MpMyContact { Address_ID = recordsDict.ToNullableInt("Address_ID"), Address_Line_1 = recordsDict.ToString("Address_Line_1"), Address_Line_2 = recordsDict.ToString("Address_Line_2"), Congregation_ID = recordsDict.ToNullableInt("Congregation_ID"), Household_ID = recordsDict.ToInt("Household_ID"), Household_Name = recordsDict.ToString("Household_Name"), City = recordsDict.ToString("City"), State = recordsDict.ToString("State"), County = recordsDict.ToString("County"), Postal_Code = recordsDict.ToString("Postal_Code"), Contact_ID = recordsDict.ToInt("Contact_ID"), Date_Of_Birth = recordsDict.ToDateAsString("Date_of_Birth"), Email_Address = recordsDict.ToString("Email_Address"), Employer_Name = recordsDict.ToString("Employer_Name"), First_Name = recordsDict.ToString("First_Name"), Foreign_Country = recordsDict.ToString("Foreign_Country"), Gender_ID = recordsDict.ToNullableInt("Gender_ID"), Home_Phone = recordsDict.ToString("Home_Phone"), Current_School = recordsDict.ToString("Current_School"), Last_Name = recordsDict.ToString("Last_Name"), Maiden_Name = recordsDict.ToString("Maiden_Name"), Marital_Status_ID = recordsDict.ToNullableInt("Marital_Status_ID"), Middle_Name = recordsDict.ToString("Middle_Name"), Mobile_Carrier = recordsDict.ToNullableInt("Mobile_Carrier_ID"), Mobile_Phone = recordsDict.ToString("Mobile_Phone"), Nickname = recordsDict.ToString("Nickname"), Age = recordsDict.ToInt("Age"), Passport_Number = recordsDict.ToString("Passport_Number"), Passport_Country = recordsDict.ToString("Passport_Country"), Passport_Expiration = ParseExpirationDate(recordsDict.ToNullableDate("Passport_Expiration")), Passport_Firstname = recordsDict.ToString("Passport_Firstname"), Passport_Lastname = recordsDict.ToString("Passport_Lastname"), Passport_Middlename = recordsDict.ToString("Passport_Middlename") }; if (recordsDict.ContainsKey("Participant_Start_Date")) { contact.Participant_Start_Date = recordsDict.ToDate("Participant_Start_Date"); } if (recordsDict.ContainsKey("Attendance_Start_Date")) { contact.Attendance_Start_Date = recordsDict.ToNullableDate("Attendance_Start_Date"); } if (recordsDict.ContainsKey("ID_Card")) { contact.ID_Number = recordsDict.ToString("ID_Card"); } return(contact); }
public MpGroup MapRecordToMpGroup(Dictionary <string, object> record) { return(new MpGroup { GroupId = record.ToInt("Group_ID"), CongregationId = record.ToInt("Congregation_ID"), KidsWelcome = (record.ContainsKey("Kids_Welcome") ? record["Kids_Welcome"] as bool? : null), Name = record.ToString("Group_Name"), GroupRoleId = record.ContainsKey("Group_Role_ID") ? record.ToInt("Group_Role_ID") : -1, GroupDescription = record.ToString("Description"), MinistryId = record.ToInt("Ministry_ID"), ContactId = record.ToInt("Primary_Contact"), PrimaryContactName = record.ContainsKey("Primary_Contact_Name") ? record.ToString("Primary_Contact_Name") : record.ToString("Primary_Contact_Text"), PrimaryContactEmail = record.ContainsKey("Primary_Contact_Email") ? record.ToString("Primary_Contact_Email") : string.Empty, GroupType = record.ToInt("Group_Type_ID"), GroupTypeName = record.ContainsKey("Group_Type_Name") ? record.ToString("Group_Type_Name") : string.Empty, StartDate = record.ToDate("Start_Date"), EndDate = record.ToNullableDate("End_Date"), MeetingDayId = record.ToInt("Meeting_Day_ID"), MeetingDay = (record.ContainsKey("Meeting_Day") ? record.ToString("Meeting_Day") : (record.ContainsKey("Meeting_Day_ID_Text") ? record.ToString("Meeting_Day_ID_Text") : string.Empty)), MeetingTime = !string.IsNullOrEmpty(record.ToString("Meeting_Time")) ? DateTime.Parse(record.ToString("Meeting_Time")).ToShortTimeString() : string.Empty, MeetingFrequency = (record.ContainsKey("Meeting_Frequency") ? record.ToString("Meeting_Frequency") : ((record.ContainsKey("Meeting_Frequency_ID_Text") ? record.ToString("Meeting_Frequency_ID_Text") : string.Empty))), AvailableOnline = record.ToBool("Available_Online"), MaximumAge = (record.ContainsKey("Maximum_Age") ? record["Maximum_Age"] as int? : null), RemainingCapacity = (record.ContainsKey("Remaining_Capacity") ? record["Remaining_Capacity"] as int? : null), Address = record.ContainsKey("Address_ID") ? new MpAddress() { Address_ID = record.ToInt("Address_ID"), Address_Line_1 = record.ToString("Address_Line_1"), Address_Line_2 = record.ToString("Address_Line_2"), City = record.ToString("City"), State = record.ToString("State"), Postal_Code = record.ToString("Zip_Code"), Foreign_Country = record.ToString("Foreign_Country") } : new MpAddress() }); }
private static MyContact ParseProfileRecord(Dictionary<string, object> recordsDict) { var contact = new MyContact { Address_ID = recordsDict.ToNullableInt("Address_ID"), Address_Line_1 = recordsDict.ToString("Address_Line_1"), Address_Line_2 = recordsDict.ToString("Address_Line_2"), Congregation_ID = recordsDict.ToNullableInt("Congregation_ID"), Household_ID = recordsDict.ToInt("Household_ID"), Household_Name = recordsDict.ToString("Household_Name"), City = recordsDict.ToString("City"), State = recordsDict.ToString("State"), County = recordsDict.ToString("County"), Postal_Code = recordsDict.ToString("Postal_Code"), Contact_ID = recordsDict.ToInt("Contact_ID"), Date_Of_Birth = recordsDict.ToDateAsString("Date_of_Birth"), Email_Address = recordsDict.ToString("Email_Address"), Employer_Name = recordsDict.ToString("Employer_Name"), First_Name = recordsDict.ToString("First_Name"), Foreign_Country = recordsDict.ToString("Foreign_Country"), Gender_ID = recordsDict.ToNullableInt("Gender_ID"), Home_Phone = recordsDict.ToString("Home_Phone"), Last_Name = recordsDict.ToString("Last_Name"), Maiden_Name = recordsDict.ToString("Maiden_Name"), Marital_Status_ID = recordsDict.ToNullableInt("Marital_Status_ID"), Middle_Name = recordsDict.ToString("Middle_Name"), Mobile_Carrier = recordsDict.ToNullableInt("Mobile_Carrier_ID"), Mobile_Phone = recordsDict.ToString("Mobile_Phone"), Nickname = recordsDict.ToString("Nickname"), Age = recordsDict.ToInt("Age"), Passport_Number = recordsDict.ToString("Passport_Number"), Passport_Country = recordsDict.ToString("Passport_Country"), Passport_Expiration = ParseExpirationDate(recordsDict.ToNullableDate("Passport_Expiration")), Passport_Firstname = recordsDict.ToString("Passport_Firstname"), Passport_Lastname = recordsDict.ToString("Passport_Lastname"), Passport_Middlename = recordsDict.ToString("Passport_Middlename") }; if (recordsDict.ContainsKey("Participant_Start_Date")) { contact.Participant_Start_Date = recordsDict.ToDate("Participant_Start_Date"); } if (recordsDict.ContainsKey("Attendance_Start_Date")) { contact.Attendance_Start_Date = recordsDict.ToNullableDate("Attendance_Start_Date"); } if (recordsDict.ContainsKey("ID_Card")) { contact.ID_Number = recordsDict.ToString("ID_Card"); } return contact; }
private Pledge MapRecordToPledge(Dictionary<string, object> record) { return new Pledge() { PledgeId = record.ToInt("Pledge_ID"), PledgeCampaignId = record.ToInt("Pledge_Campaign_ID"), DonorId = record.ToInt("Donor_ID"), PledgeStatus = record.ToString("Pledge_Status"), CampaignName = record.ToString("Campaign_Name"), PledgeTotal = record["Total_Pledge"] as decimal? ?? 0, PledgeDonations = record["Donation_Total"] as decimal? ?? 0, CampaignStartDate = record.ToDate("Start_Date"), CampaignEndDate = record.ToDate("End_Date"), CampaignTypeId = record.ToInt("Pledge_Campaign_Type_ID"), CampaignTypeName = record.ToString("Campaign_Type") }; }