public Project BuildEntity(IDataReader reader) { Project project = new Project(reader[FieldNames.ProjectId], reader[FieldNames.ProjectNumber].ToString(), reader[FieldNames.ProjectName].ToString()); project.Address = AddressFactory.BuildAddress(reader); project.ContractDate = DataHelper.GetNullableDateTime(reader[FieldNames.ContractDate]); project.EstimatedStartDate = DataHelper.GetNullableDateTime(reader[FieldNames.EstimatedStartDate]); project.EstimatedCompletionDate = DataHelper.GetNullableDateTime(reader[FieldNames.EstimatedCompletionDate]); project.CurrentCompletionDate = DataHelper.GetNullableDateTime(reader[FieldNames.CurrentCompletionDate]); project.ActualCompletionDate = DataHelper.GetNullableDateTime(reader[FieldNames.ActualCompletionDate]); project.ContingencyAllowanceAmount = DataHelper.GetDecimal(reader[FieldNames.ContingencyAllowanceAmount]); project.TestingAllowanceAmount = DataHelper.GetDecimal(reader[FieldNames.TestingAllowanceAmount]); project.UtilityAllowanceAmount = DataHelper.GetDecimal(reader[FieldNames.UtilityAllowanceAmount]); project.OriginalConstructionCost = DataHelper.GetDecimal(reader[FieldNames.OriginalConstructionCost]); project.TotalSquareFeet = DataHelper.GetInteger(reader[FieldNames.TotalSquareFeet]); project.PercentComplete = DataHelper.GetInteger(reader[FieldNames.PercentComplete]); project.Remarks = reader[FieldNames.Remarks].ToString(); project.AeChangeOrderAmount = DataHelper.GetDecimal(reader[FieldNames.AeChangeOrderAmount]); project.ContractReason = reader[FieldNames.ContractReason].ToString(); project.AgencyApplicationNumber = reader[FieldNames.AgencyApplicationNumber].ToString(); project.AgencyFileNumber = reader[FieldNames.AgencyFileNumber].ToString(); project.Segment = new MarketSegment(reader[FieldNames.MarketSegmentId], null, reader[FieldNames.MarketSegmentCode].ToString(), reader[FieldNames.MarketSegmentName].ToString()); return(project); }
public Project BuildEntity(IDataReader reader) { Project project = new Project( reader[FieldNames.ProjectId] , reader[FieldNames.ProjectNumber].ToString() , reader[FieldNames.ProjectName].ToString()); project.Address = AddressFactory.BuildAddress(reader); return(project); }
private void AppendAddresses(Contact contact) { string sql = string.Format("SELECT * FROM ContactAddress WHERE ContactID = '{0}'", contact.Key); using (IDataReader reader = this.ExecuteReader(sql)) { while (reader.Read()) { contact.Addresses.Add(AddressFactory.BuildAddress(reader)); } } }
private void AppendAddresses(Company company) { string sql = string.Format("SELECT * FROM CompanyAddress WHERE CompanyID = '{0}'", company.Key); using (IDataReader reader = this.ExecuteReader(sql)) { Address address = null; while (reader.Read()) { address = AddressFactory.BuildAddress(reader); company.Addresses.Add(address); if (CompanyFactory.IsHeadquartersAddress(reader)) { company.HeadquartersAddress = address; } } } }