static public List <ZipCodeImport> GetAll() { List <ZipCodeImport> objZipCodeImports = new List <ZipCodeImport>(); Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); using (IDataReader reader = db.ExecuteReader(CommandType.Text, _selectViewSQL)) { while (reader.Read()) { ZipCodeImport objZipCodeImport = new ZipCodeImport(); LoadZipCodeImport(objZipCodeImport, reader); objZipCodeImports.Add(objZipCodeImport); } // always call Close when done reading. reader.Close(); return(objZipCodeImports); } }
static public void Insert(ZipCodeImport objZipCodeImport) { Database db = DatabaseFactory.CreateDatabase("BRGCaseMail"); System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_ZipCodeImportInsert"); db.AddInParameter(dbCommand, "ZipCode", DbType.String, objZipCodeImport.ZipCode); db.AddInParameter(dbCommand, "City", DbType.String, objZipCodeImport.City); db.AddInParameter(dbCommand, "State", DbType.String, objZipCodeImport.State); db.AddInParameter(dbCommand, "County", DbType.String, objZipCodeImport.County); db.AddInParameter(dbCommand, "AreaCode", DbType.String, objZipCodeImport.AreaCode); db.AddInParameter(dbCommand, "CityType", DbType.String, objZipCodeImport.CityType); db.AddInParameter(dbCommand, "CityAliasAbbreviation", DbType.String, objZipCodeImport.CityAliasAbbreviation); db.AddInParameter(dbCommand, "CityAliasName", DbType.String, objZipCodeImport.CityAliasName); db.AddInParameter(dbCommand, "Latitude", DbType.String, objZipCodeImport.Latitude); db.AddInParameter(dbCommand, "Longitude", DbType.String, objZipCodeImport.Longitude); db.AddInParameter(dbCommand, "TimeZone", DbType.String, objZipCodeImport.TimeZone); db.AddInParameter(dbCommand, "Elevation", DbType.String, objZipCodeImport.Elevation); db.AddInParameter(dbCommand, "CountyFIPS", DbType.String, objZipCodeImport.CountyFIPS); db.AddInParameter(dbCommand, "DayLightSaving", DbType.String, objZipCodeImport.DayLightSaving); db.AddInParameter(dbCommand, "PreferredLastLineKey", DbType.String, objZipCodeImport.PreferredLastLineKey); db.AddInParameter(dbCommand, "ClassificationCode", DbType.String, objZipCodeImport.ClassificationCode); db.AddInParameter(dbCommand, "MultiCounty", DbType.String, objZipCodeImport.MultiCounty); db.AddInParameter(dbCommand, "StateFIPS", DbType.String, objZipCodeImport.StateFIPS); db.AddInParameter(dbCommand, "CityStateKey", DbType.String, objZipCodeImport.CityStateKey); db.AddInParameter(dbCommand, "CityAliasCode", DbType.String, objZipCodeImport.CityAliasCode); db.AddInParameter(dbCommand, "PrimaryRecord", DbType.String, objZipCodeImport.PrimaryRecord); db.AddInParameter(dbCommand, "CityMixedCase", DbType.String, objZipCodeImport.CityMixedCase); db.AddInParameter(dbCommand, "CityAliasMixedCase", DbType.String, objZipCodeImport.CityAliasMixedCase); db.AddInParameter(dbCommand, "StateANSI", DbType.String, objZipCodeImport.StateANSI); db.AddInParameter(dbCommand, "CountyANSI", DbType.String, objZipCodeImport.CountyANSI); db.AddInParameter(dbCommand, "FacilityCode", DbType.String, objZipCodeImport.FacilityCode); db.AddInParameter(dbCommand, "CityDeliveryIndicator", DbType.String, objZipCodeImport.CityDeliveryIndicator); db.AddInParameter(dbCommand, "CarrierRouteRateSortation", DbType.String, objZipCodeImport.CarrierRouteRateSortation); db.AddInParameter(dbCommand, "FinanceNumber", DbType.String, objZipCodeImport.FinanceNumber); db.AddInParameter(dbCommand, "UniqueZIPName", DbType.String, objZipCodeImport.UniqueZIPName); db.ExecuteNonQuery(dbCommand); }
public ZipCodeImport Copy() { ZipCodeImport _zipCodeImport = new ZipCodeImport(); _zipCodeImport.ZipCode = _zipCode; _zipCodeImport.City = _city; _zipCodeImport.State = _state; _zipCodeImport.County = _county; _zipCodeImport.AreaCode = _areaCode; _zipCodeImport.CityType = _cityType; _zipCodeImport.CityAliasAbbreviation = _cityAliasAbbreviation; _zipCodeImport.CityAliasName = _cityAliasName; _zipCodeImport.Latitude = _latitude; _zipCodeImport.Longitude = _longitude; _zipCodeImport.TimeZone = _timeZone; _zipCodeImport.Elevation = _elevation; _zipCodeImport.CountyFIPS = _countyFIPS; _zipCodeImport.DayLightSaving = _dayLightSaving; _zipCodeImport.PreferredLastLineKey = _preferredLastLineKey; _zipCodeImport.ClassificationCode = _classificationCode; _zipCodeImport.MultiCounty = _multiCounty; _zipCodeImport.StateFIPS = _stateFIPS; _zipCodeImport.CityStateKey = _cityStateKey; _zipCodeImport.CityAliasCode = _cityAliasCode; _zipCodeImport.PrimaryRecord = _primaryRecord; _zipCodeImport.CityMixedCase = _cityMixedCase; _zipCodeImport.CityAliasMixedCase = _cityAliasMixedCase; _zipCodeImport.StateANSI = _stateANSI; _zipCodeImport.CountyANSI = _countyANSI; _zipCodeImport.FacilityCode = _facilityCode; _zipCodeImport.CityDeliveryIndicator = _cityDeliveryIndicator; _zipCodeImport.CarrierRouteRateSortation = _carrierRouteRateSortation; _zipCodeImport.FinanceNumber = _financeNumber; _zipCodeImport.UniqueZIPName = _uniqueZIPName; return(_zipCodeImport); }
static private void LoadZipCodeImport(ZipCodeImport objZipCodeImport, IDataReader _reader) { if (_reader.IsDBNull(0) != true) { objZipCodeImport.ZipCode = _reader.GetString(0); } if (_reader.IsDBNull(1) != true) { objZipCodeImport.City = _reader.GetString(1); } if (_reader.IsDBNull(2) != true) { objZipCodeImport.State = _reader.GetString(2); } if (_reader.IsDBNull(3) != true) { objZipCodeImport.County = _reader.GetString(3); } if (_reader.IsDBNull(4) != true) { objZipCodeImport.AreaCode = _reader.GetString(4); } if (_reader.IsDBNull(5) != true) { objZipCodeImport.CityType = _reader.GetString(5); } if (_reader.IsDBNull(6) != true) { objZipCodeImport.CityAliasAbbreviation = _reader.GetString(6); } if (_reader.IsDBNull(7) != true) { objZipCodeImport.CityAliasName = _reader.GetString(7); } if (_reader.IsDBNull(8) != true) { objZipCodeImport.Latitude = _reader.GetString(8); } if (_reader.IsDBNull(9) != true) { objZipCodeImport.Longitude = _reader.GetString(9); } if (_reader.IsDBNull(10) != true) { objZipCodeImport.TimeZone = _reader.GetString(10); } if (_reader.IsDBNull(11) != true) { objZipCodeImport.Elevation = _reader.GetString(11); } if (_reader.IsDBNull(12) != true) { objZipCodeImport.CountyFIPS = _reader.GetString(12); } if (_reader.IsDBNull(13) != true) { objZipCodeImport.DayLightSaving = _reader.GetString(13); } if (_reader.IsDBNull(14) != true) { objZipCodeImport.PreferredLastLineKey = _reader.GetString(14); } if (_reader.IsDBNull(15) != true) { objZipCodeImport.ClassificationCode = _reader.GetString(15); } if (_reader.IsDBNull(16) != true) { objZipCodeImport.MultiCounty = _reader.GetString(16); } if (_reader.IsDBNull(17) != true) { objZipCodeImport.StateFIPS = _reader.GetString(17); } if (_reader.IsDBNull(18) != true) { objZipCodeImport.CityStateKey = _reader.GetString(18); } if (_reader.IsDBNull(19) != true) { objZipCodeImport.CityAliasCode = _reader.GetString(19); } if (_reader.IsDBNull(20) != true) { objZipCodeImport.PrimaryRecord = _reader.GetString(20); } if (_reader.IsDBNull(21) != true) { objZipCodeImport.CityMixedCase = _reader.GetString(21); } if (_reader.IsDBNull(22) != true) { objZipCodeImport.CityAliasMixedCase = _reader.GetString(22); } if (_reader.IsDBNull(23) != true) { objZipCodeImport.StateANSI = _reader.GetString(23); } if (_reader.IsDBNull(24) != true) { objZipCodeImport.CountyANSI = _reader.GetString(24); } if (_reader.IsDBNull(25) != true) { objZipCodeImport.FacilityCode = _reader.GetString(25); } if (_reader.IsDBNull(26) != true) { objZipCodeImport.CityDeliveryIndicator = _reader.GetString(26); } if (_reader.IsDBNull(27) != true) { objZipCodeImport.CarrierRouteRateSortation = _reader.GetString(27); } if (_reader.IsDBNull(28) != true) { objZipCodeImport.FinanceNumber = _reader.GetString(28); } if (_reader.IsDBNull(29) != true) { objZipCodeImport.UniqueZIPName = _reader.GetString(29); } }