private static WorkScheduleType FillObjectFromRowData(DataRow returnRow)
{
WorkScheduleType WorkSchedule = new WorkScheduleType();
if (returnRow["WorkScheduleTypeID"] != DBNull.Value)
{
WorkSchedule.WorkScheduleTypeID = (int)returnRow["WorkScheduleTypeID"];
}
if (returnRow["WorkScheduleTypeAbbrev"] != DBNull.Value)
{
WorkSchedule.WorkScheduleTypeAbbrev = returnRow["WorkScheduleTypeAbbrev"].ToString();
}
if (returnRow["WorkScheduleTypeDesc"] != DBNull.Value)
{
WorkSchedule.WorkScheduleTypeDesc = returnRow["WorkScheduleTypeDesc"].ToString();
}
if (returnRow["IsActive"] != DBNull.Value)
{
WorkSchedule.IsActive = (bool)returnRow["IsActive"];
}
if (returnRow["DisplayAs"] != DBNull.Value)
{
WorkSchedule.DisplayAs = returnRow["DisplayAs"].ToString();
}
return(WorkSchedule);
}
public static List <WorkScheduleType> GetAllWorkScheduleTypes()
{
List <WorkScheduleType> listCollection = new List <WorkScheduleType>();
DataTable dataItems = ExecuteDataTable("spr_GetAllWorkScheduleTypes");
if (dataItems != null)
{
for (int i = 0; i < dataItems.Rows.Count; i++)
{
WorkScheduleType item = new WorkScheduleType();
item = GetWorkScheduleType(dataItems.Rows[i]);
listCollection.Add(item);
}
}
else
{
throw new Exception("You cannot create a Work Schedule Type collection from a null data table.");
}
return(listCollection);
}