public StringBuilder CreateFile()
{
StringBuilder writer = new StringBuilder();
writer.AppendLine($"Data utworzenia raportu: {ForDate.ToString("d", CultureInfo.CreateSpecificCulture("de-DE"))}");
writer.AppendLine("Wiazka,Kod Ciety,BIN,Zeskanowane,Deklarowane,Roznica,Uwagi");
foreach (KeyValuePair <string, Differences> entry in differencesFiltered)
{
if (entry.Value.Zeskanowanych - entry.Value.Deklarowanych != 0)
{
string line = $"{entry.Value.Wiazka},{entry.Key},{entry.Value.BIN},{entry.Value.Zeskanowanych},{entry.Value.Deklarowanych},{entry.Value.Zeskanowanych - entry.Value.Deklarowanych}";
if (entry.Value.Zeskanowanych == 0)
{
writer.AppendLine($"{line},brak");
}
else if (entry.Value.Zeskanowanych - entry.Value.Deklarowanych < 0)
{
writer.AppendLine($"{line},niedomiar");
}
else
{
writer.AppendLine($"{line},nadmiar");
}
}
}
return(writer);
}
public static IEnumerable <SqlOperator> GetAllowedForSqlType(string type)
{
type = type.ToLower();
switch (type)
{
case "int":
return(ForNumber.Clone() as SqlOperator[]);
case "nvarchar":
return(ForString.Clone() as SqlOperator[]);
case "date":
case "datetime":
return(ForDate.Clone() as SqlOperator[]);
default:
return(ForObject.Clone() as SqlOperator[]);
}
}
public override string ToString()
{
return($"{IdImg}, {ImgUrl}, {ImagePath}, {ComicUrl}, {ForDate.ToString("dd.MM.yyyy")}");
}
public override string ToString()
{
return($"{ForDate.ToString("d").Replace("/", "")}-{Number:D4}");
}