/// <summary>
/// Select a users
/// </summary>
/// <param name="userIds">List of Ids of the users to select</param>
/// <returns></returns>
public List <Entities.User> Execute(List <Int32> userIds)
{
Entities.Filters.User.Select filter = new Entities.Filters.User.Select();
filter.UserIds.AddRange(userIds);
return(_select.Execute(filter));
}
/// <summary>
/// Select a user
/// </summary>
/// <param name="userId">The Id of the user to select</param>
/// <returns>The user matching <paramref name="userId"/></returns>
public Entities.User Execute(Int32 userId)
{
Entities.Filters.User.Select filter = new Entities.Filters.User.Select();
filter.UserIds.Add(userId);
return(_select.Execute(filter).FirstOrDefault());
}
/// <summary>
/// Select a users
/// </summary>
/// <param name="userIds">List of Ids of the users to select</param>
/// <returns></returns>
public List<Entities.User> Execute(List<Int32> userIds)
{
Entities.Filters.User.Select filter = new Entities.Filters.User.Select();
filter.UserIds.AddRange(userIds);
return _select.Execute(filter);
}
/// <summary>
/// Select a user
/// </summary>
/// <param name="userId">The Id of the user to select</param>
/// <returns>The user matching <paramref name="userId"/></returns>
public Entities.User Execute(Int32 userId)
{
Entities.Filters.User.Select filter = new Entities.Filters.User.Select();
filter.UserIds.Add(userId);
return _select.Execute(filter).FirstOrDefault();
}
/// <summary>
/// Select users based on the <paramref name="filter"/>
/// </summary>
/// <param name="filter">The filter used to select users</param>
/// <returns></returns>
public List <Entities.User> Execute(Entities.Filters.User.Select filter)
{
List <Entities.User> users = new List <Entities.User>();
using (DbCommand cmd = _db.GetStoredProcCommand("User_Select"))
{
_db.AddInParameter(cmd, "@UserIds", DbType.Xml, filter.UserIds.ConvertCollectionToXML());
using (IDataReader idr = _db.ExecuteReader(cmd))
{
while (idr.Read())
{
users.Add(new Entities.User(idr));
}
}
}
return(users);
}
/// <summary>
/// Select users based on the <paramref name="filter"/>
/// </summary>
/// <param name="filter">The filter used to select users</param>
/// <returns></returns>
public List <Entities.User> Execute(Entities.Filters.User.Select filter)
{
return(_select.Execute(filter));
}
