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