public void saveChanges()
{
using (var db = new RadioPlayer())
{
tbl_mood mood = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.id.Text);
mood = db.tbl_mood.Where(m => m.mood_id == id).FirstOrDefault();
if (mood == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.id.Text}' does not exist.";
return;
}
}
else
{
mood = new tbl_mood();
}
mood.description = this.description.Text;
if (this._isCreateMode)
{
db.tbl_mood.Add(mood);
}
db.SaveChanges();
}
}
public void deleteItem(object item)
{
if (item == null)
{
return;
}
tbl_track track = item as tbl_track;
if (track == null)
{
return;
}
using (var db = new RadioPlayer())
{
foreach (var map in db.tbl_collectionmap.Where(m => m.track_id == track.track_id))
{
db.tbl_collectionmap.Remove(map);
}
db.tbl_track.Remove(db.tbl_track.Where(t => t.track_id == track.track_id).First());
db.SaveChanges();
}
}
public void saveChanges()
{
using (var db = new RadioPlayer())
{
tbl_genre genre = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.id.Text);
genre = db.tbl_genre.Where(g => g.genre_id == id).FirstOrDefault();
if (genre == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.id.Text}' does not exist.";
return;
}
}
else
{
genre = new tbl_genre();
}
genre.description = this.description.Text;
if (this._isCreateMode)
{
db.tbl_genre.Add(genre);
}
db.SaveChanges();
}
}
public void deleteItem(object item)
{
if (item == null)
{
return;
}
tbl_collection collection = item as tbl_collection;
if (collection == null)
{
return;
}
using (var db = new RadioPlayer())
{
foreach (var map in db.tbl_collectionmap.Where(m => m.collection_id == collection.collection_id))
{
db.tbl_collectionmap.Remove(map);
}
db.tbl_collection.Remove(db.tbl_collection.Where(g => g.collection_id == collection.collection_id).First());
db.SaveChanges();
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new RadioPlayer())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(tbl_collection.collection_id))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "Title",
Binding = new Binding(nameof(tbl_collection.title))
});
foreach (var collection in db.tbl_collection)
{
grid.Items.Add(collection);
// Cache data
foreach (var map in collection.tbl_collectionmap)
{
map.ToString();
map.tbl_collection.ToString();
map.tbl_track.ToString();
}
}
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new RadioPlayer())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(tbl_playlist_header.playlist_header_id))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "Description",
Binding = new Binding(nameof(tbl_playlist_header.description))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "Creator",
Binding = new Binding(nameof(tbl_playlist_header.creator))
});
foreach (var playlist in db.tbl_playlist_header)
{
grid.Items.Add(playlist);
// Cache data
foreach (var map in playlist.tbl_playlist_lines)
{
map.ToString();
map.tbl_playlist_header.ToString();
map.tbl_track.ToString();
}
}
}
}
private void PlayClick(object sender, RoutedEventArgs e)
{
RadioPlayer.PlayFile(_path, Convert.ToInt32(m_Volume.Value * 10));
timer.Start();
TimeOfMusic.Text = TimeSpan.FromSeconds(RadioPlayer.GetTimeOfStream(RadioPlayer.Stream)).ToString();
m_Slider.Maximum = RadioPlayer.GetTimeOfStream(RadioPlayer.Stream);
m_listBox.Items.Add(_path);
}
/// <summary>
/// Draw lines in visualizator
/// </summary>
public void DrawLines()
{
RadioPlayer.GetChannelInfo(RadioPlayer.Stream);
for (int i = 0; i < lines.Count; i++)
{
lines[i].Y2 = 200 - (RadioPlayer.fft[i] * 300);
}
}
public void saveChanges()
{
using (var db = new RadioPlayer())
{
tbl_collection collection = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.txtID.Text);
collection = db.tbl_collection.Where(c => c.collection_id == id).FirstOrDefault();
if (collection == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.txtID.Text}' does not exist.";
return;
}
}
else
{
collection = new tbl_collection();
}
collection.title = this.txtTitle.Text;
// Any values left in mapList need to be removed.
var mapList = collection.tbl_collectionmap.ToList();
var trackList = this.listTracks.items.Select(i => i as tbl_track).ToList();
for (int index = 0; index < trackList.Count(); index++)
{
var track = trackList[index];
var map = mapList.Where(m => m.track_id == track.track_id).FirstOrDefault();
if (map == null)
{
db.tbl_collectionmap.Add(new tbl_collectionmap()
{
tbl_collection = collection,
track_id = track.track_id,
sequence_index = index
});
continue;
}
map.sequence_index = index;
mapList.Remove(map);
}
foreach (var map in mapList)
{
db.tbl_collectionmap.Remove(map);
}
if (this._isCreateMode)
{
db.tbl_collection.Add(collection);
}
db.SaveChanges();
}
}
public static RadioPlayer Create()
{
if (rp == null)
{
lock (rp);
rp = new RadioPlayer();
}
return(rp);
}
/// <summary>
/// Change volume of stream
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void RangeBase_OnValueChanged(object sender, RoutedPropertyChangedEventArgs <double> e)
{
TextBlockVolume.Opacity = 1;
//TextBlockPlaying.Text = SliderVal.Value.ToString();
int vol = Convert.ToInt32(SliderVal.Value);
TextBlockVolume.Text = vol.ToString();
RadioPlayer.SetVolumeToStream(RadioPlayer.Stream, vol);
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new RadioPlayer())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(tbl_track.track_id))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "Title",
Binding = new Binding(nameof(tbl_track.title))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "Subtitle",
Binding = new Binding(nameof(tbl_track.subtitle))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "Publisher",
Binding = new Binding(nameof(tbl_track.publisher))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "Likes",
Binding = new Binding(nameof(tbl_track.likes))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "Dislikes",
Binding = new Binding(nameof(tbl_track.dislikes))
});
foreach (var track in db.tbl_track)
{
grid.Items.Add(track);
// Cache some of the data we need
track.tbl_format.ToString();
foreach (var v in track.tbl_moodmap)
{
v.ToString();
v.tbl_mood.ToString();
}
foreach (var v in track.tbl_genremap)
{
v.ToString();
v.tbl_genre.ToString();
}
}
}
}
/// <summary>
/// Playing from ListBox
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/*public void PlayFromContext(object sender, RoutedEventArgs e)
* {
* timer.Stop();
* RadioPlayer.Play(StationsStorage.urlRadios[RadioList.SelectedIndex].url, 50);
* SetNameRadio(StationsStorage.urlRadios[RadioList.SelectedIndex].name);
* TextBlockPlaying.Opacity = 1;
* timer.Start();
* }*/
public void PlayComm(object sender, RoutedEventArgs e)
{
timer.Stop();
RadioPlayer.Play(StationsStorage.urlRadios[needUrlIndex].url, 50);
SetNameRadio(StationsStorage.urlRadios[needUrlIndex].name);
TextBlockPlaying.Opacity = 1;
timer.Start();
SelectedName.Text = "";
RadioPlayer.GetTagsFromCurrentURLStream(RadioPlayer.Stream);
TextBlockTagTrack.Text = RadioPlayer.tag;
}
internal void StartRadioPlayer(string url)
{
this.url = url;
if (radioPlayer == null)
{
radioPlayer = new RadioPlayer(url);
}
else
{
radioPlayer.ChangeUrl(url);
}
}
public static RadioPlayer Create()
{
if (rp == null)
{
lock (rp)//if it is null we can lock the variable
{
rp = new RadioPlayer();
}
{
return(rp);
}
}
}
public void deleteItem(object item)
{
if (item == null)
{
return;
}
tbl_playlist_header playlist = item as tbl_playlist_header;
if (playlist == null)
{
return;
}
using (var db = new RadioPlayer())
{
db.tbl_playlist_header.Remove(db.tbl_playlist_header.Where(p => p.playlist_header_id == playlist.playlist_header_id).First());
db.SaveChanges();
}
}
public void deleteItem(object item)
{
if (item == null)
{
return;
}
tbl_mood mood = item as tbl_mood;
if (mood == null)
{
return;
}
using (var db = new RadioPlayer())
{
db.tbl_mood.Remove(db.tbl_mood.Where(m => m.mood_id == mood.mood_id).First());
db.SaveChanges();
}
}
public void deleteItem(object item)
{
if (item == null)
{
return;
}
tbl_genre genre = item as tbl_genre;
if (genre == null)
{
return;
}
using (var db = new RadioPlayer())
{
db.tbl_genre.Remove(db.tbl_genre.Where(g => g.genre_id == genre.genre_id).First());
db.SaveChanges();
}
}
public void deleteItem(object item)
{
if (item == null)
{
return;
}
tbl_format format = item as tbl_format;
if (format == null)
{
return;
}
using (var db = new RadioPlayer())
{
db.tbl_format.Remove(db.tbl_format.Where(f => f.format_id == format.format_id).First());
db.SaveChanges();
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new RadioPlayer())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(tbl_genre.genre_id))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "Description",
Binding = new Binding(nameof(tbl_genre.description))
});
foreach (var genre in db.tbl_genre)
{
grid.Items.Add(genre);
}
}
}
public void saveChanges()
{
using (var db = new RadioPlayer())
{
tbl_track track = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.txtID.Text);
track = db.tbl_track.Where(t => t.track_id == id).FirstOrDefault();
if (track == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.txtID.Text}' does not exist.";
return;
}
}
else
{
track = new tbl_track();
}
track.title = this.txtTitle.Text;
track.subtitle = this.txtSubtitle.Text;
track.bitrate = this.txtBitrate.Text;
track.publisher = this.txtPublisher.Text;
track.parental_advisory = (bool)this.checkboxPAL.IsChecked;
track.folder_path = this.txtFolder.Text;
track.file_name = this.txtFileName.Text;
track.duration = Convert.ToInt32(this.txtDuration.Text);
track.format_id = ((tbl_format)this.selectorFormat.item).format_id;
track.filesize = Convert.ToInt64(this.txtFileSize.Text);
track.date_recorded = this.dateRecorded.SelectedDate;
track.date_released = this.dateReleased.SelectedDate;
track.likes = Convert.ToInt32(this.txtLikes.Text);
track.dislikes = Convert.ToInt32(this.txtDislikes.Text);
track.artists = this.stringifyList(this.listArtists);
track.composers = this.stringifyList(this.listComposers);
track.keywords = this.stringifyList(this.listKeywords);
// Sort out the genre mappings.
List <tbl_genremap> genresToUnmap;
List <tbl_genre> genresToMap;
IEditorHelper.getMappings <tbl_genremap, tbl_genre>(
out genresToUnmap, out genresToMap, this.listGenres.items.Select(i => i as tbl_genre),
track.tbl_genremap, (map, value) => map.genre_id == value.genre_id
);
foreach (var toUnmap in genresToUnmap)
{
db.tbl_genremap.Remove(toUnmap);
}
foreach (var toMap in genresToMap)
{
tbl_genremap map = new tbl_genremap();
map.tbl_track = track;
map.tbl_genre = toMap;
db.tbl_genremap.Add(map);
}
// Sort out the mood mappings.
List <tbl_moodmap> moodsToUnmap;
List <tbl_mood> moodsToMap;
IEditorHelper.getMappings <tbl_moodmap, tbl_mood>(
out moodsToUnmap, out moodsToMap, this.listMoods.items.Select(i => i as tbl_mood),
track.tbl_moodmap, (map, value) => map.mood_id == value.mood_id
);
foreach (var toUnmap in moodsToUnmap)
{
db.tbl_moodmap.Remove(toUnmap);
}
foreach (var toMap in moodsToMap)
{
tbl_moodmap map = new tbl_moodmap();
map.tbl_track = track;
map.tbl_mood = toMap;
db.tbl_moodmap.Add(map);
}
if (this._isCreateMode)
{
db.tbl_track.Add(track);
}
db.SaveChanges();
}
}
public void saveChanges()
{
using (var db = new RadioPlayer())
{
var track = new tbl_track();
track.title = _tag.Title;
track.subtitle = "N/A";
track.artists = String.Join(",", _tag.AlbumArtists);
track.composers = String.Join(",", _tag.Composers);
track.bitrate = Convert.ToString(_format.AverageBytesPerSecond * 8);
track.publisher = "N/A";
track.parental_advisory = false;
track.folder_path = Path.GetDirectoryName(_fileName).Replace(Config.PathToRoot, "").Replace(Config.ServerName, "").TrimStart('\\', '/');
track.file_name = Path.GetFileName(_fileName);
track.duration = _totalSeconds;
track.tbl_format = db.tbl_format.First(f => f.description == _extension);
track.date_recorded = null;
track.date_released = null;
track.likes = 0;
track.dislikes = 0;
track.keywords = "N/A";
var lengthStream = System.IO.File.Open(_fileName, FileMode.Open);
track.filesize = lengthStream.Length;
lengthStream.Dispose();
if (db.tbl_track.Any(t => t.title == track.title))
{
var result = MessageBox.Show(
$"A track called '{track.title}' already exists, are you sure you want to" +
$" continue with adding this track?",
"Confirmation",
MessageBoxButton.YesNo,
MessageBoxImage.Question
);
if (result == MessageBoxResult.No)
{
return;
}
}
db.tbl_track.Add(track);
// Auto-add it to a collection.
var collection = db.tbl_collection.FirstOrDefault(c => c.title.ToLower() == _tag.Album.ToLower());
if (collection == null && !String.IsNullOrWhiteSpace(_tag.Album))
{
var result = MessageBox.Show(
$"There is no collection called '{_tag.Album}', would you " +
$"like to create one for this track?",
"Confirmation",
MessageBoxButton.YesNo,
MessageBoxImage.Question
);
if (result == MessageBoxResult.Yes)
{
collection = new tbl_collection();
collection.title = _tag.Album;
db.tbl_collection.Add(collection);
}
}
if (collection != null)
{
var map = new tbl_collectionmap();
map.tbl_collection = collection;
map.tbl_track = track;
map.sequence_index = 999;
db.tbl_collectionmap.Add(map);
}
db.SaveChanges();
}
}
private void UpdateTimer_Tick(object sender, EventArgs e)
{
PosOfMusic.Text = TimeSpan.FromSeconds(RadioPlayer.GetPosOfStream(RadioPlayer.Stream)).ToString();
m_Slider.Value = RadioPlayer.GetPosOfStream(RadioPlayer.Stream);
//RadioPlayer.SetPosOfScroll(RadioPlayer.Stream, Convert.ToInt32(m_Slider.Value));
}
public void ClickOk(object sender, RoutedEventArgs e)
{
RadioPlayer.Play(RadioUrl.Text, 50);
this.Close();
}
private void M_Volume_OnValueChanged(object sender, RoutedPropertyChangedEventArgs <double> e)
{
int vol = Convert.ToInt32(m_Volume.Value * 10);
RadioPlayer.SetVolumeToStream(RadioPlayer.Stream, vol);
}
private void PlayerStop(object sender, RoutedEventArgs e)
{
RadioPlayer.Stop();
}
public static void Play()
{
var rp = new RadioPlayer();
}
public void saveChanges()
{
using (var db = new RadioPlayer())
{
tbl_playlist_header playlist = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.txtID.Text);
playlist = db.tbl_playlist_header.Where(p => p.playlist_header_id == id).FirstOrDefault();
if (playlist == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.txtID.Text}' does not exist.";
return;
}
}
else
{
playlist = new tbl_playlist_header();
}
playlist.description = this.txtDescription.Text;
playlist.likes = Convert.ToInt32(this.txtLikes.Text);
playlist.dislikes = Convert.ToInt32(this.txtDislikes.Text);
playlist.creator = this.txtCreator.Text;
playlist.play_random = (bool)this.checkboxRandomise.IsChecked;
// Any values left in mapList need to be removed.
var mapList = playlist.tbl_playlist_lines.ToList();
var trackList = this.listTracks.items.Select(i => i as tbl_track).ToList();
for (int index = 0; index < trackList.Count(); index++)
{
var track = trackList[index];
var map = mapList.Where(m => m.track_id == track.track_id).FirstOrDefault();
if (map == null)
{
db.tbl_playlist_lines.Add(new tbl_playlist_lines()
{
tbl_playlist_header = playlist,
track_id = track.track_id,
sequence_index = index
});
continue;
}
map.sequence_index = index;
mapList.Remove(map);
}
foreach (var map in mapList)
{
db.tbl_playlist_lines.Remove(map);
}
if (this._isCreateMode)
{
db.tbl_playlist_header.Add(playlist);
}
db.SaveChanges();
}
}
/// <summary>
/// Stopping stream
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void StopRadio(object sender, RoutedEventArgs e)
{
RadioPlayer.Stop();
TextBlockPlaying.Opacity = 0;
}
