internal static bool IsHeadquartersAddress(IDataReader reader)
{
return(DataHelper.GetBoolean(reader[FieldNames.IsHeadquarters]));
}
protected override void PersistUpdateItem(Company item)
{
StringBuilder builder = new StringBuilder(100);
builder.Append("UPDATE Company SET ");
builder.Append(string.Format("{0} = '{1}'", CompanyFactory.FieldNames.Name, DataHelper.GetSqlValue(item.Name)));
builder.Append(string.Format(", {0} = '{1}'", CompanyFactory.FieldNames.ShortName, 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()));
this.DeleteAddresses(item);
this.InsertAddresses(item);
}
protected override void PersistUpdatedItem(ProposalRequest item)
{
StringBuilder builder = new StringBuilder(100);
builder.Append("UPDATE ProposalRequest SET ");
builder.Append(string.Format("{0} = {1}",
ProposalRequestFactory.FieldNames.ProposalRequestNumber,
DataHelper.GetSqlValue(item.Number)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.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}",
ProposalRequestFactory.FieldNames.EmployeeId,
DataHelper.GetSqlValue(item.From.Key)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.TotalPages,
DataHelper.GetSqlValue(item.TotalPages)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.DeliveryMethod,
DataHelper.GetSqlValue(item.DeliveryMethod)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.OtherDeliveryMethod,
DataHelper.GetSqlValue(item.OtherDeliveryMethod)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.PhaseNumber,
DataHelper.GetSqlValue(item.PhaseNumber)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.Reimbursable,
DataHelper.GetSqlValue(item.Reimbursable)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.Final,
DataHelper.GetSqlValue(item.Final)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.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}",
ProposalRequestFactory.FieldNames.Description,
DataHelper.GetSqlValue(item.Description)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.Attachment,
DataHelper.GetSqlValue(item.Attachment)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.Reason,
DataHelper.GetSqlValue(item.Reason)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.Initiator,
DataHelper.GetSqlValue(item.Initiator)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.Cause,
DataHelper.GetSqlValue(item.Cause)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.Origin,
DataHelper.GetSqlValue(item.Origin)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.Remarks,
DataHelper.GetSqlValue(item.Remarks)));
builder.Append(string.Format(",{0} = {1}",
ProposalRequestFactory.FieldNames.TransmittalRemarks,
DataHelper.GetSqlValue(item.TransmittalRemarks)));
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);
}