public List <int> GetSupplierUsersIds(int cityId) { UserQuery userQuery = new UserQuery(language); System.Data.DataTable dataTable = conn_db.ReadTable(userQuery.GetSuppliersByCity(cityId)); List <int> users = new List <int>(); if (dataTable.Rows.Count == 0) { throw new EmptyViewException(language); } foreach (System.Data.DataRow row in dataTable.Rows) { int user = row["user_id"] is DBNull ? 0 : Convert.ToInt32(row["user_id"]); users.Add(user); } return(users); }