public Submittal BuildEntity(IDataReader reader) { Submittal submittal = new Submittal(reader[FieldNames.SubmittalId], SubmittalFactory.BuildSpecSection(reader), reader[FieldNames.ProjectId]); submittal.TransmittalDate = DataHelper.GetDateTime(reader[FieldNames.TransmittalDate]); submittal.Action = DataHelper.GetEnumValue <ActionStatus>(reader[FieldNames.Action].ToString()); submittal.ContractNumber = reader[FieldNames.ContractNumber].ToString(); submittal.DateReceived = DataHelper.GetNullableDateTime(reader[FieldNames.DateReceived]); submittal.DateToField = DataHelper.GetNullableDateTime(reader[FieldNames.DateToField]); submittal.DeliveryMethod = DataHelper.GetEnumValue <Delivery>(reader[FieldNames.DeliveryMethod].ToString()); submittal.Final = DataHelper.GetBoolean(reader[FieldNames.Final]); submittal.OtherDeliveryMethod = reader[FieldNames.OtherDeliveryMethod].ToString(); submittal.OtherRemainderLocation = reader[FieldNames.OtherRemainderLocation].ToString(); submittal.PhaseNumber = reader[FieldNames.PhaseNumber].ToString(); submittal.Reimbursable = DataHelper.GetBoolean(reader[FieldNames.Reimbursable]); submittal.RemainderLocation = DataHelper.GetEnumValue <SubmittalRemainderLocation>(reader[FieldNames.RemainderLocation].ToString()); submittal.RemainderUnderSubmittalNumber = reader[FieldNames.RemainderUnderSubmittalNumber].ToString(); submittal.Remarks = reader[FieldNames.Remarks].ToString(); submittal.SpecSectionPrimaryIndex = reader[FieldNames.SpecificationSectionPrimaryIndex].ToString(); submittal.SpecSectionSecondaryIndex = reader[FieldNames.SpecificationSectionSecondaryIndex].ToString(); submittal.Status = TransmittalFactory.BuildItemStatus(reader); submittal.TotalPages = DataHelper.GetInteger(reader[FieldNames.TotalPages]); return(submittal); }
public Project BuildEntity(IDataReader reader) { Project project = new Project(reader[FieldNames.ProjectId], reader[FieldNames.ProjectNumber].ToString(), reader[FieldNames.ProjectName].ToString()); project.Address = new Address(reader[FieldNames.Street].ToString(), reader[FieldNames.City].ToString(), reader[FieldNames.State].ToString(), reader[FieldNames.PostalCode].ToString()); project.ContractDate = DataHelper.GetNullableDateTime(reader[FieldNames.ContractDate]); project.EstimatedStartDate = DataHelper.GetNullableDateTime(reader[FieldNames.EstimatedStartDate]); project.EstimatedCompletionDate = DataHelper.GetNullableDateTime(reader[FieldNames.EstimatedCompletionDate]); project.CurrentCompletionDate = DataHelper.GetNullableDateTime(reader[FieldNames.CurrentCompletionDate]); project.ActualCompletionDate = DataHelper.GetNullableDateTime(reader[FieldNames.ActualCompletionDate]); project.ContingencyAllowanceAmount = DataHelper.GetDecimal(reader[FieldNames.ContingencyAllowanceAmount]); project.TestingAllowanceAmount = DataHelper.GetDecimal(reader[FieldNames.TestingAllowanceAmount]); project.UtilityAllowanceAmount = DataHelper.GetDecimal(reader[FieldNames.UtilityAllowanceAmount]); project.OriginalConstructionCost = DataHelper.GetDecimal(reader[FieldNames.OriginalConstructionCost]); project.TotalSquareFeet = DataHelper.GetInteger(reader[FieldNames.TotalSquareFeet]); project.PercentComplete = DataHelper.GetInteger(reader[FieldNames.PercentComplete]); project.Remarks = reader[FieldNames.Remarks].ToString(); project.AeChangeOrderAmount = DataHelper.GetDecimal(reader[FieldNames.AeChangeOrderAmount]); project.ContractReason = reader[FieldNames.ContractReason].ToString(); project.AgencyApplicationNumber = reader[FieldNames.AgencyApplicationNumber].ToString(); project.AgencyFileNumber = reader[FieldNames.AgencyFileNumber].ToString(); project.Segment = new MarketSegment(reader[FieldNames.MarketSegmentId], null, reader[FieldNames.MarketSegmentCode].ToString(), reader[FieldNames.MarketSegmentName].ToString()); return(project); }
public ProposalRequest BuildEntity(IDataReader reader) { ProposalRequest proposalRequest = new ProposalRequest(reader[FieldNames.ProposalRequestId], reader[FieldNames.ProjectId], DataHelper.GetInteger(reader[FieldNames.ProposalRequestNumber])); proposalRequest.Attachment = DataHelper.GetString(reader[FieldNames.Attachment]); proposalRequest.Cause = DataHelper.GetInteger(reader[FieldNames.Cause]); proposalRequest.Description = DataHelper.GetString(reader[FieldNames.Description]); proposalRequest.Initiator = DataHelper.GetString(reader[FieldNames.Initiator]); proposalRequest.IssueDate = DataHelper.GetNullableDateTime(reader[FieldNames.IssueDate]); proposalRequest.Origin = DataHelper.GetInteger(reader[FieldNames.Origin]); proposalRequest.OtherDeliveryMethod = DataHelper.GetString(reader[FieldNames.OtherDeliveryMethod]); proposalRequest.Reason = DataHelper.GetString(reader[FieldNames.Reason]); proposalRequest.TransmittalRemarks = DataHelper.GetString(reader[FieldNames.TransmittalRemarks]); proposalRequest.TransmittalDate = DataHelper.GetDateTime(reader[FieldNames.TransmittalDate]); proposalRequest.DeliveryMethod = DataHelper.GetEnumValue <Delivery>(reader[FieldNames.DeliveryMethod].ToString()); proposalRequest.Final = DataHelper.GetBoolean(reader[FieldNames.Final]); proposalRequest.OtherDeliveryMethod = DataHelper.GetString(reader[FieldNames.OtherDeliveryMethod]); proposalRequest.PhaseNumber = reader[FieldNames.PhaseNumber].ToString(); proposalRequest.Reimbursable = DataHelper.GetBoolean(reader[FieldNames.Reimbursable]); proposalRequest.Remarks = reader[FieldNames.Remarks].ToString(); proposalRequest.TotalPages = DataHelper.GetInteger(reader[FieldNames.TotalPages]); return(proposalRequest); }
public ConstructionChangeDirective BuildEntity(IDataReader reader) { ConstructionChangeDirective ccd = new ConstructionChangeDirective(reader[FieldNames.ConstructionChangeDirectiveId], reader[ProjectFactory.FieldNames.ProjectId], DataHelper.GetInteger(reader[FieldNames.ConstructionChangeDirectiveNumber])); ccd.AmountChanged = DataHelper.GetDecimal(reader[FieldNames.AmountChanged]); ccd.ArchitectSignatureDate = DataHelper.GetNullableDateTime(reader[FieldNames.ArchitectSignatureDate]); ccd.Attachment = DataHelper.GetString(reader[FieldNames.Attachment]); ccd.Cause = DataHelper.GetInteger(reader[FieldNames.Cause]); ccd.ChangeType = DataHelper.GetEnumValue <PriceChangeType>(reader[FieldNames.PriceChangeType].ToString()); ccd.ContractorSignatureDate = DataHelper.GetNullableDateTime(reader[FieldNames.ContractorSignatureDate]); ccd.DeliveryMethod = DataHelper.GetEnumValue <Delivery>(reader[TransmittalFactory.FieldNames.DeliveryMethod]); ccd.Description = DataHelper.GetString(reader[FieldNames.Description]); ccd.Final = DataHelper.GetBoolean(reader[TransmittalFactory.FieldNames.Final]); ccd.Initiator = DataHelper.GetString(reader[FieldNames.Initiator]); ccd.IssueDate = DataHelper.GetNullableDateTime(reader[FieldNames.IssueDate]); ccd.Origin = DataHelper.GetInteger(reader[FieldNames.Origin]); ccd.OtherDeliveryMethod = DataHelper.GetString(reader[TransmittalFactory.FieldNames.OtherDeliveryMethod]); ccd.OwnerSignatureDate = DataHelper.GetNullableDateTime(reader[FieldNames.OwnerSignatureDate]); ccd.PhaseNumber = DataHelper.GetString(reader[TransmittalFactory.FieldNames.PhaseNumber]); ccd.PriceChangeDirection = DataHelper.GetEnumValue <ChangeDirection>(reader[FieldNames.PriceChangeTypeDirection].ToString()); ccd.Reason = DataHelper.GetString(reader[FieldNames.Reason]); ccd.Reimbursable = DataHelper.GetBoolean(reader[TransmittalFactory.FieldNames.Reimbursable]); ccd.Remarks = DataHelper.GetString(reader[FieldNames.Remarks]); ccd.TimeChanged = DataHelper.GetInteger(reader[FieldNames.TimeChangedDays]); ccd.TimeChangeDirection = DataHelper.GetEnumValue <ChangeDirection>(reader[FieldNames.TimeChangeDirection].ToString()); ccd.TotalPages = DataHelper.GetInteger(reader[TransmittalFactory.FieldNames.TotalPages]); ccd.TransmittalDate = DataHelper.GetDateTime(reader[TransmittalFactory.FieldNames.TransmittalDate]); ccd.TransmittalRemarks = DataHelper.GetString(reader[TransmittalFactory.FieldNames.TransmittalRemarks]); return(ccd); }
public override DateTime?GetLastSynchronization() { string query = "SELECT LastSynchronization FROM Synchronization"; using (DbCommand command = database.GetSqlStringCommand(query)) { return(DataHelper.GetNullableDateTime(this.database.ExecuteScalar(command))); } }
internal static RoutingItem BuildRoutingItem(object projectKey, IDataReader reader) { ProjectContact contact = ProjectService.GetProjectContact(projectKey, reader[FieldNames.ProjectContactId]); return(new RoutingItem(reader[FieldNames.RoutingItemId], TransmittalFactory.BuildDiscipline(reader), DataHelper.GetInteger(reader[FieldNames.RoutingOrder]), contact, DataHelper.GetDateTime(reader[FieldNames.DateSent]), DataHelper.GetNullableDateTime(reader[FieldNames.DateReturned]))); }
internal static Contract BuildContract(IDataReader reader) { Contract contract = new Contract(reader[FieldNames.ContractId]); contract.BidPackageNumber = reader[FieldNames.BidPackageNumber].ToString(); contract.ContractAmount = DataHelper.GetDecimal(reader[FieldNames.ContractAmount]); contract.ContractDate = DataHelper.GetNullableDateTime(reader[FieldNames.ContractDate]); ICompanyRepository repository = RepositoryFactory.GetRepository <ICompanyRepository, Company>(); contract.Contractor = repository.FindBy(reader[FieldNames.CompanyId]); contract.NoticeToProceedDate = DataHelper.GetNullableDateTime(reader[FieldNames.NoticeToProceed]); contract.ScopeOfWork = reader[FieldNames.Scope].ToString(); return(contract); }
public RequestForInformation BuildEntity(IDataReader reader) { RequestForInformation rfi = new RequestForInformation(reader[FieldNames.RequestForInformationId], reader[FieldNames.ProjectId], DataHelper.GetInteger(reader[FieldNames.RequestForInformationNumber])); rfi.TransmittalDate = DataHelper.GetDateTime(reader[FieldNames.TransmittalDate]); rfi.DateReceived = DataHelper.GetNullableDateTime(reader[FieldNames.DateReceived]); rfi.DateToField = DataHelper.GetNullableDateTime(reader[FieldNames.DateToField]); rfi.DeliveryMethod = DataHelper.GetEnumValue <Delivery>(reader[FieldNames.DeliveryMethod].ToString()); rfi.Final = DataHelper.GetBoolean(reader[FieldNames.Final]); rfi.OtherDeliveryMethod = reader[FieldNames.OtherDeliveryMethod].ToString(); rfi.PhaseNumber = reader[FieldNames.PhaseNumber].ToString(); rfi.Reimbursable = DataHelper.GetBoolean(reader[FieldNames.Reimbursable]); rfi.Remarks = reader[FieldNames.Remarks].ToString(); rfi.SpecSection = SubmittalFactory.BuildSpecSection(reader); rfi.Status = TransmittalFactory.BuildItemStatus(reader); rfi.TotalPages = DataHelper.GetInteger(reader[FieldNames.TotalPages]); return(rfi); }
public ChangeOrder BuildEntity(IDataReader reader) { ChangeOrder co = new ChangeOrder(reader[FieldNames.ChangeOrderId], reader[FieldNames.ProjectId], DataHelper.GetInteger(reader[FieldNames.ChangeOrderNumber])); co.AgencyApprovedDate = DataHelper.GetNullableDateTime(reader[FieldNames.AgencyApprovedDate]); co.AmountChanged = DataHelper.GetDecimal(reader[FieldNames.AmountChanged]); co.ArchitectSignatureDate = DataHelper.GetNullableDateTime(reader[FieldNames.ArchitectSignatureDate]); co.ChangeType = DataHelper.GetEnumValue <PriceChangeType>(reader[FieldNames.PriceChangeType].ToString()); co.PriceChangeDirection = DataHelper.GetEnumValue <ChangeDirection>(reader[FieldNames.PriceChangeTypeDirection].ToString()); co.ContractorSignatureDate = DataHelper.GetNullableDateTime(reader[FieldNames.ContractorSignatureDate]); co.DateToField = DataHelper.GetNullableDateTime(reader[FieldNames.DateToField]); co.Description = DataHelper.GetString(reader[FieldNames.Description]); co.EffectiveDate = DataHelper.GetDateTime(reader[FieldNames.EffectiveDate]); co.OwnerSignatureDate = DataHelper.GetNullableDateTime(reader[FieldNames.OwnerSignatureDate]); co.TimeChanged = DataHelper.GetInteger(reader[FieldNames.TimeChangedDays]); co.Status = TransmittalFactory.BuildItemStatus(reader); co.TimeChangeDirection = DataHelper.GetEnumValue <ChangeDirection>(reader[FieldNames.TimeChangeDirection].ToString()); return(co); }