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); }