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