public static void InsertFileHMAC(FileHmac file)
{
string value = string.Empty;
using var connection = new SQLiteConnection(connectionString);
string sqlS = "select " + FILEHMAC_PATH + " FROM " + TABLE_FILEHMAC + " WHERE " + FILEHMAC_PATH + " = @path";
connection.Open();
using (var selectSQL = new SQLiteCommand(sqlS, connection))
{
selectSQL.Parameters.AddWithValue("@path", file.path);
using (var rd = selectSQL.ExecuteReader())
{
try
{
while (rd.Read())
{
value = (string)rd[FILEHMAC_PATH];
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
connection.Close();
if (value != file.path)
{
string sql = "INSERT INTO " + TABLE_FILEHMAC + " ( " + FILEHMAC_PATH + " , " + FILEHMAC_HMAC + " , " + FILEHMAC_DIR + " ) VALUES (@Path, @Hmac, @Dir)";
connection.Open();
using (var insertSQL = new SQLiteCommand(sql, connection))
{
insertSQL.Parameters.AddWithValue("@Path", file.path);
insertSQL.Parameters.AddWithValue("@Hmac", file.hmac);
insertSQL.Parameters.AddWithValue("@Dir", file.dir);
insertSQL.ExecuteNonQuery();
}
}
}
public static int DeleteFileHMAC(FileHmac file)
{
using var connection = new SQLiteConnection(connectionString);
string sql = "DELETE FROM " + TABLE_FILEHMAC + " WHERE " + FILEHMAC_PATH + " = @Path";
connection.Open();
using (var updateSQL = new SQLiteCommand(sql, connection))
{
updateSQL.Parameters.AddWithValue("@Path", file.path);
try
{
return(updateSQL.ExecuteNonQuery());
}
catch (Exception e)
{
throw new Exception(e.ToString());
}
}
}
