public Boolean LoadFromDatabase(Int64 entityId, Core.Enumerations.EntityAddressType addressType, DateTime forDate) { Boolean success = false; String selectStatment = "EXEC dal.EntityAddress_SelectByTypeAndDate " + entityId.ToString() + ", " + ((Int32)addressType).ToString() + ", '" + forDate.ToString("MM/dd/yyyy") + "'"; System.Data.DataTable tableEntityAddress; if (base.application.EnvironmentDatabase == null) { return(false); } tableEntityAddress = base.application.EnvironmentDatabase.SelectDataTable(selectStatment); if (tableEntityAddress.Rows.Count == 1) { MapDataFields(tableEntityAddress.Rows[0]); success = true; } else { application.SetLastException(application.EnvironmentDatabase.LastException); success = false; } return(success); }
public EntityAddress(Application applicationReference, Int64 entityId, Core.Enumerations.EntityAddressType addressType, DateTime forDate) { BaseConstructor(applicationReference); if (!LoadFromDatabase(entityId, addressType, forDate)) { throw new ApplicationException("Unable to load Entity Address."); } }
override public void MapDataFields(System.Data.DataRow currentRow) { base.MapDataFields(currentRow); entityId = (Int64)currentRow["EntityId"]; addressType = (Core.Enumerations.EntityAddressType)((Int32)currentRow["AddressType"]); line1 = (String)currentRow["Line1"]; line2 = (String)currentRow["Line2"]; city = (String)currentRow["City"]; state = (String)currentRow["State"]; zipCode = (String)currentRow["ZipCode"]; zipPlus4 = (String)currentRow["ZipPlus4"]; postalCode = (String)currentRow["PostalCode"]; county = (String)currentRow["County"]; longitude = (Decimal)currentRow["Longitude"]; latitude = (Decimal)currentRow["Latitude"]; effectiveDate = (DateTime)currentRow["EffectiveDate"]; terminationDate = (DateTime)currentRow["TerminationDate"]; return; } // MapDataFields (System.Data.DataRow currentRow)