public static DataRow Save(this IQuery sql, string TableName, string ViewName, Pair values)
{
using (DataTable dt = new DataTable())
{
if (!values.ContainsKey("ID"))
{
dt.Columns.Add("ID", typeof(int));
}
foreach (KeyValuePair <string, object> hh in values)
{
dt.Columns.Add(hh.Key, (hh.Value.GetType() == typeof(DBNull)) ? typeof(string) : hh.Value.GetType());
}
DataRow dr = dt.NewRow();
foreach (KeyValuePair <string, object> hh in values)
{
if (!values.ContainsKey("ID"))
{
dr["ID"] = 0;
}
dr[hh.Key] = hh.Value;
}
dt.AcceptChanges();
using (var g = new QueryMerge(sql as Query)) return(g.Save(TableName, ViewName, dr));
}
}
public static void Save(this IQuery query, DataRow dr, string table)
{
if (query.GetType() == typeof(Query))
{
using (QueryMerge mrg = new QueryMerge(query as Query)) mrg.Save(table, "", dr);
}
else
{
throw new Exception("This Method is not yet Implemented for this Object");
}
}
public static void Save(this IQuery sql, string TableName, string ViewName, DataRow dr, bool RebuildTable = false)
{
using (var g = new QueryMerge(sql as Query)) g.Save(TableName, ViewName, dr, RebuildTable);
}
public static void Save(this IQuery sql, DataTable dt, string TableName)
{
using (var g = new QueryMerge(sql as Query)) g.Save(dt, TableName);
}
