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