public DataTable ConvertReaderToTable(DbDataReader reader) { DataReaderAdapter dra = new DataReaderAdapter(); DataTable dt = new DataTable(); dra.FillFromReader(dt, reader); return dt; }
public Street ReadItemFields(DataReaderAdapter dataReader, Street item = null) { if (item == null) { item = new Street(); } item.Code = dataReader.GetString("Code"); item.Name = dataReader.GetString("Name"); item.Property = dataReader.GetString("Property"); return(item); }
public override void Fill(DataReaderAdapter adapter, NewsItem target) { base.Fill(adapter, target); target.ID = adapter.GetInt32("ID"); target.Title = adapter.GetString("Title"); target.Text = adapter.GetString("Text"); target.OwnerUserID = adapter.GetInt32("OwnerUserID"); target.OwnerUserName = adapter.GetString("OwnerUserName"); target.AddedDate = adapter.GetDateTime("AddedDate"); target.LogoPath = adapter.GetString("LogoPath"); target.IsDeleted = adapter.GetBoolean("IsDeleted"); }
public Nomernik.ClientShotInfo ReadItemFields(DataReaderAdapter reader, Nomernik.ClientShotInfo item = null) { if (item == null) { item = new Nomernik.ClientShotInfo(); } item.Id = 0; item.Firstname = reader.GetString("Firstname"); item.Secondname = reader.GetString("Secondname"); item.Lastname = reader.GetString("Lastname"); item.Birthday = reader.GetDateTimeNull("Birthday"); item.ClientID = reader.GetInt64Null("ClientID"); return(item); }
DataTable GetTrailersComingIn() { try { string connectionString = WebConfigurationManager.ConnectionStrings["Orchestrator"].ConnectionString; using (SqlConnection conTrailersCominIn = new SqlConnection(connectionString)) { conTrailersCominIn.Open(); SqlCommand cmdTrailersComingIn = new SqlCommand("spTrailer_GetLastPosition"); cmdTrailersComingIn.CommandType = CommandType.StoredProcedure; cmdTrailersComingIn.Connection = conTrailersCominIn; cmdTrailersComingIn.Parameters.Add(new SqlParameter("@TrafficAreas", TrafficAreaIds)); SqlDataReader dr = cmdTrailersComingIn.ExecuteReader(); if (dr != null) { DataReaderAdapter dar = new DataReaderAdapter(); DataTable dt = new DataTable(); dar.FillFromReader(dt, dr); if (dt != null && dt.Columns.Count > 0) { conTrailersCominIn.Close(); return(dt); } } } } catch (SqlException sqle) { if (Utilities.MapSqlException(sqle) && getTrailersComingInErrorCount < 5) { getTrailersComingInErrorCount++; return(GetTrailersComingIn()); } else { throw; } } catch (Exception e) { throw e; } return(null); }
public override void Fill(DataReaderAdapter adapter, Link target) { base.Fill(adapter, target); target.ID = adapter.GetInt32("ID"); target.EntityType = adapter.GetString("EntityType"); target.OwnerUserID = adapter.GetInt32("OwnerUserID"); target.AddedDate = adapter.GetDateTime("AddedDate"); target.OwnerUserName = adapter.GetString("OwnerUserName"); target.EntityID = adapter.GetInt32("EntityID"); target.DisplayText = adapter.GetString("DisplayText"); target.MainLink = adapter.GetString("MainLink"); target.SecondaryLink = adapter.GetString("SecondaryLink"); target.Type = adapter.GetString("Type"); }
public void WhenDataReaderReturnsNoResults_ThenTheDataTableIsNotAffectedAtAll() { MockRepository mockRepository = new MockRepository(MockBehavior.Strict); Mock <IDataReader> dataReaderMock = mockRepository.Create <IDataReader>(); dataReaderMock.Setup(x => x.Read()).Returns(false); Mock <ISimpleDataTable> dataTableMock = mockRepository.Create <ISimpleDataTable>(); DataReaderAdapter target = new DataReaderAdapter(); target.Fill(dataTableMock.Object, dataReaderMock.Object); dataTableMock.Verify(x => x.NewRow(), Times.Never()); }
public void SupportEnumeration() { var customers = _fixture.CreateMany <Customer>(10).ToList(); var customerDr = new DataReaderAdapter <Customer>(customers); var counter = 0; while (customerDr.Read()) { Assert.IsNotNull(customerDr.GetValue(0)); //Id Assert.IsNotNull(customerDr.GetValue(1)); //First name Assert.IsNotNull(customerDr.GetValue(2)); //Last name Assert.IsNotNull(customerDr.GetValue(3)); //Address counter++; } Assert.AreEqual(counter, customers.Count); }
public ReferenceItem ReadItemFields(DataReaderAdapter reader, ReferenceItem item = null) { if (item == null) { item = new ReferenceItem(); } item.Id = reader.GetInt64("ID"); item.Name = reader.GetString("Name"); item.Code = reader.GetString("Code"); item.StartDate = reader.GetDateTimeNull("StartDate"); item.StartDate = reader.GetDateTimeNull("EndDate"); item.IsEnabledForOperator = reader.GetBooleanNull("IsEnabledForOperator"); item.IsEnabledForRegistrator = reader.GetBooleanNull("IsEnabledForRegistrator"); return(item); }
public FiasEntry ReadItemFields(DataReaderAdapter dataReader, FiasEntry item = null) { if (item == null) { item = new FiasEntry(); } item.Id = dataReader.GetString("ID"); item.Name = dataReader.GetString("Name"); item.FiasType = (FiasType)dataReader.GetInt32("FiasType"); item.ParentId = dataReader.GetString("ParentId"); item.RegionCode = dataReader.GetString("RegionCode"); item.AreaCode = dataReader.GetString("AreaCode"); return(item); }
public ReferenceUniversalItem ReadItemFields(DataReaderAdapter reader, ReferenceUniversalItem item = null) { if (item == null) { item = new ReferenceUniversalItem(); } item.ReferenceName = reader.GetString("ReferenceName"); item.Id = reader.GetInt64("ID"); item.Name = reader.GetString("Name"); item.Code = reader.GetString("Code"); item.DisplayName = reader.GetString("DisplayName"); return(item); }
public StatementStatus ReadItemFields(DataReaderAdapter dataReader, StatementStatus item = null) { if (item == null) { item = new StatementStatus(); } item.Id = dataReader.GetInt64("ID"); item.StatementID = dataReader.GetInt64("StatementID"); item.UserID = dataReader.GetInt64("UserID"); item.StatusDate = dataReader.GetDateTime("StatusDate"); item.StatusID = dataReader.GetInt64("StatusID"); item.Comment = dataReader.GetString("Comment"); item.AssignedToUserID = dataReader.GetInt64Null("AssignedToUserID"); item.ExecuteToDate = dataReader.GetDateTimeNull("ExecuteToDate"); return(item); }
public SMO ReadItemFields(DataReaderAdapter dataReader, SMO item = null) { if (item == null) { item = new SMO(); } item.Id = dataReader.GetInt64("ID"); item.RegionCode = dataReader.GetDouble("RegionCode").ToString(); item.TerritoryName = dataReader.GetString("TerritoryName"); item.Shortname = dataReader.GetString("Shortname"); item.Fullname = dataReader.GetString("Fullname"); item.OGRN = dataReader.GetString("OGRN"); item.SMOCode = dataReader.GetString("SMOCode"); item.OKATO = dataReader.GetString("OKATO"); return(item); }
public FundFileHistory ReadItemFields(DataReaderAdapter reader, FundFileHistory item = null) { if (item == null) { item = new FundFileHistory(); } item.ClientID = reader.GetInt64("ClientID"); item.VisitGroupID = reader.GetInt64("VisitGroupID"); item.ClientVisitID = reader.GetInt64("ClientVisitID"); item.StatusID = reader.GetInt64("StatusID"); item.Date = reader.GetDateTime("Date"); item.UserID = reader.GetInt64("UserID"); item.FileName = reader.GetString("FileName"); item.FileUrl = reader.GetString("FileUrl"); return(item); }
public File ReadItemFields(DataReaderAdapter dataReader, File item = null) { if (item == null) { item = new File(); } item.Id = dataReader.GetInt64("FileID"); item.StatementID = dataReader.GetInt64Null("StatementID"); item.StatementStatusID = dataReader.GetInt64Null("StatementStatusID"); item.AttachmentDate = dataReader.GetDateTime("AttachmentDate"); item.UserID = dataReader.GetInt64("UserID"); item.FileName = dataReader.GetString("FileName"); item.FIleUrl = dataReader.GetString("FIleUrl"); item.NominationID = dataReader.GetInt64Null("NominationID"); item.Comment = dataReader.GetString("Comment"); return(item); }
public NOMP ReadItemFields3(DataReaderAdapter reader, NOMP item = null) { if (item == null) { item = new NOMP(); } item.Id = 0; //item.S_CARD = reader.GetString("S_CARD"); item.N_CARD = reader.GetString("N_CARD"); item.ENP = reader.GetString("UnifiedPolicyNumber"); item.VSN = reader.GetString("TemporaryPolicyNumber"); //item.LPU_ID = reader.GetInt64Null("LPU_ID"); //item.DATE_IN = reader.GetDateTimeNull("DATE_IN"); //item.SPOS = reader.GetInt32Null("SPOS"); item.ClientID = reader.GetInt64Null("ClientID"); return(item); }
public DeliveryCenter ReadItemFields(DataReaderAdapter reader) { DeliveryCenter dc = new DeliveryCenter(); dc.Id = reader.GetInt64("DeliveryCenterID"); dc.Name = reader.GetString("DeliveryCenterName"); dc.Code = reader.GetString("DeliveryCenterCode"); dc.Address = reader.GetString("DeliveryCenterAddress"); dc.DisplayName = reader.GetString("DeliveryCenterDisplayName"); dc.District = reader.GetString("DeliveryCenterDistrict"); dc.IsDigitPolicyAbailable = reader.GetBooleanNull("DeliveryCenterIsDigitPolicyAbailable"); dc.ParentId = reader.GetInt64Null("DeliveryCenterParentId"); dc.Phone = reader.GetString("DeliveryCenterPhone"); dc.SMO = reader.GetString("DeliveryCenterSMO"); dc.WorkHours = reader.GetString("DeliveryCenterWorkHours"); return(dc); }
public ClientVisitHistoryItem ReadItemFields(DataReaderAdapter reader, ClientVisitHistoryItem item = null) { if (item == null) { item = new ClientVisitHistoryItem(); } item.ClientVisitId = reader.GetInt64("ClientVisitId"); item.Status = ReferencesMaterializer.Instance.ReadItemFields(reader, "StatusId", "StatusCode", "StatusName"); item.StatusDate = reader.GetDateTime("StatusDate"); item.UserId = reader.GetInt64Null("UserId"); item.UserLogin = reader.GetString("UserLogin"); item.UserFirstname = reader.GetString("UserFirstname"); item.UserLastname = reader.GetString("UserLastname"); item.UserSecondname = reader.GetString("UserSecondname"); return(item); }
public Execution ReadItemFields(DataReaderAdapter dataReader, Execution item = null) { if (item == null) { item = new Execution(); } item.Id = dataReader.GetInt64("ID"); item.StatementID = dataReader.GetInt64("StatementID"); item.Validity = dataReader.GetBoolean("Validity"); item.Judicial = dataReader.GetBoolean("Judicial"); item.ExpertiseDate = dataReader.GetDateTimeNull("ExpertiseDate"); item.FinancialSanctions = dataReader.GetFloatNull("FinancialSanctions"); item.Straf = dataReader.GetFloatNull("Straf"); item.DescriptionExecution = dataReader.GetString("DescriptionExecution"); item.LPU_Code = dataReader.GetString("LPU_Code"); item.LPU_Name = dataReader.GetString("LPU_Name"); return(item); }
public void InsertListToDb() { //Generate a list of 10,000 Customer records var customers = _fixture.CreateMany <Customer>(10000).ToList(); var customerDr = new DataReaderAdapter <Customer>(customers); using (var connection = new SqlConnection(_connectionString)) { connection.Open(); var bulkCopy = new SqlBulkCopy(connection) { DestinationTableName = "[dbo].[Customer]", BatchSize = 1000 }; bulkCopy.WriteToServer(customerDr); bulkCopy.Close(); } }
public ReferenceUniversalItem ReadItemFields(DataReaderAdapter reader, ReferenceUniversalItem item = null) { if (item == null) { item = new ReferenceUniversalItem(); } item.ReferenceName = reader.GetString("ReferenceName"); item.Id = reader.GetInt64("ID"); item.Name = reader.GetString("Name"); item.Code = reader.GetString("Code"); item.StartDate = reader.GetDateTimeNull("StartDate"); item.EndDate = reader.GetDateTimeNull("EndDate"); item.IsEnabledForOperator = reader.GetBooleanNull("IsEnabledForOperator"); item.IsEnabledForRegistrator = reader.GetBooleanNull("IsEnabledForRegistrator"); item.SMO = reader.GetString("SMO"); item.DisplayName = reader.GetString("DisplayName"); item.District = reader.GetString("District"); item.Address = reader.GetString("Address"); item.Phone = reader.GetString("Phone"); item.WorkHours = reader.GetString("WorkHours"); item.IsDigitPolicyAbailable = reader.GetBooleanNull("IsEnabledForRegistrator"); item.ParentId = reader.GetInt64Null("ParentId"); item.IsMFC = reader.GetBooleanNull("IsMFC"); item.DeliveryCenterId = reader.GetInt64Null("DeliveryCenterId"); item.DeliveryPointHeadId = reader.GetInt64Null("DeliveryPointHeadId"); item.SendSms = reader.GetBooleanNull("SendSms"); item.LPU_ID_AIS = reader.GetInt64Null("LPU_ID_AIS"); item.FIL_ID = reader.GetInt64Null("FIL_ID"); item.MCOD = reader.GetString("MCOD"); item.FULLNAME = reader.GetString("FULLNAME"); item.OGRN = reader.GetString("OGRN"); item.FCOD = reader.GetString("FCOD"); item.Lastname = reader.GetString("Lastname"); item.Firstname = reader.GetString("Firstname"); item.Secondname = reader.GetString("Secondname"); item.ErrCode = reader.GetString("ErrCode"); return(item); }
public List <FundResponse> Materialize_List(DataReaderAdapter dataReader) { List <FundResponse> items = new List <FundResponse>(); items.AddRange(S5FundResponseMaterializer.Instance.Materialize_List(dataReader)); dataReader.NextResult(); items.AddRange(S6FundResponseMaterializer.Instance.Materialize_List(dataReader)); dataReader.NextResult(); items.AddRange(S9FundResponseMaterializer.Instance.Materialize_List(dataReader)); dataReader.NextResult(); items.AddRange(SnilsFundResponseMaterializer.Instance.Materialize_List(dataReader)); dataReader.NextResult(); items.AddRange(SvdFundResponseMaterializer.Instance.Materialize_List(dataReader)); dataReader.NextResult(); items.AddRange(FundErrorResponseMaterializer.Instance.Materialize_List(dataReader)); dataReader.NextResult(); items.AddRange(GoznakResponseMaterializer.Instance.Materialize_List(dataReader)); return(items); }
public ClientPretension ReadItemFields(DataReaderAdapter dataReader, ClientPretension item = null) { if (item == null) { item = new ClientPretension(); } item.Generator = dataReader.GetInt64("Generator"); item.ClientID = dataReader.GetInt64("ClientID"); item.LPU_ID = dataReader.GetInt64Null("LPU_ID"); item.DATE_IN = dataReader.GetDateTimeNull("DATE_IN"); item.M_nakt = dataReader.GetString("M_nakt"); item.M_dakt = dataReader.GetDateTimeNull("M_dakt"); item.M_expert_Id = dataReader.GetInt64Null("M_expert_Id"); item.MedicalCenterId = dataReader.GetInt64Null("MedicalCenterId"); item.M_mo = dataReader.GetString("M_mo"); item.M_mcod = dataReader.GetString("M_mcod"); item.MCOD = dataReader.GetString("MCOD"); item.M_period = dataReader.GetString("M_period"); item.M_snpol = dataReader.GetString("M_snpol"); item.M_fd = dataReader.GetString("M_fd"); item.M_nd1 = dataReader.GetString("M_nd1"); item.M_nd2 = dataReader.GetString("M_nd2"); item.IsConfirm = dataReader.GetBooleanNull("IsConfirm"); item.M_osn230_Id = dataReader.GetInt64Null("M_osn230_Id"); item.M_straf = dataReader.GetFloatNull("M_straf"); item.PeriodFrom = dataReader.GetDateTimeNull("PeriodFrom"); item.PeriodTo = dataReader.GetDateTimeNull("PeriodTo"); item.Coefficient = dataReader.GetFloatNull("Coefficient"); item.UserId = dataReader.GetInt64Null("UserId"); item.UserFIO = dataReader.GetString("UserFIO"); item.UserPosition = dataReader.GetString("Position"); item.CreateDate = dataReader.GetDateTime("CreateDate"); item.UpdateUserId = dataReader.GetInt64Null("UpdateUserId"); item.UpdateUserFIO = dataReader.GetString("UpdateUserFIO"); item.UpdateDate = dataReader.GetDateTimeNull("UpdateDate"); item.FileNameLPU = dataReader.GetString("FileNameLPU"); item.FileUrlLPU = dataReader.GetString("FileUrlLPU"); item.FileName2 = dataReader.GetString("FileName2"); item.FileUrl2 = dataReader.GetString("FileUrl2"); return(item); }
public STOP ReadItemFields3(DataReaderAdapter reader, STOP item = null) { if (item == null) { item = new STOP(); } item.Id = 0; //item.SCENARIO = reader.GetString("SCENARIO"); //item.S_CARD = reader.GetString("S_CARD"); item.N_CARD = reader.GetString("N_CARD"); item.ENP = reader.GetString("UnifiedPolicyNumber"); item.VSN = reader.GetString("TemporaryPolicyNumber"); //item.QZ = reader.GetInt64Null("QZ"); //item.DATE_END = reader.GetDateTimeNull("DATE_END"); //item.DATE_ARC = reader.GetDateTimeNull("DATE_ARC"); //item.IST = reader.GetString("IST"); item.ClientID = reader.GetInt64Null("ClientID"); return(item); }
/// <summary> /// Converts <paramref name="dataReader" /> value to DataTable instance. /// </summary> public static DataTable ToDataTable(this IDataReader dataReader) { if (dataReader == null) { throw new ArgumentNullException("dataReader"); } var outputTable = new DataTable { Locale = CultureInfo.InvariantCulture }; var adapter = new DataReaderAdapter(); adapter.FillFromReader(outputTable, dataReader); dataReader.Close(); return(outputTable); }
public Policy ReadItemFields(DataReaderAdapter reader, Policy item = null) { if (item == null) { item = new Policy(); } item.Id = reader.GetInt64("ID"); item.RegionId = reader.GetInt64("RegionId"); item.TemporaryPolicyNumber = reader.GetString("TemporaryPolicyNumber"); item.UnifiedPolicyNumber = reader.GetString("UnifiedPolicyNumber"); item.PolicySeries = reader.GetString("PolicySeries"); item.PolicyNumber = reader.GetString("PolicyNumber"); item.PolicyStatus.Id = reader.GetInt64Null("StatusId") ?? 0;; item.PolicyStatus.Name = reader.GetString("StatusName"); item.ClientVisitDate = reader.GetDateTimeNull("ClientVisitDate"); item.ApplicationMethod = reader.GetString("ApplicationMethod"); item.DeliveryCenter.Id = reader.GetInt64Null("DeliveryCenterId") ?? 0; item.DeliveryCenter.Code = reader.GetString("DeliveryCenterCode"); item.DeliveryCenter.Name = reader.GetString("DeliveryCenterName"); item.Firstname = reader.GetString("FirstName"); item.Secondname = reader.GetString("Secondname"); item.Lastname = reader.GetString("Lastname"); item.Sex = reader.GetString("Sex"); item.Birthday = reader.GetDateTimeNull("Birthday"); item.Phone = reader.GetString("Phone"); item.Category = reader.GetString("Category"); item.Citizenship = reader.GetString("Citizenship"); item.DeliveryPoint.Id = reader.GetInt64Null("DeliveryPointId") ?? 0; item.DeliveryPoint.Code = reader.GetString("DeliveryPointCode"); item.DeliveryPoint.Name = reader.GetString("DeliveryPointName"); item.IssueDate = reader.GetDateTimeNull("IssueDate"); item.StatusDate = reader.GetDateTimeNull("StatusDate"); item.NomernikStatus = reader.GetString("NomernikStatus"); item.LPU = reader.GetString("LPU"); item.AttachmentDate = reader.GetDateTimeNull("AttachmentDate"); item.AttachmentMethod = reader.GetString("AttachmentMethod"); item.BlankNumber = reader.GetString("BlankNumber"); item.SaveDate = reader.GetDateTimeNull("SaveDate"); return(item); }
public ClientPretension ReadItemFields(DataReaderAdapter dataReader, ClientPretension item = null) { if (item == null) { item = new ClientPretension(); } item.Id = dataReader.GetInt64("ID"); item.Generator = dataReader.GetInt64("Generator"); item.ClientID = dataReader.GetInt64("ClientID"); item.LPU_ID = dataReader.GetInt64Null("LPU_ID"); item.DATE_IN = dataReader.GetDateTimeNull("DATE_IN"); item.M_nakt = dataReader.GetString("M_nakt"); item.MedicalCenterId = dataReader.GetInt64Null("MedicalCenterId"); item.M_mo = dataReader.GetString("M_mo"); item.M_mcod = dataReader.GetString("M_mcod"); item.M_period = dataReader.GetString("M_period"); item.M_snpol = dataReader.GetString("M_snpol"); return(item); }
public List <BSO> Materialize_List(DataReaderAdapter dataReader) { List <BSO> items = new List <BSO>(); Dictionary <long, BSO> bsoById = new Dictionary <long, BSO>(); while (dataReader.Read()) { BSO obj = ReadItemFields(dataReader); bsoById.Add(obj.Id, obj); items.Add(obj); } dataReader.NextResult(); while (dataReader.Read()) { long Id = dataReader.GetInt64("BSO_ID"); bsoById[Id].History.Add(BSOHistoryItemMaterializer.Instance.ReadItemFields(dataReader)); } return(items); }
public List <Client> Materialize_List(DataReaderAdapter reader) { List <Client> items = new List <Client>(); Dictionary <long, Client> clientsById = new Dictionary <long, Client>(); while (reader.Read()) { Client obj = ReadItemFields(reader); clientsById.Add(obj.Id, obj); items.Add(obj); } reader.NextResult(); while (reader.Read()) { long clientId = reader.GetInt64("ClientId"); Client obj = clientsById[clientId]; obj.Versions.Add(ClientVersionMaterializer.Instance.ReadItemFields(reader)); } reader.NextResult(); while (reader.Read()) { long clientId = reader.GetInt64("ClientId"); Client obj = clientsById[clientId]; obj.Visits.Add(ClientVisitInfoMaterializer.Instance.ReadItemFields(reader)); } reader.NextResult(); while (reader.Read()) { long clientId = reader.GetInt64("ClientId"); Client obj = clientsById[clientId]; obj.ListSms.Add(SmsMaterializer.Instance.ReadItemFields(reader)); } return(items); }
public BSOInfo ReadItemFields(DataReaderAdapter dataReader, BSOInfo item = null) { if (item == null) { item = new BSOInfo(); } item.Id = dataReader.GetInt64("BSO_ID"); item.PolicyPartyNumber = dataReader.GetString("PolicyPartyNumber"); item.TemporaryPolicyNumber = dataReader.GetString("TemporaryPolicyNumber"); item.Status = BSOStatusRefMaterializer.Instance.ReadItemFields(dataReader, "StatusID", "StatusName"); item.StatusDate = dataReader.GetDateTimeNull("StatusDate"); item.Comment = dataReader.GetString("Comment"); item.DeliveryCenterId = dataReader.GetInt64Null("DeliveryCenterID"); item.DeliveryCenter = dataReader.GetString("DeliveryCenter"); item.DeliveryPointId = dataReader.GetInt64Null("DeliveryPointID"); item.DeliveryPoint = dataReader.GetString("DeliveryPoint"); item.ResponsibleID = dataReader.GetInt64Null("ResponsibleID"); item.ResponsibleName = dataReader.GetString("ResponsibleName"); item.ChangeDate = dataReader.GetDateTimeNull("ChangeDate"); return(item); }
public User ReadItemFields(DataReaderAdapter dataReader, User item = null) { if (item == null) { item = new User(); } item.Id = dataReader.GetInt64("ID"); item.Login = dataReader.GetString("Login"); item.PasswordHash = dataReader.GetString("PasswordHash"); item.Department = ReferencesMaterializer.Instance.ReadItemFields(dataReader, "DepartmentID", "DepartmentCode", "DepartmentName"); item.DepartmentDisplayName = dataReader.GetString("DepartmentDisplayName"); item.DeliveryPoint = ReferencesMaterializer.Instance.ReadItemFields(dataReader, "DeliveryPointID", "DeliveryPointCode", "DeliveryPointName"); item.Firstname = dataReader.GetString("Firstname"); item.Secondname = dataReader.GetString("Secondname"); item.Lastname = dataReader.GetString("Lastname"); item.IsBlocked = dataReader.GetBooleanNull("IsBlocked"); item.CreateDate = dataReader.GetDateTime("CreateDate"); item.UpdateDate = dataReader.GetDateTime("UpdateDate"); return(item); }