public IEnumerable <string> insertMusic(string SingerName, string AlbumName, string MusicFileName, string Description)
{
if (SingerName == null)
{
SingerName = "";
}
if (MusicFileName == null)
{
MusicFileName = "";
}
if (AlbumName == null)
{
AlbumName = "";
}
if (Description == null)
{
Description = "";
}
using (var db = new MusicDataContext())
{
db.Songs.Add(new MusicPlayerMastera
{
Description = Description, AlbumName = AlbumName, MusicFileName = MusicFileName,
SingerName = SingerName
});
db.SaveChanges();
}
return(new List <string>());
}
/// <summary>
/// Initializes failsafe parts of the app.
///
/// Safe to call from App.xaml.cs constructor.
/// </summary>
public static void Start()
{
ProviderService.Instance.Register(new PhoneProvider());
Application.Current.Host.Settings.EnableFrameRateCounter = false;
FileUtils.CreateDirIfNotExists(PhoneLocalLibrary.Instance.BaseMusicPath);
FileUtils.CreateDirIfNotExists(PhoneCoverService.CoverFolder);
// initializes the database if it doesn't exist
MusicDataContext.CreateIfNotExists();
DownloadDataContext.CreateIfNotExists();
UiService.Instance.SetUiUtils(PhoneUtil.Instance);
}
public IEnumerable <string> insertAlbum(string AlbumName, string ImageName)
{
if (AlbumName == null || ImageName == null)
{
return(new List <string>());
}
using (var db = new MusicDataContext())
{
db.Albums.Add(new AlbumMastera {
AlbumName = AlbumName, ImageName = ImageName
});
db.SaveChanges();
}
return(new List <string>());
}
public IEnumerable <MusicPlayerMastera> getMusicSelectALL(string AlbumName)
{
List <MusicPlayerMastera> songs;
using (var db = new MusicDataContext())
{
if (AlbumName == null)
{
songs = db.Songs.ToList();
}
else
{
songs = db.Songs.Where(song => song.AlbumName == AlbumName).ToList();
}
}
return(songs);
}
public IEnumerable <string> deleteMusic(string MusicPlayerMasteraID)
{
if (MusicPlayerMasteraID == null)
{
MusicPlayerMasteraID = "0";
}
using (var db = new MusicDataContext())
{
var song = db.Songs.FirstOrDefault(s => s.MusicPlayerMasteraID.ToString() == MusicPlayerMasteraID);
if (song != null)
{
db.Songs.Remove(song);
db.SaveChanges();
}
}
return(new List <string>());
}
public IEnumerable <AlbumMastera> getAlbums(string AlbumName)
{
List <AlbumMastera> albums;
using (var db = new MusicDataContext())
{
if (AlbumName == null)
{
albums = db.Albums.ToList();
}
else
{
albums = db.Albums.Where(album => album.AlbumName == AlbumName).ToList();
}
}
return(albums);
}
public IEnumerable <string> updateMusic(string MusicPlayerMasteraID, string SingerName, string AlbumName, string MusicFileName, string Description)
{
var EmptyList = new List <string>();
if (MusicPlayerMasteraID == null)
{
return(EmptyList);
}
if (SingerName == null)
{
return(EmptyList);
}
if (MusicFileName == null)
{
return(EmptyList);
}
if (AlbumName == null)
{
return(EmptyList);
}
if (Description == null)
{
return(EmptyList);
}
using (var db = new MusicDataContext())
{
var song = db.Songs.FirstOrDefault(s => s.MusicPlayerMasteraID.ToString() == MusicPlayerMasteraID);
if (song != null)
{
song.AlbumName = AlbumName;
song.Description = Description;
song.MusicFileName = MusicFileName;
song.SingerName = SingerName;
}
db.SaveChanges();
}
return(EmptyList);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
var dbMusic = new MusicDataContext();
album a = new album();
a.album_id = txtAlbumID.Text;
a.album_name = txtAlbumName.Text;
a.album_artist = txtAlbumArtist.Text;
a.album_price = Convert.ToDouble(txtAlbumPrice.Text);
dbMusic.albums.InsertOnSubmit(a);
dbMusic.SubmitChanges();
lblAlbumMessage.Text = "You have successfully added the details of a new album.";
btnAdd.Enabled = false;
btnAlbum.Enabled = true;
txtAlbumID.Enabled = false;
txtAlbumName.Enabled = false;
txtAlbumArtist.Enabled = false;
txtAlbumPrice.Enabled = false;
txtAlbumID.Text = "";
txtAlbumName.Text = "";
txtAlbumArtist.Text = "";
txtAlbumPrice.Text = "";
}
public PlaylistController(MusicDataContext context)
{
_context = context;
}
