//seed some objects in database
static void Main()
{
MusicStoreEntities dbcon = new MusicStoreEntities();
Album album1 = new Album()
{
Title = "Album1",
Year = 1995,
Producer = "Producer1"
};
album1.Artists.Add(
new Artist()
{
Name = "Artist1",
Country = "Bulgaria",
DateOfBirth = new DateTime(1912, 5, 12)
});
album1.Artists.Add(
new Artist()
{
Name = "Artist2",
Country = "Germany",
DateOfBirth = new DateTime(1982, 1, 24)
});
album1.Songs.Add(
new Song()
{
Title = "Song1",
Year = 1896,
Genre = "Jazz",
ArtistId = 11
});
album1.Songs.Add(
new Song()
{
Title = "Song2",
Year = 1932,
Genre = "Jazz",
ArtistId = 11
});
album1.Songs.Add(
new Song()
{
Title = "Song3",
Year = 1999,
Genre = "Pop",
ArtistId = 12
});
dbcon.Albums.Add(album1);
dbcon.SaveChanges();
}
private static void UpdateAlbum()
{
Console.Write("Title: ");
string title = Console.ReadLine();
Console.Write("Year: ");
int year = int.Parse(Console.ReadLine());
Console.Write("Producer: ");
string producer = Console.ReadLine();
Album updatedAlbum = new Album()
{
Title = title,
Year = year,
Producer = producer
};
Console.Write("Id to update: ");
int idForUpdate = int.Parse(Console.ReadLine());
var putAlbumResponse = jsonClient.PutAsJsonAsync("api/albums/" + idForUpdate, updatedAlbum).Result;
if (putAlbumResponse.IsSuccessStatusCode)
{
Console.WriteLine("Artist updated!");
}
else
{
Console.WriteLine("{0}, ({1})", (int)putAlbumResponse.StatusCode, putAlbumResponse.ReasonPhrase);
}
}
private static void CreateAlbum()
{
Console.Write("Title: ");
string title = Console.ReadLine();
Console.Write("Year: ");
int year = int.Parse(Console.ReadLine());
Console.Write("Producer: ");
string producer = Console.ReadLine();
Album album = new Album()
{
Title = title,
Year = year,
Producer = producer
};
var postAlbumResponse = jsonClient.PostAsJsonAsync("api/albums", album).Result;
if (postAlbumResponse.IsSuccessStatusCode)
{
Console.WriteLine("Album added!");
}
else
{
Console.WriteLine("{0} ({1})", (int)postAlbumResponse.StatusCode, postAlbumResponse.ReasonPhrase);
}
}
