public PlaceInfo(string geoEntry) { var fields = geoEntry.Split(fieldsDelimiter); if (fields.Length != fieldCount) { throw new ArgumentException("Invalid GeoName Record"); } PlaceInfoId = int.Parse(fields.GetValue(PlaceInfoFields.PlaceInfoId), CultureInfo.InvariantCulture); Name = fields.GetValue(PlaceInfoFields.Name); AsciiName = fields.GetValue(PlaceInfoFields.AsciiName); AlternateNames = fields.GetValue(PlaceInfoFields.AlternateNames); Latitude = double.Parse(fields.GetValue(PlaceInfoFields.Latitude), CultureInfo.InvariantCulture); Longitude = double.Parse(fields.GetValue(PlaceInfoFields.Longitude), CultureInfo.InvariantCulture); FeatureCode = fields.GetValue(PlaceInfoFields.FeatureCode); FeatureClass = FeatureCode.ToFeatureClass(); CountryCode = fields.GetValue(PlaceInfoFields.CountryCode); AltCountryCodes = fields.GetValue(PlaceInfoFields.AltCountryCodes); Admin1Code = fields.GetValue(PlaceInfoFields.Admin1Code); Admin2Code = fields.GetValue(PlaceInfoFields.Admin2Code); Admin3Code = fields.GetValue(PlaceInfoFields.Admin3Code); Admin4Code = fields.GetValue(PlaceInfoFields.Admin4Code); Population = long.Parse(fields.GetValue(PlaceInfoFields.Population), CultureInfo.InvariantCulture); Elevation = fields.GetValue(PlaceInfoFields.Elevation).GetIntOrNull(); Dem = int.Parse(fields.GetValue(PlaceInfoFields.Dem), CultureInfo.InvariantCulture); TimeZone = fields.GetValue(PlaceInfoFields.TimeZone); ModificationDate = DateTime.ParseExact(fields.GetValue(PlaceInfoFields.ModificationDate), modificationDateFormat, CultureInfo.InvariantCulture); }
public IActionResult UpdateSingleFeatureCode(Upd_VM.FeatureCode featureCode) { try { if (ModelState.IsValid) { List <Upd_VM.FeatureCode> inputFeatureCodes = new List <Upd_VM.FeatureCode>(); inputFeatureCodes.Add(featureCode); IEnumerable <FeatureCode> result = repository.UpdateFeatureCodes(inputFeatureCodes); if (result != null && result.Count() > 0) { var primaryKey = featureCode.FeatureCodeId; byte[] inputRowId = featureCode.RowId; byte[] outputRowId = result .Where(outputFeatureCode => outputFeatureCode.FeatureCodeId == primaryKey) .Select(outputFeatureCode => outputFeatureCode.RowId) .FirstOrDefault(); bool rowIdsAreEqual = inputRowId.SequenceEqual(outputRowId); if (rowIdsAreEqual) { return(BadRequest(ErrMsgs.ErrorMessages_US_en.NotUpdated_SingleEntry)); } else { FeatureCode outputFeatureCode = new FeatureCode(); outputFeatureCode = result.FirstOrDefault(); return(Ok(outputFeatureCode)); } } else { return(StatusCode(500)); } } else { return(BadRequest(ModelState)); } } catch (Exception ex) { Debug.WriteLine(ex); throw; } }
/// <summary> /// Takes an prepopulated IDataReader and creates an array of FeatureCodes /// </summary> public static List<FeatureCode> PopulateObject(IDataReader dr) { ColumnFieldList list = new ColumnFieldList(dr); List<FeatureCode> arr = new List<FeatureCode>(); FeatureCode obj; while (dr.Read()) { obj = new FeatureCode(); if (list.IsColumnPresent("FeatureCodeID")) { obj._featureCodeID = (int)dr["FeatureCodeID"]; } if (list.IsColumnPresent("FeatureCodeCD")) { obj._featureCodeCD = (string)dr["FeatureCodeCD"]; } if (list.IsColumnPresent("FeatureClassID")) { obj._featureClassID = (int)dr["FeatureClassID"]; } if (list.IsColumnPresent("Name")) { obj._name = (string)dr["Name"]; } if (list.IsColumnPresent("Description")) { obj._description = (string)dr["Description"]; } arr.Add(obj); } dr.Close(); return arr; }