public CountersToUpdateViewModel() { Counters = new List <Counter>(); Flats = new List <Flat>(); Street = new Street(); HouseNumber = new HouseNumber(); }
// --- HOUSE NUMBERS public IEnumerable <HouseNumber> GetHouseNumbers(int StreetId) { List <HouseNumber> houseNumbers = new List <HouseNumber>(); using (SqlConnection conn = new SqlConnection(connString)) { SqlCommand cmd = new SqlCommand("select*from houseNumbers where StreetId=@StreetId", conn); cmd.Parameters.AddWithValue("@StreetId", StreetId); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { HouseNumber hn = new HouseNumber(); hn.Id = Convert.ToInt32(rdr["Id"]); hn.Name = rdr["Name"].ToString(); houseNumbers.Add(hn); } conn.Close(); } return(houseNumbers); }
public FlatsStreetsHouses() { FlatData = new List <FlatCounterDataViewModel>(); Street = new Street(); HouseNumber = new HouseNumber(); }