public List <STOP> Materialize_List(DataReaderAdapter reader) { List <STOP> items = new List <STOP>(); /// <summary> /// выбираем из таблицы стоп-листа (STOP) /// </summary> while (reader.Read()) { STOP obj = ReadItemFields1(reader); items.Add(obj); } /// <summary> /// потом собираем все, что нашли в базе по UnifiedPolicyNumber (ENP) /// </summary> reader.NextResult(); while (reader.Read()) { STOP obj = ReadItemFields2(reader); items.Add(obj); } /// <summary> /// потом собираем все, что нашли в базе по "старому" номеру полиса N_CARD /// </summary> reader.NextResult(); while (reader.Read()) { STOP obj = ReadItemFields3(reader); items.Add(obj); } return(items); }
public List <ClientVisit> Materialize_List(DataReaderAdapter dataReader) { List <ClientVisit> items = new List <ClientVisit>(); while (dataReader.Read()) { ClientVisit obj = ReadItemFields(dataReader); obj.OldClientInfo = ClientDao.Instance.ClientVersion_Get(obj.OldClientInfo.Id); obj.NewClientInfo = ClientDao.Instance.ClientVersion_Get(obj.NewClientInfo.Id); obj.OldDocument = DocumentDao.Instance.GetDocument(obj.OldDocument.Id); obj.NewDocument = DocumentDao.Instance.GetDocument(obj.NewDocument.Id); obj.NewForeignDocument = DocumentDao.Instance.GetDocument(obj.NewForeignDocument.Id); obj.OldForeignDocument = DocumentDao.Instance.GetDocument(obj.OldForeignDocument.Id); obj.OldPolicy = PolicyDao.Instance.GetPolicy(obj.OldPolicy.Id); obj.NewPolicy = PolicyDao.Instance.GetPolicy(obj.NewPolicy.Id); obj.RegistrationAddress = AddressDao.Instance.GetAddress(obj.RegistrationAddress.Id); obj.LivingAddress = AddressDao.Instance.GetAddress(obj.LivingAddress.Id); obj.Registrator = UserDao.Instance.User_Get(obj.Registrator.Id); obj.Representative = RepresentativeDao.Instance.GetRepresentative(obj.Representative.Id); items.Add(obj); } return(items); }
public List <BSOInfo> Materialize_List(DataReaderAdapter dataReader) { List <BSOInfo> items = new List <BSOInfo>(); while (dataReader.Read()) { BSOInfo obj = ReadItemFields(dataReader); items.Add(obj); } return(items); }
public List <ClientPretension> Materialize_List(DataReaderAdapter dataReader) { List <ClientPretension> items = new List <ClientPretension>(); while (dataReader.Read()) { ClientPretension obj = ReadItemFields(dataReader); items.Add(obj); } return(items); }
public List <Nomernik.History> Materialize_List(DataReaderAdapter reader) { List <Nomernik.History> items = new List <Nomernik.History>(); while (reader.Read()) { Nomernik.History obj = ReadItemFields(reader); items.Add(obj); } return(items); }
public List <ClientAcquisitionEmployee> Materialize_List(DataReaderAdapter reader) { List <ClientAcquisitionEmployee> items = new List <ClientAcquisitionEmployee>(); while (reader.Read()) { ClientAcquisitionEmployee obj = ReadItemFields(reader); items.Add(obj); } return(items); }
public List <Representative> Materialize_List(DataReaderAdapter reader) { List <Representative> items = new List <Representative>(); while (reader.Read()) { Representative obj = ReadItemFields(reader); items.Add(obj); } return(items); }
public List <ReferenceUniversalItem> Materialize_List(DataReaderAdapter reader) { List <ReferenceUniversalItem> items = new List <ReferenceUniversalItem>(); while (reader.Read()) { ReferenceUniversalItem obj = ReadItemFields(reader); items.Add(obj); } return(items); }
public List <SmsTemplate> Materialize_List(DataReaderAdapter dataReader) { List <SmsTemplate> items = new List <SmsTemplate>(); while (dataReader.Read()) { SmsTemplate obj = ReadItemFields(dataReader); items.Add(obj); } return(items); }
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 <ClientVisitInfo> Materialize_List(DataReaderAdapter reader) { List <ClientVisitInfo> items = new List <ClientVisitInfo>(); while (reader.Read()) { ClientVisitInfo obj = ReadItemFields(reader); items.Add(obj); } return(items); }
public List <BSOStatusRef> Materialize_List(DataReaderAdapter reader) { List <BSOStatusRef> items = new List <BSOStatusRef>(); while (reader.Read()) { BSOStatusRef obj = ReadItemFields(reader); items.Add(obj); } return(items); }
public List <CheckClient> Materialize_List(DataReaderAdapter reader) { List <CheckClient> items = new List <CheckClient>(); while (reader.Read()) { CheckClient obj = ReadItemFields(reader); items.Add(obj); } 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 List <FiasEntry> Materialize_List(DataReaderAdapter dataReader) { List <FiasEntry> items = new List <FiasEntry>(); while (dataReader.Read()) { FiasEntry obj = ReadItemFields(dataReader); items.Add(obj); } return(items); }
public List <Execution> Materialize_List(DataReaderAdapter reader) { List <Execution> items = new List <Execution>(); while (reader.Read()) { Execution obj = ReadItemFields(reader); items.Add(obj); } return(items); }
public List <Document> Materialize_List(DataReaderAdapter dataReader) { List <Document> items = new List <Document>(); while (dataReader.Read()) { Document obj = ReadItemFields(dataReader); items.Add(obj); } return(items); }
public List <Address> Materialize_List(DataReaderAdapter dataReader) { List <Address> items = new List <Address>(); while (dataReader.Read()) { Address obj = ReadItemFields(dataReader); items.Add(obj); } return(items); }
public List <FundRequestRecid> Materialize_List(DataReaderAdapter dataReader) { List <FundRequestRecid> items = new List <FundRequestRecid>(); while (dataReader.Read()) { FundRequestRecid obj = ReadItemFields(dataReader); items.Add(obj); } return(items); }
public List <DeliveryCenter> Materialize_List(DataReaderAdapter dataReader) { List <DeliveryCenter> items = new List <DeliveryCenter>(); while (dataReader.Read()) { DeliveryCenter obj = ReadItemFields(dataReader); items.Add(obj); } return(items); }
public List <SnilsFundResponse> Materialize_List(DataReaderAdapter dataReader) { List <SnilsFundResponse> items = new List <SnilsFundResponse>(); while (dataReader.Read()) { SnilsFundResponse obj = ReadItemFields(dataReader); items.Add(obj); } return(items); }
public List <ClientVisit.SaveData> Materialize_List(DataReaderAdapter dataReader) { List <ClientVisit.SaveData> items = new List <ClientVisit.SaveData>(); while (dataReader.Read()) { ClientVisit.SaveData obj = ReadItemFields(dataReader); items.Add(obj); } return(items); }
public List <StatementStatus> Materialize_List(DataReaderAdapter reader) { List <StatementStatus> items = new List <StatementStatus>(); while (reader.Read()) { StatementStatus obj = ReadItemFields(reader); items.Add(obj); } return(items); }
public List <Statement> Materialize_List(DataReaderAdapter reader) { List <Statement> items = new List <Statement>(); Dictionary <long, Statement> statementsById = new Dictionary <long, Statement>(); while (reader.Read()) { Statement obj = ReadItemFields(reader); statementsById.Add(obj.Id, obj); items.Add(obj); } reader.NextResult(); while (reader.Read()) { long statementId = reader.GetInt64("StatementId"); Statement obj = statementsById[statementId]; obj.StatementStatuses.Add(StatementStatusMaterializer.Instance.ReadItemFields(reader)); } //public List<File> Files reader.NextResult(); while (reader.Read()) { long statementId = reader.GetInt64("StatementId"); Statement obj = statementsById[statementId]; obj.Files.Add(FileMaterializer.Instance.ReadItemFields(reader)); } //public Execution Execution { get; set; } reader.NextResult(); while (reader.Read()) { long statementId = reader.GetInt64("StatementId"); Statement obj = statementsById[statementId]; obj.Execution = ExecutionMaterializer.Instance.ReadItemFields(reader); } return(items); }
public List <User> Materialize_List(DataReaderAdapter dataReader) { List <User> items = new List <User>(); Dictionary <long, User> usersById = new Dictionary <long, User>(); while (dataReader.Read()) { User obj = ReadItemFields(dataReader); usersById.Add(obj.Id, obj); items.Add(obj); } dataReader.NextResult(); while (dataReader.Read()) { long userId = dataReader.GetInt64("UserID"); Role obj = RoleMaterializer.Instance.ReadItemFields(dataReader); usersById[userId].Roles.Add(obj); } return(items); }
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 FundResponse Materialize(DataReaderAdapter dataReader) { if (dataReader.Read()) { string type = dataReader.GetString("FundResponseType"); if (type.Equals(S5FundResponse.Name, StringComparison.InvariantCultureIgnoreCase)) { return(S5FundResponseMaterializer.Instance.ReadItemFields(dataReader)); } if (type.Equals(S6FundResponse.Name, StringComparison.InvariantCultureIgnoreCase)) { return(S6FundResponseMaterializer.Instance.ReadItemFields(dataReader)); } if (type.Equals(S9FundResponse.Name, StringComparison.InvariantCultureIgnoreCase)) { return(S9FundResponseMaterializer.Instance.ReadItemFields(dataReader)); } if (type.Equals(SnilsFundResponse.Name, StringComparison.InvariantCultureIgnoreCase)) { return(SnilsFundResponseMaterializer.Instance.ReadItemFields(dataReader)); } if (type.Equals(SvdFundResponse.Name, StringComparison.InvariantCultureIgnoreCase)) { return(SvdFundResponseMaterializer.Instance.ReadItemFields(dataReader)); } if (type.Equals(FundErrorResponse.Name, StringComparison.InvariantCultureIgnoreCase)) { return(FundErrorResponseMaterializer.Instance.ReadItemFields(dataReader)); } if (type.Equals(GoznakResponse.Name, StringComparison.InvariantCultureIgnoreCase)) { return(GoznakResponseMaterializer.Instance.ReadItemFields(dataReader)); } } return(null); }