internal static RoutingItem BuildRoutingItem(object projectKey, IDataReader reader)
{
ProjectContact contact = ProjectService.GetProjectContact(projectKey,
reader[FieldNames.ProjectContactId]);
return(new RoutingItem(reader[FieldNames.RoutingItemId],
TransmittalFactory.BuildDiscipline(reader),
DataHelper.GetInteger(reader[FieldNames.RoutingOrder]),
contact,
DataHelper.GetDateTime(reader[FieldNames.DateSent]),
DataHelper.GetNullableDateTime(reader[FieldNames.DateReturned])));
}
public IList <Discipline> FindAllDisciplines()
{
List <Discipline> disciplines = new List <Discipline>();
string query = "SELECT * FROM Discipline";
using (IDataReader reader = this.ExecuteReader(query))
{
while (reader.Read())
{
disciplines.Add(TransmittalFactory.BuildDiscipline(reader));
}
}
return(disciplines);
}
