/// <summary>
/// Retrieves all entities in the database.
/// </summary>
/// <param name="entity">The entity being used for retrieving all entities.</param>
/// <returns>A list of entities found in the database.</returns>
public virtual List<DAL_Entity> RetrieveEntities(DAL_Entity entity)
{
List<DAL_Entity> entities = new List<DAL_Entity>();
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(entity.RetrieveAllSproc, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
entities.Add(entity.ConvertToEntity(reader));
}
}
return entities;
}
/// <summary>
/// Retrieves an entity with the specified Id in the database.
/// </summary>
/// <param name="entity">The entity that contains the Id to query by.</param>
/// <returns>An single enity.</returns>
public virtual DAL_Entity RetrieveEntityById(DAL_Entity entity)
{
DAL_Entity dal_entity = null;
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(entity.RetrieveSingleSproc, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(entity.ToSqlParams().ToArray());
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
dal_entity = entity.ConvertToEntity(reader);
}
}
return dal_entity;
}