public SnilsFundResponse ReadItemFields(DataReaderAdapter dataReader, SnilsFundResponse item = null)
{
if (item == null)
{
item = new SnilsFundResponse();
}
item.Id = dataReader.GetInt64("ID");
item.ClientVisitId = dataReader.GetInt64("ClientVisitID");
item.ClientVisitGroupId = dataReader.GetInt64("VisitGroupID");
item.PolicyType = ReferencesMaterializer.Instance.ReadItemFields(dataReader, "PolicyTypeId", "PolicyTypeCode", "PolicyTypeName");
item.UnifiedPolicyNumber = dataReader.GetString("UnifiedPolicyNumber");
item.PolicySeries = dataReader.GetString("PolicySeries");
item.PolicyNumber = dataReader.GetString("PolicyNumber");
item.OKATO = dataReader.GetString("OKATO");
item.OGRN = dataReader.GetString("OGRN");
item.StartDate = dataReader.GetDateTimeNull("StartDate");
item.ExpirationDate = dataReader.GetDateTimeNull("ExpirationDate");
item.FundAnswer = dataReader.GetString("FundAnswer");
item.ErrorMessage = dataReader.GetString("ErrorMessage");
item.FundAnswer = dataReader.GetString("FundAnswer");
item.Order = dataReader.GetInt32("OrderNumber");
item.DataType = (EntityType)(dataReader.GetInt32Null("DataTypeId") ?? 0);
item.CreateDate = dataReader.GetDateTime("CreateDate");
return(item);
}
public FundErrorResponse ReadItemFields(DataReaderAdapter dataReader, FundErrorResponse item = null)
{
if (item == null)
{
item = new FundErrorResponse();
}
item.Id = dataReader.GetInt64("ID");
item.LID = dataReader.GetInt64("LID");
item.ClientVisitId = dataReader.GetInt64("ClientVisitID");
item.ClientVisitGroupId = dataReader.GetInt64("VisitGroupID");
item.PolicyType = ReferencesMaterializer.Instance.ReadItemFields(dataReader, "PolicyTypeId", "PolicyTypeCode", "PolicyTypeName");
item.FundResponseStage = ReferencesMaterializer.Instance.ReadItemFields(dataReader, "FundResponseStageId", "FundResponseStageCode", "FundResponseStageName");
item.DeliveryCenter = ReferencesMaterializer.Instance.ReadItemFields(dataReader, "DeliveryCenterId", "DeliveryCenterCode", "DeliveryCenterName");
item.UnifiedPolicyNumber = dataReader.GetString("UnifiedPolicyNumber");
item.PolicySeries = dataReader.GetString("PolicySeries");
item.PolicyNumber = dataReader.GetString("PolicyNumber");
item.OrderNumber = dataReader.GetInt32("OrderNumber");
item.SMO_ID = dataReader.GetInt32("SMO_ID");
item.OGRN = dataReader.GetString("OGRN");
item.Firstname = dataReader.GetString("Firstname");
item.Secondname = dataReader.GetString("Secondname");
item.Lastname = dataReader.GetString("Lastname");
item.TemporaryPolicyDate = dataReader.GetDateTimeNull("TemporaryPolicyDate");
item.ExpirationDate = dataReader.GetDateTimeNull("ExpirationDate");
item.UnifiedPolicyNumber = dataReader.GetString("UnifiedPolicyNumber");
item.SNILS = dataReader.GetString("SNILS");
item.Sex = dataReader.GetString("Sex");
item.Birthday = dataReader.GetDateTimeNull("Birthday");
item.ErrorText = dataReader.GetString("ErrorText");
item.TerritoryCode = dataReader.GetString("TerritoryCode");
item.CreateDate = dataReader.GetDateTime("CreateDate");
return(item);
}
public Post ReadItemFields(DataReaderAdapter dataReader, Post item = null)
{
if (item == null)
{
item = new Post();
}
item.Id = dataReader.GetInt64("ID");
item.Title = dataReader.GetString("Title");
item.Content = dataReader.GetString("Content");
item.CreateDate = dataReader.GetDateTime("CreateDate");
item.CreateUser = new User()
{
Id = dataReader.GetInt64("CreateUserID"),
Lastname = dataReader.GetString("CreateLastname"),
Firstname = dataReader.GetString("CreateFirstname"),
Secondname = dataReader.GetString("CreateSecondname"),
};
item.UpdateDate = dataReader.GetDateTimeNull("UpdateDate");
item.UpdateUser = new User()
{
Id = dataReader.GetInt64Null("UpdateUserID") ?? 0,
Lastname = dataReader.GetString("UpdateLastname"),
Firstname = dataReader.GetString("UpdateFirstname"),
Secondname = dataReader.GetString("UpdateSecondname"),
};
item.Disabled = dataReader.GetBooleanNull("Disabled") ?? false;
return(item);
}
public SvdFundResponse ReadItemFields(DataReaderAdapter dataReader, SvdFundResponse item = null)
{
if (item == null)
{
item = new SvdFundResponse();
}
item.Id = dataReader.GetInt64("ID");
item.ClientVisitId = dataReader.GetInt64("ClientVisitID");
item.ClientVisitGroupId = dataReader.GetInt64("VisitGroupID");
item.DocumentType = ReferencesMaterializer.Instance.ReadItemFields(dataReader, "DocumentTypeID", "DocumentTypeCode", "DocumentTypeName");
item.Citizenship = ReferencesMaterializer.Instance.ReadItemFields(dataReader, "CitizenshipID", "CitizenshipCode", "CitizenshipName");
item.UnifiedPolicyNumber = dataReader.GetString("UnifiedPolicyNumber");
item.PolicySeries = dataReader.GetString("PolicySeries");
item.PolicyNumber = dataReader.GetString("PolicyNumber");
item.Snils = dataReader.GetString("Snils");
item.OGRN = dataReader.GetString("OGRN");
item.StartDate = dataReader.GetDateTimeNull("StartDate");
item.ExpirationDate = dataReader.GetDateTimeNull("ExpirationDate");
item.OmsCode = dataReader.GetString("OmsCode");
item.Firstname = dataReader.GetString("Firstname");
item.Secondname = dataReader.GetString("Secondname");
item.Lastname = dataReader.GetString("Lastname");
item.Birthday = dataReader.GetDateTimeNull("Birthday");
item.CreateDate = dataReader.GetDateTime("CreateDate");
item.Sex = dataReader.GetString("Sex");
item.DataType = (EntityType)(dataReader.GetInt32Null("DataTypeId") ?? 0);
item.DocumentNumber = dataReader.GetString("DocumentNumber");
item.DocumentSeries = dataReader.GetString("DocumentSeries");
item.DocumentIssueDate = dataReader.GetDateTimeNull("DocumentIssueDate");
item.ERZ = dataReader.GetString("ERZ");
return(item);
}
public ClientAcquisitionEmployee ReadItemFields(DataReaderAdapter reader, ClientAcquisitionEmployee item = null)
{
if (item == null)
{
item = new ClientAcquisitionEmployee();
}
item.Id = reader.GetInt64("ID");
item.UserId = reader.GetInt64Null("UserId");
item.Firstname = reader.GetString("Firstname");
if (string.IsNullOrEmpty(item.Firstname))
{
item.Firstname = reader.GetString("First_n");
}
item.Lastname = reader.GetString("Lastname");
if (string.IsNullOrEmpty(item.Lastname))
{
item.Lastname = reader.GetString("Last_n");
}
item.Secondname = reader.GetString("Secondname");
if (string.IsNullOrEmpty(item.Secondname))
{
item.Secondname = reader.GetString("Second_n");
}
return(item);
}
public PolicyInfo ReadItemFields(DataReaderAdapter dataReader, PolicyInfo item = null)
{
if (item == null)
{
item = new PolicyInfo();
}
item.Id = dataReader.GetInt64("ID");
item.Series = dataReader.GetString("Series");
item.Number = dataReader.GetString("Number");
item.UnifiedPolicyNumber = dataReader.GetString("UnifiedPolicyNumber");
item.OGRN = dataReader.GetString("OGRN");
item.OKATO = dataReader.GetString("OKATO");
item.StartDate = dataReader.GetDateTimeNull("StartDate");
item.EndDate = dataReader.GetDateTimeNull("EndDate");
item.CreateDate = dataReader.GetDateTime("CreateDate");
item.UpdateDate = dataReader.GetDateTime("UpdateDate");
item.PolicyType = ReferencesMaterializer.Instance.ReadItemFields(
dataReader,
"PolicyTypeID",
"PolicyTypeCode",
"PolicyTypeName");
item.SmoId = dataReader.GetInt64Null("SmoId");
item.SmoName = dataReader.GetString("SmoName");
return(item);
}
public CheckClient ReadItemFields(DataReaderAdapter reader, CheckClient item = null)
{
if (item == null)
{
item = new CheckClient();
}
item.Id = reader.GetInt64("ClientID");
item.Lastname = reader.GetString("Lastname");
item.Firstname = reader.GetString("Firstname");
item.Secondname = reader.GetString("Secondname");
item.Sex = reader.GetString("Sex");
item.Birthday = reader.GetDateTimeNull("Birthday");
item.PolicySeries = reader.GetString("PolicySeries");
item.PolicyNumber = reader.GetString("PolicyNumber");
item.UnifiedPolicyNumber = reader.GetString("UnifiedPolicyNumber");
item.DocumentSeries = reader.GetString("DocumentSeries");
item.DocumentNumber = reader.GetString("DocumentNumber");
item.LivingFullAddressString = reader.GetString("LivingFullAddressString");
item.OfficialFullAddressString = reader.GetString("OfficialFullAddressString");
item.TemporaryPolicyNumber = reader.GetString("TemporaryPolicyNumber");
item.TemporaryPolicyDate = reader.GetDateTimeNull("TemporaryPolicyDate");
item.SNILS = reader.GetString("SNILS");
item.Phone = reader.GetString("Phone");
return(item);
}
public Address ReadItemFields(DataReaderAdapter dataReader, Address item = null)
{
if (item == null)
{
item = new Address();
}
item.Id = dataReader.GetInt64("ID");
item.RegionCode = dataReader.GetString("RegionCode");
item.TerritoryCode = dataReader.GetString("TerritoryCode");
item.AreaId = dataReader.GetString("AreaId");
item.RegionId = dataReader.GetString("RegionId");
item.CityId = dataReader.GetString("CityId");
item.LocalityId = dataReader.GetString("LocalityId");
item.Area = dataReader.GetString("Area");
item.Region = dataReader.GetString("Region");
item.Locality = dataReader.GetString("Locality");
item.City = dataReader.GetString("City");
item.Street = dataReader.GetString("Street");
item.House = dataReader.GetString("House");
item.Housing = dataReader.GetString("Housing");
item.Building = dataReader.GetString("Building");
item.Appartment = dataReader.GetString("Appartment");
item.StreetCode = dataReader.GetString("StreetCode");
item.PostIndex = dataReader.GetString("PostIndex");
item.FullAddressString = dataReader.GetString("FullAddressString");
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 Nomernik.History ReadItemFields(DataReaderAdapter reader, Nomernik.History item = null)
{
if (item == null)
{
item = new Nomernik.History();
}
try
{
item.Id = reader.GetInt64("ID");
item.LoadDate = reader.GetDateTime("LoadDate");
item.FileDate = reader.GetDateTime("FileDate");
item.UserID = reader.GetInt64Null("UserID");
item.CountAll = reader.GetInt64Null("CountAll");
item.CountOur = reader.GetInt64Null("CountOur");
item.CountChange = reader.GetInt64Null("CountChange");
item.Firstname = reader.GetString("Firstname");
item.Secondname = reader.GetString("Secondname");
item.Lastname = reader.GetString("Lastname");
}
catch
{
item = null;
}
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 BaseReport ReadItemFields(DataReaderAdapter dataReader, BaseReport item = null)
{
if (item == null)
{
item = new BaseReport();
}
item.Id = dataReader.GetInt64("ID");
item.Firstname = dataReader.GetString("FirstName");
item.Secondname = dataReader.GetString("Secondname");
item.Lastname = dataReader.GetString("Lastname");
item.Birthday = dataReader.GetDateTimeNull("Birthday");
item.SubjectInsuranceID = dataReader.GetInt64Null("SubjectInsuranceID");
item.CreateDate = dataReader.GetDateTime("CreateDate");
item.LastStatusDate = dataReader.GetDateTimeNull("LastStatusDate");
item.ClientID = dataReader.GetInt64Null("ClientID");
item.LastStatementStatusID = dataReader.GetInt64Null("LastStatementStatusID");
item.CuratorID = dataReader.GetInt64Null("CuratorID");
item.ResponsibleID = dataReader.GetInt64Null("ResponsibleID");
item.ExecutiveID = dataReader.GetInt64Null("ExecutiveID");
item.SubjectInsuranceName = dataReader.GetString("SubjectInsuranceName");
item.LastStatusName = dataReader.GetString("LastStatusName");
item.CuratorFIO = dataReader.GetString("CuratorFIO");
item.ResponsibleFIO = dataReader.GetString("ResponsibleFIO");
item.ExecutiveFIO = dataReader.GetString("ExecutiveFIO");
item.Phone = dataReader.GetString("Phone");
item.Email = dataReader.GetString("Email");
item.VisitGroupID = dataReader.GetInt64Null("VisitGroupID");
item.MedDocumentTypeID = dataReader.GetInt64Null("MedDocumentTypeID");
item.MedDocumentTypeName = dataReader.GetString("MedDocumentTypeName");
item.UnifiedPolicyNumber = dataReader.GetString("UnifiedPolicyNumber");
item.LocalityID = dataReader.GetInt64Null("LocalityID");
item.LocalityName = dataReader.GetString("LocalityName");
item.IncidentDate = dataReader.GetDateTimeNull("IncidentDate");
item.Description = dataReader.GetString("Description");
item.IncomingСhannelID = dataReader.GetInt64Null("IncomingСhannelID");
item.IncomingСhannelName = dataReader.GetString("IncomingСhannelName");
item.AuthorID = dataReader.GetInt64Null("AuthorID");
item.AuthorFIO = dataReader.GetString("AuthorFIO");
item.StatusComment = dataReader.GetString("StatusComment");
item.AssignedToUserID = dataReader.GetInt64Null("AssignedToUserID");
item.AssignedToUserFIO = dataReader.GetString("AssignedToUserFIO");
item.ExecuteToDate = dataReader.GetDateTimeNull("ExecuteToDate");
item.Validity = dataReader.GetBoolean("Validity");
item.Judicial = dataReader.GetBoolean("Judicial");
item.ExpertiseID = dataReader.GetInt64Null("ExpertiseID");
item.ExpertiseName = dataReader.GetString("ExpertiseName");
item.ExpertiseDate = dataReader.GetDateTimeNull("ExpertiseDate");
item.FinancialSanctions = dataReader.GetFloatNull("FinancialSanctions");
item.Straf = dataReader.GetFloatNull("Straf");
item.ReasonID = dataReader.GetInt64Null("ReasonID");
item.ReasonName = dataReader.GetString("ReasonName");
item.DescriptionExecution = dataReader.GetString("DescriptionExecution");
item.LPU_Code = dataReader.GetString("LPU_Code");
item.LPU_Name = dataReader.GetString("LPU_Name");
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 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 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 BSOStatusRef ReadItemFields(DataReaderAdapter reader, string id, string name)
{
BSOStatusRef item = new BSOStatusRef();
if (reader.IsNotNull(id))
{
item.Id = reader.GetInt64(id);
item.Name = reader.GetString(name);
}
return(item);
}
public BSOStatusRef ReadItemFields(DataReaderAdapter reader, BSOStatusRef item = null)
{
if (item == null)
{
item = new BSOStatusRef();
}
item.Id = reader.GetInt64("StatusID");
item.Name = reader.GetString("Name");
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 <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 BSOSumStatus ReadItemFields(DataReaderAdapter reader, BSOSumStatus item = null)
{
if (item == null)
{
item = new BSOSumStatus();
}
item.Id = reader.GetInt64("StatusId");
item.Name = reader.GetString("Name");
item.Count = (long)reader.GetInt32("StatusCount");
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");
return(item);
}
public ReferenceItem ReadItemFields(DataReaderAdapter reader, string id, string code, string name)
{
ReferenceItem item = new ReferenceItem();
if (reader.IsNotNull(id))
{
item.Id = reader.GetInt64(id);
item.Name = reader.GetString(name);
item.Code = reader.GetString(code);
}
return(item);
}
public SMSMessage ReadItemFields(DataReaderAdapter dataReader, SMSMessage item = null)
{
if (item == null)
{
item = new SMSMessage();
}
item.Id = dataReader.GetInt64("ID");
item.SenderId = dataReader.GetString("SenderId");
item.Phone = dataReader.GetString("Phone");
item.Message = dataReader.GetString("Message");
return(item);
}
public Role ReadItemFields(DataReaderAdapter dataReader, Role item = null)
{
if (item == null)
{
item = new Role();
}
item.Id = dataReader.GetInt64("ID");
item.Name = dataReader.GetString("Name");
item.Description = dataReader.GetString("Description");
return(item);
}
public Client ReadItemFields(DataReaderAdapter reader, Client item = null)
{
if (item == null)
{
item = new Client();
}
item.Id = reader.GetInt64("ID");
item.ActualVersion = ClientVersionMaterializer.Instance.ReadItemFields(reader);
return(item);
}
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 SmsBase ReadItemFields(DataReaderAdapter reader, SmsBase item = null)
{
if (item == null)
{
item = new SmsBase();
}
item.SenderId = reader.GetString("SenderId");
item.ClientId = reader.GetInt64("ClientId");
item.VisitGroupId = reader.GetInt64("VisitGroupId");
item.VisitId = reader.GetInt64("VisitId");
item.Phone = reader.GetString("Phone");
item.Message = reader.GetString("Message");
item.CreateDate = reader.GetDateTime("CreateDate");
item.Comment = reader.GetString("Comment");
item.StatusIdInside = reader.GetInt64Null("StatusIdInside");
item.StatusFromService = reader.GetString("StatusFromService");
item.MessageFromService = reader.GetString("MessageFromService");
item.SendDate = reader.GetDateTimeNull("SendDate");
item.StatusIdRepeat = reader.GetInt64Null("StatusIdRepeat");
item.StatuRepeatDate = reader.GetDateTimeNull("StatuRepeatDate");
return(item);
}
public BSOHistoryItem ReadItemFields(DataReaderAdapter reader, BSOHistoryItem item = null)
{
if (item == null)
{
item = new BSOHistoryItem();
}
item.Id = reader.GetInt64("BSO_ID");
item.Status = BSOStatusRefMaterializer.Instance.ReadItemFields(reader, "StatusID", "StatusName");
item.StatusDate = reader.GetDateTimeNull("StatusDate");
item.VisitGroupId = reader.GetInt64Null("VisitGroupId");
item.Comment = reader.GetString("Comment");
item.DeliveryCenterId = reader.GetInt64Null("DeliveryCenterID");
item.DeliveryCenter = reader.GetString("DeliveryCenter");
item.DeliveryPointId = reader.GetInt64Null("DeliveryPointId");
item.DeliveryPoint = reader.GetString("DeliveryPoint");
item.UserId = reader.GetInt64("UserID");
item.ResponsibleID = reader.GetInt64Null("ResponsibleID");
item.ChangeDate = reader.GetDateTimeNull("ChangeDate");
return(item);
}
public ClientVisitInfo ReadItemFields(DataReaderAdapter reader, ClientVisitInfo item = null)
{
if (item == null)
{
item = new ClientVisitInfo();
}
item.Id = reader.GetInt64("ID");
item.ClientId = reader.GetInt64("ClientId");
item.VisitGroupId = reader.GetInt64("VisitGroupId");
item.StatusDate = reader.GetDateTime("StatusDate");
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.TemporaryPolicyNumber = reader.GetString("TemporaryPolicyNumber");
item.TemporaryPolicyDate = reader.GetDateTimeNull("TemporaryPolicyDate");
item.UnifiedPolicyNumber = reader.GetString("UnifiedPolicyNumber");
item.PolicySeries = reader.GetString("PolicySeries");
item.PolicyNumber = reader.GetString("PolicyNumber");
item.FundResponseApplyingMessage = reader.GetString("FundResponseApplyingMessage");
item.IsReadyToFundSubmitRequest = reader.GetBoolean("IsReadyToFundSubmitRequest");
item.IsDifficultCase = reader.GetBoolean("IsDifficultCase");
item.PolicyIssueDate = reader.GetDateTimeNull("PolicyIssueDate");
item.SNILS = reader.GetString("SNILS");
item.PolicyParty = reader.GetString("PolicyParty");
item.Status = ReferencesMaterializer.Instance.ReadItemFields(reader, "StatusID", "StatusCode", "StatusName");
item.Scenario = ReferencesMaterializer.Instance.ReadItemFields(reader, "ScenarioID", "ScenarioCode", "ScenarioName");
item.Comment = reader.GetString("Comment");
item.DeliveryCenter = ReferencesMaterializer.Instance.ReadItemFields(reader, "DeliveryCenterId", "DeliveryCenterCode", "DeliveryCenter");
item.DeliveryPoint = reader.GetString("DeliveryPoint");
item.Phone = reader.GetString("Phone");
item.UserId = reader.GetInt64Null("UserId");
item.ClientAcquisitionEmployee = reader.GetString("ClientAcquisitionEmployee");
item.Citizenship = reader.GetString("Citizenship");
return(item);
}