Beispiel #1
0
 public static Band GetBandAsync2(string selectedBand)
 {
     Band gevondenBand = new Band();
     //ObservableCollection<Band> lst = await GetBandsAsync();
     
     return gevondenBand;
 }
Beispiel #2
0
 public static Band GetBandByID(int id)
 {
     Band gevondenBand = new Band();
     string sql = "SELECT * FROM Bands WHERE ID=@id;";
     DbParameter parID = Database.AddParameter("@id", id);
     DbDataReader reader = Database.GetData(sql, parID);           
     while (reader.Read())
     {
         gevondenBand = CreateBand(reader);
     }            
     return gevondenBand;
 }
Beispiel #3
0
        private static Band CreateBand(DbDataReader reader)
        {

            Band band = new Band();
            band.ID = Convert.ToInt32(reader["ID"].ToString());
            band.Name = Convert.ToString(reader["Name"]);
            band.Picture = (byte[])reader["Picture"];
            band.Descr = Convert.ToString(reader["Description"]);
            band.Twitter = Convert.ToString(reader["Twitter"]);
            band.Facebook = Convert.ToString(reader["Facebook"]);
            band.Genres = GenreRepository.GetGenresByID (Convert.ToInt32(reader["ID"]));
            return band;
        }
Beispiel #4
0
        public async void GetBandFromAPI(int id)
        {
            List<Band> Bands = new List<FestivalLibPortable.Band>();
            HttpClient client = new HttpClient();
            client.DefaultRequestHeaders.Accept.Add(new
            System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/xml"));

            HttpResponseMessage response = await client.GetAsync("http://localhost:18358/api/band/" + id);
            if (response.IsSuccessStatusCode)
            {
                Stream stream = await response.Content.ReadAsStreamAsync();
                DataContractSerializer dxml = new DataContractSerializer(typeof(FestivalLibPortable.Band));
                Band = dxml.ReadObject(stream) as Band;
                stream.Dispose();
                Bands.Add(Band);
                DeBand.ItemsSource = Bands;
            }

        }