/// <summary> /// Data access method for single District /// </summary> /// <param name="cmd"></param> /// <returns>District object</returns> private SchoolDistrict GetDistrict(SqlCommand cmd) { SchoolDistrict district = null; SqlDataReader dr = GetReader(cmd); decimal loResult = 0, laResult = 0; if (dr.Read()) { if (!(decimal.TryParse(dr["Latitude"].ToString(), out laResult))) { laResult = 0; } if (!(decimal.TryParse(dr["Longitude"].ToString(), out loResult))) { loResult = 0; } district = new SchoolDistrict(); district.LocationId = Int64.Parse(dr["LocationId"].ToString()); district.DistrictNumber = dr["DistrictNumber"].ToString(); district.LocationName = dr["LocationName"].ToString(); district.Address = dr["Address"].ToString(); district.City = dr["City"].ToString(); district.State = dr["State"].ToString(); district.Zip = dr["Zip"].ToString(); district.Phone = dr["Phone"].ToString(); district.Email = dr["Email"].ToString(); district.Website = dr["Website"].ToString(); district.JobPage = dr["JobPage"].ToString(); district.Latitude = laResult; district.Longitude = loResult; district.LastUpdated = DateTime.Parse(dr["LastUpdated"].ToString()); } dr.Close(); return(district); }
/// <summary> /// data access method for multiple District objects /// </summary> /// <param name="cmd"></param> /// <returns>An array of District objects</returns> private SchoolDistrict[] GetDistrictArray(SqlCommand cmd) { ArrayList districtArray = new ArrayList(); SqlDataReader dr = null; try { dr = GetReader(cmd); while (dr.Read()) { decimal laResult, loResult = 0; if (!(decimal.TryParse(dr["Latitude"].ToString(), out laResult))) { laResult = 0; } if (!(decimal.TryParse(dr["Longitude"].ToString(), out loResult))) { loResult = 0; } //if (decimal.TryParse(dr["Latitude"].ToString(), out laResult) && decimal.TryParse(dr["Longitude"].ToString(), out loResult)) //{ SchoolDistrict district = new SchoolDistrict(); district.LocationId = Int64.Parse(dr["LocationId"].ToString()); district.DistrictNumber = dr["DistrictNumber"].ToString(); district.LocationName = dr["LocationName"].ToString(); district.Address = dr["Address"].ToString(); district.City = dr["City"].ToString(); district.State = dr["State"].ToString(); district.Zip = dr["Zip"].ToString(); district.Phone = dr["Phone"].ToString(); district.Email = dr["Email"].ToString(); district.Website = dr["Website"].ToString(); district.JobPage = dr["JobPage"].ToString(); district.Latitude = laResult; district.Longitude = loResult; district.LastUpdated = DateTime.Parse(dr["LastUpdated"].ToString()); districtArray.Add(district); //} } } catch (Exception ex) { string filePath = @"D:\Websites92\Error.txt"; using (StreamWriter writer = new StreamWriter(filePath, true)) { writer.WriteLine("Message: " + ex.Message + "<br/>" + Environment.NewLine + "StackTrace: " + ex.StackTrace); if (ex.InnerException != null) { writer.WriteLine(ex.InnerException.Message); } else { writer.WriteLine("No inner exception"); } } } finally { dr.Close(); } if (districtArray.Count == 0) { return(null); } else { return((SchoolDistrict[])districtArray.ToArray(typeof(SchoolDistrict))); } }