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)));
}
