public static OnboardRegistration Get(int id) { OnboardRegistration s = null; DataProvider.ExecuteCmd(GetConnection, "dbo.Users_Onboard_SelectById", inputParamMapper : delegate(SqlParameterCollection parameterCollection) { parameterCollection.AddWithValue("@Id", id); }, map : delegate(IDataReader reader, short set) { s = UserMap(reader); } ); return(s); }
private OnboardRegistration UserMap(IDataReader reader) { OnboardRegistration s = new OnboardRegistration(); int startingIndex = 0; s.Id = reader.GetSafeInt32(startingIndex++); s.FirstName = reader.GetSafeString(startingIndex++); s.LastName = reader.GetSafeString(startingIndex++); s.Gender = reader.GetSafeInt32(startingIndex++); s.EthnicityId = reader.GetSafeInt32(startingIndex++); s.DateOfBirth = reader.GetSafeDateTimeNullable(startingIndex++); s.Phone = reader.GetSafeString(startingIndex++); s.AddressId = reader.GetSafeInt32(startingIndex++); s.CountryId = reader.GetSafeInt32(startingIndex++); s.Country = reader.GetSafeString(startingIndex++); s.StreetAddress1 = reader.GetSafeString(startingIndex++); s.StreetAddress2 = reader.GetSafeString(startingIndex++); s.City = reader.GetSafeString(startingIndex++); s.StateProvinceId = reader.GetSafeInt32(startingIndex++); s.StateProvince = reader.GetSafeString(startingIndex++); s.ZipCode = reader.GetSafeString(startingIndex++); s.Facebook = reader.GetSafeString(startingIndex++); s.LinkedIn = reader.GetSafeString(startingIndex++); s.Twitter = reader.GetSafeString(startingIndex++); s.Webpage = reader.GetSafeString(startingIndex++); s.EmploymentStatusId = reader.GetSafeInt32(startingIndex++); s.Bio = reader.GetSafeString(startingIndex++); s.ProgrammingExperience = reader.GetSafeString(startingIndex++); s.WorkExperience = reader.GetSafeString(startingIndex++); s.ExtraCurricularActivities = reader.GetSafeString(startingIndex++); s.LearningObjective = reader.GetSafeString(startingIndex++); s.ReferredBy = reader.GetSafeString(startingIndex++); s.DesiredTrack = reader.GetSafeInt32(startingIndex++); s.DesiredCampusLocation = reader.GetSafeInt32(startingIndex++); s.DesiredSabioStartDate = reader.GetSafeDateTimeNullable(startingIndex++); s.TargetEmploymentLocation = reader.GetSafeString(startingIndex++); s.AccreditationId = reader.GetSafeInt32(startingIndex++); s.OnboardStatus = reader.GetSafeInt32(startingIndex++); return(s); }
private static OnboardRegistration UserMap(IDataReader reader) { OnboardRegistration s = new OnboardRegistration(); int startingIndex = 0; s.Id = reader.GetSafeInt32(startingIndex++); s.FirstName = reader.GetSafeString(startingIndex++); s.LastName = reader.GetSafeString(startingIndex++); s.Gender = reader.GetSafeInt32(startingIndex++); s.EthnicityId = reader.GetSafeInt32(startingIndex++); s.DateOfBirth = reader.GetSafeDateTimeNullable(startingIndex++); s.Phone = reader.GetSafeString(startingIndex++); s.AddressId = reader.GetSafeInt32(startingIndex++); s.CountryId = reader.GetSafeInt32(startingIndex++); s.Country = reader.GetSafeString(startingIndex++); s.StreetAddress1 = reader.GetSafeString(startingIndex++); s.StreetAddress2 = reader.GetSafeString(startingIndex++); s.City = reader.GetSafeString(startingIndex++); s.StateProvinceId = reader.GetSafeInt32(startingIndex++); s.StateProvince = reader.GetSafeString(startingIndex++); s.ZipCode = reader.GetSafeString(startingIndex++); s.Facebook = reader.GetSafeString(startingIndex++); s.LinkedIn = reader.GetSafeString(startingIndex++); s.Twitter = reader.GetSafeString(startingIndex++); s.Webpage = reader.GetSafeString(startingIndex++); s.EmploymentStatusId = reader.GetSafeInt32(startingIndex++); s.Bio = reader.GetSafeString(startingIndex++); s.ProgrammingExperience = reader.GetSafeString(startingIndex++); s.WorkExperience = reader.GetSafeString(startingIndex++); s.ExtraCurricularActivities = reader.GetSafeString(startingIndex++); s.LearningObjective = reader.GetSafeString(startingIndex++); s.ReferredBy = reader.GetSafeString(startingIndex++); s.DesiredTrack = reader.GetSafeInt32(startingIndex++); s.DesiredCampusLocation = reader.GetSafeInt32(startingIndex++); s.DesiredCorbuloStartDate = reader.GetSafeDateTimeNullable(startingIndex++); s.TargetEmploymentLocation = reader.GetSafeString(startingIndex++); s.AccreditationId = reader.GetSafeInt32(startingIndex++); return s; }