private static void CreateParameters(SqliteCommand command, DenormalisedRecord denormalisedRecord) { command.Parameters.AddWithValue("$OriginalUri", denormalisedRecord.OrginalUri ?? string.Empty); command.Parameters.AddWithValue("$OrgName", denormalisedRecord.OrgName ?? string.Empty); command.Parameters.AddWithValue("$Email", denormalisedRecord.Email ?? string.Empty); command.Parameters.AddWithValue("$ExtraContactInfo", denormalisedRecord.ExtraContactInfo ?? string.Empty); command.Parameters.AddWithValue("$BeginDate", denormalisedRecord.BeginDate.ToString() ?? string.Empty); command.Parameters.AddWithValue("$EndDate", denormalisedRecord.EndDate.ToString() ?? string.Empty); command.Parameters.AddWithValue("$Domain", denormalisedRecord.Domain ?? string.Empty); command.Parameters.AddWithValue("$Adkim", denormalisedRecord.Adkim?.ToString() ?? string.Empty); command.Parameters.AddWithValue("$Aspf", denormalisedRecord.Aspf?.ToString() ?? string.Empty); command.Parameters.AddWithValue("$P", denormalisedRecord.P.ToString() ?? string.Empty); command.Parameters.AddWithValue("$Sp", denormalisedRecord.Sp?.ToString() ?? string.Empty); command.Parameters.AddWithValue("$Pct", denormalisedRecord.Pct?.ToString() ?? string.Empty); command.Parameters.AddWithValue("$SourceIp", denormalisedRecord.SourceIp ?? string.Empty); command.Parameters.AddWithValue("$Count", denormalisedRecord.Count.ToString() ?? string.Empty); command.Parameters.AddWithValue("$Disposition", denormalisedRecord.Disposition?.ToString() ?? string.Empty); command.Parameters.AddWithValue("$Dkim", denormalisedRecord.Dkim?.ToString() ?? string.Empty); command.Parameters.AddWithValue("$Spf", denormalisedRecord.Spf?.ToString() ?? string.Empty); command.Parameters.AddWithValue("$Reason", denormalisedRecord.Reason ?? string.Empty); command.Parameters.AddWithValue("$Comment", denormalisedRecord.Comment ?? string.Empty); command.Parameters.AddWithValue("$EnvelopeTo", denormalisedRecord.EnvelopeTo ?? string.Empty); command.Parameters.AddWithValue("$HeaderFrom", denormalisedRecord.HeaderFrom ?? string.Empty); command.Parameters.AddWithValue("$DkimDomain", denormalisedRecord.DkimDomain ?? string.Empty); command.Parameters.AddWithValue("$DkimResult", denormalisedRecord.DkimResult ?? string.Empty); command.Parameters.AddWithValue("$DkimHumanResult", denormalisedRecord.DkimHumanResult ?? string.Empty); command.Parameters.AddWithValue("$SpfDomain", denormalisedRecord.SpfDomain ?? string.Empty); command.Parameters.AddWithValue("$SpfResult", denormalisedRecord.SpfResult ?? string.Empty); }
public string Serialise(DenormalisedRecord denormalisedRecord) { return(string.Join(DelimiterString, new List <string> { denormalisedRecord.OrginalUri ?? string.Empty, denormalisedRecord.OrgName ?? string.Empty, denormalisedRecord.Email ?? string.Empty, denormalisedRecord.ExtraContactInfo ?? string.Empty, denormalisedRecord.BeginDate.ToString("dd-MM-yyyy HH:mm:ss") ?? string.Empty, denormalisedRecord.EndDate.ToString("dd-MM-yyyy HH:mm:ss") ?? string.Empty, denormalisedRecord.Domain ?? string.Empty, denormalisedRecord.Adkim?.ToString() ?? string.Empty, denormalisedRecord.Aspf?.ToString() ?? string.Empty, denormalisedRecord.P.ToString() ?? string.Empty, denormalisedRecord.Sp?.ToString() ?? string.Empty, denormalisedRecord.Pct?.ToString() ?? string.Empty, denormalisedRecord.SourceIp ?? string.Empty, denormalisedRecord.Count.ToString() ?? string.Empty, denormalisedRecord.Disposition?.ToString() ?? string.Empty, denormalisedRecord.Dkim?.ToString() ?? string.Empty, denormalisedRecord.Spf?.ToString() ?? string.Empty, denormalisedRecord.Reason ?? string.Empty, denormalisedRecord.Comment ?? string.Empty, denormalisedRecord.EnvelopeTo ?? string.Empty, denormalisedRecord.HeaderFrom ?? string.Empty, denormalisedRecord.DkimDomain ?? string.Empty, denormalisedRecord.DkimResult ?? string.Empty, denormalisedRecord.DkimHumanResult ?? string.Empty, denormalisedRecord.SpfDomain ?? string.Empty, denormalisedRecord.SpfResult ?? string.Empty }.Select(EncodeString))); }