/// <summary>
/// Return active connection that match the filter
/// </summary>
/// <param name="filter">The filter used to select a active connection</param>
/// <returns>A active connection</returns>
public Entities.ActiveConnection Execute(Entities.Filters.ActiveConnection.Select filter)
{
Entities.ActiveConnection connection = null;
using (DbCommand cmd = _db.GetStoredProcCommand("ActiveConnection_SelectById"))
{
_db.AddInParameter(cmd, "@ActiveConnectionID", DbType.String, filter.ActiveConnectionID);
_db.AddInParameter(cmd, "@UserId", DbType.Int32, filter.UserId);
using (IDataReader idr = _db.ExecuteReader(cmd))
{
while (idr.Read())
{
connection = new Entities.ActiveConnection(idr);
}
}
}
return(connection);
}
/// <summary>
/// Return active connection that match the filter
/// </summary>
/// <param name="filter">The filter used to select a active connection</param>
/// <returns>A active connection</returns>
public Entities.ActiveConnection Execute(Entities.Filters.ActiveConnection.Select filter)
{
return(_selectActiveConnection.Execute(filter));
}
