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