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 UserData GetDataObjectFromReader(SqlDataReader dataReader)
{
UserData data = new UserData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("UserId")))
{
data.UserId = IdType.UNSET;
}
else
{
data.UserId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("UserId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("UserLogin")))
{
data.UserLogin = StringType.UNSET;
}
else
{
data.UserLogin = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("UserLogin")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("UserLocale")))
{
data.UserLocale = LocaleEnum.UNSET;
}
else
{
data.UserLocale = LocaleEnum.GetInstance(dataReader.GetInt32(dataReader.GetOrdinal("UserLocale")));
}
return(data);
}
private static ImageLibraryData GetDataObjectFromReader(SqlDataReader dataReader)
{
ImageLibraryData data = new ImageLibraryData();
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("FileName")))
{
data.FileName = StringType.UNSET;
}
else
{
data.FileName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("FileName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgGroupID")))
{
data.OrgGroupID = IntegerType.UNSET;
}
else
{
data.OrgGroupID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupID")));
}
return(data);
}
private static CalendarsData GetDataObjectFromReader(SqlDataReader dataReader)
{
CalendarsData data = new CalendarsData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("CalendarsID")))
{
data.CalendarsID = IdType.UNSET;
}
else
{
data.CalendarsID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("CalendarsID")));
}
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("OrgGroupsID")))
{
data.OrgGroupsID = IntegerType.UNSET;
}
else
{
data.OrgGroupsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgGroupsID")));
}
return(data);
}
private static ControlsClassesMapViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
ControlsClassesMapViewData data = new ControlsClassesMapViewData();
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("ControlsClassesID")))
{
data.ControlsClassesID = IntegerType.UNSET;
}
else
{
data.ControlsClassesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("ControlsClassesID")));
}
return(data);
}
private static OrgPhoneNumbersData GetDataObjectFromReader(SqlDataReader dataReader)
{
OrgPhoneNumbersData data = new OrgPhoneNumbersData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgPhoneNumbersID")))
{
data.OrgPhoneNumbersID = IdType.UNSET;
}
else
{
data.OrgPhoneNumbersID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("OrgPhoneNumbersID")));
}
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("OrgEmployeesID")))
{
data.OrgEmployeesID = IntegerType.UNSET;
}
else
{
data.OrgEmployeesID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgEmployeesID")));
}
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("PhoneNumber")))
{
data.PhoneNumber = StringType.UNSET;
}
else
{
data.PhoneNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("PhoneNumber")));
}
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 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 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 NewsArticlesLocationsNameData GetDataObjectFromReader(SqlDataReader dataReader)
{
NewsArticlesLocationsNameData data = new NewsArticlesLocationsNameData();
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("NewsArticlesLocationsID")))
{
data.NewsArticlesLocationsID = IntegerType.UNSET;
}
else
{
data.NewsArticlesLocationsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("NewsArticlesLocationsID")));
}
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("OrgLocationsID")))
{
data.OrgLocationsID = IntegerType.UNSET;
}
else
{
data.OrgLocationsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgLocationsID")));
}
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 TournamentFeeData GetDataObjectFromReader(SqlDataReader dataReader)
{
TournamentFeeData data = new TournamentFeeData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("TournamentFeeId")))
{
data.TournamentFeeId = IdType.UNSET;
}
else
{
data.TournamentFeeId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("TournamentFeeId")));
}
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("Key")))
{
data.Key = StringType.UNSET;
}
else
{
data.Key = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Key")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Fee")))
{
data.Fee = CurrencyType.UNSET;
}
else
{
data.Fee = new CurrencyType(dataReader.GetDecimal(dataReader.GetOrdinal("Fee")));
}
return(data);
}
/// <summary>
/// 型を取得
/// </summary>
/// <param name="typeFullName">型文字列</param>
/// <returns>型</returns>
public Type GetType(string typeFullName)
{
var type = _core.GetType(typeFullName);
if (type != null)
{
return(type);
}
var stringType = StringType.Parse(typeFullName);
if (stringType == null)
{
return(null);
}
type = stringType.MakeType(_core);
if (type != null)
{
_core.AddCache(typeFullName, type);
}
return(type);
}
private static NewEmployeeRequestData GetDataObjectFromReader(SqlDataReader dataReader)
{
NewEmployeeRequestData data = new NewEmployeeRequestData();
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("HireDate")))
{
data.HireDate = DateType.UNSET;
}
else
{
data.HireDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("HireDate")));
}
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("EmployeeID")))
{
data.EmployeeID = IntegerType.UNSET;
}
else
{
data.EmployeeID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("EmployeeID")));
}
return(data);
}
private static SeeAlsoKnowledgebasesSectionsArtclesData GetDataObjectFromReader(SqlDataReader dataReader)
{
SeeAlsoKnowledgebasesSectionsArtclesData data = new SeeAlsoKnowledgebasesSectionsArtclesData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("KnowledgebasesSectionsArticlesID")))
{
data.KnowledgebasesSectionsArticlesID = IntegerType.UNSET;
}
else
{
data.KnowledgebasesSectionsArticlesID = new IntegerType(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("Id")))
{
data.Id = IntegerType.UNSET;
}
else
{
data.Id = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Id")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("SeeAlsoID")))
{
data.SeeAlsoID = IntegerType.UNSET;
}
else
{
data.SeeAlsoID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SeeAlsoID")));
}
return(data);
}
private static EmployeeControlsViewData GetDataObjectFromReader(SqlDataReader dataReader)
{
EmployeeControlsViewData data = new EmployeeControlsViewData();
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("ControlDescription")))
{
data.ControlDescription = StringType.UNSET;
}
else
{
data.ControlDescription = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ControlDescription")));
}
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")));
}
return(data);
}
private static SessionInformationData GetDataObjectFromReader(SqlDataReader dataReader)
{
SessionInformationData data = new SessionInformationData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("SessionId")))
{
data.SessionId = IdType.UNSET;
}
else
{
data.SessionId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("SessionId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DemoId")))
{
data.DemoId = DemoIdType.UNSET;
}
else
{
data.DemoId = DemoIdType.Parse(dataReader.GetString(dataReader.GetOrdinal("DemoId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("UserId")))
{
data.UserId = StringType.UNSET;
}
else
{
data.UserId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("UserId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateCreated")))
{
data.DateCreated = DateType.UNSET;
}
else
{
data.DateCreated = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateCreated")));
}
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 TeamData GetDataObjectFromReader(SqlDataReader dataReader)
{
TeamData data = new TeamData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("TeamId")))
{
data.TeamId = IdType.UNSET;
}
else
{
data.TeamId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("TeamId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("RegistrationKey")))
{
data.RegistrationKey = StringType.UNSET;
}
else
{
data.RegistrationKey = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("RegistrationKey")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Status")))
{
data.Status = TeamStatusEnum.UNSET;
}
else
{
data.Status = TeamStatusEnum.GetInstance(dataReader.GetString(dataReader.GetOrdinal("Status")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("TournamentId")))
{
data.TournamentId = IdType.UNSET;
}
else
{
data.TournamentId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("TournamentId")));
}
return(data);
}
private static RoleData GetDataObjectFromReader(SqlDataReader dataReader)
{
RoleData data = new RoleData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("RoleId")))
{
data.RoleId = RoleEnum.UNSET;
}
else
{
data.RoleId = RoleEnum.GetInstance(dataReader.GetInt32(dataReader.GetOrdinal("RoleId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("RoleName")))
{
data.RoleName = StringType.UNSET;
}
else
{
data.RoleName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("RoleName")));
}
return(data);
}
private static LocaleData GetDataObjectFromReader(SqlDataReader dataReader)
{
LocaleData data = new LocaleData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("LocaleCode")))
{
data.LocaleCode = IdType.UNSET;
}
else
{
data.LocaleCode = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("LocaleCode")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LocaleDescription")))
{
data.LocaleDescription = StringType.UNSET;
}
else
{
data.LocaleDescription = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LocaleDescription")));
}
return(data);
}
private static GroupData GetDataObjectFromReader(SqlDataReader dataReader)
{
GroupData data = new GroupData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("GroupId")))
{
data.GroupId = IdType.UNSET;
}
else
{
data.GroupId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("GroupId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GroupName")))
{
data.GroupName = StringType.UNSET;
}
else
{
data.GroupName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("GroupName")));
}
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 EventData GetDataObjectFromReader(SqlDataReader dataReader)
{
EventData data = new EventData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("Event_Id")))
{
data.EventId = IdType.UNSET;
}
else
{
data.EventId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("Event_Id")));
}
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("Internal")))
{
data.InternalAccess = IntegerType.UNSET;
}
else
{
data.InternalAccess = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("Internal")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("External")))
{
data.ExternalAccess = IntegerType.UNSET;
}
else
{
data.ExternalAccess = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("External")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CloseDate")))
{
data.CloseDate = DateType.UNSET;
}
else
{
data.CloseDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("CloseDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("StartDate")))
{
data.StartDate = DateType.UNSET;
}
else
{
data.StartDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("StartDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DemoItemId")))
{
data.DemoItemId = StringType.UNSET;
}
else
{
data.DemoItemId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("DemoItemId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GuestItemId")))
{
data.GuestItemId = StringType.UNSET;
}
else
{
data.GuestItemId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("GuestItemId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MaxRegistrations")))
{
data.MaxRegistrations = IntegerType.UNSET;
}
else
{
data.MaxRegistrations = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("MaxRegistrations")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Warning")))
{
data.Warning = StringType.UNSET;
}
else
{
data.Warning = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Warning")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MinDemoLevel")))
{
data.MinDemoLevel = IntegerType.UNSET;
}
else
{
data.MinDemoLevel = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("MinDemoLevel")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("SpouseOnly")))
{
data.SpouseOnly = IntegerType.UNSET;
}
else
{
data.SpouseOnly = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("SpouseOnly")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MaxGuests")))
{
data.MaxGuests = IntegerType.UNSET;
}
else
{
data.MaxGuests = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("MaxGuests")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("AskTerms")))
{
data.AskTerms = StringType.UNSET;
}
else
{
data.AskTerms = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("AskTerms")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("AskColor")))
{
data.AskColor = StringType.UNSET;
}
else
{
data.AskColor = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("AskColor")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DemoFirstNameOnly")))
{
data.DemoFirstNameOnly = StringType.UNSET;
}
else
{
data.DemoFirstNameOnly = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("DemoFirstNameOnly")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("AskDemoMobility")))
{
data.AskDemoMobility = StringType.UNSET;
}
else
{
data.AskDemoMobility = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("AskDemoMobility")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("AskDemoHearing")))
{
data.AskDemoHearing = StringType.UNSET;
}
else
{
data.AskDemoHearing = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("AskDemoHearing")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("JointDemoOnly")))
{
data.JointDemoOnly = StringType.UNSET;
}
else
{
data.JointDemoOnly = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("JointDemoOnly")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ShowFinalSplash")))
{
data.ShowFinalSplash = StringType.UNSET;
}
else
{
data.ShowFinalSplash = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ShowFinalSplash")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NoGuestMeal")))
{
data.NoGuestMeal = StringType.UNSET;
}
else
{
data.NoGuestMeal = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("NoGuestMeal")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DependentEvent")))
{
data.DependentEvent = IdType.UNSET;
}
else
{
data.DependentEvent = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("DependentEvent")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("AllowCheckPayment")))
{
data.AllowCheckPayment = StringType.UNSET;
}
else
{
data.AllowCheckPayment = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("AllowCheckPayment")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("NoGuestPeriod")))
{
data.NoGuestPeriod = IntegerType.UNSET;
}
else
{
data.NoGuestPeriod = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("NoGuestPeriod")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CountryCode")))
{
data.CountryCode = CountryEnum.UNSET;
}
else
{
data.CountryCode = CountryEnum.GetInstance(dataReader.GetString(dataReader.GetOrdinal("CountryCode")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EventType")))
{
data.EventType = StringType.UNSET;
}
else
{
data.EventType = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("EventType")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EventDate")))
{
data.EventDate = DateType.UNSET;
}
else
{
data.EventDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("EventDate")));
}
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("CancelFeeItemId")))
{
data.CancelFeeItemId = StringType.UNSET;
}
else
{
data.CancelFeeItemId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("CancelFeeItemId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GuestCancelFeeItemId")))
{
data.GuestCancelFeeItemId = StringType.UNSET;
}
else
{
data.GuestCancelFeeItemId = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("GuestCancelFeeItemId")));
}
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 PaymentData GetDataObjectFromReader(SqlDataReader dataReader)
{
PaymentData data = new PaymentData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("PaymentId")))
{
data.PaymentId = IdType.UNSET;
}
else
{
data.PaymentId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("PaymentId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("TournamentId")))
{
data.Tournament.TournamentId = IdType.UNSET;
}
else
{
data.Tournament.TournamentId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("TournamentId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("AuthorizationNumber")))
{
data.AuthorizationNumber = StringType.UNSET;
}
else
{
data.AuthorizationNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("AuthorizationNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ReferenceNumber")))
{
data.ReferenceNumber = StringType.UNSET;
}
else
{
data.ReferenceNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ReferenceNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("TransactionNumber")))
{
data.TransactionNumber = StringType.UNSET;
}
else
{
data.TransactionNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("TransactionNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Amount")))
{
data.Amount = CurrencyType.UNSET;
}
else
{
data.Amount = new CurrencyType(dataReader.GetDecimal(dataReader.GetOrdinal("Amount")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ProcessDate")))
{
data.ProcessDate = DateType.UNSET;
}
else
{
data.ProcessDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("ProcessDate")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PaymentStatus")))
{
data.PaymentStatus = PaymentStatusEnum.UNSET;
}
else
{
data.PaymentStatus = PaymentStatusEnum.GetInstance(dataReader.GetString(dataReader.GetOrdinal("PaymentStatus")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GolferId")))
{
data.Golfer.GolferId = IdType.UNSET;
}
else
{
data.Golfer.GolferId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("GolferId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CreditCardNumber")))
{
data.CreditCard.Number = StringType.UNSET;
}
else
{
data.CreditCard.Number = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("CreditCardNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ExpirationDate")))
{
data.CreditCard.ExpirationDate = DateType.UNSET;
}
else
{
data.CreditCard.ExpirationDate = new DateType(Spring2.Core.Util.DateUtil.ToDateTimeFromCreditCardDate(dataReader.GetString(dataReader.GetOrdinal("ExpirationDate"))));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CardholderName")))
{
data.CreditCard.Name = StringType.UNSET;
}
else
{
data.CreditCard.Name = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("CardholderName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Address1")))
{
data.CreditCard.Address.Address1 = StringType.UNSET;
}
else
{
data.CreditCard.Address.Address1 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Address1")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Address2")))
{
data.CreditCard.Address.Address2 = StringType.UNSET;
}
else
{
data.CreditCard.Address.Address2 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Address2")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("City")))
{
data.CreditCard.Address.City = StringType.UNSET;
}
else
{
data.CreditCard.Address.City = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("City")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("State")))
{
data.CreditCard.Address.State = USStateCodeEnum.UNSET;
}
else
{
data.CreditCard.Address.State = USStateCodeEnum.GetInstance(dataReader.GetString(dataReader.GetOrdinal("State")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Country")))
{
data.CreditCard.Address.Country = StringType.UNSET;
}
else
{
data.CreditCard.Address.Country = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Country")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PostalCode")))
{
data.CreditCard.Address.PostalCode = StringType.UNSET;
}
else
{
data.CreditCard.Address.PostalCode = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("PostalCode")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("ConfirmationCode")))
{
data.ConfirmationCode = StringType.UNSET;
}
else
{
data.ConfirmationCode = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("ConfirmationCode")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PaymentDate")))
{
data.PaymentDate = DateType.UNSET;
}
else
{
data.PaymentDate = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("PaymentDate")));
}
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);
}
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 OrgLocationsData GetDataObjectFromReader(SqlDataReader dataReader)
{
OrgLocationsData data = new OrgLocationsData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgLocationsID")))
{
data.OrgLocationsID = IdType.UNSET;
}
else
{
data.OrgLocationsID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("OrgLocationsID")));
}
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("Address1")))
{
data.Address1 = StringType.UNSET;
}
else
{
data.Address1 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Address1")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Address2")))
{
data.Address2 = StringType.UNSET;
}
else
{
data.Address2 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Address2")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("City")))
{
data.City = StringType.UNSET;
}
else
{
data.City = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("City")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("State")))
{
data.State = StringType.UNSET;
}
else
{
data.State = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("State")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Country")))
{
data.Country = StringType.UNSET;
}
else
{
data.Country = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Country")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PostCode")))
{
data.PostCode = StringType.UNSET;
}
else
{
data.PostCode = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("PostCode")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Prefix")))
{
data.Prefix = StringType.UNSET;
}
else
{
data.Prefix = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Prefix")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Image")))
{
data.Image = StringType.UNSET;
}
else
{
data.Image = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Image")));
}
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 TestUpdateChangedOnlyData GetDataObjectFromReader(SqlDataReader dataReader)
{
TestUpdateChangedOnlyData data = new TestUpdateChangedOnlyData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("sqlstringcolumn")))
{
data.StringColumn = StringType.UNSET;
}
else
{
data.StringColumn = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("sqlstringcolumn")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("sqlintcolumn")))
{
data.Int32Column = IdType.UNSET;
}
else
{
data.Int32Column = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("sqlintcolumn")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmailFormat")))
{
data.EmailFormat = FormatType.UNSET;
}
else
{
data.EmailFormat = FormatType.GetInstance(dataReader.GetString(dataReader.GetOrdinal("EmailFormat")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("addr1")))
{
data.Address.Address1 = StringType.UNSET;
}
else
{
data.Address.Address1 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("addr1")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("addr2")))
{
data.Address.Address2 = StringType.UNSET;
}
else
{
data.Address.Address2 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("addr2")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("city")))
{
data.Address.City = StringType.UNSET;
}
else
{
data.Address.City = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("city")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("state")))
{
data.Address.State = StringType.UNSET;
}
else
{
data.Address.State = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("state")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("zip")))
{
data.Address.PostalCode = StringType.UNSET;
}
else
{
data.Address.PostalCode = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("zip")));
}
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 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);
}
/// <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 GolferData GetDataObjectFromReader(SqlDataReader dataReader)
{
GolferData data = new GolferData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("GolferId")))
{
data.GolferId = IdType.UNSET;
}
else
{
data.GolferId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("GolferId")));
}
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("MiddleInitial")))
{
data.MiddleInitial = StringType.UNSET;
}
else
{
data.MiddleInitial = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("MiddleInitial")));
}
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("Phone")))
{
data.Phone = StringType.UNSET;
}
else
{
data.Phone = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Phone")));
}
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("Address1")))
{
data.Address.Address1 = StringType.UNSET;
}
else
{
data.Address.Address1 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Address1")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Address2")))
{
data.Address.Address2 = StringType.UNSET;
}
else
{
data.Address.Address2 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Address2")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("City")))
{
data.Address.City = StringType.UNSET;
}
else
{
data.Address.City = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("City")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("State")))
{
data.Address.State = USStateCodeEnum.UNSET;
}
else
{
data.Address.State = USStateCodeEnum.GetInstance(dataReader.GetString(dataReader.GetOrdinal("State")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Country")))
{
data.Address.Country = StringType.UNSET;
}
else
{
data.Address.Country = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Country")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PostalCode")))
{
data.Address.PostalCode = StringType.UNSET;
}
else
{
data.Address.PostalCode = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("PostalCode")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateOfBirth")))
{
data.DateOfBirth = DateType.UNSET;
}
else
{
data.DateOfBirth = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateOfBirth")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Handicap")))
{
data.Handicap = DecimalType.UNSET;
}
else
{
data.Handicap = new DecimalType(dataReader.GetDecimal(dataReader.GetOrdinal("Handicap")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CourseNumber")))
{
data.CourseNumber = StringType.UNSET;
}
else
{
data.CourseNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("CourseNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PlayerNumber")))
{
data.PlayerNumber = StringType.UNSET;
}
else
{
data.PlayerNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("PlayerNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Gender")))
{
data.Gender = GenderType.UNSET;
}
else
{
data.Gender = GenderType.GetInstance(dataReader.GetString(dataReader.GetOrdinal("Gender")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GolferStatus")))
{
data.GolferStatus = GolferStatusEnum.UNSET;
}
else
{
data.GolferStatus = GolferStatusEnum.GetInstance(dataReader.GetString(dataReader.GetOrdinal("GolferStatus")));
}
return(data);
}
