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