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