Пример #1
0
 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")
     });
 }
Пример #2
0
        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);
        }
Пример #3
0
 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()
     });
 }
Пример #4
0
        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;
        }
Пример #5
0
 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")
     };
 }