public static DomainDateProviderIpRecord CloneWithDifferentProvider(this DomainDateProviderIpRecord record,
string provider)
{
return(new DomainDateProviderIpRecord(record.Id, record.Domain, record.Date,
provider, record.OriginalProvider, record.Ip, record.Hostname, record.SpfPassDkimPassNone,
record.SpfPassDkimFailNone, record.SpfFailDkimPassNone, record.SpfFailDkimFailNone,
record.SpfPassDkimPassQuarantine, record.SpfPassDkimFailQuarantine, record.SpfFailDkimPassQuarantine,
record.SpfFailDkimFailQuarantine, record.SpfPassDkimPassReject, record.SpfPassDkimFailReject,
record.SpfFailDkimPassReject, record.SpfFailDkimFailReject, record.SpfMisaligned, record.DkimMisaligned,
record.ProxyBlockListCount, record.SuspiciousNetworkBlockListCount, record.HijackedNetworkBlockListCount,
record.EndUserNetworkBlockListCount, record.SpamSourceBlockListCount, record.MalwareBlockListCount,
record.EndUserBlockListCount, record.BounceReflectorBlockListCount, record.Forwarded, record.SampledOut,
record.TrustedForwarder, record.MailingList, record.LocalPolicy, record.Arc, record.OtherOverrideReason));
}
private static IEnumerable <KeyValuePair <string, object> > MapParameters(DomainDateProviderIpRecord record)
{
yield return(KeyValuePair.Create <string, object>("domain", record.Domain));
yield return(KeyValuePair.Create <string, object>("date", record.Date.ToString("yyyy-MM-dd")));
yield return(KeyValuePair.Create <string, object>("provider", record.Provider));
yield return(KeyValuePair.Create <string, object>("original_provider", record.Provider));
yield return(KeyValuePair.Create <string, object>("ip", record.Ip));
yield return(KeyValuePair.Create <string, object>("hostname", record.Hostname));
yield return(KeyValuePair.Create <string, object>("spf_pass_dkim_pass_none", record.SpfPassDkimPassNone));
yield return(KeyValuePair.Create <string, object>("spf_pass_dkim_fail_none", record.SpfPassDkimFailNone));
yield return(KeyValuePair.Create <string, object>("spf_fail_dkim_pass_none", record.SpfFailDkimPassNone));
yield return(KeyValuePair.Create <string, object>("spf_fail_dkim_fail_none", record.SpfFailDkimFailNone));
yield return(KeyValuePair.Create <string, object>("spf_pass_dkim_pass_quarantine", record.SpfPassDkimPassQuarantine));
yield return(KeyValuePair.Create <string, object>("spf_pass_dkim_fail_quarantine", record.SpfPassDkimFailQuarantine));
yield return(KeyValuePair.Create <string, object>("spf_fail_dkim_pass_quarantine", record.SpfFailDkimPassQuarantine));
yield return(KeyValuePair.Create <string, object>("spf_fail_dkim_fail_quarantine", record.SpfFailDkimFailQuarantine));
yield return(KeyValuePair.Create <string, object>("spf_pass_dkim_pass_reject", record.SpfPassDkimPassReject));
yield return(KeyValuePair.Create <string, object>("spf_pass_dkim_fail_reject", record.SpfPassDkimFailReject));
yield return(KeyValuePair.Create <string, object>("spf_fail_dkim_pass_reject", record.SpfFailDkimPassReject));
yield return(KeyValuePair.Create <string, object>("spf_fail_dkim_fail_reject", record.SpfFailDkimFailReject));
yield return(KeyValuePair.Create <string, object>("spf_misaligned", record.SpfMisaligned));
yield return(KeyValuePair.Create <string, object>("dkim_misaligned", record.DkimMisaligned));
yield return(KeyValuePair.Create <string, object>("blocklists_proxy", record.ProxyBlockListCount));
yield return(KeyValuePair.Create <string, object>("blocklists_hijackednetwork", record.HijackedNetworkBlockListCount));
yield return(KeyValuePair.Create <string, object>("blocklists_suspiciousnetwork", record.SuspiciousNetworkBlockListCount));
yield return(KeyValuePair.Create <string, object>("blocklists_endusernetwork", record.EndUserNetworkBlockListCount));
yield return(KeyValuePair.Create <string, object>("blocklists_spamsource", record.SpamSourceBlockListCount));
yield return(KeyValuePair.Create <string, object>("blocklists_malware", record.MalwareBlockListCount));
yield return(KeyValuePair.Create <string, object>("blocklists_enduser", record.EndUserBlockListCount));
yield return(KeyValuePair.Create <string, object>("blocklists_bouncereflector", record.BounceReflectorBlockListCount));
yield return(KeyValuePair.Create <string, object>("por_forwarded", record.Forwarded));
yield return(KeyValuePair.Create <string, object>("por_sampledout", record.SampledOut));
yield return(KeyValuePair.Create <string, object>("por_trustedforwarder", record.TrustedForwarder));
yield return(KeyValuePair.Create <string, object>("por_mailinglist", record.MailingList));
yield return(KeyValuePair.Create <string, object>("por_localpolicy", record.LocalPolicy));
yield return(KeyValuePair.Create <string, object>("por_arc", record.Arc));
yield return(KeyValuePair.Create <string, object>("por_other", record.OtherOverrideReason));
}
private long TallyAllCounts(DomainDateProviderIpRecord record)
{
return(record.SpfPassDkimPassNone + record.SpfPassDkimFailNone + record.SpfFailDkimPassNone + record.SpfFailDkimFailNone +
record.SpfPassDkimPassQuarantine + record.SpfPassDkimFailQuarantine + record.SpfFailDkimPassQuarantine + record.SpfFailDkimFailQuarantine +
record.SpfPassDkimPassReject + record.SpfPassDkimFailReject + record.SpfFailDkimPassReject + record.SpfFailDkimFailReject);
}
