1 files changed, 62 insertions, 0 deletions
diff --git a/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/ParamMap.cs b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/ParamMap.cs
new file mode 100644
index 0000000..4b253b7
--- /dev/null
+++ b/docker/crupest-api/CrupestApi/CrupestApi.Commons/Crud/ParamMap.cs
@@ -0,0 +1,62 @@
+using System.Data;
+using System.Diagnostics;
+
+namespace CrupestApi.Commons.Crud;
+
+public record ParamInfo(string Name, object? Value, string? ColumnName = null);
+
+public class ParamList : List<ParamInfo>
+{
+    private static Random random = new Random();
+    private const string chars = "abcdefghijklmnopqrstuvwxyz";
+    public static string GenerateRandomKey(int length)
+    {
+        lock (random)
+        {
+            var result = new string(Enumerable.Repeat(chars, length)
+                .Select(s => s[random.Next(s.Length)]).ToArray());
+            return result;
+        }
+    }
+
+    public string GenerateRandomParameterName()
+    {
+        var parameterName = GenerateRandomKey(10);
+        int retryTimes = 1;
+        while (ContainsKey(parameterName))
+        {
+            retryTimes++;
+            Debug.Assert(retryTimes <= 100);
+            parameterName = GenerateRandomKey(10);
+        }
+        return parameterName;
+    }
+
+
+    public bool ContainsKey(string name)
+    {
+        return this.SingleOrDefault(p => p.Name.Equals(name, StringComparison.OrdinalIgnoreCase)) is not null;
+    }
+
+    public object? this[string key]
+    {
+        get
+        {
+            return this.SingleOrDefault(p => p.Name.Equals(key, StringComparison.OrdinalIgnoreCase)) ?? throw new KeyNotFoundException("Key not found.");
+        }
+    }
+
+    public void Add(string name, object? value, string? columnName = null)
+    {
+        Add(new ParamInfo(name, value, columnName));
+    }
+
+    // Return the random name.
+    public string AddRandomNameParameter(object? value, string? columnName = null)
+    {
+        var parameterName = GenerateRandomParameterName();
+        var param = new ParamInfo(parameterName, value, columnName);
+        Add(param);
+        return parameterName;
+    }
+}