public async Task AddCache()
{
await DropTable(@"Cache");
await CreateTable(@"Cache");
OpenConnection();
try
{
if (!Directory.Exists(@"Cache"))
{
return;
}
var filesnames = Directory.GetFiles(@"Cache").ToList();
foreach (var item in filesnames)
{
using (var sr = new StreamReader(item))
{
var line = sr.ReadToEnd();
var lineBytes = ByteConverters.ObjectToByteArray(line);
var sql = "INSERT INTO Cache ('filename', 'file') VALUES (@filename, @file)";
var command = new SQLiteCommand(sql, Connection);
command.Parameters.AddWithValue("@filename", item);
command.Parameters.Add("@file", DbType.Binary, lineBytes.Length);
command.Parameters["@file"].Value = lineBytes;
await command.ExecuteNonQueryAsync();
}
}
}
catch (Exception e)
{
LoggingService.Log(e);
}
CloseConnection();
}