public void Remove(int consumerDirectoryId)
{
using (var conn = Database.Open())
{
conn.Execute(RelationshipSql.Remove(consumerDirectoryId));
}
}
public void Add(IList <Model.Relationship> list)
{
if (list == null || list.Count == 0)
{
return;
}
using (var conn = Database.Open())
{
var trans = conn.BeginTransaction();
try
{
string sql = RelationshipSql.Remove(list[0].ConsumerInfo.ConsumerDirectoryId);
conn.Execute(sql, trans);
foreach (var item in list)
{
var tuple = RelationshipSql.Add(item);
conn.Execute(tuple.Item1, (object)tuple.Item2, trans);
}
trans.Commit();
}
catch
{
trans.Rollback();
}
}
}
public void RemoveAll()
{
using (var conn = Database.Open())
{
conn.Execute(RelationshipSql.RemoveAll());
}
}
public IEnumerable <Model.Relationship> Select(int consumerDirectoryId)
{
using (var conn = Database.Open())
{
string sql = RelationshipSql.SelectBy(consumerDirectoryId);
return(conn.Query <Model.Relationship, Model.ConsumerInfo, Model.ProviderInfo, Model.Relationship>(sql, SelectConvert, splitOn: "split"));
}
}
public void Add(Model.Relationship relationship)
{
using (var conn = Database.Open())
{
var tuple = RelationshipSql.Add(relationship);
conn.ExecuteScalar <int>(tuple.Item1, (object)tuple.Item2);
}
}
public bool RelationIsExists(int providerDirectoryId, int consumerDirectoryId)
{
using (var conn = Database.Open())
{
var tuple = RelationshipSql.IsExists(consumerDirectoryId, providerDirectoryId);
var model = conn.Query <Model.Relationship>(tuple.Item1, (object)tuple.Item2);
if (model.Any())
{
return(false);
}
return(true);
}
}
public IEnumerable <Model.Relationship> SelectAll()
{
using (var conn = Database.Open())
{
return(conn.Query <Model.Relationship, Model.ConsumerInfo, Model.ProviderInfo, Model.Relationship>(RelationshipSql.FindAll(), SelectConvert, splitOn: "split").ToList());
}
}