public void RemoveAll()
{
using (var conn = Database.Open())
{
conn.Execute(ApiSql.RemoveAll());
}
}
public IEnumerable <Model.Api.Api> SelectByDirectoryId(int directoryId)
{
using (var conn = Database.Open())
{
return(conn.Query <Model.Api.Api>(ApiSql.FindByDirectoryId(directoryId)));
}
}
public void Add(Model.Api.Api[] apiList)
{
if (apiList == null || apiList.Length == 0)
{
return;
}
using (var conn = Database.Open())
{
var trans = conn.BeginTransaction();
try
{
string sql = ApiSql.Remove(apiList[0].DirectoryId);
conn.Execute(sql, trans);
foreach (var item in apiList)
{
var tuple = ApiSql.Add(item);
int id = conn.ExecuteScalar <int>(tuple.Item1, (object)tuple.Item2, trans);
helper.SetValue(m => m.Id, item, id);
}
trans.Commit();
}
catch
{
trans.Rollback();
}
}
}
public IEnumerable <Model.Api.Api> SelectByQuery(Query query, out int totalRows)
{
using (var conn = Database.Open())
{
var tuple = ApiSql.SelectByQuery(query);
var reader = conn.QueryMultiple(tuple.Item1, (object)tuple.Item2);
var count = reader.Read <object>().First() as IDictionary <string, object>;
totalRows = Convert.ToInt32(count["Count"]);
return(reader.Read <Model.Api.Api>());
}
}
