public IEnumerable <Model.Node> Select(DirectoryType directoryType)
{
using (var conn = Database.Open())
{
return(conn.Query <Model.Node, Model.DirectoryInfo, Model.Node>(NodeSql.SelectByDirectoryType(directoryType.GetHashCode()), SelectConvert, splitOn: "split"));
}
}
public IEnumerable <Model.Node> Select(int directoryId)
{
using (var conn = Database.Open())
{
return(conn.Query <Model.Node, Model.DirectoryInfo, Model.Node>(NodeSql.SelectByDirectoryId(directoryId), SelectConvert, splitOn: "split"));
}
}
public void Remove(Model.Node item)
{
using (var conn = Database.Open())
{
conn.Execute(NodeSql.Remove(item.Id));
}
}
public void RemoveAll()
{
using (var conn = Database.Open())
{
conn.Execute(NodeSql.RemoveAll());
}
}
public IList <Model.Node> FindAll()
{
using (var conn = Database.Open())
{
return(conn.Query <Model.Node, Model.DirectoryInfo, Model.Node>(NodeSql.FindAll(), SelectConvert, splitOn: "split").ToList());
}
}
public Model.Node FindBy(int key)
{
using (var conn = Database.Open())
{
var tuple = NodeSql.FindById(key);
return(conn.Query <Model.Node, Model.DirectoryInfo, Model.Node>(tuple.Item1, SelectConvert, (object)tuple.Item2, splitOn: "split").FirstOrDefault());
}
}
public void Update(Model.Node item)
{
using (var conn = Database.Open())
{
var tuple = NodeSql.Update(item);
conn.ExecuteScalar(tuple.Item1, (object)tuple.Item2);
}
}
public void Add(Model.Node item)
{
using (var conn = Database.Open())
{
var tuple = NodeSql.Add(item);
int id = conn.ExecuteScalar <int>(tuple.Item1, (object)tuple.Item2);
propertyHelper.SetValue <int>(m => m.Id, item, id);
}
}
public IEnumerable <Model.Node> FindByIds(int[] nodeIds)
{
if (nodeIds == null || nodeIds.Length == 0)
{
return(new List <Model.Node>());
}
using (var conn = Database.Open())
{
string sql = NodeSql.FindByIds(nodeIds);
return(conn.Query <Model.Node, Model.DirectoryInfo, Model.Node>(sql, SelectConvert, splitOn: "split"));
}
}
public bool IsExists(Model.Node n)
{
using (var conn = Database.Open())
{
var tuple = NodeSql.IsExists(n.Id, n.DirectoryInfo.Id, n.Url);
var model = conn.Query <Model.Node>(tuple.Item1, (object)tuple.Item2);
if (model.Any())
{
return(false);
}
return(true);
}
}
