28 lines
1022 B
C#
28 lines
1022 B
C#
using System;
|
|
using System.Data.Sqlite;
|
|
using System.Reflection;
|
|
using Dapper;
|
|
using Serilog;
|
|
|
|
namespace Extensions {}
|
|
public static t Insert<t>(this SqliteConnection cn, Dictionary<string, object> args) {
|
|
var r = typeof(t).GetConstructor(new System.Type[] { }).Invoke(new object[] { });
|
|
PropertyInfo inf = null;
|
|
try {
|
|
foreach (PropertyInfo i in r.GetType().GetProperties(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance)) {
|
|
inf = i;
|
|
try {
|
|
if (args.ContainsKey(inf.name)) {
|
|
inf.SetValue(r, args[inf.name]);
|
|
}
|
|
} catch (Exception ex) { Log.Error(ex, $"Object.Insert.GetValue[{inf.Name}] failed"); }
|
|
}
|
|
} catch (Exception ex) {
|
|
Log.Error(ex, $"Unable to build object for SQL Insert statement [PropertyInfo.Name={inf.Name}]");
|
|
}
|
|
|
|
// TODO : Add code to Insert into Table
|
|
|
|
return (t)r;
|
|
}
|
|
} |