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