private void AddItemStatus(ItemStatusContract itemStatus)
{
string query = string.Format("INSERT INTO ItemStatus (ItemStatusID,Status) VALUES ({0},'{1}');",
itemStatus.Id, itemStatus.Status);
this.database.ExecuteNonQuery(
this.database.GetSqlStringCommand(query));
}
public SubmittalContract()
{
this.projectKey = null;
this.specSection = null;
this.specSectionPrimaryIndex = string.Empty;
this.specSectionSecondaryIndex = string.Empty;
this.to = null;
this.from = null;
this.totalPages = 0;
this.deliveryMethod = DeliveryContract.Hand;
this.otherDeliveryMethod = string.Empty;
this.phaseNumber = string.Empty;
this.reimbursable = false;
this.final = false;
this.copyToList = new List <CopyToContract>();
this.dateReceived = null;
this.contractNumber = string.Empty;
this.trackingItems = new List <TrackingItemContract>();
this.routingItems = new List <RoutingItemContract>();
this.remarks = string.Empty;
this.action = ActionStatusContract.NoExceptionTaken;
this.status = null;
this.dateToField = null;
this.remainderLocation = SubmittalRemainderLocationContract.FilingCabinet;
this.remainderUnderSubmittalNumber = string.Empty;
this.otherRemainderLocation = string.Empty;
this.transmittalRemarks = string.Empty;
}
public RequestForInformationContract()
{
this.projectKey = null;
this.number = 0;
this.from = null;
this.totalPages = 0;
this.deliveryMethod = DeliveryContract.Hand;
this.phaseNumber = string.Empty;
this.reimbursable = false;
this.final = false;
this.copyToList = new List<CopyToContract>();
this.dateReceived = null;
this.dateRequestedBy = null;
this.contractor = null;
this.specSection = null;
this.routingItems = new List<RoutingItemContract>();
this.question = string.Empty;
this.description = string.Empty;
this.contractorProposedSolution = string.Empty;
this.change = false;
this.cause = 0;
this.origin = 0;
this.status = null;
this.dateToField = null;
this.shortAnswer = string.Empty;
this.longAnswer = string.Empty;
this.remarks = string.Empty;
}
public ChangeOrderContract()
{
this.projectKey = null;
this.number = 0;
this.effectiveDate = DateTime.Now;
this.contractor = null;
this.description = string.Empty;
this.originalConstructionCost = 0;
this.newConstructionCost = 0;
this.currentProject = null;
this.changeType = null;
this.changeTypeDirection = ChangeDirectionContract.Unchanged;
this.previousTimeChangedTotal = null;
this.previousAuthorizedChangeOrderAmount = null;
this.amountChanged = 0;
this.timeChangeDirection = ChangeDirectionContract.Unchanged;
this.timeChanged = 0;
this.dateOfSubstantialCompletion = null;
this.routingItems = new List <RoutingItemContract>();
this.status = null;
this.agencyApprovedDate = null;
this.dateToField = null;
this.ownerSignatureDate = null;
this.architectSignatureDate = null;
this.contractorSignatureDate = null;
}
public SubmittalContract()
{
this.projectKey = null;
this.specSection = null;
this.specSectionPrimaryIndex = string.Empty;
this.specSectionSecondaryIndex = string.Empty;
this.to = null;
this.from = null;
this.totalPages = 0;
this.deliveryMethod = DeliveryContract.Hand;
this.otherDeliveryMethod = string.Empty;
this.phaseNumber = string.Empty;
this.reimbursable = false;
this.final = false;
this.copyToList = new List<CopyToContract>();
this.dateReceived = null;
this.contractNumber = string.Empty;
this.trackingItems = new List<TrackingItemContract>();
this.routingItems = new List<RoutingItemContract>();
this.remarks = string.Empty;
this.action = ActionStatusContract.NoExceptionTaken;
this.status = null;
this.dateToField = null;
this.remainderLocation = SubmittalRemainderLocationContract.FilingCabinet;
this.remainderUnderSubmittalNumber = string.Empty;
this.otherRemainderLocation = string.Empty;
}
public ChangeOrderContract()
{
this.projectKey = null;
this.number = 0;
this.effectiveDate = DateTime.Now;
this.contractor = null;
this.description = string.Empty;
this.originalConstructionCost = 0;
this.newConstructionCost = 0;
this.currentProject = null;
this.changeType = null;
this.changeTypeDirection = ChangeDirectionContract.Unchanged;
this.previousTimeChangedTotal = null;
this.previousAuthorizedChangeOrderAmount = null;
this.amountChanged = 0;
this.timeChangeDirection = ChangeDirectionContract.Unchanged;
this.timeChanged = 0;
this.dateOfSubstantialCompletion = null;
this.routingItems = new List<RoutingItemContract>();
this.status = null;
this.agencyApprovedDate = null;
this.dateToField = null;
this.ownerSignatureDate = null;
this.architectSignatureDate = null;
this.contractorSignatureDate = null;
}
public RequestForInformationContract()
{
this.projectKey = null;
this.number = 0;
this.from = null;
this.totalPages = 0;
this.deliveryMethod = DeliveryContract.Hand;
this.phaseNumber = string.Empty;
this.reimbursable = false;
this.final = false;
this.copyToList = new List <CopyToContract>();
this.dateReceived = null;
this.dateRequestedBy = null;
this.contractor = null;
this.specSection = null;
this.routingItems = new List <RoutingItemContract>();
this.question = string.Empty;
this.description = string.Empty;
this.contractorProposedSolution = string.Empty;
this.change = false;
this.cause = 0;
this.origin = 0;
this.status = null;
this.dateToField = null;
this.shortAnswer = string.Empty;
this.longAnswer = string.Empty;
this.remarks = string.Empty;
}
private static ItemStatus ToItemStatus(ItemStatusContract contract)
{
return (contract != null ? new ItemStatus(contract.Id, contract.Status) : null);
}
private static ItemStatusContract ToItemStatusContract(ItemStatus status)
{
ItemStatusContract contract = null;
if (status != null)
{
contract = new ItemStatusContract();
contract.Id = status.Id;
contract.Status = status.Status;
}
return contract;
}
