public void DeleteGenre(int genreID)
{
using (MusicContext context = new MusicContext())
{
context.Exec("Exec DeleteGenre " + genreID);
}
}
public TrackAlbum GetTrackAlbumById(int?id)
{
using (var context = new MusicContext())
{
return(context.TrackAlbums.AsNoTracking().SingleOrDefault(n => n.Id == id));
}
}
public void UpdateGenre(int genreID, string genre)
{
using (MusicContext context = new MusicContext())
{
context.Exec("Exec UpdateGenre " + genreID + ", '" + genre + "'");
}
}
public DataTable GetAllRatings()
{
using (MusicContext context = new MusicContext())
{
return(context.Exec <DataTable>("fetchRatings"));
}
}
public void DeleteRating(int RatingID)
{
using (MusicContext context = new MusicContext())
{
context.Exec("Exec DeleteRating " + RatingID);
}
}
/// <summary>
/// this deletes references between Genre and the selected song
/// </summary>
/// <param name="songID"></param>
public void DeleteReferences(int songID)
{
using (MusicContext context = new MusicContext())
{
context.Exec <DataTable>("RemoveGenreReferencesBySong " + songID);
}
}
public static void AddArtists()
{
var context = new MusicContext();
Artist artist1 = new Artist {
FirstName = "Michael", LastName = "Jackson", BirthOfDate = new DateTime(1958, 8, 29), Gender = "Male", Country = "USA"
};
Artist artist2 = new Artist {
FirstName = "Ed", LastName = "Sheeran", BirthOfDate = new DateTime(1991, 2, 17), Gender = "Male", Country = "UK"
};
Artist artist3 = new Artist {
FirstName = "Adele", LastName = "Adkins ", BirthOfDate = new DateTime(1988, 5, 5), Gender = "Female", Country = "UK"
};
Artist artist4 = new Artist {
FirstName = "Rihanna", LastName = "Fenty", BirthOfDate = new DateTime(1988, 2, 20), Gender = "Female", Country = "Barbados"
};
Artist artist5 = new Artist {
FirstName = "Stefani", LastName = "Germanotta", BirthOfDate = new DateTime(1986, 3, 28), Gender = "Female", Country = "USA"
};
List <Artist> myArtists = new List <Artist> {
artist1, artist2, artist3, artist4, artist5
};
context.Artists.AddRange(myArtists);
context.SaveChanges();
}
public void CreateReference(int songID, int ratingID)
{
using (MusicContext context = new MusicContext())
{
context.Exec("Exec AddRatingToSong " + songID + ", " + ratingID);
}
}
public void RemoveReference(int songID, int ratingID)
{
using (MusicContext context = new MusicContext())
{
context.Exec("Exec DeleteRatingToSong " + songID + ", " + ratingID);
}
}
// GET: Album
public IActionResult Index()
{
MusicContext context = HttpContext.RequestServices.GetService(typeof(JenkinsCRUD.Models.MusicContext))
as MusicContext;
return(View(context.GetAllAlbums()));
}
public ArtistController(MusicContext context)
{
_context = context;
if (_context.ArtistObjects.Count() == 0)
{
// DON"T JUDGE ME
_context.ArtistObjects.Add(new Artist
{
Name = "ArtistName",
Albums = new List <Album>()
{
new Album {
Name = "AlbumName",
YearReleased = 1992,
Songs = new List <Song>()
{
new Song {
Track = 0,
Name = "SongName",
Created = DateTime.Now,
LastModified = DateTime.Now
}
},
Created = DateTime.Now,
LastModified = DateTime.Now
}
},
Created = DateTime.Now,
LastModified = DateTime.Now
});
_context.SaveChanges();
}
}
public async Task SearchAsync(MusicContext music, string search)
{
music = await new MusicSearch(music, search).RunAsync();
if (music == null)
{
await music.Channel.SendMessageAsync("No result found.");
return;
}
if (IsSongInPlaylist(music))
{
await music.Channel.SendMessageAsync($"Couldn't queue your request of **{music.Song.Title ?? music.Song.VideoId}** because it's already in the playlist.");
return;
}
music = await new MusicPreemptiveDownload(music).RunAsync();
if (music == null)
{
await music.Channel.SendMessageAsync("Video not found.");
return;
}
if (music.Song.Duration.GetValueOrDefault().TotalMinutes > 9)
{
await music.Channel.SendMessageAsync("Video length exceeds limit (more than 9 minutes).");
return;
}
await QueueAsync(music);
}
public List <Artist> GetAllArtists()
{
using (var context = new MusicContext())
{
return(context.Artists.AsNoTracking().ToList());
}
}
public static void AddSongs()
{
List <Song> mySongs = new List <Song>
{
new Song
{
Name = "Remember the time", Genre = "POP", Duration = new TimeSpan(0, 4, 0), ReleaseYear = 1991
},
new Song
{
Name = "Heal the world", Genre = "POP", Duration = new TimeSpan(0, 6, 25), ReleaseYear = 1991
},
new Song
{
Name = "Beat it", Genre = "POP", Duration = new TimeSpan(0, 4, 18), ReleaseYear = 1982
},
new Song
{
Name = "I Just Can't Stop Loving You", Genre = "POP", Duration = new TimeSpan(0, 4, 12), ReleaseYear = 1995
}
};
var context = new MusicContext();
context.Songs.AddRange(mySongs);
context.SaveChanges();
}
public void CreateReference(int songID, int genreID)
{
using (MusicContext context = new MusicContext())
{
context.Exec("Exec AddGenreToSong " + songID + ", " + genreID);
}
}
static void Main(string[] args)
{
using (var context = new MusicContext())
{
var albums = context.Albums;
}
}
public static void AddAlbumSong()
{
var context = new MusicContext();
var album = context.Albums.First();
var song1 = context.Songs.FirstOrDefault(s => s.Name.StartsWith("Remember"));
var song2 = context.Songs.FirstOrDefault(s => s.Name.StartsWith("Heal"));
List <Song> songs = new List <Song> {
song1, song2
};
foreach (var song in songs)
{
context.AlbumSong.Add(new AlbumSong {
AlbumId = album.Id, SongId = song.Id
});
}
var album1 = context.Albums.FirstOrDefault(a => a.Name.StartsWith("HIStory"));
var song3 = context.Songs.FirstOrDefault(s => s.Name.StartsWith("Beat"));
var song4 = context.Songs.FirstOrDefault(s => s.Name.StartsWith("I Just"));
List <Song> songs1 = new List <Song> {
song2, song3, song4
};
foreach (var song in songs1)
{
context.AlbumSong.Add(new AlbumSong {
AlbumId = album1.Id, SongId = song.Id
});
}
context.SaveChanges();
}
public List <Genre> GetAllGenres()
{
using (var context = new MusicContext())
{
return(context.Genres.AsNoTracking().ToList());
}
}
public void RemoveReference(int songID, int genreID)
{
using (MusicContext context = new MusicContext())
{
context.Exec("Exec DeleteGenreToSong " + songID + ", " + genreID);
}
}
public Genre GetGenreById(int?id)
{
using (var context = new MusicContext())
{
return(context.Genres.AsNoTracking().SingleOrDefault(n => n.Id == id));
}
}
//Makes a List with the Music comments from the Database
public List <Music> GetAll()
{
using (context = new MusicContext())
{
return(context.MusicComments.ToList());
}
}
public void CreateReference(int songID, int artistID)
{
using (MusicContext context = new MusicContext())
{
context.Exec("Exec AddArtistToSong " + songID + ", " + artistID);
}
}
public void UpdateRating(int ratingID, string rating)
{
using (MusicContext context = new MusicContext())
{
context.Exec("Exec UpdateRating " + ratingID + ", '" + rating + "'");
}
}
public void RemoveReference(int songID, int artistID)
{
using (MusicContext context = new MusicContext())
{
context.Exec("Exec DeleteArtistToSong " + songID + ", " + artistID);
}
}
public List <TrackAlbum> GetAllTrackAlbums()
{
using (var context = new MusicContext())
{
return(context.TrackAlbums.AsNoTracking().ToList());
}
}
public DataTable GetGenreToSongInfo(int songID)
{
using (MusicContext context = new MusicContext())
{
return(context.Exec <DataTable>("fetchGenreBySongID " + songID));
}
}
public static void AddVenue()
{
var context = new MusicContext();
//Venue venue = new Venue { Name = "Stockholm Olympic Stadium", Address = "Lidingövägen", City = "Stockholm", Country = "Sweden" };
//context.Venues.Add(venue);
Venue venue1 = new Venue {
Name = "Wembley Stadium", Address = "London HA9 0WS", City = "London", Country = "UK"
};
Venue venue2 = new Venue {
Name = " Friends Arena", Address = "Råsta Strandväg 1", City = "Stockholm", Country = "Sweden"
};
Venue venue3 = new Venue {
Name = "Telenor Arena", Address = "Widerøeveien 1", City = "Oslo", Country = "Norway"
};
Venue venue4 = new Venue {
Name = "AccorHotels Arena", Address = "8 Boulevard de Bercy", City = "Paris", Country = "France"
};
Venue venue5 = new Venue {
Name = "Citi Field", Address = "120–01 Roosevelt Avenue", City = "New York", Country = "USA"
};
Venue venue6 = new Venue {
Name = " Toyota Center", Address = "1510 Polk Street", City = "Houston", Country = "USA"
};
List <Venue> venues = new List <Venue> {
venue1, venue2, venue3, venue4, venue5, venue6
};
context.Venues.AddRange(venues);
context.SaveChanges();
}
public void AddMembers(string first, string last, string term, string instrument)
{
var member = new BandMember()
{
Term = term
};
using (var context = new MusicContext())
{
member.Member = context.People.SingleOrDefault(b => b.FirstName.Equals(first) &&
b.LastName.Equals(last));
member.Instrument = context.Instruments.SingleOrDefault(b => b.Description.Equals(instrument));
member.Band = context.Bands.SingleOrDefault(b => b.Name.Equals("Yes"));
var existing = context.Bands.SingleOrDefault(b => b.Name.Equals("Yes") &&
b.Members.Count(m => m.Member.FirstName.Equals(first) &&
m.Member.LastName.Equals(last) &&
m.Instrument.Description.Equals(instrument)
) > 0
);
if (existing == null)
{
context.BandMembers.Add(member);
context.SaveChanges();
}
}
}
public SongRepositoryTests()
{
db = new MusicContext();
db.Database.BeginTransaction();
underTest = new SongRepository(db);
}
public ProductController(MusicContext db, IProduct product, IConfiguration config)
{
string PublicKey = config["Stripe:PublicKey"].ToString();
_db = db;
_product = product;
}
public MusicController()
{
SelectedMusic = AvailableMusics[Main.Random.Next(0, AvailableMusics.Count)];
AvailableMusics.Remove(SelectedMusic);
Context = MusicContext.Other;
SwitchMusicRandomly = false;
CanChangeMusic = true;
}
private static void Main(string[] args)
{
using (var context = new MusicContext())
{
var album = new Album { Price = 12m, Title = "drushyam" };
context.Albums.Add(album);
context.SaveChanges();
}
}
public SetupController(MusicContext musicContext)
{
_musicContext = musicContext;
}
public void SwitchTo(MusicContext context, string musicName, bool playNow)
{
Audio.StopMusic(SelectedMusic, true, 500);
string lastMusic = SelectedMusic;
// current
switch (context)
{
case MusicContext.Won:
SelectedMusic = musicName == null ? AvailableGameWonMusics[Main.Random.Next(0, AvailableGameWonMusics.Count)] : musicName;
AvailableGameWonMusics.Remove(SelectedMusic);
CanChangeMusic = true;
break;
case MusicContext.Lost:
SelectedMusic = musicName == null ? AvailableGameLostMusics[Main.Random.Next(0, AvailableGameLostMusics.Count)] : musicName;
AvailableGameLostMusics.Remove(SelectedMusic);
CanChangeMusic = true;
break;
case MusicContext.Other:
SelectedMusic = musicName == null ? AvailableMusics[Main.Random.Next(0, AvailableMusics.Count)] : musicName;
AvailableMusics.Remove(SelectedMusic);
CanChangeMusic = true;
break;
case MusicContext.Cutscene:
SelectedMusic = musicName == null ? AvailableCutsceneMusics[Main.Random.Next(0, AvailableCutsceneMusics.Count)] : musicName;
AvailableCutsceneMusics.Remove(SelectedMusic);
CanChangeMusic = false;
break;
}
// previous
switch (Context)
{
case MusicContext.Won: AvailableGameWonMusics.Add(lastMusic); break;
case MusicContext.Lost: AvailableGameLostMusics.Add(lastMusic); break;
case MusicContext.Other: AvailableMusics.Add(lastMusic); break;
case MusicContext.Cutscene: AvailableCutsceneMusics.Add(lastMusic); break;
}
Context = context;
if (playNow)
Audio.PlayMusic(SelectedMusic, true, FadeTime, true);
}
public void SwitchTo(MusicContext context)
{
SwitchTo(context, null, true);
}