private static List <ProductCategory> LoadProductCategoryListFromDataReader(OleDbDataReader reader) { var categories = new List <ProductCategory>(); while (reader.Read()) { var category = new ProductCategory(); category.Id = reader.GetInt32(reader.GetOrdinal("CategoryID")); category.ParentId = reader.GetNullableInt32(reader.GetOrdinal("ParentCategoryID")); category.Name = reader.GetStringSafe(reader.GetOrdinal("CategoryName")); category.SortOrder = reader.GetInt32(reader.GetOrdinal("Sequence")); category.PictureFilename = reader.GetStringSafe(reader.GetOrdinal("WS_PictureFile")); category.PictureUpdated = reader.GetBoolean(reader.GetOrdinal("PictureUpdated")); category.TargetUrl = reader.GetStringSafe(reader.GetOrdinal("TargetURL")); category.CreatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm")); category.UpdatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm")); category.DeletedDttm = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm")); categories.Add(category); } return(categories); }
/// <summary> /// Populates a list with customer objects from a data reader object /// </summary> /// <param name="reader">Data Reader containing one or more customer records</param> /// <returns></returns> private static List <Customer> LoadCustomerListFromDataReader(OleDbDataReader reader) { var customers = new List <Customer>(); int customerStoreId = -1; try { while (reader.Read()) { var customer = new Customer(); customer.StoreId = reader.GetNullableInt32("KlantID"); if (customer.StoreId != null) { customerStoreId = (int)customer.StoreId; } customer.WebshopId = reader.GetNullableInt32("KlantID_WS"); customer.LastName = reader.GetStringSafe(reader.GetOrdinal("Naam")); customer.FirstName = reader.GetStringSafe(reader.GetOrdinal("Voornaam")); customer.ShippingAddressStreet = reader.GetStringSafe(reader.GetOrdinal("Straat")); customer.ShippingAddressHomeNumber = reader.GetStringSafe(reader.GetOrdinal("Huisnummer")); customer.ShippingAddressZip = reader.GetStringSafe(reader.GetOrdinal("ZIP")); customer.ShippingAddressCity = reader.GetStringSafe(reader.GetOrdinal("Stad")); customer.ShippingAddressState = reader.GetStringSafe(reader.GetOrdinal("Staat")); customer.ShippingAddressCountry = reader.GetStringSafe(reader.GetOrdinal("Land")); customer.Phone = reader.GetStringSafe(reader.GetOrdinal("Telefoon")); customer.Mobile = reader.GetStringSafe(reader.GetOrdinal("GSM")); customer.Email = reader.GetStringSafe(reader.GetOrdinal("Email")); customer.BillingName = reader.GetStringSafe(reader.GetOrdinal("FaktuurNaam")); customer.BillingContact = reader.GetStringSafe(reader.GetOrdinal("FaktuurContact")); customer.BillingAddress1 = reader.GetStringSafe(reader.GetOrdinal("FaktuurAdres1")); customer.BillingAddress2 = reader.GetStringSafe(reader.GetOrdinal("FaktuurAdres2")); customer.BillingAddress3 = reader.GetStringSafe(reader.GetOrdinal("FaktuurAdres3")); customer.VatNumber = reader.GetStringSafe(reader.GetOrdinal("BTW Nummer")); customer.WebshopDiscount6 = reader.GetByte(reader.GetOrdinal("WebshopDiscount_6")); customer.WebshopDiscount21 = reader.GetByte(reader.GetOrdinal("WebshopDiscount_21")); customer.IsTeacher = reader.GetBoolean(reader.GetOrdinal("IsLeraarOfAcademie")); customer.IsReseller = reader.GetBoolean(reader.GetOrdinal("IsReseller")); customer.Institution = reader.GetStringSafe(reader.GetOrdinal("Academie")); customer.TeachingSubjects = reader.GetStringSafe(reader.GetOrdinal("Discipline")); customer.TeacherCardNumber = reader.GetStringSafe(reader.GetOrdinal("TeacherCardNumber")); customer.TeacherCardValidFrom = reader.GetNullableDateTime(reader.GetOrdinal("TeacherCardValidFrom")); customer.TeacherCardValidTo = reader.GetNullableDateTime(reader.GetOrdinal("TeacherCardValidTo")); customer.TeacherRegistrationNote = reader.GetStringSafe(reader.GetOrdinal("TeacherRegistrationNote")); customer.TeacherConfirmed = reader.GetNullableDateTime(reader.GetOrdinal("TeacherConfirmed")); customer.LastLoginDttm = reader.GetNullableDateTime(reader.GetOrdinal("LastLoginDttm")); customer.CreatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm")); customer.UpdatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm")); customer.DeletedDttm = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm")); customer.ForcePasswordReset = reader.GetBoolean(reader.GetOrdinal("ForcePasswordReset")); customer.Test = reader.GetBoolean(reader.GetOrdinal("Test")); customers.Add(customer); } } catch (Exception exception) { log.ErrorFormat("Error in {0} (data record with KlantID={1}, exception={2})", MethodBase.GetCurrentMethod().Name, customerStoreId, exception); throw; } return(customers); }