public void RemoveAll() { using (var conn = Database.Open()) { conn.Execute(DirectorySql.RemoveAll()); } }
public Model.Directory FindBy(int key) { using (var conn = Database.Open()) { return(conn.Query <Model.Directory>(DirectorySql.FindById(key)).FirstOrDefault()); } }
public void Remove(Model.Directory item) { using (var conn = Database.Open()) { conn.Execute(DirectorySql.Remove(item.Id)); } }
public IList <Model.Directory> FindAll() { using (var conn = Database.Open()) { return(conn.Query <Model.Directory>(DirectorySql.FindAll()).ToArray()); } }
public void Update(Model.Directory item) { using (var conn = Database.Open()) { var tuple = DirectorySql.Update(item); conn.Execute(tuple.Item1, (object)tuple.Item2); } }
public IEnumerable <Model.Directory> Select(Model.DirectoryType directoryType) { using (var conn = Database.Open()) { string sql = DirectorySql.SelectDirectoryType(directoryType); return(conn.Query <Model.Directory>(sql)); } }
public bool DirectoryIsExists(Model.Directory d) { using (var conn = Database.Open()) { var tuple = DirectorySql.DirectoryIsExists(d.Name, d.Id); return(conn.ExecuteScalar <int>(tuple.Item1, (object)tuple.Item2) > 0); } }
public Model.Directory FindBy(string name) { using (var conn = Database.Open()) { var tuple = DirectorySql.FindByName(name); return(conn.Query <Model.Directory>(tuple.Item1, (object)tuple.Item2).FirstOrDefault()); } }
public void UpdateProviderNodeCount(int directoryId, int providerNodeCount) { using (var conn = Database.Open()) { string sql = DirectorySql.UpdateProviderNodeCount(directoryId, providerNodeCount); conn.Execute(sql); } }
public void UpdateServiceApiMd5(int directoryId, string serviceApiMd5) { using (var conn = Database.Open()) { string sql = DirectorySql.UpdateServiceApiMd5(directoryId, serviceApiMd5); conn.Execute(sql); } }
public IEnumerable <Model.Directory> FindBy(string[] names) { using (var conn = Database.Open()) { var sql = DirectorySql.FindByNames(names); return(conn.Query <Model.Directory>(sql)); } }
public void Add(Model.Directory item) { using (var conn = Database.Open()) { var tuple = DirectorySql.Add(item); int id = conn.ExecuteScalar <int>(tuple.Item1, (object)tuple.Item2); propertyHelper.SetValue <int>(m => m.Id, item, id); } }