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