private void InsertRoutingItem(RoutingItem item, object key) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO RoutingItem ({0},{1},{2},{3},{4},{5}) ", TransmittalFactory.FieldNames.RoutingItemId, TransmittalFactory.FieldNames.DisciplineId, TransmittalFactory.FieldNames.RoutingOrder, TransmittalFactory.FieldNames.ProjectContactId, TransmittalFactory.FieldNames.DateSent, TransmittalFactory.FieldNames.DateReturned)); builder.Append(string.Format("VALUES ({0},{1},{2},{3},{4},{5});", DataHelper.GetSqlValue(item.Key), DataHelper.GetSqlValue(item.Discipline.Key), DataHelper.GetSqlValue(item.RoutingOrder), DataHelper.GetSqlValue(item.Recipient.Key), DataHelper.GetSqlValue(item.DateSent), DataHelper.GetSqlValue(item.DateReturned))); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); builder = new StringBuilder(50); builder.Append(string.Format("INSERT INTO {0}RoutingItem ({1},{2}) ", this.EntityName, this.KeyFieldName, TransmittalFactory.FieldNames.RoutingItemId)); builder.Append(string.Format("VALUES ({0},{1});", DataHelper.GetSqlValue(key), DataHelper.GetSqlValue(item.Key))); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); }
private void InsertTrackingItem(TrackingItem item, object key) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO SubmittalTrackingItem ({0},{1},{2},{3},{4},{5},{6},{7}) ", SubmittalFactory.FieldNames.SubmittalId, SubmittalFactory.FieldNames.TotalItemsReceived, SubmittalFactory.FieldNames.TotalItemsSent, SubmittalFactory.FieldNames.DeferredApproval, SubmittalFactory.FieldNames.SubstitutionNumber, SubmittalFactory.FieldNames.SpecificationSectionId, SubmittalFactory.FieldNames.Description, SubmittalFactory.FieldNames.Status)); builder.Append(string.Format("VALUES ({0},{1},{2},{3},{4},{5},{6},{7});", DataHelper.GetSqlValue(key), DataHelper.GetSqlValue(item.TotalItemsReceived), DataHelper.GetSqlValue(item.TotalItemsSent), DataHelper.GetSqlValue(item.DeferredApproval), DataHelper.GetSqlValue(item.SubstitutionNumber), DataHelper.GetSqlValue(item.SpecSection.Key), DataHelper.GetSqlValue(item.Description), DataHelper.GetSqlValue(item.Status))); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); }
protected override void PersistNewItem(Company item) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO Company ({0},{1},{2},{3},{4},{5},{6}) ", CompanyFactory.FieldNames.CompanyId, CompanyFactory.FieldNames.CompanyName, CompanyFactory.FieldNames.CompanyShortName, CompanyFactory.FieldNames.Phone, CompanyFactory.FieldNames.Fax, CompanyFactory.FieldNames.Url, CompanyFactory.FieldNames.Remarks)); builder.Append(string.Format("VALUES ({0},{1},{2},{3},{4},{5},{6});", DataHelper.GetSqlValue(item.Key), DataHelper.GetSqlValue(item.Name), DataHelper.GetSqlValue(item.Abbreviation), DataHelper.GetSqlValue(item.PhoneNumber), DataHelper.GetSqlValue(item.FaxNumber), DataHelper.GetSqlValue(item.Url), DataHelper.GetSqlValue(item.Remarks))); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the addresses this.InsertAddresses(item); }
protected override void PersistNewItem(Submittal item) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO Submittal ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21}) ", SubmittalFactory.FieldNames.SubmittalId, ProjectFactory.FieldNames.ProjectId, SubmittalFactory.FieldNames.SpecificationSectionId, SubmittalFactory.FieldNames.SpecificationSectionPrimaryIndex, SubmittalFactory.FieldNames.SpecificationSectionSecondaryIndex, SubmittalFactory.FieldNames.ProjectContactId, SubmittalFactory.FieldNames.EmployeeId, SubmittalFactory.FieldNames.TotalPages, SubmittalFactory.FieldNames.DeliveryMethod, SubmittalFactory.FieldNames.OtherDeliveryMethod, SubmittalFactory.FieldNames.PhaseNumber, SubmittalFactory.FieldNames.Reimbursable, SubmittalFactory.FieldNames.Final, SubmittalFactory.FieldNames.DateReceived, SubmittalFactory.FieldNames.ContractNumber, SubmittalFactory.FieldNames.Remarks, SubmittalFactory.FieldNames.Action, SubmittalFactory.FieldNames.ItemStatusId, SubmittalFactory.FieldNames.DateToField, SubmittalFactory.FieldNames.RemainderLocation, SubmittalFactory.FieldNames.RemainderUnderSubmittalNumber, SubmittalFactory.FieldNames.OtherRemainderLocation)); builder.Append(string.Format("VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21});", DataHelper.GetSqlValue(item.Key), DataHelper.GetSqlValue(item.ProjectKey), DataHelper.GetSqlValue(item.SpecSection.Key), DataHelper.GetSqlValue(item.SpecSectionPrimaryIndex), DataHelper.GetSqlValue(item.SpecSectionSecondaryIndex), DataHelper.GetSqlValue(item.To.Key), DataHelper.GetSqlValue(item.From.Key), DataHelper.GetSqlValue(item.TotalPages), DataHelper.GetSqlValue(item.DeliveryMethod), DataHelper.GetSqlValue(item.OtherDeliveryMethod), DataHelper.GetSqlValue(item.PhaseNumber), DataHelper.GetSqlValue(item.Reimbursable), DataHelper.GetSqlValue(item.Final), DataHelper.GetSqlValue(item.DateReceived), DataHelper.GetSqlValue(item.ContractNumber), DataHelper.GetSqlValue(item.Remarks), DataHelper.GetSqlValue(item.Action), DataHelper.GetSqlValue(item.Status.Id), DataHelper.GetSqlValue(item.DateToField), DataHelper.GetSqlValue(item.RemainderLocation), DataHelper.GetSqlValue(item.RemainderUnderSubmittalNumber), DataHelper.GetSqlValue(item.OtherRemainderLocation))); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the child objects this.InsertCopyToList(item); this.InsertRoutingItems(item); this.InsertTrackingItems(item); }
protected override void PersistNewItem(ProposalRequest item) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO ProposalRequest ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21}) ", ProposalRequestFactory.FieldNames.ProposalRequestId, ProjectFactory.FieldNames.ProjectId, ProposalRequestFactory.FieldNames.ProposalRequestNumber, ProposalRequestFactory.FieldNames.TransmittalDate, ProposalRequestFactory.FieldNames.ProjectContactId, ProposalRequestFactory.FieldNames.EmployeeId, ProposalRequestFactory.FieldNames.TotalPages, ProposalRequestFactory.FieldNames.DeliveryMethod, ProposalRequestFactory.FieldNames.OtherDeliveryMethod, ProposalRequestFactory.FieldNames.PhaseNumber, ProposalRequestFactory.FieldNames.Reimbursable, ProposalRequestFactory.FieldNames.Final, ProposalRequestFactory.FieldNames.IssueDate, CompanyFactory.FieldNames.CompanyId, ProposalRequestFactory.FieldNames.Description, ProposalRequestFactory.FieldNames.Attachment, ProposalRequestFactory.FieldNames.Reason, ProposalRequestFactory.FieldNames.Initiator, ProposalRequestFactory.FieldNames.Cause, ProposalRequestFactory.FieldNames.Origin, ProposalRequestFactory.FieldNames.Remarks, ProposalRequestFactory.FieldNames.TransmittalRemarks )); builder.Append(string.Format("VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21});", DataHelper.GetSqlValue(item.Key), DataHelper.GetSqlValue(item.ProjectKey), DataHelper.GetSqlValue(item.Number), DataHelper.GetSqlValue(item.TransmittalDate), DataHelper.GetSqlValue(item.To.Key), DataHelper.GetSqlValue(item.From.Key), DataHelper.GetSqlValue(item.TotalPages), DataHelper.GetSqlValue(item.DeliveryMethod), DataHelper.GetSqlValue(item.OtherDeliveryMethod), DataHelper.GetSqlValue(item.PhaseNumber), DataHelper.GetSqlValue(item.Reimbursable), DataHelper.GetSqlValue(item.Final), DataHelper.GetSqlValue(item.IssueDate), DataHelper.GetSqlValue(item.Contractor.Key), DataHelper.GetSqlValue(item.Description), DataHelper.GetSqlValue(item.Attachment), DataHelper.GetSqlValue(item.Reason), DataHelper.GetSqlValue(item.Initiator), DataHelper.GetSqlValue(item.Cause), DataHelper.GetSqlValue(item.Origin), DataHelper.GetSqlValue(item.Remarks), DataHelper.GetSqlValue(item.TransmittalRemarks))); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the child objects this.InsertCopyToList(item); }
protected void PersistDeletedItem(ProjectContact contact) { StringBuilder builder = new StringBuilder(100); builder.Append("UPDATE ProjectContact SET "); builder.Append(string.Format("{0} = {1}", ProjectFactory.FieldNames.OnFinalDistributionList, DataHelper.GetSqlValue(contact.OnFinalDistributionList))); builder.Append(" "); builder.Append(string.Format("WHERE ProjectContactID = '{0}'", contact.Key)); this.Database.ExecuteNonQuery(this.Database.GetSqlStringCommand(builder.ToString())); }
protected void PersistNewItem(ProjectContact contact) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO ProjectContact ({0}, {1}, {2}) ", ProjectFactory.FieldNames.ProjectId, ContactFactory.FieldNames.ContactId, contact.OnFinalDistributionList)); builder.Append(string.Format("VALUES ({0}, {1}, {2});", DataHelper.GetSqlValue(contact.Project.Key), DataHelper.GetSqlValue(contact.Contact.Key), DataHelper.GetSqlValue(contact.OnFinalDistributionList))); this.Database.ExecuteNonQuery(this.Database.GetSqlStringCommand(builder.ToString())); }
protected override void PersistNewItem(ChangeOrder item) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO ChangeOrder ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16}) ", ChangeOrderFactory.FieldNames.ChangeOrderId, ProjectFactory.FieldNames.ProjectId, ChangeOrderFactory.FieldNames.ChangeOrderNumber, ChangeOrderFactory.FieldNames.EffectiveDate, CompanyFactory.FieldNames.CompanyId, ChangeOrderFactory.FieldNames.Description, ChangeOrderFactory.FieldNames.PriceChangeType, ChangeOrderFactory.FieldNames.PriceChangeTypeDirection, ChangeOrderFactory.FieldNames.AmountChanged, ChangeOrderFactory.FieldNames.TimeChangeDirection, ChangeOrderFactory.FieldNames.TimeChangedDays, ChangeOrderFactory.FieldNames.ItemStatusId, ChangeOrderFactory.FieldNames.AgencyApprovedDate, ChangeOrderFactory.FieldNames.DateToField, ChangeOrderFactory.FieldNames.OwnerSignatureDate, ChangeOrderFactory.FieldNames.ArchitectSignatureDate, ChangeOrderFactory.FieldNames.ContractorSignatureDate )); builder.Append(string.Format("VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16});", DataHelper.GetSqlValue(item.Key), DataHelper.GetSqlValue(item.ProjectKey), DataHelper.GetSqlValue(item.Number), DataHelper.GetSqlValue(item.EffectiveDate), DataHelper.GetSqlValue(item.Contractor.Key), DataHelper.GetSqlValue(item.Description), DataHelper.GetSqlValue(item.ChangeType), DataHelper.GetSqlValue(item.PriceChangeDirection), DataHelper.GetSqlValue(item.AmountChanged), DataHelper.GetSqlValue(item.TimeChangeDirection), DataHelper.GetSqlValue(item.TimeChanged), DataHelper.GetSqlValue(item.Status.Id), DataHelper.GetSqlValue(item.AgencyApprovedDate), DataHelper.GetSqlValue(item.DateToField), DataHelper.GetSqlValue(item.OwnerSignatureDate), DataHelper.GetSqlValue(item.ArchitectSignatureDate), DataHelper.GetSqlValue(item.ContractorSignatureDate))); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the child objects this.InsertRoutingItems(item); }
protected override void PersistUpdatedItem(Company item) { StringBuilder builder = new StringBuilder(100); builder.Append("UPDATE Company SET "); builder.Append(string.Format("{0} = {1}", CompanyFactory.FieldNames.CompanyName, DataHelper.GetSqlValue(item.Name))); builder.Append(string.Format(",{0} = {1}", CompanyFactory.FieldNames.CompanyShortName, DataHelper.GetSqlValue(item.Abbreviation))); builder.Append(string.Format(",{0} = {1}", CompanyFactory.FieldNames.Phone, DataHelper.GetSqlValue(item.PhoneNumber))); builder.Append(string.Format(",{0} = {1}", CompanyFactory.FieldNames.Fax, DataHelper.GetSqlValue(item.FaxNumber))); builder.Append(string.Format(",{0} = {1}", CompanyFactory.FieldNames.Url, DataHelper.GetSqlValue(item.Url))); builder.Append(string.Format(",{0} = {1}", CompanyFactory.FieldNames.Remarks, DataHelper.GetSqlValue(item.Remarks))); builder.Append(" "); builder.Append(this.BuildBaseWhereClause(item.Key)); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the addresses // First, delete the existing ones this.DeleteAddresses(item); // Now, add the current ones this.InsertAddresses(item); }
private void InsertAddress(Address address, object key, bool isHeadquartersAddress) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO CompanyAddress ({0}, {1}, {2}, {3}, {4}, {5}) ", CompanyFactory.FieldNames.CompanyId, AddressFactory.FieldNames.Street, AddressFactory.FieldNames.City, AddressFactory.FieldNames.State, AddressFactory.FieldNames.PostalCode, CompanyFactory.FieldNames.IsHeadquarters)); builder.Append(string.Format("VALUES ({0}, {1}, {2}, {3}, {4}, {5};", DataHelper.GetSqlValue(key), DataHelper.GetSqlValue(address.Street), DataHelper.GetSqlValue(address.City), DataHelper.GetSqlValue(address.State), DataHelper.GetSqlValue(address.PostalCode), DataHelper.GetSqlValue(isHeadquartersAddress))); this.Database.ExecuteNonQuery(this.Database.GetSqlStringCommand(builder.ToString())); }
protected override void PersistUpdatedItem(ConstructionChangeDirective item) { StringBuilder builder = new StringBuilder(100); builder.Append("UPDATE ConstructionChangeDirective SET "); builder.Append(string.Format("{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.ConstructionChangeDirectiveNumber, DataHelper.GetSqlValue(item.Number))); builder.Append(string.Format(",{0} = {1}", TransmittalFactory.FieldNames.TransmittalDate, DataHelper.GetSqlValue(item.TransmittalDate))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.ProjectContactId, DataHelper.GetSqlValue(item.To.Key))); builder.Append(string.Format(",{0} = {1}", EmployeeFactory.FieldNames.EmployeeId, DataHelper.GetSqlValue(item.From.Key))); builder.Append(string.Format(",{0} = {1}", TransmittalFactory.FieldNames.TotalPages, DataHelper.GetSqlValue(item.TotalPages))); builder.Append(string.Format(",{0} = {1}", TransmittalFactory.FieldNames.DeliveryMethod, DataHelper.GetSqlValue(item.DeliveryMethod))); builder.Append(string.Format(",{0} = {1}", TransmittalFactory.FieldNames.OtherDeliveryMethod, DataHelper.GetSqlValue(item.OtherDeliveryMethod))); builder.Append(string.Format(",{0} = {1}", TransmittalFactory.FieldNames.PhaseNumber, DataHelper.GetSqlValue(item.PhaseNumber))); builder.Append(string.Format(",{0} = {1}", TransmittalFactory.FieldNames.Reimbursable, DataHelper.GetSqlValue(item.Reimbursable))); builder.Append(string.Format(",{0} = {1}", TransmittalFactory.FieldNames.Final, DataHelper.GetSqlValue(item.Final))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.IssueDate, DataHelper.GetSqlValue(item.IssueDate))); builder.Append(string.Format(",{0} = {1}", CompanyFactory.FieldNames.CompanyId, DataHelper.GetSqlValue(item.Contractor.Key))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.Description, DataHelper.GetSqlValue(item.Description))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.Attachment, DataHelper.GetSqlValue(item.Attachment))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.Reason, DataHelper.GetSqlValue(item.Reason))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.Initiator, DataHelper.GetSqlValue(item.Initiator))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.Cause, DataHelper.GetSqlValue(item.Cause))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.Origin, DataHelper.GetSqlValue(item.Origin))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.Remarks, DataHelper.GetSqlValue(item.Remarks))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.TransmittalRemarks, DataHelper.GetSqlValue(item.TransmittalRemarks))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.PriceChangeType, DataHelper.GetSqlValue(item.ChangeType))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.PriceChangeTypeDirection, DataHelper.GetSqlValue(item.PriceChangeDirection))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.AmountChanged, DataHelper.GetSqlValue(item.AmountChanged))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.TimeChangeDirection, DataHelper.GetSqlValue(item.TimeChangeDirection))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.TimeChangedDays, DataHelper.GetSqlValue(item.TimeChanged))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.OwnerSignatureDate, DataHelper.GetSqlValue(item.OwnerSignatureDate))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.ArchitectSignatureDate, DataHelper.GetSqlValue(item.ArchitectSignatureDate))); builder.Append(string.Format(",{0} = {1}", ConstructionChangeDirectiveFactory.FieldNames.ContractorSignatureDate, DataHelper.GetSqlValue(item.ContractorSignatureDate))); builder.Append(" "); builder.Append(this.BuildBaseWhereClause(item.Key)); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the child objects // First, delete the existing ones this.DeleteCopyToList(item); // Now, add the current ones this.InsertCopyToList(item); }
protected void PersistUpdateItem(ProjectContact item) { StringBuilder builder = GetBaseQueryBuilder(); builder.Append("UPDATE ProjectContact SET "); builder.Append(string.Format("{0} = {1}", ProjectFactory.FieldNames.ProjectId, DataHelper.GetSqlValue(item.Project))); builder.Append(string.Format("{0} = {1}", ContactFactory.FieldNames.ContactId, DataHelper.GetSqlValue(item.Contact))); builder.Append(string.Format("{0} = {1}", ProjectFactory.FieldNames.OnFinalDistributionList, DataHelper.GetSqlValue(item.OnFinalDistributionList))); builder.Append(" "); builder.Append(this.BuildBaseWhereClause(item.Key)); }
protected override void PersistUpdatedItem(ChangeOrder item) { StringBuilder builder = new StringBuilder(100); builder.Append("UPDATE ChangeOrder SET "); builder.Append(string.Format("{0} = {1}", ChangeOrderFactory.FieldNames.ChangeOrderNumber, DataHelper.GetSqlValue(item.Number))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.EffectiveDate, DataHelper.GetSqlValue(item.EffectiveDate))); builder.Append(string.Format(",{0} = {1}", CompanyFactory.FieldNames.CompanyId, DataHelper.GetSqlValue(item.Contractor.Key))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.Description, DataHelper.GetSqlValue(item.Description))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.PriceChangeType, DataHelper.GetSqlValue(item.ChangeType))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.PriceChangeTypeDirection, DataHelper.GetSqlValue(item.PriceChangeDirection))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.AmountChanged, DataHelper.GetSqlValue(item.AmountChanged))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.TimeChangeDirection, DataHelper.GetSqlValue(item.TimeChangeDirection))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.TimeChangedDays, DataHelper.GetSqlValue(item.TimeChanged))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.ItemStatusId, DataHelper.GetSqlValue(item.Status.Id))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.AgencyApprovedDate, DataHelper.GetSqlValue(item.AgencyApprovedDate))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.DateToField, DataHelper.GetSqlValue(item.DateToField))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.OwnerSignatureDate, DataHelper.GetSqlValue(item.OwnerSignatureDate))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.ArchitectSignatureDate, DataHelper.GetSqlValue(item.ArchitectSignatureDate))); builder.Append(string.Format(",{0} = {1}", ChangeOrderFactory.FieldNames.ContractorSignatureDate, DataHelper.GetSqlValue(item.ContractorSignatureDate))); builder.Append(" "); builder.Append(this.BuildBaseWhereClause(item.Key)); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the child objects // First, delete the existing ones this.DeleteRoutingItems(item); // Now, add the current ones this.InsertRoutingItems(item); }
protected override void PersistUpdatedItem(Submittal item) { StringBuilder builder = new StringBuilder(100); builder.Append("UPDATE Submittal SET "); builder.Append(string.Format("{0} = {1}", SubmittalFactory.FieldNames.SpecificationSectionId, DataHelper.GetSqlValue(item.SpecSection.Key))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.SpecificationSectionPrimaryIndex, DataHelper.GetSqlValue(item.SpecSectionPrimaryIndex))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.SpecificationSectionSecondaryIndex, DataHelper.GetSqlValue(item.SpecSectionSecondaryIndex))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.ProjectContactId, DataHelper.GetSqlValue(item.To.Key))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.EmployeeId, DataHelper.GetSqlValue(item.From.Key))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.TotalPages, DataHelper.GetSqlValue(item.TotalPages))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.DeliveryMethod, DataHelper.GetSqlValue(item.DeliveryMethod))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.OtherDeliveryMethod, DataHelper.GetSqlValue(item.OtherDeliveryMethod))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.PhaseNumber, DataHelper.GetSqlValue(item.PhaseNumber))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.Reimbursable, DataHelper.GetSqlValue(item.Reimbursable))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.Final, DataHelper.GetSqlValue(item.Final))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.DateReceived, DataHelper.GetSqlValue(item.DateReceived))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.ContractNumber, DataHelper.GetSqlValue(item.ContractNumber))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.Remarks, DataHelper.GetSqlValue(item.Remarks))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.Action, DataHelper.GetSqlValue(item.Action))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.ItemStatusId, DataHelper.GetSqlValue(item.Status.Id))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.DateToField, DataHelper.GetSqlValue(item.DateToField))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.RemainderLocation, DataHelper.GetSqlValue(item.RemainderLocation))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.RemainderUnderSubmittalNumber, DataHelper.GetSqlValue(item.RemainderUnderSubmittalNumber))); builder.Append(string.Format(",{0} = {1}", SubmittalFactory.FieldNames.OtherRemainderLocation, DataHelper.GetSqlValue(item.OtherRemainderLocation))); builder.Append(" "); builder.Append(this.BuildBaseWhereClause(item.Key)); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the child objects // First, delete the existing ones this.DeleteCopyToList(item); this.DeleteRoutingItems(item); this.DeleteTrackingItems(item); // Now, add the current ones this.InsertCopyToList(item); this.InsertRoutingItems(item); this.InsertTrackingItems(item); }
protected override void PersistUpdatedItem(Project item) { StringBuilder builder = new StringBuilder(100); builder.Append("UPDATE Project SET "); builder.Append(string.Format("{0} = {1}", ProjectFactory.FieldNames.ConstructionAdministratorEmployeeId, item.ConstructionAdministrator.Key)); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.PrincipalEmployeeId, item.PrincipalInCharge.Key)); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.ProjectAddress, DataHelper.GetSqlValue(item.Address.Street))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.ProjectCity, DataHelper.GetSqlValue(item.Address.City))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.ProjectState, DataHelper.GetSqlValue(item.Address.State))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.ProjectPostalCode, DataHelper.GetSqlValue(item.Address.PostalCode))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.OwnerCompanyId, DataHelper.GetSqlValue(item.Owner.Key))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.ContractDate, DataHelper.GetSqlValue(item.ContractDate))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.EstimatedStartDate, DataHelper.GetSqlValue(item.EstimatedStartDate))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.EstimatedCompletionDate, DataHelper.GetSqlValue(item.EstimatedCompletionDate))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.CurrentCompletionDate, DataHelper.GetSqlValue(item.CurrentCompletionDate))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.ActualCompletionDate, DataHelper.GetSqlValue(item.ActualCompletionDate))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.ContingencyAllowanceAmount, item.ContingencyAllowanceAmount)); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.TestingAllowanceAmount, item.TestingAllowanceAmount)); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.UtilityAllowanceAmount, item.UtilityAllowanceAmount)); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.OriginalConstructionCost, item.OriginalConstructionCost)); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.AeChangeOrderAmount, item.AeChangeOrderAmount)); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.TotalSquareFeet, item.TotalSquareFeet)); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.PercentComplete, item.PercentComplete)); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.Remarks, DataHelper.GetSqlValue(item.Remarks))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.ContractReason, DataHelper.GetSqlValue(item.ContractReason))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.AgencyApplicationNumber, DataHelper.GetSqlValue(item.AgencyApplicationNumber))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.AgencyFileNumber, DataHelper.GetSqlValue(item.AgencyFileNumber))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.MarketSegmentId, item.Segment.Key)); builder.Append(" "); builder.Append(this.BuildBaseWhereClause(item.Key)); this.Database.ExecuteNonQuery(this.Database.GetSqlStringCommand(builder.ToString())); }
protected override void PersistNewItem(Project item) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO Project ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25},{26}) ", ProjectFactory.FieldNames.ProjectId, ProjectFactory.FieldNames.ProjectNumber, ProjectFactory.FieldNames.ProjectName, ProjectFactory.FieldNames.ConstructionAdministratorEmployeeId, ProjectFactory.FieldNames.PrincipalEmployeeId, ProjectFactory.FieldNames.ProjectAddress, ProjectFactory.FieldNames.ProjectCity, ProjectFactory.FieldNames.ProjectState, ProjectFactory.FieldNames.ProjectPostalCode, ProjectFactory.FieldNames.OwnerCompanyId, ProjectFactory.FieldNames.ContractDate, ProjectFactory.FieldNames.EstimatedStartDate, ProjectFactory.FieldNames.EstimatedCompletionDate, ProjectFactory.FieldNames.CurrentCompletionDate, ProjectFactory.FieldNames.ActualCompletionDate, ProjectFactory.FieldNames.ContingencyAllowanceAmount, ProjectFactory.FieldNames.TestingAllowanceAmount, ProjectFactory.FieldNames.UtilityAllowanceAmount, ProjectFactory.FieldNames.OriginalConstructionCost, ProjectFactory.FieldNames.AeChangeOrderAmount, ProjectFactory.FieldNames.TotalSquareFeet, ProjectFactory.FieldNames.PercentComplete, ProjectFactory.FieldNames.Remarks, ProjectFactory.FieldNames.ContractReason, ProjectFactory.FieldNames.AgencyApplicationNumber, ProjectFactory.FieldNames.AgencyFileNumber, ProjectFactory.FieldNames.MarketSegmentId)); builder.Append(string.Format("VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25},{26});", DataHelper.GetSqlValue(item.Key), DataHelper.GetSqlValue(item.Number), DataHelper.GetSqlValue(item.Name), item.ConstructionAdministrator.Key, item.PrincipalInCharge.Key, DataHelper.GetSqlValue(item.Address.Street), DataHelper.GetSqlValue(item.Address.City), DataHelper.GetSqlValue(item.Address.State), DataHelper.GetSqlValue(item.Address.PostalCode), DataHelper.GetSqlValue(item.Owner.Key), DataHelper.GetSqlValue(item.ContractDate), DataHelper.GetSqlValue(item.EstimatedStartDate), DataHelper.GetSqlValue(item.EstimatedCompletionDate), DataHelper.GetSqlValue(item.CurrentCompletionDate), DataHelper.GetSqlValue(item.ActualCompletionDate), item.ContingencyAllowanceAmount, item.TestingAllowanceAmount, item.UtilityAllowanceAmount, item.OriginalConstructionCost, item.AeChangeOrderAmount, item.TotalSquareFeet, item.PercentComplete, DataHelper.GetSqlValue(item.Remarks), DataHelper.GetSqlValue(item.ContractReason), DataHelper.GetSqlValue(item.AgencyApplicationNumber), DataHelper.GetSqlValue(item.AgencyFileNumber), item.Segment.Key)); this.Database.ExecuteNonQuery(this.Database.GetSqlStringCommand(builder.ToString())); }
protected override void PersistNewItem(RequestForInformation item) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO RequestForInformation ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25}) ", RequestForInformationFactory.FieldNames.RequestForInformationId, ProjectFactory.FieldNames.ProjectId, RequestForInformationFactory.FieldNames.RequestForInformationNumber, RequestForInformationFactory.FieldNames.TransmittalDate, RequestForInformationFactory.FieldNames.ProjectContactId, RequestForInformationFactory.FieldNames.TotalPages, RequestForInformationFactory.FieldNames.DeliveryMethod, RequestForInformationFactory.FieldNames.OtherDeliveryMethod, RequestForInformationFactory.FieldNames.PhaseNumber, RequestForInformationFactory.FieldNames.Reimbursable, RequestForInformationFactory.FieldNames.Final, RequestForInformationFactory.FieldNames.DateReceived, RequestForInformationFactory.FieldNames.DateRequestedBy, CompanyFactory.FieldNames.CompanyId, SubmittalFactory.FieldNames.SpecificationSectionId, RequestForInformationFactory.FieldNames.Question, RequestForInformationFactory.FieldNames.Description, RequestForInformationFactory.FieldNames.ContractorProposedSolution, RequestForInformationFactory.FieldNames.NoChange, RequestForInformationFactory.FieldNames.Cause, RequestForInformationFactory.FieldNames.Origin, RequestForInformationFactory.FieldNames.ItemStatusId, RequestForInformationFactory.FieldNames.DateToField, RequestForInformationFactory.FieldNames.ShortAnswer, RequestForInformationFactory.FieldNames.LongAnswer, RequestForInformationFactory.FieldNames.Remarks )); builder.Append(string.Format("VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25});", DataHelper.GetSqlValue(item.Key), DataHelper.GetSqlValue(item.ProjectKey), DataHelper.GetSqlValue(item.Number), DataHelper.GetSqlValue(item.TransmittalDate), DataHelper.GetSqlValue(item.From.Key), DataHelper.GetSqlValue(item.TotalPages), DataHelper.GetSqlValue(item.DeliveryMethod), DataHelper.GetSqlValue(item.OtherDeliveryMethod), DataHelper.GetSqlValue(item.PhaseNumber), DataHelper.GetSqlValue(item.Reimbursable), DataHelper.GetSqlValue(item.Final), DataHelper.GetSqlValue(item.DateReceived), DataHelper.GetSqlValue(item.DateRequestedBy), DataHelper.GetSqlValue(item.Contractor.Key), DataHelper.GetSqlValue(item.SpecSection.Key), DataHelper.GetSqlValue(item.Question), DataHelper.GetSqlValue(item.Description), DataHelper.GetSqlValue(item.ContractorProposedSolution), DataHelper.GetSqlValue(item.Change), DataHelper.GetSqlValue(item.Cause), DataHelper.GetSqlValue(item.Origin), DataHelper.GetSqlValue(item.Status.Id), DataHelper.GetSqlValue(item.DateToField), DataHelper.GetSqlValue(item.ShortAnswer), DataHelper.GetSqlValue(item.LongAnswer), DataHelper.GetSqlValue(item.Remarks))); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the child objects this.InsertCopyToList(item); this.InsertRoutingItems(item); }
protected override void PersistNewItem(ConstructionChangeDirective item) { StringBuilder builder = new StringBuilder(100); builder.Append(string.Format("INSERT INTO ConstructionChangeDirective ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25},{26},{27},{28},{29}) ", ConstructionChangeDirectiveFactory.FieldNames.ConstructionChangeDirectiveId, ProjectFactory.FieldNames.ProjectId, ConstructionChangeDirectiveFactory.FieldNames.ConstructionChangeDirectiveNumber, TransmittalFactory.FieldNames.TransmittalDate, ProjectFactory.FieldNames.ProjectContactId, EmployeeFactory.FieldNames.EmployeeId, TransmittalFactory.FieldNames.TotalPages, TransmittalFactory.FieldNames.DeliveryMethod, TransmittalFactory.FieldNames.OtherDeliveryMethod, TransmittalFactory.FieldNames.PhaseNumber, TransmittalFactory.FieldNames.Reimbursable, TransmittalFactory.FieldNames.Final, ConstructionChangeDirectiveFactory.FieldNames.IssueDate, CompanyFactory.FieldNames.CompanyId, ConstructionChangeDirectiveFactory.FieldNames.Description, ConstructionChangeDirectiveFactory.FieldNames.Attachment, ConstructionChangeDirectiveFactory.FieldNames.Reason, ConstructionChangeDirectiveFactory.FieldNames.Initiator, ConstructionChangeDirectiveFactory.FieldNames.Cause, ConstructionChangeDirectiveFactory.FieldNames.Origin, ConstructionChangeDirectiveFactory.FieldNames.Remarks, TransmittalFactory.FieldNames.TransmittalRemarks, ConstructionChangeDirectiveFactory.FieldNames.PriceChangeType, ConstructionChangeDirectiveFactory.FieldNames.PriceChangeTypeDirection, ConstructionChangeDirectiveFactory.FieldNames.AmountChanged, ConstructionChangeDirectiveFactory.FieldNames.TimeChangeDirection, ConstructionChangeDirectiveFactory.FieldNames.TimeChangedDays, ConstructionChangeDirectiveFactory.FieldNames.OwnerSignatureDate, ConstructionChangeDirectiveFactory.FieldNames.ArchitectSignatureDate, ConstructionChangeDirectiveFactory.FieldNames.ContractorSignatureDate )); builder.Append(string.Format("VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25},{26},{27},{28},{29});", DataHelper.GetSqlValue(item.Key), DataHelper.GetSqlValue(item.ProjectKey), DataHelper.GetSqlValue(item.Number), DataHelper.GetSqlValue(item.TransmittalDate), DataHelper.GetSqlValue(item.To.Key), DataHelper.GetSqlValue(item.From.Key), DataHelper.GetSqlValue(item.TotalPages), DataHelper.GetSqlValue(item.DeliveryMethod), DataHelper.GetSqlValue(item.OtherDeliveryMethod), DataHelper.GetSqlValue(item.PhaseNumber), DataHelper.GetSqlValue(item.Reimbursable), DataHelper.GetSqlValue(item.Final), DataHelper.GetSqlValue(item.IssueDate), DataHelper.GetSqlValue(item.Contractor.Key), DataHelper.GetSqlValue(item.Description), DataHelper.GetSqlValue(item.Attachment), DataHelper.GetSqlValue(item.Reason), DataHelper.GetSqlValue(item.Initiator), DataHelper.GetSqlValue(item.Cause), DataHelper.GetSqlValue(item.Origin), DataHelper.GetSqlValue(item.Remarks), DataHelper.GetSqlValue(item.TransmittalRemarks), DataHelper.GetSqlValue(item.ChangeType), DataHelper.GetSqlValue(item.PriceChangeDirection), DataHelper.GetSqlValue(item.AmountChanged), DataHelper.GetSqlValue(item.TimeChangeDirection), DataHelper.GetSqlValue(item.TimeChanged), DataHelper.GetSqlValue(item.OwnerSignatureDate), DataHelper.GetSqlValue(item.ArchitectSignatureDate), DataHelper.GetSqlValue(item.ContractorSignatureDate))); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the child objects this.InsertCopyToList(item); }
protected override void PersistUpdatedItem(RequestForInformation item) { StringBuilder builder = new StringBuilder(100); builder.Append("UPDATE RequestForInformation SET "); builder.Append(string.Format("{0} = {1}", RequestForInformationFactory.FieldNames.RequestForInformationNumber, DataHelper.GetSqlValue(item.Number))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.TransmittalDate, DataHelper.GetSqlValue(item.TransmittalDate))); builder.Append(string.Format(",{0} = {1}", ProjectFactory.FieldNames.ProjectContactId, DataHelper.GetSqlValue(item.From.Key))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.TotalPages, DataHelper.GetSqlValue(item.TotalPages))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.DeliveryMethod, DataHelper.GetSqlValue(item.DeliveryMethod))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.OtherDeliveryMethod, DataHelper.GetSqlValue(item.OtherDeliveryMethod))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.PhaseNumber, DataHelper.GetSqlValue(item.PhaseNumber))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.Reimbursable, DataHelper.GetSqlValue(item.Reimbursable))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.Final, DataHelper.GetSqlValue(item.Final))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.DateReceived, DataHelper.GetSqlValue(item.DateReceived))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.DateRequestedBy, DataHelper.GetSqlValue(item.DateRequestedBy))); builder.Append(string.Format(",{0} = {1}", CompanyFactory.FieldNames.CompanyId, DataHelper.GetSqlValue(item.Contractor.Key))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.SpecificationSectionId, DataHelper.GetSqlValue(item.SpecSection.Key))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.Question, DataHelper.GetSqlValue(item.Question))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.Description, DataHelper.GetSqlValue(item.Description))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.ContractorProposedSolution, DataHelper.GetSqlValue(item.ContractorProposedSolution))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.NoChange, DataHelper.GetSqlValue(item.Change))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.Cause, DataHelper.GetSqlValue(item.Cause))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.Origin, DataHelper.GetSqlValue(item.Origin))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.ItemStatusId, DataHelper.GetSqlValue(item.Status.Id))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.DateToField, DataHelper.GetSqlValue(item.DateToField))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.ShortAnswer, DataHelper.GetSqlValue(item.ShortAnswer))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.LongAnswer, DataHelper.GetSqlValue(item.LongAnswer))); builder.Append(string.Format(",{0} = {1}", RequestForInformationFactory.FieldNames.Remarks, DataHelper.GetSqlValue(item.Remarks))); builder.Append(" "); builder.Append(this.BuildBaseWhereClause(item.Key)); this.Database.ExecuteNonQuery( this.Database.GetSqlStringCommand(builder.ToString())); // Now do the child objects // First, delete the existing ones this.DeleteCopyToList(item); this.DeleteRoutingItems(item); // Now, add the current ones this.InsertCopyToList(item); this.InsertRoutingItems(item); }