private static EntityType FillDataRecord(IDataRecord myDataRecord)
{
EntityType myEntityTypeObject = new EntityType();
myEntityTypeObject.EntityTypeId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("entityTypeId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("entityTypeId")))
{
myEntityTypeObject.EntityTypeName = myDataRecord.GetString(myDataRecord.GetOrdinal("entityTypeName"));
}
return myEntityTypeObject;
}
/// <summary>
/// Initializes a new instance of the Game class and fills it with the data from the IDataRecord
/// </summary>
/// <param name="myDataRecord"></param>
/// <returns></returns>
private static Employee FillDataRecord(IDataRecord myDataRecord)
{
Employee myEmployeeObject = new Employee();
Entity myEntityObject = new Entity();
EntityType myEntityTypeObject = new EntityType();
myEmployeeObject.EmployeeId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("employeeId"));
myEmployeeObject.PersonId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("personId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("payRate")))
{
myEmployeeObject.PersonId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("personId"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("firstName")))
{
myEmployeeObject.FirstName = myDataRecord.GetString(myDataRecord.GetOrdinal("firstName"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("middleName")))
{
myEmployeeObject.MiddleName = myDataRecord.GetString(myDataRecord.GetOrdinal("middleName"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("lastName")))
{
myEmployeeObject.LastName = myDataRecord.GetString(myDataRecord.GetOrdinal("lastName"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("socialSecurityNumber")))
{
myEmployeeObject.SocialSecurityNumber = myDataRecord.GetString(myDataRecord.GetOrdinal("socialSecurityNumber"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("payRate")))
{
myEmployeeObject.PayRate = myDataRecord.GetInt32(myDataRecord.GetOrdinal("payRate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("background")))
{
myEmployeeObject.Background = myDataRecord.GetString(myDataRecord.GetOrdinal("background"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("driversLicenseNumber")))
{
myEmployeeObject.DriversLicenseNumber = myDataRecord.GetString(myDataRecord.GetOrdinal("driversLicenseNumber"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("birthDate")))
{
myEmployeeObject.BirthDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("birthDate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("hireDate")))
{
myEmployeeObject.HireDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("hireDate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("termDate")))
{
myEmployeeObject.TermDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("termDate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("driversLicenceExpireDate")))
{
myEmployeeObject.DriversLicenseExpireDate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("driversLicenceExpireDate"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Category Entity Id")))
{
myEntityTypeObject.Category = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Category Entity Id"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Tier Level Entity Id")))
{
myEntityTypeObject.TierLevel = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Tier Level Entity Id"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Laptop Entity Id")))
{
myEntityTypeObject.Laptop = myDataRecord.GetInt32(myDataRecord.GetOrdinal("Laptop Entity Id"));
}
return myEmployeeObject;
}
