/// <summary>
/// Batch inserts a collection of <c>Target</c> objects.
/// </summary>
/// <param name="targets"></param>
public void Insert(IEnumerable <Target> targets)
{
using (var conn = new NpgsqlConnection(dbAccess.connectionString))
{
using (var db = new NPoco.Database(conn))
{
db.Connection.Open();
db.InsertBatch <TargetDto>(TargetDto.Translate(targets.ToList()));
db.Connection.Close();
}
}
}
/// <summary>
/// Insert a single <c>Target</c> object.
/// </summary>
/// <param name="target"></param>
public void Insert(Target target)
{
using (var conn = new NpgsqlConnection(dbAccess.connectionString))
{
using (var db = new NPoco.Database(conn))
{
var dto = TargetDto.Translate(target);
db.Connection.Open();
db.Save <TargetDto>(TargetDto.Translate(target));
db.Connection.Close();
}
}
}
/// <summary>
/// Deletes a <c>TargetDto</c> object.
/// </summary>
/// <param name="target">A <c>Target</c>. This will be translated to a <c>TargetDto</c> before the update operation.</param>
/// <returns><c>int</c> denoting the success value of the operation.</returns>
public int Remove(Target target)
{
int res;
using (var conn = new NpgsqlConnection(dbAccess.connectionString))
{
using (var db = new NPoco.Database(conn))
{
db.Connection.Open();
res = db.Delete(TargetDto.Translate(target));
db.Connection.Close();
}
}
return(res);
}
/// <summary>
/// Partial update for <c>TargetDto</c> by only updating the specified columns.
/// </summary>
/// <param name="docId"></param>
/// <param name="target"></param>
/// <param name="ops">A <c>string</c> collection </param>
/// <returns></returns>
public int PartialUpdate(Guid docId, Target target, IEnumerable <string> ops)
{
int res;
using (var conn = new NpgsqlConnection(dbAccess.connectionString))
{
using (var db = new NPoco.Database(conn))
{
db.Connection.Open();
res = db.Update(TargetDto.Translate(target), docId, ops);
db.Connection.Close();
}
}
return(res);
}
