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 Remove(int consumerDirectoryId)
{
using (var conn = Database.Open())
{
conn.Execute(RelationshipSql.Remove(consumerDirectoryId));
}
}