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