private static OrgGroupsData GetDataObjectFromReader(SqlDataReader dataReader)
{
OrgGroupsData data = new OrgGroupsData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
{
data.OrgGroupsID = IdType.UNSET;
}
else
{
data.OrgGroupsID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsActive")))
{
data.IsActive = BooleanType.UNSET;
}
else
{
data.IsActive = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsActive")));
}
return(data);
}
private static KnowledgebasesData GetDataObjectFromReader(SqlDataReader dataReader)
{
KnowledgebasesData data = new KnowledgebasesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("KnowledgebasesID")))
{
data.KnowledgebasesID = IdType.UNSET;
}
else
{
data.KnowledgebasesID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("KnowledgebasesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateStart")))
{
data.DateStart = DateType.UNSET;
}
else
{
data.DateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateStart")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateEnd")))
{
data.DateEnd = DateType.UNSET;
}
else
{
data.DateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateEnd")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsPublic")))
{
data.IsPublic = BooleanType.UNSET;
}
else
{
data.IsPublic = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsPublic")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
{
data.OrgGroupsID = IntegerType.UNSET;
}
else
{
data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
return(data);
}
private static OrgDepartmentsData GetDataObjectFromReader(SqlDataReader dataReader)
{
OrgDepartmentsData data = new OrgDepartmentsData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgDepartmentsID")))
{
data.OrgDepartmentsID = IdType.UNSET;
}
else
{
data.OrgDepartmentsID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("OrgDepartmentsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Active")))
{
data.Active = BooleanType.UNSET;
}
else
{
data.Active = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("Active")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgDivisionsID")))
{
data.OrgDivisionsID = IntegerType.UNSET;
}
else
{
data.OrgDivisionsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgDivisionsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GLAccount")))
{
data.GLAccount = StringType.UNSET;
}
else
{
data.GLAccount = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("GLAccount")));
}
return(data);
}
private static DirectoriesData GetDataObjectFromReader(SqlDataReader dataReader)
{
DirectoriesData data = new DirectoriesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("Id")))
{
data.Id = IdType.UNSET;
}
else
{
data.Id = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("Id")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Name")))
{
data.Name = StringType.UNSET;
}
else
{
data.Name = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Name")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Path")))
{
data.Path = StringType.UNSET;
}
else
{
data.Path = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Path")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsPublic")))
{
data.IsPublic = BooleanType.UNSET;
}
else
{
data.IsPublic = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsPublic")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupID")))
{
data.OrgGroupID = IntegerType.UNSET;
}
else
{
data.OrgGroupID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupID")));
}
return(data);
}
private static ControlsGroupsData GetDataObjectFromReader(SqlDataReader dataReader)
{
ControlsGroupsData data = new ControlsGroupsData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsGroupsID")))
{
data.ControlsGroupsID = IdType.UNSET;
}
else
{
data.ControlsGroupsID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsID")))
{
data.ControlsID = IntegerType.UNSET;
}
else
{
data.ControlsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
{
data.OrgGroupsID = IntegerType.UNSET;
}
else
{
data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("SortOrder")))
{
data.SortOrder = IntegerType.UNSET;
}
else
{
data.SortOrder = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SortOrder")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DisplayOnHomePage")))
{
data.DisplayOnHomePage = BooleanType.UNSET;
}
else
{
data.DisplayOnHomePage = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("DisplayOnHomePage")));
}
return(data);
}
private static OrgGroupsEmployeesData GetDataObjectFromReader(SqlDataReader dataReader)
{
OrgGroupsEmployeesData data = new OrgGroupsEmployeesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsEmployeesID")))
{
data.OrgGroupsEmployeesID = IdType.UNSET;
}
else
{
data.OrgGroupsEmployeesID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsEmployeesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
{
data.OrgGroupsID = IntegerType.UNSET;
}
else
{
data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgEmployeesID")))
{
data.OrgEmployeesID = IntegerType.UNSET;
}
else
{
data.OrgEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsContentManager")))
{
data.IsContentManager = BooleanType.UNSET;
}
else
{
data.IsContentManager = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsContentManager")));
}
return(data);
}
private static GroupEmployeeViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
GroupEmployeeViewData data = new GroupEmployeeViewData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("FirstName")))
{
data.FirstName = StringType.UNSET;
}
else
{
data.FirstName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("FirstName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LastName")))
{
data.LastName = StringType.UNSET;
}
else
{
data.LastName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LastName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DepartmentName")))
{
data.DepartmentName = StringType.UNSET;
}
else
{
data.DepartmentName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("DepartmentName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GroupIsActive")))
{
data.GroupIsActive = BooleanType.UNSET;
}
else
{
data.GroupIsActive = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("GroupIsActive")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
{
data.OrgGroupsID = IntegerType.UNSET;
}
else
{
data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LocationName")))
{
data.LocationName = StringType.UNSET;
}
else
{
data.LocationName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LocationName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmployeeTitle")))
{
data.EmployeeTitle = StringType.UNSET;
}
else
{
data.EmployeeTitle = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("EmployeeTitle")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmployeeIsActive")))
{
data.EmployeeIsActive = BooleanType.UNSET;
}
else
{
data.EmployeeIsActive = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("EmployeeIsActive")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsEmployeesID")))
{
data.OrgGroupsEmployeesID = IntegerType.UNSET;
}
else
{
data.OrgGroupsEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsEmployeesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgEmployeesID")))
{
data.OrgEmployeesID = IntegerType.UNSET;
}
else
{
data.OrgEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Email")))
{
data.Email = StringType.UNSET;
}
else
{
data.Email = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Email")));
}
return(data);
}
private static CalendarsItemsData GetDataObjectFromReader(SqlDataReader dataReader)
{
CalendarsItemsData data = new CalendarsItemsData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("CalendarsItemsID")))
{
data.CalendarsItemsID = IdType.UNSET;
}
else
{
data.CalendarsItemsID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("CalendarsItemsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Summary")))
{
data.Summary = StringType.UNSET;
}
else
{
data.Summary = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Summary")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EventDateStart")))
{
data.EventDateStart = DateType.UNSET;
}
else
{
data.EventDateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("EventDateStart")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EventDateEnd")))
{
data.EventDateEnd = DateType.UNSET;
}
else
{
data.EventDateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("EventDateEnd")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsActive")))
{
data.IsActive = BooleanType.UNSET;
}
else
{
data.IsActive = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsActive")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CalendarsID")))
{
data.CalendarsID = IntegerType.UNSET;
}
else
{
data.CalendarsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("CalendarsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsPublic")))
{
data.IsPublic = BooleanType.UNSET;
}
else
{
data.IsPublic = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsPublic")));
}
return(data);
}
private static MustShowControlViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
MustShowControlViewData data = new MustShowControlViewData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("Src")))
{
data.Src = StringType.UNSET;
}
else
{
data.Src = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Src")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Summary")))
{
data.Summary = StringType.UNSET;
}
else
{
data.Summary = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Summary")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ClassSrc")))
{
data.ClassSrc = StringType.UNSET;
}
else
{
data.ClassSrc = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ClassSrc")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MustShow")))
{
data.MustShow = BooleanType.UNSET;
}
else
{
data.MustShow = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("MustShow")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateStart")))
{
data.DateStart = DateType.UNSET;
}
else
{
data.DateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateStart")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateEnd")))
{
data.DateEnd = DateType.UNSET;
}
else
{
data.DateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateEnd")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsID")))
{
data.ControlsID = IntegerType.UNSET;
}
else
{
data.ControlsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsID")));
}
return(data);
}
private static ControlSubscriptionsData GetDataObjectFromReader(SqlDataReader dataReader)
{
ControlSubscriptionsData data = new ControlSubscriptionsData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlSubscriptionsID")))
{
data.ControlSubscriptionsID = IdType.UNSET;
}
else
{
data.ControlSubscriptionsID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("ControlSubscriptionsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgEmployeesID")))
{
data.OrgEmployeesID = IntegerType.UNSET;
}
else
{
data.OrgEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
{
data.OrgGroupsID = IntegerType.UNSET;
}
else
{
data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsID")))
{
data.ControlsID = IntegerType.UNSET;
}
else
{
data.ControlsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("SortOrder")))
{
data.SortOrder = IntegerType.UNSET;
}
else
{
data.SortOrder = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SortOrder")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("AllowUnsubscribe")))
{
data.AllowUnsubscribe = BooleanType.UNSET;
}
else
{
data.AllowUnsubscribe = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("AllowUnsubscribe")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateSubscribed")))
{
data.DateSubscribed = DateType.UNSET;
}
else
{
data.DateSubscribed = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateSubscribed")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsClassesID")))
{
data.ControlsClassesID = IntegerType.UNSET;
}
else
{
data.ControlsClassesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsClassesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ItemID")))
{
data.ItemID = IntegerType.UNSET;
}
else
{
data.ItemID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ItemID")));
}
return(data);
}
private static EmployeeControlPermissionViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
EmployeeControlPermissionViewData data = new EmployeeControlPermissionViewData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgEmployeeID")))
{
data.OrgEmployeeID = IntegerType.UNSET;
}
else
{
data.OrgEmployeeID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeeID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsID")))
{
data.ControlsID = IntegerType.UNSET;
}
else
{
data.ControlsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateStart")))
{
data.DateStart = DateType.UNSET;
}
else
{
data.DateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateStart")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateEnd")))
{
data.DateEnd = DateType.UNSET;
}
else
{
data.DateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateEnd")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EntireCompany")))
{
data.EntireCompany = BooleanType.UNSET;
}
else
{
data.EntireCompany = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("EntireCompany")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Summary")))
{
data.Summary = StringType.UNSET;
}
else
{
data.Summary = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Summary")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MustShow")))
{
data.MustShow = BooleanType.UNSET;
}
else
{
data.MustShow = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("MustShow")));
}
return(data);
}
private static OrgEmployeesData GetDataObjectFromReader(SqlDataReader dataReader)
{
OrgEmployeesData data = new OrgEmployeesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgEmployeesID")))
{
data.OrgEmployeesID = IdType.UNSET;
}
else
{
data.OrgEmployeesID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgDepartmentsID")))
{
data.OrgDepartmentsID = IntegerType.UNSET;
}
else
{
data.OrgDepartmentsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgDepartmentsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgLocationsID")))
{
data.OrgLocationsID = IntegerType.UNSET;
}
else
{
data.OrgLocationsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgLocationsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgWorkspacesID")))
{
data.OrgWorkspacesID = IntegerType.UNSET;
}
else
{
data.OrgWorkspacesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgWorkspacesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("FirstName")))
{
data.FirstName = StringType.UNSET;
}
else
{
data.FirstName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("FirstName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LastName")))
{
data.LastName = StringType.UNSET;
}
else
{
data.LastName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LastName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NTUserAccount")))
{
data.NTUserAccount = StringType.UNSET;
}
else
{
data.NTUserAccount = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("NTUserAccount")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsActive")))
{
data.IsActive = BooleanType.UNSET;
}
else
{
data.IsActive = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsActive")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Email")))
{
data.Email = StringType.UNSET;
}
else
{
data.Email = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Email")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmployeeTitle")))
{
data.EmployeeTitle = StringType.UNSET;
}
else
{
data.EmployeeTitle = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("EmployeeTitle")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateHired")))
{
data.DateHired = DateType.UNSET;
}
else
{
data.DateHired = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateHired")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateTerminated")))
{
data.DateTerminated = DateType.UNSET;
}
else
{
data.DateTerminated = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateTerminated")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Manager")))
{
data.Manager = IntegerType.UNSET;
}
else
{
data.Manager = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Manager")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmployeeNumber")))
{
data.EmployeeNumber = StringType.UNSET;
}
else
{
data.EmployeeNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("EmployeeNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Style")))
{
data.Style = StringType.UNSET;
}
else
{
data.Style = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Style")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Map")))
{
data.Map = StringType.UNSET;
}
else
{
data.Map = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Map")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MapX")))
{
data.MapX = DecimalType.UNSET;
}
else
{
data.MapX = new DecimalType(dataReader.GetDouble(dataReader.GetOrdinal("MapX")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MapY")))
{
data.MapY = DecimalType.UNSET;
}
else
{
data.MapY = new DecimalType(dataReader.GetDouble(dataReader.GetOrdinal("MapY")));
}
return(data);
}
/// <summary>
/// Builds a data object from the current row in a data reader..
/// </summary>
/// <param name="dataReader">Container for database row.</param>
/// <returns>Data object built from current row.</returns>
private static TestSqlEntityData GetDataObjectFromReader(SqlDataReader dataReader)
{
TestSqlEntityData data = new TestSqlEntityData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("float")))
{
data.FloatProperty = DecimalType.UNSET;
}
else
{
data.FloatProperty = new DecimalType(dataReader.GetDouble(dataReader.GetOrdinal("float")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("datetime")))
{
data.DateTimeProperty = DateType.UNSET;
}
else
{
data.DateTimeProperty = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("datetime")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("bigint")))
{
data.BigIntProperty = 0;
}
else
{
data.BigIntProperty = dataReader.GetInt64(dataReader.GetOrdinal("bigint"));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("bit")))
{
data.BitProperty = BooleanType.UNSET;
}
else
{
data.BitProperty = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("bit")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("smallint")))
{
data.SmallIntProperty = IntegerType.UNSET;
}
else
{
data.SmallIntProperty = new IntegerType(dataReader.GetInt16(dataReader.GetOrdinal("smallint")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("tinyint")))
{
data.TinyIntProperty = IntegerType.UNSET;
}
else
{
data.TinyIntProperty = new IntegerType(dataReader.GetByte(dataReader.GetOrdinal("tinyint")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("smallmoney")))
{
data.SmallMoneyProperty = CurrencyType.UNSET;
}
else
{
data.SmallMoneyProperty = new CurrencyType(dataReader.GetDecimal(dataReader.GetOrdinal("smallmoney")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("money")))
{
data.MoneyProperty = CurrencyType.UNSET;
}
else
{
data.MoneyProperty = new CurrencyType(dataReader.GetDecimal(dataReader.GetOrdinal("money")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("text")))
{
data.TextProperty = StringType.UNSET;
}
else
{
data.TextProperty = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("text")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("smalldatetime")))
{
data.SmallDateTimeProperty = DateType.UNSET;
}
else
{
data.SmallDateTimeProperty = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("smalldatetime")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("char")))
{
data.CharProperty = StringType.UNSET;
}
else
{
data.CharProperty = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("char")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("varchar")))
{
data.VarCharProperty = StringType.UNSET;
}
else
{
data.VarCharProperty = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("varchar")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("int")))
{
data.IntProperty = IntegerType.UNSET;
}
else
{
data.IntProperty = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("int")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("numeric")))
{
data.NumericProperty = DecimalType.UNSET;
}
else
{
data.NumericProperty = new DecimalType(dataReader.GetDecimal(dataReader.GetOrdinal("numeric")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("decimal")))
{
data.DecimalProperty = DecimalType.UNSET;
}
else
{
data.DecimalProperty = new DecimalType(dataReader.GetDecimal(dataReader.GetOrdinal("decimal")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("nchar")))
{
data.NCharProperty = StringType.UNSET;
}
else
{
data.NCharProperty = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("nchar")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ntext")))
{
data.NTextProperty = StringType.UNSET;
}
else
{
data.NTextProperty = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ntext")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("nvarchar")))
{
data.NVarCharProperty = StringType.UNSET;
}
else
{
data.NVarCharProperty = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("nvarchar")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("real")))
{
data.RealProperty = DecimalType.UNSET;
}
else
{
data.RealProperty = new DecimalType(dataReader.GetFloat(dataReader.GetOrdinal("real")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("uniqueidentifier")))
{
data.UniqueIdentifierProperty = new Guid();
}
else
{
data.UniqueIdentifierProperty = dataReader.GetGuid(dataReader.GetOrdinal("uniqueidentifier"));
}
return(data);
}
private static WebConfigData GetDataObjectFromReader(SqlDataReader dataReader)
{
WebConfigData data = new WebConfigData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("WebConfigID")))
{
data.WebConfigID = IdType.UNSET;
}
else
{
data.WebConfigID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("WebConfigID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CreateDate")))
{
data.CreateDate = DateType.UNSET;
}
else
{
data.CreateDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("CreateDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LeftNavBGColor")))
{
data.LeftNavBGColor = StringType.UNSET;
}
else
{
data.LeftNavBGColor = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LeftNavBGColor")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("HeaderTextColor")))
{
data.HeaderTextColor = StringType.UNSET;
}
else
{
data.HeaderTextColor = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("HeaderTextColor")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MainPic")))
{
data.MainPic = StringType.UNSET;
}
else
{
data.MainPic = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("MainPic")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LeftNavPic")))
{
data.LeftNavPic = StringType.UNSET;
}
else
{
data.LeftNavPic = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LeftNavPic")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Active")))
{
data.Active = BooleanType.UNSET;
}
else
{
data.Active = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("Active")));
}
return(data);
}
/// <summary>
/// Builds a data object from the current row in a data reader..
/// </summary>
/// <param name="dataReader">Container for database row.</param>
/// <returns>Data object built from current row.</returns>
private static TournamentData GetDataObjectFromReader(SqlDataReader dataReader)
{
TournamentData data = new TournamentData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("TournamentId")))
{
data.TournamentId = IdType.UNSET;
}
else
{
data.TournamentId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("TournamentId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Name")))
{
data.Name = StringType.UNSET;
}
else
{
data.Name = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Name")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NumberOfTeams")))
{
data.NumberOfTeams = IntegerType.UNSET;
}
else
{
data.NumberOfTeams = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("NumberOfTeams")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("TeamSize")))
{
data.TeamSize = TeamSizeEnum.UNSET;
}
else
{
data.TeamSize = TeamSizeEnum.GetInstance(dataReader.GetString(dataReader.GetOrdinal("TeamSize")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Format")))
{
data.Format = TournamentFormatEnum.UNSET;
}
else
{
data.Format = TournamentFormatEnum.GetInstance(dataReader.GetString(dataReader.GetOrdinal("Format")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("RegistrationBeginDate")))
{
data.RegistrationBeginDate = DateType.UNSET;
}
else
{
data.RegistrationBeginDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("RegistrationBeginDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("RegistrationEndDate")))
{
data.RegistrationEndDate = DateType.UNSET;
}
else
{
data.RegistrationEndDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("RegistrationEndDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CancellationCutoffDate")))
{
data.CancellationCutoffDate = DateType.UNSET;
}
else
{
data.CancellationCutoffDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("CancellationCutoffDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("RegistrationFee")))
{
data.RegistrationFee = CurrencyType.UNSET;
}
else
{
data.RegistrationFee = new CurrencyType(dataReader.GetDecimal(dataReader.GetOrdinal("RegistrationFee")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("RegistrationFeeDescription")))
{
data.RegistrationFeeDescription = StringType.UNSET;
}
else
{
data.RegistrationFeeDescription = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("RegistrationFeeDescription")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DatesText")))
{
data.DatesText = StringType.UNSET;
}
else
{
data.DatesText = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("DatesText")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PrizesText")))
{
data.PrizesText = StringType.UNSET;
}
else
{
data.PrizesText = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("PrizesText")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("SponsorsText")))
{
data.SponsorsText = StringType.UNSET;
}
else
{
data.SponsorsText = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("SponsorsText")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LocationsText")))
{
data.LocationsText = StringType.UNSET;
}
else
{
data.LocationsText = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LocationsText")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrganizerId")))
{
data.Organizer.OrganizerId = IdType.UNSET;
}
else
{
data.Organizer.OrganizerId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("OrganizerId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("RegisteredParticipants")))
{
data.RegisteredParticipants = IntegerType.UNSET;
}
else
{
data.RegisteredParticipants = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("RegisteredParticipants")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MaximumHandicap")))
{
data.MaximumHandicap = IntegerType.UNSET;
}
else
{
data.MaximumHandicap = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("MaximumHandicap")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Host")))
{
data.Host = StringType.UNSET;
}
else
{
data.Host = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Host")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ShowPercentFull")))
{
data.ShowPercentFull = BooleanType.UNSET;
}
else
{
data.ShowPercentFull = BooleanType.GetInstance(dataReader.GetString(dataReader.GetOrdinal("ShowPercentFull")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ShowParticipants")))
{
data.ShowParticipants = BooleanType.UNSET;
}
else
{
data.ShowParticipants = BooleanType.GetInstance(dataReader.GetString(dataReader.GetOrdinal("ShowParticipants")));
}
return(data);
}
private static EmployeeManagerNotesData GetDataObjectFromReader(SqlDataReader dataReader)
{
EmployeeManagerNotesData data = new EmployeeManagerNotesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("Id")))
{
data.Id = IdType.UNSET;
}
else
{
data.Id = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("Id")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ChangeEmployeeName")))
{
data.ChangeEmployeeName = StringType.UNSET;
}
else
{
data.ChangeEmployeeName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ChangeEmployeeName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsAutomated")))
{
data.IsAutomated = BooleanType.UNSET;
}
else
{
data.IsAutomated = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsAutomated")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NoteDate")))
{
data.NoteDate = DateType.UNSET;
}
else
{
data.NoteDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("NoteDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Notes")))
{
data.Notes = StringType.UNSET;
}
else
{
data.Notes = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Notes")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Type")))
{
data.Type = IntegerType.UNSET;
}
else
{
data.Type = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Type")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmployeeID")))
{
data.EmployeeID = IntegerType.UNSET;
}
else
{
data.EmployeeID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("EmployeeID")));
}
return(data);
}
private static KnowledgebasesSectionsArticlesData GetDataObjectFromReader(SqlDataReader dataReader)
{
KnowledgebasesSectionsArticlesData data = new KnowledgebasesSectionsArticlesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("KnowledgebasesSectionsArticlesID")))
{
data.KnowledgebasesSectionsArticlesID = IdType.UNSET;
}
else
{
data.KnowledgebasesSectionsArticlesID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("KnowledgebasesSectionsArticlesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Title")))
{
data.Title = StringType.UNSET;
}
else
{
data.Title = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Title")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateStart")))
{
data.DateStart = DateType.UNSET;
}
else
{
data.DateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateStart")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateEnd")))
{
data.DateEnd = DateType.UNSET;
}
else
{
data.DateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateEnd")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ParentID")))
{
data.ParentID = IntegerType.UNSET;
}
else
{
data.ParentID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ParentID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("KnowledgebasesID")))
{
data.KnowledgebasesID = IntegerType.UNSET;
}
else
{
data.KnowledgebasesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("KnowledgebasesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("HasChild")))
{
data.HasChild = BooleanType.UNSET;
}
else
{
data.HasChild = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("HasChild")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PrevKnowledgebasesSectionsID")))
{
data.PrevKnowledgebasesSectionsID = IntegerType.UNSET;
}
else
{
data.PrevKnowledgebasesSectionsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("PrevKnowledgebasesSectionsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NextKnowledgebasesSectionsID")))
{
data.NextKnowledgebasesSectionsID = IntegerType.UNSET;
}
else
{
data.NextKnowledgebasesSectionsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("NextKnowledgebasesSectionsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ListInParentArticle")))
{
data.ListInParentArticle = BooleanType.UNSET;
}
else
{
data.ListInParentArticle = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("ListInParentArticle")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IncludeSummaryinParent")))
{
data.IncludeSummaryinParent = BooleanType.UNSET;
}
else
{
data.IncludeSummaryinParent = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IncludeSummaryinParent")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Sort")))
{
data.Sort = IntegerType.UNSET;
}
else
{
data.Sort = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Sort")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsSection")))
{
data.IsSection = BooleanType.UNSET;
}
else
{
data.IsSection = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsSection")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsTemp")))
{
data.IsTemp = BooleanType.UNSET;
}
else
{
data.IsTemp = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsTemp")));
}
return(data);
}
private static EmployeeOtherControlsSubscriptionsViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
EmployeeOtherControlsSubscriptionsViewData data = new EmployeeOtherControlsSubscriptionsViewData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("Src")))
{
data.Src = StringType.UNSET;
}
else
{
data.Src = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Src")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ClassSrc")))
{
data.ClassSrc = StringType.UNSET;
}
else
{
data.ClassSrc = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ClassSrc")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ClassDescription")))
{
data.ClassDescription = StringType.UNSET;
}
else
{
data.ClassDescription = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ClassDescription")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("AllowUnsubscribe")))
{
data.AllowUnsubscribe = BooleanType.UNSET;
}
else
{
data.AllowUnsubscribe = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("AllowUnsubscribe")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("SortOrder")))
{
data.SortOrder = IntegerType.UNSET;
}
else
{
data.SortOrder = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SortOrder")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgEmployeesID")))
{
data.OrgEmployeesID = IntegerType.UNSET;
}
else
{
data.OrgEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsID")))
{
data.ControlsID = IntegerType.UNSET;
}
else
{
data.ControlsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlSubscriptionsID")))
{
data.ControlSubscriptionsID = IntegerType.UNSET;
}
else
{
data.ControlSubscriptionsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlSubscriptionsID")));
}
return(data);
}
private static AllEmployeeWithGroupInfoViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
AllEmployeeWithGroupInfoViewData data = new AllEmployeeWithGroupInfoViewData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgEmployeesID")))
{
data.OrgEmployeesID = IntegerType.UNSET;
}
else
{
data.OrgEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("FirstName")))
{
data.FirstName = StringType.UNSET;
}
else
{
data.FirstName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("FirstName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LastName")))
{
data.LastName = StringType.UNSET;
}
else
{
data.LastName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LastName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmployeeTitle")))
{
data.EmployeeTitle = StringType.UNSET;
}
else
{
data.EmployeeTitle = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("EmployeeTitle")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DepartmentName")))
{
data.DepartmentName = StringType.UNSET;
}
else
{
data.DepartmentName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("DepartmentName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LocationName")))
{
data.LocationName = StringType.UNSET;
}
else
{
data.LocationName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LocationName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PhoneNumber")))
{
data.PhoneNumber = StringType.UNSET;
}
else
{
data.PhoneNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("PhoneNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PhoneDescription")))
{
data.PhoneDescription = StringType.UNSET;
}
else
{
data.PhoneDescription = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("PhoneDescription")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Email")))
{
data.Email = StringType.UNSET;
}
else
{
data.Email = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Email")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateHired")))
{
data.DateHired = DateType.UNSET;
}
else
{
data.DateHired = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateHired")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateTerminated")))
{
data.DateTerminated = DateType.UNSET;
}
else
{
data.DateTerminated = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateTerminated")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Manager")))
{
data.Manager = IntegerType.UNSET;
}
else
{
data.Manager = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Manager")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmployeeNumber")))
{
data.EmployeeNumber = StringType.UNSET;
}
else
{
data.EmployeeNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("EmployeeNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Style")))
{
data.Style = StringType.UNSET;
}
else
{
data.Style = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Style")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsActive")))
{
data.IsActive = BooleanType.UNSET;
}
else
{
data.IsActive = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsActive")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NTUserAccount")))
{
data.NTUserAccount = StringType.UNSET;
}
else
{
data.NTUserAccount = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("NTUserAccount")));
}
return(data);
}
private static OrderDtlData GetDataObjectFromReader(SqlDataReader dataReader)
{
OrderDtlData data = new OrderDtlData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("Order_Detail_Id")))
{
data.OrderDetailId = StringType.UNSET;
}
else
{
data.OrderDetailId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Order_Detail_Id")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Orderno")))
{
data.OrderNo = StringType.UNSET;
}
else
{
data.OrderNo = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Orderno")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Type_Ord")))
{
data.TypeOrd = StringType.UNSET;
}
else
{
data.TypeOrd = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Type_Ord")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Item_Id")))
{
data.ItemId = StringType.UNSET;
}
else
{
data.ItemId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Item_Id")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Item_Descrip")))
{
data.ItemDescrip = StringType.UNSET;
}
else
{
data.ItemDescrip = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Item_Descrip")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Bin_No")))
{
data.BinNo = StringType.UNSET;
}
else
{
data.BinNo = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Bin_No")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Qty_Ordered")))
{
data.QtyOrdered = IntegerType.UNSET;
}
else
{
data.QtyOrdered = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Qty_Ordered")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Qty_Picked")))
{
data.QtyPicked = IntegerType.UNSET;
}
else
{
data.QtyPicked = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Qty_Picked")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Qty_Shipped")))
{
data.QtyShipped = IntegerType.UNSET;
}
else
{
data.QtyShipped = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Qty_Shipped")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Shipping_No")))
{
data.ShippingNo = DecimalType.UNSET;
}
else
{
data.ShippingNo = new DecimalType(dataReader.GetDouble(dataReader.GetOrdinal("Shipping_No")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Item_Price")))
{
data.ItemPrice = DecimalType.UNSET;
}
else
{
data.ItemPrice = new DecimalType(dataReader.GetDouble(dataReader.GetOrdinal("Item_Price")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Subtotal")))
{
data.Subtotal = DecimalType.UNSET;
}
else
{
data.Subtotal = new DecimalType(dataReader.GetDouble(dataReader.GetOrdinal("Subtotal")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Personal")))
{
data.Personal = BooleanType.UNSET;
}
else
{
data.Personal = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("Personal")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Tax_Exempt")))
{
data.TaxExempt = BooleanType.UNSET;
}
else
{
data.TaxExempt = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("Tax_Exempt")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Tax_Exempt_No")))
{
data.TaxExemptNo = StringType.UNSET;
}
else
{
data.TaxExemptNo = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Tax_Exempt_No")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Ship_Date")))
{
data.ShipDate = DateType.UNSET;
}
else
{
data.ShipDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("Ship_Date")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Kit")))
{
data.Kit = IntegerType.UNSET;
}
else
{
data.Kit = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Kit")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Guest_Id_Old")))
{
data.GuestIdOld = IntegerType.UNSET;
}
else
{
data.GuestIdOld = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Guest_Id_Old")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Component_Id")))
{
data.ComponentId = StringType.UNSET;
}
else
{
data.ComponentId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Component_Id")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Guest_Id")))
{
data.GuestId = StringType.UNSET;
}
else
{
data.GuestId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Guest_Id")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Xxxsave")))
{
data.Xxxsave = IntegerType.UNSET;
}
else
{
data.Xxxsave = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Xxxsave")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Startkit_Category")))
{
data.StartkitCategory = IntegerType.UNSET;
}
else
{
data.StartkitCategory = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Startkit_Category")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GLPostedDate")))
{
data.GLPostedDate = DateType.UNSET;
}
else
{
data.GLPostedDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("GLPostedDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Revenue")))
{
data.Revenue = DecimalType.UNSET;
}
else
{
data.Revenue = new DecimalType(dataReader.GetDecimal(dataReader.GetOrdinal("Revenue")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DiscountAmount")))
{
data.DiscountAmount = DecimalType.UNSET;
}
else
{
data.DiscountAmount = new DecimalType(dataReader.GetDecimal(dataReader.GetOrdinal("DiscountAmount")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("QtyCanceled")))
{
data.QtyCanceled = IntegerType.UNSET;
}
else
{
data.QtyCanceled = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("QtyCanceled")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CanceledDate")))
{
data.CanceledDate = DateType.UNSET;
}
else
{
data.CanceledDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("CanceledDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ChargeForItem")))
{
data.ChargeForItem = BooleanType.UNSET;
}
else
{
data.ChargeForItem = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("ChargeForItem")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ErrorCode")))
{
data.ErrorCode = StringType.UNSET;
}
else
{
data.ErrorCode = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ErrorCode")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ErrorDepartment")))
{
data.ErrorDepartment = StringType.UNSET;
}
else
{
data.ErrorDepartment = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ErrorDepartment")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("WaitReturnBeginDate")))
{
data.WaitReturnBeginDate = DateType.UNSET;
}
else
{
data.WaitReturnBeginDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("WaitReturnBeginDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("WaitReturnDueDate")))
{
data.WaitReturnDueDate = DateType.UNSET;
}
else
{
data.WaitReturnDueDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("WaitReturnDueDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("WaitReturnReceivedDate")))
{
data.WaitReturnReceivedDate = DateType.UNSET;
}
else
{
data.WaitReturnReceivedDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("WaitReturnReceivedDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ItemNotes")))
{
data.ItemNotes = StringType.UNSET;
}
else
{
data.ItemNotes = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ItemNotes")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("SaveAsShipped")))
{
data.SaveAsShipped = BooleanType.UNSET;
}
else
{
data.SaveAsShipped = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("SaveAsShipped")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PurchasedDate")))
{
data.PurchasedDate = DateType.UNSET;
}
else
{
data.PurchasedDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("PurchasedDate")));
}
return(data);
}
private static ControlEditData GetDataObjectFromReader(SqlDataReader dataReader)
{
ControlEditData data = new ControlEditData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsBasic")))
{
data.IsBasic = BooleanType.UNSET;
}
else
{
data.IsBasic = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsBasic")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Summary")))
{
data.Summary = StringType.UNSET;
}
else
{
data.Summary = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Summary")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Src")))
{
data.Src = StringType.UNSET;
}
else
{
data.Src = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Src")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IconImage")))
{
data.IconImage = StringType.UNSET;
}
else
{
data.IconImage = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("IconImage")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DisplayOnHomePage")))
{
data.DisplayOnHomePage = BooleanType.UNSET;
}
else
{
data.DisplayOnHomePage = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("DisplayOnHomePage")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("SortOrder")))
{
data.SortOrder = IntegerType.UNSET;
}
else
{
data.SortOrder = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SortOrder")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsID")))
{
data.ControlsID = IntegerType.UNSET;
}
else
{
data.ControlsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ControlsGroupsID")))
{
data.ControlsGroupsID = IntegerType.UNSET;
}
else
{
data.ControlsGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupID")))
{
data.OrgGroupID = IntegerType.UNSET;
}
else
{
data.OrgGroupID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ManagePage")))
{
data.ManagePage = StringType.UNSET;
}
else
{
data.ManagePage = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ManagePage")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EntireCompany")))
{
data.EntireCompany = BooleanType.UNSET;
}
else
{
data.EntireCompany = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("EntireCompany")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MustShow")))
{
data.MustShow = BooleanType.UNSET;
}
else
{
data.MustShow = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("MustShow")));
}
return(data);
}
private static NewsViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
NewsViewData data = new NewsViewData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("Title")))
{
data.Title = StringType.UNSET;
}
else
{
data.Title = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Title")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Summary")))
{
data.Summary = StringType.UNSET;
}
else
{
data.Summary = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Summary")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateStart")))
{
data.DateStart = DateType.UNSET;
}
else
{
data.DateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateStart")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateEnd")))
{
data.DateEnd = DateType.UNSET;
}
else
{
data.DateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateEnd")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsPublic")))
{
data.IsPublic = BooleanType.UNSET;
}
else
{
data.IsPublic = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsPublic")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateModified")))
{
data.DateModified = DateType.UNSET;
}
else
{
data.DateModified = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateModified")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LastModifiedFirstName")))
{
data.LastModifiedFirstName = StringType.UNSET;
}
else
{
data.LastModifiedFirstName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LastModifiedFirstName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LastModifiedLastName")))
{
data.LastModifiedLastName = StringType.UNSET;
}
else
{
data.LastModifiedLastName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LastModifiedLastName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CreateFirstName")))
{
data.CreateFirstName = StringType.UNSET;
}
else
{
data.CreateFirstName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("CreateFirstName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CreateLastName")))
{
data.CreateLastName = StringType.UNSET;
}
else
{
data.CreateLastName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("CreateLastName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
{
data.OrgGroupsID = IntegerType.UNSET;
}
else
{
data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NewsImage")))
{
data.NewsImage = StringType.UNSET;
}
else
{
data.NewsImage = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("NewsImage")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("TemplateType")))
{
data.TemplateType = IntegerType.UNSET;
}
else
{
data.TemplateType = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("TemplateType")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NewsArticlesID")))
{
data.NewsArticlesID = IntegerType.UNSET;
}
else
{
data.NewsArticlesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("NewsArticlesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Text")))
{
data.Text = StringType.UNSET;
}
else
{
data.Text = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Text")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LastModifiedID")))
{
data.LastModifiedID = IntegerType.UNSET;
}
else
{
data.LastModifiedID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("LastModifiedID")));
}
return(data);
}
private static NewsArticlesData GetDataObjectFromReader(SqlDataReader dataReader)
{
NewsArticlesData data = new NewsArticlesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("NewsArticlesID")))
{
data.NewsArticlesID = IdType.UNSET;
}
else
{
data.NewsArticlesID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("NewsArticlesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupsID")))
{
data.OrgGroupsID = IntegerType.UNSET;
}
else
{
data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Title")))
{
data.Title = StringType.UNSET;
}
else
{
data.Title = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Title")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Summary")))
{
data.Summary = StringType.UNSET;
}
else
{
data.Summary = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Summary")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Text")))
{
data.Text = StringType.UNSET;
}
else
{
data.Text = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Text")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateCreated")))
{
data.DateCreated = DateType.UNSET;
}
else
{
data.DateCreated = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateCreated")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateModified")))
{
data.DateModified = DateType.UNSET;
}
else
{
data.DateModified = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateModified")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateStart")))
{
data.DateStart = DateType.UNSET;
}
else
{
data.DateStart = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateStart")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateEnd")))
{
data.DateEnd = DateType.UNSET;
}
else
{
data.DateEnd = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateEnd")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgEmployeesID")))
{
data.OrgEmployeesID = IntegerType.UNSET;
}
else
{
data.OrgEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsArchived")))
{
data.IsArchived = BooleanType.UNSET;
}
else
{
data.IsArchived = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsArchived")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("AllowDiscussion")))
{
data.AllowDiscussion = BooleanType.UNSET;
}
else
{
data.AllowDiscussion = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("AllowDiscussion")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsNew")))
{
data.IsNew = BooleanType.UNSET;
}
else
{
data.IsNew = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsNew")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsPublic")))
{
data.IsPublic = BooleanType.UNSET;
}
else
{
data.IsPublic = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsPublic")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LastModifiedOrgEmployeesID")))
{
data.LastModifiedOrgEmployeesID = IntegerType.UNSET;
}
else
{
data.LastModifiedOrgEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("LastModifiedOrgEmployeesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NewsImage")))
{
data.NewsImage = StringType.UNSET;
}
else
{
data.NewsImage = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("NewsImage")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("TemplateType")))
{
data.TemplateType = IntegerType.UNSET;
}
else
{
data.TemplateType = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("TemplateType")));
}
return(data);
}
private static OtherGroupsKnowledgebasesData GetDataObjectFromReader(SqlDataReader dataReader)
{
OtherGroupsKnowledgebasesData data = new OtherGroupsKnowledgebasesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("KnowledgebasesID")))
{
data.KnowledgebasesID = IntegerType.UNSET;
}
else
{
data.KnowledgebasesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("KnowledgebasesID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("SubscriptionID")))
{
data.SubscriptionID = IntegerType.UNSET;
}
else
{
data.SubscriptionID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SubscriptionID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("IsPublic")))
{
data.IsPublic = BooleanType.UNSET;
}
else
{
data.IsPublic = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("IsPublic")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GroupDescription")))
{
data.GroupDescription = StringType.UNSET;
}
else
{
data.GroupDescription = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("GroupDescription")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ArticlesCount")))
{
data.ArticlesCount = IntegerType.UNSET;
}
else
{
data.ArticlesCount = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ArticlesCount")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupID")))
{
data.OrgGroupID = IntegerType.UNSET;
}
else
{
data.OrgGroupID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupID")));
}
return(data);
}