public List <Division> GetAll(int DepartmentID)
{
DivisionDAC _divisionComponent = new DivisionDAC();
IDataReader reader = _divisionComponent.GetAllDivision("DepartmentID = " + DepartmentID).CreateDataReader();
List <Division> _divisionList = new List <Division>();
while (reader.Read())
{
if (_divisionList == null)
{
_divisionList = new List <Division>();
}
Division _division = new Division();
if (reader["DivisionID"] != DBNull.Value)
{
_division.DivisionID = Convert.ToInt32(reader["DivisionID"]);
}
if (reader["DepartmentID"] != DBNull.Value)
{
_division.DepartmentID = Convert.ToInt32(reader["DepartmentID"]);
}
if (reader["Name"] != DBNull.Value)
{
_division.Name = Convert.ToString(reader["Name"]);
}
if (reader["SiteUrl"] != DBNull.Value)
{
_division.SiteUrl = Convert.ToString(reader["SiteUrl"]);
}
_division.NewRecord = false;
_divisionList.Add(_division);
}
reader.Close();
return(_divisionList);
}
