public List <Client> GetAllPartialClients() { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = @"SELECT ID, OldPEID, NewPEID, ClientName, OfficeName, Standing, AddressID FROM tblClients"; connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); List <Client> returnCollection = new List <Client>(); while (reader.Read()) { int index = 0; Client returnValue = new Client() { ID = reader.GetInt32Safe(index++), OldPEID = reader.GetStringSafe(index++), NewPEID = reader.GetStringSafe(index++), ClientName = reader.GetStringSafe(index++), OfficeName = reader.GetStringSafe(index++), Standing = ParseStanding(reader.GetStringSafe(index++)), AddressID = reader.GetInt32Safe(index++) }; returnCollection.Add(returnValue); } return(returnCollection); } } }
public List <Person> GetPartialPeopleByCriteria(string criteria) { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = "SELECT ID, FirstName, LastName, CurrentAssociation FROM tblPeople " + criteria; connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); List <Person> returnCollection = new List <Person>(); while (reader.Read()) { int index = 0; Person returnValue = new Person() { ID = reader.GetInt32Safe(index++), FirstName = reader.GetStringSafe(index++), LastName = reader.GetStringSafe(index++), CurrentAssociation = reader.GetStringSafe(index++) }; returnCollection.Add(returnValue); } return(returnCollection); } } }
public List <RecordSearch> GetPartialRecordSearchesByCriteria(string criteria) { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = @"SELECT ID, ICPrefix, ICYear, ICEnumeration, ICSuffix, ProjectName, Status, LastUpdated FROM tblRecordSearches " + criteria; connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); List <RecordSearch> returnCollection = new List <RecordSearch>(); while (reader.Read()) { int index = 0; RecordSearch returnValue = new RecordSearch() { ID = reader.GetInt32Safe(index++), ICTypePrefix = reader.GetStringSafe(index++), ICYear = reader.GetStringSafe(index++), ICEnumeration = reader.GetInt32Safe(index++), ICSuffix = reader.GetStringSafe(index++), ProjectName = reader.GetStringSafe(index++), Status = reader.GetStringSafe(index++), LastUpdated = reader.GetDateTimeSafe(index++) }; returnCollection.Add(returnValue); } return(returnCollection); } } }
private static List <Binding> LoadBindingListFromDataReader(OleDbDataReader reader) { var bindings = new List <Binding>(); int bindingId = -1; try { while (reader.Read()) { var binding = new Binding(); binding.Id = reader.GetInt32(reader.GetOrdinal("BindingID")); bindingId = binding.Id; binding.Name_EN = reader.GetStringSafe(reader.GetOrdinal("Naam_EN")); binding.Name_NL = reader.GetStringSafe(reader.GetOrdinal("Naam_NL")); binding.Name_FR = reader.GetStringSafe(reader.GetOrdinal("Naam_FR")); binding.CreatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm")); binding.UpdatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm")); binding.DeletedDttm = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm")); bindings.Add(binding); } } catch (Exception exception) { log.ErrorFormat("Error in {0} (data record with BindingID={1}, exception={2})", MethodBase.GetCurrentMethod().Name, bindingId, exception); throw; } return(bindings); }
public RecordSearch GetPartialRecordSearchesByCriteria(int id) { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = @"SELECT ID, ICPrefix, ICYear, ICEnumeration, ICSuffix, ProjectName, Status, LastUpdated FROM tblRecordSearches WHERE ID = " + id; connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); int index = 0; RecordSearch returnValue = new RecordSearch() { ID = reader.GetInt32Safe(index++), ICTypePrefix = reader.GetStringSafe(index++), ICYear = reader.GetStringSafe(index++), ICEnumeration = reader.GetInt32Safe(index++), ICSuffix = reader.GetStringSafe(index++), ProjectName = reader.GetStringSafe(index++), Status = reader.GetStringSafe(index++), LastUpdated = reader.GetDateTimeSafe(index++) }; return(returnValue); } } }
public List <Staff> GetAllStaff() { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = "SELECT ID, PersonName, IsActive FROM tblStaff"; connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); List <Staff> returnCollection = new List <Staff>(); while (reader.Read()) { int index = 0; Staff returnValue = new Staff() { ID = reader.GetInt32Safe(index++), Name = reader.GetStringSafe(index++), IsActive = reader.GetBooleanSafe(index++), IsChanged = false }; returnCollection.Add(returnValue); } return(returnCollection); } } }
private static List <Author> LoadAuthorListFromDataReader(OleDbDataReader reader) { var authors = new List <Author>(); int authorId = -1; try { while (reader.Read()) { var author = new Author(); author.Id = reader.GetInt32(reader.GetOrdinal("ComponistID")); authorId = author.Id; author.Name = reader.GetStringSafe(reader.GetOrdinal("Naam")); author.CreatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm")); author.UpdatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm")); author.DeletedDttm = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm")); authors.Add(author); } } catch (Exception exception) { log.ErrorFormat("Error in {0} (data record with ComponistID={1}, exception={2})", MethodBase.GetCurrentMethod().Name, authorId, exception); throw; } return(authors); }
/// <summary> /// Returns an Country object from the database /// </summary> /// <param name="countryId">Id of the country to be retrieved</param> /// <returns>Returns an Country object populated with data</returns> internal static Country GetCountryById(int countryId) { Country country = null; try { //create and open connection using (OleDbConnection conn = DAL.GetConnection()) { //create command OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from Countries where CountryID = @countryId"; cmd.Parameters.AddWithValue("@countryId", countryId); try { //execute a datareader, closing the connection when all the data is read from it using (OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)) { while (dr.Read()) { country = new Country(); country.Id = dr.GetInt32(dr.GetOrdinal("CountryID")); country.Name = dr.GetStringSafe(dr.GetOrdinal("Country")); country.Iso2Code = dr.GetStringSafe(dr.GetOrdinal("ISO2")); country.IsEuropean = dr.GetBoolean(dr.GetOrdinal("European")); } } } catch (Exception exception) { throw new Exception("Error while executing the following Sql statement:\n" + cmd.ToStringExtended(), exception); } } } catch (Exception exception) { log.Error(Utility.GetExceptionWithMethodSignatureDetails(MethodBase.GetCurrentMethod(), exception, countryId)); throw; } return(country); }
private static List <Instrument> LoadInstrumentListFromDataReader(OleDbDataReader reader) { var instruments = new List <Instrument>(); while (reader.Read()) { var instrument = new Instrument(); instrument.Id = reader.GetInt32(reader.GetOrdinal("InstrumentID")); instrument.Name_EN = reader.GetStringSafe(reader.GetOrdinal("Naam_EN")); instrument.Name_NL = reader.GetStringSafe(reader.GetOrdinal("Naam_NL")); instrument.Name_FR = reader.GetStringSafe(reader.GetOrdinal("Naam_FR")); instrument.CreatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm")); instrument.UpdatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm")); instrument.DeletedDttm = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm")); instruments.Add(instrument); } return(instruments); }
public Client GetClientByID(int id, bool loadAsCurrentClient = true) { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = @"SELECT ID, OldPEID, NewPEID, ClientName, OfficeName, Phone, Email, Website, Standing, AddressID, Notes FROM tblClients WHERE ID = ?"; sqlCommand.Parameters.AddWithValue("ID", id); connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); reader.Read(); if (!reader.HasRows) { return(new Client()); } int index = 0; Client returnValue = new Client() { ID = reader.GetInt32Safe(index++), OldPEID = reader.GetStringSafe(index++), NewPEID = reader.GetStringSafe(index++), ClientName = reader.GetStringSafe(index++), OfficeName = reader.GetStringSafe(index++), Phone = reader.GetStringSafe(index++), Email = reader.GetStringSafe(index++), Website = reader.GetStringSafe(index++), Standing = ParseStanding(reader.GetStringSafe(index++)), AddressID = reader.GetInt32Safe(index), AddressModel = _as.GetAddressByID(reader.GetInt32Safe(index++)), Notes = reader.GetStringSafe(index++) }; if (loadAsCurrentClient) { CurrentClient = returnValue; } return(returnValue); } } }
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); }
public Person GetPersonByID(int id, bool loadAsCurrentClient = true) { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = "SELECT ID, FirstName, LastName, CurrentAssociationID, CurrentAssociation, " + "AddressID, Phone1, Phone2, Email, DisclosureLevel, Notes" + " FROM tblPeople WHERE ID = " + id; connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); if (!reader.HasRows) { return(new Person()); } reader.Read(); int index = 0; Person returnValue = new Person() { ID = reader.GetInt32Safe(index++), FirstName = reader.GetStringSafe(index++), LastName = reader.GetStringSafe(index++), CurrentAssociationID = reader.GetInt32Safe(index++), CurrentAssociation = reader.GetStringSafe(index++), AddressID = reader.GetInt32Safe(index), AddressModel = _as.GetAddressByID(reader.GetInt32(index++)), Phone1 = reader.GetStringSafe(index++), Phone2 = reader.GetStringSafe(index++), Email = reader.GetStringSafe(index++), DisclosureLevel = reader.GetStringSafe(index++), Note = reader.GetStringSafe(index++) }; if (loadAsCurrentClient) { CurrentPerson = returnValue; } return(returnValue); } } }
public Fee GetFeeData(Fee returnValue) { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { string fields = returnValue.GetFieldNames(); sqlCommand.CommandText = "SELECT " + fields + ", Adjustment, AdjustmentExplanation, IsPriority, IsEmergency, IsRapidResponse FROM tblFees WHERE ID = " + returnValue.ID; connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); reader.Read(); int index = 0; foreach (ICharge charge in returnValue.Charges) { switch (charge.Type) { case "variable": VariableCharge vCharge = (VariableCharge)charge; vCharge.Count = reader.GetDecimalSafe(index++); break; case "categorical": CategoricalCharge cCharge = (CategoricalCharge)charge; cCharge.Count = reader.GetDecimalSafe(index++); break; case "boolean": BooleanCharge bCharge = (BooleanCharge)charge; bCharge.IsIncurred = reader.GetBooleanSafe(index++); break; } } returnValue.Adjustment = reader.GetDecimalSafe(index++); returnValue.AdjustmentExplanation = reader.GetStringSafe(index++); returnValue.IsPriority = reader.GetBooleanSafe(index++); returnValue.IsEmergency = reader.GetBooleanSafe(index++); returnValue.IsRapidResponse = reader.GetBooleanSafe(index++); returnValue.CalculateProjectCost(); return(returnValue); } } }
private static List <Manufacturer> LoadManufacturerListFromDataReader(OleDbDataReader reader) { var manufacturers = new List <Manufacturer>(); while (reader.Read()) { var manufacturer = new Manufacturer(); manufacturer.Id = reader.GetInt32(reader.GetOrdinal("UitgeverID")); manufacturer.Name = reader.GetStringSafe(reader.GetOrdinal("Naam")); manufacturer.CreatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm")); manufacturer.UpdatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm")); manufacturer.DeletedDttm = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm")); manufacturers.Add(manufacturer); } return(manufacturers); }
private static List <ProductSeries> LoadProductSeriesListFromDataReader(OleDbDataReader reader) { var productSeries = new List <ProductSeries>(); while (reader.Read()) { var series = new ProductSeries(); series.Id = reader.GetInt32(reader.GetOrdinal("SeriesID")); series.Name = reader.GetStringSafe(reader.GetOrdinal("Naam")); series.CreatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm")); series.UpdatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm")); series.DeletedDttm = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm")); productSeries.Add(series); } return(productSeries); }
private static List <Supplier> LoadSupplierListFromDataReader(OleDbDataReader reader) { var suppliers = new List <Supplier>(); while (reader.Read()) { var supplier = new Supplier(); supplier.Id = reader.GetInt32(reader.GetOrdinal("VerdelerID")); supplier.Name = reader.GetStringSafe(reader.GetOrdinal("Naam")); supplier.MinimumDeliveryDays = reader.GetNullableInt16(reader.GetOrdinal("WS_min_delivery_days")); supplier.MaximumDeliveryDays = reader.GetNullableInt16(reader.GetOrdinal("WS_max_delivery_days")); supplier.CreatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("CreateDttm")); supplier.UpdatedDttm = reader.GetNullableDateTime(reader.GetOrdinal("UpdateDttm")); supplier.DeletedDttm = reader.GetNullableDateTime(reader.GetOrdinal("DeleteDttm")); suppliers.Add(supplier); } return(suppliers); }
public Address GetAddressByID(int id) { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = "SELECT ID, AddressName, AttentionTo, Line1, Line2, City, " + "State, Zip, Notes " + "FROM tblAddresses WHERE ID = ?"; sqlCommand.Parameters.AddWithValue("ID", id); connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); reader.Read(); if (!reader.HasRows) { return(new Address()); } int index = 0; Address returnValue = new Address() { AddressID = reader.GetInt32Safe(index++), AddressName = reader.GetStringSafe(index++), AttentionTo = reader.GetStringSafe(index++), AddressLine1 = reader.GetStringSafe(index++), AddressLine2 = reader.GetStringSafe(index++), City = reader.GetStringSafe(index++), State = reader.GetStringSafe(index++), ZIP = reader.GetStringSafe(index++), Notes = reader.GetStringSafe(index++) }; return(returnValue); } } }
public RecordSearch GetRecordSearchByID(int id, bool loadAsCurrentSearch = true) { using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { using (OleDbCommand sqlCommand = connection.CreateCommand()) { sqlCommand.CommandText = "SELECT ID, ICPrefix, ICYear, ICEnumeration, ICSuffix, " + "DateReceived, DateEntered, DateOfResponse, DateBilled, DatePaid, LastUpdated, " + "RequestorID, AdditionalRequestors, ClientID, MailingAddressID, IsMailingAddressSameAsBilling, BillingAddressID, " + "ProjectName, RecordSearchType, Status, SpecialCaseDetails, " + "MainCounty, AdditionalCounties, PLSS, Acres, LinearMiles, " + "AreResourcesInProject, Recommendation, IsReportReceived, Processor, EncryptionPassword, " + "FeeVersion, FeeID, TotalCost, " + "ProjectNumber, InvoiceNumber, CheckName, CheckNumber, IsPrePaid, IsSelected, Notes " + "FROM tblRecordSearches WHERE ID = " + id; connection.Open(); OleDbDataReader reader = sqlCommand.ExecuteReader(); reader.Read(); int index = 0; RecordSearch returnValue = new RecordSearch() { ID = reader.GetInt32Safe(index++), //0 ICTypePrefix = reader.GetStringSafe(index++), ICYear = reader.GetStringSafe(index++), ICEnumeration = reader.GetInt32Safe(index++), ICSuffix = reader.GetStringSafe(index++), DateReceived = reader.GetDateTimeSafe(index++), //5 DateEntered = reader.GetDateTimeSafe(index++), DateOfResponse = reader.GetDateTimeSafe(index++), DateBilled = reader.GetDateTimeSafe(index++), DatePaid = reader.GetDateTimeSafe(index++), LastUpdated = reader.GetDateTimeSafe(index++), //10 RequestorID = reader.GetInt32Safe(index), Requestor = _ps.GetPersonByID(reader.GetInt32Safe(index++)), AdditionalRequestors = reader.GetStringSafe(index++), ClientID = reader.GetInt32Safe(index), ClientModel = _cs.GetClientByID(reader.GetInt32Safe(index++)), //15 MailingAddress = _as.GetAddressByID(reader.GetInt32Safe(index++)), IsMailingSameAsBilling = reader.GetBooleanSafe(index++), BillingAddress = _as.GetAddressByID(reader.GetInt32Safe(index++)), ProjectName = reader.GetStringSafe(index++), RSType = reader.GetStringSafe(index++), //20 Status = reader.GetStringSafe(index++), SpecialDetails = reader.GetStringSafe(index++), MainCounty = reader.GetStringSafe(index++), AdditionalCounties = ParseAdditionalCounties(reader.GetStringSafe(index++)), PLSS = reader.GetStringSafe(index++), //25 Acres = reader.GetInt32Safe(index++), LinearMiles = reader.GetInt32Safe(index++), AreResourcesInProject = reader.GetBooleanSafe(index++), Recommendation = reader.GetStringSafe(index++), IsReportReceived = reader.GetBooleanSafe(index++), //30 Processor = reader.GetStringSafe(index++), EncryptionPassword = reader.GetStringSafe(index++), FeeVersion = reader.GetStringSafe(index++), FeeID = reader.GetInt32Safe(index++), TotalFee = reader.GetDecimalSafe(index++), ProjectNumber = reader.GetStringSafe(index++), InvoiceNumber = reader.GetStringSafe(index++), CheckName = reader.GetStringSafe(index++), CheckNumber = reader.GetStringSafe(index++), IsPrePaid = reader.GetBooleanSafe(index++), IsSelected = reader.GetBooleanSafe(index++), Notes = reader.GetStringSafe(index++), }; returnValue.Fee = GetFeeData(returnValue.FeeVersion, returnValue.FeeID); if (returnValue.IsMailingSameAsBilling) { returnValue.BillingAddress = returnValue.MailingAddress; } if (loadAsCurrentSearch) { CurrentRecordSearch = returnValue; } return(returnValue); } } }
/// <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); }