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); } }