public DbFileInfo GetFileInfo(Guid fileId)
{
DbFileInfo fileInfo = null;
using (var connection = _connection)
{
connection.Open();
var command = connection.CreateCommand();
command.CommandText = "select fileName, key, iv from fileInfo where fileID = @guid";
command.Parameters.AddWithValue("@guid", fileId);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
fileInfo = new DbFileInfo
{
FileName = (string)reader["fileName"],
Key = (byte[])reader["key"],
Iv = (byte[])reader["iv"],
FileId = fileId
};
}
}
}
return(fileInfo);
}
public void StoreFileDetails(DbFileInfo fileInfo)
{
using (var connection = _connection)
{
connection.Open();
var command = connection.CreateCommand();
command.CommandText = "insert into fileInfo values(@guid, @filename, @key, @iv)";
command.Parameters.AddWithValue("@guid", fileInfo.FileId);
command.Parameters.AddWithValue("@filename", fileInfo.FileName);
command.Parameters.AddWithValue("@key", fileInfo.Key);
command.Parameters.AddWithValue("@iv", fileInfo.Iv);
command.ExecuteNonQuery();
}
}